[aur-dev] [PATCH] Fix latest_pkgs() again

[Lukas Fleischer]

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 at cryptocrack.de>
---
 web/lib/pkgfuncs.inc.php | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/web/lib/pkgfuncs.inc.php b/web/lib/pkgfuncs.inc.php
index c736051..f515864 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);
-- 
2.0.0