123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249 |
- <?php
- class SiteStats {
- static $row, $loaded = false;
- static $admins, $jobs;
- static $pageCount = array();
- static $groupMemberCounts = array();
- static function recache() {
- self::load( true );
- }
- static function load( $recache = false ) {
- if ( self::$loaded && !$recache ) {
- return;
- }
- self::$row = self::loadAndLazyInit();
-
- if ( !isset( self::$row->ss_total_pages ) && self::$row->ss_total_pages == -1 ) {
-
- $u = new SiteStatsUpdate( 0, 0, 0 );
- $u->doUpdate();
- $dbr = wfGetDB( DB_SLAVE );
- self::$row = $dbr->selectRow( 'site_stats', '*', false, __METHOD__ );
- }
- self::$loaded = true;
- }
- static function loadAndLazyInit() {
- wfDebug( __METHOD__ . ": reading site_stats from slave\n" );
- $row = self::doLoad( wfGetDB( DB_SLAVE ) );
- if( !self::isSane( $row ) ) {
-
- wfDebug( __METHOD__ . ": site_stats damaged or missing on slave\n" );
- $row = self::doLoad( wfGetDB( DB_MASTER ) );
- }
- if( !self::isSane( $row ) ) {
-
-
-
-
- wfDebug( __METHOD__ . ": initializing damaged or missing site_stats\n" );
- global $IP;
- require_once "$IP/maintenance/initStats.inc";
- ob_start();
- wfInitStats();
- ob_end_clean();
- $row = self::doLoad( wfGetDB( DB_MASTER ) );
- }
- if( !self::isSane( $row ) ) {
- wfDebug( __METHOD__ . ": site_stats persistently nonsensical o_O\n" );
- }
- return $row;
- }
- static function doLoad( $db ) {
- return $db->selectRow( 'site_stats', '*', false, __METHOD__ );
- }
- static function views() {
- self::load();
- return self::$row->ss_total_views;
- }
- static function edits() {
- self::load();
- return self::$row->ss_total_edits;
- }
- static function articles() {
- self::load();
- return self::$row->ss_good_articles;
- }
- static function pages() {
- self::load();
- return self::$row->ss_total_pages;
- }
- static function users() {
- self::load();
- return self::$row->ss_users;
- }
-
- static function activeUsers() {
- self::load();
- return self::$row->ss_active_users;
- }
- static function images() {
- self::load();
- return self::$row->ss_images;
- }
-
- static function admins() {
- wfDeprecated(__METHOD__);
- return self::numberingroup('sysop');
- }
-
-
- static function numberingroup($group) {
- if ( !isset( self::$groupMemberCounts[$group] ) ) {
- global $wgMemc;
- $key = wfMemcKey( 'SiteStats', 'groupcounts', $group );
- $hit = $wgMemc->get( $key );
- if ( !$hit ) {
- $dbr = wfGetDB( DB_SLAVE );
- $hit = $dbr->selectField( 'user_groups', 'COUNT(*)',
- array( 'ug_group' => $group ), __METHOD__ );
- $wgMemc->set( $key, $hit, 3600 );
- }
- self::$groupMemberCounts[$group] = $hit;
- }
- return self::$groupMemberCounts[$group];
- }
- static function jobs() {
- if ( !isset( self::$jobs ) ) {
- $dbr = wfGetDB( DB_SLAVE );
- self::$jobs = $dbr->estimateRowCount('job');
-
- if (self::$jobs == 1) {
- self::$jobs = 0;
- }
- }
- return self::$jobs;
- }
- static function pagesInNs( $ns ) {
- wfProfileIn( __METHOD__ );
- if( !isset( self::$pageCount[$ns] ) ) {
- $dbr = wfGetDB( DB_SLAVE );
- $pageCount[$ns] = (int)$dbr->selectField( 'page', 'COUNT(*)', array( 'page_namespace' => $ns ), __METHOD__ );
- }
- wfProfileOut( __METHOD__ );
- return $pageCount[$ns];
- }
-
- private static function isSane( $row ) {
-
- return true;
- if(
- $row === false
- or $row->ss_total_pages < $row->ss_good_articles
- or $row->ss_total_edits < $row->ss_total_pages
- or $row->ss_users < $row->ss_admins
- ) {
- return false;
- }
-
- foreach( array( 'total_views', 'total_edits', 'good_articles',
- 'total_pages', 'users', 'admins', 'images' ) as $member ) {
- if(
- $row->{"ss_$member"} > 2000000000
- or $row->{"ss_$member"} < 0
- ) {
- return false;
- }
- }
- return true;
- }
- }
- class SiteStatsUpdate {
- var $mViews, $mEdits, $mGood, $mPages, $mUsers;
- function __construct( $views, $edits, $good, $pages = 0, $users = 0 ) {
- $this->mViews = $views;
- $this->mEdits = $edits;
- $this->mGood = $good;
- $this->mPages = $pages;
- $this->mUsers = $users;
- }
- function appendUpdate( &$sql, $field, $delta ) {
- if ( $delta ) {
- if ( $sql ) {
- $sql .= ',';
- }
- if ( $delta < 0 ) {
- $sql .= "$field=$field-1";
- } else {
- $sql .= "$field=$field+1";
- }
- }
- }
- function doUpdate() {
- $fname = 'SiteStatsUpdate::doUpdate';
- $dbw = wfGetDB( DB_MASTER );
- $updates = '';
- $this->appendUpdate( $updates, 'ss_total_views', $this->mViews );
- $this->appendUpdate( $updates, 'ss_total_edits', $this->mEdits );
- $this->appendUpdate( $updates, 'ss_good_articles', $this->mGood );
- $this->appendUpdate( $updates, 'ss_total_pages', $this->mPages );
- $this->appendUpdate( $updates, 'ss_users', $this->mUsers );
- if ( $updates ) {
- $site_stats = $dbw->tableName( 'site_stats' );
- $sql = "UPDATE $site_stats SET $updates";
-
- $dbw->begin();
- $dbw->query( $sql, $fname );
- $dbw->commit();
- }
- }
-
- public static function cacheUpdate( $dbw ) {
- $dbr = wfGetDB( DB_SLAVE, array( 'SpecialStatistics', 'vslow') );
-
-
- $activeUsers = $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__ );
- $dbw->update( 'site_stats',
- array( 'ss_active_users' => intval($activeUsers) ),
- array( 'ss_row_id' => 1 ), __METHOD__
- );
- }
- }
|