maintenance/initStats.php

   1 <?php
   2
   3 require_once( 'commandLine.inc' );
   4
   5 $dbr =& wfGetDB( DB_SLAVE );
   6
   7 $edits = $dbr->selectField( 'revision', 'COUNT(rev_id)', '' );
   8 $pages = $dbr->selectField( 'page', 'COUNT(page_id)',
   9         array(
  10                 'page_namespace' => 0,
  11                 'page_is_redirect' => 0,
  12                 'page_len > 0',
  13         )
  14 ); // HACK APPROXIMATION
  15
  16 echo "$wgDBname: setting edits $edits, pages $pages\n";
  17
  18 $dbw =& wfGetDB( DB_MASTER );
  19 if( isset( $options['update'] ) ) {
  20         echo "(updating...)\n";
  21         $dbw->update( 'site_stats',
  22                 array( 'ss_total_edits'   => $edits,
  23                        'ss_good_articles' => $pages ),
  24                 array( 'ss_row_id' => 1 ) );
  25 } else {
  26         $dbw->delete( 'site_stats', array( 'ss_row_id' => 1 ) );
  27         $dbw->insert( 'site_stats',
  28                 array( 'ss_row_id'=> 1,
  29                        'ss_total_views'   => 0,
  30                        'ss_total_edits'   => $edits,
  31                        'ss_good_articles' => $pages ) );
  32 }
  33
  34 ?>