[SOLVED] CB Rating count and log info

I started to use your Rating plugin, which is, as usually, cool and functional.
I have two questions about it:
1. Where is the count of how many users rates the member, That information is obviously vital if a user has 5 stars, he/she could get there easily with one vote, so we need a count
2. I enabled logging of the rater's info. Where can I view hat information?

Tnx,
BK

1. Where is the count of how many users rates the member, That information is obviously vital if a user has 5 stars, he/she could get there easily with one vote, so we need a count

As far as I am aware there is no counter. It displays overall rating through the stars.

2. I enabled logging of the rater's info. Where can I view hat information?

There's no frontend or backend viewing for this information. It's stored within your database in table _comprofiler_ratingfield_log.

Hey K,

I'm guessing the star rating is an average calculated according to rating divided by how many people voted, right? Is there a way I can display how many people voted just next to the stars? like ***** (75 votes).

How do I do that?

Have a good week,
BK

How do I do that?

As stated earlier there's no feature in the rating field for this. You'd need to edit the source code of the field (which I can't assist with) or you could use for example incubator project CB Query Field which allows displaying the results of a database query as a field. You could use that to query the database for the vote count.

Alright, I downloaded it and installed.
Any chance you could tell me what the query is to display that information? Once I have that example I will know how to query other fields.
thnx, bk

Any chance you could tell me what the query is to display that information? Once I have that example I will know how to query other fields.

Any valid MYSQL will work; except substitutions and Joomla syntax is also supported (example #__ for table prefix instead of jos_). Below query will pull vote count.