Miscellany

<?php/*Page:           _drawrating.phpCreated:        Aug 2006Last Mod:       Mar 11 2007The function that draws the rating bar.--------------------------------------------------------- ryan masuga, masugadesign.comryan@masugadesign.com --------------------------------------------------------- */function rating_bar($id,$units='',$static='') { require('_config-rating.php'); // get the db connection info	//set some variables$ip = $_SERVER['REMOTE_ADDR'];if (!$units) {$units = 10;}if (!$static) {$static = FALSE;}$query=mysql_query("SELECT total_votes, total_value, used_ips FROM $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-121if (mysql_num_rows($query) == 0) {$sql = "INSERT INTO $tableName (`id`,`total_votes`, `total_value`, `used_ips`) VALUES ('$id', '0', '0', '')";$result = mysql_query($sql);}$numbers=mysql_fetch_assoc($query);$count=$numbers['total_votes']; //how many votes total$current_rating=$numbers['total_value']; //total number of rating added together and stored$tense=($count==1) ? "vote" : "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 $tableName WHERE used_ips LIKE '%".$ip."%' AND id='".$id."' ")); // now draw the rating bar$rating_width = @number_format($current_rating/$count,2)*$unitwidth;$rating1 = @number_format($current_rating/$count,1);$rating2 = @number_format($current_rating/$count,2);if ($static == 'static') {$static_rater = '';$static_rater .= '<div class="ratingblock">';$static_rater .= '<div id="unit_long'.$id.'">';$static_rater .= '<ul id="unit_ul'.$id.'" class="unit-rating" style="width:'.$unitwidth*$units.'px;">';$static_rater .= '<li class="current-rating" style="width:'.$rating_width.'px;">Currently '.$rating2.'/'.$units.'</li>';$static_rater .= '</ul>';echo $static_rater;?>		<p class="static"><?php echo $id ?>. Rating: <strong> <?php echo $rating1 ?></strong>/<?php echo $units ?> (<?php echo $count ?> <?php echo $tense ?> cast) <em>This is 'static'.</em>		</p></div></div><?php} else {?><div class="ratingblock"><div id="unit_long<?php echo $id ?>">		<ul id="unit_ul<?php echo $id ?>" class="unit-rating" style="width:<?php echo $unitwidth*$units; ?>px;">		<li class="current-rating" style="width:<?php echo $rating_width; ?>px;">Currently <?php echo $rating2; ?>/<?php echo $units ?></li><?php	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 		?><li><a href="db.php?j=<?php echo $ncount ?>&amp;q=<?php echo $id ?>&amp;t=<?php echo $ip ?>&amp;c=<?php echo $units ?>" title="<?php echo $ncount ?> out of <?php echo $units ?>" class="r<?php echo $ncount ?>-unit rater" rel="nofollow"><?php echo $ncount ?></a></li><?php	 }   }	$ncount=0; // resets the count?>		</ul>		<p<?php if($voted){?> class="voted"<?php } ?> ><?php echo $id; ?>. Rating: <strong> <?php echo $rating1; ?></strong>/<?php echo $units ?> (<?php echo $count ?> <?php echo $tense ?> cast)		</p></div></div><?}}?>