<?php
// 配置数据库连接
$host = 'localhost';
$dbname = 'syxywl.cn_sdk-14'; // 主数据库
$username = 'root';
$password = 'qq28009618';
$dsn = "mysql
:host=$host;dbname=$dbname;charset=utf8mb4";
try {
$pdo = new PDO($dsn, $username, $password);
$pdo->setAttribute(PDO
::ATTR_ERRMODE, PDO
::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
die("数据库连接失败
: " . htmlspecialchars($e->getMessage()));
}
// 设置分页参数
$limit = 10;
$page = isset($_GET['page']) ? (int)$_GET['page']
: 1;
$page = max(1, $page);
$offset = ($page - 1) * $limit;
// === 获取主键字段名 ===
function getPrimaryKey($pdo, $table) {
$stmt = $pdo->prepare("DESCRIBE `$table`");
$stmt->execute();
$columns = $stmt->fetchAll(PDO
::FETCH_ASSOC);
foreach ($columns as $col) {
if ($col['Key'] === 'PRI') {
return $col['Field'];
}
}
return null;
}
$primaryKey = getPrimaryKey($pdo, 't_accounts');
if (!$primaryKey) {
die("错误：t_accounts 表没有定义主键！");
}
// 处理封禁/解封请求
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
$pkValue = $_POST[$primaryKey] ?? null;
if ($pkValue && in_array($_POST['action'], ['ban', 'unban'])) {
try {
$type = $_POST['action'] === 'ban' ? 99
: 1;
$sql = "UPDATE `t_accounts` SET `type` = ? WHERE `$primaryKey` = ?";
$stmt = $pdo->prepare($sql);
$stmt->execute([$type, $pkValue]);
$successMsg = "用户 <strong>" . htmlspecialchars($pkValue) . "</strong> 已成功 "
. ($_POST['action'] === 'ban' ? '<span
style="color
:red;">封禁</span>（type=99）'
: '<span
style="color
:green;">解封</span>（type=1）') . "！";
} catch (PDOException $e) {
$errorMsg = "操作失败
: " . htmlspecialchars($e->getMessage());
}
}
}
// ======== 搜索逻辑开始 ========
$searchResult = null;
$searchError = null;
if (isset($_GET['search_player_uid']) && trim($_GET['search_player_uid']) !== '') {
$rawInput = trim($_GET['search_player_uid']);
// 验证是否为纯数字
if (!preg_match('/^\d+$/', $rawInput)) {
$searchError = "请输入有效的角色 UID（必须是纯数字）";
} else {
$playerUid = (string)$rawInput;
try {
// 第一步：从 db_hk4e_user_gio.t_player_uid 查 account_uid
$sql = "SELECT `account_uid` FROM `db_hk4e_user_gio`.`t_player_uid` WHERE `uid` = ?";
$stmt = $pdo->prepare($sql);
$stmt->execute([$playerUid]);
$link = $stmt->fetch(PDO
::FETCH_ASSOC);
if (!$link) {
$searchError = "❌ 未找到游戏 UID <strong>$playerUid</strong> 的绑定记录";
} else {
$accountUid = $link['account_uid'];
// 第二步：在 t_accounts 中查找用户
$sql = "SELECT `uid`, `name`, `type` FROM `t_accounts` WHERE `uid` = ?";
$stmt = $pdo->prepare($sql);
$stmt->execute([$accountUid]);
$user = $stmt->fetch(PDO
::FETCH_ASSOC);
if (!$user) {
$searchError = "✅ 找到绑定关系，但 SDK 账户 <strong>$accountUid</strong> 在系统中不存在！";
} else {
// 第三步：获取该账号所有绑定的角色
$roles = getPlayerRoles($pdo, $user['uid']);
$searchResult = [
'player_uid' => $playerUid,
'account' => $user,
'roles' => $roles
];
}
}
} catch (PDOException $e) {
$searchError = "⚠️ 数据库查询异常
: " . htmlspecialchars($e->getMessage());
}
}
}
// ======== 搜索逻辑结束 ========
// === 函数：获取某 account_uid 绑定的所有角色 UID ===
function getPlayerRoles($pdo, $accountUid) {
try {
// 检查数据库是否存在
$dbCheck = $pdo->query("SELECT 1 FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'db_hk4e_user_gio'");
if ($dbCheck->rowCount() == 0) {
return ['error' => '数据库 `db_hk4e_user_gio` 不存在'];
}
// 检查表是否存在
$tableCheck = $pdo->query("
SELECT 1 FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'db_hk4e_user_gio' AND TABLE_NAME = 't_player_uid'
");
if ($tableCheck->rowCount() == 0) {
return ['error' => '表 `t_player_uid` 不存在'];
}
// 查询绑定的角色 UID
$sql = "SELECT `uid` FROM `db_hk4e_user_gio`.`t_player_uid` WHERE `account_uid` = ?";
$stmt = $pdo->prepare($sql);
$stmt->execute([(string)$accountUid]);
$results = $stmt->fetchAll(PDO
::FETCH_ASSOC);
return empty($results) ? ['empty' => true]
: $results;
} catch (PDOException $e) {
return ['exception' => $e->getMessage()];
}
}
// 查询总行数（用于分页）
$totalStmt = $pdo->query("SELECT COUNT(*) FROM `t_accounts`");
$totalRows = $totalStmt->fetchColumn();
$totalPages = ceil($totalRows / $limit);
// 获取当前页数据
$stmt = $pdo->prepare("SELECT `uid`, `name`, `type` FROM `t_accounts` LIMIT ? OFFSET ?");
$stmt->bindValue(1, $limit, PDO
::PARAM_INT);
$stmt->bindValue(2, $offset, PDO
::PARAM_INT);
$stmt->execute();
$rows = $stmt->fetchAll(PDO
::FETCH_ASSOC);
?>
<!DOCTYPE html>
<html lang="zh">
<head>
<meta charset="UTF-8">
<title>封禁/解封管理系统 + 角色绑定 & 搜索</title>
<
style>
body {
font-family
: Arial, sans-serif;
margin
: 20px;
background-color
: #f7f7f7;
color
: #333;
}
h1 { color
: #d32f2f; }
h2 { color
: #1976D2; border-bottom
: 1px solid #ddd; padding-bottom
: 5px; }
table {
width
: 100%;
border-collapse
: collapse;
margin-top
: 20px;
background-color
: #fff;
box-shadow
: 0 2px 8px rgba(0,0,0,0.1);
}
th,
td {
border
: 1px solid #ddd;
padding
: 10px;
text-align
: left;
}
th {
background-color
: #333;
color
: white;
}
.status-banned {
background-color
: #ffcdd2;
color
: #c62828;
padding
: 2px 6px;
border-radius
: 3px;
font-weight
: bold;
}
.status-normal {
background-color
: #e8f5e8;
color
: #2e7d32;
padding
: 2px 6px;
border-radius
: 3px;
}
button.ban {
background-color
: #d32f2f;
color
: white;
border
: none;
padding
: 5px 10px;
cursor: pointer;
border-radius
: 4px;
font-weight
: bold;
margin-right
: 5px;
}
button.unban {
background-color
: #2e7d32;
color
: white;
border
: none;
padding
: 5px 10px;
cursor: pointer;
border-radius
: 4px;
font-weight
: bold;
}
button
:hover { opacity
: 0.9; }
.pagination {
margin
: 20px 0;
text-align
: center;
}
.pagination a, .pagination span {
display
: inline-block;
margin
: 0 3px;
padding
: 8px 12px;
text-decoration
: none;
border
: 1px solid #ccc;
background-color
: #fff;
color
: #333;
border-radius
: 4px;
}
.pagination a
:hover {
background-color
: #333;
color
: white;
}
.pagination .current {
background-color
: #333;
color
: white;
font-weight
: bold;
}
.msg {
padding
: 10px;
margin
: 10px 0;
border-radius
: 4px;
}
.msg.success {
background-color
: #d4edda;
color
: #155724;
border
: 1px solid #c3e6cb;
}
.msg.error {
background-color
: #f8d7da;
color
: #721c24;
border
: 1px solid #f5c6cb;
}
/* 搜索区域样式 */
.search-box {
background
: #fff;
padding
: 15px;
border-radius
: 8px;
box-shadow
: 0 1px 6px rgba(0,0,0,0.1);
margin-bottom
: 20px;
}
.search-box form {
display
: flex;
gap
: 10px;
align-items
: center;
flex-wrap
: wrap;
}
.search-box input[type="text"] {
padding
: 8px;
width
: 250px;
border
: 1px solid #ccc;
border-radius
: 4px;
font-size
: 1em;
}
.search-box button {
padding
: 8px 15px;
background
: #007BFF;
color
: white;
border
: none;
border-radius
: 4px;
cursor: pointer;
}
.search-box button
:hover {
background
: #0056b3;
}
</
style>
</head>
<body>
<h1>🔐 用户封禁与解封管理系统 + 角色绑定信息</h1>
<!-- 搜索框 -->
<div class="search-box">
<form method="get">
<label for="search_player_uid"><strong>🔍 通过游戏内UID查找账号：</strong></label>
<input
type="text"
name="search_player_uid"
id="search_player_uid"
value="<?= htmlspecialchars($_GET['search_player_uid'] ?? '') ?>"
placeholder="输入角色 UID（如：2000123）"
>
<button type="submit">搜索</button>
<?php if (isset($_GET['page']))
: ?>
<input type="hidden" name="page" value="<?= (int)$_GET['page'] ?>">
<?php endif; ?>
</form>
<!-- 搜索结果提示 -->
<?php if ($searchError)
: ?>
<p class="msg error"
style="margin-top
:10px;"><?= $searchError ?></p>
<?php elseif ($searchResult)
: ?>
<p class="msg success"
style="margin-top
:10px;">
<strong>✅ 找到匹配账号：</strong><br>
游戏角色 UID
: <code><?= htmlspecialchars($searchResult['player_uid']) ?></code> ➜
SDK账户排序
: <strong><?= htmlspecialchars($searchResult['account']['uid']) ?></strong>,
登陆账户
: <strong><?= htmlspecialchars($searchResult['account']['name']) ?></strong>
</p>
<?php endif; ?>
</div>
<!-- 操作反馈消息 -->
<?php if (isset($successMsg))
: ?>
<div class="msg success"><?= $successMsg ?></div>
<?php endif; ?>
<?php if (isset($errorMsg))
: ?>
<div class="msg error"><?= $errorMsg ?></div>
<?php endif; ?>
<!-- 搜索结果详情（单独显示） -->
<?php if ($searchResult)
: ?>
<h2>📌 搜索结果详情</h2>
<table>
<thead>
<tr>
<th>sdk账户排序</th>
<th>登陆账户</th>
<th>账户状态</th>
<th>操作</th>
<th>游戏内UID</th>
</tr>
</thead>
<tbody>
<tr>
<
td><?= htmlspecialchars($searchResult['account']['uid']) ?></
td>
<
td><?= htmlspecialchars($searchResult['account']['name']) ?></
td>
<
td>
<?php if ($searchResult['account']['type'] == 99)
: ?>
<span class="status-banned">🔴 已封禁</span>
<?php else
: ?>
<span class="status-normal">🟢 正常</span>
<?php endif; ?>
</
td>
<
td>
<form method="post"
style="display
:inline;">
<input type="hidden" name="<?= htmlspecialchars($primaryKey) ?>" value="<?= htmlspecialchars($searchResult['account']['uid']) ?>">
<?php if ($searchResult['account']['type'] == 99)
: ?>
<input type="hidden" name="action" value="unban">
<button type="submit" class="unban" onclick="return confirm('确定要解封用户 UID=<?= $searchResult['account']['uid'] ?> 吗？')">解封</button>
<?php else
: ?>
<input type="hidden" name="action" value="ban">
<button type="submit" class="ban" onclick="return confirm('确定要封禁用户 UID=<?= $searchResult['account']['uid'] ?> 吗？')">封禁</button>
<?php endif; ?>
</form>
</
td>
<
td>
<?php $roles = $searchResult['roles']; ?>
<?php if (isset($roles['error']))
: ?>
<span class="error">❌ <?= htmlspecialchars($roles['error']) ?></span>
<?php elseif (isset($roles['exception']))
: ?>
<span class="error">💥 <?= htmlspecialchars($roles['exception']) ?></span>
<?php elseif ($roles['empty'])
: ?>
此登陆账户未绑定
<?php else
: ?>
<?php
$uids = array_column($roles, 'uid');
echo implode(', ', array_map('htmlspecialchars', $uids));
?>
<?php endif; ?>
</
td>
</tr>
</tbody>
</table>
<br>
<?php endif; ?>
<!-- 主表格：所有用户列表 -->
<?php if (!empty($rows))
: ?>
<h2>📋 所有 SDK 账户列表</h2>
<table>
<thead>
<tr>
<th>sdk账户排序</th>
<th>登陆账户</th>
<th>账户状态</th>
<th>操作</th>
<th>游戏内UID</th>
</tr>
</thead>
<tbody>
<?php foreach ($rows as $row)
: ?>
<tr>
<
td><?= htmlspecialchars($row['uid']) ?></
td>
<
td><?= htmlspecialchars($row['name']) ?></
td>
<
td>
<?php if ($row['type'] == 99)
: ?>
<span class="status-banned">🔴 已封禁</span>
<?php else
: ?>
<span class="status-normal">🟢 正常</span>
<?php endif; ?>
</
td>
<
td>
<form method="post"
style="display
:inline;">
<input type="hidden" name="<?= htmlspecialchars($primaryKey) ?>" value="<?= htmlspecialchars($row['uid']) ?>">
<?php if ($row['type'] == 99)
: ?>
<input type="hidden" name="action" value="unban">
<button type="submit" class="unban" onclick="return confirm('确定要解封用户 UID=<?= $row['uid'] ?> 吗？')">解封</button>
<?php else
: ?>
<input type="hidden" name="action" value="ban">
<button type="submit" class="ban" onclick="return confirm('确定要封禁用户 UID=<?= $row['uid'] ?> 吗？')">封禁</button>
<?php endif; ?>
</form>
</
td>
<
td>
<?php $roles = getPlayerRoles($pdo, $row['uid']); ?>
<?php if (isset($roles['error']))
: ?>
<span class="error">❌ <?= htmlspecialchars($roles['error']) ?></span>
<?php elseif (isset($roles['exception']))
: ?>
<span class="error">💥 <?= htmlspecialchars($roles['exception']) ?></span>
<?php elseif ($roles['empty'])
: ?>
此登陆账户未绑定
<?php else
: ?>
<?php
$uids = array_column($roles, 'uid');
echo implode(', ', array_map('htmlspecialchars', $uids));
?>
<?php endif; ?>
</
td>
</tr>
<?php endforeach; ?>
</tbody>
</table>
<!-- 分页 -->
<div class="pagination">
<?php if ($page > 1)
: ?>
<a href="?<?= http_build_query(array_merge($_GET, ['page' => $page - 1])) ?>">上一页</a>
<?php else
: ?>
<span>上一页</span>
<?php endif; ?>
<?php
$start = max(1, $page - 1);
$end = min($totalPages, $start + 2);
if ($start > 1)
: ?>
<a href="?<?= http_build_query(array_merge($_GET, ['page' => 1])) ?>">1</a>
<?php if ($start > 2)
: ?><span>...</span><?php endif; ?>
<?php endif; ?>
<?php for ($i = $start; $i <= $end; $i++)
: ?>
<?php if ($i == $page)
: ?>
<span class="current"><?= $i ?></span>
<?php else
: ?>
<a href="?<?= http_build_query(array_merge($_GET, ['page' => $i])) ?>"><?= $i ?></a>
<?php endif; ?>
<?php endfor; ?>
<?php if ($end < $totalPages)
: ?>
<?php if ($end < $totalPages - 1)
: ?><span>...</span><?php endif; ?>
<a href="?<?= http_build_query(array_merge($_GET, ['page' => $totalPages])) ?>"><?= $totalPages ?></a>
<?php endif; ?>
<?php if ($page < $totalPages)
: ?>
<a href="?<?= http_build_query(array_merge($_GET, ['page' => $page + 1])) ?>">下一页</a>
<?php else
: ?>
<span>下一页</span>
<?php endif; ?>
<span
style="margin-left
: 20px;">共 <?= number_format($totalRows) ?> 条记录，<?= $totalPages ?> 页</span>
</div>
<?php else
: ?>
<p>
该表中没有数据。</p>
<?php endif; ?>
</body>
</html>
点击封禁或解封后重新跳转至指定链接 http
://150.138.84.7
:333 完整写出
介绍了一种样式，其作用是当鼠标移动到单元格上时，鼠标形状会由箭头变为手形，呈现出链接的样式。
扫一扫
525
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
