Mercurial > defr > DualBlog
view tag.php @ 2:1da880ffa7aa
Suppression d'anciennes versions des fichiers comment et index
author | Franck Deroche <webmaster@defr.org> |
---|---|
date | Sat, 20 Oct 2007 14:26:42 +0200 |
parents | 629389204276 |
children |
line wrap: on
line source
<?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"); ?>