Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1
  • 2

TOPIC:

OpenStreet Maps for all Events 3 years 7 months ago #24019

  • AlainR
  • AlainR's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 20
  • Thank you received: 5

AlainR wrote: Perhaps I should add a verification not to take venues when long. or lat. are with 0.000000 completed...

Arf! I did it, so it's another problem. Perhaps, you've to put some echo or print_r in my script to debug... Good luck!

jojo12 wrote: In addition how to set markers, if there is not yet added an event to the defined venue ?

Sorry, because of my poor english, I don't understand your question...

Please Log in or Create an account to join the conversation.

Last edit: by AlainR.

OpenStreet Maps for all Events 3 years 7 months ago #24021

jojo12 wrote:
In addition how to set markers, if there is not yet added an event to the defined venue ?
Sorry, because of my poor english, I don't understand your question...

Pardon: Pour un certain site je collecte tout les endroits qui vont accueillir des hôtes. Et j'utilise une variation de myvenues qui montre tous les endroits (même s'ils ne sont pas (encore) connecté avec un évènement).
Il me semble qu'avec ton script ce ne sont montrés que les endroits connectés avec un évènement.
on JEM 2.3.0 stable in latest Joomla (3.9.22) Protostar php7.4.5

Please Log in or Create an account to join the conversation.

OpenStreet Maps for all Events 3 years 7 months ago #24023

  • AlainR
  • AlainR's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 20
  • Thank you received: 5
OK, so you have to simplify the request (lignes 15-17) to only search the venues.
I saw your website and understand now why you publsh the venue's name and not the event's name. Did you lost the latitude<>0 AND longitude<>0 condition ?

Please Log in or Create an account to join the conversation.

Last edit: by AlainR.

OpenStreet Maps for all Events 3 years 7 months ago #24025

:woohoo: I got it
I changed the file and now I have all venues (even those who have not yet an event!
I attach my changes

thanks a lot, and we will try more...

:woohoo: J'ai réussi!
J'ai changé un peu et je vois maintenant tous les lieux (même ceux qui ne sont pas encore lié à un évènement!
Merci merci beaucoup. C'est très joli!
J'attache ma version
on JEM 2.3.0 stable in latest Joomla (3.9.22) Protostar php7.4.5
Attachments:

Please Log in or Create an account to join the conversation.

OpenStreet Maps for all Events 3 years 7 months ago #24026

  • AlainR
  • AlainR's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 20
  • Thank you received: 5
Thank you for sharing.
Your query can be optimized :
SELECT DISTINCT venue,latitude,longitude FROM `".$prefix."jem_venues`
WHERE latitude<>0 AND longitude<>0
because you don't need to select in a table in which you don't need any field...

And you should add a condition to test if venue is active or not B)
The following user(s) said Thank You: jojo12

Please Log in or Create an account to join the conversation.

Last edit: by AlainR. Reason: add a condition to test if venue is active or not B)

OpenStreet Maps for all Events 3 years 7 months ago #24027

  • AlainR
  • AlainR's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 20
  • Thank you received: 5
Hi.
I updated the file (in post #24006 ) included your fork, jojo12.
It is now possible to add the ID of the module to be modified on the fly and to choose to display all locations only, regardless of events:
Eg:
writeOsModul.php?id=130
or
writeOsModul.php?id=130&venue=only
The following user(s) said Thank You: jojo12

Please Log in or Create an account to join the conversation.

Last edit: by AlainR.
  • Page:
  • 1
  • 2
Time to create page: 0.394 seconds

Donate

If you find JEM useful and if you use it on your site, please consider a donation to the project.

Private Messages

You are not logged in.

Follow us......