EQEmulator Forums - Server Account Wipe

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.
Code:
-- 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;