Restoring deleted Character.
I'm trying to restore a delete character(ingame). I tried changing the isBlock column in the database and the character showed up in the character select but now no one can PM the character. It says (Name) does not exist. I Checked the stored procedure of CHARACTER_TBL it will edit the isBlock column and such in the CHARACTER_TBL and will edit the state in the MESSENGER_TBL but when I check the MESSENGER_TBL, it was empty. Any Ideas on how to totally restore a character that was deleted in game?
Thank you.
Re: Restoring deleted Character.
Well i have checked my database and i have no data in it.
However i have over 2k Chars.
So If someone is deleted their char what i only do is this
Open mssql server
And use this code
USE CHARACTER_01_DBF
UPDATE CHARACTER_TBL SET isBlock = 'F' WHERE m_szName = '[Charname]'
Then the char is restored and everyone in the server can talk to it again.
Re: Restoring deleted Character.
well that's what I did. but when you send a PM to that char it says (name) does not exist.
Re: Restoring deleted Character.
Just find your designated character in your CHARACTER_TBL, then change IsBlock to F instead of D.
Re: Restoring deleted Character.
I did that but no one can send any PM to that character.