From 84194eaa56ffbf3d57c5a566bf1138ae4b04780f Mon Sep 17 00:00:00 2001 From: Thomas Minvielle Date: Tue, 9 Jul 2013 22:54:56 +0200 Subject: [PATCH] Removes the dead from the map. --- modules/geoloc.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/modules/geoloc.php b/modules/geoloc.php index f2136db..21c7044 100644 --- a/modules/geoloc.php +++ b/modules/geoloc.php @@ -65,7 +65,7 @@ class GeolocModule extends PLModule FROM profile_addresses AS pa INNER JOIN profiles AS p ON (pa.pid = p.pid) INNER JOIN profile_display AS pd ON (pd.pid = pa.pid) - WHERE pa.type = \'home\' AND pa.latitude IS NOT NULL AND pa.longitude IS NOT NULL' . $where . ' AND p.deathdate IS NOT NULL + WHERE pa.type = \'home\' AND p.deathdate IS NULL AND pa.latitude IS NOT NULL AND pa.longitude IS NOT NULL' . $where . ' GROUP BY pa.latitude, pa.longitude'); $page->jsonAssign('data', $data); } -- 2.1.4