markzz/aurweb.git/web/lib, branch 1.8.1

Release 1.8.1.

2011-03-09T16:44:21Z

Signed-off-by: Lukas Fleischer

Add a sanitize_ids function and use it in all pkg_* functions

2011-03-04T09:29:18Z

And use implode() instead of some looping/first time logic. Signed-off-by: Dan McGee Signed-off-by: Lukas Fleischer

Set a default timezone

2011-03-04T09:29:17Z

With our use of strtotime() in stats.inc, we are "required" to do so or at least the emitted warning tells us it is a good idea. Signed-off-by: Dan McGee Signed-off-by: Lukas Fleischer

Fix PHP notices in account pages

2011-03-04T09:29:17Z

Signed-off-by: Dan McGee Signed-off-by: Lukas Fleischer

Remove dead dependency/required by link code

2011-03-04T09:29:17Z

For some reason we were doing this song and dance "iterate all the known parameters" business. This is totally unnecessary, clutters the links, and was spewing errors all over the place, so kill it. Signed-off-by: Dan McGee Signed-off-by: Lukas Fleischer

Ensure all variables are set in package search form

2011-03-04T09:29:16Z

Signed-off-by: Dan McGee Signed-off-by: Lukas Fleischer

Add action lookup helper function

2011-03-04T09:29:15Z

Signed-off-by: Dan McGee Signed-off-by: Lukas Fleischer

Ensure all package ID values are coerced to integers

2011-03-04T09:29:15Z

We don't need mysql_real_escape_string(), we need valid integer conversions. Signed-off-by: Dan McGee Signed-off-by: Lukas Fleischer

Vastly simplify pkg_delete function

2011-03-04T09:29:14Z

Since only TUs/Devs can delete packages, we can remove almost all checks except the account type check. And now that our DB uses foreign keys, all of the other deletes happen implicitly when a package is deleted so we don't need to take care of it here. Signed-off-by: Dan McGee Signed-off-by: Lukas Fleischer

Ensure users can be deleted when foreign keys are present

2011-03-04T09:29:14Z

This change is necessary to prevent this: mysql> delete from Users where ID = 112; ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`aur`.`Packages`, CONSTRAINT `Packages_ibfk_2` FOREIGN KEY (`SubmitterUID`) REFERENCES `Users` (`ID`) ON DELETE NO ACTION) As a bonus, due to foreign keys, orphaning of packages will be automatic. Signed-off-by: Dan McGee Signed-off-by: Lukas Fleischer