Icon of Sin / Baphomet
Register | User Profile | Member List | F.A.Q | Privacy Policy | New Blog | Search Forums | Forums Home
Doomworld Forums : Powered by vBulletin version 2.2.5 Doomworld Forums > Misc. > Everything Else > One Millionth Post
Pages (2): [1] 2 »  
Author
All times are GMT. The time now is 14:25. Post New Thread    Post A Reply
GreyGhost
a ghost... only grey


Posts: 5703
Registered: 01-08
This milestone apparently passed unnoticed twenty days ago. Would there have been 27,561 post deleted or are there other ways they can fail to show in the official tally?

Anyhow, congratulations I'myourtarget. Unfortunately there doesn't seem to be any sort of prize or celebration organized, but you can at least bask in the adulation of your peers.
Old Post 08-29-11 07:22 #
GreyGhost is offline Profile || Blog || PM || Email || Search || Add Buddy IP || Edit/Delete || Quote
Technician
Still no custom title


Posts: 5772
Registered: 08-04
I think this was brought up in another topic.

EDIT: Yeah, that atheist thread.

Last edited by Technician on 08-29-11 at 07:53
Old Post 08-29-11 07:39 #
Technician is offline Profile || Blog || PM || Email || Search || Add Buddy IP || Edit/Delete || Quote
Snakes
Senior Member


Posts: 1538
Registered: 09-09
In the exact thread, actually. Grazza was the one to point it out. Still... neat little factoid.
Old Post 08-29-11 07:45 #
Snakes is offline Profile || Blog || PM || Email || Search || Add Buddy IP || Edit/Delete || Quote
Bloodshedder
Spellchecker


Posts: 4571
Registered: 03-02
Members: 11,764, Threads: 54,445, Posts: 978,952
Old Post 08-29-11 08:11 #
Bloodshedder is offline Profile || Blog || PM || Email || Homepage || Search || Add Buddy IP || Edit/Delete || Quote
DoomUK
Forum Staple


Posts: 2228
Registered: 04-04
Is it just me or does 1,000,000 posts not sound like a lot, considering Doomworld's age?

With 11,764 members it works out at approximately 85 posts per user. Let's be reasonable and say that 2/3rds of these people never even posted. That leaves around 3,920 contributing members. That still only leaves 255 posts per user. Considering all the most active people have made thousands of posts I would of expected the total post count to be much higher. But obviously I'm mistaken.

Last edited by DoomUK on 08-29-11 at 08:50
Old Post 08-29-11 08:29 #
DoomUK is offline Profile || Blog || PM || Email || Search || Add Buddy IP || Edit/Delete || Quote
dew
Feral Kid


Posts: 1702
Registered: 05-08
it's because people at doomworld think before they post and take time to convey meaningful... eh, never mind.
Old Post 08-29-11 09:08 #
dew is offline Profile || Blog || PM || Email || Homepage || Search || Add Buddy IP || Edit/Delete || Quote
GreyGhost
a ghost... only grey


Posts: 5703
Registered: 01-08
Snakes said:
In the exact thread, actually. Grazza was the one to point it out.
So he did, either I missed that or senile dementia is creeping up on me. I predict there'll be a bit of a bun fight when the official count reaches 1 million.
Old Post 08-29-11 14:15 #
GreyGhost is offline Profile || Blog || PM || Email || Search || Add Buddy IP || Edit/Delete || Quote
Phobus
Senior Member


Posts: 1480
Registered: 10-06
Bloodshedder said:
Members: 11,764, Threads: 54,445, Posts: 978,952


I'd noticed this on the day and couldn't help but wonder. Perhaps that is the case that 21,048 posts have been deleted over time?
Old Post 08-29-11 15:16 #
Phobus is offline Profile || Blog || PM || Email || Homepage || Search || Add Buddy IP || Edit/Delete || Quote
Grazza
Super Moderator


Posts: 11451
Registered: 07-02
I'm not sure what is counted in that total. Posts in Losers and Blogs don't add to users' postcount, so maybe they don't get counted in this total either. I don't know whether deleting posts affects that total either.

Edit: tested, and yes, deleting posts does reduce that total, and posting in Losers doesn't. Deleting a post in Losers does, however, reduce the total, and I imagine the same goes for Blogs.

So it's not surprising that there is quite a large discrepancy.
Old Post 08-29-11 17:14 #
Grazza is offline Profile || Blog || PM || Homepage || Search || Add Buddy IP || Edit/Delete || Quote
Bloodshedder
Spellchecker


Posts: 4571
Registered: 03-02
The actual number of records in the posts table is 979,037
Old Post 08-29-11 17:55 #
Bloodshedder is offline Profile || Blog || PM || Email || Homepage || Search || Add Buddy IP || Edit/Delete || Quote
Doomguy458
Mini-Member


Posts: 52
Registered: 07-10
Congrats everybody! Now reward yourselfs! Go outside! Get a life! Get a girlfriend! Be social! You all deserve it.
Old Post 08-30-11 10:24 #
Doomguy458 is offline Profile || Blog || PM || Homepage || Search || Add Buddy IP || Edit/Delete || Quote
GreyGhost
a ghost... only grey


Posts: 5703
Registered: 01-08
GO OUTSIDE!? Are you trying to get me killed? It's dark, cold, wet and windy out there! I'll most likely break my leg in a wombat hole and be eaten alive by bulldog ants! Besides, I don't have mobile Internet. :P
Old Post 08-30-11 11:57 #
GreyGhost is offline Profile || Blog || PM || Email || Search || Add Buddy IP || Edit/Delete || Quote
Quasar
Moderator


Posts: 4615
Registered: 08-00
Generally when you delete a record in a SQL database, the generator used to create new unique IDs is not affected so it will continue to march forward.

That would explain why the number of posts obtained from a "select count(*) from posts" is smaller than the highest post ID.

However both are a valid way of measuring how many posts *there have been* - one just also reflects the number of posts you can actually still read while the other does not. 'Tis the sort of matter William James once expounded upon in his treatises on pragmatism :P
Old Post 08-30-11 13:53 #
Quasar is offline Profile || Blog || PM || Email || Homepage || Search || Add Buddy IP || Edit/Delete || Quote
I'myourtarget
Junior Member


Posts: 167
Registered: 04-11
Thank you, thank you. I checked the post count too when Grazza mentioned it and I was quite confused, myself. I still feel bad that it was a bit of a crappy post, but eh....

Anyway, maybe the person who gets the "Official" millionth post that gets counted on the post counter could get a mention as well later.
Old Post 08-30-11 23:00 #
I'myourtarget is offline Profile || Blog || PM || Search || Add Buddy IP || Edit/Delete || Quote
rf`
Dr. Nosign


Posts: 7798
Registered: 11-01
7712 of those posts are mine!
Old Post 08-30-11 23:20 #
rf` is offline Profile || Blog || PM || Email || Homepage || Search || Add Buddy IP || Edit/Delete || Quote
chungy
Doomworld is so about bullshit excuses


Posts: 1458
Registered: 06-05
Quasar said:
However both are a valid way of measuring how many posts *there have been* - one just also reflects the number of posts you can actually still read while the other does not. 'Tis the sort of matter William James once expounded upon in his treatises on pragmatism :P

Well, technically speaking, an autoincrement field is a rather terrible way to judge how many records there have been or whether a certain record is newer/older than another. Though it's rather unlikely this forum would ever wrap around the numbers :P
Old Post 08-30-11 23:25 #
chungy is offline Profile || Blog || PM || Email || Search || Add Buddy IP || Edit/Delete || Quote
Technician
Still no custom title


Posts: 5772
Registered: 08-04
Doomguy458 said:
Congrats everybody! Now reward yourselfs! Go outside! Get a life! Get a girlfriend! Be social! You all deserve it.
You do you thin you are, 40oz or somethin'?
Old Post 08-30-11 23:28 #
Technician is offline Profile || Blog || PM || Email || Search || Add Buddy IP || Edit/Delete || Quote
Snakes
Senior Member


Posts: 1538
Registered: 09-09
Technician said:
You do you thin you are, 40oz or somethin'?


Whoa dude... typo city.
Old Post 08-30-11 23:42 #
Snakes is offline Profile || Blog || PM || Email || Search || Add Buddy IP || Edit/Delete || Quote
I'myourtarget
Junior Member


Posts: 167
Registered: 04-11
By the way, I would like to mention that the 999,999th post was made by buttspit and the 1,000,001st post was cbronson. Thanks for setting up for me, buttspit, and sorry, cbronson.
Old Post 08-31-11 00:12 #
I'myourtarget is offline Profile || Blog || PM || Search || Add Buddy IP || Edit/Delete || Quote
Technician
Still no custom title


Posts: 5772
Registered: 08-04
Snakes said:


Whoa dude... typo city.
To be fair, I had a few beers.
Old Post 08-31-11 00:40 #
Technician is offline Profile || Blog || PM || Email || Search || Add Buddy IP || Edit/Delete || Quote
The Ultimate DooMer
(former) /newstuff Chronicler


Posts: 4449
Registered: 03-02
Grazza said:
I'm not sure what is counted in that total. Posts in Losers and Blogs don't add to users' postcount, so maybe they don't get counted in this total either. I don't know whether deleting posts affects that total either.

Edit: tested, and yes, deleting posts does reduce that total, and posting in Losers doesn't. Deleting a post in Losers does, however, reduce the total, and I imagine the same goes for Blogs.

So it's not surprising that there is quite a large discrepancy.


None larger ofc than the 1500 or so posts making up that legendary heh thread that got deleted :(
Old Post 08-31-11 01:27 #
The Ultimate DooMer is offline Profile || Blog || PM || Email || Homepage || Search || Add Buddy IP || Edit/Delete || Quote
Quasar
Moderator


Posts: 4615
Registered: 08-00
The Ultimate DooMer said:

None larger ofc than the 1500 or so posts making up that legendary heh thread that got deleted :(

Are you talking about the thread that is now in the Losers forum? Because if so it was still there as of a few minutes ago.
Old Post 08-31-11 04:03 #
Quasar is offline Profile || Blog || PM || Email || Homepage || Search || Add Buddy IP || Edit/Delete || Quote
Grazza
Super Moderator


Posts: 11451
Registered: 07-02
No, he means this one.
Old Post 08-31-11 04:51 #
Grazza is offline Profile || Blog || PM || Homepage || Search || Add Buddy IP || Edit/Delete || Quote
GreyGhost
a ghost... only grey


Posts: 5703
Registered: 01-08
Quasar said:

Are you talking about the thread that is now in the Losers forum?
The one that was in Blogs. I know it was archived but can't find the link right now.
Old Post 08-31-11 04:58 #
GreyGhost is offline Profile || Blog || PM || Email || Search || Add Buddy IP || Edit/Delete || Quote
Grazza
Super Moderator


Posts: 11451
Registered: 07-02
The link is also in Blogs, which is why it isn't so easy to search for.

Here you go.
Old Post 08-31-11 05:10 #
Grazza is offline Profile || Blog || PM || Homepage || Search || Add Buddy IP || Edit/Delete || Quote
The Ultimate DooMer
(former) /newstuff Chronicler


Posts: 4449
Registered: 03-02
Well, the first 900 posts anyway...pity it wasn't the whole thing but still.
Old Post 08-31-11 12:45 #
The Ultimate DooMer is offline Profile || Blog || PM || Email || Homepage || Search || Add Buddy IP || Edit/Delete || Quote
Phobus
Senior Member


Posts: 1480
Registered: 10-06
My my... trawling through this site's history is a hell of thing. Kind of reminds me of May 2005 when I first joined the ZDoom forums, but probably worse because more people were at it. That ridiculously elaborate prank on Railgunner (or Blackfish) to do with Ralphis hacking Doomworld is hilarious!
Old Post 08-31-11 15:33 #
Phobus is offline Profile || Blog || PM || Email || Homepage || Search || Add Buddy IP || Edit/Delete || Quote
I'myourtarget
Junior Member


Posts: 167
Registered: 04-11
It seems today's Doomworld doesn't even compare to back then. Seems like more interesting things happened on this forum then. I have to say, looking back on all the "legendary threads," (From the second link Grazza posted) so far my favorite would have to be the "I'm leaving" thread. No clue why, but that made me laugh a lot.
Old Post 09-01-11 02:34 #
I'myourtarget is offline Profile || Blog || PM || Search || Add Buddy IP || Edit/Delete || Quote
Olympus
Junior Member


Posts: 181
Registered: 12-10
I feel the same way. I think we should have another "custom titles" thread :)
Old Post 09-02-11 03:04 #
Olympus is offline Profile || Blog || PM || Search || Add Buddy IP || Edit/Delete || Quote
Danarchy
YOU CAN'T CUT BACK ON FUNDING! YOU WILL REGRET THIS!


Posts: 15854
Registered: 01-01
I'myourtarget said:
It seems today's Doomworld doesn't even compare to back then. Seems like more interesting things happened on this forum then. I have to say, looking back on all the "legendary threads," (From the second link Grazza posted) so far my favorite would have to be the "I'm leaving" thread. No clue why, but that made me laugh a lot.

Guess it's not just nostalgia that's telling me that, then.

That "I'm leaving" thread made me laugh my ass off when it was happening and I was one of the people who was serious. There's a pretty long story behind that one, but that was so long ago and so many things have changed that it's just a tiny trickle of a brook under the bridge now. It ended up spawning my second-most-posted-at forum, though, so that's fun.
Old Post 09-02-11 17:44 #
Danarchy is offline Profile || Blog || PM || Search || Add Buddy IP || Edit/Delete || Quote
All times are GMT. The time now is 14:25. Post New Thread    Post A Reply
Pages (2): [1] 2 »  
Doomworld Forums : Powered by vBulletin version 2.2.5 Doomworld Forums > Misc. > Everything Else > One Millionth Post

Show Printable Version | Email this Page | Subscribe to this Thread

 

Forum Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts 		HTML code is OFF
vB code is ON
Smilies are OFF
[IMG] code is ON
 

< Contact Us - Doomworld >

Powered by: vBulletin Version 2.2.5
Copyright ©2000, 2001, Jelsoft Enterprises Limited.

Forums Directory