K

Incorrect % in rating count & the phrase appears in other languages

  • Thread starter Thread starter kick
  • Start date Start date

Visitor Greeting

Welcome to NullWarehouse.com... We are currently seeking Mod's and Contributors. If you wish to apply for a Mod position then please click on Members dropdown arrow, then click on Staff App and fill it out completely and submit it. If you want to be a Contributor then start contributing and we will have our eye on you and take notice, something great could come of it.

  • We have redone the forum. If you notice any issues or errors please open a Support Ticket under the Members dropdown and let us know.
K

kick

Guest

In 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]);
But this is an incorrect value, because we get the number of reviews, without rating...

Read more

Continue reading...
 
Similar content Most view View more
Back
Top Bottom