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("INSERT INTO rate_cards (content_item_id, platform_id, placement_id, rate, media_format_id) VALUES (?, ?, ?, ?, ?)");
$stmt->execute([$_POST['content_item_id'], $_POST['platform_id'], $_POST['placement_id'], $_POST['rate'], $_POST['media_format_id']]);
}
// DELETE
elseif (isset($_POST['delete_rate'])) {
$pdo->prepare("DELETE FROM rate_cards WHERE id = ?")->execute([$_POST['id']]);
}
// EDIT - Removed max_quantity update
elseif (isset($_POST['edit_rate'])) {
$pdo->prepare("UPDATE rate_cards SET rate = ? WHERE id = ?")
->execute([$_POST['rate'], $_POST['id']]);
}
}
// Fetch Data
$items = $pdo->query("SELECT * FROM content_items ORDER BY type, name")->fetchAll();
$platforms = $pdo->query("SELECT * FROM platforms")->fetchAll();
$placements = $pdo->query("SELECT * FROM ad_placements")->fetchAll();
$formats = $pdo->query("SELECT * FROM media_formats ORDER BY format_name")->fetchAll();
$rates = $pdo->query("SELECT r.*, c.name as item_name, c.type, p.platform_name, a.placement_name, mf.format_name
FROM rate_cards r
JOIN content_items c ON r.content_item_id = c.id
JOIN platforms p ON r.platform_id = p.id
JOIN ad_placements a ON r.placement_id = a.id
JOIN media_formats mf ON r.media_format_id = mf.id
ORDER BY r.id DESC")->fetchAll();
?>