TickTackk
Well-known member
In Category model under prepareCategoryFetchOptions function
should be
PHP:
if (isset($fetchOptions['watchUserId']))
{
if (!empty($fetchOptions['watchUserId']))
{
$selectFields .= ',
IF(category_watch.user_id IS NULL, 0, 1) AS category_is_watched';
$joinTables .= '
LEFT JOIN xf_resource_category_watch AS category_watch
ON (category_watch.resource_category_id = resource_category.resource_category_id
AND category_watch.user_id = ' . $this->_getDb()->quote($fetchOptions['watchUserId']) . ')';
}
else
{
$selectFields .= ',
0 AS forum_is_watched';
}
}
should be
PHP:
if (isset($fetchOptions['watchUserId']))
{
if (!empty($fetchOptions['watchUserId']))
{
$selectFields .= ',
IF(category_watch.user_id IS NULL, 0, 1) AS category_is_watched';
$joinTables .= '
LEFT JOIN xf_resource_category_watch AS category_watch
ON (category_watch.resource_category_id = resource_category.resource_category_id
AND category_watch.user_id = ' . $this->_getDb()->quote($fetchOptions['watchUserId']) . ')';
}
else
{
$selectFields .= ',
0 AS category_is_watched';
}
}