if you want that users whitch are not activated shouldn't be shown in
memberlist and shouldn't be count.
OPEN includes/functions.php
FIND
case 'newestuser':
$sql = "SELECT user_id, username
FROM " . USERS_TABLE . "
WHERE user_id <> " . ANONYMOUS . "
ORDER BY user_id DESC
LIMIT 1";
break;
$sql = "SELECT user_id, username
FROM " . USERS_TABLE . "
WHERE user_id <> " . ANONYMOUS . "
ORDER BY user_id DESC
LIMIT 1";
break;
REPLACE WITH
case 'newestuser':
$sql = "SELECT user_id, username
FROM " . USERS_TABLE . "
WHERE user_id <> " . ANONYMOUS . " AND user_active = 1
ORDER BY user_id DESC
LIMIT 1";
break;
$sql = "SELECT user_id, username
FROM " . USERS_TABLE . "
WHERE user_id <> " . ANONYMOUS . " AND user_active = 1
ORDER BY user_id DESC
LIMIT 1";
break;
OPEN memberlist.php
FIND
$sql = "SELECT count(*) AS total
FROM " . USERS_TABLE . " u
WHERE user_id <> " . ANONYMOUS . " AND user_active = 1
$where_sql
$alpha_where";
FROM " . USERS_TABLE . " u
WHERE user_id <> " . ANONYMOUS . " AND user_active = 1
$where_sql
$alpha_where";
REPLACE WITH
$sql = "SELECT count(*) AS total
FROM " . USERS_TABLE . " u
WHERE user_id <> " . ANONYMOUS . " AND user_active = 1
$where_sql
$alpha_where";
FROM " . USERS_TABLE . " u
WHERE user_id <> " . ANONYMOUS . " AND user_active = 1
$where_sql
$alpha_where";
FIND
$sql = "SELECT u.*, t.*
FROM " . USERS_TABLE . " u, " . THEMES_TABLE . " t
WHERE u.user_id <> " . ANONYMOUS . "
AND t.themes_id = u.user_style
$where_sql
$alpha_where
ORDER BY $order_by";
FROM " . USERS_TABLE . " u, " . THEMES_TABLE . " t
WHERE u.user_id <> " . ANONYMOUS . "
AND t.themes_id = u.user_style
$where_sql
$alpha_where
ORDER BY $order_by";
REPLACE WITH
$sql = "SELECT u.*, t.*
FROM " . USERS_TABLE . " u, " . THEMES_TABLE . " t
WHERE u.user_id <> " . ANONYMOUS . " AND user_active = 1
AND t.themes_id = u.user_style
$where_sql
$alpha_where
ORDER BY $order_by";
FROM " . USERS_TABLE . " u, " . THEMES_TABLE . " t
WHERE u.user_id <> " . ANONYMOUS . " AND user_active = 1
AND t.themes_id = u.user_style
$where_sql
$alpha_where
ORDER BY $order_by";
@MG: Maybe it could be standard in IcyPhoenix.