So i made a new query that pretty much fucked up my db and lost all the accounts like it was weird idk what the fuck 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.
[Help/Question]Transfering chars from an account to another.
09/27/2012 20:52
fadyi#1
09/27/2012 20:53
PortalDark#2
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
just change that to the account you want
09/27/2012 20:58
A new hope#3
_User table
09/27/2012 21:01
fadyi#4
Ye the JIDAccount ? my old ids are still there but they are gone from the TB_UserQuote:
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
More details, please ? :)Quote:
09/27/2012 21:09
A new hope#5
Change the JID.Quote:
09/27/2012 21:49
fadyi#6
When i do that i get this errorQuote:
[Only registered and activated users can see links. Click Here To Register...]
._.
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 -_-
09/27/2012 22:10
qoaway#7
delete keys from _accountjid and _userQuote:
[Only registered and activated users can see links. Click Here To Register...]
._.
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 -_-
09/27/2012 22:22
fadyi#8
Sorry, I am new to this whole thing so i got to ask. How do i do that? :)Quote:
09/28/2012 23:23
youngvegas#9
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
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