phpBB.de

Code: Alles auswählen

if ( ($userdata['session_logged_in']) && (empty($gen_simple_header)) )
{
   if ( $userdata['user_new_privmsg'] )
   {
      $l_privmsgs_new_in = $userdata['user_new_privmsg'];

      if ( $userdata['user_last_privmsg'] > $userdata['user_lastvisit'] )
      {
         $sql = "UPDATE " . USERS_TABLE . "
            SET user_last_privmsg = " . $userdata['user_lastvisit'] . "
            WHERE user_id = " . $userdata['user_id'];
         if ( !$db->sql_query($sql) )
         {
            message_die(GENERAL_ERROR, 'Could not update private message new/read time for user', '', __LINE__, __FILE__, $sql);
         }

         $s_privmsg_new = 1;
         $icon_pm = $images['pm_new_msg'];
      }
      else
      {
         $s_privmsg_new = 0;
         $icon_pm = $images['pm_new_msg'];
      }
   }
   else
   {
      $l_privmsgs_new_in = "0";

      $s_privmsg_new = 0;
      $icon_pm = $images['pm_no_new_msg'];
   }

   if ( $userdata['user_unread_privmsg'] )
   {
      $l_message_unread = $userdata['user_unread_privmsg'];
   }
   else
   {
      $l_message_unread = "0";
   }

   $l_message_read_sql = mysql_query("Select * FROM " . PRIVMSGS_TABLE . " WHERE privmsgs_to_userid =  " . $userdata['user_id'] . " AND privmsgs_type = " . PRIVMSGS_READ_MAIL );
   $l_message_read = mysql_num_rows($l_message_read_sql);

   $l_message_send_sql = mysql_query("Select * FROM " . PRIVMSGS_TABLE . " WHERE privmsgs_from_userid =  " . $userdata['user_id'] . " AND privmsgs_type = " . PRIVMSGS_SENT_MAIL );
   $l_message_send = mysql_num_rows($l_message_send_sql);

   $l_message_unsend_sql = mysql_query("Select * FROM " . PRIVMSGS_TABLE . " WHERE privmsgs_from_userid = " . $userdata['user_id'] . " AND ( privmsgs_type = " . PRIVMSGS_NEW_MAIL . " OR privmsgs_type = " . PRIVMSGS_UNREAD_MAIL .")");
   $l_message_unsend = mysql_num_rows($l_message_unsend_sql);
   
   $l_message_saved_sql = mysql_query("Select * FROM " . PRIVMSGS_TABLE . " WHERE ( ( privmsgs_to_userid = " . $userdata['user_id'] . " AND privmsgs_type = " . PRIVMSGS_SAVED_IN_MAIL . " )
            OR ( privmsgs_from_userid = " . $userdata['user_id'] . "
               AND privmsgs_type = " . PRIVMSGS_SAVED_OUT_MAIL . " ) )");
   $l_message_saved = mysql_num_rows($l_message_saved_sql);
   
   $l_privmsgs_text = "N: $l_privmsgs_new_in, U: $l_message_unread, PE: $l_message_read, G: $l_message_send, PA: $l_message_unsend, A: $l_message_saved";
}