Emotes
Emotesets
Users
Upload
Re-upload
Account
prepare("SELECT COUNT(*) FROM inbox_messages WHERE recipient_id = ? AND has_read = false");
$stmt->execute([$_SESSION["user_id"]]);
$unread_count = intval($stmt->fetch()[0]);
echo '' ?>
Inbox 0 ? "($unread_count)" : "" ?>
prepare("SELECT COUNT(*) FROM reports WHERE sender_id = ? AND resolved_by IS NULL");
$stmt->execute([$_SESSION["user_id"]]);
$unread_count = intval($stmt->fetch()[0]);
echo '' ?>
Reports 0 ? "($unread_count)" : "" ?>
query("SELECT COUNT(*) FROM emotes WHERE visibility = 2")->fetch()[0]);
}
if ($_SESSION["user_role"]["permission_report_review"]) {
$system_count += intval($db->query("SELECT COUNT(*) FROM reports WHERE resolved_by IS NULL")->fetch()[0]);
}
echo 'System';
if ($system_count > 0) {
echo " ($system_count)";
}
echo '';
}
}
$stmt = null;
$db = null;
}
?>
![[ Log out ]](/static/img/icons/door_out.png "Log out"){kind=icon}