PDA

View Full Version : Char swap -> one ls account to another?


MarglarTZ
03-26-2009, 08:15 PM
Could one of you experienced folks points me in the right direction - I want to move a toon from one login server account to another, and was curious where one might have to look in the db to altar that. dual boxing does not work well when the two toons are on the same LS account.

appreciate the help in advance!

Theeper
03-26-2009, 09:34 PM
The 'account_id' field in the character_ table relates to the 'id' field in the account table.

Locate the LS account you want to move your toon to in the account table, and note it's 'id'. Then, put that 'id' into the 'account_id' field of the character_ table in the row of the character you want to change.

MarglarTZ
03-26-2009, 10:03 PM
+10 internets to you, thank you very much.

trevius
03-27-2009, 12:57 AM
Another really easy way to do it is to use the webtool that comes with the eqemu server. Just enable it in your server config on this line:

<http port="9080" enabled="true" mimefile="mime.types" />

Then, restart your server and in your web browser, enter this:

http://localhost:9080/

Then, you can select "Database" on the left and "Account" and do your search from there. Find the account you are wanting to move the char to, and copy the account ID. Then, search for the account or char that you are moving from and you will see the option to move the character. Then just paste the account ID you copied earlier and do the move.

It sounds like alot of steps, but it is actually very quick and simple. If you plan to do account moves for people regularly, it is good to know this way. If you have port 9080 forwarded on your router to your server, you can also do these account moves from anywhere remotely, which can also come in handy :)