From f496c838d202e16f65b6efa6207b877f0596ae1e Mon Sep 17 00:00:00 2001
From: ilotterytea <iltsu@alright.party>
Date: Mon, 21 Apr 2025 16:18:49 +0500
Subject: feat: emote removal

---
 public/emotes/add.php      | 67 ----------------------------------
 public/emotes/setmanip.php | 89 ++++++++++++++++++++++++++++++++++++++++++++++
 src/emotes/single_page.php | 26 +++++++-------
 3 files changed, 102 insertions(+), 80 deletions(-)
 delete mode 100644 public/emotes/add.php
 create mode 100644 public/emotes/setmanip.php

diff --git a/public/emotes/add.php b/public/emotes/add.php
deleted file mode 100644
index 33e8c06..0000000
--- a/public/emotes/add.php
+++ /dev/null
@@ -1,67 +0,0 @@
-<?php
-include_once "../../src/config.php";
-include "../../src/accounts.php";
-include "../../src/alert.php";
-
-if (!authorize_user(true)) {
-    return;
-}
-
-$db = new PDO(DB_URL, DB_USER, DB_PASS);
-
-// checking emote
-$emote_id = $_POST["id"];
-$stmt = $db->prepare("SELECT id FROM emotes WHERE id = ?");
-$stmt->execute([$emote_id]);
-if ($stmt->rowCount() == 0) {
-    generate_alert("/emotes/$emote_id", "Emote not found", 404);
-    exit;
-}
-
-$user_id = $_SESSION["user_id"];
-
-// obtaining or creating a emote set
-$stmt = $db->prepare("SELECT emote_set_id FROM acquired_emote_sets WHERE user_id = ? AND is_default = true");
-$stmt->execute([$user_id]);
-$emote_set_id = null;
-
-if ($row = $stmt->fetch()) {
-    $emote_set_id = $row["emote_set_id"];
-
-    // checking ownership
-    $stmt = $db->prepare("SELECT id FROM emote_sets WHERE id = ? AND owner_id = ?");
-    $stmt->execute([$emote_set_id, $user_id]);
-
-    if ($stmt->rowCount() == 0) {
-        $_SESSION["user_emote_set_id"] = "";
-        generate_alert("/emotes/$emote_id", "Bad ownership permissions on active emoteset", 403);
-        exit;
-    }
-}
-
-if ($emote_set_id == null) {
-    $stmt = $db->prepare("INSERT INTO emote_sets(owner_id, name) VALUES (?, ?)");
-    $stmt->execute([$user_id, $_SESSION["user_name"] . "'s emoteset"]);
-    $emote_set_id = $db->lastInsertId();
-
-    $stmt = $db->prepare("INSERT INTO acquired_emote_sets(user_id, emote_set_id, is_default) VALUES (?, ?, true)");
-    $stmt->execute([$user_id, $emote_set_id]);
-}
-
-$_SESSION["user_emote_set_id"] = $emote_set_id;
-
-// inserting emote
-$stmt = $db->prepare("SELECT id FROM emote_set_contents WHERE emote_set_id = ? AND emote_id = ?");
-$stmt->execute([$emote_set_id, $emote_id]);
-
-if ($stmt->rowCount() != 0) {
-    generate_alert("/emotes/$emote_id", "This emote has been already added!");
-    exit;
-}
-
-$stmt = $db->prepare("INSERT INTO emote_set_contents(emote_set_id, emote_id, added_by) VALUES (?, ?, ?)");
-$stmt->execute([$emote_set_id, $emote_id, $user_id]);
-
-$db = null;
-
-generate_alert("/emotes/$emote_id", "This emote has been added to your set. Enjoy!", 200);
\ No newline at end of file
diff --git a/public/emotes/setmanip.php b/public/emotes/setmanip.php
new file mode 100644
index 0000000..2c5d577
--- /dev/null
+++ b/public/emotes/setmanip.php
@@ -0,0 +1,89 @@
+<?php
+include_once "../../src/config.php";
+include "../../src/accounts.php";
+include "../../src/alert.php";
+
+if (!authorize_user(true)) {
+    return;
+}
+
+if (!isset($_POST["id"], $_POST["action"])) {
+    generate_alert("/emotes/$emote_id", "Not enough POST fields");
+    exit;
+}
+
+$db = new PDO(DB_URL, DB_USER, DB_PASS);
+
+// checking emote
+$emote_id = $_POST["id"];
+$stmt = $db->prepare("SELECT id FROM emotes WHERE id = ?");
+$stmt->execute([$emote_id]);
+if ($stmt->rowCount() == 0) {
+    generate_alert("/emotes/$emote_id", "Emote not found", 404);
+    exit;
+}
+
+$user_id = $_SESSION["user_id"];
+
+// obtaining or creating a emote set
+$stmt = $db->prepare("SELECT emote_set_id FROM acquired_emote_sets WHERE user_id = ? AND is_default = true");
+$stmt->execute([$user_id]);
+$emote_set_id = null;
+
+if ($row = $stmt->fetch()) {
+    $emote_set_id = $row["emote_set_id"];
+
+    // checking ownership
+    $stmt = $db->prepare("SELECT id FROM emote_sets WHERE id = ? AND owner_id = ?");
+    $stmt->execute([$emote_set_id, $user_id]);
+
+    if ($stmt->rowCount() == 0) {
+        $_SESSION["user_emote_set_id"] = "";
+        generate_alert("/emotes/$emote_id", "Bad ownership permissions on active emoteset", 403);
+        exit;
+    }
+}
+
+if ($emote_set_id == null) {
+    $stmt = $db->prepare("INSERT INTO emote_sets(owner_id, name) VALUES (?, ?)");
+    $stmt->execute([$user_id, $_SESSION["user_name"] . "'s emoteset"]);
+    $emote_set_id = $db->lastInsertId();
+
+    $stmt = $db->prepare("INSERT INTO acquired_emote_sets(user_id, emote_set_id, is_default) VALUES (?, ?, true)");
+    $stmt->execute([$user_id, $emote_set_id]);
+}
+
+$_SESSION["user_emote_set_id"] = $emote_set_id;
+
+// inserting emote
+$stmt = $db->prepare("SELECT id FROM emote_set_contents WHERE emote_set_id = ? AND emote_id = ?");
+$stmt->execute([$emote_set_id, $emote_id]);
+
+$action = $_POST["action"];
+
+if ($action == "add") {
+    if ($stmt->rowCount() != 0) {
+        generate_alert("/emotes/$emote_id", "This emote has been already added!");
+        exit;
+    }
+
+    $stmt = $db->prepare("INSERT INTO emote_set_contents(emote_set_id, emote_id, added_by) VALUES (?, ?, ?)");
+    $stmt->execute([$emote_set_id, $emote_id, $user_id]);
+
+    $db = null;
+
+    generate_alert("/emotes/$emote_id", "This emote has been added to your set. Enjoy!", 200);
+} else {
+    if ($row = $stmt->fetch()) {
+        $stmt = $db->prepare("DELETE FROM emote_set_contents WHERE id = ?");
+        $stmt->execute([$row["id"]]);
+    } else {
+        generate_alert("/emotes/$emote_id", "This emote wasn't added!");
+        $db = null;
+        exit;
+    }
+
+    $db = null;
+
+    generate_alert("/emotes/$emote_id", "This emote has been removed from your set.", 200);
+}
\ No newline at end of file
diff --git a/src/emotes/single_page.php b/src/emotes/single_page.php
index b76fda8..3fa0a30 100644
--- a/src/emotes/single_page.php
+++ b/src/emotes/single_page.php
@@ -50,21 +50,21 @@ include_once "../../src/config.php";
 
                                 $db = null;
                                 ?>
-                                <?php
-                                if ($added) { ?>
-                                    <form action="/emotes/remove.php" method="POST">
-                                        <input type="text" name="id" value="<?php echo $emote->get_id() ?>"
-                                            style="display: none;">
+                                <form action="/emotes/setmanip.php" method="POST">
+                                    <input type="text" name="id" value="<?php echo $emote->get_id() ?>"
+                                        style="display: none;">
+                                    <?php
+                                    if ($added) { ?>
+                                        <input type="text" name="action" value="remove" style="display: none;">
                                         <button type="submit" class="red">Remove from my channel</button>
-                                    </form><?php
-                                } else { ?>
-                                    <form action="/emotes/add.php" method="POST">
-                                        <input type="text" name="id" value="<?php echo $emote->get_id() ?>"
-                                            style="display: none;">
+                                        <?php
+                                    } else { ?>
+                                        <input type="text" name="action" value="add" style="display: none;">
                                         <button type="submit" class="green">Add to my channel</button>
-                                    </form><?php
-                                }
-                                ?>
+                                        <?php
+                                    }
+                                    ?>
+                                </form>
                             </div>
                             <div class="items row right full">
                                 <form action="/emotes/rate.php" method="POST">
-- 
cgit v1.2.3