diff options
author | Pierre Schmitz <pierre@archlinux.de> | 2006-10-11 18:12:39 +0000 |
---|---|---|
committer | Pierre Schmitz <pierre@archlinux.de> | 2006-10-11 18:12:39 +0000 |
commit | 183851b06bd6c52f3cae5375f433da720d410447 (patch) | |
tree | a477257decbf3360127f6739c2f9d0ec57a03d39 /maintenance/recount.sql |
MediaWiki 1.7.1 wiederhergestellt
Diffstat (limited to 'maintenance/recount.sql')
-rw-r--r-- | maintenance/recount.sql | 8 |
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; + |