[Help/Question]Transfering chars from an account to another.

[fadyi]

So i made a new query that pretty much ****** up my db and lost all the accounts like it was weird idk what the **** happened but anyways...the chars are still there so is there a way to move/transfer the chars to another accounts ? sadly i had no back up files so ye any help will be greatly appreciated.

[PortalDark]

if im not wrong, the characters got a column that associates with the JID of the user
just change that to the account you want

[A new hope]

_User table

[fadyi]

Originally Posted by PortalDark

if im not wrong, the characters got a column that associates with the JID of the user
just change that to the account you want

Ye the JIDAccount ? my old ids are still there but they are gone from the TB_User

Originally Posted by A new hope

_User table

More details, please ?

[A new hope]

Originally Posted by fadyi

More details, please ?

Change the JID.

[fadyi]

Originally Posted by A new hope

Change the JID.

When i do that i get this error

._.
Tried to edit the AccountJID and delete the old id and it didn't work...... so ye i just don't wanna lose my chars -_-

[qoaway]

Originally Posted by fadyi

When i do that i get this error

._.
Tried to edit the AccountJID and delete the old id and it didn't work...... so ye i just don't wanna lose my chars -_-

delete keys from _accountjid and _user

[fadyi]

Originally Posted by qoaway

delete keys from _accountjid and _user

Sorry, I am new to this whole thing so i got to ask. How do i do that?

[youngvegas]

Fady , go to the TB_user
go to the Char table

each jid matches

just switch the char JID associated with the account to the account int he JIDs under tb_user