<?
// affichage des festivals
$prefix="../";
include $prefix."includes/debut.php";
include "agenda_lib.php";
if ($id) {
	$vue="details";
}
switch ($vue) {
	case "details":
	$trail["Festivals"]='festivals.php';
	$sql= "SELECT *, date_format(debut,'%d.%m.%Y') AS date, date_format(fin,'%d.%m.%Y') AS datefin FROM agenda_festivals WHERE idfest = '$id'";
	$connexion=mysql_connect($host,$login,$password) or die("Impossible de se connecter à la base de données");	
	$resultat = mysql_db_query($base,$sql);
    mysql_close($connexion);
	if (mysql_num_rows($resultat)>0) { // on affiche le résultat
		$t->set_file("detail",$dossier_commun."agenda/detail_festival.tpl");
		while($row = mysql_fetch_array($resultat)){
			$nom = MyStripSlashes($row["nom"],"b");
			$trail[$nom]='';
			$t->set_var(array(
					"NOM_FESTIVAL"=>$nom,
					"DETAIL_FESTIVAL"=>nl2br(MyStripSlashes($row["details"],"b")),
					"DEBUT_FESTIVAL"=>$row["date"],
					"FIN_FESTIVAL"=>$row["datefin"]
				));
			//image
			icone ($row["idfest"], "$prefix/images/agenda/");
			//liste des évènements correspondants
			liste_evenements($dossier_commun."agenda/liste.tpl","LISTE_DATES",'festival', '','',$row["idfest"]);
			$t->parse("CONTENU_SITE","detail",true);
		}
	}
	else {
		$t->set_var("CONTENU_SITE","Ce festival n'existe pas");
	}
	break;
	default: // on affiche la liste des festivals à venir
	$trail["Festivals"]='';
	$t->set_file("liste",$dossier_commun."agenda/accueil_festival.tpl");
	$t->set_block("liste","FESTIVAL","ligne_fest");
	$sql = "SELECT *, date_format(debut,'%d.%m.%Y') AS date, date_format(fin,'%d.%m.%Y') AS datefin FROM agenda_festivals WHERE idfest <> 0 AND debut >= CURRENT_DATE() OR debut <= CURRENT_DATE AND fin >= CURRENT_DATE ORDER BY debut";
	$connexion=mysql_connect($host,$login,$password) or die("Impossible de se connecter à la base de données");	
	$resultat = mysql_db_query($base,$sql);
    $nb=mysql_num_rows($resultat);
	mysql_close($connexion);
	if ($nb>0) {
		while($row = mysql_fetch_array($resultat)){
			$t->set_var(array(
				"NOM_FESTIVAL"=>MyStripSlashes($row["nom"],"b"),
				"DETAIL_FESTIVAL"=>nl2br(MyStripSlashes($row["details"],"b")),
				"DEBUT_FESTIVAL"=>$row["date"],
				"FIN_FESTIVAL"=>$row["datefin"],
				"ID_FESTIVAL"=>$row["idfest"]
				));
			icone ($row["idfest"], "$prefix/images/agenda/");
			$t->parse("ligne_fest","FESTIVAL",true);
		}
	}
	else {
		$t->set_var("ligne_fest","Aucun festival actuellement");
	}
	$t->parse("CONTENU_SITE","liste",true);

}


include $prefix."includes/fin.php";
?>