maintenance/initStats.inc

   1 <?php
   2
   3 function wfInitStats( $options=array() ) {
   4         $dbr = wfGetDB( DB_SLAVE );
   5
   6         echo "Counting total edits...";
   7         $edits = $dbr->selectField( 'revision', 'COUNT(*)', '', __METHOD__ );
   8         $edits += $dbr->selectField( 'archive', 'COUNT(*)', '', __METHOD__ );
   9         echo "{$edits}\nCounting number of articles...";
  10
  11         global $wgContentNamespaces;
  12         $good  = $dbr->selectField( 'page', 'COUNT(*)', array( 'page_namespace' => $wgContentNamespaces, 'page_is_redirect' => 0, 'page_len > 0' ), __METHOD__ );
  13         echo "{$good}\nCounting total pages...";
  14
  15         $pages = $dbr->selectField( 'page', 'COUNT(*)', '', __METHOD__ );
  16         echo "{$pages}\nCounting number of users...";
  17
  18         $users = $dbr->selectField( 'user', 'COUNT(*)', '', __METHOD__ );
  19         echo "{$users}\nCounting number of admins...";
  20
  21         $admin = $dbr->selectField( 'user_groups', 'COUNT(*)', array( 'ug_group' => 'sysop' ), __METHOD__ );
  22         echo "{$admin}\nCounting number of images...";
  23
  24         $image = $dbr->selectField( 'image', 'COUNT(*)', '', __METHOD__ );
  25         echo "{$image}\n";
  26
  27         if( !isset( $options['noviews'] ) ) {
  28                 echo "Counting total page views...";
  29                 $views = $dbr->selectField( 'page', 'SUM(page_counter)', '', __METHOD__ );
  30                 echo "{$views}\n";
  31         }
  32
  33         echo "\nUpdating site statistics...";
  34
  35         $dbw = wfGetDB( DB_MASTER );
  36         $values = array( 'ss_total_edits' => $edits,
  37                                         'ss_good_articles' => $good,
  38                                         'ss_total_pages' => $pages,
  39                                         'ss_users' => $users,
  40                                         'ss_admins' => $admin,
  41                                         'ss_images' => $image );
  42         $conds = array( 'ss_row_id' => 1 );
  43         $views = array( 'ss_total_views' => isset( $views ) ? $views : 0 );
  44
  45         if( isset( $options['update'] ) ) {
  46                 $dbw->update( 'site_stats', $values, $conds, __METHOD__ );
  47         } else {
  48                 $dbw->delete( 'site_stats', $conds, __METHOD__ );
  49                 $dbw->insert( 'site_stats', array_merge( $values, $conds, $views ), __METHOD__ );
  50         }
  51
  52         echo( "done.\n" );
  53 }
  54
  55 ?>