par
romuald » 27 févr. 2012, 14:33
Voici la partie message:
<?php
$topic_id = $_GET['topic_id'];
$requete = mysql_query('SELECT * FROM forum_topic WHERE id="'.$topic_id.'"');
$donnees = mysql_fetch_object($requete);
$topics_Scat = $donnees->Scat_id;
$requete2 = mysql_query('SELECT * FROM forum_scat WHERE id="'.$topics_Scat.'"');
$donnees2 = mysql_fetch_object($requete2);
$requete3 = mysql_query('SELECT * FROM forum_messages WHERE topic_id="'.$topic_id.'" LIMIT 1');
$donnees3 = mysql_fetch_object($requete3);
echo''
.'<div style="text-align:left;"><b>'
.'<a href="index.php?page=Forum">'.HOME.'</a>'
.' <span style="color:'.$_color[1].';">/</span> '
.'<a href="index.php?page=Forum&page_name=topics&scat='.$topics_Scat.'">'.$donnees2->titre.'</a>'
.' <span style="color:'.$_color[1].';">/</span> '
.'<a href="index.php?page=Forum&page_name=messages&topic_id='.$topic_id.'">'.$donnees3->titre.'</a>'
.'</b></div>'
;
function MessageRepondre() {
global $_color;
$requete = mysql_query('SELECT * FROM forum_messages WHERE topic_id="'.$_GET['topic_id'].'" ORDER by id ASC');
$donnees = mysql_fetch_object($requete);
echo'<br />'
.'<form name="form" method="post" action="index.php?page=Forum&page_name=messages&action=creat_message&topic_id='.$_GET['topic_id'].'">'
.'<table cellspacing="0" cellpadding="0" style="width:100%;text-align:center;">'
.'<tr>'
.'<td colspan="2" style="'.STYLE_TITRE.'padding-top:2px;padding-bottom:2px;">'
.'<b>'.REPONDRE.'</b>'
.'</td>'
.'</tr>'
.'<tr>'
.'<td style="border:1px solid '.$_color[2].';border-top:none;text-align:left;padding-top:5px;padding-bottom:5px;padding-left:5px;background-color:'.$_color[4].';">'
.'<b>'.TITRE.'</b>'
.'</td>'
.'<td align="left" style="border:1px solid '.$_color[2].';border-top:none;border-left:none;padding-top:3px;padding-bottom:3px;padding-left:10px;background-color:'.$_color[4].';">'
.'<input type="text" name="titre" value="Re : '.stripslashes($donnees->titre).'" size="50" />'
.'</td>'
.'</tr>'
.'<tr>'
.'<td valign="top" style="border:1px solid '.$_color[2].';border-top:none;text-align:left;padding-top:5px;padding-bottom:5px;padding-left:5px;background-color:'.$_color[3].';">'
.'<b>'.MESSAGE.'</b>'
.'<br />'
.'<div style="text-align:center;">'
.GetSmileys('contenue')
.'</div>'
.'</td>'
.'<td align="center" valign="top" style="border:1px solid '.$_color[2].';border-top:none;border-left:none;text-align:left;padding-top:5px;padding-bottom:5px;padding-left:10px;padding-right:10px;background-color:'.$_color[3].';">'
.'<br /><a href="JavaScript:Smiley(\'[url=http://]http://[/url]\', \'contenue\')"><img src="images/ccode/url.gif" alt="Lien" /></a>'
.'<a href="JavaScript:Smiley(\'[img]http://[/img]\', \'contenue\')"><img src="images/ccode/img.gif" alt="Image" /></a>'
.'<a href="JavaScript:Smiley(\' \', \'contenue\')"><img src="images/ccode/gras.gif" alt="Gras" /></a>'
.'<a href="JavaScript:Smiley(\'[center] [/center]\', \'contenue\')"><img src="images/ccode/center.gif" alt="Centrer" /></a>'
.'<a href="JavaScript:Smiley(\' \', \'contenue\')"><img src="images/ccode/italique.gif" alt="Italique" /></a>'
.'<a href="JavaScript:Smiley(\' \', \'contenue\')"><img src="images/ccode/souligner.gif" alt="Souligner" /></a>'
.'<a href="JavaScript:Smiley(\'[list] [/list]\', \'contenue\')"><img src="images/ccode/list.gif" alt="List à puces" /></a>'
.'<a href="JavaScript:Smiley(\'[bar] [/bar]\', \'contenue\')"><img src="images/ccode/bar.gif" alt="Barer" /></a>'
.'<select onchange="JavaScript:Smiley(this.value, \'contenue\')" style="margin-bottom:6px;">'
.'<option selected="selected" disabled="disabled">'.COULEUR.'</option>'
.'<option value="[rouge] [/rouge]">'.ROUGE.'</option>'
.'<option value="[blanc] [/blanc]">'.BLANC.'</option>'
.'<option value="[jaune] [/jaune]">'.JAUNE.'</option>'
.'<option value="[bleu] [/bleu]">'.BLEU.'</option>'
.'<option value="[violet] [/violet]">'.VIOLET.'</option>'
.'<option value="[orange] [/orange]">'.ORANGE.'</option>'
.'<option value="[rose] [/rose]">'.ROSE.'</option>'
.'<option value="[gris] [/gris]">'.GRIS.'</option>'
.'<option value="[brun] [/brun]">'.BRUN.'</option>'
.'</select>'
.'<br /><textarea name="contenue" rows="16" cols="45"></textarea>'
.'</td>'
.'</tr>'
.'<tr>'
.'<td colspan="2" align="center" style="border:1px solid '.$_color[2].';border-top:none;padding-top:4px;padding-bottom:4px;background-color:'.$_color[4].';">'
.'<input type="button" value="'.APERCU.'" onClick="JavaScript:Apercu(\'contenue\', \'\')" />'
.'<input type="submit" value="'.VALIDER.'" />'
.'</td>'
.'</tr>'
.'</table>'
.'</form>'
;
}
function MessageSauvegarder() {
$requete = mysql_query('SELECT * FROM forum_topic WHERE id="'.$_GET['topic_id'].'"');
$donnees = mysql_fetch_object($requete);
$topic_id = $_GET['topic_id'];
$en_titre = htmlentities(addslashes($_POST['titre']));
$en_message = htmlentities(addslashes($_POST['contenue']));
$en_date = time();
if(isset($_SESSION['pseudo']))
{
if($en_message != "" && $en_titre != "")
{
mysql_query('INSERT into forum_messages (topic_id, Scat_id, auteur, titre, message, date) VALUES ("'.$_GET['topic_id'].'", "'.$donnees->Scat_id.'", "'.$_SESSION['pseudo'].'", "'.$en_titre.'", "'.$en_message.'", "'.$en_date.'")');
mysql_query('UPDATE forum_topic SET date2="'.$en_date.'" WHERE id="'.$_GET['topic_id'].'"');
echo'<div style="text-align:center;"><b>'.MODIF_OK.'</b></div>';
Redirection(3000, 'index.php?page=Forum&page_name=messages&topic_id='.$_GET['topic_id']);
}
else
{
echo'<div style="text-align:center;"><b>'.ERREUR_200.'</b></div>';
Redirection(3000, 'index.php?page=Forum&page_name=messages&topic_id='.$_GET['topic_id']);
}
}
else
{
echo'<div style="text-align:center;"><b>'.ERREUR_700.'</b></div>';
Redirection(3000, 'index.php?page=Forum&page_name=messages&topic_id='.$_GET['topic_id']);
}
}
function MessageModifier() {
global $_color;
$requete = mysql_query('SELECT * FROM forum_messages WHERE id="'.$_GET['id'].'"');
$donnees = mysql_fetch_object($requete);
if(isset($_SESSION['lvl']) && ($_SESSION['lvl'] >= 2 || $_SESSION['pseudo'] == $donnees->auteur))
{
echo'<br />'
.'<form name="form" method="post" action="index.php?page=Forum&page_name=messages&action=save_modif&id='.$_GET['id'].'&topic_id='.$_GET['topic_id'].'">'
.'<table cellspacing="0" cellpadding="0" style="width:100%;text-align:center;">'
.'<tr>'
.'<td colspan="2" style="'.STYLE_TITRE.'padding-top:2px;padding-bottom:2px;">'
.'<b>'.MODIFIER.'</b>'
.'</td>'
.'</tr>'
.'<tr>'
.'<td style="border:1px solid '.$_color[2].';border-top:none;text-align:left;padding-top:5px;padding-bottom:5px;padding-left:5px;background-color:'.$_color[4].';">'
.'<b>'.TITRE.'</b>'
.'</td>'
.'<td align="left" style="border:1px solid '.$_color[2].';border-top:none;border-left:none;padding-top:3px;padding-bottom:3px;padding-left:10px;background-color:'.$_color[4].';">'
.'<input type="text" name="titre" value="'.stripslashes($donnees->titre).'" size="50" />'
.'</td>'
.'</tr>'
.'<tr>'
.'<td valign="top" style="border:1px solid '.$_color[2].';border-top:none;text-align:left;padding-top:5px;padding-bottom:5px;padding-left:5px;background-color:'.$_color[3].';">'
.'<b>'.MESSAGE.'</b>'
.'<br />'
.'<div style="text-align:center;">'
.GetSmileys('contenue')
.'</div>'
.'</td>'
.'<td align="center" valign="top" style="border:1px solid '.$_color[2].';border-top:none;border-left:none;text-align:left;padding-top:5px;padding-bottom:5px;padding-left:10px;padding-right:10px;background-color:'.$_color[3].';">'
.'<br /><a href="JavaScript:Smiley(\'[url=http://]http://[/url]\', \'contenue\')"><img src="images/ccode/url.gif" alt="Lien" /></a>'
.'<a href="JavaScript:Smiley(\'[img]http://[/img]\', \'contenue\')"><img src="images/ccode/img.gif" alt="Image" /></a>'
.'<a href="JavaScript:Smiley(\' \', \'contenue\')"><img src="images/ccode/gras.gif" alt="Gras" /></a>'
.'<a href="JavaScript:Smiley(\'[center] [/center]\', \'contenue\')"><img src="images/ccode/center.gif" alt="Centrer" /></a>'
.'<a href="JavaScript:Smiley(\' \', \'contenue\')"><img src="images/ccode/italique.gif" alt="Italique" /></a>'
.'<a href="JavaScript:Smiley(\' \', \'contenue\')"><img src="images/ccode/souligner.gif" alt="Souligner" /></a>'
.'<a href="JavaScript:Smiley(\'[list] [/list]\', \'contenue\')"><img src="images/ccode/list.gif" alt="List à puces" /></a>'
.'<a href="JavaScript:Smiley(\'[bar] [/bar]\', \'contenue\')"><img src="images/ccode/bar.gif" alt="Barer" /></a>'
.'<select onchange="JavaScript:Smiley(this.value, \'contenue\')" style="margin-bottom:6px;">'
.'<option selected="selected" disabled="disabled">'.COULEUR.'</option>'
.'<option value="[rouge] [/rouge]">'.ROUGE.'</option>'
.'<option value="[blanc] [/blanc]">'.BLANC.'</option>'
.'<option value="[jaune] [/jaune]">'.JAUNE.'</option>'
.'<option value="[bleu] [/bleu]">'.BLEU.'</option>'
.'<option value="[violet] [/violet]">'.VIOLET.'</option>'
.'<option value="[orange] [/orange]">'.ORANGE.'</option>'
.'<option value="[rose] [/rose]">'.ROSE.'</option>'
.'<option value="[gris] [/gris]">'.GRIS.'</option>'
.'<option value="[brun] [/brun]">'.BRUN.'</option>'
.'</select>'
.'<br /><textarea name="contenue" rows="16" cols="45">'.stripslashes($donnees->message).'</textarea>'
.'</td>'
.'</tr>'
.'<tr>'
.'<td colspan="2" align="center" style="border:1px solid '.$_color[2].';border-top:none;padding-top:4px;padding-bottom:4px;background-color:'.$_color[4].';">'
.'<input type="button" value="'.APERCU.'" onClick="JavaScript:Apercu(\'contenue\', \'\')" />'
.'<input type="submit" value="'.VALIDER.'" />'
.'</td>'
.'</tr>'
.'</table>'
.'</form>'
;
}
}
function MessageSauvegarderModif() {
$en_titre = htmlentities(addslashes($_POST['titre']));
$en_message = htmlentities(addslashes($_POST['contenue']));
if(isset($_SESSION['pseudo']))
{
if($en_message != "" && $en_titre != "")
{
mysql_query('UPDATE forum_messages SET titre="'.$en_titre.'", message="'.$en_message.'" WHERE id="'.$_GET['id'].'"');
echo'<div style="text-align:center;"><b>'.MODIF_OK.'</b></div>';
Redirection(3000, 'index.php?page=Forum&page_name=messages&topic_id='.$_GET['topic_id']);
}
else
{
echo'<div style="text-align:center;"><b>'.ERREUR_200.'</b></div>';
Redirection(3000, 'index.php?page=Forum&page_name=messages&topic_id='.$_GET['topic_id']);
}
}
else
{
echo'<div style="text-align:center;"><b>'.ERREUR_700.'</b></div>';
Redirection(3000, 'index.php?page=Forum&page_name=messages&topic_id='.$_GET['topic_id']);
}
}
function MessageSupprimer() {
if ($_SESSION['lvl'] >= 2)
{
echo '<div style="text-align:center;"><b>'.CONF_SUP.'<br /><a href="index.php?page=Forum&page_name=messages&action=valider_supprimer&id='.$_GET['id'].'&topic_id='.$_GET['topic_id'].'">'.OUI.'</a> <a href="index.php?page=Forum&page_name=messages&topic_id='.$_GET['topic_id'].'">'.NON.'</a></b></div><br /><br /><br />';
}
else
{
echo'<div style="text-align:center;"><b>'.ERREUR_701.'</b></div>';
Redirection(3000, 'index.php?page=Forum&page_name=messages&topic_id='.$_GET['topic_id']);
}
}
function MessageValiderSupprimer() {
if ($_SESSION['lvl'] >= 2)
{
mysql_query('DELETE FROM forum_messages WHERE id="'.$_GET['id'].'"');
echo'<div style="text-align:center;"><b>'.MODIF_OK.'</b></div>';
Redirection(3000, 'index.php?page=Forum&page_name=messages&topic_id='.$_GET['topic_id']);
}
else
{
echo'<div style="text-align:center;"><b>'.ERREUR_701.'</b></div>';
Redirection(3000, 'index.php?page=Forum&page_name=messages&topic_id='.$_GET['topic_id']);
}
}
function MessagesIndex() {
global $_color, $_config;
$limit_par_page = $_config->nb_messages_forum_par_pages;
$page_num=(isset($_GET['page_num']))?$_GET['page_num']-1:0;
$from = $page_num * $limit_par_page;
echo'<br />'
.'<table cellspacing="0" cellpadding="0" style="width:100%;text-align:center;">'
.'<tr>'
.'<th style="width:25%;'.STYLE_TITRE.'">'.AUTEUR.'</th>'
.'<th style="width:75%;'.STYLE_TITRE.'">'.MESSAGE.'</th>'
.'</tr>'
;
$azeeza = 1;
$azeeza2 = 1;
$color_num=1;
$requete = mysql_query('SELECT * FROM forum_messages WHERE topic_id="'.$_GET['topic_id'].'" ORDER by date LIMIT '.$from.', '.$limit_par_page);
while($donnees = mysql_fetch_object($requete))
{
$cocolor=($color_num == 1)?$_color[3]:$_color[4];
$requete2 = mysql_query('SELECT * FROM membres WHERE pseudo="'.$donnees->auteur.'"');
$donnees2 = mysql_fetch_object($requete2);
$url=($donnees2->avatard == "non" || empty($donnees2->avatard))?'<img src="images/no_avatar.gif" alt="" width="100" />':'<img src="'.$donnees2->avatard.'" alt="" width="100" />';
$date = date('d/m/Y', $donnees->date).' '.A.' '.date('H:i', $donnees->date);
$requete3 = mysql_query('SELECT COUNT(*) AS nb_entree FROM forum_messages WHERE auteur="'.$donnees->auteur.'"');
$nb_don = mysql_fetch_array($requete3);
$nb_post = $nb_don['nb_entree'];
echo''
.'<tr>'
.'<td style="background-color:'.$cocolor.';border:1px solid '.$_color[2].';border-top:none;border-right:none;padding:5px;vertical-align:top;">'
.'<b>'.str_replace(' ', ' ', $donnees->auteur).'</b>'
.'<br />'
;
if ($donnees2->lvl == 2)
{
echo'<font color="red">'.MODERATEUR.'</font>';
}
elseif ($donnees2->lvl == 3)
{
echo'<font color="red">'.ADMINISTRATEUR.'</font>';
}
else
{
echo'<b>'.MEMBRE.'</b>';
}
echo''
.'<br />'
.$url
.'<br />'
.MESSAGES.' : '.$nb_post
.'</td>'
.'<td valign="top" align="left" style="background-color:'.$cocolor.';border:1px solid '.$_color[2].';border-top:none;padding:5px;">'
;
if(isset($_SESSION['lvl']) && ($_SESSION['lvl'] >= 2 || $_SESSION['pseudo'] == $donnees->auteur))
{
echo '<a href="index.php?page=Forum&page_name=messages&action=modifier&topic_id='.$_GET['topic_id'].'&id='.$donnees->id.'"><img src="images/posticon.gif" alt="" /></a> ';
}
else
{
echo '<img src="images/posticon.gif" alt="" /> ';
}
echo'<b>'.stripslashes($donnees->titre).'</b>, '.POSTE_LE.' : <i>'.$date.'</i>';
if(isset($_SESSION['lvl']) && $_SESSION['lvl'] >= 2)
{
echo ' <a href="index.php?page=Forum&page_name=messages&action=supprimer&id='.$donnees->id.'&topic_id='.$_GET['topic_id'].'"><img src="images/del.gif" /></a>';
}
echo''
.'<br />'
.'<br />'
.Ccode(stripslashes($donnees->message)).'<br />'
.'</td>'
.'</tr>'
;
$color_num=($color_num == 2)?0:$color_num;
$color_num++;
}
echo'</table>';
$requete4 = mysql_query('SELECT COUNT(*) AS nb_msg FROM forum_messages WHERE topic_id="'.$_GET['topic_id'].'"');
$nb_msg2 = mysql_fetch_array($requete4);
$nb_msg = $nb_msg2['nb_msg'];
$nb_pages = ceil($nb_msg / $limit_par_page);
if($nb_pages != '')
{
echo''
.'<br />'
.'<div style="text-align:center;">'.PAGE.' :'
;
for($page_num=1;$page_num<=$nb_pages;$page_num++)
{
echo'<a href="index.php?page=Forum&page_name=messages&page_num='.$page_num.'&topic_id='.$_GET['topic_id'].'">'.$page_num.'</a>';
}
echo'</div>';
}
if(isset($_SESSION['pseudo']))
{
echo'<div style="text-align:right;"><a href="index.php?page=Forum&page_name=messages&action=repondre&topic_id='.$_GET['topic_id'].'""><b>'.REPONDRE.'</b></a>';
}
}
if(isset($_GET['action']))
{
switch($_GET['action'])
{
case 'repondre':
MessageRepondre();
break;
case 'creat_message':
MessageSauvegarder();
break;
case 'modifier':
MessageModifier();
break;
case 'save_modif':
MessageSauvegarderModif();
break;
case 'supprimer':
MessageSupprimer();
break;
case 'valider_supprimer':
MessageValiderSupprimer();
break;
default:
MessagesIndex();
break;
}
}
else
{
MessagesIndex();
}
?>
Voici la partie message:
[php]<?php
$topic_id = $_GET['topic_id'];
$requete = mysql_query('SELECT * FROM forum_topic WHERE id="'.$topic_id.'"');
$donnees = mysql_fetch_object($requete);
$topics_Scat = $donnees->Scat_id;
$requete2 = mysql_query('SELECT * FROM forum_scat WHERE id="'.$topics_Scat.'"');
$donnees2 = mysql_fetch_object($requete2);
$requete3 = mysql_query('SELECT * FROM forum_messages WHERE topic_id="'.$topic_id.'" LIMIT 1');
$donnees3 = mysql_fetch_object($requete3);
echo''
.'<div style="text-align:left;"><b>'
.'<a href="index.php?page=Forum">'.HOME.'</a>'
.' <span style="color:'.$_color[1].';">/</span> '
.'<a href="index.php?page=Forum&page_name=topics&scat='.$topics_Scat.'">'.$donnees2->titre.'</a>'
.' <span style="color:'.$_color[1].';">/</span> '
.'<a href="index.php?page=Forum&page_name=messages&topic_id='.$topic_id.'">'.$donnees3->titre.'</a>'
.'</b></div>'
;
function MessageRepondre() {
global $_color;
$requete = mysql_query('SELECT * FROM forum_messages WHERE topic_id="'.$_GET['topic_id'].'" ORDER by id ASC');
$donnees = mysql_fetch_object($requete);
echo'<br />'
.'<form name="form" method="post" action="index.php?page=Forum&page_name=messages&action=creat_message&topic_id='.$_GET['topic_id'].'">'
.'<table cellspacing="0" cellpadding="0" style="width:100%;text-align:center;">'
.'<tr>'
.'<td colspan="2" style="'.STYLE_TITRE.'padding-top:2px;padding-bottom:2px;">'
.'<b>'.REPONDRE.'</b>'
.'</td>'
.'</tr>'
.'<tr>'
.'<td style="border:1px solid '.$_color[2].';border-top:none;text-align:left;padding-top:5px;padding-bottom:5px;padding-left:5px;background-color:'.$_color[4].';">'
.'<b>'.TITRE.'</b>'
.'</td>'
.'<td align="left" style="border:1px solid '.$_color[2].';border-top:none;border-left:none;padding-top:3px;padding-bottom:3px;padding-left:10px;background-color:'.$_color[4].';">'
.'<input type="text" name="titre" value="Re : '.stripslashes($donnees->titre).'" size="50" />'
.'</td>'
.'</tr>'
.'<tr>'
.'<td valign="top" style="border:1px solid '.$_color[2].';border-top:none;text-align:left;padding-top:5px;padding-bottom:5px;padding-left:5px;background-color:'.$_color[3].';">'
.'<b>'.MESSAGE.'</b>'
.'<br />'
.'<div style="text-align:center;">'
.GetSmileys('contenue')
.'</div>'
.'</td>'
.'<td align="center" valign="top" style="border:1px solid '.$_color[2].';border-top:none;border-left:none;text-align:left;padding-top:5px;padding-bottom:5px;padding-left:10px;padding-right:10px;background-color:'.$_color[3].';">'
.'<br /><a href="JavaScript:Smiley(\'[url=http://]http://[/url]\', \'contenue\')"><img src="images/ccode/url.gif" alt="Lien" /></a>'
.'<a href="JavaScript:Smiley(\'[img]http://[/img]\', \'contenue\')"><img src="images/ccode/img.gif" alt="Image" /></a>'
.'<a href="JavaScript:Smiley(\' \', \'contenue\')"><img src="images/ccode/gras.gif" alt="Gras" /></a>'
.'<a href="JavaScript:Smiley(\'[center] [/center]\', \'contenue\')"><img src="images/ccode/center.gif" alt="Centrer" /></a>'
.'<a href="JavaScript:Smiley(\' \', \'contenue\')"><img src="images/ccode/italique.gif" alt="Italique" /></a>'
.'<a href="JavaScript:Smiley(\' \', \'contenue\')"><img src="images/ccode/souligner.gif" alt="Souligner" /></a>'
.'<a href="JavaScript:Smiley(\'[list] [/list]\', \'contenue\')"><img src="images/ccode/list.gif" alt="List à puces" /></a>'
.'<a href="JavaScript:Smiley(\'[bar] [/bar]\', \'contenue\')"><img src="images/ccode/bar.gif" alt="Barer" /></a>'
.'<select onchange="JavaScript:Smiley(this.value, \'contenue\')" style="margin-bottom:6px;">'
.'<option selected="selected" disabled="disabled">'.COULEUR.'</option>'
.'<option value="[rouge] [/rouge]">'.ROUGE.'</option>'
.'<option value="[blanc] [/blanc]">'.BLANC.'</option>'
.'<option value="[jaune] [/jaune]">'.JAUNE.'</option>'
.'<option value="[bleu] [/bleu]">'.BLEU.'</option>'
.'<option value="[violet] [/violet]">'.VIOLET.'</option>'
.'<option value="[orange] [/orange]">'.ORANGE.'</option>'
.'<option value="[rose] [/rose]">'.ROSE.'</option>'
.'<option value="[gris] [/gris]">'.GRIS.'</option>'
.'<option value="[brun] [/brun]">'.BRUN.'</option>'
.'</select>'
.'<br /><textarea name="contenue" rows="16" cols="45"></textarea>'
.'</td>'
.'</tr>'
.'<tr>'
.'<td colspan="2" align="center" style="border:1px solid '.$_color[2].';border-top:none;padding-top:4px;padding-bottom:4px;background-color:'.$_color[4].';">'
.'<input type="button" value="'.APERCU.'" onClick="JavaScript:Apercu(\'contenue\', \'\')" />'
.'<input type="submit" value="'.VALIDER.'" />'
.'</td>'
.'</tr>'
.'</table>'
.'</form>'
;
}
function MessageSauvegarder() {
$requete = mysql_query('SELECT * FROM forum_topic WHERE id="'.$_GET['topic_id'].'"');
$donnees = mysql_fetch_object($requete);
$topic_id = $_GET['topic_id'];
$en_titre = htmlentities(addslashes($_POST['titre']));
$en_message = htmlentities(addslashes($_POST['contenue']));
$en_date = time();
if(isset($_SESSION['pseudo']))
{
if($en_message != "" && $en_titre != "")
{
mysql_query('INSERT into forum_messages (topic_id, Scat_id, auteur, titre, message, date) VALUES ("'.$_GET['topic_id'].'", "'.$donnees->Scat_id.'", "'.$_SESSION['pseudo'].'", "'.$en_titre.'", "'.$en_message.'", "'.$en_date.'")');
mysql_query('UPDATE forum_topic SET date2="'.$en_date.'" WHERE id="'.$_GET['topic_id'].'"');
echo'<div style="text-align:center;"><b>'.MODIF_OK.'</b></div>';
Redirection(3000, 'index.php?page=Forum&page_name=messages&topic_id='.$_GET['topic_id']);
}
else
{
echo'<div style="text-align:center;"><b>'.ERREUR_200.'</b></div>';
Redirection(3000, 'index.php?page=Forum&page_name=messages&topic_id='.$_GET['topic_id']);
}
}
else
{
echo'<div style="text-align:center;"><b>'.ERREUR_700.'</b></div>';
Redirection(3000, 'index.php?page=Forum&page_name=messages&topic_id='.$_GET['topic_id']);
}
}
function MessageModifier() {
global $_color;
$requete = mysql_query('SELECT * FROM forum_messages WHERE id="'.$_GET['id'].'"');
$donnees = mysql_fetch_object($requete);
if(isset($_SESSION['lvl']) && ($_SESSION['lvl'] >= 2 || $_SESSION['pseudo'] == $donnees->auteur))
{
echo'<br />'
.'<form name="form" method="post" action="index.php?page=Forum&page_name=messages&action=save_modif&id='.$_GET['id'].'&topic_id='.$_GET['topic_id'].'">'
.'<table cellspacing="0" cellpadding="0" style="width:100%;text-align:center;">'
.'<tr>'
.'<td colspan="2" style="'.STYLE_TITRE.'padding-top:2px;padding-bottom:2px;">'
.'<b>'.MODIFIER.'</b>'
.'</td>'
.'</tr>'
.'<tr>'
.'<td style="border:1px solid '.$_color[2].';border-top:none;text-align:left;padding-top:5px;padding-bottom:5px;padding-left:5px;background-color:'.$_color[4].';">'
.'<b>'.TITRE.'</b>'
.'</td>'
.'<td align="left" style="border:1px solid '.$_color[2].';border-top:none;border-left:none;padding-top:3px;padding-bottom:3px;padding-left:10px;background-color:'.$_color[4].';">'
.'<input type="text" name="titre" value="'.stripslashes($donnees->titre).'" size="50" />'
.'</td>'
.'</tr>'
.'<tr>'
.'<td valign="top" style="border:1px solid '.$_color[2].';border-top:none;text-align:left;padding-top:5px;padding-bottom:5px;padding-left:5px;background-color:'.$_color[3].';">'
.'<b>'.MESSAGE.'</b>'
.'<br />'
.'<div style="text-align:center;">'
.GetSmileys('contenue')
.'</div>'
.'</td>'
.'<td align="center" valign="top" style="border:1px solid '.$_color[2].';border-top:none;border-left:none;text-align:left;padding-top:5px;padding-bottom:5px;padding-left:10px;padding-right:10px;background-color:'.$_color[3].';">'
.'<br /><a href="JavaScript:Smiley(\'[url=http://]http://[/url]\', \'contenue\')"><img src="images/ccode/url.gif" alt="Lien" /></a>'
.'<a href="JavaScript:Smiley(\'[img]http://[/img]\', \'contenue\')"><img src="images/ccode/img.gif" alt="Image" /></a>'
.'<a href="JavaScript:Smiley(\' \', \'contenue\')"><img src="images/ccode/gras.gif" alt="Gras" /></a>'
.'<a href="JavaScript:Smiley(\'[center] [/center]\', \'contenue\')"><img src="images/ccode/center.gif" alt="Centrer" /></a>'
.'<a href="JavaScript:Smiley(\' \', \'contenue\')"><img src="images/ccode/italique.gif" alt="Italique" /></a>'
.'<a href="JavaScript:Smiley(\' \', \'contenue\')"><img src="images/ccode/souligner.gif" alt="Souligner" /></a>'
.'<a href="JavaScript:Smiley(\'[list] [/list]\', \'contenue\')"><img src="images/ccode/list.gif" alt="List à puces" /></a>'
.'<a href="JavaScript:Smiley(\'[bar] [/bar]\', \'contenue\')"><img src="images/ccode/bar.gif" alt="Barer" /></a>'
.'<select onchange="JavaScript:Smiley(this.value, \'contenue\')" style="margin-bottom:6px;">'
.'<option selected="selected" disabled="disabled">'.COULEUR.'</option>'
.'<option value="[rouge] [/rouge]">'.ROUGE.'</option>'
.'<option value="[blanc] [/blanc]">'.BLANC.'</option>'
.'<option value="[jaune] [/jaune]">'.JAUNE.'</option>'
.'<option value="[bleu] [/bleu]">'.BLEU.'</option>'
.'<option value="[violet] [/violet]">'.VIOLET.'</option>'
.'<option value="[orange] [/orange]">'.ORANGE.'</option>'
.'<option value="[rose] [/rose]">'.ROSE.'</option>'
.'<option value="[gris] [/gris]">'.GRIS.'</option>'
.'<option value="[brun] [/brun]">'.BRUN.'</option>'
.'</select>'
.'<br /><textarea name="contenue" rows="16" cols="45">'.stripslashes($donnees->message).'</textarea>'
.'</td>'
.'</tr>'
.'<tr>'
.'<td colspan="2" align="center" style="border:1px solid '.$_color[2].';border-top:none;padding-top:4px;padding-bottom:4px;background-color:'.$_color[4].';">'
.'<input type="button" value="'.APERCU.'" onClick="JavaScript:Apercu(\'contenue\', \'\')" />'
.'<input type="submit" value="'.VALIDER.'" />'
.'</td>'
.'</tr>'
.'</table>'
.'</form>'
;
}
}
function MessageSauvegarderModif() {
$en_titre = htmlentities(addslashes($_POST['titre']));
$en_message = htmlentities(addslashes($_POST['contenue']));
if(isset($_SESSION['pseudo']))
{
if($en_message != "" && $en_titre != "")
{
mysql_query('UPDATE forum_messages SET titre="'.$en_titre.'", message="'.$en_message.'" WHERE id="'.$_GET['id'].'"');
echo'<div style="text-align:center;"><b>'.MODIF_OK.'</b></div>';
Redirection(3000, 'index.php?page=Forum&page_name=messages&topic_id='.$_GET['topic_id']);
}
else
{
echo'<div style="text-align:center;"><b>'.ERREUR_200.'</b></div>';
Redirection(3000, 'index.php?page=Forum&page_name=messages&topic_id='.$_GET['topic_id']);
}
}
else
{
echo'<div style="text-align:center;"><b>'.ERREUR_700.'</b></div>';
Redirection(3000, 'index.php?page=Forum&page_name=messages&topic_id='.$_GET['topic_id']);
}
}
function MessageSupprimer() {
if ($_SESSION['lvl'] >= 2)
{
echo '<div style="text-align:center;"><b>'.CONF_SUP.'<br /><a href="index.php?page=Forum&page_name=messages&action=valider_supprimer&id='.$_GET['id'].'&topic_id='.$_GET['topic_id'].'">'.OUI.'</a> <a href="index.php?page=Forum&page_name=messages&topic_id='.$_GET['topic_id'].'">'.NON.'</a></b></div><br /><br /><br />';
}
else
{
echo'<div style="text-align:center;"><b>'.ERREUR_701.'</b></div>';
Redirection(3000, 'index.php?page=Forum&page_name=messages&topic_id='.$_GET['topic_id']);
}
}
function MessageValiderSupprimer() {
if ($_SESSION['lvl'] >= 2)
{
mysql_query('DELETE FROM forum_messages WHERE id="'.$_GET['id'].'"');
echo'<div style="text-align:center;"><b>'.MODIF_OK.'</b></div>';
Redirection(3000, 'index.php?page=Forum&page_name=messages&topic_id='.$_GET['topic_id']);
}
else
{
echo'<div style="text-align:center;"><b>'.ERREUR_701.'</b></div>';
Redirection(3000, 'index.php?page=Forum&page_name=messages&topic_id='.$_GET['topic_id']);
}
}
function MessagesIndex() {
global $_color, $_config;
$limit_par_page = $_config->nb_messages_forum_par_pages;
$page_num=(isset($_GET['page_num']))?$_GET['page_num']-1:0;
$from = $page_num * $limit_par_page;
echo'<br />'
.'<table cellspacing="0" cellpadding="0" style="width:100%;text-align:center;">'
.'<tr>'
.'<th style="width:25%;'.STYLE_TITRE.'">'.AUTEUR.'</th>'
.'<th style="width:75%;'.STYLE_TITRE.'">'.MESSAGE.'</th>'
.'</tr>'
;
$azeeza = 1;
$azeeza2 = 1;
$color_num=1;
$requete = mysql_query('SELECT * FROM forum_messages WHERE topic_id="'.$_GET['topic_id'].'" ORDER by date LIMIT '.$from.', '.$limit_par_page);
while($donnees = mysql_fetch_object($requete))
{
$cocolor=($color_num == 1)?$_color[3]:$_color[4];
$requete2 = mysql_query('SELECT * FROM membres WHERE pseudo="'.$donnees->auteur.'"');
$donnees2 = mysql_fetch_object($requete2);
$url=($donnees2->avatard == "non" || empty($donnees2->avatard))?'<img src="images/no_avatar.gif" alt="" width="100" />':'<img src="'.$donnees2->avatard.'" alt="" width="100" />';
$date = date('d/m/Y', $donnees->date).' '.A.' '.date('H:i', $donnees->date);
$requete3 = mysql_query('SELECT COUNT(*) AS nb_entree FROM forum_messages WHERE auteur="'.$donnees->auteur.'"');
$nb_don = mysql_fetch_array($requete3);
$nb_post = $nb_don['nb_entree'];
echo''
.'<tr>'
.'<td style="background-color:'.$cocolor.';border:1px solid '.$_color[2].';border-top:none;border-right:none;padding:5px;vertical-align:top;">'
.'<b>'.str_replace(' ', ' ', $donnees->auteur).'</b>'
.'<br />'
;
if ($donnees2->lvl == 2)
{
echo'<font color="red">'.MODERATEUR.'</font>';
}
elseif ($donnees2->lvl == 3)
{
echo'<font color="red">'.ADMINISTRATEUR.'</font>';
}
else
{
echo'<b>'.MEMBRE.'</b>';
}
echo''
.'<br />'
.$url
.'<br />'
.MESSAGES.' : '.$nb_post
.'</td>'
.'<td valign="top" align="left" style="background-color:'.$cocolor.';border:1px solid '.$_color[2].';border-top:none;padding:5px;">'
;
if(isset($_SESSION['lvl']) && ($_SESSION['lvl'] >= 2 || $_SESSION['pseudo'] == $donnees->auteur))
{
echo '<a href="index.php?page=Forum&page_name=messages&action=modifier&topic_id='.$_GET['topic_id'].'&id='.$donnees->id.'"><img src="images/posticon.gif" alt="" /></a> ';
}
else
{
echo '<img src="images/posticon.gif" alt="" /> ';
}
echo'<b>'.stripslashes($donnees->titre).'</b>, '.POSTE_LE.' : <i>'.$date.'</i>';
if(isset($_SESSION['lvl']) && $_SESSION['lvl'] >= 2)
{
echo ' <a href="index.php?page=Forum&page_name=messages&action=supprimer&id='.$donnees->id.'&topic_id='.$_GET['topic_id'].'"><img src="images/del.gif" /></a>';
}
echo''
.'<br />'
.'<br />'
.Ccode(stripslashes($donnees->message)).'<br />'
.'</td>'
.'</tr>'
;
$color_num=($color_num == 2)?0:$color_num;
$color_num++;
}
echo'</table>';
$requete4 = mysql_query('SELECT COUNT(*) AS nb_msg FROM forum_messages WHERE topic_id="'.$_GET['topic_id'].'"');
$nb_msg2 = mysql_fetch_array($requete4);
$nb_msg = $nb_msg2['nb_msg'];
$nb_pages = ceil($nb_msg / $limit_par_page);
if($nb_pages != '')
{
echo''
.'<br />'
.'<div style="text-align:center;">'.PAGE.' :'
;
for($page_num=1;$page_num<=$nb_pages;$page_num++)
{
echo'<a href="index.php?page=Forum&page_name=messages&page_num='.$page_num.'&topic_id='.$_GET['topic_id'].'">'.$page_num.'</a>';
}
echo'</div>';
}
if(isset($_SESSION['pseudo']))
{
echo'<div style="text-align:right;"><a href="index.php?page=Forum&page_name=messages&action=repondre&topic_id='.$_GET['topic_id'].'""><b>'.REPONDRE.'</b></a>';
}
}
if(isset($_GET['action']))
{
switch($_GET['action'])
{
case 'repondre':
MessageRepondre();
break;
case 'creat_message':
MessageSauvegarder();
break;
case 'modifier':
MessageModifier();
break;
case 'save_modif':
MessageSauvegarderModif();
break;
case 'supprimer':
MessageSupprimer();
break;
case 'valider_supprimer':
MessageValiderSupprimer();
break;
default:
MessagesIndex();
break;
}
}
else
{
MessagesIndex();
}
?>[/php]