[Mediawiki-l] Clean up users?

Anthony Lieuallen arantius at gmail.com
Tue Jul 26 04:58:08 UTC 2011


SELECT 'all', count(0) FROM user
UNION
SELECT '0 edit', count(0) FROM user WHERE user_editcount = 0;

all 	count(0)
all 	22749
0 edit 	22288

All but ~500 out of ~22,000 users on my wiki have never made a single 
edit.  Is there a good way to clean out these junk records?  Is there an 
extension that puts e.g. a captcha on the user register page (not just 
edit)?



More information about the MediaWiki-l mailing list