aboutsummaryrefslogtreecommitdiffstats
path: root/mod/connedit.php
diff options
context:
space:
mode:
authorredmatrix <redmatrix@redmatrix.me>2015-11-01 16:19:28 -0800
committerredmatrix <redmatrix@redmatrix.me>2015-11-01 16:19:28 -0800
commit14e92f53f16b0f98bb4574f98c54c68e08d528dc (patch)
tree4c273a1c4278ada816df4bb0a46feef23a7dc23c /mod/connedit.php
parentd3183467e06d6d7a04221c63d26173f97217cc43 (diff)
downloadvolse-hubzilla-14e92f53f16b0f98bb4574f98c54c68e08d528dc.tar.gz
volse-hubzilla-14e92f53f16b0f98bb4574f98c54c68e08d528dc.tar.bz2
volse-hubzilla-14e92f53f16b0f98bb4574f98c54c68e08d528dc.zip
hubloc filtering to eliminate dead and deleted entries
Diffstat (limited to 'mod/connedit.php')
-rw-r--r--mod/connedit.php3
1 files changed, 2 insertions, 1 deletions
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'])
);