Technology [Data] Bans, Mutes, and Players per Month - Graphs

Here is our some graphs of our bans, mutes, and players per month, I was bored. Ban and mute spikes are from us banning alternative account lists or when bots join the server.

c = amount of bans that month
rt = running total of all bans


c = amount of mutes that month
rt = running total of all mutes


c = amount of players that joined that month
rt = running total of all players that joined


The SQL query used (bans shown):

Code:

SET @runtot:=0;
SELECT
   q1.d,
   q1.c,
   (@runtot := @runtot + q1.c) AS rt
FROM (
    SELECT
        CONCAT(
                MONTHNAME(
                    STR_TO_DATE(MONTH(ban_time), '%m')
                    ),
                " ",
                YEAR(ban_time)
            ) AS d,
        COUNT(*) AS c
    FROM
        ban
    GROUP BY
        YEAR(ban_time),
        MONTH(ban_time)
) AS q1

Running total from http://stackoverflow.com/questions/664700/calculate-a-running-total-in-mysql

 

The slope on the running total decreases as less new players join the server.

The players data is the amount of players who are new to the server, never played before. Not online or active players.

 

We were testing the hub system in September and published it in October. Looks pretty funny.