fix: pagination on emote search

1 files changed, 3 insertions, 3 deletions

diff --git a/emotes/index.php b/emotes/index.php
index 2310e03..aae7683 100644
--- a/emotes/index.php
+++ b/emotes/index.php
@@ -108,8 +108,8 @@ else {
         array_push($emotes, Emote::from_array_with_user($row, $db));
     }
 
-    $stmt = $db->prepare("SELECT COUNT(*) FROM emotes WHERE visibility = 1");
-    $stmt->execute();
+    $stmt = $db->prepare("SELECT COUNT(*) FROM emotes WHERE code LIKE ? AND visibility = 1");
+    $stmt->execute([$sql_search]);
     $total_emotes = $stmt->fetch()[0];
     $total_pages = ceil($total_emotes / $limit);
 }
@@ -528,7 +528,7 @@ if (CLIENT_REQUIRES_JSON) {
                                 html_pagination(
                                     $total_pages,
                                     $page,
-                                    "/emotes?q=" . substr($search, 1, strlen($search) - 2) . "&s=$sort_by"
+                                    "/emotes?q=$search&s=$sort_by"
                                 );
                             }
                         }