The Arcive of Official vBulletin Modifications Site.

About Developer · **Released**: 07-30-2001

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.

#2 07-30-2001, 07:35 PM

If this hack has not been created, I am willing to pay for someone to create this for me.

Thank you.

Iliana

Freddie Bingham · #3 07-30-2001, 07:53 PM

I created a hack for this maybe a year ago and it is probably still around here if you figure out a creative way to search for it.

#4 07-30-2001, 08:26 PM

Hi freddie,

Actually I did find it at:

http://www.vbulletin.com/forum/showt...t=contest+hack

I couldn't find this line in the global.php

This code goes in global.php right before
eval("\$fivelinks = \"".gettemplate("fivelinks")."\";");

So I assumed that it could of been for the older version of the vb's?

Freddie Bingham · #5 07-30-2001, 08:54 PM

Oh you don't need fivelinks or that section at all. It just allows you to show the current results without opening the contest page. You could even put that into the phpinclude template and then it would be available to be used in your header if you so wished.

#6 07-30-2001, 09:07 PM

Freddie,

Thanks for your help. I'm going to give it a try. Wish me luck!

Iliana

#7 07-30-2001, 09:22 PM

ok call me stupid but I must not be doing something right.

I get this error:

Parse error: parse error in /home/www/theparentclub/forums/contest.php on line 14

#8 07-30-2001, 09:39 PM

could you post the code around (above and below 2 or 3 lines) line 14.

most likely while changing the code one character was missing.. maybe.

(i.e. = " or ' or } or { ... who knows)

#9 07-30-2001, 09:47 PM

now be nice to me

Did I have to create a contest.php file and insert the code freddie posted on his other post? If so, then this is what I did.

?php require("global.php"); ?>
<html>
<head>


<title>The Parent Club Post Contest</title>
</head>
<body>
<?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");



<a href="./"><img border="0" src="images/bbtitle.gif" width="420" height="85"></a>
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.
<div align="center">
<table border="1" cellpadding="4" cellspacing="4">
<tr>
<td bgcolor="#9900CC">User</td>
<td bgcolor="#9900CC">Posts
from July 8th to Aug 8th</td>
</tr>
<tr>
<td>

 
<?php
while ($user = $DB_site->fetch_array($users))
{
$username = $user["username"];
echo ("$username ");
}
echo (" ");
while ($user = $DB_site->fetch_array($admin))
{
$username = $user["username"];
echo ("$username ");
}
?>
 

</td>
<td align="center">

 
<?php
$DB_site->data_seek(0,$users);
while ($user = $DB_site->fetch_array($users))
{
$count = $user["count"];
echo ("$count ");
}
echo (" ");
$DB_site->data_seek(0,$admin);
while ($user = $DB_site->fetch_array($admin))
{
$count = $user["count"];
echo ("$count ");
}
?>
 

</td>
</tr>
</table>
</div>
 


</body>
</html>

#10 07-30-2001, 09:53 PM

does the first line look like this ?

?php require("global.php"); ?>

or..

<?php require("global.php"); ?>

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04330 seconds Memory Usage 2,295KB Queries Executed 24 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (10)post_thanks_box (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (10)post_thanks_postbit_info (9)postbit (2)postbit_onlinestatus (10)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start postbit_imicons pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!