Changing account ID and character account in same time?

[labaouici]

Hello! As the title say, I would like to know if their a quick way to change an account ID in auth and make it apply columns of account too in characters

Thanks

[Brainy]

Just change the account ids and database names for following queries and run it on your mysql console. Be sure that no user is logged into the affected account while you're changing the ids.

 

SET @OLD_ACCOUNT_ID := XXXXXX;

SET @NEW_ACCOUNT_ID := XXXXXX;

UPDATE auth.account SET id = @NEW_ACCOUNT_ID WHERE id = @OLD_ACCOUNT_ID;

UPDATE characters.characters SET account = @NEW_ACCOUNT_ID WHERE account = @OLD_ACCOUNT_ID;

[labaouici]

Oh nice thanks

I'll try that

 

Edit : Works good

PS : (but is there a way to make it doing automatically for all account until their is no more ID?)

[Brainy]

If you tell me what exactly you wanna do, I will write down a small script which does it.

Do you just want to renumber the account ids to use unused account ids?

Or do you simply want to merge two account databases?

[Aokromes]

3 hours ago, labaouici said:

Oh nice thanks

I'll try that

 

Edit : Works good

PS : (but is there a way to make it doing automatically for all account until their is no more ID?)

https://github.com/TGM/characters_optimization but very likely it will need to be updated.

[labaouici]

Thanks for the answers and sorry for the last reply,

 

@Brainy

I tried to delete account & character who are on this account but I think I found a way