diff options
| author | pjmattal <pjmattal> | 2005-08-05 03:58:22 +0000 |
|---|---|---|
| committer | pjmattal <pjmattal> | 2005-08-05 03:58:22 +0000 |
| commit | 620937ebfc09a9d8c8f54d3cada4bb0ad229b7d8 (patch) | |
| tree | a63da96567571dae577503f2ad7d2849701bb6cf | |
| parent | 8d4a353425fb18b1e69c4c9f8bde096d1e77841d (diff) | |
| download | aurweb-620937ebfc09a9d8c8f54d3cada4bb0ad229b7d8.tar.xz | |
fixed bug I introduced in 1.2.1 with now requiring outer (left) join in main
query
| -rw-r--r-- | web/lib/pkgfuncs.inc | 6 |
1 files changed, 3 insertions, 3 deletions
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"])) { |