Someone

on ^$*:TEXT:/^!stats\b/:#: {
  var %pretime = $ctime, %timeperiod = $2
  if (%timeperiod == year) var %cutoff = $calc(%pretime - 31556926)
  elseif (%timeperiod == month) var %cutoff = $calc(%pretime - 2629744)
  else var %cutoff = $calc(%pretime - 86400)

  var %sql = SELECT DISTINCT user.nick, COUNT(pretime) AS total FROM pre, user WHERE pretime > %cutoff AND pre.userID = user.ROWID GROUP BY user.nick ORDER BY total DESC LIMIT 10;

  if (!%pre_db) { echo 4 -a ERROR: Not connected to database | return }
  else {
    var %request = $sqlite_query(%pre_db, %sql)
    if (!%request) { echo 4 -a ERROR: %sqlite_errstr | return }
    else {
      while ($sqlite_fetch_row(%request, row)) {
        var %nick = $hget(row,1), %count = $hget(row,2)
        msg $chan %nick %count
      }
    }
  }
}