Contest type hack

Hello!

I want to run a contest on my site and winners would be determined by the # of posts they make. I was wondering if anyone has created a hack that could do this by being able to determine the start and end date of contest and then list the post standings by users. Then having a way to turn this option off when you do not have a contest running on the boards.

The Pickel is in the mail... it is a large dill pickel... so it is a semi-large small box

<a href="http://www.dlrarmy.com/forums/contest.php" target="_blank">http://www.dlrarmy.com/forums/contest.php</a>

It works!
But the thing is,
I am using this time stamp

$date1 = "UNIX_TIMESTAMP(\"2001-07-01\")";

$date2 = "UNIX_TIMESTAMP(\"2001-08-01\")";

If I put the date into the future at all, it screws up and starts giving off errors again

What I wanted to do was run a contest from Aug1, 2001 to Sept 1,2001 and have it count posts. While it is counting posts everyday, people can check their progress.

Is this feasable?
Thanks for the help

Yes it is feasible.. putting in the dates like this :

$date1 = "UNIX_TIMESTAMP(\"2001-08-01\")";
$date2 = "UNIX_TIMESTAMP(\"2001-09-01\")";

will give you an error because there is 0 posts..

start this tommorow.. and have anyone but you.. post a few times like in a test thread and see if that makes a difference.

That is what I gather from it, if you get that error it is because it can't find a value for posts.. for the array.

I changed the start date to 7/30 and it works
Thanks so much
Sarge

Glad it works..

took me like freddie said 50 some posts.. total me and whoever else in this post.. lol to figure that simple thing out.

I was like I don't know why I am getting that error.. then I was thinking again about ohh ya I have 4 members and almost nill to 0 posts.. so I could see why the mysql was upchucking that now

hey is there anyway we could beef this up and have the person's name link to their profile, and maybe show how many stars they have?

How about their total post count also?

are any of these hard?
Thanks broheim
Sarge

[maverick1236]

so is the code safe to try now?-or are u still working out the bugs?
just curious!?

Sarge.. it is all possible... I have not really messed with it.. I mean I wanted to.. cause I just can't keep things the way they are/were

and Maverick1236 it should work just fine.. before we messed with it..

Freddie did a great job

<a href="http://www.dlrarmy.com/forums/showthread.php?s=&threadid=12189" target="_blank">http://www.dlrarmy.com/forums/showth...threadid=12189</a>

I added in the images before each name...and it added a bit to it.

If we could make this kinda look like the memberlist it would kick ass!

I tried to steal php off the memberlist, but since I suck, it didn't work.

Brad.. is this something you might want to tackle in the future?
Thanks in advance
Sarge

Sarge,

Sure I can tackle this.. stumble, get bruises, go to the hospital no problem... but I will need Freddie's consent

Making it look like the memberlist would be kind of cool.. is there anything else you want to add.. to make it look even more interesting