I just wanted to take a moment to share end-of-year results with each of you...

Here is 2008 data for the overall site:

1,264,011 visits (+14.71% from 2007)
18,988,469 pageviews (+17.26% from 2007)

Here is 2008 data for the Collector Zone:

756,435 posts (+13.58% from 2007)
12,562 completed transactions (+45.78% from 2007)

As you can see, the overall site and the Collector Zone continued to experience significant increases in activity compared to the previous year!

Throughout 2008, TCC proved that it's possible to provide a site that is informative and fun as well as a site that makes it easy for collectors to buy, sell and trade - all within an environment that seeks to bring out the best in each of us!

Of course, this is all true because of many, many collectors. So...

Thanks to each and every one of you that have chosen to join the Collector Zone! Each of you help to make TCC an amazing site!

Thanks also to the men and women who volunteer their time to help as members of the TCC Team!

-Bob

P.S. Feel free to dig into various statistics about the site by clicking here. As you'll see, the bar was set fairly high in 2008. So, with almost 1/3 of 2009 behind us already, let's get busy!

wow i joined at one of the big points in the life of TCC jan. 06!

Wow, TCC is rockin'

I have to sing to dedicate this moment on TCC

I know your eyes in the morning sun
I feel you touch me in the pouring rain
And the moment that you wander far from me
I wanna feel you in my arms again

And you come to me on a summer breeze
Keep me warm in your love and then softly leave
And its me you need to show

Chorus:
How deep is your love

To INFINITY and BEYOND

Wow, way to go TCC!!!!!!!!!!!!

Lets do it, and keep the party going!

Sweet Googglly Moogglly! TCC ROCKS

wow, that's super-dee-duper-dee. here's to 2009

Bob, is there anyway to locate the 2,000,000th Post??

We clicked over sometime this month..

I could probably determine that at some point. I know about when it happened - just not sure of the exact post that was made at that moment.

-Bob

After a bit of research I've determined that the post was most likely made on April 14, 2009 sometime before 1pm CST.

After more looking around I've come to the conclusion that I was off by a day.

Actually, I believe it was made shortly before this topic was posted.

-Bob

The first post in that topic is post #2013935. It was made some time before that. It's around the 14th, 15th. I'm trying to get closer now. I found a post that was made just 80 posts prior to 2,000,000, and it was on Apr 15th.

Here is a link to post #2,000,003. It's the closest I've found so far. The date shows as Apr 15 2009, 10:27 PM CST.

http://www.tradingcardcentral.com/forums/i...dpost&p=2000003

You're not accounting for deleted posts in your approach. Otherwise, we could just do this...



Resulting in this...

Here it is!

From my experience with determining the 1,000,000th post, I know that it's somewhat difficult. However, it can be done.

-Bob

Ahh, ok. I just figured you were looking for #2000000. I also didn't know you could use the "post" tags.

A whole 15 minutes of research...wasted!

Yes, that's a nice little BB code! There's one for topics as well.



-Bob

That's good to know. Never know when something like that might come in handy.

A quick question though, couldn't you determine the 2,000,000th post very easily with a quick SQL call? I'm not sure how this software works, but I'm thinking this is how you might could do it.

"select pid from table limit 1,1999999"

The approach uses a query similar to that one. However, I have to be careful about when it's run. If I recall, that simple query really bogged down the database.

-Bob

<--- Apologizes about the technical "geek" chat to all of those that aren't interested.

-Bob

That loud *whoosh* sound you heard was all that going right over my head

Whats the difference between a visit and a page view?

Visits are counted when you actually come to a site and counts your total time spent on the site during that particular "session". Page views are the number of times you refresh/view a page on the site. Each person probably views several pages per visit.

Actually, according to this data, the average person views about 15 pages per visit.

using that postxxx coding I found post 107 lol... so far thats the oldest one I can locate.. what happened to post #1?

Did you already try every post between 0 and 107? If not, feel free to give me a range and I'll help you out. If so, you must be just as bored as I am!

Many/most of the first posts were made in a private forum related to the OpenChecklist.com project. I'll see if I can quickly determine the first "public" post.

-Bob

I just started at 1 and I'm currently at 78 checking each 1 by 1. Haven't found any working ones yet, but it may also be because I don't have permission to view those posts.

EDIT: I just finished checking all the posts from 1 to 106, as I'm now sure broscards probably did too, and found nothing.

Based on a query of the database, post #107 is indeed the first post in a public forum.

-Bob

Does this mean Bob gets a prize now for having the first post on the forum?

Also, Bob, any luck determining which post was the 2,000,000th post on the forum? Now might be a pretty good time to check as it doesn't appear the boards are as busy as they are at other times of the day.

Shouldn't you be programming a state-of-the-art drafting system for group box breaks?

-Bob

I can't do anything like that while I'm at work. I don't have access to my server or any ftp/ssh software loaded here.

PS: I can't guarantee how "state of the art" it's going to be anyways, but it'll work...I hope?

Give me a few minutes... Just need to verify the query (think the LIMIT statement is opposite of what you posted) as well as whether LIMIT is based on 0 or 1.

-Bob

Actually, I think you could be right about me having the numbers reversed. I wasn't really thinking when I typed that out. It was meant more as a "something like this" query vs one you should actually use. However, I am pretty sure that the limit uses a 0 as the first post.

Understood. The LIMIT statement should be LIMIT 1999999,1 which returns the 2,000,000th row. That corresponds to...

Post #2013924 (Collector Zone team members click here) - Tarasadie17

That post was actually made in the sub-forum for the Collector Zone team though. So, let's look at the posts right before and right after that post...

Click here for right before - Hallsgator

Click here for right after - shuecarsmake2

-Bob

Very cool... except for the posts leading up to the actual 2 millionth post announcement

Actually I tried to find post 1, then post 25, then post 50, then post 100, then post 200... and I found that, then I went to Mr. Presidents profile, looked up his posts, went to the last page, noticed his "first" post was post #107, and just assumed that was the oldest post - but mjda gets the award for persistence!

Thanks for doing that research Bob. It's always neat to see things like this, at least for me.