Retour à la liste des salons ForumDusite
// include "graphisme.php";
if ($_REQUEST["action"] == "addmess")
{
$id_salon = $_POST["id_salon"];
$pseudo = $_POST["pseudo"];
$pass = $_POST["pass"];
$titre = $_POST["titre"];
$message = $_POST["message"];
$errmess = 0;
if (empty($pseudo)) { echo "Veuillez entrer un pseudo "; $errmess = 1; }
if (empty($titre)) { echo "Veuillez entrer un titre "; $errmess = 1; }
if (empty($message)) { echo "Veuillez entrer un message "; $errmess = 1; }
$verif_login = "SELECT * FROM user where nom = '$pseudo'";
$chop = mysql_query ($verif_login);
$i = 0;
//Y a til un user à ce nom là?
$nbbb =mysql_num_rows($chop);
//on recup les données utilisateur
if ($nbbb == 0) { echo "
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 'Sujet
| Auteur du Sujet | Nombre de Réponse | Sujet Posté le |
';
// 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 '| '.$titre.' | '.$id_footeux.' | '.$it->REP.' | '.$iidate.' |
';
$i = $i+1;
}
?>