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.
 
Lightning Knight
Feb 24, 2012

Pray for Answer

Jeffrey of YOSPOS posted:

See if you can guess what these each were! I just used the date of the time processed so sometimes these are one day grouped into two entries, such as 2007-04-(11,12) and 2016-11-(10,11).

pre:
+-----------------+------+
| DATE(date_proc) | Bans |
+-----------------+------+
| 2020-04-08      |  497 |
| 2016-11-11      |  219 |
| 2018-12-04      |  181 |
| 2006-12-12      |  144 |
| 2010-05-24      |  104 |
| 2016-11-10      |   93 |
| 2012-11-06      |   89 |
| 2007-04-11      |   77 |
| 2010-05-31      |   65 |
| 2007-04-12      |   64 |
+-----------------+------+

18/12/4 must be Basta toxxes

Adbot
ADBOT LOVES YOU

Captain Hygiene
Sep 17, 2007

You mess with the crabbo...



Jeffrey of YOSPOS posted:

pre:
+-----------------+------+
| DATE(date_proc) | Bans |
+-----------------+------+

| 2007-04-11      |   77 |
| 2007-04-12      |   64 |
+-----------------+------+

The Kurt Vonnegut Death Purge will truly live on as a time of infamy for the forums

Pick
Jul 19, 2009
Nap Ghost
One of those absolutely has to be a Ron Paul, but I don't think my history is that good

Fuschia tude
Dec 26, 2004

THUNDERDOME LOSER 2019

weed cat posted:

no idea after that, except 7 (McCain toxxes)

2012 would be Romney.

weed cat
Dec 23, 2010

weed cat is back, and he loves to suck dick



:sueme:

Fuschia tude posted:

2012 would be Romney.

oh, right. man that poo poo was a lifetime ago

Patrick Spens
Jul 21, 2006

"Every quarterback says they've got guts, But how many have actually seen 'em?"
Pillbug

Lightning Knight posted:

18/12/4 must be Basta toxxes

One hundred and eighty one people toxxed for Michael Avenetti?

Lightning Knight
Feb 24, 2012

Pray for Answer

Patrick Spens posted:

One hundred and eighty one people toxxed for Michael Avenetti?

yes lmao, it drew in a lot of people who didn't read the OP, as well as people just buying into the hype I guess

Pick
Jul 19, 2009
Nap Ghost
I've been clued in that one of those was Ban Tuesday, a day where anything that otherwise would have been a probation was instead upgraded to a ban. I love that.

bradzilla
Oct 15, 2004

Jeffrey of YOSPOS posted:

See if you can guess what these each were! I just used the date of the time processed so sometimes these are one day grouped into two entries, such as 2007-04-(11,12) and 2016-11-(10,11).

pre:
+-----------------+------+
| DATE(date_proc) | Bans |
+-----------------+------+
| 2020-04-08      |  497 |
| 2016-11-11      |  219 |
| 2018-12-04      |  181 |
| 2006-12-12      |  144 |
| 2010-05-24      |  104 |
| 2016-11-10      |   93 |
| 2012-11-06      |   89 |
| 2007-04-11      |   77 |
| 2010-05-31      |   65 |
| 2007-04-12      |   64 |
+-----------------+------+

Bernie 2
Hillary
Shmorky
No idea
Pedocaust 1

No idea about the rest

Arrhythmia
Jul 22, 2011
What's the median posts per day? Could we get a timeline of it?

e: posts per USER per day, durr

Arrhythmia fucked around with this message at 23:00 on Apr 23, 2020

exmarx
Feb 18, 2012


The experience over the years
of nothing getting better
only worse.
do the traffic graphs still work? and could you please post any interesting ones, if they do?

sebmojo
Oct 23, 2010


Legit Cyberpunk









Dead gay forums

Current registered users 203,420
New users since 13 June 2018: 3,420
Average new users per day: ~5

Paladinus
Jan 11, 2014

heyHEYYYY!!!

sebmojo posted:

Dead gay forums

Current registered users 203,420
New users since 13 June 2018: 3,420
Average new users per day: ~5

Does it count only actual new users or also reregs after a ban?

AARD VARKMAN
May 17, 1993
Any way to calculate who has had the most time on probation outside of 100k hour probes?

Arrhythmia
Jul 22, 2011

TheAardvark posted:

Any way to calculate who has had the most time on probation outside of 100k hour probes?

BurgerQuest posted:

erm I think I did this sort of right. I took the top 20 users by probe count first, then turned it into hours. assumed '1 month' probes are 30 days so yeah. could be tweaked.


AARD VARKMAN
May 17, 1993

thanks, the ArfJason thread got me curious and I missed or forgot about this

sebmojo
Oct 23, 2010


Legit Cyberpunk









Paladinus posted:

Does it count only actual new users or also reregs after a ban?

I've wondered that, I presume it counts reregs since otherwise that's high.

Dustcat
Jan 26, 2019

i would hazard a guess that the "new regs" number is just new accounts

a majority of those would probably be alts for current users

but reregs seems like they'd be counted differently since they're handled differently by the purchase system

sebmojo
Oct 23, 2010


Legit Cyberpunk









Dustcat posted:

i would hazard a guess that the "new regs" number is just new accounts

a majority of those would probably be alts for current users

but reregs seems like they'd be counted differently since they're handled differently by the purchase system

i've asked jeffrey. We ban a lot less than five people a day anyway, toxx waves aside.

e: yep, new regs only. 5 a day, 150 a month, 1800 a year.

sebmojo fucked around with this message at 12:19 on May 2, 2020

ZentraediElite
Oct 22, 2002

Not sure if you’ve done something like this, or really how to explain it.

What are the biggest, most popular threads, as measured by the number of unique posters?

Similarly, what are the longest threads with the fewest unique posters?

Are there any really long running threads with like 10 people posting in them?

In Training
Jun 28, 2008
Probation
Can't post for 5 hours!

ZentraediElite posted:

Not sure if you’ve done something like this, or really how to explain it.

What are the biggest, most popular threads, as measured by the number of unique posters?

Similarly, what are the longest threads with the fewest unique posters?

Are there any really long running threads with like 10 people posting in them?

Not sure if it stacks up but the PHIZ movie thread is coming up on 12 years old and theres like 8 people who post there.

Jeffrey of YOSPOS
Dec 22, 2005

GET LOSE, YOU CAN'T COMPARE WITH MY POWERS

ZentraediElite posted:

Not sure if you’ve done something like this, or really how to explain it.

What are the biggest, most popular threads, as measured by the number of unique posters?
I did this one here, see the post below it for the thread titles:
https://forums.somethingawful.com/showthread.php?threadid=3899931&userid=0&perpage=40&pagenumber=12#post503838282

quote:

Similarly, what are the longest threads with the fewest unique posters?

Are there any really long running threads with like 10 people posting in them?
So top threads by like, posts per distinct user? Should be doable.

Dip Viscous
Sep 17, 2019


A lot of TFR threads got rebooted earlier this year, and the old versions of some of those threads are probably up there. I don't think TFR has ever had a huge population but some of those threads got started in like 2005.

Jeffrey of YOSPOS
Dec 22, 2005

GET LOSE, YOU CAN'T COMPARE WITH MY POWERS

ZentraediElite posted:

Not sure if you’ve done something like this, or really how to explain it.

What are the biggest, most popular threads, as measured by the number of unique posters?

Similarly, what are the longest threads with the fewest unique posters?

Are there any really long running threads with like 10 people posting in them?

Top 10 threads by posts per distinct user posting there. As expected, mostly chat threads. Boston goons stick together. Some intense roleplaying? The mysterious thread with no title looks like GBS Nite Crew to me. Half expected to find the thread where two people flirted in a forum for awhile.
code:
+-------+-----------------------------------------------------------------+----------+-----------------------------------+
| users | title                                                           | threadid |     	            posts/user   |
+-------+-----------------------------------------------------------------+----------+-----------------------------------+
|   248 | Work Crew: thread page double sex number, nice                  |  3690783 |                         1134.6734 |
|   239 | DHM: GOM but not forgotten                                      |  3570088 |                         1122.0084 |
|   293 | PWM: RIP                                                        |  3650476 |                          951.2901 |
|   294 | Auspol Crew: happy iajwife, happy iajlife                       |  3690833 |                          944.3639 |
|    23 | Blackbird Dreaming (Post Apocalypse / Survival Horror)          |  2545278 |                          921.0000 |
|     8 | [GURPS] A Prayer in Darkness                                    |  3472400 |                          684.3750 |
|   199 | Boston: BOSTON STROG Im an idiot                                |  3836680 |                          656.2864 |
|   493 | Paradise Lost: Clash of the Heavens - Choose Your Own Adventure |  3550307 |                          539.9432 |
|   262 |                                                                 |  3693018 |                          496.8550 |
|    12 | Lost Highway                                                    |  3507914 |                          490.3333 |
+-----------------------------+-----------------------------------------------------------------+----------+-------------+

Burt Sexual
Jan 26, 2006

by Jeffrey of YOSPOS
Switchblade Switcharoo
Permas by week or whatever over the years?

CAT INTERCEPTOR
Nov 9, 2004

Basically a male Margaret Thatcher

Dip Viscous posted:

A lot of TFR threads got rebooted earlier this year, and the old versions of some of those threads are probably up there. I don't think TFR has ever had a huge population but some of those threads got started in like 2005.

AI has got some old old active threads as they have never been rebooted. Marquee specific ones tend have been around for 10 years plus now.

What are the oldest still active threads on the forums, say the top 30? Active to me would mean the last post was less than 30 days ago? That possible to do a query for?

Carthag Tuek
Oct 15, 2005

Tider skal komme,
tider skal henrulle,
slægt skal følge slægters gang



The worthless things on Wikipedia thread in yospos turned 10 years recently

Jeffrey of YOSPOS
Dec 22, 2005

GET LOSE, YOU CAN'T COMPARE WITH MY POWERS

Carthag Tuek posted:

The worthless things on Wikipedia thread in yospos turned 10 years recently
I don't think I've looked at that thread in years and years but I still think about "list of fictional bears" whenever I encounter a fictional bear.

Bum the Sad
Aug 25, 2002
Probation
Can't post for 6 days!
Hell Gem

BurgerQuest posted:

top 40 spenders



Oh poo poo, I'm gonna get to #1, I should be at $160/170 right now I think.


edit: Wait does this only includes automated Leper's Colony ones doesn't it? Ban's used to be hand posted before I guess Mid '04. I demand a recount.

Bum the Sad fucked around with this message at 19:37 on May 8, 2020

Flipperwaldt
Nov 11, 2011

Won't somebody think of the starving hamsters in China?



Carthag Tuek posted:

The worthless things on Wikipedia thread in yospos turned 10 years recently
Buyer/seller feedback for SAmart thread turned 18 last month.

BurgerQuest
Mar 17, 2009

by Jeffrey of YOSPOS

Bum the Sad posted:

Oh poo poo, I'm gonna get to #1, I should be at $160/170 right now I think.


edit: Wait does this only includes automated Leper's Colony ones doesn't it? Ban's used to be hand posted before I guess Mid '04. I demand a recount.

yes it's scraped from whatever was in the lepers colony pages. and no.

buglord
Jul 31, 2010

Cheating at a raffle? I sentence you to 1 year in jail! No! Two years! Three! Four! Five years! Ah! Ah! Ah! Ah!

Buglord
Is it possible to see what percentage of goons are shitposting on mobile?

twoday
May 4, 2005



C-SPAM Times best-selling author
What’s the number of plat vs non-plat users?

There Bias Two
Jan 13, 2009
I'm not a good person

BurgerQuest posted:

top 40 spenders



Seraph84 has to be up there in terms of number of unique accounts.

SniperWoreConverse
Mar 20, 2010



Gun Saliva

Jeffrey of YOSPOS posted:

Top 10 threads by posts per distinct user posting there. As expected, mostly chat threads. Boston goons stick together. Some intense roleplaying? The mysterious thread with no title looks like GBS Nite Crew to me. Half expected to find the thread where two people flirted in a forum for awhile.
code:
+-------+-----------------------------------------------------------------+----------+-----------------------------------+
| users | title                                                           | threadid |     	            posts/user   |
+-------+-----------------------------------------------------------------+----------+-----------------------------------+
|   248 | Work Crew: thread page double sex number, nice                  |  3690783 |                         1134.6734 |
|   239 | DHM: GOM but not forgotten                                      |  3570088 |                         1122.0084 |
|   293 | PWM: RIP                                                        |  3650476 |                          951.2901 |
|   294 | Auspol Crew: happy iajwife, happy iajlife                       |  3690833 |                          944.3639 |
|    23 | Blackbird Dreaming (Post Apocalypse / Survival Horror)          |  2545278 |                          921.0000 |
|     8 | [GURPS] A Prayer in Darkness                                    |  3472400 |                          684.3750 |
|   199 | Boston: BOSTON STROG Im an idiot                                |  3836680 |                          656.2864 |
|   493 | Paradise Lost: Clash of the Heavens - Choose Your Own Adventure |  3550307 |                          539.9432 |
|   262 |                                                                 |  3693018 |                          496.8550 |
|    12 | Lost Highway                                                    |  3507914 |                          490.3333 |
+-----------------------------+-----------------------------------------------------------------+----------+-------------+

:enkidel: is prob one of the oldest too

Julias
Jun 24, 2012

Strum in a harmonizing quartet
I want to cause a revolution

What can I do? My savage
nature is beyond wild

There Bias Two posted:

Seraph84 has to be up there in terms of number of unique accounts.

I don't have an exact number, but they've had nearly 50 accounts so far.

Arrhythmia
Jul 22, 2011

Julias posted:

I don't have an exact number, but they've had nearly 50 accounts so far.

:eyepop:

SniperWoreConverse
Mar 20, 2010



Gun Saliva
I just am really pleased that pl made the top ten of that, cause it has by far the hugest number of uniques and after a point that would suppress its ranking.

It's a really good thread all around, goons have got degrees, got jobs, got married, got knocked up, multiple times, multiple goons. And they keep coming back. Every once in a while someone will show up "i used to post back in the day what the hell did you guys do??" Or just show up outta nowhere saying they read 6666 pages of story and they're ready to vote wrong.

Kind of crazy to think about. The thing is probably gonna run 20 more years at this point lol.

CAT INTERCEPTOR
Nov 9, 2004

Basically a male Margaret Thatcher

Ironic War Criminal is even more impressive

quote:

Posted by Scirocco Griffon on May 6, 2013

Ironic War Criminal has been permabanned 85 times so far. It's highly likely that number will reach 100 before the end of 2013.

Just think about that for a moment.

Adbot
ADBOT LOVES YOU

weed cat
Dec 23, 2010

weed cat is back, and he loves to suck dick



:sueme:
we should tally it and see once and for all - Ironic War Criminal vs. Dare vs. Seraph84 vs. monkeu

  • 1
  • 2
  • 3
  • 4
  • 5