dépôts
/
lhc
/
web
/
wiklou.git
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
history
|
raw
|
HEAD
formatting
[lhc/web/wiklou.git]
/
maintenance
/
recount.sql
1
--
2
-- Recalculate the article count
3
--
4
5
SELECT
@foo
:=
COUNT
(*)
FROM
/*$wgDBprefix*/
cur
6
WHERE
cur_namespace
=
0
AND
cur_is_redirect
=
0
AND
cur_text
like
'%[[%'
;
7
UPDATE
/*$wgDBprefix*/
site_stats
SET
ss_good_articles
=
@foo
;
8