webmaster@0: <?php
webmaster@0:     setlocale(LC_ALL, "fr_FR.utf8@euro", "fr_FR.utf8");
webmaster@0:      include("classes.php");
webmaster@0:      $type = $_GET['type'];
webmaster@0:      $year = $_GET['year'];
webmaster@0:      $month = $_GET['month'];
webmaster@0:      $prevMonth = ($month - 1)%12; if($prevMonth == 0) $prevMonth = 12; $prevYear = ($month == 1)?$year-1:$year;
webmaster@0:      $nextMonth = $month % 12 + 1; $nextYear = ($month == 12)?$year+1:$year;
webmaster@0:      $Data = new DataAccess;
webmaster@0:      include("top.php");
webmaster@0:      $Data->Connect();
webmaster@0:      if($type != "cal") 
webmaster@0: 	$Data->Query("SELECT * FROM Mess Where num_version='Version 10' ORDER BY num_mess DESC");
webmaster@0:      else
webmaster@0: 	$Data->Query("SELECT * FROM Mess WHERE YEAR(DatePost)={$year} AND MONTH(DatePost)={$month} ORDER BY num_mess DESC");
webmaster@0:      $i=0;
webmaster@0:      if($type == "cal") {
webmaster@0: 	echo("<div class='cal'>");
webmaster@0: 	if($prevYear > $startDate['year'] - 1 || ($prevYear > $startDate['Year'] - 2 && $prevMonth > $startDate['month'] - 1))
webmaster@0: 		echo("<a class='calPrev' href='/blog/posts/{$prevYear}/{$prevMonth}'>{$arMonth[$prevMonth - 1]} {$prevYear}</a>");
webmaster@0: 	else
webmaster@0: 		echo("<a class='calPrev'>{$arMonth[$prevMonth - 1]} {$prevYear}</a>");
webmaster@0: 	if(($curYear == $nextYear && $nextMonth < $curMonth + 1) || ($nextYear < $curYear) )
webmaster@0: 		echo("<a class='calNext' href='/blog/posts/{$nextYear}/" . ($month % 12 + 1)  ."'>{$arMonth[$month%12]} {$nextYear}</a>");
webmaster@0: 	else
webmaster@0: 		echo("<a class='calNext'>{$arMonth[$month%12]} {$nextYear}</a>");
webmaster@0: 	echo("{$arMonth[$month - 1]} {$year}</div> ");
webmaster@0:      }
webmaster@0:      while(($row=$Data->GetRow()) && ($i++<10 || $type == "cal")) {
webmaster@0:       $mood = '';
webmaster@0:       $Mess=$Data->utf8_ensure(str_replace("<P>","<p>",str_replace("</P>","</p>", $row['Message'])));
webmaster@0:       $dateFormatee = strftime("%A %d %B %Y, %Hh%M", strtotime($row['DatePost']));
webmaster@0:       $Titre = $Data->utf8_ensure($row['Titre']);
webmaster@0:       $Titre_url = str_replace(" ", "_", strip_tags($Titre));
webmaster@0:       $Titre_url = str_replace("-", "_", $Titre_url);
webmaster@0:       $Titre_url = str_replace(array("é", "è"), "e", $Titre_url);
webmaster@0:       $Titre_url = str_replace("à", "a", $Titre_url);
webmaster@0:       $Titre_url = str_replace("ù", "u", $Titre_url);
webmaster@0:       $Titre_url = str_replace(array("î", "ï"), "i", $Titre_url);
webmaster@0:       if(!empty($row['Emot'])) {
webmaster@0: 	$mood = "<img src='/blog/mood/{$row['Emot']}.png' alt='Mood : {$row['Emot']}' class='mood' />";
webmaster@0: 	$row['Emot'] = " " . $row['Emot'];
webmaster@0:       }
webmaster@0:       echo("
webmaster@0:        <div class='PostContent{$row['Emot']}'>
webmaster@0:         <h2>{$Titre} | <span class='Date'>{$dateFormatee}</span></h2>
webmaster@0: 	 {$mood}
webmaster@0: 	 {$Mess}<br />
webmaster@0: 	 <a href=\"/blog/posts/{$row['num_mess']}-{$Titre_url}\">#{$row['num_mess']}</a> - 
webmaster@0: 	 <a href=\"/blog/posts/{$row['num_mess']}-{$Titre_url}\">
webmaster@0: 	 ");
webmaster@0:       if(!is_null($row['NbCommentaires']) && $row['NbCommentaires']!=0)
webmaster@0: 	echo("Un 'tit commentaire ( {$row['NbCommentaires']} ) ?");
webmaster@0:       else
webmaster@0:        echo("Un 'tit commentaire ?");
webmaster@0:       echo("
webmaster@0:         </a>");
webmaster@0:       $nb = $Data->debugQuery("
webmaster@0: 	SELECT T.Tag
webmaster@0: 	FROM Tags T, Lien_Tags_Posts L
webmaster@0: 	WHERE L.idMess={$row['num_mess']} AND  L.idTag = T.idTag
webmaster@0: 	ORDER BY T.Tag
webmaster@0:       ", 2);
webmaster@0:       if($nb > 0)
webmaster@0:       {
webmaster@0: 	  $tags = '';
webmaster@0: 	  while(0 !== ($tag = $Data->GetRow(2)))
webmaster@0: 	    $tags .= " <a href='/blog/tags/{$tag['Tag']}'>{$tag['Tag']}</a> -";
webmaster@0: 	  $tags = substr($tags, 0, -1);
webmaster@0: 	  echo(" ; <em>Tags</em> : {$tags}");
webmaster@0:       }
webmaster@0:       echo("
webmaster@0: 
webmaster@0:        </div>");
webmaster@0:      }
webmaster@0:      if($type == "cal") {
webmaster@0: 	echo("<div class='cal'>");
webmaster@0: 	if($prevYear > $startDate['year'] - 1 && $prevMonth > $startDate['month'] - 1)
webmaster@0: 		echo("<a class='calPrev' href='/blog/posts/{$prevYear}/{$prevMonth}'>{$arMonth[$prevMonth - 1]} {$prevYear}</a>");
webmaster@0: 	else
webmaster@0: 		echo("<a class='calPrev'>{$arMonth[$prevMonth - 1]} {$prevYear}</a>");
webmaster@0: 	if(($curYear == $nextYear && $nextMonth < $curMonth + 1) || ($nextYear < $curYear) )
webmaster@0: 		echo("<a class='calNext' href='/blog/posts/{$nextYear}/" . ($month % 12 + 1)  ."'>{$arMonth[$month%12]} {$nextYear}</a>");
webmaster@0: 	else
webmaster@0: 		echo("<a class='calNext'>{$arMonth[$month%12]} {$nextYear}</a>");
webmaster@0: 	echo("{$arMonth[$month - 1]} {$year}</div> ");
webmaster@0:      }
webmaster@0:      $Data->Close();
webmaster@0:      include("foot.php");
webmaster@0: ?>