User list - <?php echo INSTANCE_NAME ?>

From 57472eab3c7b035392c6a5aa240593ecaa7d1ccf Mon Sep 17 00:00:00 2001 From: ilotterytea Date: Mon, 8 Dec 2025 21:53:36 +0500 Subject: upd: moved all /public/ files to the root folder --- public/users.php | 587 ------------------------------------------------------- 1 file changed, 587 deletions(-) delete mode 100644 public/users.php (limited to 'public/users.php') diff --git a/public/users.php b/public/users.php deleted file mode 100644 index 6a6273e..0000000 --- a/public/users.php +++ /dev/null @@ -1,587 +0,0 @@ -prepare("SELECT id, username, joined_at, last_active_at - FROM users - WHERE username LIKE ? - ORDER BY last_active_at DESC LIMIT ? OFFSET ?"); - $stmt->bindParam(1, $search, PDO::PARAM_STR); - $stmt->bindParam(2, $limit, PDO::PARAM_INT); - $stmt->bindParam(3, $offset, PDO::PARAM_INT); - $stmt->execute(); - - $count_stmt = $db->prepare("SELECT COUNT(*) FROM users WHERE username LIKE ?"); - $count_stmt->execute([$search]); - - $total_users = $count_stmt->fetch()[0]; - $total_pages = ceil($total_users / $limit); - - 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 '' ?> - - - - User list - <?php echo INSTANCE_NAME ?> - - - - - -

-

- -

- -

-

-

-

Users -

-

-

- '; - echo ''; - echo 'UsernameLast active'; - echo ''; - while ($row = $stmt->fetch()) { - $diff = time() - strtotime($row["last_active_at"]); - - $last_active = "moments"; - - if ($diff > 5) { - $last_active = format_timestamp($diff); - } - - echo ''; - echo '

'; - echo '' . $row["username"] . ''; - echo "$last_active ago"; - echo ''; - } - echo ''; - } else { - echo '

Nothing found...

'; - } - ?> -

-

- 1) { - echo '' ?> - -

- -

- -

-

-

- - - - prepare("SELECT u.id FROM users u - INNER JOIN connections co ON co.alias_id = ? AND co.platform = ? - WHERE co.user_id = u.id - "); - $stmt->execute([$alias_id, $platform]); - - if ($row = $stmt->fetch()) { - $user = User::get_user_by_id($db, $row["id"]); - } -} -// fetching user by internal id -else if (isset($_GET["id"])) { - $user = User::get_user_by_id($db, $_GET["id"]); -} - -if (!$user) { - generate_alert("/404.php", "The user you requested cannot be found", 404); - exit; -} - -// User preferences -$stmt = $db->prepare("SELECT * FROM user_preferences WHERE id = ?"); -$stmt->execute([$user->id]); - -$user_preferences = $stmt->fetch(PDO::FETCH_ASSOC); - -$public_profile = !$user_preferences["private_profile"] || $user->id == ($_SESSION["user_id"] ?? ""); - -// fetching emote sets -$emote_sets = Emoteset::get_all_user_emotesets($db, $user->id); -$active_emote_set = null; -foreach ($emote_sets as $es) { - if ($es->is_default) { - $active_emote_set = $es; - break; - } -} - -// gathering uploaded emotes -$uploaded_emotes = []; - -if ($public_profile) { - $stmt = $db->prepare("SELECT e.id, e.code, e.uploaded_by, e.source, e.visibility - FROM emotes e - WHERE e.uploaded_by = ? - ORDER BY e.created_at ASC - "); - $stmt->execute([$user->id]); - - $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); - - foreach ($rows as $row) { - array_push($uploaded_emotes, Emote::from_array_with_user($row, $db)); - } -} - -// gathering actions -$actions = []; - -if ($public_profile) { - $stmt = $db->prepare("SELECT a.* FROM actions a WHERE a.user_id = ? ORDER BY a.created_at DESC LIMIT 15"); - $stmt->execute([$user->id]); - $actions = $stmt->fetchAll(PDO::FETCH_ASSOC); -} - -// TODO: add functionality - -// calculating contributions -$stmt = $db->prepare("SELECT COUNT(*) FROM emotes WHERE uploaded_by = ?"); -$stmt->execute([$user->id]); -$contributions = intval($stmt->fetch()[0]); - -$stmt = $db->prepare("SELECT COUNT(*) FROM ratings WHERE user_id = ?"); -$stmt->execute([$user->id]); - -$contributions += intval($stmt->fetch()[0]); - -// getting status -$stmt = $db->prepare("SELECT * FROM roles r INNER JOIN role_assigns ra ON ra.user_id = ? WHERE ra.role_id = r.id"); -$stmt->execute([$user->id]); - -$role = $stmt->fetch(PDO::FETCH_ASSOC) ?? null; - -// getting reactions -$stmt = $db->prepare("SELECT rate, COUNT(*) AS c FROM ratings WHERE user_id = ? GROUP BY rate ORDER BY c DESC"); -$stmt->execute([$user->id]); - -$fav_reactions = $stmt->fetchAll(PDO::FETCH_ASSOC); - -// getting favorite emote -$fav_emote = 1; - -// getting custom badge -$stmt = $db->prepare("SELECT b.* FROM badges b - INNER JOIN user_badges ub ON ub.user_id = ? - WHERE b.id = ub.badge_id -"); -$stmt->execute([$user->id]); - -$custom_badge = null; -if ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { - $custom_badge = $row; -} - -if ($is_json) { - $user_data = (array) $user; - - unset($user_data["private_profile"]); - - $user_data["stats"] = [ - "contributions" => $contributions, - "favorite_reaction_id" => $fav_reactions, - "favorite_emote_id" => $fav_emote - ]; - - $user_data["active_emote_set_id"] = $active_emote_set->id; - $user_data["emote_sets"] = $emote_sets; - $user_data["uploaded_emotes"] = $uploaded_emotes; - $user_data["actions"] = $actions; - - json_response([ - "status_code" => 200, - "message" => null, - "data" => $user_data - ]); - exit; -} -?> - - - - - <?php echo sprintf("%s - %s", $user->username, INSTANCE_NAME) ?> - - - - - -

-

-

- -

-

- -

-

- -

-

- username; - - if ($custom_badge) { - echo '

'; - } - ?> -

-

- id)) { - echo 'userdata/avatars/' . $user->id . '/3x.webp'; - } else { - echo 'img/defaults/profile_picture.png'; - } - echo '" width="192" height="192">'; - ?> -

-

- - sprintf("background: rgba(%s);", $bg_color_split[1]), - "gradient" => sprintf("background: linear-gradient(0deg, rgba(%s), rgba(%s));", $bg_color_split[1], $bg_color_split[2]), - "img" => sprintf("background-image: url('%s')", $bg_color_split[1]), - default => "" - }; - - if ($role["badge_id"]): ?> -

-

-

/3x.webp" - alt="" width="54" height="54"> -

-

-

- Role -

-

- - -

- - - - joined_at); - echo ' UTC">about ' . format_timestamp(time() - $user->joined_at) . " ago"; - ?> - - - - last_active_at; - if ($diff > 60) { - echo '"; - } else { - echo ''; - } - ?> - - - - - - - - - - - prepare("SELECT code FROM emotes WHERE id = ?"); - $stmt->execute([$fav_emote]); - - if ($row = $stmt->fetch()) { - echo ''; - echo ''; - echo ''; - } - ?> -

Joined
Last activity	last_active_at); - echo ' UTC">about ' . format_timestamp($diff) . " ago	Online
Contributions
Reactions	- '; - } - ?> -
Favorite emote	'; - echo ""; - echo $row["code"] . ' '; - echo '

-

- -

- - - - - - -

-

-

- -

-

-

- name : "Emotes" ?> -

- -

-

- emotes)) { - html_display_emotes($active_emote_set->emotes); - } else { - echo '

No emotes found... ' . ((($_SESSION["user_id"] ?? "") == $id) ? 'Start adding emotes and they will appear here! :)

' : '

'); - } - } else { - echo "

This user doesn't have active emote set.

"; - } - ?> -

-

- -

-

- Emote sets -

-

- No emote sets found... ' . ((($_SESSION["user_id"] ?? "") == $id) ? 'Start adding emotes and you will have one! :)

' : '

'); - } - ?> -

-

- - - - - -

-

-

- Uploaded emotes - " : "" ?> -

-

-

- -

-

- -

-

-

-

- - - - - \ No newline at end of file -- cgit v1.2.3