Ha.
This works.
DELETE FROM user WHERE user_id NOT IN (SELECT DISTINCT(rev_user) FROM revision); DELETE FROM user_rights WHERE ur_user NOT IN (SELECT user_id FROM user);
Of course if this first one didn't work, you might be gambling on the 2nd..... muhahah - just kidding.
Travis
On 9/6/06, HeinzJ h-j.luecking@t-online.de wrote:
Maybe all users would be blown away if the SQL would work ;-)
HeinzJ
Travis Derouin schrieb:
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
Wikitech-l mailing list Wikitech-l@wikimedia.org http://mail.wikipedia.org/mailman/listinfo/wikitech-l