diff options
| author | pjmattal <pjmattal> | 2005-08-05 20:11:41 +0200 |
|---|---|---|
| committer | pjmattal <pjmattal> | 2005-08-05 20:11:41 +0200 |
| commit | 6aef04189174430afcaa581b01db806b7687b3cd (patch) | |
| tree | 9918c56814e0c6e73dcd837985a217f0783e704b | |
| parent | ab525e309b6dd848003efd03360aed8f25390771 (diff) | |
| download | aur-6aef04189174430afcaa581b01db806b7687b3cd.tar.gz aur-6aef04189174430afcaa581b01db806b7687b3cd.tar.xz | |
fixed big bug in main query introduced in 1.2.1
changed wrong join to RIGHT JOIN!
| -rw-r--r-- | web/lib/pkgfuncs.inc | 2 |
1 files changed, 1 insertions, 1 deletions
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; |