0){ while($data = mysql_fetch_assoc($sel)){ $total = $total + $data['rating_num']; $rows++; } $perc = ($total/$rows) * 20; //$newPerc = round($perc/5)*5; //return $newPerc.'%'; $newPerc = round($perc,2); return $newPerc.'%'; } else { return '0%'; } } function outOfFive($id){ $total = 0; $rows = 0; $sel = mysql_query("SELECT rating_num FROM ratings WHERE rating_id = '$id'"); if(mysql_num_rows($sel) > 0){ while($data = mysql_fetch_assoc($sel)){ $total = $total + $data['rating_num']; $rows++; } $perc = ($total/$rows); return round($perc,2); //return round(($perc*2), 0)/2; // 3.5 } else { return '0'; } } function getVotes($id){ $sel = mysql_query("SELECT rating_num FROM ratings WHERE rating_id = '$id'"); $rows = mysql_num_rows($sel); if($rows == 0){ $votes = '0 Votes'; } else if($rows == 1){ $votes = '1 Vote'; } else { $votes = $rows.' Votes'; } return $votes; } function pullRating($id,$show5 = false, $showPerc = false, $showVotes = false, $static = NULL){ // Check if they have already voted... $text = ''; $sel = mysql_query("SELECT id FROM ratings WHERE IP = '".$_SERVER['REMOTE_ADDR']."' AND rating_id = '$id'"); if(mysql_num_rows($sel) > 0 || $static == 'novote' || isset($_COOKIE['has_voted_'.$id])){ if($show5 || $showPerc || $showVotes){ $text .= ''; } if($show5){ $text .= ''; } if($showPerc){ $text .= ''; } if($showVotes){ $text .= '('.getVotes($id).')'; } if($show5 || $showPerc || $showVotes){ $text .= ''; } return $text.'
'; } else { if($show5 || $showPerc || $showVotes){ $text .= ''; } if($show5){ $show5bool = 'true'; $text .= ''; } else { $show5bool = 'false'; } if($showPerc){ $showPercbool = 'true'; $text .= ''; } else { $showPercbool = 'false'; } if($showVotes){ $showVotesbool = 'true'; $text .= '('.getVotes($id).')'; } else { $showVotesbool = 'false'; } if($show5 || $showPerc || $showVotes){ $text .= ''; } return $text.'
'; } } // Added in version 1.5 // Fixed sort in version 1.7 function getTopRated($limit, $table, $idfield, $namefield){ $result = ''; $sql = "SELECT COUNT(ratings.id) as rates,ratings.rating_id,".$table.".".$namefield." as thenamefield,ROUND(AVG(ratings.rating_num),2) as rating FROM ratings,".$table." WHERE ".$table.".".$idfield." = ratings.rating_id GROUP BY rating_id ORDER BY rates DESC,rating DESC LIMIT ".$limit.""; $sel = mysql_query($sql); $result .= '
    '."\n"; while($data = @mysql_fetch_assoc($sel)){ $result .= '
  • '.$data['thenamefield'].' ('.$data['rating'].')
  • '."\n"; } $result .= '
'."\n"; return $result; }