Файл: sys/fnc/aut2.php
Строк: 35
<?
function aut2()
{
global $set;
if ($set['web']==false)
{
global $user;
if (isset($user))
{
$k_new=mysql_result(mysql_query("SELECT COUNT(`mail`.`id`) FROM `mail`
LEFT JOIN `users_konts` ON `mail`.`id_user` = `users_konts`.`id_kont` AND `users_konts`.`id_user` = '$user[id]'
WHERE `mail`.`id_kont` = '$user[id]' AND (`users_konts`.`type` IS NULL OR `users_konts`.`type` = 'common' OR `users_konts`.`type` = 'favorite') AND `mail`.`read` = '0'"),0);
$k_new_fav=mysql_result(mysql_query("SELECT COUNT(`mail`.`id`) FROM `mail`
LEFT JOIN `users_konts` ON `mail`.`id_user` = `users_konts`.`id_kont` AND `users_konts`.`id_user` = '$user[id]'
WHERE `mail`.`id_kont` = '$user[id]' AND (`users_konts`.`type` = 'favorite') AND `mail`.`read` = '0'"),0);
################################################################################
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `frends_new` WHERE `to` = '$user[id]' LIMIT 1"), 0) > 0)
{
echo '<a href="/my.php">Дружба!</a><br />';
}
################################################################################
if ($k_new!=0 && $k_new_fav==0)
echo "Новых писем (<a href='/new_mess.php'>$k_new<img src='/style/mail.gif' alt='-' /></a>)<br />";
$nj=mysql_result(mysql_query("SELECT COUNT(*) FROM `blog_jurnal` WHERE `id_kont` = '$user[id]' AND `read` = '0'"), 0);
if ($nj>0)echo "Журнал $user[nick] (<a href='/pages/blog_jurnal.php'>$nj</a>)<br />n";
}
else
{
################################################################################
echo "<a href='/aut.php'>Вход</a> <a href='/reg.php'>Регистрация</a><br />n";
}
}
}
?>