summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorLukas Fleischer <archlinux@cryptocrack.de>2014-06-07 05:24:11 +0200
committerLukas Fleischer <archlinux@cryptocrack.de>2014-06-07 05:24:11 +0200
commit43f5167f75d1bc748cdfe21364f3d440a7992e08 (patch)
tree3c998cde251d0c15e6de7b984d94c4eb86ba7c62
parente37a49d7269d9f31e9fed9c1e3cd52bba7ae069a (diff)
downloadaur-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.php3
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);