<?php
include ('settings.php');
error_reporting(E_ERROR | E_WARNING | E_PARSE);
require_once ('languages/lang_'.$langs.'.php');
$rating = (int)$_POST['rating'];
$id = (int)$_POST['id'];
if(isset($_COOKIE['rated'.$id])) {
	echo "<div style='width:100px;float:left;background:#FFF5C3;font-family: Arial, sans-serif;font-size:14px;position:relative;top:0px;left:2px;'>$lang[VOTE1]</div>";
} else {
	$arecordSet = &$conn->Execute('SELECT * FROM newser WHERE blogid = ? LIMIT 1', array($id));
	if(!$arecordSet)
		print $conn->ErrorMsg();
	else
		while(!$arecordSet->EOF) {
			if($rating > 5 || $rating < 1) {
				echo "Rating can't be below 1 or more than 5";
			}
			setcookie("rated".$id,$id,time() + 60 * 60 * 24 * 365);
			$total_ratings = $arecordSet->fields['total_ratings'];
			$total_rating = $arecordSet->fields['total_rating'];
			$current_rating = $arecordSet->fields['rating'];
			$new_total_rating = $total_rating + $rating;
			$new_total_ratings = $total_ratings + 1;
			$new_rating = $new_total_rating / $new_total_ratings;
$sql = $conn->Prepare('UPDATE newser SET total_rating = ? WHERE blogid = ?');
if($conn->Execute($sql,array($new_total_rating,$id)) === false) {
		print '<br /><div id="error">error inserting[1]: '.$conn->ErrorMsg().'</div><br />';
}
$sql2 = $conn->Prepare('UPDATE newser SET rating = ? WHERE blogid = ?');
if($conn->Execute($sql2,array($new_rating,$id)) === false) {
		print '<br /><div id="error">error inserting[1]: '.$conn->ErrorMsg().'</div><br />';
}
$sql3 = $conn->Prepare('UPDATE newser SET total_ratings = ? WHERE blogid = ?');
if($conn->Execute($sql3,array($new_total_ratings,$id)) === false) {
		print '<br /><div id="error">error inserting[1]: '.$conn->ErrorMsg().'</div><br />';
}
				echo "<div style='width:100px;float:left;background:#FFF5C3;font-family: Arial, sans-serif;font-size:14px;position:relative;top:0px;left:2px;'>$lang[VOTE2]</div>";
				$arecordSet->MoveNext();
			}
		}
$conn->Close();
######################################
##send.php                    4.1.4.##
######################################
?>