feat: show emote rating

5 files changed, 94 insertions, 8 deletions

diff --git a/public/emotes/index.php b/public/emotes/index.php
index de0e6ef..475e119 100644
--- a/public/emotes/index.php
+++ b/public/emotes/index.php
@@ -57,7 +57,8 @@ function display_list_emotes(PDO &$db, int $page, int $limit): array
             $row["ext"],
             intval(strtotime($row["created_at"])),
             $row["uploaded_by"],
-            $row["is_in_user_set"]
+            $row["is_in_user_set"],
+            $row["rating"]
         ));
     }
 
@@ -66,8 +67,12 @@ function display_list_emotes(PDO &$db, int $page, int $limit): array
 
 function display_emote(PDO &$db, int $id)
 {
-    $stmt = $db->prepare("SELECT * FROM emotes WHERE id = ?");
-    $stmt->execute([$id]);
+    $stmt = $db->prepare("SELECT e.*, COALESCE(COUNT(r.rate), 0) as total_rating,
+    COALESCE(ROUND(AVG(r.rate), 2), 0) AS average_rating
+    FROM emotes e
+    LEFT JOIN ratings AS r ON r.emote_id = ?
+    WHERE e.id = ?");
+    $stmt->execute([$id, $id]);
 
     $emote = null;
 
@@ -78,7 +83,8 @@ function display_emote(PDO &$db, int $id)
             $row["ext"],
             intval(strtotime($row["created_at"])),
             $row["uploaded_by"],
-            false
+            false,
+            ["total" => $row["total_rating"], "average" => $row["average_rating"]]
         );
     }
 
@@ -222,8 +228,6 @@ if ($id == "" || !is_numeric($id)) {
                                             $username = $row["username"];
                                             $link = "/users.php?id=" . $emote->get_uploaded_by();
                                         }
-
-                                        $db = null;
                                     }
 
                                     echo "<a href=\"$link\">";
@@ -237,7 +241,48 @@ if ($id == "" || !is_numeric($id)) {
                                 </tr>
                                 <tr>
                                     <th>Rating</th>
-                                    <td>Not rated</td>
+                                    <?php
+                                    if ($emote->get_rating()["total"] < 10) {
+                                        echo '<td>Not rated (' . $emote->get_rating()["total"] . ')</td>';
+                                    } else {
+
+                                        $rating = $emote->get_rating()["average"];
+
+                                        // TODO: make it customizable
+                                        list($rating_classname, $rating_name) = match (true) {
+                                            in_range($rating, 0.75, 1.0) => [
+                                                "gemerald",
+                                                "<img src='/static/img/icons/ratings/1.png'>
+                                        <img src='/static/img/icons/ratings/1.png'>
+                                        <img src='/static/img/icons/ratings/1.png'> Shiny Gemerald! 
+                                        <img src='/static/img/icons/ratings/1.png'>
+                                        <img src='/static/img/icons/ratings/1.png'>
+                                        <img src='/static/img/icons/ratings/1.png'>
+                                        "
+                                            ],
+                                            in_range($rating, 0.25, 0.75) => ["gem", "<img src='/static/img/icons/ratings/1.png'> Gem <img src='/static/img/icons/ratings/1.png'>"],
+                                            in_range($rating, -0.25, 0.25) => ["iron", "Iron"],
+                                            in_range($rating, -0.75, -0.25) => ["coal", "<img src='/static/img/icons/ratings/-1.png'> Coal <img src='/static/img/icons/ratings/-1.png'>"],
+                                            in_range($rating, -1.0, -0.75) => [
+                                                "brimstone",
+                                                "
+                                        <img src='/static/img/icons/ratings/brimstone.webp'>
+                                        <img src='/static/img/icons/ratings/-1.png'>
+                                        <img src='/static/img/icons/ratings/brimstone.webp'>
+                                        !!!AVOID THIS CANCER-GIVING BRIMSTONE!!!
+                                        <img src='/static/img/icons/ratings/brimstone.webp'>
+                                        <img src='/static/img/icons/ratings/-1.png'>
+                                        <img src='/static/img/icons/ratings/brimstone.webp'>
+                                        "
+                                            ]
+                                        };
+
+                                        echo '<td>';
+                                        echo "<span class=\"rating $rating_classname\">$rating_name</span>";
+                                        echo ' (' . $emote->get_rating()["total"] . ')';
+                                        echo '</td>';
+                                    }
+                                    ?>
                                 </tr>
                             </table>
                         </section>
diff --git a/public/static/img/icons/ratings/brimstone.webp b/public/static/img/icons/ratings/brimstone.webp
new file mode 100644
index 0000000..98b0d62
--- /dev/null
+++ b/public/static/img/icons/ratings/brimstone.webp
diff --git a/public/static/style.css b/public/static/style.css
index cb9a996..099764f 100644
--- a/public/static/style.css
+++ b/public/static/style.css
@@ -358,6 +358,34 @@ a.box:hover {
     margin-top: -15px;
 }
 
+/** RATINGS */
+.rating.gemerald {
+    font-weight: bolder;
+    text-shadow: 0 0 5px blue;
+    color: #b4dbeb;
+}
+
+.rating.gemerald img {
+    filter: hue-rotate(50deg) brightness(1.5);
+}
+
+.rating.gem {
+    font-weight: bold;
+    color: #2e7b99;
+}
+
+.rating.coal {
+    font-weight: bold;
+    color: #2d3335;
+    text-shadow: 0 0 2px black;
+}
+
+.rating.brimstone {
+    font-weight: bolder;
+    color: orange;
+    text-shadow: 0 0 4px red;
+}
+
 /** 
 -------------
    ACCOUNTS
diff --git a/src/emote.php b/src/emote.php
index 2fd30c0..1fa0221 100644
--- a/src/emote.php
+++ b/src/emote.php
@@ -6,9 +6,10 @@ class Emote
     public string $ext;
     public string|null $uploaded_by;
     public int $created_at;
+    public mixed $rating;
     public bool $is_in_user_set;
 
-    function __construct($id, $code, $ext, $created_at, $uploaded_by, $is_in_user_set)
+    function __construct($id, $code, $ext, $created_at, $uploaded_by, $is_in_user_set, $rating)
     {
         $this->id = $id;
         $this->code = $code;
@@ -16,6 +17,7 @@ class Emote
         $this->created_at = $created_at;
         $this->uploaded_by = $uploaded_by;
         $this->is_in_user_set = $is_in_user_set;
+        $this->rating = $rating;
     }
 
     function get_id()
@@ -47,4 +49,9 @@ class Emote
     {
         return $this->is_in_user_set;
     }
+
+    function get_rating()
+    {
+        return $this->rating;
+    }
 }
diff --git a/src/utils.php b/src/utils.php
index 325603b..a11fa16 100644
--- a/src/utils.php
+++ b/src/utils.php
@@ -58,7 +58,13 @@ function format_timestamp(int $timestamp_secs)
         return "$days day" . ($days > 1 ? "s" : "");
     }
 }
+
 function clamp(int $current, int $min, int $max): int
 {
     return max($min, min($max, $current));
+}
+
+function in_range(float $value, float $min, float $max): bool
+{
+    return $min <= $value && $value <= $max;
 }
\ No newline at end of file