Character Winning Event

[misfun]

Greetings,

I have an server running and now i want to make an even where ya can win a complete lvl80 char with top equipment and enchants.. My question is how do i copy a character to a new account, is there a script available for this kind of action..

Thx in Advance..

MAiki

[Edder]

My question is how do i copy a character to a new account

I would try to just change the accountid in characters:

UPDATE `characters` SET `account`='accountid of the winner' WHERE (`guid`='charguid');

[xeross155]

I would try to just change the accountid in characters:

UPDATE `characters` SET `account`='accountid of the winner' WHERE (`guid`='charguid');

He wants to copy the character not move it to a different account.

[SyriosOne]

Use the command "pdump write filename playerguid" in the console to save.

Open it with an editor and delete the first rows to the first insert line.

Then use the command "pdump load filename accountid newname newguid"

Hope this help.

[Diablox]

Use the command "pdump write filename playerguid" in the console to save.

Open it with an editor and delete the first rows to the first insert line.

Then use the command "pdump load filename accountid newname newguid"

Hope this help.

Those lines are there for a good reason its not a good idea to delete them.

[SyriosOne]

Those lines are there for a good reason its not a good idea to delete them.

pdump load does not work with these lines.

It's just a warning, which you should not import the file directly via sql

[Diablox]

It works with those lines and it's not just a warning it is there to stop you from importing it in DB thats is not on same version as one from witch you get your pdump

[SyriosOne]

Oh you're right, but I can still remember the times that was not, so I had to always deleted this.

Sorry for my mistakes ^ ^ My last pdump use goes back a long time:)

But why tell me the console that?

SQL ERROR: Incorrect integer value: '' for column 'deleteInfos_Account' at row 1

and after change to 0 in the pdumpfile it comes

SQL ERROR: Incorrect integer value: '' for column 'deleteDate' at row 1

also set to 0 and it works.

Only once do I log in with the char before I restarted the server or it will be deleted

[misfun]

Thx for the help.. gonna try it on a test server

Well thx it works like a charm..

I had Char 'Demonika' on Account 'Administrator', i did in mangos : .pdump write Demonika Demonika

after that i added the char to Account 'Player' : .pdump load Demonika player Ellipsia (new char name)..

Mny Thx all..

MAiki

[Patman128]

Maybe mangos should implement character copy command?

[misfun]

This isn't to hard to use.. The commands are really self explaining after i used them.. It completly copies the char to another account with skills and bag inventory to..

[darkstalker]

Maybe mangos should implement character copy command?

pdump load/save works fine for that purpose