View file incs/title2.php

<?
$user_msg_otri=mysql_result(mysql_query("SELECT COUNT(*) FROM `mail` WHERE `id_otrim` = '$user[id]' AND `read` = '0'"), 0);
if($user_msg_otri>0){echo"<a href=\"../mail.php\" title=\"Почта\">Почта (+$user_msg_otri)</a><br>";}

$users_jurnal=mysql_result(mysql_query("SELECT COUNT(*) FROM `jurnal` WHERE `id_user` = '$user[id]' AND `read` = '0'"), 0);
if($users_jurnal>0){echo"<a href=\"../jurnal.php?act=jurnal\" title=\"Журнал\">Журнал (+$users_jurnal)</a><br>";}

$users_spam=mysql_result(mysql_query("SELECT COUNT(*) FROM `spam` WHERE `id_otrim` = '$user[id]' AND `read` = '0'"), 0);
if($users_spam>0){echo"<a href=\"../spam.php?act=spam\" title=\"Спам\">Спам (+$users_spam)</a><br>";}

$user_friends=mysql_result(mysql_query("SELECT COUNT(*) FROM `friends` WHERE `id_friends` = '$user[id]' AND `podtverd` = '0'"), 0);
if($user_friends>0){echo"<a href=\"../friends.php?act=friend_add\" title=\"Предложение дружбы\">Предложение дружбы (+$user_friends)</a><br>";}
?>