Sistema gostei e não gostei nas notícias.

<?php

require_once('./data_classes/server-data.php_data_classes-core.php.php');
require_once('./data_classes/server-data.php_data_classes-session.php.php');

$body_id = "news";
$pageid = "11";

$news_id = FilterText($_GET['web-articles-id']);
$main_sql = mysql_query("SELECT * FROM cms_news WHERE id = '".$news_id."'") or die(mysql_error());
$article_exists = mysql_num_rows($main_sql);

if($article_exists == "1"){
 $news = mysql_fetch_assoc($main_sql);
 $pagename = "Noticias - ".HoloText($news['title'])."";
} else {
 $main_sql = mysql_query("SELECT * FROM cms_news ORDER BY ID DESC") or die(mysql_error());
 $news = mysql_fetch_assoc($main_sql);
 $news_id = $news['id'];
 $pagename = "Notícias - ".HoloText($news['title'])."";
}

 //SISTEMA DE VOTAÇÃO INICIA AQUI 
if(isset($_GET['vote']) || FilterText($_GET['vote']) == "like" || FilterText($_GET['vote']) == "unlike"){
 $vote = FilterText($_GET['vote']);

 $usercheck = mysql_query("SELECT id_user FROM cms_news_vote WHERE id_user = '".$my_id."' AND id_news = '".$news_id."'") or die(mysql_error());
 if(mysql_num_rows($usercheck) < 1){

 if($vote == "like"){
 mysql_query("INSERT INTO `cms_news_vote` (id_user,id_news,vote_like,vote_unlike) VALUES ('".$my_id."','".$news_id."','1','0')") or die(mysql_error());
 } else {
 mysql_query("INSERT INTO `cms_news_vote` (id_user,id_news,vote_like,vote_unlike) VALUES ('".$my_id."','".$news_id."','0','1')") or die(mysql_error());
 }

 header("location: $path/articles/".$news_id."");
 } else {
 $msg = "<script>alert(\"Obrigado por votar nesta notícia, assim poderemos saber se realmente você gostou :-) \");</script>";
 }
}

$images = explode(",",$news['images']);

if(isset($_GET['vote']) || FilterText($_GET['vote']) == "like" || FilterText($_GET['vote']) == "unlike"){
 $vote = FilterText($_GET['vote']);

 $usercheck = mysql_query("SELECT id_user FROM cms_news_vote WHERE id_user = '".$my_id."' AND id_news = '".$news_id."'") or die(mysql_error());
 if(mysql_num_rows($usercheck) < 1){

 if($vote == "like"){
 mysql_query("INSERT INTO `cms_news_vote` (id_user,id_news,vote_like,vote_unlike) VALUES ('".$my_id."','".$news_id."','1','0')") or die(mysql_error());
 } else {
 mysql_query("INSERT INTO `cms_news_vote` (id_user,id_news,vote_like,vote_unlike) VALUES ('".$my_id."','".$news_id."','0','1')") or die(mysql_error());
 }

 header("location: $path/articles/".$news_id."");
 } else {
 $msg = "<script>alert(\"Você já votou nesta notícia!\");</script>";
 }
}

 // TERMINA AQUI //

?>

<?php require_once('./templates/community_subheader.php'); ?>
<?php require_once('./includes/header.php'); ?>

<div id="container">
<div id="content">
<div id="column1" class="column">
<div class="habblet-container ">
<div class="cbb clearfix notitle ">

<div id="article-wrapper">
 <h2><?php echo HoloText($news['title']); ?><img src="https://i.imgur.com/9mnzRx6.gif" sttyle="float: right;"></h2>
 <div class="article-meta">Publicado em <?php echo date('d/m/Y', $news['published']); ?> <a href="articles/category/<?php echo $shortname; ?>"><?php echo $shortname; ?></a></div>

<script type="text/javascript" language="Javascript"> 
 document.observe("dom:loaded", function() {
 $$('.article-images a').each(function(a) {
 Event.observe(a, 'click', function(e) {
 Event.stop(e);
 Overlay.lightbox(a.href, "Carregando imagem...");
 });
 });
 
$$('<?php echo $row['id']; ?>').each(function(a) {
 a.replace(a.innerHTML);
 });
 });
 </script> 

 <p class="summary"><?php echo (HoloText($news['longstory'])); ?></p>
 <div class="article-body">
 <p><?php echo (HoloText($news['shortstory'], true)); ?></p>
 <div class="article-body"><b><?php echo $news['author']; ?></b><br>
 
</div>
 <!-- SISTEMA DE CURTIDAS -->

<hr sttyle="border:#ccc 1px dotted;" />
<div sttyle="background-color:#F5F5F5; border:1px solid #E9E9E9; padding:5px; border-radius:5px;">

<?php if(mysql_num_rows($usercheck = mysql_query("SELECT id_user FROM cms_news_vote WHERE id_user = '".$my_id."' AND id_news = '".$news_id."'")) < 1){ ?>
<?php } ?>
<?php if(mysql_num_rows($usercheck = mysql_query("SELECT id_user FROM cms_news_vote WHERE id_user = '".$my_id."' AND id_news = '".$news_id."'")) < 1){ ?>
 
<a href="<?php echo $path; ?>/articles/<?php echo $news_id; ?>&vote=like"><img src="https://i.imgur.com/gD2SDJV.png"></a>
 <a href="<?php echo $path; ?>/articles/<?php echo $news_id; ?>&vote=unlike"><img src="https://i.imgur.com/jsk5m0p.png"></a><?php } ?>
 
<!-- RESULTADOS -->
 <p><span sttyle="color: #008000; font-size: small;"><?php echo $like; ?> <span sttyle="color: #000000;">Pessoas gostaram da notícia.<br /></span></span><span sttyle="color: #ff0000; font-size: small;"><?php echo $unlike; ?> </span><span sttyle="font-size: small;">Pessoas não gostaram da notícia.
</span></p>
<script>alert(\"Obrigado por votar nesta notícia, assim poderemos saber se realmente você gostou :-)\");</script>
 
<!-- FIM SISTEMA DE CURTIDAS -->
</div>
 
    <hr sttyle="border:#ccc 1px dotted;" />
 
</div>
</div>
</div>
</div>
</div>
<div id="column2" class="column">
<div class="habblet-container ">
<div class="cbb clearfix blue">
 <h2 class="title">Notícias</h2>
<div id="article-archive">
<?php

if ($news_id > 0)
{
 for ($i = 0; $i < 7; $i++)
 {
 $sectionName = "";
 $sectionCutoffMax = 0;
 $sectionCutoffMin = 0;
 
switch ($i)
 {
 case 0:
 
$sectionName = "Hoje";
 $sectionCutoffMax = time();
 $sectionCutoffMin = time() - 86400;
 break;
 
case 1:
 
$sectionName = "Ontem";
 $sectionCutoffMax = time() - 86400;
 $sectionCutoffMin = time() - 172800;
 break;
 
case 2: 
 
$sectionName = "Essa Semana";
 $sectionCutoffMax = time() - 172800;
 $sectionCutoffMin = time() - 604800;
 break;
 
case 3:
 
$sectionName = "Semana Passada";
 $sectionCutoffMax = time() - 604800;
 $sectionCutoffMin = time() - 1209600;
 break;
 
case 4:
 
$sectionName = "Esse Mês";
 $sectionCutoffMax = time() - 1209600;
 $sectionCutoffMin = time() - 2592000;
 break;
 
case 5:
 
$sectionName = "Mês Passado";
 $sectionCutoffMax = time() - 2592000;
 $sectionCutoffMin = time() - 5184000;
 break;
               

            case 6:
 
$sectionName = "Outros Meses";
 $sectionCutoffMax = time() - 3592000;
 $sectionCutoffMin = time() - 5684000;
 break;

 }

 $sql = mysql_query("SELECT * FROM cms_news WHERE published >= " . $sectionCutoffMin . " AND published <= " . $sectionCutoffMax .  " ORDER BY published DESC"); 
 if(mysql_num_rows($sql) > 0){
?>

 <?php echo "<h2>"; echo $sectionName; echo "</h2><ul>"; ?>
<?php while($row = mysql_fetch_assoc($sql)){ ?>
 <li><?php if($news_id !== $row['id']){ echo"<a href=\"".$path."/articles/".$row['id']."\">"; } ?>
 <?php echo $row['title']; ?> »</a> 
 <?php if($news_id !== $row['id']){ echo"</a>"; } ?></li>
 
<?php } ?>

</ul>

<?php } } } ?>

<ul>
 <li>
 <a href="<?php echo $path; ?>/articles/" class="article">Mais Notícias »</a>
 </li>
</ul>
</div>

</div>
</div>
<script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script>
</div>

<?php
 $votecheck = mysql_query("SELECT * FROM cms_news_vote WHERE id_news = '".$news_id."'");
 $votecount = mysql_num_rows($votecheck);
 if($votecount < 1){
 $percentlike = "50";
 $percentunlike = "50";
 $like = "0";
 $unlike = "0";
 } else {
 $percentlike = 100 / $votecount * mysql_evaluate("SELECT COUNT(*) FROM cms_news_vote WHERE id_news = '".$news_id."' AND vote_like = '1'");
 $percentunlike = 100 / $votecount * mysql_evaluate("SELECT COUNT(*) FROM cms_news_vote WHERE id_news = '".$news_id."' AND vote_unlike = '1'");
 $like = mysql_evaluate("SELECT COUNT(*) FROM cms_news_vote WHERE id_news = '".$news_id."' AND vote_like = '1'");
 $unlike = mysql_evaluate("SELECT COUNT(*) FROM cms_news_vote WHERE id_news = '".$news_id."' AND vote_unlike = '1'");
 }
 ?>



</div></div>
 
</div>
</div>


<script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script>
</div>
</div>

<?php require_once('./templates/community_footer.php'); ?>