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...