markzz/aurweb.git/web/lib/pkgfuncs.inc, branch v3.4.2

rename .inc files to .inc.php and adjust imports and references

2011-06-22T13:15:04Z

Lukas: Add note to "UPGRADING". Signed-off-by: Lukas Fleischer

test return value from db_query before assuming it is valid

2011-05-17T08:43:42Z

make the sql query form consistent in usage by cleaning up instances where db_query's result was not inspected before attempting to fetch row data from the handle Signed-off-by: Lukas Fleischer

SQL: use standard LIMIT/OFFSET syntax

2011-04-27T12:50:27Z

Increases compatibility with standard SQL dialect. Thanks-to: elij Signed-off-by: Dan McGee Signed-off-by: Lukas Fleischer

Use HTTPs for links in out of date notification mails.

2011-04-19T22:02:09Z

Signed-off-by: Lukas Fleischer

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