summaryrefslogtreecommitdiff
path: root/public/users.php
diff options
context:
space:
mode:
Diffstat (limited to 'public/users.php')
-rw-r--r--public/users.php418
1 files changed, 418 insertions, 0 deletions
diff --git a/public/users.php b/public/users.php
new file mode 100644
index 0000000..73f1d54
--- /dev/null
+++ b/public/users.php
@@ -0,0 +1,418 @@
+<?php
+include_once "../src/config.php";
+include_once "../src/user.php";
+include_once "../src/partials.php";
+include_once "../src/utils.php";
+include_once "../src/accounts.php";
+authorize_user();
+session_start();
+
+$is_json = isset($_SERVER["HTTP_ACCEPT"]) && $_SERVER["HTTP_ACCEPT"] == "application/json";
+
+$id = $_GET["id"] ?? "";
+
+$db = new PDO(DB_URL, DB_USER, DB_PASS);
+
+if ($id == "") {
+ $page = $_GET["p"] ?? "0";
+ $limit = 50;
+ $offset = $page * $limit;
+ $stmt = $db->prepare("SELECT id, username, joined_at, last_active_at FROM users ORDER BY last_active_at DESC LIMIT ? OFFSET ?");
+ $stmt->bindParam(1, $limit, PDO::PARAM_INT);
+ $stmt->bindParam(2, $offset, PDO::PARAM_INT);
+ $stmt->execute();
+
+ $all_user_count = $db->query("SELECT COUNT(*) FROM users")->fetch()[0];
+
+ if ($is_json) {
+ header("Content-Type: application/json");
+ echo json_encode([
+ "status_code" => 200,
+ "message" => null,
+ "data" => [
+ "all_user_count" => intval($all_user_count),
+ "users" => $stmt->fetchAll(PDO::FETCH_ASSOC)
+ ]
+ ]);
+ exit;
+ }
+
+ echo '' ?>
+ <html>
+
+ <head>
+ <title>User list - alright.party</title>
+ <link rel="stylesheet" href="/static/style.css">
+ </head>
+
+ <body>
+ <div class="container">
+ <div class="wrapper">
+ <?php html_navigation_bar() ?>
+ <section class="content row">
+ <section class="sidebar">
+ <?php html_navigation_search(); ?>
+ </section>
+ <section class="content">
+ <section class="box">
+ <div class="box navtab">
+ <p><?php echo $all_user_count ?> Users</p>
+ </div>
+ <div class="box content">
+ <?php
+ if ($stmt->rowCount() != 0) {
+ echo '<table>';
+ echo '<tr>';
+ echo '<th></th><th style="width:80%;">Username</th><th>Last active</th>';
+ echo '<tr>';
+ while ($row = $stmt->fetch()) {
+ $diff = time() - strtotime($row["last_active_at"]);
+
+ $last_active = "moments";
+
+ if ($diff > 5) {
+ $last_active = format_timestamp($diff);
+ }
+
+ echo '<tr>';
+ echo '<td><img src="/static/userdata/avatars/' . $row["id"] . '" width="24" height="24"></td>';
+ echo '<td><a href="/users.php?id=' . $row["id"] . '">' . $row["username"] . '</a></td>';
+ echo "<td>$last_active ago</td>";
+ echo '</tr>';
+ }
+ echo '</table>';
+ } else {
+ echo '<p>Nothing found...</p>';
+ }
+ ?>
+ </div>
+ </section>
+ </section>
+ </section>
+ </div>
+ </div>
+ </body>
+
+ </html>
+ <?php ;
+ exit;
+}
+
+$stmt = $db->prepare("SELECT * FROM users WHERE id = ?");
+$stmt->execute([$id]);
+
+$user = null;
+
+if ($row = $stmt->fetch()) {
+ $user = new User($row);
+}
+
+if ($user == null) {
+ header("Location: /404.php");
+ exit;
+}
+
+// --- EMOTE SETS ---
+// TODO: OPTIMIZE IT ASAP!!!
+$emote_sets = [];
+$active_emote_set = null;
+
+// gathering acquired emote sets
+$stmt = $db->prepare("SELECT emote_set_id, is_default FROM acquired_emote_sets WHERE user_id = ?");
+$stmt->execute([$user->id()]);
+
+while ($row = $stmt->fetch()) {
+ // getting more info about set
+ $set_stmt = $db->prepare("SELECT id, name, size FROM emote_sets WHERE id = ?");
+ $set_stmt->execute([$row["emote_set_id"]]);
+ $set = $set_stmt->fetch();
+
+ // getting info about emote set content
+ $em_stmt = $db->prepare(
+ "SELECT e.id, e.code, e.ext FROM emotes e
+ INNER JOIN emote_set_contents AS esc
+ ON esc.emote_set_id = ?
+ WHERE esc.emote_id = e.id
+ " . ($row["is_default"] ? '' : ' LIMIT 5')
+ );
+ $em_stmt->execute([$row["emote_set_id"]]);
+
+ $emote_set = [
+ "id" => $set["id"],
+ "name" => $set["name"],
+ "size" => $set["size"],
+ "emotes" => $em_stmt->fetchAll(PDO::FETCH_ASSOC)
+ ];
+
+ if ($row["is_default"]) {
+ $active_emote_set = count($emote_sets);
+ }
+
+ array_push($emote_sets, $emote_set);
+}
+
+$active_emote_set = &$emote_sets[$active_emote_set];
+
+// gathering uploaded emotes
+$stmt = $db->prepare("SELECT e.*,
+ CASE WHEN EXISTS (
+ SELECT 1
+ FROM emote_set_contents ec
+ INNER JOIN emote_sets es ON es.id = ec.emote_set_id
+ WHERE ec.emote_id = e.id AND es.owner_id = ?
+ ) THEN 1 ELSE 0 END AS is_in_user_set
+ FROM emotes e
+ WHERE e.uploaded_by = ?
+ ORDER BY e.created_at ASC
+ ");
+$stmt->execute([$user->id(), $user->id()]);
+
+$uploaded_emotes = $stmt->fetchAll(PDO::FETCH_ASSOC);
+
+// gathering actions
+// TODO: update it when we will have action logs
+$actions = [];
+
+// TODO: add functionality
+
+// calculating contributions
+$stmt = $db->prepare("SELECT COUNT(*) FROM emotes WHERE uploaded_by = ?");
+$stmt->execute([$user->id()]);
+$contributions = $stmt->fetch()[0];
+
+// getting status
+$status = 1;
+
+// getting favorite reaction
+$fav_reaction = 1;
+
+// getting favorite emote
+$fav_emote = 1;
+
+if ($is_json) {
+ header("Content-type: application/json");
+ echo json_encode([
+ "status_code" => 200,
+ "message" => null,
+ "data" => [
+ "id" => intval($user->id()),
+ "username" => $user->username(),
+ "joined_at" => $user->joined_at(),
+ "last_active_at" => $user->last_active_at(),
+ "stats" => [
+ "status_id" => $status,
+ "contributions" => $contributions,
+ "favorite_reaction_id" => $fav_reaction,
+ "favorite_emote_id" => $fav_emote
+ ],
+ "active_emote_set_id" => $active_emote_set["id"],
+ "emote_sets" => $emote_sets,
+ "uploaded_emotes" => $uploaded_emotes,
+ "actions" => $actions
+ ]
+ ]);
+ exit;
+}
+?>
+
+<html>
+
+<head>
+ <title><?php echo $user->username() ?> - alright.party</title>
+ <link rel="stylesheet" href="/static/style.css">
+</head>
+
+<body>
+ <div class="container">
+ <div class="wrapper">
+ <?php echo html_navigation_bar() ?>
+ <section class="content row">
+ <!-- User information -->
+ <section class="user-bar column small-gap">
+ <section class="box">
+ <div class="box navtab">
+ <p>User #<?php echo $user->id() ?></p>
+ </div>
+ <div class="box content">
+ <img src="/static/userdata/avatars/<?php echo $user->id() ?>" width="96" height="96">
+ <h1><?php echo $user->username() ?></h1>
+ </div>
+ </section>
+
+ <!-- STATS -->
+ <section class="box">
+ <table class="vertical left">
+ <tr>
+ <th><img src="/static/img/icons/user.png"> I am </th>
+ <td><?php
+ if ($status == 1) {
+ echo "Gemposter";
+ } else {
+ echo "Unknown";
+ }
+ ?></td>
+ </tr>
+ <tr>
+ <th><img src="/static/img/icons/door_in.png"> Joined</th>
+ <?php
+ echo '<td title="';
+ echo date("M d, Y H:i:s", $user->joined_at());
+ echo ' UTC">about ' . format_timestamp(time() - $user->joined_at()) . " ago</td>";
+ ?>
+ </tr>
+ <tr>
+ <th><img src="/static/img/icons/clock.png"> Last activity</th>
+ <?php
+ $diff = time() - $user->last_active_at();
+ if ($diff > 60) {
+ echo '<td title="';
+ echo date("M d, Y H:i:s", $user->last_active_at());
+ echo ' UTC">about ' . format_timestamp($diff) . " ago</td>";
+ } else {
+ echo '<td>Online</td>';
+ }
+ ?>
+ </tr>
+ <tr>
+ <th><img src="/static/img/icons/star.png"> Contributed emotes</th>
+ <td><?php echo $contributions ?></td>
+ </tr>
+ <tr>
+ <th><img src="/static/img/icons/emoticon_happy.png"> Favorite reaction</th>
+ <td>
+ <?php
+ if ($fav_reaction == 1) {
+ echo 'Gem <img src="/static/img/icons/gem.png">';
+ } else {
+ echo 'Coal <img src="/static/img/icons/coal.png">';
+ }
+ ?>
+ </td>
+ </tr>
+ <?php
+ $stmt = $db->prepare("SELECT code, ext FROM emotes WHERE id = ?");
+ $stmt->execute([$fav_emote]);
+
+ if ($row = $stmt->fetch()) {
+ echo '<tr>';
+ echo '<th><img src="/static/img/icons/heart.png"> Favorite emote</th>';
+ echo '<td>';
+ echo "<a href=\"/emotes/$fav_emote\">";
+ echo $row["code"] . ' <img src="/static/userdata/emotes/' . $fav_emote . '/1x.' . $row["ext"] . '" width="16" height="16">';
+ echo '</a></td></tr>';
+ }
+ ?>
+ </table>
+ </section>
+
+ <!-- ACTIONS -->
+ <section class="box column">
+ <a href="/message/send.php?user=<?php echo $user->id() ?>">Send a message</a>
+ <a href="/report.php?user=<?php echo $user->id() ?>">Report user</a>
+ </section>
+ </section>
+
+ <!-- Emotes -->
+ <section class="column small-gap flex">
+ <!-- Emoteset -->
+ <section class="box">
+ <div class="box navtab">
+ <p>Emotes</p>
+ </div>
+ <div class="box content items">
+ <?php
+ if (!empty($emote_sets)) {
+ foreach ($emote_sets as $set_row) { ?>
+ <a href="/emotesets/<?php echo $set_row["id"] ?>" class="box">
+ <div>
+ <?php
+ echo '<p>' . $set_row["name"] . '</p>';
+
+ if ($set_row["size"]) {
+ echo '<p class="circled black">' . $set_row["size"] . '</p>';
+ }
+ ?>
+ </div>
+
+ <div>
+ <?php
+ foreach ($set_row["emotes"] as $e) {
+ echo '<img src="/static/userdata/emotes/' . $e["id"] . '/1x.' . $e["ext"] . '">';
+ }
+ ?>
+ </div>
+ </a>
+ <?php }
+ } else {
+ echo '<p>No emote sets found... ' . ((($_SESSION["user_id"] ?? "") == $id) ? 'Start adding emotes and you will have one! :)</p>' : '</p>');
+ }
+ ?>
+ </div>
+ </section>
+
+ <!-- Active emoteset -->
+ <?php
+ if ($active_emote_set != null) {
+ echo '' ?>
+ <section class="box">
+ <div class="content items">
+ <?php
+ if (!empty($active_emote_set["emotes"])) {
+ foreach ($active_emote_set["emotes"] as $emote_row) {
+ echo '<a class="box emote" href="/emotes/' . $emote_row["id"] . '">';
+ echo '<img src="/static/userdata/emotes/' . $emote_row["id"] . '/2x.' . $emote_row["ext"] . '" alt="' . $emote_row["code"] . '"/>';
+ echo '<p>' . $emote_row["code"] . '</p>';
+ echo '</a>';
+ }
+ } else {
+ echo '<p>No emotes found... ' . ((($_SESSION["user_id"] ?? "") == $id) ? 'Start adding emotes and they will appear here! :)</p>' : '</p>');
+ }
+ ?>
+ </div>
+ </section><?php
+ }
+ ?>
+
+ <!-- Uploaded emotes -->
+ <?php
+ if (!empty($uploaded_emotes)) {
+ echo '' ?>
+ <section class="box">
+ <div class="box navtab">
+ <p>Uploaded emotes</p>
+ </div>
+ <div class="box content items">
+ <?php
+ foreach ($uploaded_emotes as $emote_row) {
+ echo '<a class="box emote" href="/emotes/' . $emote_row["id"] . '">';
+ echo '<img src="/static/userdata/emotes/' . $emote_row["id"] . '/2x.' . $emote_row["ext"] . '" alt="' . $emote_row["code"] . '"/>';
+ echo '<p>' . $emote_row["code"] . '</p>';
+ echo '</a>';
+ }
+ ?>
+ </div>
+ </section><?php
+ }
+ ?>
+
+ <!-- Actions -->
+ <section class="box">
+ <div class="box navtab">
+ <p>Actions</p>
+ </div>
+ <div class="box content">
+ <?php
+ if (!empty($actions)) {
+ } else {
+ echo "<p>This user has done nothing bad or good...</p>";
+ }
+ ?>
+ </div>
+ </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 00:28:40 +0000