National wrapup giveaway Congratz blazers091

We wanted you all to come back and share your national experiences (whether you were there or not). In the process we wanted to give away something we won at the Topps meet and greet.

Details from Topps can be found here

http://www.freedomcardboard.com/?p=910

Anyway during the meet and greet FCB won its own Stephen Strasburg autographed baseball. This ball will be given away here. The winner must have active participation on FCB across each of the next 10 days. If you would like to enter, make a few posts over the next few days until August 22. More details about the exact algorithm will be provided in the post.

viewtopic.php?f=2&t=101359

Please stop by for a chance to own your own cashburg auto provided by Topps, and let us know how the show went, or you’re recent pickups or anything else that is on your mind.

Thanks, the staff

Re: National wrapup giveaway .........

The algorithm ($10 paypal to the first person who can translate this into English and post it here) Jason or Nick, here is your chance to break the FCB code

run
SELECT poster_id, count(DATE_FORMAT(FROM_UNIXTIME(post_time), '%d'))
FROM table where `post_time` > UNIX_TIMESTAMP() - (60*60*24*10)
group by poster_id, DATE_FORMAT(FROM_UNIXTIME(post_time), '%d')


export data and bring it into excel into colum "a"

select column "a"

select data tab

choose advanced

If you get a dialog that states that it cannot figure out column labels, hit ok

select the copy to another location radio button

click into the "copy to" text box

select the b column

select unique records only check box

in column "c" enter =COUNTIF(A:A,B1)

drag down to the last row of colum "b"

copy columns "b" and "c" that have a post count greater than 7 and post them into notepad to remove referances

copy back to page 2 of your excel notebook

figure out the last column and then determine a random number (<php echo rand(5, x); ?>) to choose the random userid.

Re: National wrapup giveaway .........

Re: National wrapup giveaway .........

Cereal

Re: National wrapup giveaway .........

Chumlee!!!! ::facepalm::

Re: National wrapup giveaway .........

Confused as to what to post here :shock:

Re: National wrapup giveaway .........

In like flynn

Re: National wrapup giveaway .........

bubblegumga said:

Confused as to what to post here :shock:

Click to expand...

it dosent matter where you post



Anywhere on the board is fine, just make sure you participate every day.

Re: National wrapup giveaway .........

James Darnell is the greatest baseball player to ever play the game...

Re: National wrapup giveaway .........

you do not have to post in this thread to win

Re: National wrapup giveaway .........

Chumlee

Re: National wrapup giveaway .........

Re: National wrapup giveaway .........

This board is awesome. They were planning on giving it away the day after they got it when I saw them (Friday)

Brian

Re: National wrapup giveaway .........

cgilmo said:

you do not have to post in this thread to win

Click to expand...

Do I have to post in this thread evryday to win?

Re: National wrapup giveaway .........

Erich said:

cgilmo said:

you do not have to post in this thread to win

Click to expand...

Do I have to post in this thread evryday to win?

Click to expand...

I am pretty sure the response you quoted answered your own question!!

Re: National wrapup giveaway .........

Dale Murphy!

Re: National wrapup giveaway .........

Thanks for the shot at the ball!!!!!!

Re: National wrapup giveaway .........

Wow, this is awesome!

Re: National wrapup giveaway .........

While I didn't attend the National, I have started a strictly rookie card collecton as a new pc. No auto, game used stuff just straight rookies.

Re: National wrapup giveaway .........

bouwob said:

The algorithm ($10 paypal to the first person who can translate this into English and post it here) Jason or Nick, here is your chance to break the FCB code

run
SELECT poster_id, count(DATE_FORMAT(FROM_UNIXTIME(post_time), '%d'))
FROM table where `post_time` > UNIX_TIMESTAMP() - (60*60*24*10)
group by poster_id, DATE_FORMAT(FROM_UNIXTIME(post_time), '%d')

Click to expand...

Retrieve a list of id's and number of days posted from the past 10 days. "group by" brings back unique combinations of poster_id and count(...).

bouwob said:

export data and bring it into excel into colum "a"

select column "a"
select data tab

choose advanced

If you get a dialog that states that it cannot figure out column labels, hit ok

select the copy to another location radio button

click into the "copy to" text box

select the b column

select unique records only check box

in column "c" enter =COUNTIF(A:A,B1)

drag down to the last row of colum "b"

copy columns "b" and "c" that have a post count greater than 7 and post them into notepad to remove referances

copy back to page 2 of your excel notebook

Click to expand...

Using Excel, exclude any lines with a post count less than or equal to seven.

bouwob said:

figure out the last column and then determine a random number (<php echo rand(5, x); ?>) to choose the random userid.

Click to expand...

Using the php randomizer, retrieve the random userid that corresponds to the random number generated.