File size: 2.3Kb
<?php defined('ACCESS') OR die('No direct script access...');
/**
* Author - koder_alex
* ISQ - 669906617
* VK - https://vk.com/koder_alex
* It is forbidden to give, sell, modify.
*/
$data = array();
if (isset($_POST['peer']) && is_numeric($_POST['peer']) && mysql_result(mysql_query("SELECT COUNT(id) FROM user WHERE `id` = '".(int) $_POST['peer']."'", $db), 0))
$peer = d_user((int) $_POST['peer'], false);
else
$peer = d_user(0, false);
if($peer['date_last'] > ($time - 600) && $user['id'] != $peer['id'])
{
$data['read'] = true;
if(mysql_result(mysql_query("SELECT COUNT(id) FROM user WHERE `vkTypingId` = '$user[id]' AND `vkTypingLastTime` > '".($time - 5)."' AND `id` = '".$peer['id']."'"), 0))
$data['typing'] = true;
if(mysql_result(mysql_query("SELECT COUNT(id) FROM `mail` WHERE `read` = '0' AND `id_kont` = '$peer[id]' AND `id_user` = '$user[id]'"), 0))
$data['read'] = false;
$data['message'] = array();
$q = mysql_query("SELECT *, (SELECT COUNT(id) FROM mail_important WHERE `id_user` = '$user[id]' and `id_mail` = m.id LIMIT 1) as important FROM `mail` AS m WHERE m.`read` = '0' AND (m.`id_user` = '".$peer['id']."' and m.`id_kont` = '".$user['id']."') AND m.unlink != '$peer[id]' ORDER BY m.`id` DESC");
$i = 0;
if(mysql_num_rows($q))
{
while ($post = mysql_fetch_assoc($q))
{
$d = d_user($post['id_user'], true, 'mi_img');
$data['message'][$i]['mess']['mi_unread'] = "";
$data['message'][$i]['mess']['id'] = $post['id'];
$data['message'][$i]['mess']['time'] = vremja($post['time']);
$data['message'][$i]['mess']['msg'] = output_text($post['msg']);
$data['message'][$i]['user']['id_user'] = $d['id'];
$data['message'][$i]['user']['nick'] = $d['nick'];
$data['message'][$i]['user']['group'] = $d['group'];
$data['message'][$i]['user']['online'] = $d['online'];
$data['message'][$i]['user']['medal'] = $d['medal'];
$data['message'][$i]['user']['avatar'] = $d['avatar'];
if($post['attachments'])
{
ob_start();
showAttachments($post['id']);
$data['message'][$i]['mess']['attachments'] = ob_get_contents();
ob_end_clean();
}
$i++;
}
mysql_query("UPDATE `mail` SET `read` = '1' WHERE `id_kont` = '$user[id]' AND `id_user` = '$peer[id]'");
}
}
setData($data);