"; $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); // Почта $lenta = mysql_result(mysql_query("SELECT COUNT(`read`) FROM `tape` WHERE `id_user` = '$user[id]' AND `read` = '0' "),0); // Лента $discuss = mysql_result(mysql_query("SELECT COUNT(`count`) FROM `discussions` WHERE `id_user` = '$user[id]' AND `count` > '0' "),0); // Обсуждения $k_frend = mysql_result(mysql_query("SELECT COUNT(id) FROM `frends_new` WHERE `to` = '$user[id]'"), 0); // Друзья $k_notif = mysql_result(mysql_query("SELECT COUNT(`read`) FROM `notification` WHERE `id_user` = '$user[id]' AND `read` = '0'"), 0); // Уведомления /* ================================= Страничка ================================= */ echo ""; echo "
S
"; echo ""; /* ================================= Почта ================================= */ echo ""; if ($k_new!=0 && $k_new_fav==0) { echo "
$k_new"; echo "($k_new)
"; }else{ echo "
S
"; } echo ""; /* ================================= Лента ================================= */ if ($lenta > 0) { $j2 = 'tape'; } elseif ($discuss > 0) { $j2 = 'discussions'; } elseif ($k_notif > 0) { $j2 = 'notification'; }else{ $j2 = 'tape'; } echo ""; echo "
S"; $k_l = $lenta+$k_notif+$discuss; if($k_l>0)echo "($k_l)"; echo "
"; echo ""; /* ================================= Друзья ================================= */ if ($k_frend > 0) { echo ""; echo "
S($k_frend)
"; echo ""; } /* ================================= Обновить ================================= */ echo ""; echo '
S
'; echo ""; echo ""; } } } ?>