diff options
| author | Mario Vavti <mario@mariovavti.com> | 2018-10-29 23:01:13 +0100 |
|---|---|---|
| committer | Mario Vavti <mario@mariovavti.com> | 2018-10-29 23:01:13 +0100 |
| commit | 1eac4db491e6c597b56752b7915fdcafc529ed5e (patch) | |
| tree | f4517f77ea0f54aaff4fc2361ad73839621cd0e2 | |
| parent | 0f19627407ccd373afe1ce2d2347ea240f3195c1 (diff) | |
| download | volse-hubzilla-1eac4db491e6c597b56752b7915fdcafc529ed5e.tar.gz volse-hubzilla-1eac4db491e6c597b56752b7915fdcafc529ed5e.tar.bz2 volse-hubzilla-1eac4db491e6c597b56752b7915fdcafc529ed5e.zip | |
fix forum ping results - the term query requires xchan_name instead of xchan_hash. also improve the query itself - item_permission_sql() is redundant here since we always deal with local_channel() and use count(id) instead of sum(item_unseen) to get the unseen count
| -rw-r--r-- | Zotlabs/Module/Ping.php | 7 |
1 files changed, 3 insertions, 4 deletions
diff --git a/Zotlabs/Module/Ping.php b/Zotlabs/Module/Ping.php index 75e8843d6..cf5b2e004 100644 --- a/Zotlabs/Module/Ping.php +++ b/Zotlabs/Module/Ping.php @@ -635,7 +635,6 @@ class Ping extends \Zotlabs\Web\Controller { $forums = get_forum_channels(local_channel()); if($forums) { - $perms_sql = item_permissions_sql(local_channel()); $item_normal = item_normal(); $fcount = count($forums); $forums['total'] = 0; @@ -644,14 +643,14 @@ class Ping extends \Zotlabs\Web\Controller { $p = q("SELECT oid AS parent FROM term WHERE uid = %d AND ttype = %d AND term = '%s'", intval(local_channel()), intval(TERM_FORUM), - dbesc($forums[$x]['xchan_hash']) + dbesc($forums[$x]['xchan_name']) ); $p_str = ids_to_querystr($p, 'parent'); $p_sql = (($p_str) ? "OR parent IN ( $p_str )" : ''); - $r = q("select sum(item_unseen) as unseen from item - where uid = %d and ( owner_xchan = '%s' OR author_xchan = '%s' $p_sql ) and item_unseen = 1 $perms_sql $item_normal", + $r = q("select count(id) as unseen from item + where uid = %d and ( owner_xchan = '%s' OR author_xchan = '%s' $p_sql ) and item_unseen = 1 $item_normal", intval(local_channel()), dbesc($forums[$x]['xchan_hash']), dbesc($forums[$x]['xchan_hash']) |