Number of Guests browsing current forum

[yasunari]

Anyone have a idea how to make it?
I have try to make it by self, but no luck with it :(

[Scott MacVicar]

Well its not exactly possible as their is a column called inforum on the user table so when a user enters a forum this column is updated in the table.

Guests don't have entires in the user table so they wont show up.

open forumdisplay.php
look for

$datecut = $ourtimenow - $cookietimeout;

below it put

$guestsnum = $DB_site->query_first("SELECT COUNT(*) AS total FROM session WHERE LOCATE('forumid=$foruminfo[forumid]', location)>0 AND LOCATE('forumdisplay.php', location)>0 AND userid=0 AND lastactivity > $datecut");


use $guestnum[total] in the forumdisplay template

[Zzed]

I released this hack a few days ago: https://vborg.vbsupport.ru/showthread.php?s=&threadid=38005 ;)

[Scott MacVicar]

thats not the number of guests, that just the number of users that have user accounts.

I believe that yasunari wanted the number of actual unregistered users browsing the forums.

[Admin]

That code will only work for people who are browsing forumdisplay.php though, it won't catch guests that read actual threads or something. That will require adding an inforum field to the session table (and removing it from the user table) to keep track of everyone.

[Zzed]

/me feels very silly right now...

[Scott MacVicar]

good point chen, i might try changing of the session table to hold inforum and see how much trouble it causes editing it, I don't expect much though.

Just changing the query at bottom of forumdisplay.php to join the user table based on the session table inforum.

[Admin]

I'd say remove the field from the user table altogether and just use the session table. You only need to edit updateuserforum() function to chagne the shut down query, and forumdisplay.php to grab the data from the session table... but you'll probably need two queries since you want to group first by userid then by IP address, I think.

[yasunari]

Yes PPN is right, I need to show the total Guests on each Forums..

I have try PPN's method,it only show the total Guest on the forumdisplay.php,but not the thread err...

*waiting for the new method.. thanks*

[RetroDreams]

Has anyone released this? I'm also interested in this hack.