Suche Votescript

<?php
$getNewsLikes = $mysqlCore->mysqlQuery("SELECT * FROM cms_news_likes WHERE news_id = '".$newsId."'");
$getLikes	  = $mysqlCore->mysqlQuery("SELECT COUNT(id) FROM cms_news_likes WHERE news_id = '".$newsId."' AND like_status = '1'");
$getDislikes  = $mysqlCore->mysqlQuery("SELECT COUNT(id) FROM cms_news_likes WHERE news_id = '".$newsId."' AND like_status = '0'");
$getAll		  = $mysqlCore->mysqlQuery("SELECT COUNT(id) FROM cms_news_likes WHERE news_id = '".$newsId."'");
$getUser	  = $mysqlCore->mysqlQuery("SELECT COUNT(id) FROM cms_news_likes WHERE news_id = '".$newsId."' AND username = '".$userCore->username."'");


$usernameCheck = mysql_fetch_array($getUser);
$getNewsLikes  = mysql_fetch_assoc($getNewsLikes);
$getLikes	   = mysql_fetch_array($getLikes);
$getDislikes   = mysql_fetch_array($getDislikes);
$getAll		   = mysql_fetch_array($getAll);


$rechnung			= 100/$getAll[0];
$like_berechnung    = $rechnung*$getLikes[0];
$dislike_berechnung = $rechnung*$getDislikes[0];


if(isset($_GET['like']))
{
	$likeStatus = $siteCore->htmlEscape($_GET['like']);
	if ($likeStatus == 'true')
	{
		$mysqlCore->mysqlQuery("INSERT INTO `cms_news_likes` (username,like_status,news_id) VALUES ('".$userCore->username."', '1', '".$newsId."')");
		header("Location: intern.php?do=news&&id=".$newsId."");
	}
	elseif ($likeStatus == 'false')
	{
		$mysqlCore->mysqlQuery("INSERT INTO `cms_news_likes` (username,like_status,news_id) VALUES ('".$userCore->username."', '0', '".$newsId."')");
	    header("Location: intern.php?do=news&&id=".$newsId."");
	}
}
?>