Knowledgebase
View categorized listing of all common frequently asked questions.
Video Tutorials (jReviews 2.0)
Create a Movie & TV Show review website.
Customize the jReviews themes.
Review user profiles with the Everywhere addon.
Forum
Community forum
Submit a Ticket
Use your client area email to access the ticket system.
Downloads
Guides, modules and more...
Reviews Ahoy!

Extensions we recommend

CSV Import for Joomla and jReviews
 
Welcome, Guest. Please login or register.
Did you miss your activation email?
December 01, 2008, 09:58:02 PM
 21662 Posts in 4948 Topics by 2838 Members
Latest Member: davidkan
News: Do not post any jReviews files or large amounts of code in the forums please. Only template files and code are allowed.
 
jReviews Support Forum  |  jReviews 1.x - jReviews Modules and Hook Components  |  Modules & bots  |  Dashboard help show the top 5 user rated products « previous next »
Pages: [1]
Author Topic: Dashboard help show the top 5 user rated products  (Read 787 times)
axelman
Newbie
*
Offline Offline

Posts: 14
« on: February 20, 2008, 10:12:55 AM »
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  Huh

Thanks in advanced for your kind help
« Last Edit: February 20, 2008, 10:25:17 AM by axelman » Logged
Alejandro
Global Moderator
Administrator
Hero Member
*****
Offline Offline

Posts: 8593
« Reply #1 on: February 20, 2008, 12:03:20 PM »
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
Logged
Please take the time to vote and to write a review: http://extensions.joomla.org
Reviews Ahoy! - Submit your jReviews site here.
axelman
Newbie
*
Offline Offline

Posts: 14
« Reply #2 on: February 20, 2008, 08:53:35 PM »
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 Huh?

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

What am I doing wrong?Huh

Thanks in advanced
Logged
Alejandro
Global Moderator
Administrator
Hero Member
*****
Offline Offline

Posts: 8593
« Reply #3 on: February 20, 2008, 09:14:31 PM »
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
Logged
Please take the time to vote and to write a review: http://extensions.joomla.org
Reviews Ahoy! - Submit your jReviews site here.
axelman
Newbie
*
Offline Offline

Posts: 14
« Reply #4 on: February 20, 2008, 10:43:09 PM »
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!
Logged
Alejandro
Global Moderator
Administrator
Hero Member
*****
Offline Offline

Posts: 8593
« Reply #5 on: February 21, 2008, 07:16:44 AM »
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.
Logged
Please take the time to vote and to write a review: http://extensions.joomla.org
Reviews Ahoy! - Submit your jReviews site here.
axelman
Newbie
*
Offline Offline

Posts: 14
« Reply #6 on: February 21, 2008, 01:52:49 PM »
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
Logged
Pages: [1]
« previous next »
    Jump to:  


    Powered by MySQL Powered by PHP Powered by SMF 1.1.7 | SMF © 2006-2008, Simple Machines LLC
    Joomla Bridge by JoomlaHacks.com     		Valid XHTML 1.0! Valid CSS!