summaryrefslogtreecommitdiff
path: root/public/system/emotes
diff options
context:
space:
mode:
authorilotterytea <iltsu@alright.party>2025-05-02 18:35:09 +0500
committerilotterytea <iltsu@alright.party>2025-05-02 18:35:09 +0500
commit0c25e3dd54225b126ad8e48e10f4fbde8ce26ec5 (patch)
treedb7fc3d7c73f96a236eafd12c4255b1835ab3cdd /public/system/emotes
parent9c7e8c24f8273f70d743ae44034a01da352a88e9 (diff)
feat: emote approval
Diffstat (limited to 'public/system/emotes')
-rw-r--r--public/system/emotes/index.php155
-rw-r--r--public/system/emotes/manip.php76
2 files changed, 231 insertions, 0 deletions
diff --git a/public/system/emotes/index.php b/public/system/emotes/index.php
new file mode 100644
index 0000000..f49ff97
--- /dev/null
+++ b/public/system/emotes/index.php
@@ -0,0 +1,155 @@
+<?php
+include_once "../../../src/partials.php";
+include_once "../../../src/accounts.php";
+include_once "../../../src/alert.php";
+include_once "../../../src/config.php";
+include_once "../../../src/utils.php";
+
+if (!MOD_EMOTES_APPROVE) {
+ generate_alert("/404.php", "Manual emote approval is disabled", 405);
+ exit;
+}
+
+if (!authorize_user(true) || !$_SESSION["user_role"]["permission_approve_emotes"]) {
+ generate_alert("/404.php", "Not enough permissions", 403);
+ exit;
+}
+
+$emote_id = max(0, intval($_GET["id"] ?? "0"));
+
+$db = new PDO(DB_URL, DB_USER, DB_PASS);
+$emote_results = $db->query("SELECT e.*, u.username as uploader_name
+FROM emotes e
+LEFT JOIN users u ON u.id = e.uploaded_by
+WHERE e.visibility = 2
+ORDER BY e.created_at DESC
+LIMIT 25
+")->fetchAll(PDO::FETCH_ASSOC);
+
+$emote = $emote_results[0] ?? null;
+
+if ($emote_id > 0) {
+ $stmt = $db->prepare("SELECT e.*, u.username as uploader_name
+ FROM emotes e
+ LEFT JOIN users u ON u.id = e.uploaded_by
+ WHERE e.visibility = 2 AND e.id = ?
+ LIMIT 1");
+ $stmt->execute([$emote_id]);
+ $emote = $stmt->fetch(PDO::FETCH_ASSOC) ?? null;
+}
+
+?>
+
+<html>
+
+<head>
+ <title>System panel - alright.party</title>
+ <link rel="stylesheet" href="/static/style.css">
+</head>
+
+<body>
+ <div class="container">
+ <div class="wrapper">
+ <?php html_navigation_bar() ?>
+ <?php display_alert() ?>
+ <section class="content row">
+ <section class="box">
+ <div class="box navtab">System panel - Emote approval section</div>
+ <div class="box content">
+ <?php
+ foreach ($emote_results as $row) {
+ echo '<a href="/system/emotes?id=' . $row["id"] . '">';
+ echo '<img src="/static/userdata/emotes/' . $row["id"] . '/1x.' . $row["ext"] . '">';
+ echo '<b>' . $row["code"] . '</b>';
+ echo '<span style="font-size:10px;"> by ';
+
+ if ($row["uploader_name"] == null) {
+ echo ANONYMOUS_DEFAULT_NAME . '*';
+ } else {
+ echo $row["uploader_name"];
+ }
+
+ echo '</span></a>';
+ }
+
+ if (empty($emote_results)) {
+ echo 'Everything is clear. Good job!';
+ }
+ ?>
+ </div>
+ </section>
+ <?php if ($emote != null): ?>
+ <section class="content">
+ <!-- Emote showcase -->
+ <section class="box">
+ <div class="box navtab">Emote - <?php echo $emote["code"] ?></div>
+ <div class="box content">
+ <div class="emote-showcase">
+ <img src="/static/userdata/emotes/<?php echo $emote["id"] . '/' . '1x.' . $emote["ext"] ?>"
+ alt="<?php echo $emote["id"] ?>">
+ <img src="/static/userdata/emotes/<?php echo $emote["id"] . '/' . '2x.' . $emote["ext"] ?>"
+ alt="<?php echo $emote["id"] ?>">
+ <img src="/static/userdata/emotes/<?php echo $emote["id"] . '/' . '3x.' . $emote["ext"] ?>"
+ alt="<?php echo $emote["id"] ?>">
+ </div>
+ </div>
+ </section>
+ <!-- Emote actions -->
+ <section class="box items center row">
+ <form action="/system/emotes/manip.php" method="post">
+ <input type="text" name="id" value="<?php echo $emote["id"] ?>" style="display: none;">
+ <input type="text" name="action" value="approve" style="display: none;">
+ <button type="submit" class="green">Approve</button>
+ </form>
+ <form action="/system/emotes/manip.php" method="post">
+ <input type="text" name="id" value="<?php echo $emote["id"] ?>" style="display: none;">
+ <input type="text" name="action" value="reject" style="display: none;">
+ <button type="submit" class="red">Reject</button>
+ </form>
+ </section>
+ <!-- Emote information -->
+ <section class="box">
+ <table class="vertical">
+ <tr>
+ <th>Uploader</th>
+ <td><?php
+ $username = ANONYMOUS_DEFAULT_NAME;
+ $link = "#";
+
+ if ($row["uploader_name"] != null) {
+ $username = $row["uploader_name"];
+ $link = '/users.php?id=' . $row["uploaded_by"];
+ }
+
+ echo "<a href=\"$link\">";
+ echo $username;
+ echo "</a>";
+
+ echo ', <span title="';
+ echo date("M d, Y H:i:s", strtotime($row["created_at"]));
+ echo ' UTC">about ' . format_timestamp(time() - strtotime($row["created_at"])) . " ago</span>";
+ ?></td>
+ </tr>
+ <tr>
+ <th>Notes</th>
+ <td><i>Empty</i></td>
+ </tr>
+ </table>
+ </section>
+ <!-- Mod actions on emote -->
+ <section class="box">
+ <div class="box navtab">
+ Mod actions
+ </div>
+ <div class="box content">
+ <p>No one has done anything on this emote...</p>
+ </div>
+ </section>
+ </section>
+ <?php endif; ?>
+ </section>
+ </div>
+ </div>
+</body>
+
+</html> \ No newline at end of file
diff --git a/public/system/emotes/manip.php b/public/system/emotes/manip.php
new file mode 100644
index 0000000..2c04c3f
--- /dev/null
+++ b/public/system/emotes/manip.php
@@ -0,0 +1,76 @@
+<?php
+include_once "../../../src/alert.php";
+include_once "../../../src/accounts.php";
+include_once "../../../src/config.php";
+include_once "../../../src/utils.php";
+
+if (!MOD_EMOTES_APPROVE) {
+ generate_alert("/404.php", "Manual emote approval is disabled", 405);
+ exit;
+}
+
+if (!authorize_user(true) || !$_SESSION["user_role"]["permission_approve_emotes"]) {
+ generate_alert("/404.php", "Not enough permissions", 403);
+ exit;
+}
+
+if (!isset($_POST["id"], $_POST["action"])) {
+ generate_alert("/system/emotes", "Not enough POST fields");
+ exit;
+}
+
+$id = intval($_POST["id"], 0);
+$action = $_POST["action"];
+
+$db = new PDO(DB_URL, DB_USER, DB_PASS);
+
+$stmt = $db->prepare("SELECT id, code, uploaded_by FROM emotes WHERE id = ? AND visibility = 2 LIMIT 1");
+$stmt->execute([$id]);
+
+if ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
+ $verdict = 2;
+
+ switch ($action) {
+ case "approve": {
+ $db->prepare("UPDATE emotes SET visibility = 1 WHERE id = ?")
+ ->execute([$row["id"]]);
+ $verdict = 1;
+ break;
+ }
+ case "reject": {
+ $db->prepare("UPDATE emotes SET visibility = 0 WHERE id = ?")
+ ->execute([$row["id"]]);
+ $verdict = 0;
+ break;
+ }
+ default: {
+ generate_alert("/system/emotes", "Unknown action");
+ exit;
+ }
+ }
+
+ $comment = str_safe($_POST["comment"] ?? "", EMOTE_COMMENT_MAX_LENGTH, false);
+
+ if ($comment == "") {
+ $comment = null;
+ }
+
+ $db->prepare("INSERT INTO mod_actions(user_id, emote_id, verdict, comment) VALUES (?, ?, ?, ?)")
+ ->execute([$_SESSION["user_id"], $row["id"], $verdict, $comment]);
+
+ if ($row["uploaded_by"] != null) {
+ $contents = match ($verdict) {
+ 0 => 'Your emote "' . $row["code"] . '" has been unlisted! Anyone can add it via a direct link.',
+ 1 => 'Your emote "' . $row["code"] . '" has been approved! Enjoy!',
+ default => 'We did something with your emote "' . $row["code"] . '"'
+ };
+
+ $db->prepare("INSERT INTO inbox_messages(recipient_id, message_type, contents, link) VALUES (?, ?, ?, ?)")
+ ->execute([$row["uploaded_by"], "1", $contents, "/emotes?id=" . $row["id"]]);
+ }
+
+ generate_alert("/system/emotes", 'Emote "' . $row["code"] . '" has been ' . ($verdict == 0 ? 'rejected (unlisted)' : 'approved (public)') . '!', 200);
+ exit;
+}
+
+generate_alert("system/emotes", "Emote ID $id not found", 404); \ No newline at end of file
generated by cgit v1.2.3 (git 2.39.1) at 2025-12-12 18:31:59 +0000