jReviews Support Forum

Hi everybody,

I'm new to Jreviews Dashboard module can you help me set it up so it will show the top 5 user rated products, where the query goes, which tables and fiels do I use, sorry if this seems s*#%&id but so farm I'm stuck  ???

Thanks in advanced for your kind help

There's no query, no tables and no fields involved. You install the module and change the settings.

http://demo.reviewsforjoomla.com/administrator/index2.php?option=com_modules&client=&task=editA&hidemainmenu=1&id=52

Hi Alejandro,

Wow this really rocks in your site and looks great!! but in my site I still can get it to function.

Did exactly as your demo but still getting a message  "No entries were found" I'm using virtuamart and Jreviews everywhere, both are functioning  correctly I think as I can add reviews and ratings to my products, but the top user rated just don't show, for every category in virtuamart do i need to create a category in Jreviews Categories Manager ????

I've created a category Products, section Products and assigned the criteria Products to the category.

What am I doing wrong????

Thanks in advanced

Please update your forum email so it matches the client area email. It's a requirement of this forum.

The dashboard only works with regular content, not JRE. The closest thing to it is this module (http://support.reviewsforjoomla.com/index.php?_m=downloads&_a=viewdownload&downloaditemid=3&nav=0,3)

OK I'm going  to try the module, but is there a way to create a query joining the virtuamart products table and some table where Jreviews  stores the rating value? after all I want to display the top 5 user rated products.

I've checked both profiles forum and client area both emails are the same, please advise.

Thank you so much for your quick answer to my post, keep up the good work!

The virtuemart-jreviews module I pointed you to has the queries you need. Just open the php file and search for jreviews to find the queries. The dashboard also has the queries. The reference to the virtuemart product id is in jreviews_comments, column pid. There's also a column on that table, I think "mode" with the component name com_virtuemart in your case. The rating info is stored in jreviews_ratings. Look at the code.

Thank you so much Alejandro, I'm not a developer but I'm trying to learn so the people I hire don't try to scam me, your components and the support you give are excellent the best I've seen so far regarding Joomla components.

Thanks