\n"; //------------------------ //affichage des categories //------------------------ $requete="select * from ".$extension2."categories order by cat_order"; $result=mysql_query($requete, $link); while ($dossier=mysql_fetch_object($result)) { $cat="$dossier->cat_id"; //présentation $listedossiers .="\n"; /*affichage des forums*/ $requete2="select * from ".$extension2."forums where cat_id=$cat order by forum_order"; $result2=mysql_query($requete2, $link); while ($forum=mysql_fetch_object($result2)) { // affichage des modos $mdfor=""; $requetmodo="select ".$extension2."users.username from ".$extension2."auth_access, ".$extension2."user_group, ".$extension2."users where ".$extension2."auth_access.forum_id=".$forum->forum_id." and ".$extension2."auth_access.group_id=".$extension2."user_group.group_id and ".$extension2."user_group.user_id=".$extension2."users.user_id"; $resultmodo=mysql_query($requetmodo, $link); if (mysql_num_rows($resultmodo)==0) { } else { while ($modo=mysql_fetch_object($resultmodo)) { $mdfor.="$modo->username "; } $affichage_modo=""; } if (isset($forum->forum_posts)) { /*affichage des données des forums*/ $requete3="select * from ".$extension2."forums, ".$extension2."posts, ".$extension2."users where ".$extension2."forums.forum_id=$forum->forum_id and forum_last_post_id=".$extension2."posts.post_id and ".$extension2."posts.poster_id=".$extension2."users.user_id order by forum_order"; $result3=mysql_query($requete3, $link); $forumdetails=mysql_fetch_object($result3); // transformation date $post_time=$forumdetails->post_time; $post_time2=$forumdetails->post_time-86400; $post_time = date("d-m-Y à H:m:s",$post_time+24*3600); //--------------------------- if ($SESSION_LASTVISIT) { if ($SESSION_LASTVISIT<=$post_time2) { $imgfor="folder_new_big.gif"; } else { $imgfor="folder_big.gif"; } } else { $imgfor="folder_big.gif"; } } $listedossiers .= "\n"; mysql_free_result($result2); //-------------------------- } $listedossiers .= "

\n"; $listedossiers .= "$dossier->cat_title\n"; $listedossiers .= "	$LG_BBSUJET\n"; $listedossiers .= "	$LG_BBMESSAGE\n"; $listedossiers .= "	$LG_BBLASTMESS\n"; $listedossiers .= "
	\n"; $listedossiers .= " forum_id."\" class=\"Dos_sscat_titre\">$forum->forum_name \n"; $listedossiers .= " $forum->forum_desc \n"; $listedossiers .= "$affichage_modo\n"; if ($forum->forum_posts=='0') { $listedossiers .= "	0\n"; $listedossiers .= "	0\n"; $listedossiers .= "	$LG_BBNOMESS\n"; } else { $listedossiers .= "	$forumdetails->forum_topics\n"; $listedossiers .= "	$forumdetails->forum_posts\n"; $listedossiers .= "	$post_time $LG_BBPAR \n"; if ($forumdetails->user_id=='-1') { $listedossiers .= "$LG_BBINVITE\n"; } else { $listedossiers .= "$forumdetails->username\n"; } } } $listedossiers .= "