| Coups de gueule contre son patron |
|
$sql = "
SELECT
anecdote.id_anec,
anecdote.title,
anecdote.text,
anecdote.date as LaDate,
users.nickname
FROM anecdote,users
WHERE anecdote.id_user=users.id_user
AND anecdote.active='1'
ORDER BY `LaDate` DESC
";
$result = mysql_query($sql);
//On compte les pages
$nb_pages = mysql_num_rows($result)/10;
if(!is_int($nb_pages)) { $nb_pages = intval($nb_pages) + 1; }
//Si on est sur une page
if(!$_REQUEST['p']) {
$prev = 1;
$next = 2;
$depart = 0;
if( ($nb_pages<10) ) {
$depart_nav = 1;
$fin_nav = $nb_pages;
}
else {
$depart_nav = 1;
$fin_nav = 9;
}
}
else {
$depart = (intval($_REQUEST['p'])-1)*10;
$next = intval($_REQUEST['p'])+1;
if($_REQUEST['p']!=1) {$prev = intval($_REQUEST['p'])-1;} else { $prev = 1; }
if( (intval($_REQUEST['p'])<=4) && ($nb_pages<10)){
$depart_nav = 1;
$fin_nav = $nb_pages;
}
else {
$depart_nav = 1;
$fin_nav = 9;
}
if( (intval($_REQUEST['p'])>4) && ($nb_pages>=10)){
$depart_nav = intval($_REQUEST['p'])-4;
$fin_nav = intval($_REQUEST['p'])+4;
}
if( (intval($_REQUEST['p']+3==$nb_pages)) && ($nb_pages>=10)) {
$depart_nav = intval($_REQUEST['p'])-5;
$fin_nav = intval($_REQUEST['p'])+3;
}
if( (intval($_REQUEST['p']+2==$nb_pages)) && ($nb_pages>=10)) {
$depart_nav = intval($_REQUEST['p'])-6;
$fin_nav = intval($_REQUEST['p'])+2;
}
if( (intval($_REQUEST['p']+1==$nb_pages)) && ($nb_pages>=10)) {
$depart_nav = intval($_REQUEST['p'])-7;
$fin_nav = intval($_REQUEST['p'])+1;
}
if( (intval($_REQUEST['p']==$nb_pages)) && ($nb_pages>=10)) {
$depart_nav = intval($_REQUEST['p'])-8;
$fin_nav = intval($_REQUEST['p']);
}
}
?>
// Si un enregistrement est trouvé
if(mysql_num_rows($result) > 0)
{
if($_REQUEST['tri']):
switch($_REQUEST['tri']):
case "date":
$sql = "
SELECT
anecdote.id_anec,
anecdote.title,
anecdote.text,
anecdote.date as LaDate,
users.nickname
FROM anecdote,users
WHERE anecdote.id_user=users.id_user
AND anecdote.active='1'
ORDER BY `LaDate` DESC
LIMIT ".$depart.",10
";
break;
case "pop":
$sql = "
SELECT
anecdote.id_anec,
anecdote.title,
anecdote.text,
anecdote.date as LaDate,
users.nickname, (ratings.total_value/ratings.total_votes) AS Somme
FROM anecdote,users,ratings
WHERE anecdote.id_user=users.id_user
AND ratings.id = anecdote.id_anec
AND anecdote.active='1'
ORDER BY `Somme` DESC
LIMIT ".$depart.",10
";
$navplus = "&tri=pop";
break;
endswitch;
else:
$sql = "
SELECT
anecdote.id_anec,
anecdote.title,
anecdote.text,
anecdote.date as LaDate,
users.nickname
FROM anecdote,users
WHERE anecdote.id_user=users.id_user
AND anecdote.active='1'
ORDER BY `LaDate` DESC
LIMIT ".$depart.",10
";
endif;
$result = mysql_query($sql);
while($row = mysql_fetch_array($result))
{
$sql2 = "
SELECT COUNT(id_comment) as NbComment
FROM comments
WHERE id_anec = '".$row["id_anec"]."' AND active='1'
";
$result2 = mysql_query($sql2);
while($row2 = mysql_fetch_array($result2)) { $nb_com = $row2["NbComment"]; }
//Calcul de la moyenne des votes
$vote_total=0;
$sql3 = "
SELECT *
FROM ratings
WHERE id = '".$row["id_anec"]."'
";
$result3 = mysql_query($sql3);
if(mysql_num_rows($result3) > 0)
{
while($row3 = mysql_fetch_array($result3))
{
if($row3["total_votes"]!=0):
$note = intval($row3["total_value"])/intval($row3["total_votes"]);
else:
$note=1;
endif;
}
$width = ($note*73)/5;
}
else { $width=0; }
//On transforme la date
$ladate = date("d/m/y à H:i",$row["LaDate"]);
//On prend un bout du texte seulement
if(strlen($row["text"])>270) {
$nb_caracteres = 270;
for($i=$nb_caracteres; $i<= $nb_caracteres+100;$i++) {
if(substr($row["text"],$i,1)==" ") {
$text = substr($row["text"],0,$i).'...';
break;
}
else { $text = $row["text"]; }
}
} else { $text = $row["text"]; }
echo '
'
.'
'
.'
'.$text.'
'
.'
'
.' |
'
.'rédigé par '.$row["nickname"].' le '.$ladate
.' | Commentaires('. $nb_com .')'
.' |
';
}
}
?>