New Stats Section

Space Goat · 03-10-2009, 01:19 AM

I've finally added the stats section. I actually coded most of this over a year ago, and filed it away for some reason that I can't even remember anymore.

I devised a scheme that caches every query in a separate database table. These caches expire after 24 hours, meaning that a particular query can only be run no more than once a day. This prevents people from inadvertently hammering the server to death with resource intensive queries. However, it also causes thread and post counts to not really be 'live', despite being dynamically generated. I doubt you'll notice though.

Enjoy.

http://www.3dmm.com/stats.php

Tuna Hematoma · 03-10-2009, 01:59 AM

I rate movies like a mofo.

edit -the 2nd most downloaded movie in 2008 was Penis Penis Vagina 2? I hate you all. (I should totally be nominated for best voice actor for THAT movie)

Klown · 03-10-2009, 02:54 AM

Not Found

The requested URL /stats.php was not found on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

Space Goat · 03-10-2009, 03:18 AM

Yeah, sorry, I just remembered why I never finished it. There's a few open security risks I need to patch up.

Phil Williamson · 03-10-2009, 03:57 AM

well shit
I'll check back in three more years I guess

Aaron Haynes · 03-10-2009, 05:12 AM

Aww you even took down the one I was able to view

Slime · 08-06-2009, 03:00 PM

Hahah what the hell? This section was actually up for a day? At least its making progress!

Space Goat · 06-03-2010, 12:50 AM

It's back.

Aaron Haynes · 06-03-2010, 01:04 AM

Some of the user stuff is gone :[

Gorosaurus · 06-03-2010, 02:50 AM

Very nice work!

Space Goat · 06-03-2010, 10:52 AM

Two of the reports are missing because they were causing spikes on the server load.

Trooper · 06-03-2010, 05:18 PM

I love how the Top Review is rated 1%.

Congrats, Goat. It's all looking nice.

Slime · 06-04-2010, 03:54 AM

Quote:

Originally Posted by Trooper

I love how the Top Review is rated 1%.

And the 4th Top Review gave an Overall Score of -99999999999999999999999999999999999999999999999999 99999999999999999999999999999999999999999999999999 99999999999999999999999999999999999999999999999999 9999999999999999999999999/5

Cheezemaster · 06-05-2010, 02:40 AM

Who's 44 years old? He's not displayed in the Oldest Users section.

James McCloud · 06-05-2010, 10:23 AM

its probably sutt steve

Space Goat · 06-05-2010, 05:52 PM

It could be a bot account. I don't think suttsteve is active anymore.

Breed · 06-06-2010, 06:54 PM

nice work Goat!

Adelitas · 12-23-2013, 10:13 AM

*goatseee.jpg removed by moderator

03-10-2009, 01:19 AM	#1
Space Goat Administrator Join Date: Sep 2001 Posts: 6,042	New Stats Section I've finally added the stats section. I actually coded most of this over a year ago, and filed it away for some reason that I can't even remember anymore. I devised a scheme that caches every query in a separate database table. These caches expire after 24 hours, meaning that a particular query can only be run no more than once a day. This prevents people from inadvertently hammering the server to death with resource intensive queries. However, it also causes thread and post counts to not really be 'live', despite being dynamically generated. I doubt you'll notice though. Enjoy. http://www.3dmm.com/stats.php

03-10-2009, 02:54 AM	#3
Klown Senior Member Join Date: Oct 2001 Posts: 11,640	Not Found The requested URL /stats.php was not found on this server. Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
Klown Senior Member Join Date: Oct 2001 Posts: 11,640

08-06-2009, 03:00 PM	#7
Slime Senior Member Join Date: Oct 2001 Posts: 24,891	Hahah what the hell? This section was actually up for a day? At least its making progress!
Slime Senior Member Join Date: Oct 2001 Posts: 24,891

06-03-2010, 05:18 PM	#12
Trooper Senior Member Join Date: Mar 2007 Posts: 7,441	I love how the Top Review is rated 1%. Congrats, Goat. It's all looking nice.
Trooper Senior Member Join Date: Mar 2007 Posts: 7,441

06-06-2010, 06:54 PM	#17
Breed Senior Member Join Date: Sep 2004 Posts: 7,768	nice work Goat!
Breed Senior Member Join Date: Sep 2004 Posts: 7,768

03-10-2009, 01:59 AM	#2
Tuna Hematoma Senior Member Join Date: Oct 2001 Posts: 10,055	I rate movies like a mofo. edit -the 2nd most downloaded movie in 2008 was Penis Penis Vagina 2? I hate you all. (I should totally be nominated for best voice actor for THAT movie)

03-10-2009, 03:18 AM	#4
Space Goat Administrator Join Date: Sep 2001 Posts: 6,042	Yeah, sorry, I just remembered why I never finished it. There's a few open security risks I need to patch up.

03-10-2009, 03:57 AM	#5
Phil Williamson Super Moderator Join Date: Oct 2002 Posts: 16,900	well shit I'll check back in three more years I guess

03-10-2009, 05:12 AM	#6
Aaron Haynes Senior Member Join Date: Dec 2001 Posts: 15,125	Aww you even took down the one I was able to view

06-03-2010, 12:50 AM	#8
Space Goat Administrator Join Date: Sep 2001 Posts: 6,042	It's back.

06-03-2010, 01:04 AM	#9
Aaron Haynes Senior Member Join Date: Dec 2001 Posts: 15,125	Some of the user stuff is gone :[

06-03-2010, 02:50 AM	#10
Gorosaurus Super Moderator Join Date: Jan 2002 Posts: 16,146	Very nice work!

06-03-2010, 10:52 AM	#11
Space Goat Administrator Join Date: Sep 2001 Posts: 6,042	Two of the reports are missing because they were causing spikes on the server load.

06-05-2010, 02:40 AM	#14
Cheezemaster Senior Member Join Date: Jan 2002 Posts: 2,753	Who's 44 years old? He's not displayed in the Oldest Users section.

06-05-2010, 10:23 AM	#15
James McCloud Senior Member Join Date: May 2005 Posts: 4,214	its probably sutt steve

06-05-2010, 05:52 PM	#16
Space Goat Administrator Join Date: Sep 2001 Posts: 6,042	It could be a bot account. I don't think suttsteve is active anymore.

12-23-2013, 10:13 AM	#18
Adelitas Senior Member Join Date: Jan 2012 Posts: 1,500	*goatseee.jpg removed by moderator
Adelitas Senior Member Join Date: Jan 2012 Posts: 1,500