How Do i Get it to show How many players are online

[cm31]

I am wondering How To get my main menu to Shoe How may players Thats areOn Line Like if there were 5 Players online it will show

Player Online (5)

Thanks

[Blade Maker]

You could make it so when they login it sets a a field in the database table to 1 and echo all the people that are logged in?

And when logged out set it to 0?

That is just a simple way.

[cm31]

Do you have any codes for the data base menu I'm a noob when it comes to coding xD Thanks

[Lilith]

Database query:

$q=$db->query("SELECT * FROM users WHERE laston>unix_timestamp()-15*60 ORDER BY laston DESC");

$online=$db->num_rows($q);

html:

<div class="Whatever style you want to put here from your css">Total Members:<span>$membs</span>Online Now: <span>$online</span>

 

That should work, and no need to add to the database.

[rulerofzu]

Optimize that code there Lilith!!!

select * <--- select everything? why??

select laston :thumbup:

[Lilith]

Um cus I posted at about 4am my time after taking a sleeping pill?

Try this query that isn't nearly so hard on the DB:

$q=$db->query("SELECT ['laston'] FROM users WHERE laston>unix_timestamp()-15*60 ORDER BY laston DESC");

$online=$db->num_rows($q);

[cm31]

lol I'm still lost is there a way to add it to the mainmenu.php file

[Equinox]

<?php

$Online = mysql_query("SELECT laston FROM users WHERE (laston > unix_timestamp()-15*60) ORDER BY laston DESC", $c) or die(mysql_error());

$Count = mysql_num_rows($Online);

echo 'Users online:'.$Count;

?>

[cm31]

Thanks but I found what i was looking for right here

[mccode] Main menu users online count