Register a SA Forums Account here!
JOINING THE SA FORUMS WILL REMOVE THIS BIG AD, THE ANNOYING UNDERLINED ADS, AND STUPID INTERSTITIAL ADS!!!

You can: log in, read the tech support FAQ, or request your lost password. This dumb message (and those ads) will appear on every screen until you register! Get rid of this crap by registering your own SA Forums Account and joining roughly 150,000 Goons, for the one-time price of $9.95! We charge money because it costs us money per month for bills, and since we don't believe in showing ads to our users, we try to make the money back through forum registrations.
 
  • Locked thread
froward
Jun 2, 2014

by Azathoth
in the name of OSI BEan Dip do i make this holy thread, sacrosanct in the eyes of the LOL.

OSI Bean Dip posted:

This JSON file (data.json) contains all ban, probation, and permaban detail from August 7th, 2004 through to September 9th, 2015. The data is not provided in a sorted format but timestamps are provided.

You can see the nasty poo poo here.

Some preliminary analysis by ap
code:
MariaDB [test]> SELECT 
 TargetUserName, 
 COUNT(*) * 10 AS wallet_damage 
 FROM lepers WHERE BanType = 'ban' 
 GROUP BY TargetUserName ORDER BY wallet_damage DESC LIMIT 30;
+-----------------------+---------------+
| TargetUserName        | wallet_damage |
+-----------------------+---------------+
| Kingsbury2            |           350 |
| vilepilot             |           310 |
| IzzyFnStradlin        |           290 |
| Kyoon_                |           270 |
| DB_Cooper             |           260 |
| TenementFunster       |           200 |
| Marxux                |           190 |
| Avshalom              |           180 |
| big duck equals goose |           160 |
| Orc-Slayer 6000       |           160 |
| Kyoon__               |           160 |
| Narciss               |           140 |
| quite the fucker      |           130 |
| Jezza                 |           130 |
| A Major Fucker        |           130 |
| Pipe Dreamer          |           130 |
| Zeitgueist            |           120 |
| autopsy-turvey        |           120 |
| Black Baby Goku       |           120 |
| I.N.R.I               |           120 |
| Bum the Sad           |           110 |
| rivetz                |           110 |
| Teabiscuit            |           110 |
| a creepy colon        |           110 |
| WEED LORD             |           110 |
| circ dick soleil      |           110 |
| NULL                  |           110 |
| ArfJason              |           110 |
| M. Discordia          |           110 |
| fishmech              |           100 |
+-----------------------+---------------+
code:
MariaDB [test]> SELECT 
 TargetUserName, 
 COUNT(BanType) AS count, 
 SUM(IF(BanType = 'ban', 1, 0)) AS bans, 
 SUM(IF(BanType = 'probation', 1, 0)) AS `probations`, 
 SUM(IF(BanType = 'permaban', 1, 0)) As permabans 
 FROM lepers GROUP BY TargetUserName ORDER BY count DESC LIMIT 30;
+---------------------+-------+------+------------+-----------+
| TargetUserName      | count | bans | probations | permabans |
+---------------------+-------+------+------------+-----------+
| drilldo squirt      |   216 |    4 |        212 |         0 |
| Big Milton Fan Here |   196 |    2 |        194 |         0 |
| Never Post Again    |   189 |    4 |        185 |         0 |
| I.N.R.I             |   122 |   12 |        110 |         0 |
| TenementFunster     |   104 |   20 |         83 |         1 |
| psyopmonkey         |   101 |    3 |         98 |         0 |
| circ dick soleil    |    96 |   11 |         85 |         0 |
| Black Baby Goku     |    84 |   12 |         71 |         1 |
| TheLovablePlutonis  |    84 |    4 |         80 |         0 |
| Cole                |    81 |    0 |         81 |         0 |
| Surprisingly Dope   |    80 |    6 |         74 |         0 |
| Suicide Sam E.      |    75 |    0 |         74 |         1 |
| Al Borland          |    75 |    2 |         73 |         0 |
| Dr. Gitmo Moneyson  |    73 |    5 |         68 |         0 |
| why the ____ ____   |    69 |    7 |         62 |         0 |
| a Loving Dog        |    69 |    7 |         62 |         0 |
| Iseeyouseemeseeyou  |    67 |    9 |         58 |         0 |
| ANIME MONSTROSITY   |    65 |    2 |         62 |         1 |
| tbp                 |    64 |    8 |         56 |         0 |
| Avshalom            |    64 |   18 |         46 |         0 |
| Grass Effect        |    63 |    0 |         63 |         0 |
| The Taint Reaper    |    62 |    0 |         62 |         0 |
| IzzyFnStradlin      |    60 |   29 |         31 |         0 |
| OMFG PTSD LOL PBUH  |    60 |   10 |         50 |         0 |
| ArfJason            |    60 |   11 |         49 |         0 |
| garbage owl         |    58 |    2 |         56 |         0 |
| El GiNGiS           |    58 |    1 |         57 |         0 |
| Whirlwind Jones     |    58 |    3 |         55 |         0 |
| Breath Ray          |    57 |    4 |         53 |         0 |
| Nonviolent J        |    57 |    8 |         49 |         0 |
+---------------------+-------+------+------------+-----------+
and OSI reports dece five figggies for the 'tax
code:
MariaDB [test]> SELECT 
 SUM(x.adj_count) * 10 as ban_profit 
 FROM ( SELECT TargetUserName, COUNT(*) - 1 AS adj_count 
 FROM lepers WHERE BanType = "ban" GROUP BY TargetUserName) AS x\G
*************************** 1. row ***************************
ban_profit: 66400

froward fucked around with this message at 21:08 on Sep 11, 2015

Adbot
ADBOT LOVES YOU

echinopsis
Apr 13, 2004

by Fluffdaddy
lmao owned

Sharktopus
Aug 9, 2006

can i get this in yaml

Wiggly Wayne DDS
Sep 11, 2010



october 16th is the most dangerous day

Lain Iwakura
Aug 5, 2004

The body exists only to verify one's own existence.

Taco Defender
the first person to get a 100,000 hour probation will have it expire on october 4th, 2016

i hope they return to post

echinopsis
Apr 13, 2004

by Fluffdaddy
drat i got a count of 55 im so close to being on that bottom list

Cold on a Cob
Feb 6, 2006

i've seen so much, i'm going blind
and i'm brain dead virtually

College Slice
probations and bans have been requested by 428 distinct mods/admins (incl. radium)


OSI bean dip posted:

the first person to get a 100,000 hour probation will have it expire on october 4th, 2016

i hope they return to post

:agreed:

Notorious R.I.M.
Jan 27, 2004

up to my ass in alligators
Most banned member award goes to Kyoon. If anyone knows any other of his alts we can keep the tally going:

code:
MariaDB [(none)]> SELECT COUNT(*) AS kyoon_bans
    -> FROM test.lepers
    -> WHERE BanType = 'ban'
    -> AND TargetUserName LIKE 'Kyoon%'
    -> OR TargetUserName IN ('MyFire', 'The 11th Fact', 'The Simple Truth', 'TomJerry', 'VERY LAST DISCIPLE', 'Web of Truth', 'Web-of-Truth', 'gold45revolver')\G
*************************** 1. row ***************************
kyoon_bans: 81

Lain Iwakura
Aug 5, 2004

The body exists only to verify one's own existence.

Taco Defender

Notorious R.I.M. posted:

Most banned member award goes to Kyoon. If anyone knows any other of his alts we can keep the tally going:

code:
MariaDB [(none)]> SELECT COUNT(*) AS kyoon_bans
    -> FROM test.lepers
    -> WHERE BanType = 'ban'
    -> AND TargetUserName LIKE 'Kyoon%'
    -> OR TargetUserName IN ('MyFire', 'The 11th Fact', 'The Simple Truth', 'TomJerry', 'VERY LAST DISCIPLE', 'Web of Truth', 'Web-of-Truth', 'gold45revolver')\G
*************************** 1. row ***************************
kyoon_bans: 81

over $800 now

i originally thought he was like $750

univbee
Jun 3, 2004




OSI bean dip posted:

the first person to get a 100,000 hour probation will have it expire on october 4th, 2016

i hope they return to post

bigpeeler, right?

froward
Jun 2, 2014

by Azathoth
these are just counting re-reg fees, tho. sometimes they also re-buy avatars & pm priviledges

Squeezy Farm
Jun 16, 2009

OSI bean dip posted:

over $800 now

i originally thought he was like $750

that's basically nothing if you make a deece sally tho

Lain Iwakura
Aug 5, 2004

The body exists only to verify one's own existence.

Taco Defender

univbee posted:

bigpeeler, right?

http://forums.somethingawful.com/member.php?action=getinfo&userid=78215

i'm not sure if the probation is still in effect though

Notorious R.I.M.
Jan 27, 2004

up to my ass in alligators

froward posted:

these are just counting re-reg fees, tho. sometimes they also re-buy avatars & pm priviledges

Yeah it also assumes that the last ban was final, i.e. you didn't pay to unban the last one. Using the current number as a yardstick it's probably somewhere closer to 100k or so.

Number19
May 14, 2003

HOCKEY OWNS
FUCK YEAH



i hope they get another 100,000 hour probation for their first post back if they make one

arnbiguous
Feb 2, 2014
Gary’s Answer
pretty sure everybody with a 100,000 hour probation is way too mentally ill to have actually stayed away from the forums

Lain Iwakura
Aug 5, 2004

The body exists only to verify one's own existence.

Taco Defender

oh goddamn it is



http://forums.somethingawful.com/showthread.php?threadid=1552163&pagenumber=2&perpage=40#post299214930

[edit]

time machine

Lain Iwakura fucked around with this message at 22:12 on Sep 11, 2015

echinopsis
Apr 13, 2004

by Fluffdaddy

im full of poo poo posted:

pretty sure everybody with a 100,000 hour probation is way too mentally ill to have actually stayed away from the forums

:(

Symbolic Butt
Mar 22, 2009

(_!_)
Buglord
who is *redacted*

Symbolic Butt fucked around with this message at 22:33 on Sep 11, 2015

PipeRifle
Oct 4, 2004

we have catte

univbee posted:

bigpeeler, right?

that's a name I haven't heard in a long, long time

Lain Iwakura
Aug 5, 2004

The body exists only to verify one's own existence.

Taco Defender

Symbolic Butt posted:

who is OSI bean dip

Symbolic Butt
Mar 22, 2009

(_!_)
Buglord
oh hey *redacted*

how's it going

Symbolic Butt fucked around with this message at 22:33 on Sep 11, 2015

PleasureKevin
Jan 2, 2011

hey great job making a .json file open source so we can go edit it lol what

PleasureKevin
Jan 2, 2011

make a freaking API

Notorious R.I.M.
Jan 27, 2004

up to my ass in alligators
perma bans not necessarily perma

code:
MariaDB [test]> SELECT TargetUserName, COUNT(*) AS perma_count
FROM lepers
WHERE BanType = 'permaban'
AND TargetUserName <> 'NULL'
GROUP BY TargetUserName HAVING perma_count > 2
ORDER BY perma_count DESC;
+------------------+-------------+
| TargetUserName   | perma_count |
+------------------+-------------+
| putnam           |           4 |
| DONT BAN ME BRO  |           4 |
| Legalize Pol Pot |           3 |
| FAKEPOST POLICE  |           3 |
| Kyoon_           |           3 |
+------------------+-------------+

pram
Jun 10, 2001
can you sort by who has the highest probation time

arnbiguous
Feb 2, 2014
Gary’s Answer
would probably have to omit the 100,000 hours people

Sharktopus
Aug 9, 2006

PleasureKevin posted:

hey great job making a .json file open source so we can go edit it lol what

quoting this now for when this guy wants to edit out his stupidity later

funeral home DJ
Apr 21, 2003


Pillbug
if that 10,000 hour probation person comes back they should honor them with admin status then ban them for coming back to a forum 11 years later

Notorious R.I.M.
Jan 27, 2004

up to my ass in alligators

pram posted:

can you sort by who has the highest probation time

Here it is with the 100,000 hour probations removed:

code:
MariaDB [test]> SELECT TargetUserName, SUM(BanLength)/86400 as probate_days, COUNT(BanLength) AS probate_instances
    -> FROM lepers
    -> WHERE BanType = 'probation'
    -> AND BanLength <> '360000000'
    -> GROUP BY TargetUserName
    -> ORDER BY probate_days DESC LIMIT 50;
+----------------------+--------------+-------------------+
| TargetUserName       | probate_days | probate_instances |
+----------------------+--------------+-------------------+
| TenementFunster      |     439.0000 |                83 |
| Narciss              |     395.7500 |                39 |
| Zeitgueist           |     345.2500 |                43 |
| autopsy-turvey       |     298.5000 |                33 |
| Never Post Again     |     288.2500 |               185 |
| Black Baby Goku      |     282.2500 |                71 |
| I.N.R.I              |     274.2500 |               110 |
| Iseeyouseemeseeyou   |     263.0000 |                58 |
| Retarded_Clown_      |     254.7500 |                37 |
| Nonviolent J         |     242.7500 |                49 |
| Cabbagepots          |     235.2500 |                38 |
| Rass P               |     231.5000 |                41 |
| Duck and Cover       |     231.5000 |                34 |
| Grandpas a Racist    |     227.0000 |                19 |
| Iluvlortab           |     226.5000 |                43 |
| Dirty Rob            |     226.2500 |                22 |
| IzzyFnStradlin       |     220.2500 |                31 |
| Vaerai Archon        |     219.5000 |                29 |
| Dr. Gitmo Moneyson   |     216.2500 |                68 |
| rbis4rbb             |     213.0000 |                16 |
| T-Paine              |     209.0000 |                32 |
| a Loving Dog         |     204.0000 |                62 |
| Emden                |     203.0000 |                23 |
| mootmoot             |     202.7500 |                15 |
| Cool Bear            |     202.5000 |                20 |
| MOVIE MAJICK         |     200.5000 |                29 |
| SpeedGem             |     198.2500 |                29 |
| Lord Waffle Beard    |     196.7500 |                30 |
| gowb                 |     196.2500 |                27 |
| doritos              |     196.0000 |                25 |
| Vile                 |     196.0000 |                39 |
| Particle Board       |     195.7500 |                15 |
| Devour               |     195.0000 |                32 |
| LostCause            |     192.5000 |                25 |
| Turn left Dale!! Noo |     192.5000 |                19 |
| Morphix              |     192.2500 |                24 |
| asbo subject         |     189.0000 |                19 |
| actionjackson        |     188.7500 |                29 |
| echinopsis           |     187.7500 |                48 |
| Shakespearean Beef   |     187.7500 |                29 |
| Paul Pot             |     182.2500 |                19 |
| Willa Rogers         |     182.2500 |                20 |
| All Of The Dicks     |     181.2500 |                22 |
| Teabiscuit           |     180.7500 |                13 |
| Mr. Unlucky          |     178.2500 |                28 |
| Matlock, BRB         |     178.0000 |                17 |
| Goatstein            |     178.0000 |                26 |
| a creepy colon       |     177.7500 |                41 |
| gently caress da Mods         |     176.5000 |                25 |
| Casino               |     175.5000 |                13 |
+----------------------+--------------+-------------------+

Symbolic Butt
Mar 22, 2009

(_!_)
Buglord

Notorious R.I.M. posted:

code:
| echinopsis           |     187.7500 |                48 |

:smugmrgw:

Lain Iwakura
Aug 5, 2004

The body exists only to verify one's own existence.

Taco Defender

PleasureKevin posted:

make a freaking API

i would if i had some time. the tools i used to compile the data from html is part of canary so i cannot even give those out

pram
Jun 10, 2001

Notorious R.I.M. posted:

Here it is with the 100,000 hour probations removed:

code:
MariaDB [test]> SELECT TargetUserName, SUM(BanLength)/86400 as probate_days, COUNT(BanLength) AS probate_instances
    -> FROM lepers
    -> WHERE BanType = 'probation'
    -> AND BanLength <> '360000000'
    -> GROUP BY TargetUserName
    -> ORDER BY probate_days DESC LIMIT 50;
+----------------------+--------------+-------------------+
| TargetUserName       | probate_days | probate_instances |
+----------------------+--------------+-------------------+
| TenementFunster      |     439.0000 |                83 |
| Narciss              |     395.7500 |                39 |
| Zeitgueist           |     345.2500 |                43 |
| autopsy-turvey       |     298.5000 |                33 |
| Never Post Again     |     288.2500 |               185 |
| Black Baby Goku      |     282.2500 |                71 |
| I.N.R.I              |     274.2500 |               110 |
| Iseeyouseemeseeyou   |     263.0000 |                58 |
| Retarded_Clown_      |     254.7500 |                37 |
| Nonviolent J         |     242.7500 |                49 |
| Cabbagepots          |     235.2500 |                38 |
| Rass P               |     231.5000 |                41 |
| Duck and Cover       |     231.5000 |                34 |
| Grandpas a Racist    |     227.0000 |                19 |
| Iluvlortab           |     226.5000 |                43 |
| Dirty Rob            |     226.2500 |                22 |
| IzzyFnStradlin       |     220.2500 |                31 |
| Vaerai Archon        |     219.5000 |                29 |
| Dr. Gitmo Moneyson   |     216.2500 |                68 |
| rbis4rbb             |     213.0000 |                16 |
| T-Paine              |     209.0000 |                32 |
| a Loving Dog         |     204.0000 |                62 |
| Emden                |     203.0000 |                23 |
| mootmoot             |     202.7500 |                15 |
| Cool Bear            |     202.5000 |                20 |
| MOVIE MAJICK         |     200.5000 |                29 |
| SpeedGem             |     198.2500 |                29 |
| Lord Waffle Beard    |     196.7500 |                30 |
| gowb                 |     196.2500 |                27 |
| doritos              |     196.0000 |                25 |
| Vile                 |     196.0000 |                39 |
| Particle Board       |     195.7500 |                15 |
| Devour               |     195.0000 |                32 |
| LostCause            |     192.5000 |                25 |
| Turn left Dale!! Noo |     192.5000 |                19 |
| Morphix              |     192.2500 |                24 |
| asbo subject         |     189.0000 |                19 |
| actionjackson        |     188.7500 |                29 |
| echinopsis           |     187.7500 |                48 |
| Shakespearean Beef   |     187.7500 |                29 |
| Paul Pot             |     182.2500 |                19 |
| Willa Rogers         |     182.2500 |                20 |
| All Of The Dicks     |     181.2500 |                22 |
| Teabiscuit           |     180.7500 |                13 |
| Mr. Unlucky          |     178.2500 |                28 |
| Matlock, BRB         |     178.0000 |                17 |
| Goatstein            |     178.0000 |                26 |
| a creepy colon       |     177.7500 |                41 |
| gently caress da Mods         |     176.5000 |                25 |
| Casino               |     175.5000 |                13 |
+----------------------+--------------+-------------------+

lol doritos, and echi

CRIP EATIN BREAD
Jun 24, 2002

Hey stop worrying bout my acting bitch, and worry about your WACK ass music. In the mean time... Eat a hot bowl of Dicks! Ice T



Soiled Meat
unban WEED LORD

echinopsis
Apr 13, 2004

by Fluffdaddy

echinopsis
Apr 13, 2004

by Fluffdaddy
great success

Cold on a Cob
Feb 6, 2006

i've seen so much, i'm going blind
and i'm brain dead virtually

College Slice
here is the longest ban comment

http://forums.somethingawful.com/banlist.php?userid=172634

lol spombies

platonicbackrub
Sep 8, 2015

informaon is worth a bump

Valeyard
Mar 30, 2012


Grimey Drawer
Nice op, I did this last year

Adbot
ADBOT LOVES YOU

Notorious R.I.M.
Jan 27, 2004

up to my ass in alligators

PleasureKevin posted:

make a freaking API

Here, have a really elaborate API: http://54.175.247.114/query

Note to anyone playing around with this: You already have full read access. There's no reason to try SQL injections. Your stupid query will get auto-killed by pt-kill anyway.

If anyone does see any sort of vulns on this let me know because I'm curious to see what all it entails to make a read-only query interface.

  • Locked thread