[Release] Users Online SQL

[tomsaundo]

I know this is no big release but this I'm very proud of because i cant do SQL I was just messing around with the code
This is very helpful if you want it to look different on a certain page not just [[0 user(s) online]]
Now you can have something like [[There is 0 online]]
HERE :

<?php 
$getOnline = dbquery("SELECT * FROM users WHERE online = '1'");
$Online = mysql_num_rows($getOnline)
?> 
<?php echo $Online; ?> [[add your custom thing such as just ONLINE]]

Also the amount of users registered (Not my work)

$getUsers = mysql_query("SELECT * FROM users"); 
$users = mysql_num_rows($getUsers); 
?> 
<?php echo $users; ?> [[add your custom thing such as just REGISTERED]]

Don't Flame give your Opinion !

[joopie]

 echo mysql_result(mysql_query('SELECT COUNT(*) FROM `users` WHERE `online` = "1"'), 0, 0).' people online'; 
  

I thought that does the same =3

But also, You can just download phoenixphp/ubercms, It has also a user online counter in it?

[tomsaundo]

In ubercms you can put %hotelstaus% (i think) and it does it automatically but this is if you want a different one

[joopie]

In ubercms you can put %hotelstaus% (i think) and it does it automatically but this is if you want a different one

That's because it is in a template x.x and already coded into the template system from uber ;/

[tomsaundo]

I know that the point of this release
( This is my FIRST sql attempt )

[JohnHearfield]

does this update when users come on and off, or do you have to reload the page?

[joopie]

does this update when users come on and off, or do you have to reload the page?

What do you thing? php is server side so you must reload or you must use xmlrequest

[JohnHearfield]

so life is refreshing pages to see whos online.

[azaidi]

Nice! I know this isn't a Pro release, but it is great for a beginner.

[leenster]

If ur using the phoenix emu then i think this query is faster, especially if ur user db is large...

 SELECT users_online FROM server_status 
  

so....

 <?php 
$getOnline = dbquery("SELECT users_online FROM server_status");
$Online = mysql_num_rows($getOnline)
?> 
<?php echo $Online; ?>  

[ησвяαιη]

If ur using the phoenix emu then i think this query is faster, especially if ur user db is large...

 SELECT users_online FROM server_status 
  

so....

 <?php 
$getOnline = dbquery("SELECT users_online FROM server_status");
$Online = mysql_num_rows($getOnline)
?> 
<?php echo $Online; ?>  

You do realise that, that gets every user even if they're offline?

[leenster]

You do realise that, that gets every user even if they're offline?

yeah i see that i should not have use the rest of his code....

the query is good though

this is how im using it in modcms

$online = $db->Execute("SELECT users_online,rooms_loaded FROM server_status");
$registerd = $db->Execute("SELECT id FROM users");

echo $online->fields['users_online']." User(s) Online | ";
echo $online->fields['rooms_loaded']." Rooms(s) Loaded | ";
echo $registerd->RecordCount()." Registered Users";

[ησвяαιη]

yeah i see that i should not have use the rest of his code....

the query is good though

this is how im using it in modcms

$online = $db->Execute("SELECT users_online,rooms_loaded FROM server_status");
$registerd = $db->Execute("SELECT id FROM users");

echo $online->fields['users_online']." User(s) Online | ";
echo $online->fields['rooms_loaded']." Rooms(s) Loaded | ";
echo $registerd->RecordCount()." Registered Users";

Oh, I see what you have done.

Basically you have called the $online variable to get the field 'user_online' ^^

[Muscab]

Nice simple release.

I personally use this.

<?php

$host = 'localhost';
$port = port;
$user = 'root';
$pass = 'pw';
$db = 'dbname';

mysql_connect("{$host}:{$port}", $user, $pass);
mysql_select_db($db);

print mysql_result(mysql_query("SELECT COUNT(*) FROM users users WHERE users.online = '1';"), 0);

?>

All work's

[ManiacButcher]

Nice, good for begs
Posted via Mobile Device