Arianne

Support:Queries: Difference between revisions

← Older editNewer edit →
Content deleted Content added
VisualWikitext
imported>Kymara
imported>Hendrik Brummermann
Line 17:
</source>
 
=== Merge characterall characters into an account ===
 
<source lang="SQL">▼
1. Learn the name of the original account and new one:
-- get ids as we will need them later
 
select id as account_id from account where username = '[account]';
<pre>
select id as character_account_id from account where username = '[character]';
SELECT account.username, account.status
update account set status = 'merged' where username ='[character]';
FROM characters, account
update characters set player_id = '[account_id]' where charname = '[character]';
WHERE account.id=player_id AND charname='[charname]';
insert into gameEvents (source, event, param1, param2)
</pre>
values ('[character]','accountmerge','[character_account_id]', '[character]-->[account]');
 
2. As user marauroa execute the following script. <nowiki>[oldaccount]</nowiki> is the account name, from which the characters are taken away.
 
▲<source lang="SQLbash">
cd /var/www/stendhal/scripts/cmd
php merge.php [oldaccount] [newaccount]
</source>
 
Retrieved from "https://meet.konsthol.eu/w/index.php?title=Support:Queries"