SELECT * FROM Agenda3 WHERE Id=#URL.Id# ORDER BY date_debut SELECT Titre,Extrait,Description FROM Activites WHERE Id=#output.Source_Id# SELECT Fiches.societe,Fiches.lieu,technique.billetterie,technique.billetterie_info,technique.billetterie_url FROM fiches LEFT JOIN technique ON fiches.repertoire_no = technique.repertoire_no WHERE fiches.repertoire_no=#output.salleid#

CalendrierAgenda


CalendrierAgenda

CalendrierAgenda

Activité :

#output.Titre# #output.Titre# #output.web#http://#output.web#" target="_blank">#output.Titre##output.Titre#

Artiste :

#Replace("#output.artiste#","#chr(13)##chr(10)#","
","ALL")#
#output.artiste_url#http://#output.artiste_url#
" target="_blank">#Replace("#output.artiste#","#chr(13)##chr(10)#","
","ALL")#
#Replace("#output.artiste#","#chr(13)##chr(10)#","
","ALL")#

#Replace("#output.activite#","#chr(13)##chr(10)#","
","ALL")#

#replace("#REReplace("#REReplace("#REReplace("#REReplace("#output.Description#","([[:space:]])http://([^[:space:]]+?)(\.*[[:space:]])","\1\2\3","ALL")#","([[:space:]])([A-Za-z0-9_\.\-]+@[A-Za-z0-9\.\-]+\.[A-Za-z]{2,})(\.*[[:space:]])","\1\2\3","all")#","\[\[([^\]\]]+?)\]\]","\1","ALL")#","#chr(13)##chr(10)#","
#chr(13)##chr(10)#","all")#","
","","all")#

Info :

#replace("#REReplace("#REReplace("#REReplace("#REReplace("#Activites.Description#","([[:space:]])http://([^[:space:]]+?)(\.*[[:space:]])","\1\2\3","ALL")#","([[:space:]])([A-Za-z0-9_\.\-]+@[A-Za-z0-9\.\-]+\.[A-Za-z]{2,})(\.*[[:space:]])","\1\2\3","all")#","\[\[([^\]\]]+?)\]\]","\1","ALL")#","#chr(13)##chr(10)#","
#chr(13)##chr(10)#","all")#","
","","all")#

Première partie :

#Replace("#output.artiste1#","#chr(13)##chr(10)#","
","ALL")#
#output.artiste1_url#http://#output.artiste1_url#
" target="_blank">#Replace("#output.artiste1#","#chr(13)##chr(10)#","
","ALL")#
#Replace("#output.artiste1#","#chr(13)##chr(10)#","
","ALL")#

#Replace("#output.activite1#","#chr(13)##chr(10)#","
","ALL")#

#replace("#REReplace("#REReplace("#REReplace("#REReplace("#output.description1#","([[:space:]])http://([^[:space:]]+?)(\.*[[:space:]])","\1\2\3","ALL")#","([[:space:]])([A-Za-z0-9_\.\-]+@[A-Za-z0-9\.\-]+\.[A-Za-z]{2,})(\.*[[:space:]])","\1\2\3","all")#","\[\[([^\]\]]+?)\]\]","\1","ALL")#","#chr(13)##chr(10)#","
#chr(13)##chr(10)#","all")#","
","","all")#

Deuxième partie :

#Replace("#output.artiste2#","#chr(13)##chr(10)#","
","ALL")#
#output.artiste2_url#http://#output.artiste2_url#
" target="_blank">#Replace("#output.artiste2#","#chr(13)##chr(10)#","
","ALL")#
#Replace("#output.artiste2#","#chr(13)##chr(10)#","
","ALL")#

#Replace("#output.activite2#","#chr(13)##chr(10)#","
","ALL")#

#replace("#REReplace("#REReplace("#REReplace("#REReplace("#output.description2#","([[:space:]])http://([^[:space:]]+?)(\.*[[:space:]])","\1\2\3","ALL")#","([[:space:]])([A-Za-z0-9_\.\-]+@[A-Za-z0-9\.\-]+\.[A-Za-z]{2,})(\.*[[:space:]])","\1\2\3","all")#","\[\[([^\]\]]+?)\]\]","\1","ALL")#","#chr(13)##chr(10)#","
#chr(13)##chr(10)#","all")#","
","","all")#

Quand :

#DateFormat("#output.date_debut#","d")# #lsDateFormat("#output.date_debut#","mmmm")# #DateFormat("#output.date_debut#","yyyy")# - #DateFormat("#output.date_fin#","d")# #lsDateFormat("#output.date_fin#","mmmm")# #DateFormat("#output.date_fin#","yyyy")#

Heures :

#TimeFormat(Heure_debut, "H")#h#TimeFormat(Heure_debut, "mm")# - #TimeFormat(Heure_fin, "H")#h#TimeFormat(Heure_fin, "mm")#

Heure :

#TimeFormat(Heure_debut, "H")#h#TimeFormat(Heure_debut, "mm")#

Horaire :

#Replace("#output.horaire#","#chr(13)##chr(10)#","
","ALL")#

Saison :

#Replace("#output.periode#","#chr(13)##chr(10)#","
","ALL")#

Où :

#salle.societe#

Indication routière :

#replace("#REReplace("#REReplace("#REReplace("#REReplace("#output.Lieu#","([[:space:]])http://([^[:space:]]+?)(\.*[[:space:]])","\1\2\3","ALL")#","([[:space:]])([A-Za-z0-9_\.\-]+@[A-Za-z0-9\.\-]+\.[A-Za-z]{2,})(\.*[[:space:]])","\1\2\3","all")#","\[\[([^\]\]]+?)\]\]","\1","ALL")#","#chr(13)##chr(10)#","
#chr(13)##chr(10)#","all")#","
","","all")#

Indication routière :

#replace("#REReplace("#REReplace("#REReplace("#REReplace("#salle.lieu#","([[:space:]])http://([^[:space:]]+?)(\.*[[:space:]])","\1\2\3","ALL")#","([[:space:]])([A-Za-z0-9_\.\-]+@[A-Za-z0-9\.\-]+\.[A-Za-z]{2,})(\.*[[:space:]])","\1\2\3","all")#","\[\[([^\]\]]+?)\]\]","\1","ALL")#","#chr(13)##chr(10)#","
#chr(13)##chr(10)#","all")#","
","","all")#

Où :

#replace("#REReplace("#REReplace("#REReplace("#REReplace("#output.Lieu#","([[:space:]])http://([^[:space:]]+?)(\.*[[:space:]])","\1\2\3","ALL")#","([[:space:]])([A-Za-z0-9_\.\-]+@[A-Za-z0-9\.\-]+\.[A-Za-z]{2,})(\.*[[:space:]])","\1\2\3","all")#","\[\[([^\]\]]+?)\]\]","\1","ALL")#","#chr(13)##chr(10)#","
#chr(13)##chr(10)#","all")#","
","","all")#

Ville :

#output.Ville#

Coût des billets :

#replace("#REReplace("#REReplace("#REReplace("#REReplace("#output.cout#","([[:space:]])http://([^[:space:]]+?)(\.*[[:space:]])","\1\2\3","ALL")#","([[:space:]])([A-Za-z0-9_\.\-]+@[A-Za-z0-9\.\-]+\.[A-Za-z]{2,})(\.*[[:space:]])","\1\2\3","all")#","\[\[([^\]\]]+?)\]\]","\1","ALL")#","#chr(13)##chr(10)#","
#chr(13)##chr(10)#","all")#","
","","all")#

Billetterie :

#replace("#REReplace("#REReplace("#REReplace("#REReplace("#output.Information#","([[:space:]])http://([^[:space:]]+?)(\.*[[:space:]])","\1\2\3","ALL")#","([[:space:]])([A-Za-z0-9_\.\-]+@[A-Za-z0-9\.\-]+\.[A-Za-z]{2,})(\.*[[:space:]])","\1\2\3","all")#","\[\[([^\]\]]+?)\]\]","\1","ALL")#","#chr(13)##chr(10)#","
#chr(13)##chr(10)#","all")#","
","","all")#

Billetterie :

#replace("#REReplace("#REReplace("#REReplace("#REReplace("#salle.billetterie_info#","([[:space:]])http://([^[:space:]]+?)(\.*[[:space:]])","\1\2\3","ALL")#","([[:space:]])([A-Za-z0-9_\.\-]+@[A-Za-z0-9\.\-]+\.[A-Za-z]{2,})(\.*[[:space:]])","\1\2\3","all")#","\[\[([^\]\]]+?)\]\]","\1","ALL")#","#chr(13)##chr(10)#","
#chr(13)##chr(10)#","all")#","
","","all")#

Achat :

#billetterie_url#http://#billetterie_url#" title="Achat de billet en ligne" target="_blank">Achat de billets en ligne

Achat :

#salle.billetterie_url#http://#billetterie_url#" title="Achat de billet en ligne" target="_blank">Achat de billets en ligne

DiffuseurPrésentateur :

">#output.Presentateur# [#output.Web_presentateur#http://#output.Web_presentateur#" target="_top">Info] #output.Presentateur#

Crédits :

#Replace("#output.credits#","#chr(13)##chr(10)#","
","ALL")#

Commentaires :

#Replace("#output.commentaires#","#chr(13)##chr(10)#","
","ALL")#

Événement :

#evenement_url#http://#evenement_url#" title="Achat de billet en ligne" target="_blank">#output.evenement# #output.evenement#


Réseau Ontario

<< Retour

UPDATE agenda3 SET clic = Clic + 1 WHERE Id=#URL.Id#