Server Account Wipe

[N0ctrnl]

I'm not sure if they catch all the tables now, but the drop_player.sql and load_player.sql scripts from PEQ are exactly what you're looking for. Maybe somebody else can confirm if they're still up to date or not.

https://code.google.com/p/projecteqd...%2Fpeqdatabase

[rencro]

Heres what I've used in the past, havent done one in a while but should still be similar. Assuming bots and mercs of course.

-- remove info from character tables
DELETE QUICK FROM aa_timers;
DELETE QUICK FROM account;
DELETE QUICK FROM account_flags;
DELETE QUICK FROM account_ip;
DELETE QUICK FROM account_rewards;
DELETE QUICK FROM adventure_details;
DELETE QUICK FROM adventure_members;
DELETE QUICK FROM adventure_stats;
DELETE QUICK FROM botbuffs;
DELETE QUICK FROM botgroup;
DELETE QUICK FROM botgroupmembers;
DELETE QUICK FROM botguildmembers;
DELETE QUICK FROM botinventory;
DELETE QUICK FROM botpetbuffs;
DELETE QUICK FROM botpetinventory;
DELETE QUICK FROM botpets;
DELETE QUICK FROM bots;
DELETE QUICK FROM botstances;
DELETE QUICK FROM bottimers;
DELETE QUICK FROM bugs;
DELETE QUICK FROM buyer;
DELETE QUICK FROM character_activities;
DELETE QUICK FROM character_alt_currency;
DELETE QUICK FROM character_backup;
DELETE QUICK FROM character_bandolier;
DELETE QUICK FROM character_bind;
DELETE QUICK FROM character_buffs;
DELETE QUICK FROM character_corpses;
DELETE QUICK FROM character_corpse_items;
DELETE QUICK FROM character_currency;
DELETE QUICK FROM character_data;
DELETE QUICK FROM character_disciplines;
DELETE QUICK FROM character_enabledtasks;
DELETE QUICK FROM character_inspect_messages;
DELETE QUICK FROM character_item_recast;
DELETE QUICK FROM character_languages;
DELETE QUICK FROM character_leadership_abilities;
DELETE QUICK FROM character_lookup;
DELETE QUICK FROM character_material;
DELETE QUICK FROM character_memmed_spells;
DELETE QUICK FROM character_pet_buffs;
DELETE QUICK FROM character_pet_info;
DELETE QUICK FROM character_pet_inventory;
DELETE QUICK FROM character_potionbelt;
DELETE QUICK FROM character_skills;
DELETE QUICK FROM character_spells;
DELETE QUICK FROM character_tasks;
DELETE QUICK FROM character_tribute;
DELETE QUICK FROM char_recipe_list;
DELETE QUICK FROM chatchannels;
DELETE QUICK FROM completed_tasks;
DELETE QUICK FROM discovered_items;
DELETE QUICK FROM eventlog;
DELETE QUICK FROM faction_values;
DELETE QUICK FROM friends;
DELETE QUICK FROM group_id;
DELETE QUICK FROM group_leaders;
DELETE QUICK FROM guild_members;
DELETE QUICK FROM guild_ranks;
DELETE QUICK FROM guild_relations;
DELETE QUICK FROM guilds;
DELETE QUICK FROM guild_bank;
DELETE QUICK FROM hackers;
DELETE QUICK FROM inventory;
DELETE QUICK FROM item_tick;
DELETE QUICK FROM keyring;
DELETE QUICK FROM lfguild;
DELETE QUICK FROM mail;
DELETE QUICK FROM merchantlist_temp;
DELETE QUICK FROM mercs;
DELETE QUICK FROM merc_buffs;
DELETE QUICK FROM object_contents;
DELETE QUICK FROM petitions;
DELETE QUICK FROM player_titlesets;
DELETE QUICK FROM qs_merchant_transaction_record;
DELETE QUICK FROM qs_merchant_transaction_record_entries;
DELETE QUICK FROM qs_player_aa_rate_hourly;
DELETE QUICK FROM qs_player_delete_record;
DELETE QUICK FROM qs_player_delete_record_entries;
DELETE QUICK FROM qs_player_handin_record;
DELETE QUICK FROM qs_player_handin_record_entries;
DELETE QUICK FROM qs_player_move_record;
DELETE QUICK FROM qs_player_move_record_entries;
DELETE QUICK FROM qs_player_npc_kill_record;
DELETE QUICK FROM qs_player_npc_kill_record_entries;
DELETE QUICK FROM qs_player_speech;
DELETE QUICK FROM qs_player_trade_record;
DELETE QUICK FROM qs_player_trade_record_entries;
DELETE QUICK FROM quest_globals;
DELETE QUICK FROM raid_details;
DELETE QUICK FROM raid_leaders;
DELETE QUICK FROM raid_members;
DELETE QUICK FROM reports;
DELETE QUICK FROM respawn_times;
DELETE QUICK FROM sharedbank;
DELETE QUICK FROM spell_globals;
DELETE QUICK FROM timers;
DELETE QUICK FROM trader;
DELETE QUICK FROM trader_audit;
DELETE QUICK FROM zone_flags;
-- reset auto increments
ALTER TABLE `account_ip` AUTO_INCREMENT = 1;
ALTER TABLE `account` AUTO_INCREMENT = 1;
ALTER TABLE `adventure_details` AUTO_INCREMENT = 1;
ALTER TABLE `botbuffs` AUTO_INCREMENT = 1;
ALTER TABLE `botgroup` AUTO_INCREMENT = 1;
ALTER TABLE `botgroupmembers` AUTO_INCREMENT = 1;
ALTER TABLE `botinventory` AUTO_INCREMENT = 1;
ALTER TABLE `botpetbuffs` AUTO_INCREMENT = 1;
ALTER TABLE `botpetinventory` AUTO_INCREMENT = 1;
ALTER TABLE `botpets` AUTO_INCREMENT = 1;
ALTER TABLE `bots` AUTO_INCREMENT = 1;
ALTER TABLE `bugs` AUTO_INCREMENT = 1;
ALTER TABLE `character_backup` AUTO_INCREMENT = 1; 
ALTER TABLE `character_corpses` AUTO_INCREMENT = 1; 
ALTER TABLE `character_data` AUTO_INCREMENT = 1;
ALTER TABLE `character_languages` AUTO_INCREMENT = 1;
ALTER TABLE `character_lookup` AUTO_INCREMENT = 1;
ALTER TABLE `character_material` AUTO_INCREMENT = 1;
ALTER TABLE `character_skills` AUTO_INCREMENT = 1;
ALTER TABLE `character_spells` AUTO_INCREMENT = 1;
ALTER TABLE `eventlog` AUTO_INCREMENT = 1; 
ALTER TABLE `guilds` AUTO_INCREMENT = 1; 
ALTER TABLE `hackers` AUTO_INCREMENT = 1; 
ALTER TABLE `mail` AUTO_INCREMENT = 1; 
ALTER TABLE `mercs` AUTO_INCREMENT = 1; 
ALTER TABLE `merc_buffs` AUTO_INCREMENT = 1; 
ALTER TABLE `petitions` AUTO_INCREMENT = 1; 
ALTER TABLE `player_titlesets` AUTO_INCREMENT = 1;
ALTER TABLE `qs_merchant_transaction_record` AUTO_INCREMENT = 1;
ALTER TABLE `qs_player_delete_record` AUTO_INCREMENT = 1;
ALTER TABLE `qs_player_handin_record` AUTO_INCREMENT = 1;
ALTER TABLE `qs_player_move_record` AUTO_INCREMENT = 1;
ALTER TABLE `qs_player_npc_kill_record` AUTO_INCREMENT = 1;
ALTER TABLE `qs_player_speech` AUTO_INCREMENT = 1;
ALTER TABLE `qs_player_trade_record` AUTO_INCREMENT = 1;
ALTER TABLE `reports` AUTO_INCREMENT = 1;