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

Add option to search for exact name matches only (fixes FS#23556).

2011-04-06T17:21:19Z

Signed-off-by: Lukas Fleischer

Initialize "$name" in pkgname_from_id().

2011-04-05T09:38:43Z

Ensures "$name" is always initialized, even if the package doesn't exist. Fixes PHP warnings appearing when retrieving package details of a package with an invalid ID. Signed-off-by: Lukas Fleischer

Remove Dummy Package concept

2011-04-03T20:59:32Z

Instead, we just store dependencies directly in the PackageDepends table. Since we don't use this info anywhere besides the package details page, there is little value in precalculating what is in the AUR vs. what is not. An upgrade path is provided via several SQL statements in the UPGRADING document. There should be no user-visible change from this, but the DB schema gets a bit more sane and we no longer have loads of junk packages in our tables that are never shown to the end user. This should also help the MySQL query planner in several cases as we no longer have to be careful to exclude dummy packages on every query. Signed-off-by: Dan McGee Signed-off-by: Lukas Fleischer

Always set ModifiedTS including new packages

2011-04-03T20:59:31Z

Set it equal to the SubmittedTS field, which will be our indication the package is new when we show the logo on the front page of the AUR. This results in the ability to remove the use of the unindexable GREATEST() function from the AUR code everywhere we had to use it before to handle the 0 timestamp case. Note that there is no race condition here in calling UNIX_TIMESTAMP() twice- it always returns the time at the beginning of statment execution: mysql> select unix_timestamp(), sleep(2), unix_timestamp(); +------------------+----------+------------------+ | unix_timestamp() | sleep(2) | unix_timestamp() | +------------------+----------+------------------+ | 1300851746 | 0 | 1300851746 | +------------------+----------+------------------+ 1 row in set (2.00 sec) Signed-off-by: Dan McGee Signed-off-by: Lukas Fleischer

Bump up default per-page value to 50

2011-03-24T14:32:08Z

25 is woefully small for the number of packages many searches can return, and with 28000+ packages in AUR, it makes sense to show a lot more per page by default. The new choices of (50, 100, 250) happen to match those from the main site. Signed-off-by: Dan McGee Signed-off-by: Lukas Fleischer

Fix searching for orphans with "$LANG != 'en'" (fixes FS#23252).

2011-03-12T18:54:35Z

Regression introduced in commit ef8fab0c. Removed the strict check again instead of wrapping it in __() to ensure search URLs are language independent. Signed-off-by: Lukas Fleischer

Perform a second query to find total search count

2011-03-10T17:16:00Z

This removes the need for SQL_CALC_FOUND_ROWS which can really slow down queries in a lot of cases. The COUNT(*) query we end up performing can reuse a lot of the original clauses from our primary query, but we can really slim it up by omitting some joins and the sorting/limiting clauses. Signed-off-by: Dan McGee Signed-off-by: Lukas Fleischer

Split package search query into parts

2011-03-10T17:16:00Z

No functional change here; we should be rebuilding the same query at the end of the process. Signed-off-by: Dan McGee 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

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