One of my clients accidentally gave her listing a one star rating.  Is there a way of resetting the ratings?

For ethical reasons, I cannot describe the procedure of manipulating the rating count.

The ratings are stored in the XMod SQL database table named KB_XMod_Ratings.

Each rating is a record that is based on the XModID (The ID of the particular listing) and the FormID.

By hoovering your mouse over a More Info button on a listing will reveal the xmid value in your browser tray. The xmid value in the URL string is the value that is mapped to the XModID in the table.

A SQL query on the KB_XMod_Ratings table with the criteria of the XMod listing record ID would produce a look at the offending rating.

Buck

In a new details form (view more info) I can't get the rating stars to show on the page. The text (Click a star below to add your rating) but there are no stars. There are 3 fields in the KB_XMod_Index_VC400 table: gRatingPermission = "all", gShowRatings = "Yes" and ShowRating. The ShowRating field has 2 records: one's value is empty and the other's valuse is "Select". Any ideas as to why the rsting stars are not showing up?

The rating stars were included in the installation folder of the package you purchased.

They need to be uploaded to your portal root folder.

Please see step 4 in the following instructions.

Uploading Rating Images

http://training.dnnprofessor.com/BusinessDirectory/LearningLab61/Installation.aspx

Justin

Thanks for the reply. The files are where they are supposed to be and, with the following code, they are appearing now for the one rating that is already in the database:

[xmod:field name="Company" /] Overall Rating   [xmod:ratings location="xmod" fullimage="fullstar.gif" emptyimage="emptystar.gif" ratingscale="5" showrating="true" /]

But the following lines show the same same thing rather than allowing a new rating to be entered.

   [span](Click a star below to add your rating)[br /][/span]
[xmod:ratings location="xmod" fullimage="fullStar.gif" emptyimage="emptyStar.gif" ratingscale="5" allowratings="true" /]

test page is at:

http://atriptothezoo.com/Admin/TROTest/tabid/112/ctl/Detail/mid/559/xmid/251/xmfid/14/Default.aspx

Thanks for any help you can offer.

The rating system is built into XMod and referenced in the XMod Online help at http://dnndev.com/help/xmod/Content/Template_Tags/_xmod_ratings_.htm

Full Xmod online Help Reference - http://dnndev.com/help/xmod/default.htm

I believe what you are experiencing is the fact that you have already added a rating as a particular logged in user and the rating control will not allow you to add another rating as that user.

Since you have the page restricted to public access this could not be tested.

Try allowing all user access or log in as a different user and a new rating should now be allowed.

If you have additional questions about the Xmod rating system, you can also contact the XMod developer, Kelly Ford, at http://dnndev.zendesk.com/.