comment_delete.php - master - TwixoffStudio/stliveprod

comment_delete.php

29 строк1 KB

TwixoffStudio

Create: login.php, logout.php, oauth_callback.php, oauth_start.php, register.php, config.sample.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, index.php, fix_charset.sql, 001_add_comments.sql, 002_add_forum.sql, schema.sql, catalog.php, channel.php, channel_manage.php, chat_ban.php, chat_delete.php, chat_poll.php, chat_send.php, comment_add.php, comment_delete.php, dashboard.php, diagnose.php, embed.php, forum.php, forum_category.php, forum_new_thread.php, forum_thread.php, index.php, new_channel.php, now_playing.php, README.md, shorts.php, channels.php, forum.php, index.php, moderation.php, oauth.php, sources.php, update.php, users.php, _layout_end.php, _layout_start.php, style.css

09 июл 2026, 01:37

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

09 июл 2026, 01:377cdfd3d

<?php
require_once __DIR__ . '/includes/auth.php';
$user = require_login();
csrf_verify();

$commentId = (int)($_POST['comment_id'] ?? 0);
$channelId = (int)($_POST['channel_id'] ?? 0);

$stmt = db()->prepare('SELECT * FROM channels WHERE id = ?');
$stmt->execute([$channelId]);
$channel = $stmt->fetch();

if ($channel && is_channel_moderator($channelId, $user['id'])) {
  $stmt = db()->prepare('SELECT user_id FROM comments WHERE id = ? AND channel_id = ?');
  $stmt->execute([$commentId, $channelId]);
  $comment = $stmt->fetch();

  if ($comment) {
    db()->prepare('UPDATE comments SET is_deleted = 1 WHERE id = ? AND channel_id = ?')->execute([$commentId, $channelId]);

    // Автора удалённого комментария блокируем на канале целиком (чат + сама страница канала).
    // Владельца канала (если он вдруг удаляет свой же комментарий) не баним.
    if ((int)$comment['user_id'] !== (int)$channel['owner_id']) {
      db()->prepare('INSERT IGNORE INTO chat_bans (channel_id, user_id) VALUES (?, ?)')->execute([$channelId, $comment['user_id']]);
    }
  }
}

redirect('/channel.php?slug=' . ($channel['slug'] ?? '') . '#comments');