Файл: upload/core/ajax/messages/state.php
Строк: 19
<?php
require_once ($_SERVER['DOCUMENT_ROOT'] . '/core/core.php');
$userId = intval($_GET['user']);
$data = [
"dialogs" => [],
"count" => 0,
"last" => []
];
// === 1. Непрочитанные по диалогам ===
$res = dbquery("
SELECT sender_id AS peer, COUNT(*) AS cnt
FROM messages
WHERE receiver_id = ? AND readed = 0
GROUP BY sender_id
", [$userId]);
while ($row = FetchAssoc($res)) {
$data["dialogs"][$row['peer']] = intval($row['cnt']);
$data["count"] += intval($row['cnt']);
}
// === 2. Последние сообщения ===
$res2 = dbquery("
SELECT
CASE WHEN sender_id = ? THEN receiver_id ELSE sender_id END AS peer,
k_text
FROM messages
WHERE sender_id = ? OR receiver_id = ?
ORDER BY id DESC
", [$userId, $userId, $userId]);
while ($row = FetchAssoc($res2)) {
$peer = $row['peer'];
if (!isset($data["last"][$peer])) {
$data["last"][$peer] = chars(bbnonmes($row['k_text']));
}
}
echo json_encode($data);