summaryrefslogtreecommitdiff
path: root/web
diff options
context:
space:
mode:
authorpjmattal <pjmattal>2005-08-05 18:11:41 +0000
committerpjmattal <pjmattal>2005-08-05 18:11:41 +0000
commit6aef04189174430afcaa581b01db806b7687b3cd (patch)
tree9918c56814e0c6e73dcd837985a217f0783e704b /web
parentab525e309b6dd848003efd03360aed8f25390771 (diff)
fixed big bug in main query introduced in 1.2.1
changed wrong join to RIGHT JOIN!
Diffstat (limited to 'web')
-rw-r--r--web/lib/pkgfuncs.inc2
1 files changed, 1 insertions, 1 deletions
diff --git a/web/lib/pkgfuncs.inc b/web/lib/pkgfuncs.inc
index 7427947..c4a30d5 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;