View file ajax/events/get.php

<?
include_once '../../sys/inc/start.php';
include_once '../../sys/inc/compress.php';
include_once '../../sys/inc/sess.php';
include_once '../../sys/inc/home.php';
include_once '../../sys/inc/settings.php';
include_once '../../sys/inc/db_connect.php';
include_once '../../sys/inc/ipua.php';
include_once '../../sys/inc/fnc.php';
include_once '../../sys/inc/user.php';

function sendJsonResponse($data) {
	header('Content-type: apllication/json');
	echo json_encode($data);
	exit;
}
$data = array('status' => 1);

if (!isset($user)) {
	$data['status'] = 0;
	sendJsonResponse($data);
}

$fr_count_all = mysql_result(mysql_query("SELECT COUNT(*) FROM `frends` WHERE `user` = '$user[id]' AND `i` = '1'"), 0);
$fr_count_online = mysql_result(mysql_query("SELECT COUNT(*) FROM `frends` INNER JOIN `user` ON `frends`.`frend` = `user`.`id` WHERE `frends`.`user` = '$user[id]' AND `frends`.`i` = '1' AND `user`.`date_last` > '".(time() - 600)."'"), 0);
$fr_count = $fr_count_all ? ($fr_count_online ? "<b>$fr_count_online</b>&nbsp;/&nbsp;" : NULL) . $fr_count_all : NULL;
$mail_count = 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);
$tape_count = mysql_result(mysql_query("SELECT COUNT(`read`) FROM `tape` WHERE `id_user` = '$user[id]' AND `read` = '0' "),0);
$dsc_count = mysql_result(mysql_query("SELECT COUNT(`count`) FROM `discussions` WHERE `id_user` = '$user[id]' AND `count` > '0' "),0);
$notif_count = mysql_result(mysql_query("SELECT COUNT(`read`) FROM `notification` WHERE `id_user` = '$user[id]' AND `read` = '0'"), 0);
$gst_count = mysql_result(mysql_query("SELECT COUNT(*) FROM `my_guests` WHERE `id_ank` = '$user[id]' AND `read`='1'"),0);
$marks_count = mysql_result(mysql_query("SELECT COUNT(*) FROM `gallery_rating` WHERE `avtor` = '$user[id]'  AND `read`='1'"),0);
$fr_count_new = mysql_result(mysql_query("SELECT COUNT(id) FROM `frends_new` WHERE `to` = '$user[id]'"), 0);

$data['events'] = array(
	'fr' => $fr_count, 
	'mail' => $mail_count, 
	'tape' => $tape_count, 
	'dsc' => $dsc_count, 
	'notif' => $notif_count, 
	'gst' => $gst_count, 
	'marks' => $marks_count, 
	'fr_new' => $fr_count_new
);
sendJsonResponse($data);
?>