Support:Queries: Difference between revisions
Jump to navigation
Jump to search
Content deleted Content added
imported>Kymara |
imported>Kymara |
||
| Line 26: | Line 26: | ||
insert into gameEvents (source, event, param1, param2) |
insert into gameEvents (source, event, param1, param2) |
||
values ('[character]','accountmerge','[character_account_id]', '[character]-->[account]'); |
values ('[character]','accountmerge','[character_account_id]', '[character]-->[account]'); |
||
</source> |
|||
=== Did a password get changed? === |
|||
<source lang="SQL"> |
|||
SELECT account.username, address, service, passwordChange.timedate, oldpassword |
|||
FROM account, passwordChange |
|||
WHERE account.id = passwordChange.player_id AND username ='[account]'; |
|||
</source> |
</source> |
||