markzz/aurweb.git/web/lib/aurjson.class.php, branch 1.8.2

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

Drop PackageLocations table and references

2011-02-01T11:41:08Z

We don't need this anymore since all packages managed here are well...managed here. Rip out all of the places we were using this field, many of which depended on the magic value '2' anyway. On the display side of things, we had a column that was always showing 'unsupported' that is now gone, and you can no longer sort by this column. Signed-off-by: Dan McGee Signed-off-by: Lukas Fleischer

aurjson: Escape wildcards in "LIKE" patterns (fixes FS#18626).

2011-01-28T15:54:58Z

Percent signs ("%") and underscores ("_") are not escaped by mysql_real_escape_string() and are interpreted as wildcards if combined with "LIKE", so we need to deal with them separately. Signed-off-by: Lukas Fleischer

Build URLs from package names (fixes FS#15308, FS#19327).

2011-01-24T17:08:29Z

Drop the "URLPath" field from the "Packages" table, build URLs from package names instead. Signed-off-by: Lukas Fleischer

Add timestamp when a package is flagged out-of-date (FS#20848).

2010-11-10T19:50:35Z

Signed-off-by: Loui Chang - resolve conflict and omit i18n changes.

aurjson: Only return an error string if utf8_encode returns an empty string.

2009-10-23T16:35:02Z

This allows 0 and '0' values to pass. Signed-off-by: Loui Chang

Fix json info output.

2009-10-01T20:41:22Z

Commit 325347a introduced a regression causing an improper database query. Signed-off-by: Loui Chang

Add maintainer search to json interface. Closes FS#15947

2009-09-28T19:44:31Z

Fix for maintainer search ticket: FS#15947 Also http://mailman.archlinux.org/pipermail/aur-dev/2009-September/000892.html Fixed some problems with selecting the proper data fields in the original patch. - Loui Signed-off-by: Loui Chang

fix content-type when sending jsonp

2009-09-28T19:17:07Z

jsonp callback should have a content type of text/javascipt, since it specifies a callback function wrapping json data, and is not soley json data. Signed-off-by: Loui Chang

Fix: FS#15526 non-UTF8 character in rpc output

2009-09-16T11:50:44Z

Currently AUR does not check the uploaded packages, whether they are correctly in UTF8 encoding. If there are fields (such as $pkgdesc) that contain such non-UTF8 characters, the rpc interface chokes on those fields: even if there's data successfully retrieved from the database, rpc returns "null". In an effort to make such errors in the PKGBUILDs debugged more easily, let's force rpc to have more useful output: try to convert non-UTF8 fields to UTF8. If it's a success, good. Partial success (some characters showing as \uXXXX) is ok. Failure results in error message printed to that field. Signed-off-by: Gergely Imreh Signed-off-by: Loui Chang