On 07/27/11 08:00, mediawiki-l-request@lists.wikimedia.org wrote:
On 26/07/11 06:58, Anthony Lieuallen wrote:
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)?
Maybe some users only use the watchlist functionality?
Nope, they're spammers' failed accounts.
SELECT count( DISTINCT ( wl_user ) ) FROM watchlist;
count(distinct(wl_user)) 3580
(And lots of those are for pages that don't exist on this wiki, and never did, including e.g. full URLs to facebook photos, "Www.farmville.com(bonus)", and in at least one case, many hundreds of lines of junk intended as page contents, each submitted individually as a watchlist page title, and two accounts with many thousands of invalid watched pages -- the wiki has only around 300 real pages.)
mediawiki-l@lists.wikimedia.org