markzz/aurweb.git/support, branch 1.7.0

Support for storing salted passwords

2010-04-17T20:50:24Z

To upgrade existing databases: ALTER TABLE Users ADD Salt CHAR(32) NOT NULL DEFAULT ''; Signed-off-by: Loui Chang

aur-schema.sql: Expand LangPreference field to allow for longer lang codes.

2009-11-29T11:28:15Z

To upgrade existing databases: ALTER TABLE Users MODIFY LangPreference CHAR(5) NOT NULL DEFAULT 'en'; Signed-off-by: Loui Chang

Implement 'Password Reset' facility (FS#3061)

2009-11-13T21:49:55Z

This works by adding a new field to the 'Users' table called 'ResetKey', which is a 32 characters long, random string. When the user requests a password reset, a new 'reset key' is generated and sent to the user's e-mail address in the form of a link in the following format: http://aur.archlinux.org/passreset.php?resetkey= When the above link is followed, the user is presented with a form to verify his/her e-mail address and specify the new desired password. If the e-mail address matches the reset key in the database, the new password is assigned to the account. If there is an error, a relevant message is displayed and the user is prompted to re-enter the required information. Upon successful completion of this procedure, the ResetKey field in the database is blanked and the specific key cannot be reused. One SQL query is needed to add the ResetKey field to the 'Users' table: ALTER TABLE `Users` ADD `ResetKey` CHAR(32) NOT NULL DEFAULT ''; Signed-off-by: Loui Chang

Add multicolumn indexes on votes and notifications tables

2009-06-18T05:47:17Z

To put a long story short, when we do joins on these tables in our pkg_search_page() function, we always join on both the user ID and package ID columns. By creating multicolumn indices, we can always get the exact row we are looking for in the table. The benefits of adding a unique index should also speak for themselves, as we previously did not have this on either of these tables. This is part one of a two-part series to address the fact that this query was often showing up in our slow query logs. Signed-off-by: Dan McGee Signed-off-by: Loui Chang

Move tupkg scripts to tupkg/scripts.

2008-12-11T15:22:15Z

Signed-off-by: Loui Chang

Update usage and paths in tupkg run scripts.

2008-12-11T15:20:59Z

In run-tupkgupdate: Set HOME for correct CVS auth. Properly filter out unneeded messages from CVS output, and prune empty directories on update. Signed-off-by: Loui Chang

run-tupkgupdate: Fix CVS output grepping.

2008-11-28T00:06:07Z

Signed-off-by: Loui Chang

Rework tupkg support scripts. Update paths.

2008-11-27T04:03:53Z

Grep CVS update output for only useful messages. Signed-off-by: Loui Chang

Remove redundant tupkgs.conf.

2008-11-24T07:55:49Z

Signed-off-by: Loui Chang

Add version, username and description to daily new package email.

2008-06-09T20:25:07Z

Add some variables to make it more configurable. Do some general clean up on the script. Signed-off-by: Loui Chang Signed-off-by: Callan Barrett