From 3d8d52632b20b96e2236330c49c88a33c999e72f Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Fri, 18 Jan 2013 22:27:18 +0100 Subject: [PATCH] respect exclude_place_ids in poi searches --- website/search.php | 9 ++++++++- 1 file changed, 8 insertions(+), 1 deletion(-) diff --git a/website/search.php b/website/search.php index cea1ec03..e00d8791 100755 --- a/website/search.php +++ b/website/search.php @@ -831,12 +831,19 @@ if ($sCountryCodesSQL) $sSQL .= " join placex using (place_id)"; $sSQL .= " where st_contains($sViewboxSmallSQL, ct.centroid)"; if ($sCountryCodesSQL) $sSQL .= " and country_code in ($sCountryCodesSQL)"; + if (sizeof($aExcludePlaceIDs)) + { + $sSQL .= " and place_id not in (".join(',',$aExcludePlaceIDs).")"; + } if ($sViewboxCentreSQL) $sSQL .= " order by st_distance($sViewboxCentreSQL, ct.centroid) asc"; $sSQL .= " limit $iLimit"; if (CONST_Debug) var_dump($sSQL); $aPlaceIDs = $oDB->getCol($sSQL); - if (!sizeof($aPlaceIDs)) + // If excluded place IDs are given, it is fair to assume that + // there have been results in the small box, so no further + // expansion in that case. + if (!sizeof($aPlaceIDs) && !sizeof($aExcludePlaceIDs)) { $sSQL = "select place_id from place_classtype_".$aSearch['sClass']."_".$aSearch['sType']." ct"; if ($sCountryCodesSQL) $sSQL .= " join placex using (place_id)"; -- 2.39.5