Support:Queries: Difference between revisions
Jump to navigation
Jump to search
Content deleted Content added
imported>Hendrik Brummermann characters and accounts |
imported>Hendrik Brummermann No edit summary |
||
| Line 15: | Line 15: | ||
FROM account, characters |
FROM account, characters |
||
WHERE characters.player_id=account.id AND username='[account]' |
WHERE characters.player_id=account.id AND username='[account]' |
||
</source> |
|||
== Items == |
|||
=== Item history of all items touched by suspicious character === |
|||
<source lang="SQL"> |
|||
SELECT * FROM itemlog, (SELECT DISTINCT itemid FROM itemlog WHERE source IN ('[charname1]', '[charname2]')) As x |
|||
WHERE x.itemid=itemlog.itemid |
|||
ORDER BY itemlog.itemid, itemlog.id |
|||
</source> |
</source> |
||