PageManagerPublic::__construct
PageBuilderPublic::__construct
Page::__construct
PageManagerPublic::displayPage
Page::getPageStatic
SELECT * FROM ga_page WHERE page_url="err404" AND page_type="0"
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="2" 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="2" 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='2' AND ga_page_rss.id_rss=ga_rss.id_rss ORDER BY ga_rss.id_rss
Site::getConfig
SELECT * FROM ga_config
SELECT page_url FROM ga_page WHERE id_page="2"
Page::getPageStatic
SELECT * FROM ga_page WHERE page_url="err404" AND page_type=""
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="2" 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="2" 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='2' AND ga_page_rss.id_rss=ga_rss.id_rss ORDER BY ga_rss.id_rss
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="err404" 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.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_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
Données envoyés au template :
Array
(
[prochaine_emission_liste] => Array
(
[0] => Array
(
[page_url] => ground-control-24-05-2013
[emission_datetime] => 2013-05-24 00:00:00
[emission_entete] => Spécial House
[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
)
[1] => Array
(
[page_url] => midnight-city-24052013
[emission_datetime] => 2013-05-24 01:00:00
[emission_entete] =>
[programme_nom] => Midnight City
[programme_entete] => Voyage à travers le côté tranquille de la bass music
[media_name] => 2013-01-29-ee0df397a2d89dafe7615b0b699e5f68.jpg
)
[3] => Array
(
[page_url] => prun-sport-24052013
[emission_datetime] => 2013-05-24 19:00:00
[emission_entete] =>
[programme_nom] => Prun' Sport
[programme_entete] => L'émission qui vous promet du jeu et de la sueur
[media_name] => 2013-03-13-dd15a6f8582c37581e234e132b59800f.jpg
)
[4] => Array
(
[page_url] => electro-bamako-24-05-2013
[emission_datetime] => 2013-05-24 20:00:00
[emission_entete] =>
[programme_nom] => Electro Bamako
[programme_entete] => Du bon son pour vous faire voyager autour du monde !
[media_name] => 2012-09-21-45ba135502082264957c92e9300861a8.jpg
)
[3] => Array
(
[page_url] => la-nuit-de-valognes-28-05-2013
[evenement_nom] => La Nuit De Valognes
[evenement_type] => partenaire
[evenement_debut] => 2013-05-28 20:30:00
[evenement_entete] => Théâtre - Une Pièce de Séducteur
[evenement_etat] => 2
[media_name] => 2013-05-24-e69ba03e014266ef85deb0e9538b18c9.jpg
)
[4] => Array
(
[page_url] => les-zygomatiq-28-05-2013
[evenement_nom] => Les Zygomatiq
[evenement_type] => partenaire
[evenement_debut] => 2013-05-28 21:00:00
[evenement_entete] => L’humour sous toutes ses coutures
[evenement_etat] => 2
[media_name] => 2013-05-16-06f3c9e32e187642b95be2520dfe4aa9.jpg
)
)
)
PageBuilderPublic::headerHTML
PageBuilderPublic::headerTPL
PageBuilderPublic::footerTPL
PageBuilderPublic::footerHTML
SELECT config_value FROM ga_config WHERE config_label="project_debug"