summaryrefslogtreecommitdiff
path: root/emotes
diff options
context:
space:
mode:
Diffstat (limited to 'emotes')
-rw-r--r--emotes/index.php4
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);
}