1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
| private function ForumLu($id)
{
if(isset($_SESSION['logged']) && $_SESSION['logged']===true)
{
$sql = 'SELECT * FROM `s_sujet`
LEFT JOIN `s_membres` ON `mbm_id`='.$_SESSION['id'].'
WHERE `s_f`='.$id.'';
$req = mysql_query($sql) or die('Erreur SQL : '.$sql.'<br />'.mysql_error());
while ($res = mysql_fetch_object($req)) {
if($res->mbm_inscrit < $res->s_date)
{
$sql2 = 'SELECT * FROM `s_lu` WHERE `lu_auteur`='.$_SESSION['id'].' AND `lu_s`='.$res->s_id.'';
$req2 = mysql_query($sql2) or die('Erreur SQL : '.$sql2.'<br />'.mysql_error());
$res2 = mysql_fetch_object($req2);
if($res2->lu_mess != $res->s_mess)
{
return 0;
}
}
else
{
return 1;
}
}
return 1;
}
else
{
return 1;
}
} |