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

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

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

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

lol

sorry the small cow is mine for good, and I will show it off by craming her into my avatar!

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

I just want the pickel and the secret to this hack. ;)

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

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

YOU ARE MY HERO!

Thank you!:)

Hero today, loser tommorow...

this concludes another story book ending...

... the end.

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

Only 52 posts to get it?

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

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 :

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.

naaaaa, we got more, if ya like ya can share the glasses fred (mind if I call ya that)

I changed it to

Sarge .. because I am a webmaster on the board,
and it didn't make any difference.
:confused:

Thanks
Sarge

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.

Brad will always be my hero with glasses and his cow. :)

WHERE IS MY PICKEL?

The Pickel is in the mail... it is a large dill pickel... so it is a semi-large small box :)

<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

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.

I changed the start date to 7/30 and it works
Thanks so much
Sarge

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

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

so is the code safe to try now?-or are u still working out the bugs?
just curious!?
:):)

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

<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

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

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

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

whats all this pickle talk?
Would a pickle help hurry things along?
:)

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

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

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

cool
How is this any different than the one brad did?
It looks the same.
Thanks in advance
Sarge

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

How can I modify the query to exclude more than one member in the contest?