Total Number of Users Online Now on Every Page

Again, all credit goes to Chen for the original hack.

I've merely modified it, so that two extra queries are saved on forumhome - there's no point running the queries again since index.php has already calculated it.

This hack modifies 1 php file and 2 templates. It's easy.

Using my method, you save yourself 2 queries on forumhome. We use this at vB.org too.

Instructions in the HTML file zipped below.

[Boofo]

When I add the fetch template header in the index.php, it makes the top line for the bbinactive to not show up on forumhome. It will show up on other pages, just not forumhome. If I take that out of the index.php, then it shows up again. Any way to fix that?

[Mr. Brian]

That's weird!

When ever I'm trying to add this on my top of my "phpinclude_start" template, I get a database error.

Add this on top of my phpinclude_start temp

if (strpos($_SERVER['PHP_SELF'], 'index.php') == false) {
$datecut = TIMENOW - $vboptions['cookietimeout'];
$headerguests=$DB_site->query_first("SELECT COUNT(*) AS count FROM session WHERE userid=0 AND lastactivity>$datecut");
$headerusers=$DB_site->query_first("SELECT COUNT(DISTINCT(userid)) AS count FROM session WHERE session.userid>0 AND session.lastactivity>$datecut");
$headerguests=$headerguests[count];
$headerusers=$headerusers[count];
$totalonline=$headerguests+$headerusers;
}

I get this

Database error in vBulletin 3.0.0 Gamma:

Invalid SQL: SELECT COUNT(*) AS count FROM session WHERE userid=0 AND lastactivity>1075329292
mysql error: Table 'soccerwi_soccerforum.session' doesn't exist

mysql error number: 1146

Date: Wednesday 28th of January 2004 03:49:53 PM
Script: http://www.what ever link I click other then my index page?
Referer: http://www.my forum/index.php?
Username: Me
IP Address: xx.xx.xxx

Did I miss out any thing?

Many thanks in advance..

[LordJMann]

Originally Posted by Matthew Lam

That's weird!

When ever I'm trying to add this on my top of my "phpinclude_start" template, I get a database error.

Add this on top of my phpinclude_start temp


I get this


Did I miss out any thing?

Many thanks in advance..

Do you have a table prefix you are using?

[Boofo]

Originally Posted by Boofo

When I add the fetch template header in the index.php, it makes the top line for the bbinactive to not show up on forumhome. It will show up on other pages, just not forumhome. If I take that out of the index.php, then it shows up again. Any way to fix that?

Did anyone ever find a fix for this?

[Mr. Brian]

Originally Posted by LordJMann

Do you have a table prefix you are using?

Yes. No doubt!

BTW, I noticed whenever I'm trying to check/repair my db, I got this line:-

[code]soccerwi_soccerforum.soccerwi_soccerforumsession
error : The handler for the table doesn't support check[/b]

Any ideal why I got this?

thanks

[brandy]

Hi, I installed this hack (really cool btw) but the home page displays funny, although all the other pages display fine. Can you tell me what I did wrong? You can see the home page at http://doggiedoor.com/forums/index.php?

Thanks,
Brandy :classic:

[Tim Wheatley]

3.0 Gold here, I get a blank page on index.php and forum.php (which I use as my main page) with this installed.

[Boofo]

Tim, have you noticed that the board closed line doesn't show at the top of the forumhome when the baord is closed? It shows at the bottom but not at the top for me. Have you run into anything like this?

[Tim Wheatley]

I've uninstalled this now... Sorry.

For me I've always had it top and bottom.

[Boofo]

Where did you have the code in the index.php? Maybe that's where I messed up.