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
