diff options
author | Mario <mario@mariovavti.com> | 2024-04-17 10:00:40 +0000 |
---|---|---|
committer | Mario <mario@mariovavti.com> | 2024-04-17 10:00:40 +0000 |
commit | 3b812f25703a496c91fb92409db173b38d4cc115 (patch) | |
tree | cbc773acccbe79d89679f6545e45a774962dc5cb | |
parent | 2e15207d0bdbe147f9d1f21030f4c36b02c3dedf (diff) | |
download | volse-hubzilla-3b812f25703a496c91fb92409db173b38d4cc115.tar.gz volse-hubzilla-3b812f25703a496c91fb92409db173b38d4cc115.tar.bz2 volse-hubzilla-3b812f25703a496c91fb92409db173b38d4cc115.zip |
comment out deprecated way to find forum items and do not count announce activities
-rw-r--r-- | Zotlabs/Module/Sse_bs.php | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/Zotlabs/Module/Sse_bs.php b/Zotlabs/Module/Sse_bs.php index a18301a1a..09c4ed614 100644 --- a/Zotlabs/Module/Sse_bs.php +++ b/Zotlabs/Module/Sse_bs.php @@ -590,6 +590,7 @@ class Sse_bs extends Controller { if($forums) { $item_normal = item_normal(); + $p_sql = ''; $sql_extra = ''; if(! (self::$vnotify & VNOTIFY_LIKE)) @@ -599,6 +600,7 @@ class Sse_bs extends Controller { $i = 0; for($x = 0; $x < $fcount; $x ++) { + /* $p = q("SELECT oid AS parent FROM term WHERE uid = %d AND ttype = %d AND term = '%s'", intval(self::$uid), intval(TERM_FORUM), @@ -607,14 +609,16 @@ class Sse_bs extends Controller { $p_str = ids_to_querystr($p, 'parent'); $p_sql = (($p_str) ? "OR parent IN ( $p_str )" : ''); + */ $r = q("select count(*) as total from item - where uid = %d and ( owner_xchan = '%s' OR author_xchan = '%s' $p_sql ) and item_unseen = 1 $sql_extra $item_normal", + where uid = %d and ( owner_xchan = '%s' OR author_xchan = '%s' $p_sql ) and verb != 'Announce' and item_unseen = 1 $sql_extra $item_normal", intval(self::$uid), dbesc($forums[$x]['xchan_hash']), dbesc($forums[$x]['xchan_hash']) ); + if($r[0]['total']) { $forums[$x]['notify_link'] = z_root() . '/network/?f=&pf=1&unseen=1&cid=' . $forums[$x]['abook_id']; |