fresh msg alert

[xblade]

why is this in 08 should be 09

[BamBam0077]

Deprecated Version

Code Select Expand


    if ($TBDEV['msg_alert'] && $msgalert && $CURUSER)
    {
      $res = mysql_query("SELECT COUNT(*) FROM messages WHERE receiver=" . $CURUSER["id"] . " && unread='yes'") or sqlerr(__FILE__,__LINE__);
      $arr = mysql_fetch_row($res);
      $unread = $arr[0];
    }


new version [=

Code Select Expand

   
  if ( isset($CURUSER) ) {
   if ( isset($TBDEV['msg_alert']) && $msgalert ) {
$res = mysqli_query("SELECT new_msg FROM messages WHERE receiver=".sqlesc($CURUSER['id'])." && unread_msg='yes') or mysqli_error(__FILE__, __LINE__);
while ( $arr = mysqli_fetch_row($res) ) {
$unread = $arr[0];
    }
   }
  }