summaryrefslogtreecommitdiffstats
path: root/web
diff options
context:
space:
mode:
authorpjmattal <pjmattal>2005-08-05 05:58:22 +0200
committerpjmattal <pjmattal>2005-08-05 05:58:22 +0200
commit620937ebfc09a9d8c8f54d3cada4bb0ad229b7d8 (patch)
treea63da96567571dae577503f2ad7d2849701bb6cf /web
parent8d4a353425fb18b1e69c4c9f8bde096d1e77841d (diff)
downloadaur-620937ebfc09a9d8c8f54d3cada4bb0ad229b7d8.tar.gz
aur-620937ebfc09a9d8c8f54d3cada4bb0ad229b7d8.tar.xz
fixed bug I introduced in 1.2.1 with now requiring outer (left) join in main
query
Diffstat (limited to 'web')
-rw-r--r--web/lib/pkgfuncs.inc6
1 files changed, 3 insertions, 3 deletions
diff --git a/web/lib/pkgfuncs.inc b/web/lib/pkgfuncs.inc
index 550c6cb9..7427947b 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"])) {