BlackMamba

The following sql statement will give you a list of your admins with a counter, how many bans, kicks and warnings they imposed.

select
    ifnull(c.name, 'b3') as name,
    sum(case when type = 'Ban' then 1 else 0 end) as ban,
    sum(case when type = 'TempBan' then 1 else 0 end) as tempban,
    sum(case when type = 'Kick' then 1 else 0 end) as kick,
    sum(case when type = 'Warning' then 1 else 0 end) as warning
from
    penalties p
    left join
    clients c
        on
        p.admin_id = c.id
where
    p.inactive = 0
    and
    p.type != 'Notice'
group by
    c.name
order by
    count(*) desc
;

Sometimes for me it’s interesting if a player is banned by two different admins due to cheating. Such players a highly suspicious to be real cheaters. Because of using b3 bot I can see the reasons for the bans in the database. I assume that reasons, which have the word wallhack, wh, aimbot, mombot or hax in it or a word starting with cheat or hack are reasons for cheating. There is an easy SQL statement to get such players (the statement shows only the players, which have at least one ban in the last month, I don’t want to get old cases):

select
    p.client_id,
    c.name
from
    penalties p
    join
    clients c
        on
        c.id = p.client_id
where
    p.type = 'TempBan'
    and
    p.admin_id > 0
    and
    (
        lower(p.reason) rlike '[[:<:]]cheat|hack'
        or
        lower(p.reason) rlike '[[:<:]]wallhack|wh|aimbot|mombot|hax[[:>:]]'
    )
    and
    p.inactive = 0
group by
    p.client_id,
    c.name
having
    max(p.admin_id)!=min(p.admin_id)
    and
    max(p.time_add) > unix_timestamp(date_add(now(), interval -1 month))
;