Support:Queries: Difference between revisions
Content deleted Content added
imported>Hendrik Brummermann |
imported>Kymara how to merge a character into an account |
||
Line 17:
</source>
=== Merge character into an account ===
<source lang="SQL">
-- get ids as we will need them later
select id as account_id from account where username = '[account]';
select id as character_account_id from account where username = '[character]';
update account set status = 'merged' where username ='[character]';
update characters set player_id = '[account_id]' where charname = '[character]';
insert into gameEvents (source, event, param1, param2)
values ('dankass','accountmerge','[character_account_id]', 'dankass-->[account]');
</source>
== Items ==
| |||