From f1dcd4d6651ece224e4ae30ccdeabd912d6b43f4 Mon Sep 17 00:00:00 2001 From: ilotterytea Date: Sun, 11 May 2025 01:45:16 +0500 Subject: fix: duplicate usernames in emote pages --- public/emotes/index.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'public/emotes/index.php') diff --git a/public/emotes/index.php b/public/emotes/index.php index 1225bdd..e9e93cb 100644 --- a/public/emotes/index.php +++ b/public/emotes/index.php @@ -465,7 +465,8 @@ if (CLIENT_REQUIRES_JSON) { FROM users INNER JOIN emote_sets AS es ON es.owner_id = users.id INNER JOIN emote_set_contents AS ec ON ec.emote_set_id = es.id - WHERE ec.emote_id = ?"); + INNER JOIN acquired_emote_sets AS aes ON aes.emote_set_id = es.id + WHERE ec.emote_id = ? AND aes.is_default = TRUE"); $stmt->execute([$emote->get_id()]); $count = $stmt->rowCount(); -- cgit v1.2.3