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.

YOU ARE MY HERO!

Thank you!

Hero today, loser tommorow...

this concludes another story book ending...

... the end.

P.S. I FOUND A COW! so there!

[snyx]

[Freddie Bingham]

Only 52 posts to get it?

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

here is my error message
Warning: Offset 0 is invalid for MySQL result index 9 in ./admin/db_mysql.php on line 187

here is what I am using

<?
require('./global.php');
?>
<?php
$date1 = "UNIX_TIMESTAMP(\"2001-08-01\")";

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

$users = $DB_site->query(
"SELECT post.userid, count(post.userid) as count, user.username from " .
"post, user WHERE post.dateline >= $date1 and post.dateline <= $date2 " .
"and post.userid = user.userid and user.username <> 'admin' group ".
"by post.userid order by count DESC");
$admin = $DB_site->query(
"SELECT post.userid, count(post.userid) as count, user.username from " .
"post, user WHERE post.dateline >= $date1 and post.dateline <= $date2 " .
"and post.userid = user.userid and user.username = 'admin' group ".
"by post.userid order by count DESC");
?>
<!-- Put your header in here -->
<!-- This is mine -->
<? include("/home/dlrarmy/public_html/forums/head.html") ?>

<p align="center"><b><font face="verdana,arial,helvetica" size="2">The TOP THREE USERS who
posts the most on-topic posts from August 1st, 2001 to Aug 31st 2001 will receive the following: TO BE ANNOUNCED. For

residences in the U.S. and Canada.</font></b></p>
<div align="center">
<table border="1" cellpadding="4" cellspacing="4">
<tr>
<td bgcolor="#9900CC"><b><font face="verdana,arial,helvetica" color="#FFFFFF" size="3">User</font></b></td>
<td bgcolor="#9900CC"><b><font face="verdana,arial,helvetica" size="3"><font
color="#FFFFFF">Posts
from July 8th to Aug 8th</font></font></b></td>
</tr>
<tr>
<td>
<FONT face="verdana,arial,helvetica" size="2">
<br>
<?php
while ($user = $DB_site->fetch_array($users))
{
$username = $user["username"];
echo"$username<br>";
}
echo"<br>";
while ($user = $DB_site->fetch_array($admin))
{
$username = $user["username"];
echo"$username<br>";
}
?>
<br>
</font>
</td>
<td align="center">
<FONT face="verdana,arial,helvetica" size="2">
<br>
<?php
$DB_site->data_seek(0,$users);
while ($user = $DB_site->fetch_array($users))
{
$count = $user["count"];
echo"$count<br>";
}
echo"<br>";
$DB_site->data_seek(0,$admin);
while ($user = $DB_site->fetch_array($admin))
{
$count = $user["count"];
echo"$count<br>";
}
?>
<br>
</font>
</td>
</tr>
</table>
</div>
<p> </p>

<!-- Put any Footer info in here -->
<!-- This Is Mine -->
<?php
include ("/home/dlrarmy/public_html/forums/foot.html");
?>

I would love to get this to work! Any clues?!

thanks for the glass snyx

Freddie yes, cause I am dumber than a box of rocks.. and you forgot the countless pm's

Sarge.. see this line :

PHP Code:

"and post.userid = user.userid and user.username <> 'admin' group ". 


where it says : 'admin' : you need to change that to your administrators name.. like if it is yours then : 'Sarge'

the same for the next few lines down where it says : 'admin' : agan

see if that helps.

[snyx]

Originally posted by freddie
Only 52 posts to get it?

naaaaa, we got more, if ya like ya can share the glasses fred (mind if I call ya that)

Originally posted by BradC
thanks for the glass snyx

Sarge.. see this line :

PHP Code:

"and post.userid = user.userid and user.username <> 'admin' group ". 


where it says : 'admin' : you need to change that to your administrators name.. like if it is yours then : 'Sarge'

the same for the next few lines down where it says : 'admin' : agan

see if that helps.

I changed it to

Sarge .. because I am a webmaster on the board,
and it didn't make any difference.


Thanks
Sarge

as a test expain this :

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

to something like this :

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

see if that works.

Brad will always be my hero with glasses and his cow.

WHERE IS MY PICKEL?