Gossamer Forum: Products: Gossamer Links: Discussions: Add review rating to link.html

Dec 15, 2005, 12:24 PM

MJB

Enthusiast (559 posts)

Dec 15, 2005, 12:24 PM

Post #1 of 5

Shortcut

Add review rating to link.html

I have added "Reviews: 0" to the "Ratings / Votes" count for each link (not detailed pages). How do I add "Reviews Rating: x" to the link?

Dec 15, 2005, 3:22 PM

afinlr

Veteran (1921 posts)

Dec 15, 2005, 3:22 PM

Post #2 of 5

Shortcut

Re: [MJB] Add review rating to link.html In reply to

You need a global for that I think.

Try this:
http://www.gossamer-threads.com/...i?post=233569#233569

Dec 16, 2005, 1:29 AM

MJB

Enthusiast (559 posts)

Dec 16, 2005, 1:29 AM

Post #3 of 5

Shortcut

Re: [afinlr] Add review rating to link.html In reply to

I tried the first global:

Code:
average_rating => sub { 
   my $id = shift; 
   my ($avg) = $DB->table('Reviews')->select( 'AVG(Review_Rating)', { Review_LinkID => $id })->fetchrow_array; 
   $avg ||= 0; 
   return sprintf("%.2f", $avg); 
 }

but it returns the message "Error: Variable 'average_rating' is not a code reference". What does that mean?

Dec 16, 2005, 2:04 AM

Andy

Veteran / Moderator (18441 posts)

Dec 16, 2005, 2:04 AM

Post #4 of 5

Shortcut

Re: [MJB] Add review rating to link.html In reply to

Erm, I'm assuming you have it setup as you posted =)

You need;

Global name: average_rating

Value:

Code:
sub {  
   my $id = shift;  
   my ($avg) = $DB->table('Reviews')->select( 'AVG(Review_Rating)', { Review_LinkID => $id })->fetchrow_array;  
   $avg ||= 0;  
   return sprintf("%.2f", $avg);  
 }

Cheers

Andy (mod)
andy@ultranerds.co.uk

Dec 16, 2005, 2:33 AM

MJB

Enthusiast (559 posts)

Dec 16, 2005, 2:33 AM

Post #5 of 5

Shortcut

Re: [Andy] Add review rating to link.html In reply to

Thanks.