MODE DEBUG
PageManagerPublic::__construct
PageBuilderPublic::__construct
Page::__construct
PageManagerPublic::displayPage
SELECT id_page FROM ga_page WHERE page_url="agenda"
SELECT COUNT(1) count FROM ga_page WHERE page_url="agenda" AND page_link="0"
SELECT id_page FROM ga_page WHERE page_link="69" AND page_url="prun-electro-allstars"
Page::getPageDynamic
Page::getModels
SELECT model_name FROM ga_model WHERE model_type="page"
SELECT id_utilisateur, page_name, page_title, page_description, page_keywords FROM ma_utilisateur WHERE page_url="prun-electro-allstars"
SELECT id_stage, page_name, page_title, page_description, page_keywords FROM ma_stage WHERE page_url="prun-electro-allstars"
SELECT id_programme, page_name, page_title, page_description, page_keywords FROM ma_programme WHERE page_url="prun-electro-allstars"
SELECT id_emission, page_name, page_title, page_description, page_keywords FROM ma_emission WHERE page_url="prun-electro-allstars"
SELECT id_article, page_name, page_title, page_description, page_keywords FROM ma_article WHERE page_url="prun-electro-allstars"
SELECT id_evenement, page_name, page_title, page_description, page_keywords FROM ma_evenement WHERE page_url="prun-electro-allstars"
SELECT id_page,page_link FROM ga_page WHERE page_url="evenement"
SELECT page_url FROM ga_page WHERE id_page="69"
SELECT page_url FROM ga_page WHERE id_page="10"
Page::getPageStatic
SELECT * FROM ga_page WHERE page_url="evenement" AND page_type="1"
Page::getCssPage
SELECT ga_file.file_name FROM ga_file, ga_file_page WHERE ga_file.id_file=ga_file_page.id_file AND ga_file_page.id_page="10" AND file_extension="css" ORDER BY ga_file_page.id_file_page
Page::getJsPage
SELECT ga_file.file_name FROM ga_file, ga_file_page WHERE ga_file.id_file=ga_file_page.id_file AND ga_file_page.id_page="10" AND file_extension="js" ORDER BY ga_file_page.id_file_page
Page::getRSSPage
SELECT rss_url,rss_description FROM ga_rss,ga_page_rss WHERE ga_page_rss.id_page='10' AND ga_page_rss.id_rss=ga_rss.id_rss ORDER BY ga_rss.id_rss
Site::getConfig
SELECT * FROM ga_config
PageBuilderPublic::buildPage
dataflow::__construct
dataflow::getDataflowQueries
Récupération des requêtes supplémentaires.
SELECT ga_query.id_query, ga_query_asso.query_asso_order, ga_query.query_column, ga_query.query_table, ga_query.query_where, ga_query.query_group, ga_query.query_order, ga_query.query_left, ga_query.query_on, ga_query.query_list, ga_query.query_limit, ga_query.query_type, ga_query.query_log, ga_query.query_output_name, ga_fileprocess.fileprocess_name FROM ( ga_dataflow, ga_query, ga_query_asso) LEFT JOIN ga_fileprocess ON ga_dataflow.id_fileprocess=ga_fileprocess.id_fileprocess WHERE ga_dataflow.dataflow_name="evenement" AND ga_dataflow.id_dataflow=ga_query_asso.id_dataflow AND ga_query.id_query=ga_query_asso.id_query ORDER BY ga_query_asso.query_asso_order, ga_query.query_list
SELECT ma_evenement.id_evenement, ma_evenement.page_name, ma_evenement.page_url, ma_evenement.page_title, ma_evenement.page_description, ma_evenement.page_keywords, ma_evenement.evenement_nom, ma_evenement.evenement_type, ma_evenement.evenement_id_facebook, ma_evenement.evenement_debut, ma_evenement.id_lieu, ma_evenement.evenement_prix, ma_evenement.evenement_entete, ma_evenement.evenement_description, ma_evenement.id_organisateur, ma_evenement.evenement_fin, ma_evenement.evenement_etat, ma_evenement.id_utilisateur, ma_evenement.id_evenement_categorie, ma_utilisateur.utilisateur_nom_complet, ma_media.id_media, ma_media.media_name, ma_media.media_description, ma_lieu.page_url lieu_url, ma_lieu.lieu_nom, ma_lieu.lieu_adresse, ma_lieu.lieu_code_postal, ma_lieu.lieu_ville, ma_lieu.lieu_latitude, ma_lieu.lieu_longitude, ma_lieu.lieu_adresse_num, ma_lieu.lieu_adresse_type, ma_lieu.lieu_adresse_bis, ma_organisateur.organisateur_nom, ma_organisateur.organisateur_site, ma_organisateur.organisateur_twitter, ma_organisateur.organisateur_telephone, ma_organisateur.organisateur_entete, ma_organisateur.organisateur_description FROM ( ma_evenement) LEFT JOIN ma_utilisateur ON ma_utilisateur.id_utilisateur=ma_evenement.id_utilisateur LEFT JOIN ma_media ON ma_media.id_evenement=ma_evenement.id_evenement LEFT JOIN ma_lieu ON ma_lieu.id_lieu=ma_evenement.id_lieu LEFT JOIN ma_organisateur ON ma_organisateur.id_organisateur=ma_evenement.id_organisateur WHERE ma_evenement.page_url="prun-electro-allstars"
SELECT ma_playlist.playlist_datetime, ma_titre.titre_artiste, ma_titre.titre_nom FROM ( ma_playlist) LEFT JOIN ma_titre ON ma_titre.id_titre=ma_playlist.id_titre ORDER BY ma_playlist.playlist_datetime DESC LIMIT 1
SELECT ma_tag.id_tag, ma_tag.tag_name FROM ( ma_evenement) LEFT JOIN ma_tag ON ma_tag.id_evenement=ma_evenement.id_evenement WHERE page_url="prun-electro-allstars"
SELECT ma_evenement.page_url, ma_evenement.evenement_nom, ma_evenement.evenement_type, ma_evenement.evenement_debut, ma_evenement.evenement_entete, ma_evenement.evenement_etat, ma_media.media_name FROM ( ma_evenement) LEFT JOIN ma_media ON ma_media.id_evenement=ma_evenement.id_evenement WHERE ma_evenement.evenement_debut>=NOW() AND ma_evenement.evenement_etat='2' ORDER BY ma_evenement.evenement_debut ASC LIMIT 5
SELECT ma_emission.page_url, ma_emission.emission_datetime, ma_emission.emission_entete, ma_programme.programme_nom, programme_entete, ma_media.media_name FROM ( ma_emission) LEFT JOIN ma_programme ON ma_programme.id_programme=ma_emission.id_programme LEFT JOIN ma_media ON ma_media.id_programme=ma_emission.id_programme WHERE ma_emission.emission_datetime>=CURDATE() AND ma_emission.emission_datetime<=CURDATE()+1 ORDER BY ma_emission.emission_datetime ASC
Données envoyés au template :
Array
(
[id_evenement] => 64
[page_name] => Prun' Electro Allstars
[page_url] => prun-electro-allstars
[page_title] => Prun' Electro Allstars
[page_description] => Mix électro avec les meilleurs DJs de la radio !
[page_keywords] =>
[evenement_nom] => Prun' Electro Allstars
[evenement_type] => 0
[evenement_id_facebook] =>
[evenement_debut] => 2012-11-09 22:00:00
[id_lieu] => 34
[evenement_prix] => Gratuit
[evenement_entete] => Mix électro avec les meilleurs DJs de la radio !
[evenement_description] =>
Le vendredi 9 novembre, retrouve la crème des DJs et des animateurs électro de la radio !
Electro, techno, house, dubstep, drum’n’bass…
La Prun' Electro Allstars débarque à la Scène Michelet pour 5 heures de mix non stop !
Avec les membres d'Orbeat, OK Dude, UK Flava, Amnezic, Dextropropoxyfeensmaak, Ground Control, Le Cocktail Electro, Electric Chicken, Doudoune Musta, Cosmic Show...
Plus d'infos sur le 92FM.
[id_organisateur] => 24
[evenement_fin] => 2012-11-10 03:00:00
[evenement_etat] => 2
[id_utilisateur] => 13
[id_evenement_categorie] => 1
[utilisateur_nom_complet] => Communication Prun
[id_media] => 540
[media_name] => 2012-10-31-dd362139d853da69b62d18ea2cf74616.jpg
[media_description] => Prun' Electro Allstars 9 novembre 2012
[lieu_url] => scene-michelet
[lieu_nom] => Scène Michelet
[lieu_adresse] => Henry Orrion
[lieu_code_postal] => 44000
[lieu_ville] => Nantes
[lieu_latitude] => 47.2329
[lieu_longitude] => -1.55681
[lieu_adresse_num] => 1
[lieu_adresse_type] => Boulevard
[lieu_adresse_bis] =>
[organisateur_nom] => Prun'
[organisateur_site] => http://www.prun.net
[organisateur_twitter] =>
[organisateur_telephone] => 0240120906
[organisateur_entete] =>
[organisateur_description] =>
[playlist] => Array
(
[0] => Array
(
[playlist_datetime] => 2013-05-23 23:00:47
[titre_artiste] => Disco Anti Napoleon
[titre_nom] => Blue Lawn
)
)
[tags_liste] => Array
(
[0] => Array
(
[id_tag] => 18948
[tag_name] => electro
)
[1] => Array
(
[id_tag] => 18949
[tag_name] => techno
)
[2] => Array
(
[id_tag] => 18950
[tag_name] => house
)
[3] => Array
(
[id_tag] => 18951
[tag_name] => dubstep
)
[4] => Array
(
[id_tag] => 18952
[tag_name] => drum'n'bass
)
)
[evenements_liste] => Array
(
[0] => Array
(
[page_url] => les-3-elephants-24-05-2013
[evenement_nom] => Les 3 Eléphants
[evenement_type] => partenaire
[evenement_debut] => 2013-05-24 19:00:00
[evenement_entete] => Festival - Concerts et arts de rue
[evenement_etat] => 2
[media_name] => 2013-04-30-8e2be6c7b8ad4de684f64027a23c3c43.jpg
)
[1] => Array
(
[page_url] => la-zikabilo-dj-click-24-05-2013
[evenement_nom] => La Zikabilo + DJ Click
[evenement_type] => partenaire
[evenement_debut] => 2013-05-24 20:30:00
[evenement_entete] => Concert - Cubano-Rock-Tzigane
[evenement_etat] => 2
[media_name] => 2013-05-13-645ae729fa78f2f19e304375db6c8002.jpg
)
[2] => Array
(
[page_url] => etienne-de-crecy-alphaat-24-05-2013
[evenement_nom] => Etienne de Crécy + Alphaat
[evenement_type] => partenaire
[evenement_debut] => 2013-05-24 22:00:00
[evenement_entete] => Concert - Electro / Techno
[evenement_etat] => 2
[media_name] => 2013-05-13-820e2112fe58ab53f869d75aa41b0107.jpg
)
[3] => Array
(
[page_url] => dtwice-aymeric-maini-25-05-2013
[evenement_nom] => Dtwice + Aymeric Maïni
[evenement_type] => partenaire
[evenement_debut] => 2013-05-25 20:30:00
[evenement_entete] => Concert - Electro / Pop
[evenement_etat] => 2
[media_name] => 2013-05-13-9b93bd09c9d6188140d1f8e4a08ff333.jpg
)
[4] => Array
(
[page_url] => stakhanoizz-25-05-2013
[evenement_nom] => Stakhanoizz
[evenement_type] => partenaire
[evenement_debut] => 2013-05-25 21:00:00
[evenement_entete] => Concert - Rock indé / frivole jazz
[evenement_etat] => 2
[media_name] => 2013-05-13-d9ca694d01b8bfc78ab91e8c04ba1b50.jpg
)
)
[prochaine_emission_liste] => Array
(
[0] => Array
(
[page_url] => evan-dream-on-the-mix-23-05-2013
[emission_datetime] => 2013-05-23 00:00:00
[emission_entete] =>
[programme_nom] => Evan Dream On the Mix
[programme_entete] => 2H de Mix autour des musiques électroniques
[media_name] => 2012-09-25-d7fd483399938bb8a372bb07e4a160a4.jpg
)
[1] => Array
(
[page_url] => la-matinale-23052013
[emission_datetime] => 2013-05-23 07:00:00
[emission_entete] =>
[programme_nom] => La Matinale
[programme_entete] => Réveillez-vous avec l'actualité locale, nationale et internationale
[media_name] => 2012-12-17-e774b6059eeabd80af2b2e794bbf3b51.jpg
)
[2] => Array
(
[page_url] => emission-speciale-23052013
[emission_datetime] => 2013-05-23 17:00:00
[emission_entete] => En direct de la Cité des Congrès
[programme_nom] => Emission Spéciale
[programme_entete] => Prun' en direct pour une émission spéciale.
[media_name] => 2012-10-16-31755eeba6d5da8bb0c795d18e2a91a2.jpg
)
[3] => Array
(
[page_url] => my-web-generation-23-05-2013
[emission_datetime] => 2013-05-23 19:00:00
[emission_entete] =>
[programme_nom] => My Web Generation
[programme_entete] => L'émission 2.0 qui vous parle de Web et des nouvelles technologies
[media_name] => 2012-09-17-2b3464f80061078b82b3d14b5477268d.jpg
)
[4] => Array
(
[page_url] => triangle-23-05-2013
[emission_datetime] => 2013-05-23 20:00:00
[emission_entete] =>
[programme_nom] => Triangle
[programme_entete] => Découverte de l'IDM, de l'Electronica et des dérives électroniques
[media_name] => 2012-10-01-a145d06e9be6b1a35a3980b7f7ea571a.jpg
)
[5] => Array
(
[page_url] => orbeat-23-05-2013
[emission_datetime] => 2013-05-23 21:00:00
[emission_entete] =>
[programme_nom] => Orbeat
[programme_entete] => Emission des musiques électroniques qui font remuer les fesses !
[media_name] => 2013-02-28-defabb6331aa0546c025bbc6fc7bb41c.jpg
)
[6] => Array
(
[page_url] => electric-chicken-23-05-2013
[emission_datetime] => 2013-05-23 23:00:00
[emission_entete] =>
[programme_nom] => Electric Chicken
[programme_entete] => Emission qui vous emmène aux frontières des musiques électroniques
[media_name] => 2012-09-19-2cff457fd21bcb519e6e20b09665361e.jpg
)
[7] => Array
(
[page_url] => ground-control-24-05-2013
[emission_datetime] => 2013-05-24 00:00:00
[emission_entete] =>
[programme_nom] => Ground Control
[programme_entete] => Emission de mix dédié à la Bass Music sous toutes ses coutures
[media_name] => 2012-10-08-ac2d53e7e652899bf7d83b5593c05c99.jpg
)
)
)
PageBuilderPublic::headerHTML
PageBuilderPublic::headerTPL
PageBuilderPublic::footerTPL
PageBuilderPublic::footerHTML
SELECT config_value FROM ga_config WHERE config_label="project_debug"
