MU 在线洗点源码

Published: Oct 17, 2024   Comment: No Comments

游戏设置 如果觉得对你有帮助，并想支持我，可以适当打赏以作勉励，点击打赏

<?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;
}
?>