From 2b3c7fc0d56ef09142970373737027670e637291 Mon Sep 17 00:00:00 2001
From: Antoine Musso <hashar@users.mediawiki.org>
Date: Sat, 6 Jan 2007 20:41:16 +0000
Subject: [PATCH] [[Special:Statistics]] as a command line script.

---
 RELEASE-NOTES             |  1 +
 maintenance/showStats.php | 46 +++++++++++++++++++++++++++++++++++++++
 2 files changed, 47 insertions(+)
 create mode 100644 maintenance/showStats.php

diff --git a/RELEASE-NOTES b/RELEASE-NOTES
index 6f3b757ad2..d017e67a14 100644
--- a/RELEASE-NOTES
+++ b/RELEASE-NOTES
@@ -471,6 +471,7 @@ it from source control: http://www.mediawiki.org/wiki/Download_from_SVN
   to avoid cluttering it with useless wiki formatting
 * (bug 8417) Handle EXIF unknown dates
 * (bug 8372) Return nothing on empty <math> tags.
+* New maintenance script to show the cached statistics : showStats.php.
 
 
 == Languages updated ==
diff --git a/maintenance/showStats.php b/maintenance/showStats.php
new file mode 100644
index 0000000000..27f9be6b01
--- /dev/null
+++ b/maintenance/showStats.php
@@ -0,0 +1,46 @@
+<?php
+
+/**
+ * Maintenance script to show the cached statistics.
+ * Give out the same output as [[Special:Statistics]]
+ *
+ * @author Ashar Voultoiz <hashar@altern.org>
+ * Based on initStats.php by:
+ * @author Brion Vibber
+ * @author Rob Church <robchur@gmail.com>
+ *
+ * @licence GNU General Public License 2.0 or later
+ */
+
+require_once( 'commandLine.inc' );
+
+#
+# Configuration
+#
+$fields = array(
+	'ss_total_views' => 'Total views',
+	'ss_total_edits' => 'Total edits',
+	'ss_good_articles' => 'Number of articles',
+	'ss_total_pages' => 'Total pages',
+	'ss_users' => 'Number of users',
+	'ss_admins' => 'Number of admins',
+	'ss_images' => 'Number of images',
+);
+
+// Get cached stats from slave database
+$dbr =& wfGetDB( DB_SLAVE );
+$fname = 'showStats';
+$stats = $dbr->selectRow( 'site_stats', '*', '' );
+
+// Get maximum size for each column
+$max_length_value = $max_length_desc = 0;
+foreach( $fields as $field => $desc ) {
+	$max_length_value = max( $max_length_value, strlen( $stats->$field ) );
+	$max_length_desc  = max( $max_length_desc , strlen( $desc )) ;
+}
+
+// Show them
+foreach( $fields as $field => $desc ) {
+	printf( "%-{$max_length_desc}s: %{$max_length_value}d\n", $desc, $stats->$field );
+}
+?>
-- 
2.20.1