Мини-хак сообщений о новой почте

/*
-----------------------------------------------------------------
Ссылки на непрочитанное
-----------------------------------------------------------------
*/
if ($user_id) {
    $list = array();
    $new_sys_mail = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_mail` WHERE `from_id`='$user_id' AND `read`='0' AND `sys`='1' AND `delete`!='$user_id';"), 0);
if ($new_sys_mail) $list[] = '<a href="' . $home . '/mail/index.php?act=systems">Система</a> (+' . $new_sys_mail . ')';
$new_mail = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_mail` LEFT JOIN `cms_contact` ON `cms_mail`.`user_id`=`cms_contact`.`from_id` AND `cms_contact`.`user_id`='$user_id' WHERE `cms_mail`.`from_id`='$user_id' AND `cms_mail`.`sys`='0' AND `cms_mail`.`read`='0' AND `cms_mail`.`delete`!='$user_id' AND `cms_contact`.`ban`!='1' AND `cms_mail`.`spam`='0'"), 0);
if ($new_mail) $list[] = '<a href="' . $home . '/mail/index.php?act=new">' . $lng['mail'] . '</a> (+' . $new_mail . ')';
    if ($datauser['comm_count'] > $datauser['comm_old']) $list[] = '<a href="' . core::$system_set['homeurl'] . '/users/profile.php?act=guestbook&amp;user=' . $user_id . '">' . $lng['guestbook'] . '</a> (' . ($datauser['comm_count'] - $datauser['comm_old']) . ')';
    $new_album_comm = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_album_files` WHERE `user_id` = '" . core::$user_id . "' AND `unread_comments` = 1"), 0);
    if ($new_album_comm) $list[] = '<a href="' . core::$system_set['homeurl'] . '/users/album.php?act=top&amp;mod=my_new_comm">' . $lng['albums_comments'] . '</a>';

    if (!empty($list)) echo '<div class="rmenu">' . $lng['unread'] . ': ' . functions::display_menu($list, ', ') . '</div>';
}

/*
-----------------------------------------------------------------
Ссылки на непрочитанное
-----------------------------------------------------------------
*/
if ($user_id) {
    $list = array();
    $new_sys_mail = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_mail` WHERE `from_id`='$user_id' AND `read`='0' AND `sys`='1' AND `delete`!='$user_id';"), 0);
if ($new_sys_mail) $list[] = '<a href="'. $home .'/mail/index.php?act=systems">Система</a> (+'. $new_sys_mail .')';
$new_mail = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_mail` LEFT JOIN `cms_contact` ON `cms_mail`.`user_id`=`cms_contact`.`from_id` AND `cms_contact`.`user_id`='$user_id' WHERE `cms_mail`.`from_id`='$user_id' AND `cms_mail`.`sys`='0' AND `cms_mail`.`read`='0' AND `cms_mail`.`delete`!='$user_id' AND `cms_contact`.`ban`!='1' AND `cms_mail`.`spam`='0'"), 0);
if ($new_mail) {
        function sendName() {
            global $user_id, $start, $kmess;
            $out = [];
        $query = mysql_query("SELECT `users`.* FROM `cms_mail`
        LEFT JOIN `users` ON `cms_mail`.`user_id`=`users`.`id`
        LEFT JOIN `cms_contact` ON `cms_mail`.`user_id`=`cms_contact`.`user_id`
        WHERE `cms_mail`.`from_id`='" . $user_id . "' AND `cms_mail`.`read`='0' AND `cms_mail`.`spam`='0' 
                GROUP BY `cms_mail`.`user_id` ORDER BY `cms_contact`.`time` DESC LIMIT " . $start . "," . $kmess
            );
        while ($row = mysql_fetch_assoc($query)) {
        $new_cnt_mess = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_mail` WHERE `cms_mail`.`user_id`='{$row['id']}' 
                    AND `cms_mail`.`from_id`='$user_id' AND `read`='0' AND `delete`!='$user_id' AND `spam`='0';"), 0);
        $cnt_mess = ($new_cnt_mess ? '<span style="font-size:xx-small; vertical-align:super; color:red;">+'. 
                    $new_cnt_mess .'</span>' : '');
                $out[] = ($row['imname'] ? $row['imname'] : $row['name']) . $cnt_mess;
        }
            return implode(', ', $out);
        }
        $list[] = '<a style="text-decoration:none;" href="'. $home .'/mail/index.php?act=new">'. 
            sendName() .'</a> (<b>+'. $new_mail .'</b>)';
}
    if ($datauser['comm_count'] > $datauser['comm_old']) $list[] = '<a href="'. core::$system_set['homeurl'] .'/users/profile.php?act=guestbook&amp;user='. $user_id .'">'. $lng['guestbook'] .'</a> ('. ($datauser['comm_count'] - $datauser['comm_old']) .')';
    $new_album_comm = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_album_files` WHERE `user_id` = '". core::$user_id ."' AND `unread_comments` = 1"), 0);
    if ($new_album_comm) $list[] = '<a href="'. core::$system_set['homeurl'] .'/users/album.php?act=top&amp;mod=my_new_comm">'. $lng['albums_comments'] .'</a>';

    if (!empty($list)) 
        echo '<div class="rmenu"><img style="vertical-align:-5px; margin: -7px 0 -7px 0;" src="http://'. 
            $_SERVER['SERVER_NAME'] .'/images/usmail.png" /> '. functions::display_menu($list, ', ') .'</div>';
}