Server Account Wipe

[Soak]

Okay - I have searched and search with no answer. I am guessing it's probably because the answer is super simple and I simply haven't got the base skills to know when it comes to databases, etc. But here's the question:

Can someone please walk me through how I do an account wipe on my server?

I'm learning as I go and have a loooooong way to go, but have gotten this far. Looking to wipe any accounts and start fresh. Didn't see in option in EoC 2.0 nor on boards.

Thanks in advance!

[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;

[Tyen05]

Wipe it clean

[Akkadius]

[Soak]

Thanks everyone - still learning all the very basics so sure I am doing it the hard way, but any issue with me using HeidiSQL to go to character_data --> data --> And then just deleting the info there?

Seemed to work on one I tested, but not sure if that will create more problems in other areas.

[Soak]

BTW - If I were to try and use what renco posted, where would that even go? (again noob here). Also...Is there really a place I can "mark it zero" and be done with it? If so where?

I'm going to figure this out hell or high water :p

[N0ctrnl]

Do yourself a favor and read the replies and then figure out how to do that. You've asked the question and gotten the answer. You need to fill your knowledge gap and not keep searching for a shortcut.

Trust me - These are things you're going to need to know anyway. Running a SQL script is about the most basic thing you'll do on your server.

Please learn something for yourself.

[Soak]

Thanks everyone for the info and the push - Figured each way out. Script worked great once I figured out I needed to paste it into a notepad and save as an sql file. Now figuring out what each of those lines in the script means/does. Head swimming but thankful for this community.

[N0ctrnl]

You should be able to run .sql files withing HeidiSQL, I believe. I only note this because there are going to be times when copy/paste just isn't feasible (loading a fresh DB or a huge query come to mind).

I'm glad you got it figured out.