{$kb}KB
"; } if ($image_size = getimagesize($path)) { echo "$image_size[0]x$image_size[1]
"; } echo 'prepare("SELECT e.id, e.code, e.created_at, e.source, e.visibility, COALESCE(COUNT(r.rate), 0) as total_rating, COALESCE(ROUND(AVG(r.rate), 2), 0) AS average_rating, CASE WHEN up.private_profile = FALSE OR up.id = ? THEN e.uploaded_by ELSE NULL END AS uploaded_by FROM emotes e LEFT JOIN user_preferences up ON up.id = e.uploaded_by LEFT JOIN ratings AS r ON r.emote_id = e.id WHERE e.id = ? LIMIT 1 "); $stmt->execute([$user_id, $id]); $row = $stmt->fetch(); if ($row["id"]) { // fetching emote tags $stmt = $db->prepare("SELECT t.code FROM tags t INNER JOIN tag_assigns ta ON ta.emote_id = ? WHERE t.id = ta.tag_id "); $stmt->execute([$row["id"]]); $tags = $stmt->fetchAll(PDO::FETCH_ASSOC); $tags = array_column($tags, "code"); $row["tags"] = $tags; $row["ext"] = "webp"; $emote = Emote::from_array_with_user($row, $db); } else { generate_alert("/404.php", "Emote ID $id does not exists", 404); exit; } } // fetching all emotes else { $sort = $_GET["sort"] ?? "high_ratings"; $sort = match ($sort) { "low_ratings" => "rating ASC", "recent" => "e.created_at DESC", "oldest" => "e.created_at ASC", default => "rating DESC" }; $page = max(1, intval($_GET["p"] ?? "1")); $limit = 50; $offset = ($page - 1) * $limit; $search = $_GET["q"] ?? ""; // fetching emotes $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 EXISTS ( SELECT 1 FROM emote_set_contents ec INNER JOIN emote_sets es ON es.id = ec.emote_set_id JOIN acquired_emote_sets aes ON aes.emote_set_id = es.id WHERE ec.emote_id = e.id AND es.id = ? ) THEN 1 ELSE 0 END AS is_in_user_set, COALESCE(COUNT(r.rate), 0) AS rating FROM emotes e LEFT JOIN user_preferences up ON up.id = e.uploaded_by LEFT JOIN ratings AS r ON r.emote_id = e.id LEFT JOIN tag_assigns ta ON ta.emote_id = e.id LEFT JOIN tags t ON t.id = ta.tag_id WHERE (t.code = ? OR e.code LIKE ?) AND e.visibility = 1 GROUP BY e.id, e.code, e.created_at ORDER BY $sort LIMIT ? OFFSET ? "); $sql_search = "%$search%"; $user_emote_set_id = $_SESSION["user_active_emote_set_id"] ?? ""; $stmt->bindParam(1, $user_id, PDO::PARAM_STR); $stmt->bindParam(2, $user_emote_set_id, PDO::PARAM_STR); $stmt->bindParam(3, $search, PDO::PARAM_STR); $stmt->bindParam(4, $sql_search, PDO::PARAM_STR); $stmt->bindParam(5, $limit, PDO::PARAM_INT); $stmt->bindParam(6, $offset, PDO::PARAM_INT); $stmt->execute(); $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); $emotes = []; foreach ($rows as $row) { array_push($emotes, Emote::from_array_with_user($row, $db)); } $total_emotes = count($emotes); $total_pages = ceil($total_emotes / $limit); } if (CLIENT_REQUIRES_JSON) { json_response([ "status_code" => 200, "message" => null, "data" => $emotes ?? $emote ]); exit; } ?>
{$kb}KB
"; } if ($image_size = getimagesize($path)) { echo "$image_size[0]x$image_size[1]
"; } echo 'Log in to get additional features...
| Tags | get_tags() as $tag) { echo "$tag "; } ?> | |
|---|---|---|
| Uploader | get_uploaded_by()) {
$u = $emote->get_uploaded_by();
$show_private_badge = $u->private_profile;
$username = $u->username;
$link = "/users.php?id={$u->id}";
$badge = $u->role;
$custom_badge = $u->custom_badge;
}
echo "";
echo $username;
echo "";
if ($show_private_badge) {
echo " ";
}
if ($custom_badge) {
echo " ";
}
echo ', get_created_at());
echo ' UTC">about ' . format_timestamp(time() - $emote->get_created_at()) . " ago";
?> |
|
| Approver | ';
echo "{$approver->username}";
if ($approver->role && $approver->role->badge) {
echo " ";
}
if ($approver->custom_badge) {
echo " ";
}
echo ', ';
echo format_timestamp(strtotime($row["created_at"]) - $emote->get_created_at()) . ' after upload';
echo ' | |
| Rating | get_rating()["total"] < CONFIG['rating']['minvotes']) { echo 'Not rated (' . $emote->get_rating()["total"] . ') | '; } else { $rating = $emote->get_rating()["average"]; // TODO: make it customizable list($rating_classname, $rating_name) = match (true) { in_range($rating, 0.75, 1.0) => [ "gemerald", "'; echo ""; echo ' (' . $emote->get_rating()["total"] . ')'; echo ' | '; } ?>
| Visibility | get_visibility()) { case 0: echo 'Unlisted'; break; case 1: echo 'Public'; break; case 2: echo 'Pending approval (unlisted for a moment)'; break; default: echo 'N/A'; break; } ?> | |
| Source | get_source() ?> |
Added in $count channels
"; } else { echo "No one has added this emote yet... :'("; } ?>