Support:Queries

Bots

Checking if someone is a bot

The following queries lists the number of "use"-actions per player and hour. If there are high number of uses for several hours in a row, it is likely a bot.

<source lang="SQL"> SELECT source, left(timedate, 13) As day, count(*) As cnt FROM gameEvents WHERE (source='[name1]' OR source='[name2]') AND event='use' GROUP BY source, event, day ORDER BY day; </source>