Restoring deleted Character.

[kamote]

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.

 

[raventh1984]

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.

 

[kamote]

well that's what I did. but when you send a PM to that char it says (name) does not exist.

 

[Gravious]

Just find your designated character in your CHARACTER_TBL, then change IsBlock to F instead of D.

 

[kamote]

I did that but no one can send any PM to that character.