feat: emote visibility

1 files changed, 26 insertions, 12 deletions

diff --git a/public/emotes/index.php b/public/emotes/index.php
index b6308a5..dc406f5 100644
--- a/public/emotes/index.php
+++ b/public/emotes/index.php
@@ -31,7 +31,7 @@ function display_list_emotes(PDO &$db, string $search, string $sort_by, int $pag
     ) THEN 1 ELSE 0 END AS is_in_user_set, COALESCE(COUNT(r.rate), 0) AS rating
     FROM emotes e
     LEFT JOIN ratings AS r ON r.emote_id = e.id
-    WHERE e.code LIKE ? 
+    WHERE e.code LIKE ? AND e.visibility = 1
     GROUP BY 
     e.id, e.code, e.created_at
     ORDER BY $sort
@@ -65,7 +65,8 @@ function display_list_emotes(PDO &$db, string $search, string $sort_by, int $pag
             intval(strtotime($row["created_at"])),
             $uploader,
             $row["is_in_user_set"],
-            $row["rating"]
+            $row["rating"],
+            $row["visibility"]
         ));
     }
 
@@ -84,15 +85,18 @@ function display_emote(PDO &$db, int $id)
     $emote = null;
 
     if ($row = $stmt->fetch()) {
-        $emote = new Emote(
-            $row["id"],
-            $row["code"],
-            $row["ext"],
-            intval(strtotime($row["created_at"])),
-            $row["uploaded_by"],
-            false,
-            ["total" => $row["total_rating"], "average" => $row["average_rating"]]
-        );
+        if ($row["id"] != null) {
+            $emote = new Emote(
+                $row["id"],
+                $row["code"],
+                $row["ext"],
+                intval(strtotime($row["created_at"])),
+                $row["uploaded_by"],
+                false,
+                ["total" => $row["total_rating"], "average" => $row["average_rating"]],
+                $row["visibility"]
+            );
+        }
     }
 
     if ($emote == null) {
@@ -128,7 +132,7 @@ $sort_by = $_GET["sort_by"] ?? "";
 
 if ($id == "" || !is_numeric($id)) {
     $emotes = display_list_emotes($db, $search, $sort_by, $page, $limit);
-    $stmt = $db->prepare("SELECT COUNT(*) FROM emotes WHERE code LIKE ?");
+    $stmt = $db->prepare("SELECT COUNT(*) FROM emotes WHERE code LIKE ? AND visibility = 1");
     $stmt->execute([$search]);
     $total_emotes = $stmt->fetch()[0];
     $total_pages = ceil($total_emotes / $limit);
@@ -329,6 +333,16 @@ if (CLIENT_REQUIRES_JSON) {
                                     }
                                     ?>
                                 </tr>
+                                <tr>
+                                    <th>Visibility</th>
+                                    <td><?php
+                                    if ($emote->get_visibility() == 1) {
+                                        echo 'Public';
+                                    } else {
+                                        echo 'Unlisted';
+                                    }
+                                    ?></td>
+                                </tr>
                             </table>
                         </section>