Моя стр'; /* ================================= Почта ================================= */ $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 ($k_new!=0 && $k_new_fav==0){ echo " +$k_new
Почта "; }else{ echo "
Почта"; } /* ================================= Лента ================================= */ $lenta = mysql_result(mysql_query("SELECT COUNT(*) FROM `tape` WHERE `id_user` = '$user[id]' AND `read` = '0' "),0); echo ""; $k_l = $lenta; if($k_l>0)echo " +$k_l"; echo "
Лента"; echo ""; /* ================================= Обсуждения ================================= */ $discuss = mysql_result(mysql_query("SELECT COUNT(`count`) FROM `discussions` WHERE `id_user` = '$user[id]' AND `count` > '0' "),0); // Обсуждения $k_l = $discuss; echo ""; if($k_l>0)echo " +$k_l"; echo "
Обсуждения"; echo ""; /* ================================= Уведомления ================================= */ $k_notif = mysql_result(mysql_query("SELECT COUNT(`read`) FROM `notification` WHERE `id_user` = '$user[id]' AND `read` = '0'"), 0); // Уведомления $k_l = $k_notif; if($k_l>0){ echo "+$k_l
Уведомления"; echo ""; } /* ================================= Друзья ================================= */ $k_f = mysql_result(mysql_query("SELECT COUNT(id) FROM `frends_new` WHERE `to` = '$user[id]' LIMIT 1"), 0); if ($k_f>0) echo "+$k_f
Друзья "; else echo '
Друзья'; /* ================================= Обновить ================================= */ echo '
Обновить'; }elseif ($_SERVER['PHP_SELF'] != '/aut.php' && $_SERVER['PHP_SELF'] != '/registration.php'){ echo ''; $tUlogin = '
'; echo '
Авторизация/Регистрация'; echo ''; }