How to do A character Transfer through the Db And some other usefull "character" tips

[xpxd]

Hello I Am xpxd and this is my second tut, well for the title "How to do A character Transfer through the Db And some other usefull "character" tips"
i Know it is long im sorry about that but well couldent quite make up my mind XD by "character" tips" I have arcemu so i say "character database for he database that has the characters inside the accounts, playeritems, .etc.

uhhhh... ok so lets start....
-*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*
Open Your //Navicat//Hedisql// and connect (default for arcemu is name-"root" pass "root"), goto the characters Db (for ascent i think its logon)
and goto accounts, now you see all the accounts in your server, now on the first row which must be called "acct" there is the id for each account. ok now goto chracters table.Now you see all the characters in your server (if you have alot of players theyl be quite alot)now there on the second row it is also called "acct" (this is part 2 ill have some extra "tips" in the end of the tut) so the "acct=account" in the characters table represents the account the character is in so to do the transfer you get an id of an account from the accounts table and swap it with the one on the character ou want to transfer.

soo thats the character tranfer part but i promised some extra tips-- so

-*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*
How to remove an item from a character through the database.
well i know the first thing youll think is this is stupid you could just do .character removeitem <ID> But sometimes players have this bug that when they equip that item they disconnect from server and cant log in back to the character. so goto the "Characters" DB (explained in the tut above)
and find the table "playeritems" so now you see ALOT (exept if your server is empty) of numbers, so the "ownerguid" is the owner of the item (you can find the "guid" of a player in the "characters" table) and the "entry" is the entry/Id of the item so well you get the point you can delete it or chaneg the entry i wont go into depth right now maybe in another tut because well there is alot of things that you can do..
(you can (obviousely) change the ownership of an item)
-*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*
How to see mail sent in the server
goto the "characters" DB and goto the table "Mailbox" we wont be going over the first to rows right now so lets take a look at the third row "player_guid" it is the id of the player (how to get it is explained in the second tut in this thread) who recived it. the fourth row again having to do again with "playerguid's" show the id of the player who sent the mail.well the rest is mostly self explanator the subject is the subject the body is the message itself the "attached item guids" is the entrys of the items attached to the mail, and well dont mess with the rest (theyr more advanced options)
-*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*
The "tips" i talked about in the second tut so go to the "characters" Db and to the "Characters" Table and by looking at the rows some are self explanatory and some are not... well the race and class are so ill just give you the id's..
<I need to search them but i dont have time if anybody can leave them on a comment i would b grateful>
-*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*
Backing up your database ..
this is based on arcemu (johved)
ok...
make a folder caled backup then go to your arcemu folder and goto database then data, copy everything from there to the bacakup folder... so if your db crashes and something happens and they get deleted-just copy and replace them and it will be fine -Remember that the moment you replace them the database will be changed to how it was when you made the backup so update your backup often!!!



i hope you liked it please dont leave negative comments!! -by xpxd

-*--*--*-PLEASE LEAVE FEEDBACK (COMMENTS)-*--*--*--*--*--*-

[xpxd]

PLEase SoMe FeEdBaCk

[xpxd]

GUYS PLEASE 44 Views An No Replies

[sasoritail]

N00b Easy Guide :P
I have done this several times before...
i couldnt find it in the forum before now
+Rep for a nice n00b easy guide

[xpxd]

in my opinion i now much more advance things but i like making guides realy easy to understand so people dont have problems since i had to learn by waiting 48 for the unclear parts of a tut to be explained

[rakic]

Can you post some tut on backup mangos characters and db?

[xpxd]

im so sorry but i have no idia how mangos or ascent, aspire and other Emulators exept arcemu work but i think its about the same thing

[redlion829]

it help me alot +rep