From 57472eab3c7b035392c6a5aa240593ecaa7d1ccf Mon Sep 17 00:00:00 2001 From: ilotterytea Date: Mon, 8 Dec 2025 21:53:36 +0500 Subject: upd: moved all /public/ files to the root folder --- public/emotesets.php | 164 --------------------------------------------------- 1 file changed, 164 deletions(-) delete mode 100644 public/emotesets.php (limited to 'public/emotesets.php') diff --git a/public/emotesets.php b/public/emotesets.php deleted file mode 100644 index 635f4c4..0000000 --- a/public/emotesets.php +++ /dev/null @@ -1,164 +0,0 @@ -query("SELECT * FROM emote_sets WHERE is_global = TRUE LIMIT 1", PDO::FETCH_ASSOC); - - if ($rows->rowCount()) { - $emote_set = $rows->fetch(); - } else { - generate_alert("/404.php", "Global emoteset is not found", 404); - exit; - } -} -// featured emoteset -else if ($id == "featured") { - $rows = $db->query("SELECT * FROM emote_sets WHERE is_featured = TRUE LIMIT 1", PDO::FETCH_ASSOC); - - if ($rows->rowCount()) { - $emote_set = $rows->fetch(); - } else { - generate_alert("/404.php", "Featured emoteset is not found", 404); - exit; - } -} -// connected emoteset -else if (isset($_GET["alias_id"])) { - $alias_id = $_GET["alias_id"]; - $platform = $_GET["platform"] ?? "twitch"; - - $stmt = $db->prepare("SELECT es.* FROM emote_sets es - INNER JOIN connections co ON co.alias_id = ? AND co.platform = ? - INNER JOIN acquired_emote_sets aes ON aes.user_id = co.user_id - WHERE aes.is_default = TRUE - "); - $stmt->execute([$alias_id, $platform]); - - if ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { - $emote_set = $row; - } else { - generate_alert("/404.php", "Emoteset is not found for alias ID $alias_id ($platform)", 404); - exit; - } -} -// specified emoteset -else if (!empty($id)) { - $stmt = $db->prepare("SELECT es.* FROM emote_sets es WHERE es.id = ?"); - $stmt->execute([$id]); - - if ($row = $stmt->fetch()) { - $emote_set = $row; - } else { - generate_alert("/404.php", "Emoteset ID $id is not found", 404); - exit; - } -} - -$user_id = $_SESSION["user_id"] ?? ""; -$emote_sets = null; - -// fetching emotes -if ($emote_set) { - $emote_set = Emoteset::from_array_extended($emote_set, $user_id, $db); -} elseif (!EMOTESET_PUBLIC_LIST) { - generate_alert("/404.php", "The public list of emotesets is disabled", 403); - exit; -} else { - $emote_sets = []; - foreach ($db->query("SELECT * FROM emote_sets", PDO::FETCH_ASSOC) as $row) { - array_push($emote_sets, Emoteset::from_array_extended($row, $user_id, $db)); - } -} - -if (CLIENT_REQUIRES_JSON) { - if ($emote_sets != null) { - json_response([ - "status_code" => 200, - "message" => null, - "data" => $emote_sets - ]); - exit; - } else if ($emote_set != null) { - json_response([ - "status_code" => 200, - "message" => null, - "data" => $emote_set - ]); - exit; - } else { - json_response([ - "status_code" => 404, - "message" => "Emoteset(s) not found", - "data" => null - ], 404); - exit; - } -} -?> - - - - - <?php - $title = match ($emote_set == null) { - true => count($emote_sets) . ' emotesets', - false => "Emoteset - {$emote_set->name}", - }; - - echo "$title - " . INSTANCE_NAME; - ?> - - - - - - -
-
- -
-
-
-
-
- -
- -
-
- emotes); - } else { - echo 'Nothing found...'; - } - ?> -
-
-
-
-
- - - \ No newline at end of file -- cgit v1.2.3