Hablamos Español

Support Center

Knowledgebase
View categorized listing of all common frequently asked questions.
Video Tutorials
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...
Changelog

Sites using jReviews

Reviews Ahoy!

Friendly Sites

 
Welcome, Guest. Please login or register.
Did you miss your activation email?
January 09, 2009, 09:34:00 AM
 22880 Posts in 5237 Topics by 2978 Members
Latest Member: mini_me
News: Use your client area email when you sign up to the forum so we can identify you as a trial or licensed user. Otherwise we may not answer your questions.
 
jReviews Support Forum  |  jReviews 1.x  |  Tips & tricks  |  Change the ordering of users in the Review Rank list « previous next »
Pages: [1]
Author Topic: Change the ordering of users in the Review Rank list  (Read 1328 times)
andreasa
Hero Member
*****
Offline Offline

Posts: 271



WWW
« on: July 03, 2007, 07:52:00 AM »
Hi!

I would like show the reviewrank ordered by number of voting, could you please help me?
Thank you!

Andrea
« Last Edit: July 03, 2007, 10:40:33 AM by Alejandro » Logged
Alejandro
Global Moderator
Administrator
Hero Member
*****
Offline Offline

Posts: 9032
« Reply #1 on: July 03, 2007, 10:39:20 AM »
Not really a template question  Shocked

In jreviews.php, function reviewRank

reviewRank:

Code:
<?php
// rank algorithm
 $query = "SELECT userid, name, username, count(userid) as reviews,"
  ."\n sum(yes)/(sum(yes)+sum(no)) as helpful,(sum(yes)+sum(no)) AS vote_count,"
  ."\n (count(id)*(sum(yes)/(sum(yes)+sum(no)))) is null AS vote_null"
  ."\n FROM #__jreviews_comments AS a"
  ."\n LEFT JOIN #__jreviews_votes AS b ON a.id = b.reviewid"
  ."\n WHERE published = 1 AND userid > 0"
  ."\n GROUP BY userid"
  ."\n ORDER BY vote_count DESC, reviews DESC, helpful DESC, vote_null ASC"
  ."\n LIMIT $limitstart, $limit"
  ;
?>
Logged
Reviews Ahoy! - Submit your jReviews site here.
andreasa
Hero Member
*****
Offline Offline

Posts: 271



WWW
« Reply #2 on: July 03, 2007, 11:01:09 AM »
Perfect, like always....  Smiley

And now...  Grin
how to show the # in the page....
I inserted {VOTE_COUNT} in the template but seems don't work.

Thank you
Logged
Alejandro
Global Moderator
Administrator
Hero Member
*****
Offline Offline

Posts: 9032
« Reply #3 on: July 03, 2007, 11:09:50 AM »
Code:
<?php
                                              $tmpl->addVars( "row", array (
 "helpful"=>(($row->helpful)*100)."%",
 "vote_null"=>$row->vote_null,
                                                                        "vote_count"=>$row->vote_count
 )
 );
?>
Logged
Reviews Ahoy! - Submit your jReviews site here.
andreasa
Hero Member
*****
Offline Offline

Posts: 271



WWW
« Reply #4 on: July 03, 2007, 11:15:48 AM »
wonderful!

Thank you very much.
Logged
andreasa
Hero Member
*****
Offline Offline

Posts: 271



WWW
« Reply #5 on: July 06, 2007, 01:42:34 PM »
Ok, I changed my list views... but now I have an additional problem  Grin...  the link showed in the content page, don't reflect the new rank...

I mean this:

"#1 Reviewer"
"Top 10 Reviewer"
"Top 50 Reviewer"
"Top 100 Reviewer"
"Top 500 Reviewer"
"Top 1000 Reviewer"

Thank you  Smiley
Logged
Alejandro
Global Moderator
Administrator
Hero Member
*****
Offline Offline

Posts: 9032
« Reply #6 on: July 06, 2007, 01:51:47 PM »
You have to make similar changes to jreviews.common.php, function getRankList
Logged
Reviews Ahoy! - Submit your jReviews site here.
andreasa
Hero Member
*****
Offline Offline

Posts: 271



WWW
« Reply #7 on: July 06, 2007, 02:25:08 PM »
Yes!

Ciao
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!