From c01fd37880b595fe7cc6c099373d3123f015d812 Mon Sep 17 00:00:00 2001
From: ilotterytea <iltsu@alright.party>
Date: Sun, 4 May 2025 15:05:09 +0500
Subject: upd: count only public emotes

---
 public/index.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/public/index.php b/public/index.php
index d9321fd..17d4d75 100644
--- a/public/index.php
+++ b/public/index.php
@@ -38,7 +38,7 @@ authorize_user();
             <div class="counter">
                 <?php
                 $db = new PDO(DB_URL, DB_USER, DB_PASS);
-                $results = $db->query("SELECT COUNT(*) FROM emotes");
+                $results = $db->query("SELECT COUNT(*) FROM emotes WHERE visibility = 1");
                 $count = $results->fetch()[0];
 
                 foreach (str_split($count) as $c) {
-- 
cgit v1.2.3