';
$limit_art=$nb_alaune_culture;
////////dates
if(!$cdate) $cdate=date("d-m-Y");
$exdate=explode('-',$cdate);
$timestamp=mktime(0,0,0,$exdate[1],$exdate[0],$exdate[2]);
$today=time();
if($timestamp<$today) $cdate=date("d-m-Y");
$exdate=explode('-',$cdate);
$timestamp=mktime(0,0,0,$exdate[1],$exdate[0],$exdate[2]);
$timestampf=mktime(0,0,0,$exdate[1]+1,$exdate[0],$exdate[2]);
//////////Manifestations culutrelles
$requmanif="select distinct manifestation.id,headline,item,minimage,alt_min,sdate,date_fin,lieu,place_min from manifestation where id_langue='$id_langue' and sdate<=$timestampf and date_fin>=$timestamp and statut_news='t'";
if($id_manif) $requmanif.=" and manifestation.id='$id_manif'";
$requmanif.=" order by sdate";
$reqf=query($requmanif);
$nb_manif=mysql_num_rows($reqf);
if($nb_manif and !$id_cat_culture)
{
$x=1;
while($rec=mysql_fetch_array($reqf))
{
$id_manifestation=$rec["id"];
$titre_article=$rec["headline"];
$resume_article=$rec["item"];
$lieu_article=$rec["lieu"];
$image_min=$rec["minimage"];
$alt_min=$rec["alt_min"];
$date_debut=$rec['sdate'];
$date_fin=$rec['date_fin'];
$place_min=$rec['place_min'];
$class_picture="photo_jetset";
if(!$date_fin or $date_debut==$date_fin) $intervalle=affichedate($date_debut);
else $intervalle="Du ".affichedate($date_debut)." au ".affichedate($date_fin);
$rep=$rep_culture."/festival/";
$link_article=$nom_de_domaine.$rep.reecritureUrl($titre_article).".".$article_culture.".".$id_manifestation.".html";
//$link_article=$url_absolue.'manif.php?id_article='.$article_culture.'&id_manif='.$id_manifestation;
if($image_min)
{
$photo='';
if(!$id_manif) $photo.='
';
$photo.='
';
if(!$id_manif) $photo.='';
}
else $photo='';
$affiche.='
';
$affiche.=$photo;
//echo '
';
$affiche.='
'.$lieu_article.'';
$affiche.='
'.$intervalle.'';
$affiche.='
'.$resume_article;
if(!$id_manif) $affiche.=' Plus de détails';
$affiche.='
';
$affiche.='
';
//if($x<$nb_manif) echo '
';
$x++;
}
////////fin test festival
}
$requete_init="select distinct article.reference,titre_article,lieu_article,date,article.date_f ,photo_miniature,resume_technique,place_min,alt_min,etalage.code_etalage,libelle_etalage,etalage.icone_etalage from etalage,article_etalage,article
where article.reference=article_etalage.reference and article_etalage.code_etalage=etalage.code_etalage
and article.id_langue='$id_langue' and etalage.id_langue='$id_langue' and actif='t' and date<=$timestampf and article.date_f>=$timestamp and etalage.code_etalagep='$categorie_culture' and publication='t' ";
$requete=$requete_init." group by article_etalage.code_etalage order by top desc,etalage.ordre_etalage";
$z=1;
$req2=query($requete);
while($rec2=mysql_fetch_array($req2))
{
$titre_bloc_culture=$rec2["libelle_etalage"];
$id_cat_culture=$rec2["code_etalage"];
$rep=$rep_culture."/";
$date_url=reecritureUrl(affichedate($timestamp));
$repfils=traite_rep($titre_bloc_culture).".".$article_culture.".".$id_cat_culture."/".$cdate.",".$date_url.".html";
$repfils=$rep.$repfils;
$chemin=$nom_de_domaine.$repfils;
$link_cat_cul='
Tout l\'agenda '.$titre_bloc_culture.'';
//$link_cat_cul='
Tout l\'agenda '.$titre_bloc_culture.'';
$affiche.='
'.$titre_bloc_culture.'
';
$affiche.='
';
$requete=$requete_init."and article_etalage.code_etalage='$id_cat_culture' order by actif_home,date,article.reference desc limit 0,$limit_art";
////articles culture
$req=query($requete);
$nb=mysql_num_rows($req);
$x=1;
while($rec=mysql_fetch_array($req))
{
$date_debut=$rec['date'];
$idt_article=$rec['reference'];
$image_min=$rec['photo_miniature'];
$alt_min=$rec["alt_min"];
$titre_article=$rec["titre_article"];
$lieu_article=$rec["lieu_article"];
$resume_article=$rec["resume_technique"];
$class_picture="photo_jetset";
$date_fin=$rec['date_f'];
if(!$date_fin or $date_debut==$date_fin) $intervalle=affichedate($date_debut);
else $intervalle="Du ".affichedate($date_debut)." au ".affichedate($date_fin);
$date_affichage=$timestamp;
if($date_debut>$date_affichage) $date_affichage=$date_debut;
$link_article=$nom_de_domaine.$rep.reecritureUrl($titre_article).".".$article_detail_agenda.".".$idt_article.".html";
//$link_article='agenda_details.php?id_article='.$article_detail_agenda.'&id_agenda='.$idt_article;
if($image_min) $photo='
';
else $photo='';
/////////Verifier si festival
$requef="select article.id,headline from article,manifestation where article.id=manifestation.id and reference='$idt_article'";
$reqf=query($requef);
$recf=mysql_fetch_array($reqf);
$link_manif=$nom_de_domaine.$rep_culture."/festival/".reecritureUrl($recf["headline"]).".".$article_culture.".".$recf['id'].".html";
if($recf['id'] and !$id_manif) $manifestation='Tout le programme :
'.$recf["headline"].'';
else $manifestation='';
$affiche.='
';
/*
echo '
';
echo ''.date("d",$date_affichage).'
';
echo ''.getmois($date_affichage).'
';
echo ''.date("Y",$date_affichage).'';
echo '
';
*/
//echo '
';
$affiche.=$photo;
$affiche.='
'.$titre_article.'';
$affiche.='
'.$lieu_article.'';
$affiche.='
'.$intervalle;
if($manifestation) $affiche.='
'.$manifestation;
$affiche.='';
$affiche.='
'.$resume_article.'
';
$affiche.='
Plus de détails';
//echo'
';
$affiche.='
';
if($x<$nb) $affiche.='
';
$x++;
}
///////////fin articles culture
$affiche.='
';
$affiche.='
';
$affiche.='
'.$link_cat_cul.'
';
$z++;
}
$affiche.='
';
$affiche.='';
$requete_init="select distinct article.reference,titre_article,lieu_article,date,article.date_f ,photo_miniature,resume_technique,place_min,alt_min,etalage.code_etalage,libelle_etalage,etalage.icone_etalage from etalage,article_etalage,article
where article.reference=article_etalage.reference and article_etalage.code_etalage=etalage.code_etalage
and article.id_langue='$id_langue' and etalage.id_langue='$id_langue' and actif='t' and date<=$timestampf and article.date_f>=$timestamp and etalage.code_etalagep='$categorie_culture' and publication='t' ";
$requete=$requete_init." group by article_etalage.code_etalage order by top desc,etalage.ordre_etalage";
$req2=query($requete);
$z=1;
while($rec2=mysql_fetch_array($req2))
{
$titre_bloc_culture=$rec2["libelle_etalage"];
$id_cat_culture=$rec2["code_etalage"];
$rep=$rep_culture."/";
$date_url=reecritureUrl(affichedate($timestamp));
$repfils=traite_rep($titre_bloc_culture).".".$article_culture.".".$id_cat_culture."/".$cdate.",".$date_url.".html";
$repfils=$rep.$repfils;
$chemin=$nom_de_domaine.$repfils;
$link_cat_cul='
';
$affiche.='
';
$requete=$requete_init."and article_etalage.code_etalage='$id_cat_culture' order by actif_home,date,article.reference desc ";
////articles culture
$req=query($requete);
$nb=mysql_num_rows($req);
$x=1;
while($rec=mysql_fetch_array($req))
{
$date_debut=$rec['date'];
$idt_article=$rec['reference'];
$image_min=$rec['photo_miniature'];
$alt_min=$rec["alt_min"];
$titre_article=$rec["titre_article"];
$lieu_article=$rec["lieu_article"];
$resume_article=$rec["resume_technique"];
$class_picture="photo_jetset";
$date_fin=$rec['date_f'];
if(!$date_fin or $date_debut==$date_fin) $intervalle=affichedate($date_debut);
else $intervalle="Du ".affichedate($date_debut)." au ".affichedate($date_fin);
$date_affichage=$timestamp;
if($date_debut>$date_affichage) $date_affichage=$date_debut;
$link_article=$nom_de_domaine.$rep.reecritureUrl($titre_article).".".$article_detail_agenda.".".$idt_article.".html";
//$link_article='agenda_details.php?id_article='.$article_detail_agenda.'&id_agenda='.$idt_article;
if($image_min) $photo='
';
else $photo='';
/////////Verifier si festival
$requef="select article.id,headline from article,manifestation where article.id=manifestation.id and reference='$idt_article'";
$reqf=query($requef);
$recf=mysql_fetch_array($reqf);
$link_manif=$nom_de_domaine.$rep_culture."/festival/".reecritureUrl($recf["headline"]).".".$article_culture.".".$recf['id'].".html";
if($recf['id'] and !$id_manif) $manifestation='Tout le programme :
'.$recf["headline"].'';
else $manifestation='';
$affiche.='
';
/*
echo '
';
echo ''.date("d",$date_affichage).'
';
echo ''.getmois($date_affichage).'
';
echo ''.date("Y",$date_affichage).'';
echo '
';
*/
//echo '
';
$affiche.=$photo;
$affiche.='
'.$titre_article.'';
$affiche.='
'.$lieu_article.'';
$affiche.='
'.$intervalle;
if($manifestation) $affiche.='
'.$manifestation;
$affiche.='';
$affiche.='
'.$resume_article.'
';
$affiche.='
Plus de détails';
//echo'
';
$affiche.='
';
if($x<$nb) $affiche.='
';
$x++;
}
///////////fin articles culture
$affiche.='
';
//echo '
'.$link_cat_cul.'
';
$z++;
$affiche.='
'.$titre_content.'