vb.org Archive

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>
<!-- put any include Styles in here
This is mine:
<?php require '/home/theparentclub/www/style.html';
?>
-->

<title>The Parent Club Post Contest</title>
</head>
<body>
<?php
<!-- Date to Start counting Posts -->
<!-- Year-Month-Day -->
$date1 = "UNIX_TIMESTAMP(\"2001-08-01\")";
<!-- Date to Stop Counting Posts -->
$date2 = "UNIX_TIMESTAMP(\"2001-08-31\")";
<!-- Change 'admin' to the admin's name, he is not in the contest -->

$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");
<!-- Change 'admin' to the admin's name -->
$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/theparentclub/www/menu.html") ?>
-->


<p><a href="./"><img border="0" src="images/bbtitle.gif" width="420" height="85"></a></p>
<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/theparentclub/www/menu.html");
include("/home/theparentclub/www/meter.html");
?>
-->
</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"); ?>


All times are GMT. The time now is 01:44 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01078 seconds
  • Memory Usage 1,739KB
  • 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)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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