1. alfred100
  2. General
  3. Wednesday, November 04 2015, 07:56 AM
i want to show just number of users and number of online users like this for example:

users : 200
online users : 10

is it possible? and how?
Accepted Answer
admin Accepted Answer
Admin
Hi,
try this
                $db=JFactory::getDbo();
$query=$db->getQuery(true);
$query->select('COUNT(userid)')->from('#__session')->where('client_id=0')->where('userid>0');
$db->setQuery($query);
$online_users=$db->loadResult();

$query=$db->getQuery(true);
$query->select('COUNT(id)')->from('#__users');
$db->setQuery($query);
$all_users=$db->loadResult();

echo('Online:'.$online_users.'<br />');
echo('All:'.$all_users.'<br />');
  1. more than a month ago
  2. General
  3. # Permalink
admin Accepted Answer
Admin
Yes, it's possible but not with Easy Profile, you need to create a module to do this.
  1. more than a month ago
  2. General
  3. # 1
alfred100 Accepted Answer
custom module type with php code or any other module?
  1. more than a month ago
  2. General
  3. # 2
admin Accepted Answer
Admin
Hi,
you can use also HTML custom module, but you need some plugin like NoNumber Sorcerer to parse PHP code into this module.
Otherwise you need to create your module.
  1. more than a month ago
  2. General
  3. # 3
alfred100 Accepted Answer
ok . i have custom html module that can be added php code in. but what is the php code to call this from easy profile or joomla core ?
possible help with code?
  1. more than a month ago
  2. General
  3. # 4
alfred100 Accepted Answer
thanks for your answering. that works well
  1. more than a month ago
  2. General
  3. # 5
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.
Sorry, the discussion is currently locked. You will not be able to post a reply at the moment.