Esempio n. 1
0
$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;
echo "DELETE PLAYER {$playerID}: Leave Player ";
if (!Tribe::leaveTribe($playerID)) {
    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";
}
echo "DELETE PLAYER {$playerID}: Delete Cave_takeover";
$sql = $db_game->prepare("DELETE FROM " . CAVE_TAKEOVER_TABLE . " WHERE playerID = :playerID");
$sql->bindValue('playerID', $playerID, PDO::PARAM_INT);