From 05b89c62e9b974bee16a1a1a0f45892cc9261109 Mon Sep 17 00:00:00 2001 From: Thomas Minvielle Date: Tue, 9 Jul 2013 21:22:49 +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 3e8955e..f2136db 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 . ' + WHERE pa.type = \'home\' AND pa.latitude IS NOT NULL AND pa.longitude IS NOT NULL' . $where . ' AND p.deathdate IS NOT NULL GROUP BY pa.latitude, pa.longitude'); $page->jsonAssign('data', $data); } -- 2.1.4