[aur-dev] Removing spammer accounts

[Lukas Fleischer]

On Tue, Apr 23, 2013 at 09:12:49PM +0200, Lukas Fleischer wrote:
> On Sun, Mar 24, 2013 at 11:37:53PM +0100, Lukas Fleischer wrote:
> > I analyzed recent additions to the AUR user database in the hope of
> > finding a way to delete all spammer accounts.
> > 
> > [...]
> > 
> > My suggestion is:
> > 
> > 1. Set the password field of these accounts to "", so that they will no
> >    longer be able to login. They can still use the password reset form.
> > 
> > 2. Delete all accounts that still have an empty password field in ~2
> >    weeks.
> 
> Purged. I will make up (and execute) a SQL query to sync the number of
> votes, which are stored separately, later.

Done.

Note that this fixed a couple of other inconsistencies as well (only
+/-1 vote in most cases -- apart from the spam votes).

> 
> > 
> > If there are any objections or alternative suggestions, please let me
> > know. Otherwise, I will unset password fields before I re-enable the
> > registration form (on Tuesday, 2013-03-26).
> > 
> > Regards,
> > Lukas