Plugin Rating Fied

mfe13
OFFLINE
Posts: 619
Thanks: 26
Karma: 5

11 years 8 months ago #210058 by mfe13

Plugin Rating Fied was created by mfe13

Hi,

I have a question on this plugin.

There is In the field "Stars-your rating" > Log Rating Details: "If set to "yes", detail about each rating will be logged such as IP adress, User IP,DateTime, etc."
Is it possible to retrieve these values to show in new field ?

Thanks for answer.

Please Log in or Create an account to join the conversation.

krileon
ONLINE
Posts: 68625
Thanks: 9109
Karma: 1434

11 years 8 months ago #210062 by krileon

Replied by krileon on topic Re: Plugin Rating Fied

You could use CB Query Field to query the _comprofiler_ratingfield_log database table and display the results.

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in or Create an account to join the conversation.

mfe13
OFFLINE
Posts: 619
Thanks: 26
Karma: 5

11 years 8 months ago - 11 years 8 months ago #210083 by mfe13

Replied by mfe13 on topic Re: Plugin Rating Fied

Hi,
Thanks for this response. I'm doing this:
but how to have the username and not the userID ?

Thank you for your help

Attachments:

Last edit: 11 years 8 months ago by mfe13.

Please Log in or Create an account to join the conversation.

krileon
ONLINE
Posts: 68625
Thanks: 9109
Karma: 1434

11 years 8 months ago #210189 by krileon

Replied by krileon on topic Re: Plugin Rating Fied

Your query isn't specific enough. Please try the below.

Code:

SELECT `rating`, `rateruserid` FROM `#__comprofiler_ratingfield_log` WHERE `rateduserid` = '[user_id]'

You also have it set to single row output so it's only going to display 1 result. You need to set it to multiple rows.

Please Log in or Create an account to join the conversation.

Moderators: beat, nant, krileon