what is the fast way of to restore a character?

[Arex]

what is the fast way of to restore a char of character_backup to character_ table? is there any tool that help with it?

Thank You!

[RangerDown]

examine the GMCommands guide for the proper use of the #charbackup command.

[Arex]

Thank You Rangerdown, i only was thinking that it would be hard restore a backup because i didnt have a profile field in character_backup table.

[RangerDown]

that table had a profile field the last time I checked. Did something change with 7.0?

[Arex]

You have 2 profiles on character_ table, ext_profile and profile, and u only have one profile field on character_backup table, then i dont know why one of 2 profiles arent backup on character_backup table...

i have checked the code on character_backup command, i think that with the actual code if a guy have deleted to his char accidentally, he cant restore his character of backup using this command...

[fireclav]

i just tried the restore command it says char is restored but still doesnt show on my char screen. i had deleted him a bit ago and wanted to get him back is there any other way of doing this. he shows up in the char_backup in mysql but i cant get it to move it to character file

[mattmeck]

Did you hand delete out of the DB?

Or

Did you use the delete button on the character select?

If you just hit the delete button the character is still in the main character DB, just need to add you account number back into the proper field.

[oghog]

Anyone ever figure out an easy way to restore a deleted character once its gone out of the main table???...It seems as though the #charbackup doesnt work.

[Darkonig]

The only way you could possibly restore a character to a database from which you deleted it would be if you had a backup of the database from before you deleted it. Such a backup does not get created automatically.

[oghog]

Thanks for the reply. Maybe one of you SQL guru's could figure out how to get the #charbackup functions....I lost my oobah chanter hehe.

Seriously though, that would be a great function for the server admins if it worked properly..


Thanks again, Im sure I'll have more questions...

[Darkonig]

If all else fails and you have the GM status, you could always create a new character by the same name and just assign him the level and stats your old character had and summon him the gear.

[John Adams]

Are you sure the #charbackup restore [backup#] isn't working? You have to list them first, find the backup you want to restore and use the #. I haven't run this in a while, but I thought i was working before.

Check out commands.cpp in the source to see the flow. "void command_charbackup". SQL appears to be ok.

[oghog]

tested it with my chanter.
my 9 year old deleted him :shock:

ran the following commands

#charbackup list 13

it gave me the backup numbers there were 2. One from Sunday night and one from Monday night.

then i ran :

#charbackup restore *** (not sure what the number is as im at work)

Got reply "Character Restored"

No change in the character table, no change on login screen.