prepare("SELECT e.*, CASE WHEN up.private_profile = FALSE OR up.id = ? THEN e.uploaded_by ELSE NULL END AS uploaded_by, CASE WHEN up.private_profile = FALSE OR up.id = ? THEN u.username ELSE NULL END AS uploader_name FROM emotes e LEFT JOIN users u ON u.id = e.uploaded_by LEFT JOIN user_preferences up ON up.id = u.id WHERE e.visibility = 2 ORDER BY e.created_at DESC LIMIT 25 "); $emote_results->execute([$current_user_id, $current_user_id]); $emote_results = $emote_results->fetchAll(PDO::FETCH_ASSOC); $emote = $emote_results[0] ?? null; if (isset($_GET["id"])) { $stmt = $db->prepare("SELECT e.*, CASE WHEN up.private_profile = FALSE OR up.id = ? THEN e.uploaded_by ELSE NULL END AS uploaded_by, CASE WHEN up.private_profile = FALSE OR up.id = ? THEN u.username ELSE NULL END AS uploader_name FROM emotes e LEFT JOIN user_preferences up ON up.id = u.id LEFT JOIN users u ON u.id = e.uploaded_by WHERE e.visibility = 2 AND e.id = ? LIMIT 1"); $stmt->execute([$current_user_id, $current_user_id, $_GET["id"]]); $emote = $stmt->fetch(PDO::FETCH_ASSOC) ?? null; } ?> System panel - <?php echo INSTANCE_NAME ?>
System panel - Emote approval section
'; echo ''; echo '' . $row["code"] . ''; echo ' by '; if ($row["uploader_name"] == null) { echo ANONYMOUS_DEFAULT_NAME . '*'; } else { echo $row["uploader_name"]; } echo ''; } if (empty($emote_results)) { echo 'Everything is clear. Good job!'; } ?>
Emote -
/1x.webp" alt=""> /2x.webp" alt=""> /3x.webp" alt="">
" style="display: none;">
" style="display: none;">
Uploader "; echo $username; echo ""; echo ', about ' . format_timestamp(time() - strtotime($emote["created_at"])) . " ago"; ?>
Notes Empty' ?>
Mod actions

No one has done anything on this emote...