TOPIC:

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...

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.

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 ?

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...

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

Thank you for sharing.
Your query can be optimized :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

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:or