Added ss_images to site_stats, to replace the slow count(*) query in Parser.php.

[lhc/web/wiklou.git] / includes / SpecialStatistics.php

diff --git a/includes/SpecialStatistics.php b/includes/SpecialStatistics.php
index f5583fe..6ff3338 100644 (file)
--- a/includes/SpecialStatistics.php
+++ b/includes/SpecialStatistics.php
@@ -21,6 +21,7 @@ function wfSpecialStatistics() {
        $views = $row->ss_total_views;
        $edits = $row->ss_total_edits;
        $good = $row->ss_good_articles;
+       $images = $row->ss_images;
 
        # This code is somewhat schema-agnostic, because I'm changing it in a minor release -- TS
        if ( isset( $row->ss_total_pages ) && $row->ss_total_pages == -1 ) {
@@ -50,12 +51,11 @@ function wfSpecialStatistics() {
 
        $admins = $dbr->selectField( 'user_groups', 'COUNT(*)', array( 'ug_group' => 'sysop' ), $fname );
        $numJobs = $dbr->selectField( 'job', 'COUNT(*)', '', $fname );
-       $numFiles = $dbr->selectField( 'image', 'COUNT(*)', '', $fname );
 
        if ($action == 'raw') {
                $wgOut->disable();
                header( 'Pragma: nocache' );
-               echo "total=$total;good=$good;views=$views;edits=$edits;users=$users;admins=$admins;files=$numFiles\n";
+               echo "total=$total;good=$good;views=$views;edits=$edits;users=$users;admins=$admins;images=$images\n";
                return;
        } else {
                $text = '==' . wfMsg( 'sitestats' ) . "==\n" ;
@@ -67,7 +67,7 @@ function wfSpecialStatistics() {
                        $wgLang->formatNum( sprintf( '%.2f', $total ? $edits / $total : 0 ) ),
                        $wgLang->formatNum( sprintf( '%.2f', $edits ? $views / $edits : 0 ) ),
                        $wgLang->formatNum( $numJobs ),
-                       $wgLang->formatNum( $numFiles )
+                       $wgLang->formatNum( $images )
                );
 
                $text .= "\n==" . wfMsg( 'userstats' ) . "==\n";