diff options
| author | Lukas Fleischer <archlinux@cryptocrack.de> | 2014-06-07 05:24:11 +0200 |
|---|---|---|
| committer | Lukas Fleischer <archlinux@cryptocrack.de> | 2014-06-07 05:24:11 +0200 |
| commit | 43f5167f75d1bc748cdfe21364f3d440a7992e08 (patch) | |
| tree | 3c998cde251d0c15e6de7b984d94c4eb86ba7c62 | |
| parent | e37a49d7269d9f31e9fed9c1e3cd52bba7ae069a (diff) | |
| download | aur-43f5167f75d1bc748cdfe21364f3d440a7992e08.tar.gz aur-43f5167f75d1bc748cdfe21364f3d440a7992e08.tar.xz | |
Fix latest_pkgs() again
In 4cd6841 (pkgfuncs.inc.php: Fix latest_pkgs(), 2014-05-29),
latest_pkgs() was modified to work with the new database layout.
However, since all columns were selected, package names have been
overwritten by package base names since that change. Qualify the
*-shorthand to avoid this.
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
| -rw-r--r-- | web/lib/pkgfuncs.inc.php | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/web/lib/pkgfuncs.inc.php b/web/lib/pkgfuncs.inc.php index c7360514..f5158646 100644 --- a/web/lib/pkgfuncs.inc.php +++ b/web/lib/pkgfuncs.inc.php @@ -954,7 +954,8 @@ function pkg_add_lic($pkgid, $licid) { function latest_pkgs($numpkgs) { $dbh = DB::connect(); - $q = "SELECT * FROM Packages LEFT JOIN PackageBases ON "; + $q = "SELECT Packages.*, MaintainerUID, SubmittedTS "; + $q.= "FROM Packages LEFT JOIN PackageBases ON "; $q.= "PackageBases.ID = Packages.PackageBaseID "; $q.= "ORDER BY SubmittedTS DESC "; $q.= "LIMIT " . intval($numpkgs); |