Pan Private Messages - новые личные сообщения (Page 2 of 3)

function pan_pm_get_unread_msg()
{
   global $forum_db, $forum_user;
   
   $unread_msg = array();
   $query = array(
      'SELECT'   => 'id, status',
      'FROM'      => 'pan_pm',
      'WHERE'      => 'receiver_id='.$forum_user['id']
   );
   
   $result = $forum_db->query_build($query) or error(__FILE__, __LINE__);
   while ($rows = $forum_db->fetch_assoc($result)) {
      if ($rows['status'] == 'sent')
         $unread_msg[] = $rows['id'];
   }

   return $unread_msg;
}

function pan_notify_get_pun_pm_new_msg()
{
   global $forum_db, $forum_user;

   if ($forum_db->table_exists('pun_pm_messages'))
   {
      $query = array(
         'SELECT'   => 'COUNT(pm.id)',
         'FROM'      => 'pun_pm_messages AS pm',
//         'WHERE'      => 'pm.read_at=0 AND pm.receiver_id='.$forum_user['id']
         'WHERE'      => 'pm.read_at=0 AND pm.deleted_by_receiver=0 AND pm.receiver_id='.$forum_user['id']
      );
      $result = $forum_db->query_build($query) or error(__FILE__, __LINE__);
      $pm_msgs = $forum_db->result($result);

      return $pm_msgs;
   }
}

'WHERE'      => 'receiver_id='.$forum_user['id']

'WHERE'      => 'receiver_id='.$forum_user['id'].' AND deleted_by_receiver=0'