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 _______________________________________________ MediaWiki-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
