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

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'])