} if (!($r = $db_login->query("SELECT * FROM Login WHERE LoginID = '{$playerID}'")) || !$r->nextRow()) { echo "DELETE PLAYER {$playerID}: No such Login\r\n"; exit(1); } echo "DELETE PLAYER {$playerID}: Delete Login "; if (!$db_login->query("DELETE FROM Login WHERE loginID = '{$playerID}' ")) { echo "FAILURE\r\n"; exit(1); } echo "SUCCESS\r\n"; if (!($db_game = new Db($config->DB_HOST, $config->DB_USER, $config->DB_PWD, $config->DB_NAME))) { echo "DELETE PLAYER {$playerID}: Failed to connect to game db.\r\n"; exit(1); } if ($tag = tribe_getTagOfPlayerID($playerID, $db_game)) { echo "DELETE PLAYER {$playerID}: Leave Player "; if (tribe_processLeave($playerID, $tag, $db_game, 1) != 2) { echo "FAILURE\r\n"; } else { echo "SUCCESS\r\n"; } } echo "DELETE PLAYER {$playerID}: Delete Player "; if (!$db_game->query("DELETE FROM Player WHERE playerID = '{$playerID}' ")) { echo "FAILURE\r\n"; } else { echo "SUCCESS\r\n"; } echo "DELETE PLAYER {$playerID}: Delete Cave_takeover"; if (!$db_game->query("DELETE FROM Cave_takeover WHERE playerID = '{$playerID}' ")) {
} $sqlSelect->closeCursor(); echo "DELETE PLAYER {$playerID}: Delete Login "; $sqlDelete = $db_login->prepare("DELETE FROM Login WHERE loginID = :playerID"); $sqlDelete->bindValue('playerID', $playerID, PDO::PARAM_INT); if (!$sqlDelete->execute()) { echo "FAILURE\n"; exit(1); } echo "SUCCESS\n"; if (!($db_game = DbConnect())) { echo "DELETE PLAYER {$playerID}: Failed to connect to game db.\n"; exit(1); } $db = $db_game; if ($tag = tribe_getTagOfPlayerID($playerID)) { echo "DELETE PLAYER {$playerID}: Leave Player "; if (tribe_processLeave($playerID, $tag, 1) != 2) { echo "FAILURE\n"; } else { echo "SUCCESS\n"; } } echo "DELETE PLAYER {$playerID}: Delete Player "; $sql = $db_game->prepare("DELETE FROM " . PLAYER_TABLE . " WHERE playerID = :playerID"); $sql->bindValue('playerID', $playerID, PDO::PARAM_INT); if (!$sql->execute()) { echo "FAILURE\n"; } else { echo "SUCCESS\n"; }