comments_poll.php - master - alosouser/StreamLive-V29Fork

comments_poll.php

37 строк1 KB

TwixoffStudio

Create: watch_room_chat_poll.php, watch_room_poll.php, forum-live.js, hits-guard.js, push-notify.js, footer.php, poll_throttle.php, api_notifications_poll.php, broadcast_post_poll.php, chat_poll.php, comments_poll.php, FOOTER_ADD.txt, forum_poll.php, message_poll.php, footer.php, poll_throttle.php, forum-live.js, hits-guard.js, push-notify.js, apple-touch-icon.png, icon-128.png, icon-144.png, icon-152.png, icon-192.png, icon-384.png, icon-512.png, icon-72.png, icon-96.png, background.js, icon-128.png, icon-16.png, icon-32.png, icon-48.png, manifest.json, options.html, options.js, extension_build.php, extension_top_link.php, footer.php, header.php, pwa_head.php, pwa_register.php, extension.php, extension_download.php, INSTALL.txt, manifest.json, manifest.webmanifest, offline.html, platform_unavailable.html, sw.js

06 авг 2026, 15:10

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

06 авг 2026, 15:105670f35

<?php
if (is_file(__DIR__."/includes/poll_throttle.php")) { require_once __DIR__."/includes/poll_throttle.php"; poll_throttle("comments_poll", 180); }

if (is_file(__DIR__ . '/includes/poll_throttle.php')) {
  require_once __DIR__ . '/includes/poll_throttle.php';
  poll_throttle('comments_poll', 60);
}

/**
 * Автообновление комментариев канала (вкладка открыта).
 * GET channel_id, after (comment id)
 */
require_once __DIR__ . '/includes/functions.php';
require_once __DIR__ . '/includes/auth.php';
header('Content-Type: application/json; charset=utf-8');
header('Cache-Control: no-store');

$channelId = (int)($_GET['channel_id'] ?? 0);
$after = (int)($_GET['after'] ?? 0);
if ($channelId <= 0) {
  echo json_encode(['ok' => false, 'comments' => []]);
  exit;
}

try {
  $st = db()->prepare(
    'SELECT cm.id, cm.message, cm.created_at, u.username, u.is_verified
     FROM comments cm JOIN users u ON u.id = cm.user_id
     WHERE cm.channel_id = ? AND cm.is_deleted = 0 AND cm.id > ?
     ORDER BY cm.id ASC LIMIT 50'
  );
  $st->execute([$channelId, $after]);
  $rows = $st->fetchAll();
  echo json_encode(['ok' => true, 'comments' => $rows], JSON_UNESCAPED_UNICODE);
} catch (Throwable $e) {
  echo json_encode(['ok' => false, 'comments' => []]);
}