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 !

[MentaL]

[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 )

[Spheral]

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

[Spheral]

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; ?>

[NoBrain]

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";

[NoBrain]

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

[Riizq]

Nice, good for begs
Posted via Mobile Device

[Divide]

I have a better way:

Spoiler:

$sql = mysql_num_rows(mysql_query("SELECT id FROM users WHERE online = '1'"));
$sql1 = mysql_fetch_assoc(mysql_query("SELECT users_online FROM server_status"));
	if(($sql >= 5) && ($sql1['users_online'] >= 5))
	{
		if($sql == $sql1['users_online'])
		{
		define('%online_count%', $sql.' users online');
		}
		else
		{
		define('%online_count%', $sql1['users_online'].' users online');
		}
	}
	else
	{
	define('%online_count%', '5 users online');
	}

Use <?php echo %online_count%; ?> to show the user count.

P.S. This way, If theres less than 5 users online it will say there is 5 users online. It also means you do not have to have the brackets arround the (s).

[NoBrain]

I have a better way:

Spoiler:

$sql = mysql_num_rows(mysql_query("SELECT id FROM users WHERE online = '1'"));
$sql1 = mysql_fetch_assoc(mysql_query("SELECT users_online FROM server_status"));
	if(($sql >= 5) && ($sql1['users_online'] >= 5))
	{
		if($sql == $sql1['users_online'])
		{
		define('%online_count%', $sql.' users online');
		}
		else
		{
		define('%online_count%', $sql1['users_online'].' users online');
		}
	}
	else
	{
	define('%online_count%', '5 users online');
	}

Use <?php echo %online_count%; ?> to show the user count.

P.S. This way, If theres less than 5 users online it will say there is 5 users online. It also means you do not have to have the brackets arround the (s).

That's just fucking stupid. So much code to do such a little job, your a crack head for thinking that it is a better way -.-

[Law]

I have a better way:

Spoiler:

$sql = mysql_num_rows(mysql_query("SELECT id FROM users WHERE online = '1'"));
$sql1 = mysql_fetch_assoc(mysql_query("SELECT users_online FROM server_status"));
	if(($sql >= 5) && ($sql1['users_online'] >= 5))
	{
		if($sql == $sql1['users_online'])
		{
		define('%online_count%', $sql.' users online');
		}
		else
		{
		define('%online_count%', $sql1['users_online'].' users online');
		}
	}
	else
	{
	define('%online_count%', '5 users online');
	}

Use <?php echo %online_count%; ?> to show the user count.

P.S. This way, If theres less than 5 users online it will say there is 5 users online. It also means you do not have to have the brackets arround the (s).

if($sql1['users_online'] == '1')
{
define('%online_count%', $sql1['users_online'] .' user online');
} else {
define('%online_count%', $sql1['users_online'] .' users online');
}

Isn't that better? Because the only place your going to say "user online" is when it says 1... 1 user online, 2 users online, 3 users online. etc.

[Matthew]

I have no idea why you're all insisting on posting the same thing over and over but whatever. This is simple PHP... Getting the online count.. alright we get it. Stop posting the same stuff over and over. It's not exactly hard anyways.

If you actually want to post something worth while. Make a script which selects the online count using int from the server_status table, using apc cache the value for 5 minutes then re-query for the value and cache it again.. That would be the best and more efficient method of getting the online count.

[Danny]

Great, code for a beginner. Great release.

[maritnmine]

$getUsers = mysql_query("SELECT * FROM users");

- Martin

[tomsaundo]

- Martin

Dude I did say I don't know how to do SQL I was messing around so

Great, code for a beginner. Great release.

Thanks at least someone respects that im starting New

[leenster]

i just go online and count them by hand..... its pretty accurate....

[EasyHabbo]

I looked through this entire thread and absolutely none of this is right. Pheonix stores the array/dictionary/list/(what ever it is) of live connections in the database as positive integer. That is the most reliable online count. For the people that are doing the following:

print mysql_num_rows(mysql_query("SELECT users_online FROM server_status"));

You are completely wrong. First of all this will always be "1"?

For the people doing the following:

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

or

print mysql_num_rows(mysql_query("SELECT * FROM users WHERE online = '1'"));

... you are again wrong. This will fetch all the users with an online status of 1. If your vps randomly restarts or the emulator randomly quits it does not restore everyone to online = '0'. Some will still be left as online = '1'.

With all that being said, I imagine a lot of you (for some odd reason) are all wondering what is the correct way to gather the online count? The most proper way to find the online count in Phoenix is by doing the following:

$hostname = 'localhost';
$port = 8889;
$username = 'root';
$password = 'root';

$database = 'pheonix_database';

mysql_connect("{$hostname:$port}", $username, $passord);
mysql_select_db($database);

print mysql_result(mysql_query("SELECT ss.users_online FROM server_status ss LIMIT 0,1;"), 0);

Hopefully you will all learn from this. For the record, I cannot believe we are actually discussing how to get the online count... it truly explains so much. Aim high?

[leenster]

I looked through this entire thread and absolutely none of this is right. Pheonix stores the array/dictionary/list/(what ever it is) of live connections in the database as positive integer. That is the most reliable online count. For the people that are doing the following:

print mysql_num_rows(mysql_query("SELECT users_online FROM server_status"));

You are completely wrong. First of all this will always be "1"?

the query is right for phoenix..

SELECT users_online,rooms_loaded FROM server_status 

mysql_num_rows will give u 1 though