<?
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;
$search
Error = null;
if (isset($_GET['search_player_uid']) && trim($_GET['search_player_uid']) !== '') {
$rawInput = trim($_GET['search_player_uid']);
// 验证是否为纯数字
if (!preg_match('/^\d+$/', $rawInput)) {
$search
Error = "请输入有效的角色 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) {
$search
Error = "❌ 未找到游戏 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) {
$search
Error = "✅ 找到绑定关系，但 SDK 账户 <strong>$accountUid</strong> 在系统中不存在！";
} else {
// 第三步：获取该账号所有绑定的角色
$roles = getPlayerRoles($pdo, $user['uid']);
$searchResult = [
'player_uid' => $playerUid,
'account' => $user,
'roles' => $roles
];
}
}
} catch (PDOException $e) {
$search
Error = "⚠️ 数据库查询异常
: " .
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 ($search
Error)
: ?>
<p class="msg
error" style="margin
-top
:10px;"><?= $search
Error ?></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 完整写出
本文介绍了如何解决PHP中设置Cookie失败的问题。指出Cookie作为HTML头部的一部分，必须在任何输出前设置。文章建议将setcookie操作提前到所有echo或print_r等输出操作之前。
扫一扫
764
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
