markzz/aurweb.git/web/lib/pkgfuncs.inc, branch 1.7.0

Confirmation when deleting packages

2010-07-02T01:19:18Z

Signed-off-by: Loui Chang

Add sorting by "Voted" and "Notify" fields

2010-06-04T22:22:22Z

Signed-off-by: Loui Chang

pkg_comments: Only display 10 comments by default.

2010-04-15T20:52:55Z

Add a mechanism to view all comments. Signed-off-by: Loui Chang

add search only by name

2010-04-15T19:26:20Z

Signed-off-by: Loui Chang

remove empty To field (FS#17584)

2010-03-30T00:20:40Z

Signed-off-by: Loui Chang

Turn on package notification for adopted packages

2010-03-16T02:20:08Z

Signed-off-by: Loui Chang

add link to account profile in out-of-date notification

2010-03-10T23:58:47Z

Signed-off-by: Loui Chang

Specify explicit joins for package search

2009-06-18T05:47:17Z

Refactor the query to use explicit LEFT JOINs, which appears to be handled by MySQL in a saner fashion than the previous implicit join syntax. This is part two in a slight fixup for observed slow queries in the production environment. With the new indexes and this fixup, a particular iteration of this query will examine only 13346 rows instead of 272060. Signed-off-by: Dan McGee Signed-off-by: Loui Chang

Don't hit the database twice per comment on package

2009-04-13T14:07:46Z

It's performance improvement day today. For non-superusers, we were hitting the database twice per comment on a package- once to get the UID, and once to check the owner of the comment. The best part is we already knew the owner of the comment, and we only need to get our own UID once. For viewing a package like yaourt, this cuts a single pageview from over 700 queries to around 18, which is still not great but a pretty big improvement. Signed-off-by: Dan McGee Signed-off-by: Loui Chang

Fix search output if no results are found.

2009-03-03T18:22:53Z

Signed-off-by: Loui Chang