CCS用户后台
管理你的玩家信息
欢迎
prepare("SELECT username, level, points, email, register_time, organization, development_field, skill_tags FROM users WHERE id = ?"); $stmt->bind_param("i", $user_id); $stmt->execute(); $result = $stmt->get_result(); if ($row = $result->fetch_assoc()) { return $row; } return [ 'username' => '未授权人员', 'level' => 1, 'points' => 0, 'email' => 'NULL', 'register_time' => 'NULL', 'organization' => 'NULL', 'development_field' => 'NULL', 'skill_tags' => 'NULL' ]; } $user_info = get_user_full_info($conn, $user_id); $username = $user_info['username']; $level = $user_info['level']; $points = $user_info['points']; $email = $user_info['email']; $register_time = $user_info['register_time']; $organization = $user_info['organization']; $development_field = $user_info['development_field']; $skill_tags = explode(',', $user_info['skill_tags']); $levelDescriptions = [1 => '云境初探者', 2 => '云境行者', 3 => '云智大师', 4 => '云核守护者']; $userLevelDescription = $levelDescriptions[$level] ?? '未知等级'; function get_user_players($conn, $user_id) { $stmt = $conn->prepare("SELECT player_name, description, created_at FROM players WHERE user_id = ?"); $stmt->bind_param("i", $user_id); $stmt->execute(); $result = $stmt->get_result(); $userPlayers = $result->fetch_all(MYSQLI_ASSOC); $stmt->close(); return $userPlayers; } $user_players = get_user_players($conn, $user_id); $max_players = 5; $can_create_player = count($user_players) < $max_players; // 管理功能 - 获取所有用户 function get_all_users($conn) { $stmt = $conn->prepare("SELECT id, username, level, points, email, register_time FROM users"); $stmt->execute(); $result = $stmt->get_result(); $users = $result->fetch_all(MYSQLI_ASSOC); $stmt->close(); return $users; } // 管理功能 - 获取所有玩家 function get_all_players($conn) { $stmt = $conn->prepare("SELECT p.id, p.player_name, p.description, p.created_at, u.username as owner FROM players p JOIN users u ON p.user_id = u.id"); $stmt->execute(); $result = $stmt->get_result(); $players = $result->fetch_all(MYSQLI_ASSOC); $stmt->close(); return $players; } // 只有管理员用户才能获取管理数据 if ($level == 4) { $all_users = get_all_users($conn); $all_players = get_all_players($conn); } $token = bin2hex(random_bytes(32)); $_SESSION['player_token'] = $token; $conn->close(); ?>