diff options
author | Mario Vavti <mario@mariovavti.com> | 2018-01-19 09:16:51 +0100 |
---|---|---|
committer | Mario Vavti <mario@mariovavti.com> | 2018-01-19 09:16:51 +0100 |
commit | e9f32ef94e5cb188e86a8cf43f9580b462d0ea46 (patch) | |
tree | 553feae3fb0c8267262fb605b28857f412e57b41 /Zotlabs/Widget/Forums.php | |
parent | 2cf4381e19a05c98c523422dce39753c7381229d (diff) | |
parent | 764d6e3407f75cbe7a6f9635dd40cd2cca0f2b4f (diff) | |
download | volse-hubzilla-e9f32ef94e5cb188e86a8cf43f9580b462d0ea46.tar.gz volse-hubzilla-e9f32ef94e5cb188e86a8cf43f9580b462d0ea46.tar.bz2 volse-hubzilla-e9f32ef94e5cb188e86a8cf43f9580b462d0ea46.zip |
Merge remote-tracking branch 'mike/master' into dev
Diffstat (limited to 'Zotlabs/Widget/Forums.php')
-rw-r--r-- | Zotlabs/Widget/Forums.php | 22 |
1 files changed, 11 insertions, 11 deletions
diff --git a/Zotlabs/Widget/Forums.php b/Zotlabs/Widget/Forums.php index 0b90b9740..44d95012f 100644 --- a/Zotlabs/Widget/Forums.php +++ b/Zotlabs/Widget/Forums.php @@ -71,6 +71,8 @@ class Forums { if($r) $r1[$x]['unseen'] = $r[0]['unseen']; + } + /** * @FIXME * This SQL makes the counts correct when you get forum posts arriving from different routes/sources @@ -79,21 +81,19 @@ class Forums { * It may make more sense in that query to look for the mention in the body rather than another join, * but that makes it very inefficient. * - $r = q("select sum(item_unseen) as unseen from item left join term on oid = id where otype = %d and owner_xchan != '%s' and item.uid = %d and url = '%s' and ttype = %d $perms_sql ", - intval(TERM_OBJ_POST), - dbesc($r1[$x]['xchan_hash']), - intval(local_channel()), - dbesc($r1[$x]['xchan_url']), - intval(TERM_MENTION) - ); - if($r) - $r1[$x]['unseen'] = ((array_key_exists('unseen',$r1[$x])) ? $r1[$x]['unseen'] + $r[0]['unseen'] : $r[0]['unseen']); + * $r = q("select sum(item_unseen) as unseen from item left join term on oid = id where otype = %d and owner_xchan != '%s' and item.uid = %d and url = '%s' and ttype = %d $perms_sql ", + * intval(TERM_OBJ_POST), + * dbesc($r1[$x]['xchan_hash']), + * intval(local_channel()), + * dbesc($r1[$x]['xchan_url']), + * intval(TERM_MENTION) + * ); + * if($r) + * $r1[$x]['unseen'] = ((array_key_exists('unseen',$r1[$x])) ? $r1[$x]['unseen'] + $r[0]['unseen'] : $r[0]['unseen']); * * end @FIXME */ - } - if($r1) { $o .= '<div class="widget">'; $o .= '<h3>' . t('Forums') . '</h3><ul class="nav nav-pills flex-column">'; |