52 AND id_forum = ".$idforum;
$rs_temp = mysqli_query($cxConn, $sql) or die(mysqli_error($cxConn));
$data = mysqli_fetch_array($rs_temp); $nb_points = $data["somme_points"]; mysqli_free_result($rs_temp);
$sql = "SELECT COUNT(id) AS nb_MP FROM mutu_sportytrader.indexprive WHERE lu=0 AND id=".$idforum;
$rs_temp = mysqli_query($cxConn, $sql) or die(mysqli_error($cxConn));
$data = mysqli_fetch_array($rs_temp); $nb_MP = $data["nb_MP"]; mysqli_free_result($rs_temp);
//date et heure de la dérnière notification de MP pour le membre connécté
$sql = "SELECT date FROM sportytrader.membres_notifs WHERE idMembre = ".$idforum." AND idGroupNotif = 7";
$rs=mysqli_query($cxConn, $sql) or die(mysqli_error($cxConn));
if (mysqli_num_rows($rs)>0) { $r = mysqli_fetch_row($rs); $date=$r[0]; } else $date="";
//création des notifications de MP
//Le membre X vous a envoyé un Message privé => lien vers page MP
/*$sql_membre = " SELECT t.date, IF(p.dest<>i.pseudo,i_dest.id,i_auteur.id), t.id
FROM mutu_sportytrader.threadprive t
INNER JOIN mutu_sportytrader.prive p ON t.numeropost = p.numeropost
INNER JOIN mutu_sportytrader.inscrit i On i.id = t.id
LEFT OUTER JOIN mutu_sportytrader.inscrit i_dest On i_dest.pseudo = p.dest
LEFT OUTER JOIN mutu_sportytrader.inscrit i_auteur On i_auteur.pseudo = p.auteur
WHERE p.dest <> t.id
AND IF(p.dest<>i.pseudo,i_dest.id,i_auteur.id) = ".$idforum."
".($date!=""?"AND t.date > '".$date."'":"")."
ORDER BY t.date DESC";
$rs_membre = mysql_query($sql_membre, $cxConn) or die($sql_membre."
".mysql_error());
while($r = mysql_fetch_row($rs_membre))
{
$sql = "SELECT id FROM sportytrader.membres_notifs WHERE idMembre = ".$r[1]." AND date = '".$r[0]."' AND idGroupNotif = 7 AND idActeur = ".$r[2];
$rs=mysql_query($sql, $cxConn) or die($sql."
".mysql_error());
if (mysql_num_rows($rs)==0)
{
if ($r[1]!=$r[2])
{
$sql = "INSERT INTO sportytrader.membres_notifs (idMembre,date,idGroupNotif,idActeur) VALUES (".$r[1].",'".$r[0]."',7,".$r[2].")";
mysql_query($sql, $cxConn) or die($sql."
".mysql_error());
}
}
}
mysql_free_result($rs_membre);*/
//notifications désactivées par le membre
$desactiv_notif="0";
$sql = "SELECT idGroupNotif FROM sportytrader.membres_notifs_gestion WHERE idMembre = ".$idforum;
$rs_temp = mysqli_query($cxConn, $sql) or die(mysqli_error($cxConn));
while($rs = mysqli_fetch_object($rs_temp)) $desactiv_notif .= ",".$rs->idGroupNotif;
mysqli_free_result($rs_temp);
//nombre de notification pas vues et pas supprimées
$sql = "SELECT smn.id FROM sportytrader.membres_notifs smn
INNER JOIN sportytrader.notifications sn ON sn.idGroup = smn.idGroupNotif
WHERE sn.active = 1 AND sn.etat = 1 AND sn.LCID = 1036 AND smn.vu = 0 AND smn.supr = 0 AND smn.idMembre = ".$idforum." AND sn.idGroup NOT IN (".$desactiv_notif.")";
$rs_notifs = mysqli_query($cxConn, $sql) or die(mysqli_error($cxConn));
$nb_notifs = mysqli_num_rows($rs_notifs);
//récupération des 10 dérnières notifications qu'elles soient vu ou non (sans les notifications supprimées bien entendu)
$sql = "SELECT smn.*,sn.intitule AS notification, sn.icone AS logo, sn.lien_actif AS lien_actif
FROM sportytrader.membres_notifs smn
INNER JOIN sportytrader.notifications sn ON sn.idGroup = smn.idGroupNotif
LEFT OUTER JOIN sportytrader.membres_public smp ON smp.id_forum = smn.idActeur
WHERE sn.active = 1 AND sn.etat = 1 AND sn.LCID = 1036 AND smn.supr = 0 AND smn.idMembre = ".$idforum." AND sn.idGroup NOT IN (".$desactiv_notif.")
AND smp.LCID IN (NULL,1036)
ORDER BY smn.date DESC
LIMIT 10";
$rs_notifs = mysqli_query($cxConn, $sql) or die(mysqli_error($cxConn));
?>
 |
|
|
 |
".$_SESSION["menu_connection_message_erreur"].""; unset($_SESSION["menu_connection_message_erreur"]); }
if (isset($_COOKIE["menu_connection_message_erreur"])) { echo "
".MyStripSlashes_gpc($_COOKIE["menu_connection_message_erreur"])."
"; unset($_COOKIE["menu_connection_message_erreur"]); } ?>
".MyStripSlashes_gpc($_COOKIE["menu_connection_message_erreur"])."
Profil
Publier
Parrainer
Compte
