From 620937ebfc09a9d8c8f54d3cada4bb0ad229b7d8 Mon Sep 17 00:00:00 2001 From: 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