<?php
    setlocale(LC_ALL, "fr_FR.utf8@euro", "fr_FR.utf8");
    include("classes.php");
    $tag = $_GET['tag'];
    $Data = new DataAccess;
    include("top.php");
    $Data->Query("
	SELECT * 
	FROM Mess M, Tags T, Lien_Tags_Posts L
	WHERE M.num_version='Version 10' AND T.Tag='{$tag}' AND M.num_mess=L.idMess AND L.idTag=T.idTag
	ORDER BY num_mess DESC");
    $i=0;
    while(($row=$Data->GetRow()) && $i++<10) {
    $mood = '';
    $Mess=$Data->utf8_ensure(str_replace("<P>","<p>",str_replace("</P>","</p>", $row['Message'])));
    $dateFormatee = strftime("%A %d %B %Y, %Hh%M", strtotime($row['DatePost']));
    $Titre = $Data->utf8_ensure($row['Titre']);
    $Titre_url = str_replace(" ", "_", strip_tags($Titre));
    $Titre_url = str_replace("-", "_", $Titre_url);
    $Titre_url = str_replace(array("é", "è"), "e", $Titre_url);
    $Titre_url = str_replace("à", "a", $Titre_url);
    $Titre_url = str_replace("ù", "u", $Titre_url);
    $Titre_url = str_replace(array("î", "ï"), "i", $Titre_url);
    if(!empty($row['Emot'])) {
	$mood = "<img src='/blog/mood/{$row['Emot']}.png' alt='Mood : {$row['Emot']}' class='mood' />";
	$row['Emot'] = " " . $row['Emot'];
    }
    $nbTags = $Data->Query("
	SELECT T.Tag
	FROM Tags T, Lien_Tags_Posts L
	WHERE L.idMess={$row['num_mess']} AND  L.idTag = T.idTag
	ORDER BY T.Tag
      ", 2);
      $tags = '';
      if($nbTags > 0)
      {
	$tags = "<span class='Tags'><em>Tags</em> :";
	while(0 !== ($tag = $Data->GetRow(2)))
	    $tags .= " <a href='/blog/tags/{$tag['Tag']}'>{$tag['Tag']}</a> |";
	$tags = substr($tags, 0, -1) . ' ;</span><br />';
      }

      echo("
       <div class='PostContent{$row['Emot']}'>
	<h2>{$Titre} | <span class='Date'>{$dateFormatee}</span></h2>
	{$mood}
	{$Mess}
	<p class='postInfos'>
	{$tags}
	<a href=\"/blog/posts/{$row['num_mess']}-{$Titre_url}\">#{$row['num_mess']}</a> - 
	<a href=\"/blog/posts/{$row['num_mess']}-{$Titre_url}\">
	 ");
      if(!is_null($row['NbCommentaires']) && $row['NbCommentaires']!=0)
	echo("Un 'tit commentaire ( {$row['NbCommentaires']} ) ?");
      else
       echo("Un 'tit commentaire ?");
      echo("
        </a>
	</p>
       </div>");
     }
     $Data->Close();
     include("foot.php");
?>