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 $dbw->delete( 'site_stats', array( 'ss_row_id' => 1 ) );
  20 $dbw->insert( 'site_stats',
  21         array( 'ss_row_id'=> 1,
  22                'ss_total_views'   => 0,
  23                'ss_total_edits'   => $edits,
  24                'ss_good_articles' => $pages ) );
  25
  26 ?>