Big tuto sur les forums

<?
if (verif_auth($data2['auth_view']))
{
//Affichage des forums
?>

<?php
// Ce super echo de la mort affiche tous
         // les forums en détail : description, nombre de réponses etc...

         echo'<tr><td><img src="http://ultimate.dofus.free.fr/images/p_mess.jpg" alt="message"  class="no_cadre" /></td>
         <td class="titre"><strong>
         <a href="./voirforum.php?f='.$data2['forum_id'].'">
         '.stripslashes(htmlspecialchars($data2['forum_name'])).'</a></strong>
         <br />'.nl2br(stripslashes(htmlspecialchars($data2['forum_desc']))).'</td>
         <td class="nombresujets">'.$data2['forum_topic'].'</td>
         <td class="nombremessages">'.$data2['forum_post'].'</td>';

         // Deux cas possibles :
         // Soit il y a un nouveau message, soit le forum est vide
         if (!empty($data2['forum_post']))
         {
         //Selection dernier message
	 $nombreDeMessagesParPage = 15;
         $nbr_post = $data2['topic_post'] +1;
	 $page = ceil($nbr_post / $nombreDeMessagesParPage);


         echo'<td class="derniermessage">
         '.date('H\hi \l\e d/M/Y',$data2['post_time']).'<br />
         <a href="./voirprofil.php?m='.stripslashes(htmlspecialchars($data2['membre_pseudo'])).'&amp;action=consulter">'.$data2['membre_pseudo'].'  </a>
               <a href="./voirtopic.php?t='.$data2['topic_id'].'&amp;page='.$page.'#p_'.$data2['post_id'].'">
               <img src="http://ultimate.dofus.free.fr/images/go.gif" alt="go" class="no_cadre" /></a></td></tr>';
         }
         else
         {
               echo'<td class="nombremessages">Pas de message</td></tr>';
         }

         //Cette variable stock le nombre de message, on la met à jour
         $totaldesmessages += $data2['forum_post'];

         //On ferme notre boucle et nos balises
         } //fin de la boucle
echo '</table>';

} //fin du else
?>

echo'<td class="nombremessages"><FORM method=post action="vidermessage.php"><INPUT type=checkbox name="vider[]" value="'.htmlentities($data2['forum_id']).'"></td></tr>';

<?php session_start();

include ('le fichier de connection');

//Topic déjà consulté ?
$marche = mysql_query("SELECT paysjoue FROM membres_tbl WHERE '".mysql_real_escape_string($_SESSION['login'])."' = Login");
$marcher = mysql_fetch_array($marche);
$marcheid = mysql_query("SELECT membre_id FROM forum_membres WHERE membre_pseudo = '".mysql_real_escape_string($marcher['paysjoue'])."'");
$marcherid = mysql_fetch_array($marcheid);
$_SESSION['id'] = ''.htmlentities($marcherid['membre_id']).'';

//on récupère le tableau des langues
$tab_lang = (isset($_POST['vider']))?$_POST['vider']:array();
//affichage des langues cochées

foreach($tab_lang as $lang)
{
$add1 = ',tv_id, tv_post_id, tv_poste'; 
//Deuxièmement, jointure
$add2 = 'LEFT JOIN forum_topic_view 
ON forum_topic.topic_id = forum_topic_view.tv_topic_id AND forum_topic_view.tv_id = '.intval($_SESSION['id']);

$requete3 = mysql_query('SELECT forum_topic.topic_id, topic_titre, topic_createur, topic_vu, topic_post, topic_time, topic_last_post,
Mb.membre_pseudo AS membre_pseudo_createur, post_createur, post_time, post_numerodetour, post_annee, post_saison, post_nomdirigeant, Ma.membre_pseudo AS membre_pseudo_last_posteur 
'.$add1.'
FROM forum_topic
LEFT JOIN forum_membres Mb ON Mb.membre_id = forum_topic.topic_createur
LEFT JOIN forum_post ON forum_topic.topic_last_post = forum_post.post_id
LEFT JOIN forum_membres Ma ON Ma.membre_id = forum_post.post_createur   
'.$add2.'
WHERE topic_genre <> "Annonce" AND forum_topic.forum_id = "'.$lang.'"');
$data3 = mysql_fetch_assoc($requete3);

$requete1 = mysql_query("
SELECT topic_titre, topic_post, forum_topic.forum_id, topic_last_post,
forum_name, auth_view, auth_topic, auth_post 
FROM forum_topic 
LEFT JOIN forum_forum ON forum_topic.forum_id = forum_forum.forum_id 
WHERE topic_id = '".$data3['topic_id']."'") or die (mysql_error());
$data1 = mysql_fetch_assoc($requete1);

$nbr_vu = mysql_result(mysql_query("SELECT COUNT(*) FROM forum_topic_view
WHERE tv_topic_id = '".$data1['forum_id']."' AND tv_id = '".intval($_SESSION['id'])."'"), 0);

if ($nbr_vu == 0) //Si c'est la première fois on insère une ligne entière
{
        mysql_query('INSERT INTO forum_topic_view 
        (tv_id, tv_topic_id, tv_forum_id, tv_post_id)
        VALUES ('.intval($_SESSION['id']).', '.$lang.', '.$data1['forum_id'].', '.$data1['topic_last_post'].')');
echo $_SESSION['id'];
echo "/a";
echo $lang;
echo "/b";
echo $data1['forum_id'];
echo "/c";
echo $data1['topic_last_post'];
echo "/d";
echo $_POST['vider'];
		}
else //Sinon, on met simplement à jour
{
        mysql_query('UPDATE forum_topic_view SET tv_post_id = 
        '.$data1['topic_last_post'].' WHERE tv_topic_id = '.$lang.' 
        AND tv_id = '.intval($_SESSION['id']));
echo $_SESSION['id'];
echo "/a";
echo $lang;
echo "/b";
echo $data1['forum_id'];
echo "/c";
echo $data1['topic_last_post'];
echo "/d";
echo $_POST['vider'];
		}
}

?>

<?php session_start();

include (ton fichier de connection);

//Topic déjà consulté ?
$marche = mysql_query("SELECT paysjoue FROM membres_tbl WHERE '".mysql_real_escape_string($_SESSION['login'])."' = Login");
$marcher = mysql_fetch_array($marche);
$marcheid = mysql_query("SELECT membre_id FROM forum_membres WHERE membre_pseudo = '".mysql_real_escape_string($marcher['paysjoue'])."'");
$marcherid = mysql_fetch_array($marcheid);
$_SESSION['id'] = ''.htmlentities($marcherid['membre_id']).'';

//on récupère le tableau des langues
$tab_lang = (isset($_POST['vider']))?$_POST['vider']:array();
//affichage des langues cochées

foreach($tab_lang as $lang)
{
$add1 = ',tv_id, tv_post_id, tv_poste'; 
//Deuxièmement, jointure
$add2 = 'LEFT JOIN forum_topic_view 
ON forum_topic.topic_id = forum_topic_view.tv_topic_id AND forum_topic_view.tv_id = '.intval($_SESSION['id']);

$requete3 = mysql_query('SELECT forum_topic.topic_id, topic_titre, topic_createur, topic_vu, topic_post, topic_time, topic_last_post,
Mb.membre_pseudo AS membre_pseudo_createur, post_createur, post_time, post_numerodetour, post_annee, post_saison, post_nomdirigeant, Ma.membre_pseudo AS membre_pseudo_last_posteur 
'.$add1.'
FROM forum_topic
LEFT JOIN forum_membres Mb ON Mb.membre_id = forum_topic.topic_createur
LEFT JOIN forum_post ON forum_topic.topic_last_post = forum_post.post_id
LEFT JOIN forum_membres Ma ON Ma.membre_id = forum_post.post_createur   
'.$add2.'
WHERE topic_genre <> "Annonce" AND forum_topic.forum_id = "'.$lang.'"');
 while ($data3 = mysql_fetch_assoc($requete3))
        {
$requete1 = mysql_query("
SELECT topic_titre, topic_post, forum_topic.forum_id, topic_last_post,
forum_name, auth_view, auth_topic, auth_post 
FROM forum_topic 
LEFT JOIN forum_forum ON forum_topic.forum_id = forum_forum.forum_id 
WHERE topic_id = '".$data3['topic_id']."'") or die (mysql_error());
while($data1 = mysql_fetch_assoc($requete1))
{

$nbr_vu = mysql_result(mysql_query("SELECT COUNT(*) FROM forum_topic_view
WHERE tv_topic_id = '".$data3['topic_id']."' AND tv_id = '".intval($_SESSION['id'])."'"), 0);
if ($nbr_vu == 0) //Si c'est la première fois on insère une ligne entière
{
        mysql_query('INSERT INTO forum_topic_view 
        (tv_id, tv_topic_id, tv_forum_id, tv_post_id)
        VALUES ('.intval($_SESSION['id']).', '.$data3['topic_id'].', '.$lang.', '.$data1['topic_last_post'].')');
echo $_SESSION['id'];
echo "/a";
echo $lang;
echo "/b";
echo $data3['topic_id'];
echo "/c";
echo $data1['topic_last_post'];


		}
else //Sinon, on met simplement à jour
{
        mysql_query('UPDATE forum_topic_view SET tv_post_id = 
        '.$data1['topic_last_post'].' WHERE tv_topic_id = '.$data3['topic_id'].' 
        AND tv_id = '.intval($_SESSION['id']));
echo $_SESSION['id'];
echo "/a";
echo $lang;
echo "/b";
echo $data3['topic_id'];
echo "/c";
echo $data1['topic_last_post'];

}
}
}
}
?>