Chargement...

Evan Dream On the Mix

Prochaine Emission : jeudi 30 mai 2013 00 h 00

A propos de ce programme

Evan Dream On The Mix, c'est une émission hebdomadaire chaque mercredi à partir de minuit, à l'affût des nouvelles tendances musicales, qu'elles viennent du rock électro ou du hip hop electro, et des nouveaux phénomènes de société liés à la musique électronique.

MODE DEBUG

PageManagerPublic::__construct
PageBuilderPublic::__construct
Page::__construct
PageManagerPublic::displayPage
Page::getPageStatic
SELECT * FROM ga_page WHERE page_url="evan-dream-on-the-mix" 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="" 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="" 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='' AND ga_page_rss.id_rss=ga_rss.id_rss ORDER BY ga_rss.id_rss

Site::getConfig
SELECT * FROM ga_config

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="evan-dream-on-the-mix"

SELECT id_stage, page_name, page_title, page_description, page_keywords FROM ma_stage WHERE page_url="evan-dream-on-the-mix"

SELECT id_programme, page_name, page_title, page_description, page_keywords FROM ma_programme WHERE page_url="evan-dream-on-the-mix"

SELECT id_page,page_link FROM ga_page WHERE page_url="programme"

SELECT page_url FROM ga_page WHERE id_page="7"

Page::getPageStatic
SELECT * FROM ga_page WHERE page_url="programme" 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="7" 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="7" 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='7' 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="programme" 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_programme.id_programme, ma_programme.page_name, ma_programme.page_url, ma_programme.page_title, ma_programme.page_description, ma_programme.page_keywords, ma_programme.programme_nom, ma_programme.programme_heure, ma_programme.programme_duree, ma_programme.id_programme_categorie, ma_programme.id_programme_type, ma_programme.programme_recurrence, ma_programme.programme_description, ma_programme.programme_jour, ma_programme.programme_entete, ma_media.media_name FROM ( ma_programme) LEFT JOIN ma_media ON ma_media.id_programme=ma_programme.id_programme WHERE page_url="evan-dream-on-the-mix"

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

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='57' 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='57' 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='57' AND
emission_datetime<''
ORDER BY emission_datetime DESC
LIMIT 1

SELECT ma_emission.emission_datetime,ma_emission.emission_sujet,page_url
FROM ma_emission
WHERE id_programme='57' AND
emission_datetime>''
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=''

Données envoyés au template :
Array
(
[id_programme] => 57
[page_name] => Evan Dream On the Mix
[page_url] => evan-dream-on-the-mix
[page_title] => Evan Dream On the Mix
[page_description] =>
[page_keywords] =>
[programme_nom] => Evan Dream On the Mix
[programme_heure] => 0000-00-00 00:00:00
[programme_duree] => 119
[id_programme_categorie] => 2
[id_programme_type] => 4
[programme_recurrence] => Hebdomadaire
[programme_description] =>

11 h 00	Chromosome X Un autre regard sur la condition féminine
12 h 00	Cosmopolite Savourez un délicieux cocktail épicé de musiques du monde !
15 h 00	Planet Hip Hop Emission à ne pas manquer pour les amoureux du Hip Hop
16 h 00	Hip Hop Shop L'actualité du Hip Hop de la France au Québec, de Nantes à Queensbridge !
17 h 00	Get Up! La culture reggae sur la bande fm nantaise !
19 h 00	Truth & Right Le meilleur de la musique jamaïcaine, des fondations jusqu'à aujourd'hui
20 h 00	Bass Addict Hip Hop & Reggae, deux musiques pour un seul et même combat !
22 h 00	Distant Relatives L'émission qui fait l'apologie du Hip Hop Africain !
23 h 00	Back Ina Days Emission dédiée au rap et ragga des années 90

26.05.2013 14 h	Mad' en action Festival caritatif
28.05.2013 20 h	La Nuit De Valognes Théâtre - Une Pièce de Séducteur
28.05.2013 21 h	Les Zygomatiq L’humour sous toutes ses coutures
29.05.2013 00 h	Festival Cinépride Festival du film Gay, Lesbien, Bi
29.05.2013 19 h	Truck Turner Film - Blaxploitation