Author: ppiotr
Description:
site_stats.ss_active_users count is refreshed on each visit to special:statistics page (modulo wgMiserMode switch) - to make it more up to date than the rest of stats (which are refreshed via maintenance/initStats script), presumably. But it is not refreshed by initStats script itself what is strange and what bites sites with premanent/frequent wgMiserMode states.
Patch:
Index: maintenance/initStats.inc
- maintenance/initStats.inc (revision 9043)
+++ maintenance/initStats.inc (working copy)
@@ -20,8 +20,13 @@
wfOut( "{$pages}\nCounting number of users..." ); $users = $dbr->selectField( 'user', 'COUNT(*)', '', __METHOD__ );
- wfOut( "{$users}\nCounting number of admins..." );
+ wfOut( "{$users}\nCounting number of active users..." );
+ $active_users = $dbr->selectField( 'recentchanges', 'COUNT( DISTINCT rc_user_text )',
+ array( 'rc_user != 0', 'rc_bot' => 0, "rc_log_type != 'newusers' OR rc_log_type IS NULL" ),
+ METHOD );
+ wfOut( "{$active_users}\nCounting number of admins..." );
+
$admin = $dbr->selectField( 'user_groups', 'COUNT(*)', array( 'ug_group' => 'sysop' ), __METHOD__ ); wfOut( "{$admin}\nCounting number of images..." );
@@ -41,6 +46,7 @@
'ss_good_articles' => $good, 'ss_total_pages' => $pages, 'ss_users' => $users,
+ 'ss_active_users' => $active_users,
'ss_admins' => $admin, 'ss_images' => $image ); $conds = array( 'ss_row_id' => 1 );
Version: unspecified
Severity: enhancement