[Mediawiki-l] Clean up users?

Helmut Hullen Hullen at t-online.de
Tue Jul 26 06:06:00 UTC 2011


Hallo, Anthony,

Du meintest am 26.07.11:

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

No - at least I have not found such a way. And I'd like to delete some  
hundreds of these spammer entries.

> Is there an extension that puts e.g. a captcha on the user register
> page (not just edit)?

"ConfirmEdit" has helped a long time against those spammers.

But since some weeks there's a robot which first gets an account and  
then changes the main page - very nasty.

Viele Gruesse!
Helmut



More information about the MediaWiki-l mailing list