rating_rev_stats bug
Posted: 17 April 2008 11:53 AM   [ Ignore ]
Newbie
Rank
Total Posts:  4
Joined  2008-01-23

in mod.rating.php

In function rating_rev_stats

find:

$query  $DB->query"SELECT rating_rev_r, COUNT(rating_rev_r) AS count FROM exp_rating_rev WHERE rating_id = '$rating_id' AND status = 'o' GROUP BY rating_rev_r" );

replace with:

$query  $DB->query"SELECT rating_rev_r, COUNT(rating_rev_r) AS count FROM exp_rating_rev WHERE rating_id = '$rating_id' AND status = 'open' GROUP BY rating_rev_r" );

otherwise mysql will always return with 0 results.

Profile
 
 
Posted: 18 April 2008 05:56 AM   [ Ignore ]   [ # 1 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  3350
Joined  2006-10-18

Thank you nVaux…

I’ll get this queued up smile

 Signature 
Profile