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.

#32 07-31-2001, 12:07 AM

snyx can you give me to chickens, a hog, and a small cow instead?

#33 07-31-2001, 12:11 AM

Brad did you read my private message to you? It should explain things.

#34 07-31-2001, 12:14 AM

it does.. now check yours lol

#35 07-31-2001, 12:17 AM

Perhaps we should go over Freddie's hack line per line. Maybe we'll figure out what the heck I have done wrong. I sent you another PM

#36 07-31-2001, 12:33 AM

yah yah..

working on it.. hehe

#37 07-31-2001, 12:37 AM

Ok we are now getting somewhere.

Brad check this out:
http://www.theparentclub.com/forums/contest.php

#38 07-31-2001, 12:39 AM

in /home/www/theparentclub/forums/

why is it messing up my root directory?

it's supposed to be /home/theparentclub/www/forums

snyx · #39 07-31-2001, 12:42 AM

Quote:

Originally posted by BradC
snyx can you give me to chickens, a hog, and a small cow instead?

no, im sorry, we discussed this already, NO small cow.

#40 07-31-2001, 12:43 AM

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


<? include("/home/theparentclub/www/forums/style.html") ?>

<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");
?>


<? include("/home/theparentclub/www/forums/menu.html") ?>

<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>
 



<?php
include ("/home/theparentclub/www/forums/menu.html");
include("/home/theparentclub/www/forums/meter.html");
?>
</body>
</html>

#41 07-31-2001, 12:45 AM

I don't see anymore errors

and snyx... I thought you said I could have a small cow too!

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04663 seconds Memory Usage 2,297KB Queries Executed 26 (?)
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)bbcode_quote (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 (4)pagenav_pagelink (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (1)postbit_onlinestatus (11)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!