Newsletter

Login Form



Donate

 

Es kostet Zeit, Geld und Know-how, diese Plugins zu entwickeln und kostenlos zur Verfügung zu stellen. Wenn Sie meine Arbeit nützlich finden, ziehen Sie bitte in Betracht, mich mit einer kleinen Spende zu unterstützen.

It takes time, money and know-how to develop and offer this stuff for free. If you find my work useful, consider please to support it with a small donation.

Home Support Forum
Welcome, Guest
Please Login or Register.    Lost Password?

highest rated module
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: highest rated module
#150
highest rated module 3 Years, 6 Months ago  
Hi!

first of all, i love cb rating! great script!
but i have a little question. i'm using the cb rating module as some sort of highest rated users module. but a user that got 1 positive vote on lets say 10 september gets a higher spot than a user that got 3 positive votes on 20 september. in my opinion this is strange. most people who rate will rate 100% so my question is: is there a way to get the highest rated with most positive votes first? not the one that got 100% first..

greetings
Jeroen Seeuws
gelkoppeke
Fresh Boarder
Posts: 4
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#152
Re:highest rated module 3 Years, 6 Months ago  
Hi,
you can set a minimum of ratings a user must have to be displayed with the top 10.
See config page of the module.

Cheers,
admin
Moderator
Posts: 112
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#154
Re:highest rated module 3 Years, 6 Months ago  
yes i know that. but that doesn't fix the problem. if i set a minimum of 4 a user that got 6 x 100% is above a user who got 200054852 x 100% at a later time. that is the problem.
gelkoppeke
Fresh Boarder
Posts: 4
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#155
Re:highest rated module 3 Years, 6 Months ago  
the ordering is like this:
Code:

$orderby_clause = "\n ORDER BY rating DESC";

where 'rating' is the number of positive ratings divided by the number of total ratings.
Time does not matter.

It may solve your problem if you include the total number of ratings as prior to the division. That means to replace the line above whith:
Code:


$orderby_clause = "\n ORDER BY b.total_rating, rating DESC";

admin
Moderator
Posts: 112
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#156
Re:highest rated module 3 Years, 6 Months ago  
thanks for the fast reply!
i tried it but it doesn't seem to work..
i did exactly like you said i had to do.
gelkoppeke
Fresh Boarder
Posts: 4
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#157
Re:highest rated module 3 Years, 6 Months ago  
ok it seems i fixed it with some little thinking

i changed:
Code:

$orderby_clause = "\n ORDER BY b.total_rating, rating DESC";


into
Code:

$orderby_clause = "\n ORDER BY rating, b.total_rating DESC";


and now it seems to work fine

thanks a lot!
gelkoppeke
Fresh Boarder
Posts: 4
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
Go to topPage: 1

© 2012 by lbm-services.de - All rights reserved.

Valid XHTML 1.0 Transitional