Number of User viewing?

[Dj-marc]

Could anyone please help me with this code to sho for eg.

 General Forum (5 Viewing)

I was trying to make it but got a bit confused

[sweetangel]

4 lavalair?

[Dj-marc]

yes for lavalair.

[sweetangel]

I think view similar code at hipertype site...

[Dj-marc]

you meant hypetype? i dont see that option there

[ori]

add like a section when a user enters into a forum fid add +1 to that forum count and when they goto another page take away the +1 kinda tricky but would work

[Dj-marc]

bro could you give an example.

[i0nutzxp]

$x1=mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_online WHERE place='Viewing Forum'"));
$x2=mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_online WHERE place='......'"));
$x3=
$xn=
$total = $x1[0]=$x2[0]+$x3[0]+...+$xn[0]
$visit = "($total Viewing)";
echo "...";
//make n $x.. for as many actions exists in forum 

[jsyguy23]

$vfc=mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM online WHERE place='Viewing Forum Category'"));
$vft=mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM online WHERE place='Viewing Forum Topic'"));
$vfo=mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM online WHERE place='Viewing Forum'"));
$cnt=mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM online WHERE place='Creating new topic'"));
$pry=mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM online WHERE place='Posting reply'"));
$fnx=mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM online WHERE place='Forum Index'"));
$nif=$vfc[0] + $vft[0] + $vfo[0] + $cnt[0] + $pry[0] + $fnx[0];
echo "($nif) :Browsing Forums<br/>"; 

this might help not sure

[mcKeny]

$vfc=mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM online WHERE place='Viewing Forum Category'"));
$vft=mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM online WHERE place='Viewing Forum Topic'"));
$vfo=mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM online WHERE place='Viewing Forum'"));
$cnt=mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM online WHERE place='Creating new topic'"));
$pry=mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM online WHERE place='Posting reply'"));
$fnx=mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM online WHERE place='Forum Index'"));
$nif=$vfc[0] + $vft[0] + $vfo[0] + $cnt[0] + $pry[0] + $fnx[0];
echo "($nif) :Browsing Forums<br/>"; 

this might help not sure

hmm suppose the dude edit the places names?...........would been easier if he use the add to chat fuunctin..........just a few editing............

[i0nutzxp]

hmm suppose the dude edit the places names?...........would been easier if he use the add to chat fuunctin..........just a few editing............

is better whit name bcoz the result is exact .. no member in forum if ther are not :P and this thing whit name is better and for chat.php and other

[djlee]

i was working on something like this on my beta site before i got bored. basically i had numerical assignments for each page where

1=main
2=online users
3=forums
4=chat
e.c.t.

then in the users table i had an area field where i put in the number, then it was simply a case of doing

$ucnt_main = mysql_result(mysql_query("SELECT count(id) FROM users WHERE area=1"), 0);

it was actually more complex than that using constants and an array to do one query and populate all the counts quickly.

Just an idea. some people like the text based one, but since im a optimisation freak, ints are always my first choice when i cant use bools