Support:Queries: Difference between revisions
Jump to navigation
Jump to search
imported>Hendrik Brummermann checking for bot |
imported>Hendrik Brummermann checking for bot |
(No difference)
| |
Revision as of 19:42, 27 October 2010
Bots
Finding 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>