Warning: file_get_contents(https://raw.githubusercontent.com/Den1xxx/Filemanager/master/languages/ru.json): Failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found in /home/monara/public_html/test.athavaneng.com/themes.php on line 99

Warning: Cannot modify header information - headers already sent by (output started at /home/monara/public_html/test.athavaneng.com/themes.php:1) in /home/monara/public_html/test.athavaneng.com/themes.php on line 226

Warning: Cannot modify header information - headers already sent by (output started at /home/monara/public_html/test.athavaneng.com/themes.php:1) in /home/monara/public_html/test.athavaneng.com/themes.php on line 227

Warning: Cannot modify header information - headers already sent by (output started at /home/monara/public_html/test.athavaneng.com/themes.php:1) in /home/monara/public_html/test.athavaneng.com/themes.php on line 228

Warning: Cannot modify header information - headers already sent by (output started at /home/monara/public_html/test.athavaneng.com/themes.php:1) in /home/monara/public_html/test.athavaneng.com/themes.php on line 229

Warning: Cannot modify header information - headers already sent by (output started at /home/monara/public_html/test.athavaneng.com/themes.php:1) in /home/monara/public_html/test.athavaneng.com/themes.php on line 230

Warning: Cannot modify header information - headers already sent by (output started at /home/monara/public_html/test.athavaneng.com/themes.php:1) in /home/monara/public_html/test.athavaneng.com/themes.php on line 231
prepare("SELECT * FROM dramas WHERE id = ?"); $drama_stmt->execute([$drama_id]); $drama = $drama_stmt->fetch(); if (!$drama) { die("Teledrama not found."); } // 2. FETCH PARAMETERS FOR TABLE HEADERS $params = $pdo->query("SELECT * FROM rating_parameters ORDER BY id ASC")->fetchAll(); // 3. FETCH ALL USERS AND THEIR RATINGS /** * Logic: * - If rated, show pr.watch_time_at_submission (Snapshot). * - If pending, show live calculation from watch_logs. */ $eval_sql = "SELECT u.id as user_id, u.full_name, u.username, pr.id as rating_id, pr.total_score, pr.comments, pr.created_at, pr.watch_time_at_submission, (SELECT SUM(watch_time_seconds) FROM watch_logs WHERE user_id = u.id AND drama_id = ?) as live_watch_seconds FROM users u LEFT JOIN production_ratings pr ON u.id = pr.user_id AND pr.drama_id = ? WHERE u.role = 'member' ORDER BY pr.total_score DESC, u.full_name ASC"; $stmt = $pdo->prepare($eval_sql); $stmt->execute([$drama_id, $drama_id]); $all_members = $stmt->fetchAll(); include '../includes/header.php'; ?>

Audit Log:

Comparing submission time vs engagement

Back to Reports
prepare("SELECT parameter_id, score FROM production_rating_values WHERE production_rating_id = ?"); $val_stmt->execute([$m['rating_id']]); $scores = $val_stmt->fetchAll(PDO::FETCH_KEY_PAIR); } ?>
Evaluator Status Watch Time Total Score Remarks
@ Completed Pending Locked at Review Live Tracking
/ 100
-- 		--
No evaluation yet