aboutsummaryrefslogtreecommitdiffstats
path: root/Zotlabs/Module
diff options
context:
space:
mode:
authorMario <mario@mariovavti.com>2023-07-04 09:07:39 +0000
committerMario <mario@mariovavti.com>2023-07-04 09:07:39 +0000
commite57211fbd10079a860c8d6b7c5f71efb297134bb (patch)
treeb40eda2d170add6e4a61847cf36b9da3100a8586 /Zotlabs/Module
parentd31eb4c89cd0a53eb3caaf2d0ce2f317c251aa89 (diff)
downloadvolse-hubzilla-e57211fbd10079a860c8d6b7c5f71efb297134bb.tar.gz
volse-hubzilla-e57211fbd10079a860c8d6b7c5f71efb297134bb.tar.bz2
volse-hubzilla-e57211fbd10079a860c8d6b7c5f71efb297134bb.zip
also filter deleted hublocs
Diffstat (limited to 'Zotlabs/Module')
-rw-r--r--Zotlabs/Module/Dirsearch.php2
1 files changed, 1 insertions, 1 deletions
diff --git a/Zotlabs/Module/Dirsearch.php b/Zotlabs/Module/Dirsearch.php
index 7efac6345..a5c3f41c0 100644
--- a/Zotlabs/Module/Dirsearch.php
+++ b/Zotlabs/Module/Dirsearch.php
@@ -273,7 +273,7 @@ class Dirsearch extends Controller {
xprof.xprof_hometown as hometown,
xprof.xprof_keywords as keywords
from xchan left join xprof on xchan_hash = xprof_hash left join hubloc on (hubloc_id_url = xchan_url and hubloc_hash = xchan_hash)
- where hubloc_primary = 1 and hubloc_updated > %s - INTERVAL %s and ( $logic $sql_extra ) $hub_query $keywords_query and xchan_network = 'zot6' and xchan_system = 0 and xchan_hidden = 0 and xchan_orphan = 0 and xchan_deleted = 0
+ where hubloc_primary = 1 and hubloc_updated > %s - INTERVAL %s and ( $logic $sql_extra ) $hub_query $keywords_query and xchan_network = 'zot6' and xchan_system = 0 and xchan_hidden = 0 and xchan_orphan = 0 and xchan_deleted = 0 and hubloc_deleted = 0
$safesql $order $qlimit",
db_utcnow(),
db_quoteinterval('30 DAY')