summaryrefslogtreecommitdiff
path: root/public/emotes/index.php
diff options
context:
space:
mode:
Diffstat (limited to 'public/emotes/index.php')
-rw-r--r--public/emotes/index.php546
1 files changed, 0 insertions, 546 deletions
diff --git a/public/emotes/index.php b/public/emotes/index.php
deleted file mode 100644
index af14120..0000000
--- a/public/emotes/index.php
+++ /dev/null
@@ -1,546 +0,0 @@
-<?php
-include "../../src/emote.php";
-include "../../src/accounts.php";
-include_once "../../src/config.php";
-include "../../src/partials.php";
-include "../../src/utils.php";
-include "../../src/alert.php";
-
-authorize_user();
-
-$db = new PDO(DB_URL, DB_USER, DB_PASS);
-
-$user_id = $_SESSION["user_id"] ?? "";
-
-$emotes = null;
-$emote = null;
-$total_emotes = 0;
-$total_pages = 0;
-
-// fetching emote by id
-if (isset($_GET["id"])) {
- $id = $_GET["id"];
-
- $stmt = $db->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;
-}
-?>
-
-<html>
-
-<head>
- <title><?php
- echo ($emote != null ? "Emote " . $emote->get_code() : "Emotes") . ' - ' . INSTANCE_NAME
- ?></title>
- <link rel="stylesheet" href="/static/style.css">
- <link rel="shortcut icon" href="/static/favicon.ico" type="image/x-icon">
-</head>
-
-<body>
- <div class="container">
- <div class="wrapper">
- <?php html_navigation_bar() ?>
-
- <section class="content row">
- <section class="sidebar">
- <?php
- html_navigation_search();
- html_featured_emote($db);
- html_random_emote($db);
- ?>
- </section>
- <section class="content">
- <?php display_alert() ?>
- <section class="box">
- <div class="box navtab row">
- <?php
- if ($emote != null) {
- echo "Emote - " . $emote->get_code();
- echo '<div class="row small-gap" style="margin-left:auto">';
-
- $original_path = "/static/userdata/emotes/" . $emote->get_id();
- $files = glob($_SERVER["DOCUMENT_ROOT"] . $original_path . "/original.*");
-
- if (!empty($files)) {
- $filename = basename($files[0]);
- echo "<a href='$original_path/$filename' target='_BLANK'><img src='/static/img/icons/emotes/emote.png' alt='[Show original]' title='Show original' /></a>";
- }
-
- $stmt = $db->prepare("
- SELECT MAX(es.is_featured) AS is_featured, MAX(es.is_global) AS is_global
- FROM emote_sets es
- JOIN emote_set_contents esc ON esc.emote_set_id = es.id
- JOIN emotes e ON esc.emote_id = e.id
- WHERE e.id = ?
- ");
- $stmt->execute([$emote->get_id()]);
-
- if ($row = $stmt->fetch()) {
- if ($row["is_featured"]) {
- echo '<img src="/static/img/icons/star.png" title="Featured emote" alt="Featured" />';
- }
- if ($row["is_global"]) {
- echo '<img src="/static/img/icons/world.png" title="Global emote" alt="Global" />';
- }
- }
- echo '</div>';
- } else {
- echo "<div class='grow'>Emotes - Page $page/$total_pages</div>";
- html_emotelist_mode();
- }
- ?>
- </div>
- <?php
- if ($emote != null) { ?>
- <div class="box content">
- <div class="emote-showcase items-bottom">
- <?php
- for ($size = 1; $size < 4; $size++) {
- echo '<div class="column items-center small-gap">';
-
- echo '<img src="/static/userdata/emotes/';
- echo $emote->get_id();
- echo "/{$size}x.webp\"";
- echo 'title="' . $emote->get_code() . '" />';
-
- $path = $_SERVER["DOCUMENT_ROOT"] . '/static/userdata/emotes/' . $emote->get_id() . "/{$size}x.webp";
-
- echo '<div class="column items-center">';
-
- if ($file_size = filesize($path)) {
- $kb = sprintf("%.2f", $file_size / 1024);
- echo "<p class='font-small'>{$kb}KB</p>";
- }
-
- if ($image_size = getimagesize($path)) {
- echo "<p class='font-small'>$image_size[0]x$image_size[1]</p>";
- }
-
- echo '</div></div>';
- }
- ?>
- </div>
- </div>
- </section>
- <section class="box items row">
- <?php if (isset($_SESSION["user_id"])) {
- echo '' ?>
- <div class="items row left full">
- <?php
- $added = false;
-
- if (isset($_SESSION["user_active_emote_set_id"])) {
- $stmt = $db->prepare("SELECT id, code FROM emote_set_contents WHERE emote_set_id = ? AND emote_id = ?");
- $stmt->execute([$_SESSION["user_active_emote_set_id"], $emote->get_id()]);
-
- $added = false;
-
- if ($row = $stmt->fetch()) {
- $added = true;
- $emote_current_name = $row["code"] ?? $emote->get_code();
- }
- }
-
- if (isset($_SESSION["user_role"]) && $_SESSION["user_role"]["permission_emoteset_own"]) {
- echo '' ?>
- <form action="/emotes/setmanip.php" method="POST">
- <input type="text" name="id" value="<?php echo $emote->get_id() ?>"
- style="display: none;">
- <input type="text" name="emote_set_id"
- value="<?php echo $_SESSION["user_active_emote_set_id"] ?>" style="display: none;">
- <?php
- if ($added) {
- ?>
- <input type="text" name="action" value="remove" style="display: none;">
- <button type="submit" class="red">Remove from my channel</button>
- </form>
- <form action="/emotes/setmanip.php" method="POST" class="row">
- <input type="text" name="id" value="<?php echo $emote->get_id() ?>"
- style="display: none;">
- <input type="text" name="emote_set_id"
- value="<?php echo $_SESSION["user_active_emote_set_id"] ?>" style="display: none;">
- <input type="text" name="value" id="emote-alias-input"
- value="<?php echo $emote_current_name ?>"
- placeholder="<?php echo $emote->get_code() ?>">
- <input type="text" name="action" value="alias" style="display: none;">
- <button type="submit" class="transparent"><img src="/static/img/icons/pencil.png"
- alt="Rename" title="Rename"></button>
- <?php
- } else { ?>
- <input type="text" name="action" value="add" style="display: none;">
- <button type="submit" class="green">Add to my channel</button>
- <?php
- }
- ?>
- </form>
- <?php
- ;
- }
- ?>
-
- <?php if ($emote->get_uploaded_by() === $_SESSION["user_id"]): ?>
- <form action="/emotes/delete.php" method="post">
- <input type="text" name="id" value="<?php echo $emote->get_id() ?>"
- style="display: none;">
- <button type="submit" class="transparent">
- <img src="/static/img/icons/bin.png" alt="Delete emote" title="Delete emote">
- </button>
- </form>
- <form action="/emotes/delete.php" method="post">
- <input type="text" name="id" value="<?php echo $emote->get_id() ?>"
- style="display: none;">
- <input type="text" name="unlink" value="1" style="display:none">
- <button type="submit" class="transparent">
- <img src="/static/img/icons/link_break.png" alt="Remove your authorship"
- title="Remove your authorship">
- </button>
- </form>
- <?php endif; ?>
- </div>
- <div class="items row right full">
- <?php
- if (isset($_SESSION["user_role"])) {
- if ($_SESSION["user_role"]["permission_rate"]) {
- $stmt = $db->prepare("SELECT rate FROM ratings WHERE user_id = ? AND emote_id = ?");
- $stmt->execute([$_SESSION["user_id"], $id]);
-
- if ($row = $stmt->fetch()) {
- echo 'You gave <img src="/static/img/icons/ratings/' . $row["rate"] . '.png" width="16" height="16"';
- echo 'title="' . RATING_NAMES[$row["rate"]] . '">';
- } else {
- foreach (RATING_NAMES as $key => $value) {
- echo '<form action="/emotes/rate.php" method="POST">';
- echo '<input type="text" name="id" value="' . $emote->get_id() . '"style="display: none;">';
- echo "<input type=\"text\" name=\"rate\" value=\"$key\" style=\"display:none;\">";
- echo '<button type="submit" class="transparent">';
- echo "<img
- src=\"/static/img/icons/ratings/$key.png\" alt=\"$value!\"
- title=\"IT'S A $value!\">";
- echo '</button></form>';
- }
- }
- }
- if (REPORTS_ENABLE && $_SESSION["user_role"]["permission_report"]) {
- echo "<a class='button red' href='/report?emote_id={$emote->id}'>Report emote</a>";
- }
- }
- ?>
- </div>
- <?php
- } else {
- echo '' ?>
- <p><a href="/account/login">Log in</a> to get additional features...</p>
- <?php
- }
- ?>
- </section>
-
- <section class="box">
- <table class="vertical">
- <?php if (!empty($emote->get_tags())): ?>
- <tr>
- <th>Tags</th>
- <td>
- <?php
- foreach ($emote->get_tags() as $tag) {
- echo "<a href='/emotes/?q=$tag'>$tag</a> ";
- }
- ?>
- </td>
- </tr>
- <?php endif; ?>
- <tr>
- <th>Uploader</th>
- <td><?php
- $username = ANONYMOUS_DEFAULT_NAME;
- $link = "#";
- $show_private_badge = false;
- $badge = null;
- $custom_badge = null;
-
- if ($emote->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 "<a href=\"$link\">";
- echo $username;
- echo "</a>";
-
- if ($show_private_badge) {
- echo " <img src='/static/img/icons/eye.png' alt='(Private)' title='You are the only one who sees this' />";
- }
-
- if ($badge && $badge->badge) {
- echo " <img src='/static/userdata/badges/{$badge->badge->id}/1x.webp' alt='## {$badge->name}' title='{$badge->name}' />";
- }
-
- if ($custom_badge) {
- echo " <img src='/static/userdata/badges/{$custom_badge->id}/1x.webp' alt='' title='Personal badge' />";
- }
-
- echo ', <span title="';
- echo date("M d, Y H:i:s", $emote->get_created_at());
- echo ' UTC">about ' . format_timestamp(time() - $emote->get_created_at()) . " ago</span>";
- ?></td>
- </tr>
- <?php
- $stmt = $db->prepare("SELECT u.id, a.created_at FROM users u
- INNER JOIN mod_actions a ON a.emote_id = ?
- WHERE u.id = a.user_id");
- $stmt->execute([$emote->get_id()]);
-
- if ($row = $stmt->fetch()) {
- $approver = User::get_user_by_id($db, $row["id"]);
-
- echo '<tr><th>Approver</th><td>';
- echo "<a href='/users.php?id={$approver->id}' target='_blank'>{$approver->username}</a>";
-
- if ($approver->role && $approver->role->badge) {
- echo " <img src='/static/userdata/badges/{$approver->role->badge->id}/1x.webp' alt='## {$approver->role->name}' title='{$approver->role->name}' />";
- }
-
- if ($approver->custom_badge) {
- echo " <img src='/static/userdata/badges/{$approver->custom_badge->id}/1x.webp' alt='' title='Personal badge' />";
- }
-
- echo ', <span title="';
- echo date("M d, Y H:i:s", strtotime($row["created_at"])) . ' UTC">';
- echo format_timestamp(strtotime($row["created_at"]) - $emote->get_created_at()) . ' after upload';
- echo '</span></td></tr>';
- }
-
- if (RATING_ENABLE): ?>
- <tr>
- <th>Rating</th>
- <?php
- if ($emote->get_rating()["total"] < RATING_EMOTE_MIN_VOTES) {
- echo '<td>Not rated (' . $emote->get_rating()["total"] . ')</td>';
- } 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",
- "<img src='/static/img/icons/ratings/1.png'>
- <img src='/static/img/icons/ratings/1.png'>
- <img src='/static/img/icons/ratings/1.png'> Shiny Gemerald!
- <img src='/static/img/icons/ratings/1.png'>
- <img src='/static/img/icons/ratings/1.png'>
- <img src='/static/img/icons/ratings/1.png'>
- "
- ],
- in_range($rating, 0.25, 0.75) => ["gem", "<img src='/static/img/icons/ratings/1.png'> Gem <img src='/static/img/icons/ratings/1.png'>"],
- in_range($rating, -0.25, 0.25) => ["iron", "Iron"],
- in_range($rating, -0.75, -0.25) => ["coal", "<img src='/static/img/icons/ratings/-1.png'> Coal <img src='/static/img/icons/ratings/-1.png'>"],
- in_range($rating, -1.0, -0.75) => [
- "brimstone",
- "
- <img src='/static/img/icons/ratings/brimstone.webp'>
- <img src='/static/img/icons/ratings/-1.png'>
- <img src='/static/img/icons/ratings/brimstone.webp'>
- !!!AVOID THIS CANCER-GIVING BRIMSTONE!!!
- <img src='/static/img/icons/ratings/brimstone.webp'>
- <img src='/static/img/icons/ratings/-1.png'>
- <img src='/static/img/icons/ratings/brimstone.webp'>
- "
- ]
- };
-
- echo '<td>';
- echo "<span class=\"rating $rating_classname\">$rating_name</span>";
- echo ' (' . $emote->get_rating()["total"] . ')';
- echo '</td>';
- }
- ?>
- </tr>
- <?php endif; ?>
- <tr>
- <th>Visibility</th>
- <td><?php
- switch ($emote->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;
- }
- ?></td>
- </tr>
- <?php if ($emote->get_source()): ?>
- <tr>
- <th>Source</th>
- <td>
- <a href="<?php echo $emote->get_source() ?>"
- target="_blank"><?php echo $emote->get_source() ?></a>
- </td>
- </tr>
- <?php endif; ?>
- </table>
- </section>
-
- <section class="box">
- <div class="content">
- <?php
- $stmt = $db->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
- INNER JOIN acquired_emote_sets AS aes ON aes.emote_set_id = es.id
- WHERE ec.emote_id = ? AND aes.is_default = TRUE");
-
- $stmt->execute([$emote->get_id()]);
- $count = $stmt->rowCount();
-
- $db = null;
-
- if ($count > 0) {
- echo "<p>Added in $count channels</p>";
- } else {
- echo "No one has added this emote yet... :'(";
- }
- ?>
- <div class="items row">
- <?php
- while ($row = $stmt->fetch()) {
- echo '<a href="/users.php?id=' . $row["id"] . '">' . $row["username"] . '</a>';
- }
- ?>
- </div>
- </div>
- <?php
- } else { ?>
- <div class="box content items">
- <?php html_display_emotes($emotes); ?>
- </div>
- <?php if ($total_pages > 1) {
- echo '' ?>
- </section>
- <section class="box center row">
- <?php
- html_pagination(
- $total_pages,
- $page,
- "/emotes?q=" . substr($search, 1, strlen($search) - 2) . "&sort_by=$sort_by"
- );
- }
- }
- ?>
- </section>
- </section>
- </section>
- </div>
- </div>
-</body>
-
-</html> \ No newline at end of file
generated by cgit v1.2.3 (git 2.39.1) at 2025-12-13 16:55:50 +0000