diff options
| author | redmatrix <redmatrix@redmatrix.me> | 2015-11-01 16:19:28 -0800 |
|---|---|---|
| committer | redmatrix <redmatrix@redmatrix.me> | 2015-11-01 16:19:28 -0800 |
| commit | 14e92f53f16b0f98bb4574f98c54c68e08d528dc (patch) | |
| tree | 4c273a1c4278ada816df4bb0a46feef23a7dc23c | |
| parent | d3183467e06d6d7a04221c63d26173f97217cc43 (diff) | |
| download | volse-hubzilla-14e92f53f16b0f98bb4574f98c54c68e08d528dc.tar.gz volse-hubzilla-14e92f53f16b0f98bb4574f98c54c68e08d528dc.tar.bz2 volse-hubzilla-14e92f53f16b0f98bb4574f98c54c68e08d528dc.zip | |
hubloc filtering to eliminate dead and deleted entries
| -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']) ); |