Rating Field (Stars - My Rating / Your Rating, PB Ranking)

No, users can reset their individual ratings of the user though using the button to the far left of the stars. I suppose if everyone reset their rating all at once it'd reset it back to 0. You could manually reset via database if needed though.

Im assuming you mean, setting up the field to allow multiple ratings? And then the user can vote again? But does this send a new additional vote or does it reset the original vote?

If I have multiple voting set to "no" then once I vote, there is no option to reset or vote again.


Also, when I change the words "Star" and "Stars", to something else, in the field manager where it says singular and plural, it wont update on the profile page.

As stars or as an integer? You can re-output it elsewhere using substitutions in a delimiter field. The standard [FIELDNAME] will give you the average as an integer.

Ok, as integers worked, but how do I output the overall average rate as stars?

Or display them as a percentage, so maybe round them up or down and add a 0 at the end?

Im assuming you mean, setting up the field to allow multiple ratings? And then the user can vote again? But does this send a new additional vote or does it reset the original vote?

When you use a "Your Rating" type field then other users rate you. Each user gets 1 rating. You can however enable multiple ratings if you want.

If I have multiple voting set to "no" then once I vote, there is no option to reset or vote again.

Correct, it's only present during the rating process. If you want them to rate again you need to enable multiple rating.

Ok, as integers worked, but how do I output the overall average rate as stars?

You'll need to use CB Query Field to query the database and calculate the average, but [FIELDNAME] is already the average based off the maximum number of stars.

Or display them as a percentage, so maybe round them up or down and add a 0 at the end?

You'd have to use CB Query Field and query the database for the rating average then use MYSQL functions on it to alter it as needed.

Ok, if [fieldname] gives the average, I am trying to manipulate the average (eg. multiply by 10 in order to move the decimal over to the right). I'm trying to use CB query field for this, but can't seem to pull the average from the database.

When I use

SELECT `fieldname` FROM `#__comprofiler`

I just get "0" as the output on the profile.

How do I query the average through CB query field so I can use MYsql functions to manipulate it on the same query?

You need to specify a user in your query. Example as follows.

SELECT `FIELD_NAME` FROM `#__comprofiler` WHERE `id` = '[user_id]'

There's no need to multiply by 10 as you can reformat, round, etc.. using MYSQL functions found below.

dev.mysql.com/doc/refman/5.6/en/functions.html