MU 在线洗点源码
Published: Comment: No Comments
Last Modified:2024-11-09 23:24:09
<?php
$account = $_POST['account'];
$password = $_POST['password'];
$name = $_POST['Name'];
if (!empty($account) && !empty($password)) {
$connStr = "sqlsrv:Server=127.0.0.1;Database=muonline97";
$username = "sa";
$passwordDb = "123456";
try {
$conn = new PDO($connStr, $username, $passwordDb);
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$stmt = $conn->prepare("SELECT COUNT(*) FROM MEMB_INFO WHERE memb___id = :account AND memb__pwd = :password");
$stmt->bindParam(':account', $account);
$stmt->bindParam(':password', $password);
$stmt->execute();
$count = $stmt->fetchColumn();
if ($count > 0) {
$stmt = $conn->prepare("SELECT ConnectStat FROM MEMB_STAT WHERE memb___id = :account");
$stmt->bindParam(':account', $account);
$stmt->execute();
$connectStat = $stmt->fetchColumn();
if ($connectStat == 1) {
echo "<script>alert('洗点前请退出游戏。');</script>";
} else {
$stmt = $conn->prepare("UPDATE Character SET [LevelUpPoint]=[LevelUpPoint] + Strength + Dexterity + Vitality + Energy, Strength=0, Dexterity=0, Vitality=0, Energy=0 WHERE AccountID = :account AND Name = :name");
$stmt->bindParam(':account', $account);
$stmt->bindParam(':name', $name);
$stmt->execute();
echo "<script>alert('洗点完成!');</script>";
}
} else {
echo "<script>alert('账号密码不正确。');</script>";
}
} catch (PDOException $e) {
echo "连接失败:" . $e->getMessage();
}
$conn = null;
}
?>