[FIXED] Top rated videos

Eri · 2011-05-16 19:33:59

I do not know if this is a bug or not but i am posting it here

When i go to top rated videos i am getting to rated by number and not by stars.
The best top rated system must be first 5 stars videos with most rates then the 4,5 stars with most rates.............e.t.c

Or having a different system of rating like/dislike that will make the script faster

symtab · 2011-05-16 20:24:40

Top Rated is calculated by rating and rated_by, thats why in some cases, videos might appear with 4.5 stars, because there are more votes. I'll try to figure out a way though.

Eri · 2011-05-31 09:02:43

Fixed that
at /modules/video/components/browse.php

Replace

            case 'rated':
                $sql       .= ' ORDER BY (v.rating*v.rated_by) DESC';
                $order_name = __('top-rated');
                break;

With

case 'rated':
                $sql       .= ' ORDER BY v.rating DESC, v.rated_by DESC';
                $order_name = __('top-rated');
                break;

Last edited by Eri (2011-06-08 23:14:57)

Eri · 2011-07-08 12:28:51

Also per category top rated at /modules/video/components/category.php
Replace

 case 'rated':
                $sql       .= ' ORDER BY (v.rating*v.rated_by) DESC';
                $order_name = __('top-rated');
                break;

With

 case 'rated':
                $sql       .= ' ORDER BY v.rating DESC, v.rated_by DESC';
                $order_name = __('top-rated');
                break;

Last edited by Eri (2011-07-08 12:29:10)

symtab · 2011-07-12 13:08:41

Fixed in RC3.

Adult Script Pro Community Forums

#1 2011-05-16 19:33:59

[FIXED] Top rated videos

#2 2011-05-16 20:24:40

Re: [FIXED] Top rated videos

#3 2011-05-31 09:02:43

Re: [FIXED] Top rated videos

#4 2011-07-08 12:28:51

Re: [FIXED] Top rated videos

#5 2011-07-12 13:08:41

Re: [FIXED] Top rated videos

Board footer