From 53a2e84af1ef1f35d835ef439260157038c70a46 Mon Sep 17 00:00:00 2001
From: ilotterytea <iltsu@alright.party>
Date: Thu, 15 May 2025 01:44:01 +0500
Subject: feat: tags

---
 public/system/emotes/index.php | 18 ++++++++++++++++++
 1 file changed, 18 insertions(+)

(limited to 'public/system/emotes')

diff --git a/public/system/emotes/index.php b/public/system/emotes/index.php
index 9e88d83..eaabf4d 100644
--- a/public/system/emotes/index.php
+++ b/public/system/emotes/index.php
@@ -147,6 +147,24 @@ if (isset($_GET["id"])) {
                         <!-- Emote information -->
                         <section class="box">
                             <table class="vertical">
+                                <?php
+                                $stmt = $db->prepare("SELECT t.code FROM tags t
+                                    INNER JOIN tag_assigns ta ON ta.emote_id = ?
+                                    WHERE t.id = ta.tag_id
+                                ");
+                                $stmt->execute([$emote["id"]]);
+
+                                $tags = $stmt->fetchAll(PDO::FETCH_ASSOC);
+                                $tags = array_column($tags, "code");
+
+                                if (!empty($tags)) {
+                                    echo '<tr><th>Tags</th><td>';
+                                    foreach ($tags as $tag) {
+                                        echo "<a href='/emotes/?q=$tag'>$tag</a> ";
+                                    }
+                                    echo '</td></tr>';
+                                }
+                                ?>
                                 <tr>
                                     <th>Uploader</th>
                                     <td><?php
-- 
cgit v1.2.3