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
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
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
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
The captcha functionality is already on code, and enabled on some wikis. Remember when deleting users, to preserve those with deleted edits or in the log table (is it possible to have someone there and not in (deleted) edits?).
Platonides schrieb:
The captcha functionality is already on code, and enabled on some wikis. Remember when deleting users, to preserve those with deleted edits or in the log table (is it possible to have someone there and not in (deleted) edits?).
Interesting! I'm just updating to MediaWiki 1.71. I work quite long on it now. All i could find are the extensions on SVN / mediawiki.org / wikimedia.org.
Where "already on code" is it ?
THX, Heinz
"HeinzJ"wrote:
Interesting! I'm just updating to MediaWiki 1.71. I work quite long on it now. All i could find are the extensions on SVN / mediawiki.org / wikimedia.org.
Where "already on code" is it ?
THX, Heinz
It's probably on extensions. But it should be ready-to-install.
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
HeinzJ 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
Run the maintenance script maintenance/removeUnusedAccounts.php.
THX Rotem Liss, that was what i where looking for.
heinzJ
Rotem Liss schrieb:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
HeinzJ 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
Run the maintenance script maintenance/removeUnusedAccounts.php.
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2.2 (GNU/Linux) Comment: Using GnuPG with Mandriva - http://enigmail.mozdev.org
iD8DBQFE/vKuqahN/0dU8mcRAsIBAKCaZGcXb96mXok2u4GskoZpfknKjgCdEsX9 U8mJMXTpWMJR2tWBamIuzZ4= =cXQs -----END PGP SIGNATURE-----
HeinzJ h-j.luecking@t-online.de wrote: THX Rotem Liss, that was what i where looking for.
heinzJ
Rotem Liss schrieb:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
HeinzJ 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
Run the maintenance script maintenance/removeUnusedAccounts.php.
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2.2 (GNU/Linux) Comment: Using GnuPG with Mandriva - http://enigmail.mozdev.org
iD8DBQFE/vKuqahN/0dU8mcRAsIBAKCaZGcXb96mXok2u4GskoZpfknKjgCdEsX9 U8mJMXTpWMJR2tWBamIuzZ4= =cXQs -----END PGP SIGNATURE-----
_______________________________________________ Wikitech-l mailing list Wikitech-l@wikimedia.org http://mail.wikipedia.org/mailman/listinfo/wikitech-l
--------------------------------- Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates starting at 1¢/min.
HeinzJ h-j.luecking@t-online.de wrote: THX Rotem Liss, that was what i where looking for.
heinzJ
Rotem Liss schrieb:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
HeinzJ 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
Run the maintenance script maintenance/removeUnusedAccounts.php.
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2.2 (GNU/Linux) Comment: Using GnuPG with Mandriva - http://enigmail.mozdev.org
iD8DBQFE/vKuqahN/0dU8mcRAsIBAKCaZGcXb96mXok2u4GskoZpfknKjgCdEsX9 U8mJMXTpWMJR2tWBamIuzZ4= =cXQs -----END PGP SIGNATURE-----
_______________________________________________ Wikitech-l mailing list Wikitech-l@wikimedia.org http://mail.wikipedia.org/mailman/listinfo/wikitech-l
--------------------------------- Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates starting at 1¢/min.
wikitech-l@lists.wikimedia.org