| Author |
Who got post number 1,000,000? |
masseur
Joined: Jan 03, 2003
Posts: > 500
From: Sydney, London
PM |
hmmm... I guess you have a better view of the database than me but what I did was I waited for a quiet moment and then watched for one post. The moment that post was made the forum header showed 1,000,055 and the post id of that post was 1088804 which is how I came up with the difference of 88749 and thus derived the result I posted earlier.
I actually did the same a few minutes earlier and used this second identical result as confimration of my answer so I'm not sure where I was wrong in my logic  but perhaps its just difficult to pin down exactly 
|
|
|
Debu
Joined: Jan 15, 2003
Posts: > 500
From: Colchester, UK
PM |
 I didn't realize that i made the millionth post!!! I was just trying to answer the poor guy's question about the recurring calendar. 
Visit My Blog : Debu's Innovations'When nine hundred years old you will be, look as good, you will not' - Yoda |
sonam
Joined: Jan 12, 2005
Posts: 7
From: Bangalore, India
PM |
Congratulations Dev,  |
Debu
Joined: Jan 15, 2003
Posts: > 500
From: Colchester, UK
PM |
Thank you, thank you....
(cups cheeks in hands) Oh...it was all so un expected....sniff!
Congratulations Laffen and the entire Team Esato.
_________________
This message was posted from the hands of a sexy guy who wants to date you tonight.
.....yeeehah......Esato's one millionth poster !!!!!
[ This Message was edited by: Debu on 2005-01-19 09:39 ] |
vineet_d
Joined: Apr 15, 2004
Posts: > 500
From: MumBhai
PM |
dev
|
k4m!k4ze
Joined: Oct 02, 2004
Posts: > 500
From: CBE
PM |
@debu - so when's the party ? 
If at first you don't succeed, destroy all evidence of your attempt !! |
laffen
Joined: Aug 07, 2001
Posts: > 500
From: Oslo, Norway
PM |
@masseur
The difference of 6 post may be caused by the time of counting. Your count was done last evening while I did mine this morning. It might be that another moderator deleted a topic with 6 post last night. |
batesie
Joined: Feb 13, 2004
Posts: > 500
From: London, UK
PM |
i see! congratulations goes to @laffen for his site and all the hard work thats made it possible, including the moderators....
[addsig] |
Krubach
Joined: Dec 05, 2002
Posts: > 500
From: Sunny Portugal! :)
PM |
@laffen & @masseur
I already solved the problem of how to get the milionth post in the other thread:
«About the question of the milionth post being cleaned by being in garbage or so.
It's easy to get the milionth post.
(@laffen)
Use the same query you use to get the total number of posts (the one presented in the forum home) which are already "cleaned".
Then, just order them by ID and get the milionth position.
Easy, huh?
P.S.-Better to do it after the daily cleanup. If the number of posts is kept above the million, then use the method.
»
[addsig] |
masseur
Joined: Jan 03, 2003
Posts: > 500
From: Sydney, London
PM |
That is exactly what laffen did (I've seen the sql queries) but as he mentioned, any posts that were removed from the database, that were prior to the 1 millionth post, between me doing my analysis and him doing his will give the difference in our results
since I did my analysis about 5 to 10 minutes after the 1 millionth post was made that my result is possible my result might be more accurate since no posts are likely to have been removed in that time but its difficult to be 100% sure
the important thing I guess is that we hit a huge milestone
other milestones we can achieve would seem to be more than 1000 online users (current max since the data was reset some time ago is 833 which occurred just a couple of weeks ago) and 100,000 members, but that will probably take another 3 years!
|
Krubach
Joined: Dec 05, 2002
Posts: > 500
From: Sunny Portugal! :)
PM |
Quote:
|
On 2005-01-19 11:50:41, masseur wrote:
the important thing I guess is that we hit a huge milestone
|
|
Totally agree. 
Next stop: 2.000.000 posts.
[addsig] |
masseur
Joined: Jan 03, 2003
Posts: > 500
From: Sydney, London
PM |
at the current rate of posting that should be in the 4th qtr of 2006
|
methylated_spirit
Joined: Jul 07, 2004
Posts: > 500
From: Bonnie Scotland
PM |
Well done debu. Now that you're an Esato legend alongside the likes of JN, ajack, vlammetje, and manish, how does it feel?
Hello, Scroto!
U.G.L.Y. You ain't got no alibi, you ugly! |
Sammy_boy
Joined: Mar 31, 2004
Posts: > 500
From: Staffordshire, United Kingdom
PM, WWW
|
Oh no! Debu's stolen my crown!  
Well done! 
lt was nice to be the millionth post briefly
_________________
"All it takes for evil to flourish is for good men to do nothing" - Edmund Burke
My Ebay Auctions Two Towers soundtrack, etc
[ This Message was edited by: Sammy_boy on 2005-01-19 12:50 ] |
Debu
Joined: Jan 15, 2003
Posts: > 500
From: Colchester, UK
PM |
@methylated_spirit: Feels really nice.
Mostly I feel elated for being a part of ESATO, which is over a million posts old.
Visit My Blog : Debu's Innovations'When nine hundred years old you will be, look as good, you will not' - Yoda |
|
|
Posted: 2005-01-19 08:53
