K
kick
Guest
In
We get this query:
PHP:
But this is an incorrect value, because we get the number of reviews, without rating...
Read more
Continue reading...
getResourceRatingSplit
We get this query:
PHP:
Code:
$splitRatings = $this->app()->db()->fetchAllKeyed("
SELECT rating,
COUNT(*) AS total,
(COUNT(*) / ?) * 100 AS percentage
FROM xf_rm_resource_rating
WHERE resource_id = ?
AND rating_state = 'visible'
GROUP BY rating
", 'rating', [$resource->review_count, $resource->resource_id]);
Read more
Continue reading...