breadfish Statistiken 2017

ausgeteilte Verwarnungen 2017

MariaDB [breadfish]> SELECT judgeID, COUNT(*) FROM wcf1_user_infraction_warning WHERE time BETWEEN '1483225200' AND '1513886400' GROUP BY judgeID;
+---------+----------+
| judgeID | COUNT(*) |
+---------+----------+
|    2520 |      124 |
|    3066 |       20 |
|   12701 |       34 |
|   13423 |       83 |
|   15905 |      144 |
|   35362 |       73 |
+---------+----------+


Gemessen im Zeitraum von 01.01.2017 00:00 Uhr (Timestamp 1483225200) und dem 21.12.1017 21:00 Uhr (Timestamp 1513886400)

ausgeteilte Verwarnungen insgesamt

MariaDB [breadfish]> SELECT judgeID, COUNT(*) FROM wcf1_user_infraction_warning GROUP BY judgeID;
+---------+----------+
| judgeID | COUNT(*) |
+---------+----------+
|       1 |        1 |
|       7 |       40 |
|    1614 |       10 |
|    2464 |        3 |
|    2520 |      449 |
|    2768 |        6 |
|    2769 |        1 |
|    3066 |      117 |
|    6393 |        2 |
|   12701 |      102 |
|   13423 |      216 |
|   15905 |      341 |
|   35362 |      194 |
+---------+----------+
13 rows in set (0.00 sec)

Beiträge (Posts) 2017

MariaDB [breadfish]> SELECT postID, count(*) FROM wbb1_post WHERE time BETWEEN '1483225200' AND '1513886400';
+---------+----------+
| postID  | count(*) |
+---------+----------|
| 2245931 |    49384 | <-
+---------+----------+

Gemessen im Zeitraum von 01.01.2017 00:00 Uhr (Timestamp 1483225200) und dem 21.12.1017 21:00 Uhr (Timestamp 1513886400)

Donator Käufe

MariaDB [breadfish]> SELECT subscriptionID, COUNT(*) FROM wcf1_paid_subscription_transaction_log wHERE logMessage = 'payment completed' GROUP BY subscriptionID;
+----------------+----------+
| subscriptionID | COUNT(*) |
+----------------+----------+
|              1 |      175 |
|              2 |       24 |
|              3 |       34 |
+----------------+----------+
3 rows in set (0.00 sec)

Dazu sollte man erwähnen dass die Zahlen vom Vorjahr eventuell falsch sind weil ich damals vermutlich keine Doppelten Käufe sowie
Käufe mit geklauten PP Konten von der Zählung ausgeschlossen habe (was dieses Mal der Fall ist durch das logMessage = 'payment completed'

gesperrte User insgesamt

MariaDB [breadfish]> SELECT COUNT(*) FROM wcf1_user WHERE banned = '1';
+----------+
| COUNT(*) |
+----------+
|     3783 |
+----------+

neue Benutzer 2017

MariaDB [breadfish]> SELECT userID, count(*) FROM wcf1_user WHERE registrationDate BETWEEN '1483225200' AND '1513886400';
+--------+----------+
| userID | count(*) |
+--------+----------+
|  40652 |     1361 | <-
+--------+----------+
1 row in set (0.00 sec)

Gemessen im Zeitraum von 01.01.2017 00:00 Uhr (Timestamp 1483225200) und dem 21.12.1017 21:00 Uhr (Timestamp 1513886400)

permanente Sperren

SELECT * FROM `wcf1_user_infraction_suspension` ORDER BY `suspensionID` DESC LIMIT 16;
+------------------+--------+--------------+------------+---------+---------+---------+-----------+
| userSuspensionID | userID | suspensionID | time       | expires | revoked | revoker | warningID |
+------------------+--------+--------------+------------+---------+---------+---------+-----------+
|             1703 |  41820 |            7 | 1509804479 |       0 |       0 |    NULL |      1463 |
|             1537 |  41364 |            7 | 1498484266 |       0 |       0 |    NULL |      1307 |
|             1499 |  40079 |            7 | 1495113700 |       0 |       0 |    NULL |      1269 |
|             1276 |  40718 |            7 | 1484313513 |       0 |       0 |    NULL |      1079 |
|             1253 |  39276 |            7 | 1483892013 |       0 |       0 |    NULL |      1066 |
|             1193 |  38825 |            7 | 1482429529 |       0 |       0 |    NULL |      1013 |
|             1173 |  34228 |            7 | 1481896037 |       0 |       0 |    NULL |      1000 |
|             1044 |  40337 |            7 | 1477810746 |       0 |       0 |    NULL |       885 |
|              809 |  39706 |            7 | 1470768101 |       0 |       0 |    NULL |       702 |
|              599 |  39304 |            7 | 1464736753 |       0 |       0 |    NULL |       513 |
|              478 |  36225 |            7 | 1461505286 |       0 |       0 |    NULL |       399 |
|              306 |  37172 |            7 | 1456835778 |       0 |       0 |    NULL |       264 |
|              234 |  18171 |            7 | 1454455592 |       0 |       0 |    NULL |       223 |
|              206 |  37974 |            7 | 1453416487 |       0 |       0 |    NULL |       198 |
|               99 |  36139 |            7 | 1447176494 |       0 |       0 |    NULL |       106 |
|               53 |  35418 |            7 | 1445542759 |       0 |       0 |    NULL |        63 |
+------------------+--------+--------------+------------+---------+---------+---------+-----------+

7 = Permaban

Verwarnungen

SELECT userID, count(*) FROM wcf1_user_infraction_warning GROUP BY userid HAVING count(*) >= 9;
+--------+----------+
| userID | count(*) |
+--------+----------+
|  17184 |       11 |
|  21592 |       11 |
|  27967 |       10 |
|  28457 |       18 |
|  31944 |       13 |
|  33134 |       12 |
|  33270 |       12 |
|  36480 |       13 |
|  36685 |        9 |
|  37387 |        9 |
|  38105 |        9 |
|  38482 |       13 |
|  38825 |        9 |
|  39107 |        9 |
|  39304 |       13 |
|  40133 |       17 |
|  40657 |        9 |
+--------+----------+