Individual Account Rollback?

Is there a way to do an individual account/character rollback or restore? Lets say if indeed someone did steal someone else information, and you needed to restore their character/account back to a specific date, how would you do that?

by Navicat :
use schedule Back up of Characters DB and Realmd DB!
then you can restore it ,easily !

Quote:

---

Originally Posted by SharpSabre

by Navicat :
use schedule Back up of Characters DB and Realmd DB!
then you can restore it ,easily !

---

Ah thank you!

Quote:

---

Originally Posted by SharpSabre

by Navicat :
use schedule Back up of Characters DB and Realmd DB!
then you can restore it ,easily !

---

yes but thats for everyone, he want's to know how to do it for a single character

Quote:

---

Originally Posted by gregon13

yes but thats for everyone, he want's to know how to do it for a single character

---

when you done work on my first post
make a new DB as Recovery and try to save it the restore back up data !
then make some Queries(all tables) that can found the Character GUID !
[you must know SQL commands]

You could give him more hint you know...

@Noaru - you will have to extract those data from backup files ( I assume you DID some backups of realmd/character tables from DB..?)

Now you will have to export character DB into that Recovery one as SharpSabre said. All remaining operations you will run on that DB!

I'll write what particular tables/variables you will have to extract (based on WoW TBC mangos server):
Realmd DB: account(lookup by username and check it's ID), realmcharacters (lookup by acctid -> same number from accountID).
Character DB: characters (lookup for GUID! this will help you to find all remaining data about all characters of targeted account),
and now all remaining tables: arena_team / arena_team_member / arena_team_stats / auctionhouse / character_action / character_aura / character_gifts / character_homebind / character_instance / character_inventory / character_pet / character_queststatus / character_reputation / character_ticket / character_social / character_spell / character_spell_cooldown / character_tutorial / corpse / groups / group_member / guild / guild_bank_eventlog / guild_bank_item / guild_bank_right / guild_bank_tab / guild_member / guild_rank / instance / item_instance / item_text / mail / mail_items / petition / petition_sign / pet_aura / pet_spell / pet_spell_cooldown

Some sql commands I've written for ya in a hurry:

if you know char name you execute that on character DB:

Code:

---

SELECT guid, account, NAME FROM characters WHERE NAME LIKE 'char_name'

---

and you will get GUID number of char you want to find.
Now (almost)all char data based on GUID:

Code:

---

SELECT * FROM auctionhouse WHERE auctioneerguid = 1234;
SELECT * FROM character_action WHERE guid = 1234;
SELECT * FROM character_aura WHERE guid = 1234;
SELECT * FROM character_gifts WHERE guid = 1234;
SELECT * FROM character_homebind WHERE guid = 1234;
SELECT * FROM character_instance WHERE guid = 1234;
SELECT * FROM character_inventory WHERE guid = 1234;
SELECT * FROM character_pet WHERE OWNER = 1234;
SELECT * FROM character_queststatus WHERE guid = 1234;
SELECT * FROM character_reputation WHERE guid = 1234;
SELECT * FROM character_social WHERE guid = 1234;
SELECT * FROM character_spell WHERE guid = 1234;
SELECT * FROM character_spell_cooldown WHERE guid = 1234;

---

Mail, guild and instances queries are missing - don't have time to make more. I'm using SQLyog for it. Ater you change "1234" to char you are looking for you will get general info. Just export it to sql file and import back to your DB (use update)

This is for one char. If the account has been deleted... damn I don't have more time. But hope you will figure it out now :tongue:

Help it helps even a little.