>
New Topic
>
Topic Locked
Esato Forum Index
>
General discussions >
Garbage threads
> Who got post number 1,000,000?
Bookmark topic
@debu - so when's the party ?
--
Posted: 2005-01-19 09:15:20
Edit :
Quote
@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.
--
Posted: 2005-01-19 09:39:23
Edit :
Quote
i see! congratulations goes to @laffen for his site and all the hard work thats made it possible, including the moderators....
--
Posted: 2005-01-19 10:25:57
Edit :
Quote
@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.
»
--
Posted: 2005-01-19 11:31:46
Edit :
Quote
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!
--
Posted: 2005-01-19 11:50:41
Edit :
Quote
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.
--
Posted: 2005-01-19 12:17:58
Edit :
Quote
at the current rate of posting that should be in the 4th qtr of 2006
--
Posted: 2005-01-19 12:27:25
Edit :
Quote
Well done debu. Now that you're an Esato legend alongside the likes of JN, ajack, vlammetje, and manish, how does it feel?
--
Posted: 2005-01-19 12:59:00
Edit :
Quote
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 ]
--
Posted: 2005-01-19 13:49:00
Edit :
Quote
@methylated_spirit: Feels really nice.
Mostly I feel elated for being a part of ESATO, which is over a million posts old.
--
Posted: 2005-01-19 14:27:21
Edit :
Quote
New Topic
Topic Locked
