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 * FROM users WHERE id = ?"); $stmt->execute([$id]); } else if ($alias_id != "") { $stmt = $db->prepare("SELECT u.* FROM users u INNER JOIN connections co ON (co.alias_id = ? AND co.platform = 'twitch') WHERE co.user_id = u.id "); $stmt->execute([$alias_id]); } $user = null; if ($row = $stmt->fetch()) { $user = new User($row); } if ($user == null) { 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"] ?? ""); // --- 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 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.created_at, CASE WHEN up.private_profile = FALSE OR up.id = ? THEN e.uploaded_by ELSE NULL END AS uploaded_by, CASE WHEN esc.code IS NOT NULL THEN esc.code ELSE e.code END AS code, CASE WHEN esc.code IS NOT NULL THEN e.code ELSE NULL END AS original_code FROM emotes e LEFT JOIN user_preferences up ON up.id = e.uploaded_by 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([$_SESSION["user_id"] ?? "", $row["emote_set_id"]]); $emote_set_emotes = $em_stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($emote_set_emotes as &$e) { $e["ext"] = "webp"; if ($e["uploaded_by"]) { $uploaded_by_stmt = $db->prepare("SELECT id, username FROM users WHERE id = ?"); $uploaded_by_stmt->execute([$e["uploaded_by"]]); $e["uploaded_by"] = $uploaded_by_stmt->fetch(PDO::FETCH_ASSOC); } } $emote_set = [ "id" => $set["id"], "name" => $set["name"], "emotes" => $emote_set_emotes ]; 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 $uploaded_emotes = []; if ($public_profile) { $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 $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) { header("Content-type: application/json"); echo json_encode([ "status_code" => 200, "message" => null, "data" => [ "id" => $user->id(), "username" => $user->username(), "joined_at" => $user->joined_at(), "last_active_at" => $user->last_active_at(), "stats" => [ "role" => $role, "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, "custom_badge" => $custom_badge ] ]); 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) . " agoOnline
Contributions
Reactions '; } ?>
Favorite emote'; echo ""; echo $row["code"] . ' '; echo '
'; echo '' . $emote_row['; echo '

' . $emote_row["code"] . '

'; echo '

' . ($emote_row["uploaded_by"] == null ? (ANONYMOUS_DEFAULT_NAME . "*") : $emote_row["uploaded_by"]["username"]) . '

'; echo ''; echo ''; } } 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
" class="box">
' . $set_row["name"] . '

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

' : '

'); } ?>
Actions " : "" ?>
This user has done nothing bad or good...

"; } foreach ($actions as $action) { echo '
'; list($action_name, $preposition, $icon_name) = match ($action["action_type"]) { "EMOTESET_ADD" => ["added", "to", "yes.png"], "EMOTESET_REMOVE" => ["removed", "from", "no.png"], "EMOTESET_ALIAS" => ["renamed", "in", "pencil.png"], "EMOTE_CREATE" => ["created", null, "new_emote.png"], "EMOTE_DELETE" => ["deleted", null, "deleted_emote.png"], "EMOTE_RENAME" => ["renamed", null, "renamed_emote.png"] }; echo "
"; echo '
'; echo '

'; echo '' . $user->username() . ' '; $payload = json_decode($action["action_payload"], true); list($action_root, $action_sub) = explode("_", $action["action_type"]); switch ($action_root) { case "EMOTESET": { $e_stmt = $db->prepare("SELECT COUNT(*) FROM emotes WHERE id = ?"); $e_stmt->execute([$payload["emote"]["id"]]); echo "$action_name emote rowCount() == 1) { echo '/emotes?id=' . $payload["emote"]["id"] . '">'; echo ' '; } else { echo '">'; } if (isset($payload["emote"]["original_code"])) { echo $payload["emote"]["original_code"] . ' to '; echo "rowCount() == 1) { echo '/emotes?id=' . $payload["emote"]["id"] . '">'; echo ' '; } else { echo '">'; } echo $payload["emote"]["code"] . ''; } else { echo $payload["emote"]["code"] . ''; } $es_stmt = $db->prepare("SELECT COUNT(*) FROM emote_sets WHERE id = ?"); $es_stmt->execute([$payload["emoteset"]["id"]]); echo " $preposition rowCount() == 1) { echo '/emotesets.php?id=' . $payload["emoteset"]["id"]; } echo '">' . $payload["emoteset"]["name"] . ''; break; } case "EMOTE": { $e_stmt = $db->prepare("SELECT COUNT(*) FROM emotes WHERE id = ?"); $e_stmt->execute([$payload["emote"]["id"]]); echo "$action_name emote rowCount() == 1) { echo '/emotes?id=' . $payload["emote"]["id"] . '">'; echo ' '; } else { echo '">'; } echo $payload["emote"]["code"] . ''; break; } default: { echo "something that we don't know"; break; } } echo '

'; echo '[' . format_timestamp(time() - strtotime($action["created_at"])) . ' ago] '; echo '
'; } ?>
Uploaded emotes " : "" ?>
'; echo '' . $emote_row['; echo '

' . $emote_row["code"] . '

'; echo ''; } ?>