[aur-dev] Removing spammer accounts
archlinux at cryptocrack.de
Tue Apr 23 15:31:54 EDT 2013
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.
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
More information about the aur-dev