function rating_bar($id, $units = '', $static = '')
{
$productrating = new productrating();
$id = (int) $id;
$units = (int) $units;
require '_config-rating.php';
// get the db connection info
//set some variables
$ip = $_SERVER['REMOTE_ADDR'];
if (!$units) {
$units = 10;
}
if (!$static) {
$static = false;
}
// get votes, values, ips for the current rating bar
$query = mysql_query("SELECT `total_votes`, `total_value`, `used_ips` FROM `{$rating_dbname}`.`{$rating_tableName}` WHERE `id` = '{$id}'") or die(" Error: " . mysql_error());
// insert the id in the DB if it doesn't exist already
// see: http://www.masugadesign.com/the-lab/scripts/unobtrusive-ajax-star-rating-bar/#comment-121
if (mysql_num_rows($query) == 0) {
$sql = "INSERT INTO `{$rating_dbname}`.`{$rating_tableName}` (`id`,`total_votes`, `total_value`, `used_ips`) VALUES ('{$id}', '0', '0', '')";
$result = mysql_query($sql);
}
$numbers = mysql_fetch_assoc($query);
if ($numbers['total_votes'] < 1) {
$count = 0;
} else {
$count = $numbers['total_votes'];
}
// how many votes total
$current_rating = $numbers['total_value'];
// total number of rating added together and stored
$tense = $count == 1 ? $productrating->traduz('vote') : $productrating->traduz('votes');
//plural form votes/vote
// determine whether the user has voted, so we know how to draw the ul/li
$voted = mysql_num_rows(mysql_query("SELECT `used_ips` FROM `{$rating_dbname}`.`{$rating_tableName}` WHERE `used_ips` LIKE '%" . $ip . "%' AND `id` = '" . $id . "'"));
// now draw the rating bar
$rating_width = @number_format($current_rating / $count, 2) * $rating_unitwidth;
$rating1 = @number_format($current_rating / $count, 1);
$rating2 = @number_format($current_rating / $count, 2);
if ($static == 'static') {
$static_rater = array();
$static_rater[] .= "\n" . '<div class="ratingblock"><h7>Đánh giá:</h7>';
$static_rater[] .= '<div id="unit_long' . $id . '">';
$static_rater[] .= '</div>';
$static_rater[] .= '</div>' . "\n\n";
return join("\n", $static_rater);
} else {
$rater = '';
$rater .= '<div class="ratingblock">';
$rater .= '<div id="unit_long' . $id . '"><h7>Đánh giá:</h7>';
$rater .= '<ul id="unit_ul' . $id . '" class="unit-rating" style="width: ' . $rating_unitwidth * $units . 'px;">';
$rater .= '<li class="current-rating" style="width: ' . $rating_width . 'px;">Currently ' . $rating2 . '/' . $units . '</li>';
for ($ncount = 1; $ncount <= $units; $ncount++) {
// loop from 1 to the number of units
if (!$voted) {
// if the user hasn't yet voted, draw the voting stars
$rater .= '<li><a href="' . $ps_base_url . 'modules/productrating/rating/db.php?j=' . $ncount . '&q=' . $id . '&t=' . $ip . '&c=' . $units . '" title="' . $productrating->traduz('Give your rating now') . ': ' . $ncount . ' ' . $productrating->traduz('out of') . ' ' . $units . '" class="r' . $ncount . '-unit rater" rel="nofollow">' . $ncount . '</a></li>';
}
}
$ncount = 0;
// resets the count
$rater .= '</ul>';
$rater .= '</div>';
$rater .= '</div>';
return $rater;
}
}
Last Mod: Mar 18 2007
This page handles the database update if the user
does NOT have Javascript enabled.
---------------------------------------------------------
ryan masuga, masugadesign.com
ryan@masugadesign.com
Licensed under a Creative Commons Attribution 3.0 License.
http://creativecommons.org/licenses/by/3.0/
See credits.txt for full credit details.
--------------------------------------------------------- */
header("Cache-Control: no-cache");
header("Pragma: nocache");
require dirname(dirname(dirname(dirname(__FILE__)))) . '/config/config.inc.php';
require dirname(dirname(__FILE__)) . '/productrating.php';
require '_config-rating.php';
$productrating = new productrating();
//getting the values
$vote_sent = preg_replace('/[^0-9]/', '', $_REQUEST['j']);
$vote_sent = (int) $vote_sent;
$id_sent = preg_replace('/[^0-9a-zA-Z]/', '', $_REQUEST['q']);
$id_sent = (int) $id_sent;
$ip_num = preg_replace('/[^0-9\\.]/', '', $_REQUEST['t']);
$units = preg_replace('/[^0-9]/', '', $_REQUEST['c']);
$units = (int) $units;
$ip = $_SERVER['REMOTE_ADDR'];
$referer = $_SERVER['HTTP_REFERER'];
// kill the script because normal users will never see this.
if ($vote_sent > $units) {
die('Sorry, vote appears to be invalid.');
}
//connecting to the database to get some information
Last Mod: Mar 18 2007
This page handles the 'AJAX' type response if the user
has Javascript enabled.
---------------------------------------------------------
ryan masuga, masugadesign.com
ryan@masugadesign.com
Licensed under a Creative Commons Attribution 3.0 License.
http://creativecommons.org/licenses/by/3.0/
See credits.txt for full credit details.
--------------------------------------------------------- */
header("Cache-Control: no-cache");
header("Pragma: nocache");
require dirname(dirname(dirname(dirname(__FILE__)))) . '/config/config.inc.php';
require dirname(dirname(__FILE__)) . '/productrating.php';
require '_config-rating.php';
$productrating = new productrating();
//getting the values
$vote_sent = preg_replace('/[^0-9]/', '', $_REQUEST['j']);
$vote_sent = (int) $vote_sent;
$id_sent = preg_replace('/[^0-9a-zA-Z]/', '', $_REQUEST['q']);
$id_sent = (int) $id_sent;
$ip_num = preg_replace('/[^0-9\\.]/', '', $_REQUEST['t']);
$units = preg_replace('/[^0-9]/', '', $_REQUEST['c']);
$units = (int) $units;
$ip = $_SERVER['REMOTE_ADDR'];
// kill the script because normal users will never see this.
if ($vote_sent > $units) {
die('Sorry, vote appears to be invalid.');
}
//connecting to the database to get some information
$query = mysql_query("SELECT `total_votes`, `total_value`, `used_ips` FROM `{$rating_dbname}`.`{$rating_tableName}` WHERE `id` = '{$id_sent}'") or die("Error: " . mysql_error());
