Dev Shed forums db size

Dev Shed Forums Sponsor:

Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now!

May 31st, 2005, 02:17 PM

B-Con

Crypto-Con

Dev Shed God 4th Plane (6500 - 6999 posts)

Join Date: Apr 2004

Location: UC Davis

Posts: 6,647

Time spent in forums: 1 Month 5 Days 17 h 55 m 33 sec
Reputation Power: 852

Dev Shed forums db size

This isn't directly related to being either a Suggestion or Feedback, but more or a curious question, and I guessed that this would be the most appropriate forum for it.

How large is Dev Shed's forum database? I'm guessing that it's going to be some ungoldy size.....

__________________
- "Cryptographically secure linear feedback shift register based stream ciphers" -- a phrase that'll get any party started.
- Why know the ordinary when you can understand the extraordinary?

- Sponsor my caffeine addiction! (36.70 USD recieved so far -- Latest donor: Mark Foxvog)

May 31st, 2005, 02:50 PM

Kokoro

long time no see :)

Join Date: Nov 2004

Posts: 733

Time spent in forums: 2 Weeks 2 Days 4 h 34 m 8 sec
Reputation Power: 23

Yazorz, I bet it's hugezorz.
I want to see the row with my username and stoof.

__________________
AKA Marty Jones (todayeffect - writerlance.com)

May 31st, 2005, 04:06 PM

SimonGreenhill

(retired)

Dev Shed God 11th Plane (10000 - 10499 posts)

Join Date: Dec 2003

Location: The Laboratory

Posts: 10,101

Folding Points: 4925 Folding Title: Novice Folder

Time spent in forums: 3 Months 3 Weeks 5 h 49 m 4 sec
Reputation Power: 1331

DELETE FROM devshed_posts WHERE content='insightful' OR content='useful' AND username = 'B-Con';

0 Rows Matched, 0 Warnings, 0 Errors.

j/k

Yeah, I would be interested to know some of the statistics behind forums.devshed.com

--Simon

__________________

Retired Moderator.

» Addslashes? Magic Quotes? mysql_real_escape_string? bound parameters? sql injection??! HELP!

May 31st, 2005, 04:48 PM

codergeek42

少しな日本語とスペイン語と英語を話します。

Dev Shed God 2nd Plane (6000 - 6499 posts)

Join Date: Jul 2003

Location: Anaheim, CA (USA)

Posts: 6,420

Folding Points: 35702 Folding Title: Starter Folder

Time spent in forums: 1 Month 1 Week 6 Days 5 h 19 m 5 sec
Reputation Power: 1078

Send a message via Google Talk to codergeek42

Quote:

Originally Posted by SimonGreenhill

DELETE FROM devshed_posts WHERE content='insightful' OR content='useful' AND username = 'B-Con';

0 Rows Matched, 0 Warnings, 0 Errors.

j/k

Yeah, I would be interested to know some of the statistics behind forums.devshed.com

--Simon

Shouldn't you be using "WHERE `content` LIKE ..." instead of direct equality testing?

This intrigues me. phpBB has a statistics page that shows things like the total number of posts/threads, the DB size, the number of users, averages, etc.; does vBulletin have something similar to that?

__________________
~~ Peter ~~
( My Blog: It's exactly like normal nerdiness, but completely different. ) :: ( Supporter of the EFF & FSF ) :: ( I'm a GNU/Linux addict and Free Software Advocate. ) :: ( How to Ask Questions the Smart Way ) :: ( The Fedora Project, sponsored by Red Hat ) :: ( GNOME: The Free Software Desktop Project ) :: ( GnuPG Public Key )

May 31st, 2005, 05:01 PM

ChiefWigs1982

Cunning Linguist

Dev Shed God 10th Plane (9500 - 9999 posts)

Join Date: Jul 2003

Location: I used to live at home, now I stay at the house

Posts: 9,894

Folding Points: 50746 Folding Title: Beginner Folder

Time spent in forums: 3 Months 2 Weeks 5 Days 14 h 53 m 10 sec
Reputation Power: 820

Yes, there is a Statistics hack available for vBulletin.

Netbits have it installed...

http://forums.netbits.co.uk/statistics.php

__________________

Support requests via PM will be ignored!
Sites: Route of Queue | Sinthetic - Alternative UK Hiphop
Read These: The General Rules Thread | The General FAQ Thread | NEW USERS - How to post a question

Sign up with Matched.co.uk and earn up to £15 per website every month!

May 31st, 2005, 05:08 PM

SimonGreenhill

(retired)

Join Date: Dec 2003

Location: The Laboratory

Posts: 10,101

Time spent in forums: 3 Months 3 Weeks 5 h 49 m 4 sec
Reputation Power: 1331

What is up with the major referrals to Netbits from porn sites??

Ed & Computer - is there something you're not telling us?

--Simon

May 31st, 2005, 05:22 PM

ChiefWigs1982

Cunning Linguist

Join Date: Jul 2003

Location: I used to live at home, now I stay at the house

Posts: 9,894

Time spent in forums: 3 Months 2 Weeks 5 Days 14 h 53 m 10 sec
Reputation Power: 820

Quote:

Originally Posted by SimonGreenhill

What is up with the major referrals to Netbits from porn sites??

Ed & Computer - is there something you're not telling us?

--Simon

Heh, never noticed that! That's pretty funny!

May 31st, 2005, 05:29 PM

codergeek42

少しな日本語とスペイン語と英語を話します。

Join Date: Jul 2003

Location: Anaheim, CA (USA)

Posts: 6,420

Time spent in forums: 1 Month 1 Week 6 Days 5 h 19 m 5 sec
Reputation Power: 1078

Quote:

Originally Posted by SimonGreenhill

What is up with the major referrals to Netbits from porn sites??

Ed & Computer - is there something you're not telling us?

--Simon

HA HA HA HA HA HA HA HA HA HA HA

That's hilarious!

May 31st, 2005, 06:49 PM

B-Con

Crypto-Con

Join Date: Apr 2004

Location: UC Davis

Posts: 6,647

Time spent in forums: 1 Month 5 Days 17 h 55 m 33 sec
Reputation Power: 852

yeah, that'd be cool to see the forum stats like that

Quote:

Originally Posted by SimonGreenhill

What is up with the major referrals to Netbits from porn sites??

Ed & Computer - is there something you're not telling us?

Ha Ha ha ha ha ha ha ha hah ha ah ah ah ah ha ha ™!!!

#10

May 31st, 2005, 07:00 PM

codergeek42

少しな日本語とスペイン語と英語を話します。

Join Date: Jul 2003

Location: Anaheim, CA (USA)

Posts: 6,420

Time spent in forums: 1 Month 1 Week 6 Days 5 h 19 m 5 sec
Reputation Power: 1078

Quote:

Originally Posted by B-Con

Ha Ha ha ha ha ha ha ha hah ha ah ah ah ah ha ha ™!!!

No fairs! You can't trademark that!

...