From 6aef04189174430afcaa581b01db806b7687b3cd Mon Sep 17 00:00:00 2001 From: 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