Support:Queries: Difference between revisions
Content deleted Content added
imported>Kymara |
imported>Hendrik Brummermann No edit summary |
||
Line 87:
=== Finding Bots ===
<source lang="sql">
SELECT left(timedate, 10) As day, source, param1, count(*) As cnt
FROM gameEvents
WHERE event='use' AND timedate>date_sub(CURDATE(), INTERVAL 3 day)
GROUP BY day, param1, source ORDER BY cnt DESC
LIMIT 50;
</source>
=== Checking if someone is a bot ===
| |||