chat_poll.php - master - streamlive/StreamLiveV8

chat_poll.php

28 строк1 KB

TwixoffStudio

Create: config.sample.php, ai_client.php, antibot.php, auth.php, bbcode.php, bbcode_toolbar.php, db.php, embed_helper.php, footer.php, functions.php, header.php, migrations.php, mini_player.php, oauth.php, rss.php, totp.php, index.php, cookies.php, privacy.php, terms.php, fix_charset.sql, 001_add_comments.sql, 002_add_forum.sql, 003_add_features.sql, 004_add_messaging.sql, 005_add_rtmp.sql, 006_add_antibot.sql, 007_add_broadcast_pause.sql, 008_add_broadcast_channels.sql, 009_add_channel_visibility.sql, schema.sql, broadcast_channels.php, channel.php, chat_delete.php, embed.php, news.php, profile.php, short_like.php, sitemap.xml.php, antibot_challenge.php, antibot_challenge_view.php, antibot_image.svg.php, antibot_verify.php, broadcast_channel.php, broadcast_post_poll.php, broadcast_post_send.php, catalog.php, channel_favorite.php, channel_like.php, channel_manage.php, channel-full.php, channel-pc.php, chat_ban.php, chat_poll.php, chat_send.php, check_stream_live.php, comment_add.php, comment_delete.php, dashboard.php, diagnose.php, docs.php, favorites.php, forum.php, forum_category.php, forum_new_thread.php, forum_thread.php, index.php, message_poll.php, message_send.php, messages.php, new_channel.php, now_playing.php, playerjs.js, README.md, robots.txt, shorts.php, smotrim.php, user_search.php, ai.php, channels.php, forum.php, index.php, moderation.php, oauth.php, rss.php, security.php, sources.php, update.php, users.php, _layout_end.php, _layout_start.php, style.css, 2fa_setup.php, 2fa_verify.php, login.php, logout.php, oauth_callback.php, oauth_start.php, register.php

12 июл 2026, 09:03

Верифицирован

12 июл 2026, 09:03af41ef1

<?php
require_once __DIR__ . '/includes/functions.php';
header('Content-Type: application/json');

$channelId = (int)($_GET['channel_id'] ?? 0);
$after = (int)($_GET['after'] ?? 0);

$stmt = db()->prepare(
  'SELECT cm.id, cm.user_id, u.username, cm.message, cm.is_deleted, cm.created_at
   FROM chat_messages cm JOIN users u ON u.id = cm.user_id
   WHERE cm.channel_id = ? AND cm.id > ? ORDER BY cm.id ASC LIMIT 50'
);
$stmt->execute([$channelId, $after]);
$rows = $stmt->fetchAll();

$messages = [];
$deleted = [];
foreach ($rows as $r) {
  if ($r['is_deleted']) { $deleted[] = (int)$r['id']; continue; }
  $messages[] = ['id' => (int)$r['id'], 'userId' => (int)$r['user_id'], 'username' => $r['username'], 'message' => $r['message']];
}

// Также проверим, не были ли удалены/забанены сообщения ниже after (на случай позднего удаления модератором)
$stmt = db()->prepare('SELECT id FROM chat_messages WHERE channel_id = ? AND is_deleted = 1 AND id <= ?');
$stmt->execute([$channelId, $after]);
foreach ($stmt->fetchAll() as $r) { $deleted[] = (int)$r['id']; }

echo json_encode(['messages' => $messages, 'deleted' => array_values(array_unique($deleted))]);