1 Topic by Newuser12 (edited by Newuser12 2010-07-02 09:31)

  • Registered: 2010-05-29
  • Posts: 58

Topic: Users, Guest count

Hello every one. My web is running on PHP-Fusion v6 and forum using PunBB core. I would like to show users count and guest count. Without including, i want do it with database help. How can i count online users in database?

Who can help me to do that, i don't have experience. ;|

2 Reply by Newuser12 (edited by Newuser12 2010-07-01 15:07)

  • Registered: 2010-05-29
  • Posts: 58

Re: Users, Guest count

Any one?

3 Reply by HADI

  • HADI
  • Junior Member
  • Offline
  • Registered: 2010-07-14
  • Posts: 3

Re: Users, Guest count

Query Str : 

SELECT ident FROM prefix_online WHERE user_id=1

Then Simply count this with mysql_num_rows

This will give you the total number of guest online

For other user you should use user_id!=1. Guest group id is 1

Take a look yourPrefix_online table.