X-Git-Url: https://git.heureux-cyclage.org/?p=lhc%2Fweb%2Fspip_carte_de_sites.git;a=blobdiff_plain;f=inclure%2Fliste_gis.html;h=5741d26757063afa47349554116722fb6fa61f8c;hp=7c413677b9cf410051620e58216d475f7a24e09e;hb=d53a8523f3d8f8dbec201b236f8cfbab4b0e5366;hpb=796c5f8984db38fdcc40d22d6ac9652aa53ccb5d

diff --git a/inclure/liste_gis.html b/inclure/liste_gis.html
index 7c41367..5741d26 100644
--- a/inclure/liste_gis.html
+++ b/inclure/liste_gis.html
@@ -1,5 +1,4 @@
-
-#SET{req_gis,#VAL{"SELECT DISTINCT spip_gis.*, spip_syndic.* FROM spip_mots, spip_mots_syndic, spip_syndic, spip_gis, spip_gis_liens WHERE spip_mots.type='Ateliers' AND spip_mots_syndic.id_syndic=spip_syndic.id_syndic AND spip_syndic.id_syndic=spip_gis_liens.id_objet AND spip_gis.id_gis=spip_gis_liens.id_gis AND spip_gis_liens.objet='syndic' AND spip_gis.pays='"}|concat{#ENV{mon_pays}}|concat{"' AND spip_gis.region='"}|concat{#ENV{ma_region}}|concat{"' ORDER BY spip_gis.ville"}}
+#SET{req_gis,#VAL{"SELECT DISTINCT spip_gis.*, spip_syndic.* FROM spip_mots, spip_mots_liens, spip_syndic, spip_gis, spip_gis_liens WHERE spip_mots.type='Ateliers' AND spip_mots_liens.objet='site' AND spip_mots_liens.id_objet=spip_syndic.id_syndic AND spip_syndic.id_syndic=spip_gis_liens.id_objet AND spip_gis.id_gis=spip_gis_liens.id_gis AND spip_gis_liens.objet='site' AND spip_gis.pays='"}|concat{#ENV{mon_pays}}|concat{"' AND spip_gis.region='"}|concat{#ENV{ma_region}}|concat{"' ORDER BY spip_gis.ville"}}
 
 <BOUCLE_sql(DATA){source sql,#GET{req_gis}}>
     <ul class="spip">
@@ -19,7 +18,7 @@
                     |image_recadre{45,45,center}
                     |image_aplatir{jpg,ffffff}
                     |inserer_attribut{class,spip_logos})]
-                    #VILLE (#CODE_POSTAL) - <a href="#URL_SITE"> #TITRE </a> - #ADRESSE
+                    #VILLE (#CODE_POSTAL) - <a href="#VALEUR{url_site}"> #TITRE </a> - #ADRESSE
                 </li>
         </BOUCLE_points>
     </ul>