function delete_chardb_records() { if (empty($this->data['id'])) { return false; } $id = $this->data['id']; $queries = array("DELETE FROM `account_data` WHERE `id`= {$id};", "DELETE FROM `account_instance_times` WHERE `id`= {$id};", "DELETE FROM `account_tutorial` WHERE `id`= {$id};"); DatabaseManager::get('char')->queue->add_range($queries); return true; }
function delete() { if (empty($this->data['guid'])) { return false; } $queries = array(); $charGUID = $this->data['guid']; $queries[] = "DELETE FROM `arena_team_member` WHERE `guid`= {$charGUID};"; $queries[] = "DELETE FROM `auctionhouse` WHERE `auctioneerguid`= {$charGUID};"; $queries[] = "DELETE FROM `character_account_data` WHERE `guid`= {$charGUID};"; $queries[] = "DELETE FROM `character_achievement` WHERE `guid`= {$charGUID};"; $queries[] = "DELETE FROM `character_achievement_progress` WHERE `guid`= {$charGUID};"; $queries[] = "DELETE FROM `character_action` WHERE `guid`= {$charGUID};"; $queries[] = "DELETE FROM `character_arena_stats` WHERE `guid`= {$charGUID};"; $queries[] = "DELETE FROM `character_aura` WHERE `guid`= {$charGUID};"; $queries[] = "DELETE FROM `character_banned` WHERE `guid`= {$charGUID};"; $queries[] = "DELETE FROM `character_battleground_data` WHERE `guid`= {$charGUID};"; $queries[] = "DELETE FROM `character_battleground_random` WHERE `guid`= {$charGUID};"; $queries[] = "DELETE FROM `character_equipmentsets` WHERE `guid`= {$charGUID};"; $queries[] = "DELETE FROM `character_gifts` WHERE `guid`= {$charGUID};"; $queries[] = "DELETE FROM `character_glyphs` WHERE `guid`= {$charGUID};"; $queries[] = "DELETE FROM `character_homebind` WHERE `guid`= {$charGUID};"; $queries[] = "DELETE FROM `character_instance` WHERE `guid`= {$charGUID};"; $queries[] = "DELETE FROM `character_inventory` WHERE `guid`= {$charGUID};"; $queries[] = "DELETE FROM `character_questatus` WHERE `guid`= {$charGUID};"; $queries[] = "DELETE FROM `character_questatus_daily` WHERE `guid`= {$charGUID};"; $queries[] = "DELETE FROM `character_questatus_rewarded` WHERE `guid`= {$charGUID};"; $queries[] = "DELETE FROM `character_questatus_weekly` WHERE `guid`= {$charGUID};"; $queries[] = "DELETE FROM `character_reputation` WHERE `guid`= {$charGUID};"; $queries[] = "DELETE FROM `character_skills` WHERE `guid`= {$charGUID};"; $queries[] = "DELETE FROM `character_social` WHERE `guid`= {$charGUID};"; $queries[] = "DELETE FROM `character_spell` WHERE `guid`= {$charGUID};"; $queries[] = "DELETE FROM `character_spell_cooldown` WHERE `guid`= {$charGUID};"; $queries[] = "DELETE FROM `character_stats` WHERE `guid`= {$charGUID};"; $queries[] = "DELETE FROM `character_talent` WHERE `guid`= {$charGUID};"; $queries[] = "DELETE FROM `characters` WHERE `guid`= {$charGUID};"; $queries[] = "DELETE FROM `corpse` WHERE `guid`= {$charGUID};"; $queries[] = "DELETE FROM `gm_tickets` WHERE `guid`= {$charGUID};"; $queries[] = "DELETE FROM `group_member` WHERE `memberGuid`= {$charGUID};"; $queries[] = "DELETE FROM `groups` WHERE `leaderGuid`= {$charGUID};"; $queries[] = "DELETE FROM `item_instance` WHERE `owner_guid`= {$charGUID};"; $queries[] = "DELETE FROM `item_refund_instance` WHERE `player_guid`= {$charGUID};"; $queries[] = "DELETE FROM `mail` WHERE `receiver`= {$charGUID};"; $queries[] = "DELETE FROM `mail_items` WHERE `receiver`= {$charGUID};"; $queries[] = "DELETE FROM `petition` WHERE `ownerguid`= {$charGUID};"; $queries[] = "DELETE FROM `petition_sign` WHERE `ownerguid`= {$charGUID};"; $queries[] = "DELETE FROM `rg_characters_data` WHERE `guid`= {$charGUID};"; $db = DatabaseManager::get('char')->queue->add_range($queries); return $this->delete_pets(); }
<!DOCTYPE html> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title></title> </head> <body> <?php require 'autoloader.php'; Autoloader::register(); Config::load(array('dbconfig' => array('char' => array('user' => 'root', 'pass' => '', 'dsn' => 'mysql:host=127.0.0.1;dbname=characters'), 'auth' => array('user' => 'root', 'pass' => '', 'dsn' => 'mysql:host=127.0.0.1;dbname=auth')))); $accounts = Account::select('id = 1'); foreach ($accounts as $account) { $account->delete(); } DatabaseManager::get('auth')->queue->execute(); DatabaseManager::get('char')->queue->execute(); ?> </body> </html>