get_code() : "Emotes" ?>
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;
}
?>
prepare("SELECT rate FROM ratings WHERE user_id = ? AND emote_id = ?");
$stmt->execute([$_SESSION["user_id"], $id]);
if ($row = $stmt->fetch()) {
echo 'You gave 
';
} else {
foreach (RATING_NAMES as $key => $value) {
echo '';
}
}
?>
Report
emote
';
} else {
foreach (RATING_NAMES as $key => $value) {
echo '';
}
}
?>
Report
emote
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"] . '';
}
?>
get_id() . '">';
if ($e->is_added_by_user()) {
echo '
';
}
echo ' . '/2x.' . $e->get_ext() . ')
';
echo '
';
}
echo '' . $e->get_code() . '
'; echo ''; } ?>