feat: emote source

3 files changed, 35 insertions, 5 deletions

diff --git a/public/emotes/index.php b/public/emotes/index.php
index 978515f..68ae983 100644
--- a/public/emotes/index.php
+++ b/public/emotes/index.php
@@ -77,7 +77,8 @@ function display_list_emotes(PDO &$db, string $search, string $sort_by, int $pag
             $uploader,
             $row["is_in_user_set"],
             $row["rating"],
-            $row["visibility"]
+            $row["visibility"],
+            $row["source"]
         ));
     }
 
@@ -107,7 +108,8 @@ function display_emote(PDO &$db, string $id)
                 $row["uploaded_by"],
                 false,
                 ["total" => $row["total_rating"], "average" => $row["average_rating"]],
-                $row["visibility"]
+                $row["visibility"],
+                $row["source"]
             );
         }
     }
@@ -476,6 +478,15 @@ if (CLIENT_REQUIRES_JSON) {
                                     }
                                     ?></td>
                                 </tr>
+                                <?php if ($emote->get_source()): ?>
+                                    <tr>
+                                        <th>Source</th>
+                                        <td>
+                                            <a href="<?php echo $emote->get_source() ?>"
+                                                target="_blank"><?php echo $emote->get_source() ?></a>
+                                        </td>
+                                    </tr>
+                                <?php endif; ?>
                             </table>
                         </section>
 
diff --git a/public/emotes/upload.php b/public/emotes/upload.php
index 2c37c26..a9d416c 100644
--- a/public/emotes/upload.php
+++ b/public/emotes/upload.php
@@ -100,10 +100,15 @@ if ($_SERVER['REQUEST_METHOD'] != "POST") {
                                     <p id="form-visibility-description" style="font-size: 10px;">test</p>
                                 </div>
 
-                                <label for="notes">Approval notes (optional)</label>
+                                <label for="notes">Approval notes</label>
                                 <textarea name="notes" id="form-notes"></textarea>
 
                                 <div>
+                                    <label class="inline" for="source">Emote source: </label>
+                                    <input name="source" id="form-source"></input>
+                                </div>
+
+                                <div>
                                     <label for="tos" class="inline">Do you accept <a href="/rules.php" target="_BLANK">the
                                             rules</a>?<span style="color:red;">*</span></label>
                                     <input type="checkbox" name="tos" value="1" required>
@@ -323,6 +328,11 @@ if (empty($notes)) {
     $notes = null;
 }
 
+$source = str_safe($_POST["source"] ?? "", null);
+if (empty($source)) {
+    $source = null;
+}
+
 $visibility = clamp(intval($_POST["visibility"], EMOTE_VISIBILITY_DEFAULT), 0, 2);
 
 if (MOD_EMOTES_APPROVE && $visibility == 1 && EMOTE_VISIBILITY_DEFAULT != 1) {
@@ -333,8 +343,8 @@ if (MOD_EMOTES_APPROVE && $visibility == 1 && EMOTE_VISIBILITY_DEFAULT != 1) {
 $db = new PDO(DB_URL, DB_USER, DB_PASS);
 
 $id = bin2hex(random_bytes(16));
-$stmt = $db->prepare("INSERT INTO emotes(id, code, notes, uploaded_by, visibility) VALUES (?, ?, ?, ?, ?)");
-$stmt->execute([$id, $code, $notes, $uploaded_by, $visibility]);
+$stmt = $db->prepare("INSERT INTO emotes(id, code, notes, source, uploaded_by, visibility) VALUES (?, ?, ?, ?, ?, ?)");
+$stmt->execute([$id, $code, $notes, $source, $uploaded_by, $visibility]);
 
 $path = "../static/userdata/emotes/$id";
 
diff --git a/public/system/emotes/index.php b/public/system/emotes/index.php
index 9732bdb..9e88d83 100644
--- a/public/system/emotes/index.php
+++ b/public/system/emotes/index.php
@@ -179,6 +179,15 @@ if (isset($_GET["id"])) {
                                     <th>Notes</th>
                                     <td><?php echo isset($emote["notes"]) == true ? $emote["notes"] : '<i>Empty</i>' ?></td>
                                 </tr>
+                                <?php if ($emote["source"]): ?>
+                                    <tr>
+                                        <th>Source</th>
+                                        <td>
+                                            <a href="<?php echo $emote["source"] ?>"
+                                                target="_blank"><?php echo $emote["source"] ?></a>
+                                        </td>
+                                    </tr>
+                                <?php endif; ?>
                             </table>
                         </section>
                         <!-- Mod actions on emote -->