vb.org Archive - Contest type hack

Page 1 of 2

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Member Archives (https://vborg.vbsupport.ru/forumdisplay.php?f=202)

- - Contest type hack (https://vborg.vbsupport.ru/showthread.php?t=24016)

Iliana

07-30-2001 03:01 PM

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.

Iliana

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

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.

Iliana

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

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.

Iliana

07-30-2001 09:07 PM

Freddie,

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

Iliana

Iliana

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

BradC

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)

Iliana

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>

BradC

07-30-2001 09:53 PM

does the first line look like this ?

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

or..

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

Iliana

07-30-2001 10:02 PM

oops my mistake, I copied it wrong.

It's <?php require("global.php"); ?>

BradC

07-30-2001 10:02 PM

ok.. the parse errors seems to be coming from these files



anything with 

If they are inside the <?php ?> part you should use " // " style comments.. if they are in the html part you can use the  style..

I am still testing this :)

BradC

07-30-2001 10:04 PM

nevermind.. I am blind as a bat... but I am working on fixing it :)

BradC

07-30-2001 10:26 PM

1 Attachment(s)

Ok.. I don't know where your contest.php file is located... or anything, but take a look at this attachment.

if the contest.php and global.php are in the same folder (i.e. both in the vb folder) then delete the top require global and the other 2 code lines and replace that with this :

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

Iliana

07-30-2001 10:42 PM

Brad thanks for helping me out. :)

I do have them both in the same directory.

http://www.theparentclub.com/forums/contest.php

Not working, but I'm still trying.

Iliana

07-30-2001 10:59 PM

I can't get it to work :(

I even copied and pasted the code exactly the way you did it and it gave me an error regarding the chdir.

Please help me :(

BradC

07-30-2001 11:08 PM

<?php
chdir($DOCUMENT_ROOT . "/vb");
require("./global.php");
chdir($DOCUMENT_ROOT . "/vb/anotherfolder");
?>

take that and make it into this..

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

btw... if it still says /vb and /vb/anotherfolder.. those values have to changed.. but you don't need it if they are in the same directory

Iliana

07-30-2001 11:13 PM

This is what I have so far (still not working):

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


<?php require '/home/theparentclub/www/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/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/menu.html");
include("/home/theparentclub/www/meter.html");
?>
</body>
</html>

BradC

07-30-2001 11:15 PM

I edited it... since you looked

take just the global requirement and put the <? and ?> around it

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

Iliana

07-30-2001 11:35 PM

Now I'm beating my head against the desk.

I made the change and now the page comes up blank.

BradC

07-30-2001 11:41 PM

hmmm.. interesting..

BradC

07-30-2001 11:43 PM

put comments infront of the global like

//<?
//require global
//?>

Iliana

07-30-2001 11:47 PM

//
Fatal error: Failed opening required '/home/theparentclub/www/style.html' (include_path='') in /home/www/theparentclub/forums/contest.php on line 8

BradC

07-30-2001 11:50 PM

there we go.. :)

ok.. where you see this line :

<?php require '/home/theparentclub/www/style.html'; ?>

change it to this :

<? include("/home/theparentclub/www/style.html"); ?>
or
<? include('/home/theparentclub/www/style.html'); ?>

process of elimination :)

BradC

07-30-2001 11:52 PM

this is not in the same directory is it.. at all? www and forums are 2 different folders...

<? include($DOCUMENT_ROOT . "/style.html") ?>

might work..

Iliana

07-30-2001 11:58 PM

//
Warning: Failed opening '/home/theparentclub/www/forums/style.html' for inclusion (include_path='') in /home/www/theparentclub/forums/contest.php on line 8

Fatal error: Call to a member function on a non-object in /home/www/theparentclub/forums/contest.php on line 18

this is odd my root directory is as follows for my forums

/home/theparentclub/www/forums

look at the fatal error how it's switching it around.

BradC

07-31-2001 12:00 AM

Ok.. can you tell me where all these files are located lol

are they all in forums?E@!

Iliana

07-31-2001 12:03 AM

Brad, Check you PMs. :)

snyx	07-31-2001 12:04 AM

If ya get it working I would LOVE to use it man! I can trade ya a custom color button set, or some flash work in exchange?

BradC

07-31-2001 12:06 AM

the part about "$DOCUMENT_ROOT" will take care of this folder listing "/home/theparentclub/www"

so if your style.html file is in the "www" folder you can have it like this :

require($DOCUMENT_ROOT . "/style.html");

if it is one more folder in "www/forums/"

then you can have it like this :

require($DOCUMENT_ROOT . "/forums/style.html");

BradC

07-31-2001 12:07 AM

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

Iliana

07-31-2001 12:11 AM

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

BradC

07-31-2001 12:14 AM

it does.. now check yours lol

Iliana

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

BradC

07-31-2001 12:33 AM

yah yah.. :)

working on it.. hehe

Iliana

07-31-2001 12:37 AM

Ok we are now getting somewhere.

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

Iliana

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

Iliana

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>

BradC

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!

All times are GMT. The time now is 08:33 PM.

Page 1 of 2

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01338 seconds Memory Usage 1,829KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: