From 620937ebfc09a9d8c8f54d3cada4bb0ad229b7d8 Mon Sep 17 00:00:00 2001
From: pjmattal <pjmattal>
Date: Fri, 5 Aug 2005 03:58:22 +0000
Subject: fixed bug I introduced in 1.2.1 with now requiring outer (left) join
 in main query

---
 web/lib/pkgfuncs.inc | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

(limited to 'web')

diff --git a/web/lib/pkgfuncs.inc b/web/lib/pkgfuncs.inc
index 550c6cb..7427947 100644
--- a/web/lib/pkgfuncs.inc
+++ b/web/lib/pkgfuncs.inc
@@ -736,9 +736,9 @@ function pkg_search_page($SID="") {
 #	$q = "SELECT Packages.*, IF(ISNULL(PackageID), 0, COUNT(*)) AS Votes ";
 #	$q.= "FROM Packages LEFT JOIN PackageVotes ";
 #	$q.= "ON Packages.ID = PackageVotes.PackageID ";
-	$q = "SELECT * FROM Users,Packages ";
-	$q.= "WHERE Users.ID = Packages.MaintainerUID AND ";
-	$q.= "DummyPkg != 1 ";
+	$q = "SELECT * FROM Packages LEFT JOIN Users ";
+	$q.= "ON (Users.ID = Packages.MaintainerUID) ";
+	$q.= "WHERE DummyPkg != 1 ";
 	$has_where = 1;
 
 	if (intval($_REQUEST["L"])) {
-- 
cgit v1.2.3-70-g09d2