Support:Queries: Difference between revisions
Content deleted Content added
imported>Hendrik Brummermann checking for bot |
imported>Hendrik Brummermann characters and accounts |
||
Line 1:
== Characters and accounts ==
=== Account belonging to a character ===
<source lang="SQL">
SELECT account.*
FROM account, characters
WHERE characters.player_id=account.id AND charname='[character]';
</source>
=== Characters belonging to an account ===
<source lang="SQL">
SELECT characters.*
FROM account, characters
WHERE characters.player_id=account.id AND username='[account]'
</source>
== Bots ==
=== Finding Bots ===
{{TODO}}
=== Checking if someone is a bot ===
Line 11 ⟶ 30:
SELECT source, left(timedate, 13) As day, count(*) As cnt
FROM gameEvents
WHERE (source='[
</source>
| |||