Auteur
B-Mag
B-Mag
Forum » » Bugs, Probs ... » » [Résolu] - suppression suite a mauvaise manip er reinstal
Posté : 6 avr. 2011 à 06:51 
function MM_forumP()
{
global $NPDS_Prefix,$cookie,$user;
$maxcount = "5";
$mbid = sql_fetch_row(sql_query("SELECT uid FROM ".$NPDS_Prefix."users WHERE uname = '$cookie[1]'"));
$MM_forumP .= '<table cellspacing="3" cellpadding="1" width="top" border="0">'
.'<tr align="center" class="ligna">'
.'<td width="5%">'.aff_langue('[french]Etat[/french][english]State[/english]').'</td>'
.'<td width="20%">'.aff_langue('[french]Forum[/french][english]Forum[/english]').'</td>'
.'<td width="30%">'.aff_langue('[french]Sujet[/french][english]Topic[/english]').'</td>'
.'<td width="5%">'.aff_langue('[french]Réponse[/french][english]Replie[/english]').'</td>'
.'<td width="20%">'.aff_langue('[french]Dernier Auteur[/french][english]Last author[/english]').'</td>'
.'<td width="20%">'.aff_langue('[french]Date[/french][english]Date[/english]').'</td>'
.'</tr>';
$result = sql_query("SELECT distinct topic_id FROM ".$NPDS_Prefix."posts WHERE forum_id > 0 ORDER BY post_id DESC LIMIT $maxcount");
$count = sql_num_rows($result);
if ($count > 0)
if ($count > $maxcount) $count = $maxcount;
$ibid = 0;
$forum_limit = 0;
while ($forum_limit < $count)
{
list($topic_id) = sql_fetch_row($result);
list($post_id, $forum_id, $poster_id, $time) = sql_fetch_row(sql_query("SELECT post_id, forum_id, poster_id, post_time FROM ".$NPDS_Prefix."posts WHERE forum_id > 0 AND topic_id = $topic_id ORDER BY post_id DESC LIMIT 1"));
$forum_limit++;
if ($topic_id!=0) list($topic_title) = sql_fetch_row(sql_query("SELECT topic_title, forum_id FROM ".$NPDS_Prefix."forumtopics WHERE topic_id=$topic_id"));
if ($forum_id!=0) list($forum_name,$forum_type,$forum_pass) = sql_fetch_row(sql_query("SELECT forum_name, forum_type, forum_pass FROM ".$NPDS_Prefix."forums WHERE forum_id = $forum_id"));
if (($forum_type == "5") or ($forum_type == "7"))
{
$ok_affich = false;
$tab_groupe = valid_group($user);
$ok_affich = groupe_forum($forum_pass, $tab_groupe);
}
else
{
$ok_affich = true;
}
if ($ok_affich)
{
if ($poster_id != 0) list($uname) = sql_fetch_row(sql_query("SELECT uname FROM ".$NPDS_Prefix."users WHERE uid = $poster_id"));
$MM_forumP .= '<tr class="lignb">';
$sqlR = "SELECT rid FROM ".$NPDS_Prefix."forum_read WHERE topicid = '$topic_id' AND uid = '$mbid[0]' AND status != '0'";
if ($ibid = theme_image("forum/icons/hot_red_folder.gif"))
{
$imgtmpHR = $ibid;
}
else
{
$imgtmpHR = "images/forum/icons/hot_red_folder.gif";
}
if ($ibid = theme_image("forum/icons/hot_folder.gif"))
{
$imgtmpH = $ibid;
}
else
{
$imgtmpH = "images/forum/icons/hot_folder.gif";
}
if ($ibid = theme_image("forum/icons/red_folder.gif"))
{
$imgtmpR = $ibid;
}
else
{
$imgtmpR = "images/forum/icons/red_folder.gif";
}
if ($ibid = theme_image("forum/icons/folder.gif"))
{
$imgtmpF = $ibid;
}
else
{
$imgtmpF = "images/forum/icons/folder.gif";
}
if ($ibid = theme_image("forum/icons/lock.gif"))
{
$imgtmpL = $ibid;
}
else
{
$imgtmpL="images/forum/icons/lock.gif";
}
$TableRep = sql_query("SELECT * FROM ".$NPDS_Prefix."posts WHERE forum_id > 0 AND topic_id = '$topic_id'");
$replys = sql_num_rows($TableRep)-1;
$hot_threshold = 10;//Nbres sujets chauds
if ($replys >= $hot_threshold)
{
if (sql_num_rows(sql_query($sqlR))==0)
$image = $imgtmpHR;
else
$image = $imgtmpH;
}
else
{
if (sql_num_rows(sql_query($sqlR))==0)
$image = $imgtmpR;
else
$image = $imgtmpF;
}
if ($myrow[topic_status]!=0)
$image = $imgtmpL;
$MM_forumP .= '<td align="center"><img src="'.$image.'"></td>'
.'<td><a href="viewforum.php?forum='.$forum_id.'">'.$forum_name.
'</a></td>'
.'<td align="left"><a href="viewtopic.php?topic='.$topic_id.'&forum='.$forum_id.'">'.$topic_title.'</a></td>'
.'<td align="center">'.$replys.'</td>'
.'<td align="center"><a href="user.php?op=userinfo&uname='.$uname.'">'.$uname.'</a></td>'
.'<td>'.$time.'</td>';
}
}
$MM_forumP .= '</tr>'
.'</table>';
return ($MM_forumP);
}
Cet article provient de NPDS
https://www.npds.org/viewtopic.php?topic=25052&forum=1