Retrieve total number of users
By pepe moreno on Friday, 21 June 2019
Posted in Technical Issues
Likes 0
Views 613
Votes 0
Hi guys,

i need to add the total number of users in the EasySocial Users module. I'm editing template override from it in /templates/mytemplate/html/mod_easysocial_users/timeline.php, tried several codes but i always get error, and the help doc doesn't provide the info on retrieving the total number of users. I just need to echo the number of users. Can you help me out with this? thanks.
Hey there,

I am really sorry for the delay of this reply as it is a weekend for us here.

I am not sure why you customize for timeline.php file because this Easysocial user module doesn't have this file.

By the way, you can use this following code to retrieve your total of users count : 



$usersModel = ES::model('Users');

$totalUser = $usersModel->getTotalUsers();
Arlex Wong
·
Saturday, 22 June 2019 09:49
·
0 Likes
·
0 Votes
·
0 Comments
·
This works fine, but it shows all users, including the disabled ones, how can i exclude them?
btw i'm using timeline.php since i need override for this specific module, it's specified in the module settings so it's not affecting it on other places.
pepe moreno
·
Tuesday, 25 June 2019 01:52
·
0 Likes
·
0 Votes
·
0 Comments
·
It seems like we do not have any existing function return this result.

Try this following to retrieve total of users without blocked user : 



$db = ES::db();

$sql = $db->sql();



$query = 'SELECT count(1) FROM ' . $db->nameQuote('#__social_users') . ' AS a';

$query .= ' INNER JOIN ' . $db->nameQuote('#__users') . ' AS b';

$query .= ' ON b.' . $db->nameQuote('id') . ' = a.' . $db->nameQuote('user_id');

$query .= ' WHERE b.' . $db->nameQuote('block') . ' != ' . $db->Quote(1);



$db->setQuery($query);



$results = $db->loadResult();
Arlex Wong
·
Tuesday, 25 June 2019 10:42
·
0 Likes
·
0 Votes
·
0 Comments
·
Works like a charm, thank you!
pepe moreno
·
Tuesday, 25 June 2019 19:21
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi pepe,

You are most welcome. Glad to hear that your issue has been resolved now.

Just for your information, I have locked and marked this thread as resolved to avoid confusions in the future. Please start a new thread if you have any other issue in the future so it will be easier for us to manage your inquiries.

Thanks for understanding.
Manisha Ranawat
·
Tuesday, 25 June 2019 19:51
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post