diff options
| -rw-r--r-- | mod/connedit.php | 3 |
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']) ); |