Do you know if the user_touched has been set to anything other than null for these accounts?
Something like
DELETE FROM user, user_rights WHERE ur_user = user_id AND user_id NOT IN (SELECT UNIQUE(rev_user) FROM revision)
Although I'm totally not responsible if this blows away users that have registered. :)
Travis
On 9/5/06, HeinzJ h-j.luecking@t-online.de wrote:
At the moment we have a spam-problem. People or PCs are adding dayly users with no edits. Mostly they look like TheUserViagra with the Email TheUserViagra@someGMX.net
I would like to delete all users with no edits before updating to mediawiki 1.71 and adding a CAPTCHA into the add new user dialog.
Who have some Ideas?
- SQL clauses
- ....
THX, HeinzJ
Wikitech-l mailing list Wikitech-l@wikimedia.org http://mail.wikipedia.org/mailman/listinfo/wikitech-l