Emote - get_code() ?>
prepare("SELECT id FROM emote_set_contents WHERE emote_set_id = ? AND emote_id = ?");
$stmt->execute([$_SESSION["user_emote_set_id"], $emote->get_id()]);
$added = $stmt->rowCount() > 0;
}
$db = null;
?>
Log in to get additional features...
| Uploader | get_uploaded_by()) { $db = new PDO(DB_URL, DB_USER, DB_PASS); $stmt = $db->prepare("SELECT username FROM users WHERE id = ?"); $stmt->execute([$emote->get_uploaded_by()]); if ($row = $stmt->fetch()) { $username = $row["username"]; $link = "/users.php?id=" . $emote->get_uploaded_by(); } $db = null; } echo ""; echo $username; echo ""; echo ', get_created_at()); echo ' UTC">about ' . format_timestamp(time() - $emote->get_created_at()) . " ago"; ?> |
|---|---|
| Rating | Not rated |
prepare("SELECT users.id, users.username
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 = ?");
$stmt->execute([$emote->get_id()]);
$count = $stmt->rowCount();
$db = null;
if ($count > 0) {
echo "
Added in $count channels
"; } else { echo "No one has added this emote yet... :'("; } ?>
fetch()) {
echo '' . $row["username"] . '';
}
?>