aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-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'])
);