addLocale("homes.widget.rating"); $ownerid = $input->FilterText($_GET['ownerId']); $widgetid = $input->FilterText($_GET['ratingId']); $rate = $input->FilterText($_GET['givenRate']); } if(is_numeric($ownerid) && is_numeric($widgetid) && is_numeric($rate)){ $myvote = $db->result($db->query("SELECT COUNT(*) FROM ".PREFIX."ratings WHERE raterid = '".$user->id."' AND userid = '".$ownerid."'")); if($myvote < 1 && $ownerid != $user->id && $rate > 0 && $rate < 6){ $db->query("INSERT INTO ".PREFIX."ratings (userid,rating,raterid) VALUES ('".$ownerid."','".$rate."','".$user->id."')"); } } $totalvotes = $db->result($db->query("SELECT COUNT(*) FROM ".PREFIX."ratings WHERE userid = '".$ownerid."'")); $highvotes = $db->result($db->query("SELECT COUNT(*) FROM ".PREFIX."ratings WHERE userid = '".$ownerid."' AND rating > 3")); $votestally = $db->result($db->query("SELECT SUM(rating) FROM ".PREFIX."ratings WHERE userid = '".$ownerid."'")); $x = $totalvotes; if($x == 0){ $x = 1; } $average = round($votestally / $x, 1); $px = ceil(($average * 150) / 5); ?>
loc['average.rating']; ?>:
loc['votes.total']; ?>
( loc['high.votes.total']; ?>)