PDA

View Full Version : Contest type hack


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/showthread.php?s=&threadid=1205&highlight=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"); ?>

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

<!-- Change 'admin' to the admin's name -->

anything with <!-- blah -->

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
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>
<!-- 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
$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/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, 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
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>
<!-- put any include Styles in here -->
<!-- This is mine: -->
<? 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");
?>
<!-- Put your header in here -->
<!-- This is mine -->
<? include("/home/theparentclub/www/forums/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/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!

BradC
07-31-2001, 12:47 AM
do this... if you still are not seeing what you want..

change all the includes that you have the lenghty path name like /home/chachacha/pikachu/forums.. hehe sorry had too..

and make it look like this

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

change the style.html to whatever the next one is, and go down the list...

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

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

Iliana
07-31-2001, 12:48 AM
Warning: Offset 0 is invalid for MySQL result index 7 in /home/www/theparentclub/forums/admin/db_mysql.php on line 187

Warning: Offset 0 is invalid for MySQL result index 8 in /home/www/theparentclub/forums/admin/db_mysql.php on line 187

THis is what I'm getting now. it should say /home/theparentclub/www/forums....

BradC
07-31-2001, 12:50 AM
ok.. I am registering at your board so I can see the other part.. besided the login page :D

so it looks like my test page now :)

snyx
07-31-2001, 01:18 AM
no, the cow is mine for good
a man only comes across a few good small cows in his lifetime
I refuse to let mine go

maverick1236
07-31-2001, 01:29 AM
lol

snyx
07-31-2001, 01:31 AM
sorry the small cow is mine for good, and I will show it off by craming her into my avatar!

BradC
07-31-2001, 01:36 AM
that is not funny! I want the cow..

oh well I live in Indiana, I can go next door and take one :)

btw... I have figured out the secret to this.. it has worked all along!!!!

I am just blind...

anyone want to give me some glasses.. :)

Iliana
07-31-2001, 01:43 AM
I just want the pickel and the secret to this hack. ;)

BradC
07-31-2001, 01:53 AM
ohh and you will get the secret... although the pickel... umm I am sorry I hate it for supper.. :)

I am doing some testing and html farting around.. crap

BradC
07-31-2001, 01:57 AM
I will leave the html crap up to you.. but I got it to work.. :)

see here :

http://www.addictedusers.com/board/test.php

yes I know the dates between the 2 are off... I was just messing with the text.. and I had to add another month to actually get some values from my dev board lol

Iliana
07-31-2001, 02:24 AM
YOU ARE MY HERO!

Thank you!:)

BradC
07-31-2001, 03:01 AM
Hero today, loser tommorow...

this concludes another story book ending...

... the end.

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

snyx
07-31-2001, 03:50 AM
http://a236.g.akamai.net/f/236/1428/2w/images.viewimages.com/wm/AA012104.JPG

Freddie Bingham
07-31-2001, 03:52 AM
Only 52 posts to get it?

Sarge
07-31-2001, 04:07 AM
<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?!

BradC
07-31-2001, 04:20 AM
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 :


"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
07-31-2001, 04:24 AM
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)

Sarge
07-31-2001, 04:35 AM
Originally posted by BradC
thanks for the glass snyx :)

Sarge.. see this line :


"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.
:confused:

Thanks
Sarge

BradC
07-31-2001, 10:50 AM
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.

Iliana
07-31-2001, 12:00 PM
Brad will always be my hero with glasses and his cow. :)

WHERE IS MY PICKEL?

BradC
07-31-2001, 12:16 PM
The Pickel is in the mail... it is a large dill pickel... so it is a semi-large small box :)

Sarge
07-31-2001, 03:59 PM
<a href="http://www.dlrarmy.com/forums/contest.php" target="_blank">http://www.dlrarmy.com/forums/contest.php</a>

It works!
But the thing is,
I am using this time stamp

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

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

If I put the date into the future at all, it screws up and starts giving off errors again

What I wanted to do was run a contest from Aug1, 2001 to Sept 1,2001 and have it count posts. While it is counting posts everyday, people can check their progress.

Is this feasable?
Thanks for the help

BradC
07-31-2001, 05:07 PM
Yes it is feasible.. putting in the dates like this :

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

will give you an error because there is 0 posts..

start this tommorow.. and have anyone but you.. post a few times like in a test thread and see if that makes a difference.

That is what I gather from it, if you get that error it is because it can't find a value for posts.. for the array.

Sarge
07-31-2001, 05:41 PM
I changed the start date to 7/30 and it works
Thanks so much
Sarge

BradC
07-31-2001, 07:50 PM
Glad it works.. :)

took me like freddie said 50 some posts.. total me and whoever else in this post.. lol to figure that simple thing out.

I was like I don't know why I am getting that error.. then I was thinking again about ohh ya I have 4 members and almost nill to 0 posts.. so I could see why the mysql was upchucking that now :)

Sarge
07-31-2001, 07:59 PM
hey is there anyway we could beef this up and have the person's name link to their profile, and maybe show how many stars they have?

How about their total post count also?

are any of these hard?
Thanks broheim
Sarge

maverick1236
07-31-2001, 08:30 PM
so is the code safe to try now?-or are u still working out the bugs?
just curious!?
:):)

BradC
08-01-2001, 12:54 AM
Sarge.. it is all possible... I have not really messed with it.. I mean I wanted to.. cause I just can't keep things the way they are/were :)

and Maverick1236 it should work just fine.. before we messed with it.. :)

Freddie did a great job

Sarge
08-01-2001, 02:36 AM
<a href="http://www.dlrarmy.com/forums/showthread.php?s=&threadid=12189" target="_blank">http://www.dlrarmy.com/forums/showth...threadid=12189</a>

I added in the images before each name...and it added a bit to it.

If we could make this kinda look like the memberlist it would kick ass!

I tried to steal php off the memberlist, but since I suck, it didn't work.

Brad.. is this something you might want to tackle in the future?
Thanks in advance
Sarge

BradC
08-01-2001, 04:01 AM
Sarge,

Sure I can tackle this.. stumble, get bruises, go to the hospital no problem... but I will need Freddie's consent :)

Making it look like the memberlist would be kind of cool.. is there anything else you want to add.. to make it look even more interesting :)

Sarge
08-01-2001, 04:22 AM
Well, the only other thing I can think of is an integration of tubedoggs posts per day profile hack
ie: 2.5 posts per day

It doesn't have to look like the memberlist, just contain a few of the functions

online status, search for posts, email, pm, starsAll of those would be great!
Thanks
Sarge

BradC
08-01-2001, 12:26 PM
I will try to start on it soon... but don't know when I will get it done.. been working on some other stuff for a long while now :)

finally got my vB Upload Script done.. so having a few people test the instructions and fix any errors.. then will release that :)

After that... then I will start on this, it shouldn't take more than a couple of hours.. but putting those couple of hours together is a pain :) Well unless I do it at work, hehe

Sarge
08-01-2001, 11:24 PM
whats all this pickle talk?
Would a pickle help hurry things along?
:)

BradC
08-02-2001, 12:19 PM
that would be dry humor at it's finest :)

I am still cleaning up my instructions for installation of vB Photo Upload.. then gotta a few other things to play with.. but I work slowly work on this. :)

It is just to nice outside and I have to much stuff to do out there to be inside coding.. or sitting behind the computer :)

I am at work.. hmm maybe I should just bring the work here... lol but I can't test it, I can code it and test it later when I get home.. hehe

Sarge
08-02-2001, 02:49 PM
You know what would be cool.. and I am not sure if this is possible.
Have a drop down box where you can slect the top poster for this month, today, the past 3 months, top posters of all time..
Sarge

EYO
08-02-2001, 07:19 PM
Just saw your post on this contest thing... about 1 month to late.

I have a program where I can enter in the dates to start and end, and the threads I would like to subtract.

We are having a contest where the first 15 posters to 500 get a $100 betting account. We have other contests on the site and didn't want any posts in those threads to be included so any posts in those threads will not count towards their 500 posts.

Check it out:
http://www.evenyourodds.com/posts/posts.php

Sarge
08-04-2001, 08:33 AM
cool
How is this any different than the one brad did?
It looks the same.
Thanks in advance
Sarge

BradC
08-04-2001, 03:16 PM
It looks pretty much the same... the html code alterations... and if has it set for just certain forums.. or parts then there is a bit more code in it.. :)

fmoise99
10-24-2001, 05:51 PM
How can I modify the query to exclude more than one member in the contest?