Code: Select all
$total_users = $config['num_users'];
Code: Select all
//$total_users = $config['num_users'];
$sql = 'SELECT COUNT(user_id) AS total_users
FROM ' . USERS_TABLE;
$result = $db->sql_query($sql);
$total_users = (int) $db->sql_fetchfield('total_users');
Thank you very much.daroPL wrote:Number of total users (active users) is storage in database (phpbb3_config table, num_users record). You can get number of total users in new SQL query or change value of num_users also in inactive users registration.
Better is first concept, so try this:
Open:
index.php
Find:Replace, with:Code: Select all
$total_users = $config['num_users'];
Code: Select all
//$total_users = $config['num_users']; $sql = 'SELECT COUNT(user_id) AS total_users FROM ' . USERS_TABLE; $result = $db->sql_query($sql); $total_users = (int) $db->sql_fetchfield('total_users');
Code: Select all
//$total_users = $config['num_users'];
$sql = 'SELECT COUNT(user_id) AS total_users
FROM ' . USERS_TABLE . '
WHERE group_id = <group id here>';
$result = $db->sql_query($sql);
$total_users = (int) $db->sql_fetchfield('total_users');
$db->sql_freeresult($result);
Worked like a champ! Thanks!daroPL wrote:You must use the WHERE clause. Use the following code and put the group ID within.Code: Select all
//$total_users = $config['num_users']; $sql = 'SELECT COUNT(user_id) AS total_users FROM ' . USERS_TABLE . ' WHERE group_id = <group id here>'; $result = $db->sql_query($sql); $total_users = (int) $db->sql_fetchfield('total_users'); $db->sql_freeresult($result);