From 6aef04189174430afcaa581b01db806b7687b3cd Mon Sep 17 00:00:00 2001
From: pjmattal <pjmattal>
Date: Fri, 5 Aug 2005 18:11:41 +0000
Subject: fixed big bug in main query introduced in 1.2.1 changed wrong join to
 RIGHT JOIN!

---
 web/lib/pkgfuncs.inc | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'web')

diff --git a/web/lib/pkgfuncs.inc b/web/lib/pkgfuncs.inc
index 7427947b..c4a30d51 100644
--- a/web/lib/pkgfuncs.inc
+++ b/web/lib/pkgfuncs.inc
@@ -736,7 +736,7 @@ 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 Packages LEFT JOIN Users ";
+	$q = "SELECT * FROM Users RIGHT JOIN Packages ";
 	$q.= "ON (Users.ID = Packages.MaintainerUID) ";
 	$q.= "WHERE DummyPkg != 1 ";
 	$has_where = 1;
-- 
cgit v1.2.3-24-g4f1b