Página de noticia

<?php
#####################################################################
#||||| hPCMS r1 - Desenvolvida por nadi0s                      |||||#
#||||| Criado por nadi0s - HTML, PHP, CSS                      |||||#
#||||| Based in RevCMS and UberCMS. @rTiago por HK.            |||||#
# ||| --------------------------------------------------------- ||| #
#||||| © Copyright 2012. UberCMS/LavvosCMS/UberCMS - Estrutura |||||#
#||||| © Copyright 2012. Sulake Corporation - Habbo Arquivos   |||||#
#####################################################################

require_once('./inc/hotel_core.php');
require_once('./inc/hotel_session.php');

$body_id = "news";
$pageid = "1300";

$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 //


require_once('./templates/community_subheader.php');
require_once('./templates/community_header.php');

?>

<div id="container">
<div id="content">
<div id="column1" 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']."\">"; } ?>
	<img src="/web-gallery/v2/images/setanew.png" alt="" width="12" height="10" />
<?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 id="column2" class="column">
<div class="habblet-container ">
<div class="cbb clearfix notitle ">

<div id="article-wrapper">
	<h2><?php echo HoloText($news['title']); ?></h2>
	<div class="article-meta">Publicado em <?php echo date('d/m/Y', $news['published']); ?> </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 style="border:#ccc 1px dotted;" />
<div style="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"><input name='gostei' type='submit' value='Gostei' style='color:#999999; border-left:1px solid #999999; border-right:1px solid #999999; border-top:1px solid #999999; border-bottom:3px solid #CCCCCC; padding:5px; background-color:#FFFFFF;' /></a>
			<a href="<?php echo $path; ?>/articles/<?php echo $news_id; ?>&vote=unlike"><input name='ngostei' type='submit' value='N&atilde;o Gostei' style='color:#999999; border-left:1px solid #999999; border-right:1px solid #999999; border-top:1px solid #999999; border-bottom:3px solid #CCCCCC; padding:5px; background-color:#FFFFFF;' /></a><?php } ?>

		<!-- RESULTADOS -->
		<p><span style="color: #008000; font-size: small;"><?php echo $like; ?> <span style="color: #000000;">pessoas gostaram da not&iacute;cia.<br /></span></span><span style="color: #ff0000; font-size: small;"><?php echo $unlike; ?> </span><span style="font-size: small;">pessoas n&atilde;o gostaram da not&iacute;cia.
</span></p>
<script>alert(\"Obrigado por votar nesta notícia, assim poderemos saber se realmente você gostou :-)\");</script>

		<!-- FIM SISTEMA DE CURTIDAS -->
</div>



		</div>

</div></div>


</div>
</div>


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


</div>

<div id="column3" class="column">
<?php require_once('./templates/community_ads.php'); ?>
</div>

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