LOGO  
PagePrincipaleRechercheTexteCABP News
DerniersChangementsConnexion
Retour à la liste des salons ForumDusite

Vous n'êtes pas connu dans la base des utilisateurs du forum

"; $errmess = 1; } if ($errmess == 0) { while ($ver = mysql_fetch_object ($chop) ) { $password = $ver->pass; $nbmess = $ver->nb_mess; $id_poster = $ver->id; $dateunix = getdate(); $date = sprintf("%02.2d",$dateunix["mday"])."/".sprintf("%02.2d",$dateunix["mon"])."/".$dateunix["year"]; $poster = $ver->nom; } $titre = htmlentities($titre); $titre = str_replace("'","\'",$titre); $querytst = "SELECT id_message from message where id_salon = $id_salon and id_poster = $id_poster and titre = '$titre'"; $tstidem = mysql_query ($querytst); if(mysql_num_rows($tstidem)) {echo "Sujet existe déjà "; $errmess = 1; } //verif du mot de passe if ($password == $pass and $errmess == 0) { $id_salon = htmlentities($id_salon); $date = htmlentities($date); $message = htmlentities($message); $message = str_replace("'","\'",$message); $nouvomess= "INSERT into message (id_salon, id_poster, date, titre, message) VALUES ('".$id_salon."', '".$id_poster."', '".$date."', '".$titre."', '".$message."')"; @mysql_query($nouvomess); $idmsg = mysql_insert_id(); $namepage = 'ForumMsg'.$idmsg; $nouvpage = "INSERT INTO wa_pages (tag, time, body, body_r, owner, user, latest, handler, comment_on) VALUES "; $nouvpage .= "('".$namepage."', '2000-01-01 01:01:01', '**Retour aux Messages** ".$this->GetPageTag()."\n----\n{{affreponse idmsg=\"".$idmsg."\"}}', '', 'AdminForum', 'AdminForum', 'Y', 'page', '')"; @mysql_query ($nouvpage); $nouvpage = "INSERT INTO wa_acls VALUES ('".$namepage."', 'write', 'AdminForum')"; @mysql_query ($nouvpage); $nouvpage = "INSERT INTO wa_acls VALUES ('".$namepage."', 'read', '*')"; @mysql_query ($nouvpage); $nouvpage = "INSERT INTO wa_acls VALUES ('".$namepage."', 'comment', 'AdminForum')"; @mysql_query ($nouvpage); $nbmess = $nbmess + 1; $updatenbmess = "UPDATE user SET nb_mess=$nbmess WHERE id = $id_poster"; @mysql_query ($updatenbmess); echo "

Nouveau message envoyé

"; /* if ($nbmess>$grade2) { if ($nbmess>$grade3) { if ($nbmess>$grade4) { if ($nbmess>$grade5) { $updategrade2 = "UPDATE user SET grade=5 WHERE user.id = $id_poster"; @mysql_query ($updategrade2); } else { $updategrade2 = "UPDATE user SET grade=4 WHERE user.id = $id_poster"; @mysql_query ($updategrade2); } } else { $updategrade2 = "UPDATE user SET grade=3 WHERE user.id = $id_poster"; @mysql_query ($updategrade2); } } else { $updategrade2 = "UPDATE user SET grade=2 WHERE user.id = $id_poster"; @mysql_query ($updategrade2); } } */ } else { echo "

Mot de passe erronné

"; } } } else { unset($id_salon); $id_salon = $this->GetParameter("idsalon"); } $salonnom = "SELECT * FROM salon WHERE id_salon='$id_salon'"; $salonnom2 = mysql_query ($salonnom); $nomsal = mysql_result ($salonnom2, 0, "nom_salon"); $query1 = "SELECT message.id_message, message.titre, message.date, user.nom from message left JOIN user ON user.id= message.id_poster where message.id_salon=$id_salon order by message.id_message DESC"; $footeux = mysql_query ($query1); $nb = mysql_num_rows ($footeux); echo "

Salon : $nomsal

"; echo ''; echo ''; // declaration de requetes $i=0; while ($i < $nb) { $iidate = mysql_result($footeux,$i,"message.date"); $idmess = mysql_result($footeux,$i,"message.id_message"); $titre = mysql_result($footeux,$i,"message.titre"); $id_footeux = mysql_result($footeux,$i,"user.nom"); //on compte le nombre de réponses $compterep = "SELECT COUNT(*) AS REP FROM reponse WHERE id_message='$idmess'"; $compterep2= mysql_query ($compterep); $it = mysql_fetch_object ($compterep2); if(($i % 2) != 0) { $bg = 'frtext1'; } else { $bg = 'frtext2'; }; echo ''; $i = $i+1; } ?>
Sujet
Auteur
du Sujet
Nombre de
Réponse
Sujet
Posté le
'.$titre.''.$id_footeux.''.$it->REP.''.$iidate.'
FormOpen()); echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo '"; print($this->FormClose()); ?>
Pseudo     Poster un nouveau Sujet
Mot de passe
Sujet
Texte du message
'; // include "smil.php"; echo "