From 14e92f53f16b0f98bb4574f98c54c68e08d528dc Mon Sep 17 00:00:00 2001 From: redmatrix Date: Sun, 1 Nov 2015 16:19:28 -0800 Subject: hubloc filtering to eliminate dead and deleted entries --- mod/connedit.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/mod/connedit.php b/mod/connedit.php index c8f83b0e8..87ca55703 100644 --- a/mod/connedit.php +++ b/mod/connedit.php @@ -654,7 +654,8 @@ function connedit_content(&$a) { $locstr = ''; - $locs = q("select hubloc_addr as location from hubloc where hubloc_hash = '%s' and hubloc_network = 'zot'", + $locs = q("select hubloc_addr as location from hubloc left join site on hubloc_url = site_url where hubloc_hash = '%s' + and hubloc_network = 'zot' and hubloc_deleted = 0 and site_dead = 0", dbesc($contact['xchan_hash']) ); -- cgit v1.2.3