User list - <?= CONFIG['instance']['name'] ?>

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 - <?= CONFIG['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; } ?> <?= sprintf("%s - %s", $user->username, CONFIG['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 " : "" ?>