recount.sql

来自「php 开发的内容管理系统」· SQL 代码 · 共 9 行

-- 
-- 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;