Просмотр поста

$url1=''; //путь до иконки "Системы"
$url2=''; //путь до иконки "Почта"
if ($user_id) {
$pochta = 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) $pochta[] = '<a href="' . $home . '/mail/index.php?act=systems"><img src="'.$url1.'" alt="."/></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) $pochta[] = '<a href="' . $home . '/mail/index.php?act=new"><img src="'.$url2.'" alt="."/></a> (+' . $new_mail . ')';
if (!empty($pochta)) echo '<span class="rmenu">' . functions::display_menu($pochta, ', ') . '</span>';
}