Spam: How to delete all users with no edits - Wikitech-l

Travis Derouin

5 Sep 5 Sep

8:42 p.m.

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(a)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(a)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(a)wikimedia.org http://mail.wikipedia.org/mailman/listinfo/wikitech-l

Reply

Travis Derouin

11:57 a.m.

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(a)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(a)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(a)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(a)wikimedia.org > http://mail.wikipedia.org/mailman/listinfo/wikitech-l >

_______________________________________________ Wikitech-l mailing list Wikitech-l(a)wikimedia.org http://mail.wikipedia.org/mailman/listinfo/wikitech-l

Reply

HeinzJ

3:57 p.m.

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

Reply

Rotem Liss

4:09 p.m.

-----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(a)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.

...PGP SIGNATURE...

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

Reply

david chapman

13 Sep 13 Sep

10:14 a.m.

HeinzJ <h-j.luecking(a)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(a)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.

...PGP SIGNATURE...

-----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(a)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.

Reply