Character Editing and BAckup

[kevinhabar]

Hi
I got some problem with my characters.I have launched my server sucessfully.
But i can't edit my characters statics,location(while off-line).
1.I used GO command n sent my character in such a map that doesn't exist on my server or client.
How do i retrieve it back?
2.When i was incresing my Character Vitality manually suddenly the HP bar becomes Zero
and game exists,after that i m not able to login game by that character.
3.I can't write message in general.
4.I am Searching the forum from last week regarding the modifying the items property
there are a lots of posts over it but i am unable to modify my equips through SQL.
I've very less knowledge of SQL.(Some 1 plz spoon feed)
and finally
5.How can i save my game data(BackUp)? If i format my PC i don't want to make all the chars, friend-list, storage and how i'll use them back(after formatting).

Some one help me please
Thanks

 

[iNs@nE]

Stickies. Read the stickies. It's all there. OMG!

 

[cvrdheeraj]

As for character problems, you can use my GMTool which i posted. To change character location you can edit the location from the GMTool instead of using the SQL. Read that post with the link it has everything!

For making backups you need to have minimum knowledge about SQL Server which you can google and get help!

 

[kevinhabar]

Thanks Guys for helping
I've learned some SQL Editing(Enterprise manager>>Databse>>ASD>>Table>>charac0>>Open Table>>Return all rows: I was expecting this from u guys but any ways thanks,i have found it on the forum by a lot search ),and i got all my characters back(Hit n trial ).

But the chat in general is still disable.I searched the forum for this and found that there is some correpted file in the zoneserver n i need to replace it with raf71 server files so plz some one tell me which file i need to replace and if i'll replace these files,will my server work smooth?

You guys are really active in the forum.I love this forum.
Thanks again

 

[iNs@nE]

Well thnx a lot and now that you're learning - well I dont mind helping now.

Yep. In between a particular set of files were released where the chat didnt work. Download Raf's edited files. They're pretty much perfect. Tested them out and they're good.

 

[cvrdheeraj]

Use the Zoneserver.exe file and replace nothing else it works fine!