prepare("SELECT is_admin FROM users WHERE id = ?"); $stmt->bind_param("i", $user_id); $stmt->execute(); $stmt->bind_result($is_admin); $stmt->fetch(); $stmt->close(); $is_admin = (int)$is_admin; // ---------- STATS ---------- $stats = [ "total_uploads" => 0, "total_received" => 0, "avg_rating" => 0, "collection_count" => 0 ]; // Total uploads $res = $db->query("SELECT COUNT(*) AS c FROM images WHERE user_id = {$user_id}"); $stats["total_uploads"] = (int)($res->fetch_assoc()["c"] ?? 0); // Total received $res = $db->query("SELECT COUNT(*) AS c FROM received_images WHERE user_id = {$user_id}"); $stats["total_received"] = (int)($res->fetch_assoc()["c"] ?? 0); // Average rating given $res = $db->query("SELECT AVG(rating) AS avg_rating FROM ratings WHERE user_id = {$user_id}"); $row = $res->fetch_assoc(); $stats["avg_rating"] = $row && $row["avg_rating"] !== null ? round($row["avg_rating"], 1) : 0; // Collection count $res = $db->query("SELECT COUNT(*) AS c FROM collections WHERE user_id = {$user_id}"); $stats["collection_count"] = (int)($res->fetch_assoc()["c"] ?? 0); // ---------- COLLECTION ---------- $collection = []; $res = $db->query(" SELECT c.slot_number, i.id, i.filename FROM collections c JOIN images i ON c.image_id = i.id WHERE c.user_id = {$user_id} ORDER BY c.slot_number ASC "); while ($row = $res->fetch_assoc()) { $collection[(int)$row["slot_number"]] = $row; } // ---------- RECEIVED IMAGES ---------- $received = []; $res = $db->query(" SELECT i.id, i.filename, i.hidden_username, i.age_days, i.disabled, (SELECT AVG(rating) FROM ratings WHERE image_id = i.id) AS avg_rating, (SELECT COUNT(*) FROM collections WHERE image_id = i.id) AS collection_count, (SELECT tag_text FROM tags WHERE image_id = i.id AND user_id = {$user_id} LIMIT 1) AS my_tag, (SELECT rating FROM ratings WHERE image_id = i.id AND user_id = {$user_id} LIMIT 1) AS my_rating, (SELECT username FROM users WHERE id = i.user_id) AS owner_username FROM received_images r JOIN images i ON r.image_id = i.id WHERE r.user_id = {$user_id} ORDER BY r.received_at DESC "); while ($row = $res->fetch_assoc()) { $received[] = $row; } // JSON for JS $collection_json = json_encode($collection); $received_json = json_encode($received); $stats_json = json_encode($stats); ?> TitZ · CatZ · ToeZ

TitZ · CatZ · ToeZ

Daily Uploads 0/3

📤 Upload Your NFT

🖼️

Drop images here or click to upload

Max 3 per day • JPG, PNG, GIF

🎁 Your Received NFTs