<?php
/*
Зоны:
1 - весь сайт(блок)
Причины:
1 - Грубость и оскорбления
2 - СПАМ, реклама
3 - Педофилия
4 - Иное
*/
class Remark {
static function add($user_id, $zone, $active_time, $moder, $comment, $reason, $inf = false) {
$time = time();
// Для бесконечного блока
if($inf) {
$stmt = DB::getInstance()->prepare("
UPDATE `users` SET `die` = 1 WHERE `id` = ? LIMIT 1
");
$stmt->bind_param('i', $user_id);
$stmt->execute();
$stmt->close();
}
# Отправляем запрос на добавление
$stmt = DB::getInstance()->prepare("
INSERT INTO `remarks` (`user_id`, `zone`, `active_time`, `moder`, `comment`, `reason`, `add_time`)
VALUES (?, ?, ?, ?, ?, ?, ?)
");
$stmt->bind_param('iiiisii', $user_id, $zone, $active_time, $moder, $comment, $reason, $time);
$stmt->execute();
$remark_id = $stmt->insert_id;
$stmt->close();
UserCounter::up($user_id, 'remarks', 1);
return $remark_id;
}
static function del($remark_id) {
$stmt = DB::getInstance()->prepare("
DELETE FROM `remarks` WHERE `id` = ?
");
$stmt->bind_param('i', $remark_id);
$stmt->execute();
$stmt->close();
}
static function getInfo($remark_id) {
$result = DB::getInstance() -> query("
SELECT * FROM `remarks` WHERE `id` = '{$remark_id}' LIMIT 1
");
$data = $result->fetch_assoc();
if(!empty($data)) return $data;
else return false;
}
static function getList($user_id) {
$result = DB::getInstance() -> query("
SELECT `id`, `zone`, `add_time`, `active_time` FROM `remarks`
WHERE `user_id` = {$user_id} ORDER BY `id` DESC
");
$remarks = [];
while($row = $result -> fetch_assoc()) $remarks[] = $row;
return $remarks;
}
static function getActiveBlock($user_id) {
$time = time();
$result = DB::getInstance() -> query("
SELECT * FROM `remarks`
WHERE `user_id` = {$user_id} AND `zone` = 1 AND `active_time` > {$time} - `add_time`
ORDER BY `id` DESC LIMIT 1
");
$data = $result->fetch_assoc();
if(!empty($data)) return $data;
else return false;
}
static function zone($zone) {
switch($zone) {
case 1: return 'Блок';
}
}
static function reason($reason) {
switch($reason) {
case 1: return 'Грубость и оскорбления';
case 2: return 'СПАМ, реклама';
case 3: return 'Педофилия';
case 4: return 'Иное';
}
}
static function isActive($add_time, $active_time) {
return (time() - $add_time > $active_time) ? false : true;
}
static function leftTime($add_time, $active_time) {
return $active_time - (time() - $add_time);
}
}
?>