MODE DEBUG
PageManagerPublic::__construct
PageBuilderPublic::__construct
Page::__construct
PageManagerPublic::displayPage
SELECT id_page FROM ga_page WHERE page_url="emissions"
SELECT COUNT(1) count FROM ga_page WHERE page_url="emissions" AND page_link="0"
SELECT id_page FROM ga_page WHERE page_link="70" AND page_url="gimme-some-more-24-10-2012"
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="gimme-some-more-24-10-2012"
SELECT id_stage, page_name, page_title, page_description, page_keywords FROM ma_stage WHERE page_url="gimme-some-more-24-10-2012"
SELECT id_programme, page_name, page_title, page_description, page_keywords FROM ma_programme WHERE page_url="gimme-some-more-24-10-2012"
SELECT id_emission, page_name, page_title, page_description, page_keywords FROM ma_emission WHERE page_url="gimme-some-more-24-10-2012"
SELECT id_page,page_link FROM ga_page WHERE page_url="emission"
SELECT page_url FROM ga_page WHERE id_page="70"
SELECT page_url FROM ga_page WHERE id_page="8"
Page::getPageStatic
SELECT * FROM ga_page WHERE page_url="emission" 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="8" 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="8" 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='8' 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="emission" 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_emission.id_emission, ma_emission.page_name, ma_emission.page_url, ma_emission.page_title, ma_emission.page_description, ma_emission.page_keywords, ma_emission.emission_datetime, ma_emission.emission_datetime_fin, ma_emission.emission_duree, ma_emission.emission_sujet, ma_emission.emission_entete, ma_emission.emission_description, ma_emission.emission_audio, ma_emission.id_playlist_emission, ma_programme.programme_nom, ma_programme.programme_description, ma_media.media_name, ma_media.media_description, ma_programme.page_url media_repertoire, ma_programme.id_programme 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.page_url="gimme-some-more-24-10-2012"
SELECT ma_media.media_name emission_media_name, ma_media.media_description emission_media_description FROM ( ma_emission) LEFT JOIN ma_media ON ma_media.id_emission=ma_emission.id_emission WHERE page_url="gimme-some-more-24-10-2012" AND media_type='une'
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_tag.tag_name FROM ( ma_emission) LEFT JOIN ma_tag ON ma_tag.id_programme=ma_emission.id_programme WHERE ma_emission.page_url="gimme-some-more-24-10-2012"
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
SELECT ma_media.media_name, ma_media.media_description FROM ( ma_emission) LEFT JOIN ma_media ON ma_media.id_emission=ma_emission.id_emission WHERE page_url="gimme-some-more-24-10-2012" AND ma_media.media_type='son'
SELECT ma_commentaire.id_commentaire, ma_commentaire.commentaire_name, ma_commentaire.commentaire_contenu, ma_commentaire.commentaire_date, ma_commentaire.commentaire_auteur, ma_commentaire.id_article, ma_commentaire.id_emission, ma_commentaire.commentaire_email FROM ( ma_commentaire) LEFT JOIN ma_emission ON ma_commentaire.id_emission=ma_emission.id_emission WHERE ma_emission.page_url="gimme-some-more-24-10-2012" AND ma_commentaire.commentaire_status=1 ORDER BY ma_commentaire.commentaire_date ASC
Appel d'un fichier de post-traitement : /action/process/dataflow/emissions_programme.php
SELECT ma_emission.emission_datetime,ma_emission.page_url,ma_emission.emission_sujet
FROM ma_emission
WHERE id_programme='12' AND
emission_datetime<=CURRENT_DATE()
ORDER BY emission_datetime DESC
SELECT ma_emission.emission_datetime,ma_emission.emission_sujet,page_url
FROM ma_emission
WHERE id_programme='12' AND
emission_datetime>=NOW()
ORDER BY emission_datetime ASC
LIMIT 1
SELECT ma_emission.emission_datetime,ma_emission.emission_sujet,page_url
FROM ma_emission
WHERE id_programme='12' AND
emission_datetime<'2012-10-24 21:00:00'
ORDER BY emission_datetime DESC
LIMIT 1
SELECT ma_emission.emission_datetime,ma_emission.emission_sujet,page_url
FROM ma_emission
WHERE id_programme='12' AND
emission_datetime>'2012-10-24 21:00:00'
ORDER BY emission_datetime ASC
LIMIT 1
SELECT id_em_titre, em_titre_name, em_titre_artiste,
id_emission, em_titre_label, em_titre_annee,
em_titre_album, em_titre_site, em_titre_facebook,
em_titre_twitter, em_titre_bandcamp, em_titre_myspace,
em_titre_soundcloud, em_titre_mixcloud, em_titre_ra,
em_titre_youtube, em_titre_vimeo, em_titre_discogs,
em_titre_cover
FROM ma_em_titre
WHERE id_emission='476'
Données envoyés au template :
Array
(
[id_emission] => 476
[page_name] => Gimme Some More - 24/10/2012
[page_url] => gimme-some-more-24-10-2012
[page_title] => Gimme Some More - 24/10/2012
[page_description] =>
[page_keywords] =>
[emission_datetime] => 2012-10-24 21:00:00
[emission_datetime_fin] => 2012-10-24 21:59:00
[emission_duree] => 59
[emission_sujet] => Saison 6 - Emission 5 | Holy Grail, Charles Walker & The Dynamites, UK 90's Hip Hop, boogie....
[emission_entete] =>
[emission_description] =>
The Bobby Hamilton Quintet Unlimited - Dream Queen
The Blackbyrds - Do it fluid
Gene Ammons - Jug eyes
Gutter Snypes - The trials of life
Gutter Snypes - Who Fell
Southside Movement - Save the world
Charles Walker & The Dynamites - Slinky
Jimmy Jackson - Footsteps (In the shadows)
[emission_audio] =>
[id_playlist_emission] => 0
[programme_nom] => Gimme Some More
[programme_description] =>
Après pratiquement 10 ans de radio, Dj Bassline et Dj Nutz reprennent les rênes de l’émission soulfunkafrolatinohiphoprock.... and more !
Chaque semaine, une sélection musicale vinylistique de vieilleries, de news dénichées ici et là !
Des infos, des anecdotes, des références.. et surtout de la musique !
Que tu aimes le rock psyché, la northern soul, le hip-hop des 90’s, la musique latino boogaloo..... retrouve toutes les semaines la chaleur et les crépitements des vinyles de Dj bassline et Dj Nutz de 21H à 22H sur le 92FM et le
www.prun.netRetrouvez les playlists détaillées, les podcasts funk / hip hop et de nombreux liens vers leurs artistes et labels favoris sur le site de Prun'
[media_name] => 2012-09-26-5293800dec8459ae270380626d067731.jpg
[media_description] =>
[media_repertoire] => gimme-some-more
[id_programme] => 12
[evenements_liste] => Array
(
[0] => Array
(
[page_url] => ozma-raha-22-05-2013
[evenement_nom] => Ozma + Raha
[evenement_type] => partenaire
[evenement_debut] => 2013-05-22 20:30:00
[evenement_entete] => Concert - Jazz
[evenement_etat] => 2
[media_name] => 2013-05-14-75a6e5c1f7dc2d800e8c228ba9768e8f.jpg
)
[1] => Array
(
[page_url] => dillinger-22-05-2013
[evenement_nom] => Dillinger
[evenement_type] => partenaire
[evenement_debut] => 2013-05-22 20:30:00
[evenement_entete] => Film - Braqueurs de banque
[evenement_etat] => 2
[media_name] => 2013-05-13-c801c7683d7efe59efa8373d62149f49.jpg
)
[2] => Array
(
[page_url] => takataka-poesie-22-05-2013
[evenement_nom] => Takataka Poésie
[evenement_type] => partenaire
[evenement_debut] => 2013-05-22 21:00:00
[evenement_entete] => Soirée slam avec Nina Kibuanda
[evenement_etat] => 2
[media_name] => 2013-05-17-24763fdc84b941c3c251fa6a6d41d345.jpg
)
[3] => Array
(
[page_url] => tac-taking-haart-23-05-2013
[evenement_nom] => TAC, Taking Haart
[evenement_type] => partenaire
[evenement_debut] => 2013-05-23 18:30:00
[evenement_entete] => Projection / débat
[evenement_etat] => 2
[media_name] => 2013-05-13-a0580099e27fff995789d451f223e1b5.jpg
)
[4] => Array
(
[page_url] => nautilis-23-05-2013
[evenement_nom] => Nautilis
[evenement_type] => partenaire
[evenement_debut] => 2013-05-23 20:30:00
[evenement_entete] => Concert - Jazz
[evenement_etat] => 2
[media_name] => 2013-05-14-957ac5356248a1d87300ed1800154dbe.jpg
)
)
[tags_liste] => Array
(
[0] => Array
(
[tag_name] => hip hop
)
[1] => Array
(
[tag_name] => funk
)
[2] => Array
(
[tag_name] => soul
)
[3] => Array
(
[tag_name] => rock
)
[4] => Array
(
[tag_name] => afro
)
[5] => Array
(
[tag_name] => latino
)
)
[prochaine_emission_liste] => Array
(
[0] => Array
(
[page_url] => global-movement-21052013
[emission_datetime] => 2013-05-21 00:00:00
[emission_entete] =>
[programme_nom] => Global Movement
[programme_entete] => Tous les 3ème lundi du mois, une émission 100% Hip Hop international
[media_name] => 2012-09-19-cf3e7a90fcae7d38092cf3d7f0924f0a.jpg
)
[1] => Array
(
[page_url] => la-matinale-21052013
[emission_datetime] => 2013-05-21 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] => ghetto-blaster-21-05-2013
[emission_datetime] => 2013-05-21 17:00:00
[emission_entete] => Rimo - Voyage à Nantes - festival de Cannes
[programme_nom] => Ghetto Blaster
[programme_entete] => Magazine quotidien de 2h dédiées à l'actualité culturelle locale
[media_name] => 2013-04-15-24e3d517441a03b1abb0ab0ba4e2c3a4.jpg
)
[3] => Array
(
[page_url] => le-labo-des-savoirs-21052013
[emission_datetime] => 2013-05-21 19:00:00
[emission_entete] => La biodiversité en ville
[programme_nom] => Le Labo des Savoirs
[programme_entete] => L'émission scientifique de Prun'
[media_name] => 2012-09-26-22d3fdd9d93a84f28ba40ff129059ae2.jpg
)
[4] => Array
(
[page_url] => version-papier-21-05-2013
[emission_datetime] => 2013-05-21 20:00:00
[emission_entete] =>
[programme_nom] => Version Papier
[programme_entete] => Exploration des cavités mystérieuses des musiques indés
[media_name] => 2012-10-05-f749b2b13f02dc0128140a2c5f150d08.jpg
)
[5] => Array
(
[page_url] => yckm-21-05-2013
[emission_datetime] => 2013-05-21 21:00:00
[emission_entete] =>
[programme_nom] => YCKM
[programme_entete] => Tour d'horizon global des scènes extrèmes actuelles et antérieures
[media_name] => 2012-10-05-9bbe23440563474f8460d07d4bc70002.jpg
)
[6] => Array
(
[page_url] => bruit-anti-bruit-21-05-2013
[emission_datetime] => 2013-05-21 23:00:00
[emission_entete] =>
[programme_nom] => BRU(i)T / Anti-BRU(i)T
[programme_entete] => Programme bicéphale de musiques et autres sonorités connexes
[media_name] => 2012-10-08-3030a4037c1c3e01d0b782e633300049.jpg
)
[7] => Array
(
[page_url] => jay-deemension-22-05-2013
[emission_datetime] => 2013-05-22 00:00:00
[emission_entete] =>
[programme_nom] => Jay Deemension
[programme_entete] => Immersion dans l'univers de la musique alternative et expérimentale
[media_name] => 2012-09-24-0529e7108d5c613b911e34afdf93d6de.jpg
)
)
[podcast_liste] => Array
(
[0] => Array
(
[media_name] => gimme-some-more-20121024-1.mp3
[media_description] => Gimme Some More 24/10/2012 Partie 1
)
)
[emissions_passees_liste] => Array
(
[0] => Array
(
[emission_datetime] => 2013-05-15 21:00:00
[page_url] => gimme-some-more-15-05-2013
[emission_sujet] => Saison 6 - Emission 32
)
[1] => Array
(
[emission_datetime] => 2013-05-08 21:00:00
[page_url] => gimme-some-more-08-05-2013
[emission_sujet] => Saison 6 - Emission 31
)
[2] => Array
(
[emission_datetime] => 2013-05-01 21:00:00
[page_url] => gimme-some-more-01-05-2013
[emission_sujet] => Saison 6 - Emission 30
)
[3] => Array
(
[emission_datetime] => 2013-04-24 21:00:00
[page_url] => gimme-some-more-24-04-2013
[emission_sujet] => Saison 6 - Emission 29
)
[4] => Array
(
[emission_datetime] => 2013-04-17 21:00:00
[page_url] => gimme-some-more-17-04-2013
[emission_sujet] => Saison 6 - Emission 28
)
[5] => Array
(
[emission_datetime] => 2013-04-10 21:00:00
[page_url] => gimme-some-more-10-04-2013
[emission_sujet] => Saison 6 - Emission 27
)
[6] => Array
(
[emission_datetime] => 2013-04-03 21:00:00
[page_url] => gimme-some-more-03-04-2013
[emission_sujet] =>
)
[7] => Array
(
[emission_datetime] => 2013-03-27 21:00:00
[page_url] => gimme-some-more-27-03-2013
[emission_sujet] => Saison 6 - Emission 26
)
[8] => Array
(
[emission_datetime] => 2013-03-20 21:00:00
[page_url] => gimme-some-more-20-03-2013
[emission_sujet] => Saison 6 - Emission 25
)
[9] => Array
(
[emission_datetime] => 2013-03-13 21:00:00
[page_url] => gimme-some-more-13-03-2013
[emission_sujet] => Saison 6 - Emission 24
)
[10] => Array
(
[emission_datetime] => 2013-03-06 21:00:00
[page_url] => gimme-some-more-06-03-2013
[emission_sujet] => Saison 6 - Emission 23 - Invité : Dj Heron X
)
[11] => Array
(
[emission_datetime] => 2013-02-27 21:00:00
[page_url] => gimme-some-more-27-02-2013
[emission_sujet] => Saison 6 - Emission 22
)
[12] => Array
(
[emission_datetime] => 2013-02-20 21:00:00
[page_url] => gimme-some-more-20-02-2013
[emission_sujet] => Saison 6 - Emission 21 | Dj MARRRTIN & AJAX TOW dans l'émission GIMME SOME MORE !
)
[13] => Array
(
[emission_datetime] => 2013-02-13 21:00:00
[page_url] => gimme-some-more-13-02-2013
[emission_sujet] => Saison 6 - Emission 20
)
[14] => Array
(
[emission_datetime] => 2013-02-06 21:00:00
[page_url] => gimme-some-more-06-02-2013
[emission_sujet] =>
)
[15] => Array
(
[emission_datetime] => 2013-01-30 21:00:00
[page_url] => gimme-some-more-30-01-2013
[emission_sujet] => Saison 6 - Emission 18
)
[16] => Array
(
[emission_datetime] => 2013-01-23 21:00:00
[page_url] => gimme-some-more-23-01-2013
[emission_sujet] => Saison 6 - Emission 17
)
[17] => Array
(
[emission_datetime] => 2013-01-16 21:00:00
[page_url] => gimme-some-more-16-01-2013
[emission_sujet] => Saison 6 - Emission 16
)
[18] => Array
(
[emission_datetime] => 2013-01-09 21:00:00
[page_url] => gimme-some-more-09-01-2013
[emission_sujet] => Saison 6 - Emission 15
)
[19] => Array
(
[emission_datetime] => 2013-01-02 21:00:00
[page_url] => gimme-some-more-02-01-2013
[emission_sujet] => Saison 6 - Emission 14
)
[20] => Array
(
[emission_datetime] => 2012-12-19 21:00:00
[page_url] => gimme-some-more-19-12-2012
[emission_sujet] => Saison 6 - Emission 13
)
[21] => Array
(
[emission_datetime] => 2012-12-12 21:00:00
[page_url] => gimme-some-more-12-12-2012
[emission_sujet] => Saison 6 - Emission 12
)
[22] => Array
(
[emission_datetime] => 2012-12-05 21:00:00
[page_url] => gimme-some-more-05-12-2012
[emission_sujet] => Saison 6 - Emission 11
)
[23] => Array
(
[emission_datetime] => 2012-11-28 21:00:00
[page_url] => gimme-some-more-28-11-2012
[emission_sujet] => Saison 6 - Emission 10
)
[24] => Array
(
[emission_datetime] => 2012-11-21 21:00:00
[page_url] => gimme-some-more-21-11-2012
[emission_sujet] => Saison 6 - Emission 9
)
[25] => Array
(
[emission_datetime] => 2012-11-14 21:00:00
[page_url] => gimme-some-more-14-11-2012
[emission_sujet] => Saison 6 - Emission 8
)
[26] => Array
(
[emission_datetime] => 2012-11-07 21:00:00
[page_url] => gimme-some-more-07-11-2012
[emission_sujet] => Saison 6 - Emission 7
)
[27] => Array
(
[emission_datetime] => 2012-10-31 21:00:00
[page_url] => gimme-some-more-31-10-2012
[emission_sujet] => Saison 6 - Emission 6
)
[28] => Array
(
[emission_datetime] => 2012-10-24 21:00:00
[page_url] => gimme-some-more-24-10-2012
[emission_sujet] => Saison 6 - Emission 5 | Holy Grail, Charles Walker & The Dynamites, UK 90's Hip Hop, boogie....
)
[29] => Array
(
[emission_datetime] => 2012-10-17 21:00:00
[page_url] => gimme-some-more-17-10-2012
[emission_sujet] => Saison 6 - Emission 4 | En direct du Labo !
)
[30] => Array
(
[emission_datetime] => 2012-10-10 21:00:00
[page_url] => gimme-some-more-10-10-2012
[emission_sujet] => Saison 6 - Emission 3
)
[31] => Array
(
[emission_datetime] => 2012-10-03 21:00:00
[page_url] => gimme-some-more-03-10-2012
[emission_sujet] => Saison 6 - Emission 2
)
[32] => Array
(
[emission_datetime] => 2012-09-26 21:00:00
[page_url] => gimme-some-more-26-09-2012
[emission_sujet] => Saison 6 - Emission 1
)
)
[prochaine_emission_programme] => Array
(
[emission_datetime] => 2013-05-22 21:00:00
[emission_sujet] =>
[page_url] => gimme-some-more-22-05-2013
)
[precedente_emission_programme] => Array
(
[emission_datetime] => 2012-10-17 21:00:00
[emission_sujet] => Saison 6 - Emission 4 | En direct du Labo !
[page_url] => gimme-some-more-17-10-2012
)
[suivante_emission_programme] => Array
(
[emission_datetime] => 2012-10-31 21:00:00
[emission_sujet] => Saison 6 - Emission 6
[page_url] => gimme-some-more-31-10-2012
)
[playlist] => Array
(
)
)
PageBuilderPublic::headerHTML
PageBuilderPublic::headerTPL
PageBuilderPublic::footerTPL
PageBuilderPublic::footerHTML
SELECT config_value FROM ga_config WHERE config_label="project_debug"
