Hmmm, strange. I had an issue where it was loading slow so I emailed my hosters. We are back to superspeed with the last 24 hours in there.

could someone help me out with this index.php part of the code, i get a mysql error.....

JTMON: Are you on a dedicated or shared host? I have been having the speed problems/load time issues for over a week(since I added the 24 hour stats to the forumhome) and at first thought it a host issue, but with it lasting so long, I decided to start experimenting. Removing those queries helped my load time a great deal.

Could you PM me the URL of your board and your host provider information, if its not too much trouble?

Dark: Bane provided instrictions and the ones I provided also work, but don't include as many stats as Bane's. Did you revert back to your original index.php and try reapplying the hack?

Sure SWF, Pm'ing you now.

Dark: Try using the zip that has changed. There was a teeny problem :) This new one works swell. (or should) I'll attach to this post. Let me know.

The only difference between this version and the excellent Idea from SWFans is this one uses a seperate template. And has a few more stats.

Thanx Bane gunna give this one a try

I think you have an error in the following line for the index.php modification:

I get a mySQL error there. Looking at the code I think that the variable $norefer1 isn't defined.

thanks bane, i gave it a try, but i got this error

Database error in vBulletin 2.2.0:

Invalid SQL: SELECT COUNT(*) AS referrals, user.username, user.userid FROM user AS users
LEFT JOIN user ON (users.referrerid = user.userid)
WHERE users.referrerid <> 0 AND
user.userid NOT IN ()
GROUP BY users.referrerid
ORDER BY referrals DESC
LIMIT 1
mysql error: You have an error in your SQL syntax near ')
GROUP BY users.referrerid
ORDER BY referrals DESC
LIMIT 1' at line 4

mysql error number: 1064

Date: Sunday 18th of November 2001 11:34:11 AM
Script: http://www.partylounge.net/tof/tof/index.php?
Referer: http://www.partylounge.net/tof/online.php?

Darkman, that was exactly the error I got and I think it's related to that $norefer1 isn't declared.

hmmmmmmm............i dunno, do you think its just a typo in the code somewhere, or more to it than that?