diff options
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; + |