fix: total emotes were counted wrong...

1 files changed, 3 insertions, 1 deletions

diff --git a/emotes/index.php b/emotes/index.php
index 06d9e43..b3c9c26 100644
--- a/emotes/index.php
+++ b/emotes/index.php
@@ -108,7 +108,9 @@ else {
         array_push($emotes, Emote::from_array_with_user($row, $db));
     }
 
-    $total_emotes = count($emotes);
+    $stmt = $db->prepare("SELECT COUNT(*) FROM emotes WHERE visibility = 1");
+    $stmt->execute();
+    $total_emotes = $stmt->fetch()[0];
     $total_pages = ceil($total_emotes / $limit);
 }