[aur-dev] [PATCH 2/2] pkgfuncs.inc.php: Fix latest_pkgs()

[Lukas Fleischer]

This fixes a regression introduced when adding split package support and
makes the RSS feed work again.

Signed-off-by: Lukas Fleischer <archlinux at cryptocrack.de>
---
 web/lib/pkgfuncs.inc.php | 6 ++++--
 1 file changed, 4 insertions(+), 2 deletions(-)

diff --git a/web/lib/pkgfuncs.inc.php b/web/lib/pkgfuncs.inc.php
index a43512c..3bbf1a1 100644
--- a/web/lib/pkgfuncs.inc.php
+++ b/web/lib/pkgfuncs.inc.php
@@ -953,11 +953,13 @@ function pkg_add_lic($pkgid, $licid) {
 function latest_pkgs($numpkgs) {
 	$dbh = DB::connect();
 
-	$q = "SELECT * FROM Packages ";
+	$q = "SELECT * FROM Packages LEFT JOIN PackageBases ON ";
+	$q.= "PackageBases.ID = Packages.PackageBaseID ";
 	$q.= "ORDER BY SubmittedTS DESC ";
-	$q.= "LIMIT " .intval($numpkgs);
+	$q.= "LIMIT " . intval($numpkgs);
 	$result = $dbh->query($q);
 
+	$packages = array();
 	if ($result) {
 		while ($row = $result->fetch(PDO::FETCH_ASSOC)) {
 			$packages[] = $row;
-- 
1.9.3