Users Online displayed on main page AND on individual forum indexes?

[KuraFire]

Uhm.. okay, I put that in the forumdisplay.php right at the end _before_ the dooutput line, but what it displays is this:

Resource id #19

And nothing else... Erm?

[Admin]

LOL sorry about that, use this:

$usershere=$DB_site->query_first("SELECT COUNT(*) FROM session WHERE location LIKE 'forumid=$forumid'");

[KuraFire]

Interesting. Now it says:



Array



and again, nothing else.

[KuraFire]

Do I still have to put that stuff above in global.php as well? Cos last time I did that, I got an error (in global.php) whenever I wanted to load a page, so that didn't work

[Admin]

Are you sure you're using $usershere[count] and not just $usershere ???

[Admin]

Leave that thing along for a sec, I can't deal with both issues at the same time.

[KuraFire]

Okay I put

$usershere[count]


in the template, but now nothing shows up. :/

Oh well, I'll hear about it once you have enough to etc.

[Admin]

In forumdisplay.php

PHP Code:

$usershere=$DB_site->query_first("SELECT COUNT(*) AS count FROM session WHERE location LIKE '%forumid=$forumid%'");

eval("dooutput(\"".gettemplate('forumdisplay')."\");"); 


Now use $usershere[count].

WORKS

[Freddie Bingham]

Remember you are going to do a full table scan on the session table every time someone opens up forumdisplay.php, adding an index won't help you. Session resides in memory but it still takes cycles to do that and if you have 200 entries in session than you could have 100+ users doing this at the same time.

[KuraFire]

FF: yup, it works, shows up # of people on that particular forum. Awesome, thanks! :up:


Freddie: so like, for a n00b like me, what does that mean?