Spam: How to delete all users with no edits

classic Classic list List threaded Threaded
11 messages Options
Reply | Threaded
Open this post in threaded view
|

Spam: How to delete all users with no edits

Heinz-Josef Lücking-2
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
[hidden email]

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
[hidden email]
http://mail.wikipedia.org/mailman/listinfo/wikitech-l
Reply | Threaded
Open this post in threaded view
|

Re: Spam: How to delete all users with no edits

Travis Derouin-2
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 <[hidden email]> 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
> [hidden email]
>
> 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
> [hidden email]
> http://mail.wikipedia.org/mailman/listinfo/wikitech-l
>
_______________________________________________
Wikitech-l mailing list
[hidden email]
http://mail.wikipedia.org/mailman/listinfo/wikitech-l
Reply | Threaded
Open this post in threaded view
|

Re: Spam: How to delete all users with no edits

Heinz-Josef Lücking-2
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 <[hidden email]> 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
>> [hidden email]
>>
>> 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
>> [hidden email]
>> http://mail.wikipedia.org/mailman/listinfo/wikitech-l
>>

_______________________________________________
Wikitech-l mailing list
[hidden email]
http://mail.wikipedia.org/mailman/listinfo/wikitech-l
Reply | Threaded
Open this post in threaded view
|

Re: Spam: How to delete all users with no edits

Travis Derouin-2
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 <[hidden email]> 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 <[hidden email]> 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
> >> [hidden email]
> >>
> >> 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
> >> [hidden email]
> >> http://mail.wikipedia.org/mailman/listinfo/wikitech-l
> >>
>
> _______________________________________________
> Wikitech-l mailing list
> [hidden email]
> http://mail.wikipedia.org/mailman/listinfo/wikitech-l
>
_______________________________________________
Wikitech-l mailing list
[hidden email]
http://mail.wikipedia.org/mailman/listinfo/wikitech-l
Reply | Threaded
Open this post in threaded view
|

Re: Spam: How to delete all users with no edits

Platonides
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?).



_______________________________________________
Wikitech-l mailing list
[hidden email]
http://mail.wikipedia.org/mailman/listinfo/wikitech-l
Reply | Threaded
Open this post in threaded view
|

Re: Spam: How to delete all users with no edits

Heinz-Josef Lücking-2
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

_______________________________________________
Wikitech-l mailing list
[hidden email]
http://mail.wikipedia.org/mailman/listinfo/wikitech-l
Reply | Threaded
Open this post in threaded view
|

Re: Spam: How to delete all users with no edits

Platonides
"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.



_______________________________________________
Wikitech-l mailing list
[hidden email]
http://mail.wikipedia.org/mailman/listinfo/wikitech-l
Reply | Threaded
Open this post in threaded view
|

Re: Spam: How to delete all users with no edits

Rotem Liss-2
In reply to this post by Heinz-Josef Lücking-2
-----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
> [hidden email]
>
> 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
[hidden email]
http://mail.wikipedia.org/mailman/listinfo/wikitech-l
Reply | Threaded
Open this post in threaded view
|

Re: Spam: How to delete all users with no edits

Heinz-Josef Lücking-2
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
>> [hidden email]
>>
>> 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
[hidden email]
http://mail.wikipedia.org/mailman/listinfo/wikitech-l
Reply | Threaded
Open this post in threaded view
|

Re: Spam: How to delete all users with no edits

david chapman-5


HeinzJ <[hidden email]> 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
>> [hidden email]
>>
>> 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
[hidden email]
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 mailing list
[hidden email]
http://mail.wikipedia.org/mailman/listinfo/wikitech-l
Reply | Threaded
Open this post in threaded view
|

Re: Spam: How to delete all users with no edits

david chapman-5
In reply to this post by Heinz-Josef Lücking-2


HeinzJ <[hidden email]> 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
>> [hidden email]
>>
>> 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
[hidden email]
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 mailing list
[hidden email]
http://mail.wikipedia.org/mailman/listinfo/wikitech-l