File size: 746B
<?php
include_once getenv('DOCUMENT_ROOT') . '/sys/inc/ajaxRequest.php';
exit(json_encode(
mysql_fetch_assoc(mysql_query(
"SELECT" .
"(SELECT COUNT(*) FROM `mail` AS m,
(SELECT MAX(id) AS id FROM `mail` WHERE `unlink` != '$user[id]' AND (`id_kont` = '$user[id]') GROUP BY IF(`id_user` = '$user[id]', `id_kont`, `id_user`)) as max
WHERE m.id = max.id AND m.read = '0' AND (m.id_kont = '$user[id]') AND m.unlink != '$user[id]') as knew, " .
"(SELECT COUNT(*) FROM `groups_users` WHERE `id_user` = '".$user['id']."' AND `st` = '2') as k_group, " .
"(SELECT COUNT(id) FROM `frends_new` WHERE `to` = '$user[id]') as k_friend, " .
"(SELECT COUNT(`read`) FROM `notifi` WHERE `id_user` = '$user[id]' AND `read` = '0') as knotifi"
))
));
?>