visumodule=='1') { if ($SESSION_STATUT!="artadmin" && $SESSION_STATUT!="auteurqal" && $SESSION_STATUT!="auteur" && $SESSION_STATUT!="inscrit") { header("Location: ../outils/erreur.php?ec=2"); exit(); } } elseif ($autorisation->visumodule=='2') { if ($SESSION_STATUT!="artadmin" && $SESSION_STATUT!="auteurqal" && $SESSION_STATUT!="auteur") { header("Location: ../outils/erreur.php?ec=2"); exit(); } } elseif ($autorisation->visumodule=='3') { if ($SESSION_STATUT!="artadmin" && $SESSION_STATUT!="auteurqal") { header("Location: ../outils/erreur.php?ec=2"); exit(); } } elseif ($autorisation->visumodule=='4') { if ($SESSION_STATUT!="artadmin") { header("Location: ../outils/erreur.php?ec=2"); exit(); } } $t=$_GET['t']; $page=$_GET['page']; $limit=$_GET['limit']; $t = intval($t); $page = intval($page); $limit = intval($limit); //affichage des topics du forum (20 par page) //---------------------------------------------------------- if ($t) { $reqnb1="select topic_views, topic_status from ".$extension2."topics where topic_id='$t'"; $resnb1=mysql_query($reqnb1, $link); $oldnb=mysql_fetch_object($resnb1); //actualisation du nombre de fois lu //---------------------------------- $ajout="".$oldnb->topic_views.""; $total=$ajout+1; $reqnew="update ".$extension2."topics set topic_views='$total' where topic_id='$t'"; $resnew=mysql_query($reqnew, $link); //----------------------------------- // verif si le sujet est vérouillé pour réponse //--------------------------------------------- if ($oldnb->topic_status=='1') { $boutonreponse="\n"; } else { $boutonreponse="\n"; } //pagination le limit défini le nombre d'enregistrement par page //--------------------------------------------------------------- if (!($limit)) { $limit = 30; } if (!($page)) { $page = 0; } // comptage des enregistrements $requete2="select topic_id from ".$extension2."posts where topic_id='$t'"; $results=mysql_query($requete2, $link); $rows=mysql_num_rows($results); if ($rows == 0){ $listedossiers="

$LG_NORESULT\n"; } $pages = intval($rows/$limit); if ($rows%$limit) { $pages++;} $current = ($page/$limit) + 1; if (($pages < 1) || ($pages == 0)) { $total = 1;} else { $total = $pages;} $first = $page + 1; if (!((($page + $limit) / $limit) >= $pages) && $pages != 1) { $last = $page + $limit;} else{ $last = $rows; } //--------------------------------------------------------------------------- mysql_free_result($results); //--------------------------------------------------------------------------- if ($_GET['p']) { $p = $_GET['p']; $page = $pages*$limit-$limit; header ("Location:topic.php?t=$t&page=$page&limit=$limit#$p"); } /** DEFINITION DE LA CATEGORIE **/ // la catégorie $requetcat="SELECT ".$extension2."forums.forum_id, ".$extension2."forums.forum_name, ".$extension2."topics.topic_title FROM ".$extension2."forums, ".$extension2."topics where ".$extension2."topics.topic_id='$t' and ".$extension2."topics.forum_id=".$extension2."forums.forum_id"; $resultcat=mysql_query($requetcat, $link); $nom_cat=mysql_fetch_object($resultcat); /** ENTETE DE PAGE **/ $entete= "$LG_ACCUEIL/$LG_FORUMTITLE/forum_id."\" class=\"entete\">".$nom_cat->forum_name."/".$nom_cat->topic_title."\n"; //---------------------------------------- $entetepage= "

$LG_RESULPERPG \n"; $entetepage .= "20 | \n"; $entetepage .= "30 | \n"; $entetepage .= "50 | \n"; $entetepage .= "100  \n"; //----------------------------------------- $entete2=" ".$nom_cat->forum_name." > ".$nom_cat->topic_title."

\n\n"; //---------------------------------------- // metatags -------------------------------- $nCat = htmlspecialchars($nomcat); $nCat2 = htmlspecialchars($nomsscat); $metatitle="".$nCat." - ".$nCat2.""; $nCatDes = htmlspecialchars($defcat->descCat ); $metaDescription="$nCatDes"; //------------------------------------------- /** AFFICHAGE DES REPONSES DU TOPIC SPECIFIE **/ $page = intval($page); $limit = intval($limit); $listedossiers="

"; //présentation $listedossiers .="\n"; $requete="SELECT * FROM ".$extension2."posts, ".$extension2."posts_text, ".$extension2."users WHERE ".$extension2."posts.topic_id='$t' and ".$extension2."posts.post_id=".$extension2."posts_text.post_id and ".$extension2."users.user_id=".$extension2."posts.poster_id order by ".$extension2."posts.post_time asc LIMIT $page, $limit"; $result=mysql_query($requete, $link); while ($d2=mysql_fetch_object($result)) { $boutons="
forum_id','','menubar=no,scrollbars=yes,toolbar=no,resizable=yes,width=610,height=500');\"> \n"; $boutons .="$boutonreponse
\n"; $cite="post_id','','menubar=no,scrollbars=yes,toolbar=no,resizable=yes,width=610,height=500');\">\n"; /************ TEST MODO ***********************/ if ($_SESSION['SESSION_MODO']=='1') { $idphpbb = $_SESSION['SESSION_IDPHPBB']; $requetsupmod="SELECT session_id FROM ".$extension2."sessions WHERE session_user_id='$idphpbb' order by session_start desc"; $resultsupmod=mysql_query($requetsupmod, $link); $supmod=mysql_fetch_object($resultsupmod); $session_id = $supmod->session_id; $modo="post_id','','menubar=no,scrollbars=yes,toolbar=no,resizable=yes,width=500,height=105');\"> \n"; $modo.="post_id','','menubar=no,scrollbars=yes,toolbar=no,resizable=yes,width=610,height=500');\"> \n"; $modo2=" \n"; $modo2.=" \n"; if ($oldnb->topic_status=='1') { $modo2.=" \n"; } else { $modo2.=" \n"; } $modo2.=" \n"; } elseif ($_SESSION['SESSION_MODO']=='2') { // verif si pouvoir de modération dans ce forum $iduserphpbb=$_SESSION['SESSION_IDPHPBB']; $requetbb20="SELECT ".$extension2."user_group.group_id FROM ".$extension2."user_group WHERE ".$extension2."user_group.user_id='$iduserphpbb'"; $resultbb20=mysql_query($requetbb20, $link); $recherchegroup=mysql_fetch_object($resultbb20); $group=$recherchegroup->group_id; $requetbb21="SELECT ".$extension2."auth_access.forum_id FROM ".$extension2."auth_access WHERE ".$extension2."auth_access.group_id='$group' and ".$extension2."auth_access.forum_id='$d2->forum_id'"; $resultbb21=mysql_query($requetbb21, $link); $recherchemodo=mysql_fetch_object($resultbb21); $modo_or_not=$recherchemodo->forum_id; if (isset($modo_or_not)) { $idphpbb = $_SESSION['SESSION_IDPHPBB']; $requetsupmod="SELECT session_id FROM ".$extension2."sessions WHERE session_user_id='$idphpbb'"; $resultsupmod=mysql_query($requetsupmod, $link); $supmod=mysql_fetch_object($resultsupmod); $session_id = $supmod->session_id; $modo="post_id','','menubar=no,scrollbars=yes,toolbar=no,resizable=yes,width=500,height=105');\">"; $modo.="post_id','','menubar=no,scrollbars=yes,toolbar=no,resizable=yes,width=610,height=500');\">"; $modo2=" \n"; $modo2.=" \n"; if ($oldnb->topic_status=='1') { $modo2.=" \n"; } else { $modo2.=" \n"; } $modo2.=" \n"; } } /**********************************************/ // transformation date $d2->post_time=$d2->post_time-86400; $d2->post_time = date("d-m-Y à H:m:s",$d2->post_time+24*3600); //--------------------------- //transformation smileys $texte = "$d2->post_text"; $texte = doscode($texte); $texte = nl2br($texte); $texte = nl2br($texte); $texte = stripslashes($texte); $reqsmil="SELECT * FROM ".$extension2."smilies"; $resmil=mysql_query($reqsmil, $link); while ($smilll=mysql_fetch_object($resmil)) { $codiche = "$smilll->code"; $imgsmil = "smile_url \">"; $texte = str_replace ($codiche, $imgsmil, $texte); } if ($d2->username=='Anonymous') { $nomuser="$LG_BBINVITE"; } else { $nomuser="$d2->username"; // transformation date inscription $d2->user_regdate=$d2->user_regdate-86400; $d2->user_regdate = date("d-m-Y",$d2->user_regdate+24*3600); } $listedossiers .="\n"; $listedossiers .="\n"; $listedossiers .="\n"; } $listedossiers .="
\n"; $listedossiers .= "$LG_BBAUTEUR\n"; $listedossiers .= "$LG_BBMESS2\n"; $listedossiers .= "
\n"; $listedossiers .= "post_id\">$nomuser\n"; if ($d2->username!='Anonymous') { $listedossiers .= "

$LG_BBINSCRIT $d2->user_regdate
$LG_BBMESSAGE : $d2->user_posts\n"; } $listedossiers .= "		$LG_BBDATPOST $d2->post_time $modo $cite
\n"; $listedossiers .= "$texte \n"; $listedossiers .= "

$LG_BBTOP

"; //----------------------------------------------------------------------- // Deuxieme partie du code de pagination // (à modifier si vous avez d'autres données à faire circuler dans l'URL) //----------------------------------------------------------------------- if ($page != 0) { $back_page = $page - $limit; $pagination .= "<<\n"; } for ($i=1; $i <= $pages; $i++) { $ppage = $limit*($i - 1); if ($ppage == $page){ //------ if ($total == 1) { $pagination .= ""; } else { $pagination .= "$i \n"; } //----- } else { $pagination .= "$i \n"; } } if (!((($page+$limit) / $limit) >= $pages) && $pages != 1) { $next_page = $page + $limit; $pagination .= ">>\n"; } if (! $pagination) { $finpag .= "
"; } else { $debutpag .= "
"; $debutpag .= " $LG_ALPAGE "; $finpag .= "

"; } //------------------------------------------------------------------------- } else { header ("Location:index.php"); exit(); } mysql_free_result($result); //---------------------------- //presentation //------------ $milieu=""; $milieu .="$debutpag $pagination $finpag"; $milieu .="$entete2"; $milieu .="$boutons"; $milieu .="$listedossiers"; $milieu .="$debutpag $pagination $finpag"; $milieu .="$boutons"; $milieu .="
$modo2"; //feuilles de style spécifique au module //-------------------------------------- $css .="\n\n"; //le template //------------ $SESSION_SKIN=$_SESSION['SESSION_SKIN']; include("../templates/temp$SESSION_SKIN/temp.html"); echo $arti; mysql_close(); ?>