summaryrefslogtreecommitdiff
path: root/maintenance/recount.sql
diff options
context:
space:
mode:
authorPierre Schmitz <pierre@archlinux.de>2006-10-11 18:12:39 +0000
committerPierre Schmitz <pierre@archlinux.de>2006-10-11 18:12:39 +0000
commit183851b06bd6c52f3cae5375f433da720d410447 (patch)
treea477257decbf3360127f6739c2f9d0ec57a03d39 /maintenance/recount.sql
MediaWiki 1.7.1 wiederhergestellt
Diffstat (limited to 'maintenance/recount.sql')
-rw-r--r--maintenance/recount.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/maintenance/recount.sql b/maintenance/recount.sql
new file mode 100644
index 00000000..d9fec31f
--- /dev/null
+++ b/maintenance/recount.sql
@@ -0,0 +1,8 @@
+--
+-- Recalculate the article count
+--
+
+SELECT @foo:=COUNT(*) FROM /*$wgDBprefix*/cur
+ WHERE cur_namespace=0 AND cur_is_redirect=0 AND cur_text like '%[[%';
+UPDATE /*$wgDBprefix*/site_stats SET ss_good_articles=@foo, ss_total_pages=-1, ss_users=-1, ss_admins=-1;
+