How to fix news revcms morningstar database?

nateforever96

Member
Apr 11, 2021
59
21
You must be registered for see images attach

Post automatically merged:

<!DOCTYPE html>
<?php require_once('includes/checktheban.php'); ?>
<html lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<title>{hotelName} - News Articles</title>

<link rel="stylesheet" href="{url}/app/tpl/skins/Habbo/styles/common.css" type="text/css">
<script type="text/javascript" src="{url}/app/tpl/skins/Habbo/js/libs2.js"></script>
<script type="text/javascript" src="{url}/app/tpl/skins/Habbo/js/visual.js"></script>
<script type="text/javascript" src="{url}/app/tpl/skins/Habbo/js/libs.js"></script>
<script type="text/javascript" src="{url}/app/tpl/skins/Habbo/js/common.js"></script>
<script type="text/javascript" src="{url}/app/tpl/skins/Habbo/js/fullcontent.js"></script>

<style type="text/css">input[type="text"],input[type="password"]{background-color:#F1F1F1;border:1px solid #999999;width:175px;padding:5px;font-family:verdana;font-size:10px;color:#666666;}input[type="submit"]{background-color:#F1F1F1;border:1px solid #999999;padding:5px;font-family:verdana;font-size:10px;color:#666666;}textarea{background-color:#F1F1F1;border:1px solid #999999;padding:5px;width:517px;height:70px;font-family:verdana;font-size:10px;color:#666666;}select{background-color:#F1F1F1;border:1px solid #999999;padding:5px;font-family:verdana;font-size:10px;color:#666666;}</style>

<script type="text/javascript">
document.habboLoggedIn = true;
var habboName = "{username}";
var habboId = "{userid}";
var habboReqPath = "";
var habboStaticFilePath = "{url}/app/tpl/skins/Habbo";
var habboImagerUrl = " ";
var habboPartner = "";
var habboDefaultClientPopupUrl = "{url}/client";
window.name = "habboMain";
if (typeof HabboClient != "undefined") {
HabboClient.windowName = "eac955c8dbc88172421193892a3e98fc7402021a";
HabboClient.maximizeWindow = true;
}
</script>

<!--[if IE 8]>
<link rel="stylesheet" href="{url}/app/tpl/skins/Habbo/styles/ie8.css" type="text/css">
<![endif]-->
<!--[if lt IE 8]>
<link rel="stylesheet" href="{url}/app/tpl/skins/Habbo/styles/ie.css" type="text/css" />
<![endif]-->
<!--[if lt IE 7]>
<link rel="stylesheet" href="{url}/app/tpl/skins/Habbo/styles/ie6.css" type="text/css" />
<script type="text/javascript" src="{url}/app/tpl/skins/Habbo/js/pngfix.js"></script>
<script type="text/javascript">
try { document.execCommand('BackgroundImageCache', false, true); } catch(e) {}
</script>
<style type="text/css">
body { behavior: url({url}/app/tpl/skins/Habbo/js/csshover.htc); }
</style>
<![endif]-->
</head>

<body id="news">

<div id="overlay"></div>
<?php

$navigatorID = 2;
require_once ('includes/header.php');

?>

</div>
</div>
</div>
<div id="content-container">
<div id="navi2-container" class="pngbg">
<div id="navi2" class="pngbg clearfix">
<ul>

<?php

$subNavigatorID = 2;
require_once ('includes/subnavi.php');

?>
</ul>
</div>
</div>
<div id="container">
<div id="content" style="position: relative" class="clearfix">
<div id="column1" class="column">
<div class="habblet-container ">
<div class="cbb clearfix default ">
<h2 class="title">News</h2>
<div id="article-archive">
</ul>

<?php
{
for ($i = 0; $i < 6; $i++)
{
$sectionName = "";
$sectionCutoffMax = 0;
$sectionCutoffMin = 0;

switch ($i)
{
case 0:

$sectionName = 'Today';
$sectionCutoffMax = time();
$sectionCutoffMin = time() - 86400;
break;

case 1:

$sectionName = 'Yesterday';
$sectionCutoffMax = time() - 86400;
$sectionCutoffMin = time() - 172800;
break;

case 2:

$sectionName = 'This week';
$sectionCutoffMax = time() - 172800;
$sectionCutoffMin = time() - 604800;
break;

case 3:

$sectionName = 'Last week';
$sectionCutoffMax = time() - 604800;
$sectionCutoffMin = time() - 1209600;
break;

case 4:

$sectionName = 'This month';
$sectionCutoffMax = time() - 1209600;
$sectionCutoffMin = time() - 2592000;
break;

case 5:

$sectionName = 'Last month';
$sectionCutoffMax = time() - 2592000;
$sectionCutoffMin = time() - 5184000;
break;
}

$q = "SELECT * FROM cms_news WHERE published >= " . $sectionCutoffMin . " AND published <= " . $sectionCutoffMax . " ORDER BY published DESC";
$getArticles = mysql_query($q);
if (mysql_num_rows($getArticles) > 0)
{
echo '<h2>' . $sectionName . '</h2>';
echo'<ul><li>';

while ($a = mysql_fetch_assoc($getArticles))
{
if($a['id'] == $_GET['id'])
{
echo '' . $a['title'] . '';
}
else
{
echo '<li><a href="/index.php?url=news&id=' . $a['id'] . '">' . $a['title'] . '&nbsp;&raquo;</a></li>';
}

}
}
}
}
?>

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

<div id="column2" class="column">
<div class="habblet-container ">
<div class="cbb clearfix notitle ">
<div id="article-wrapper">

<h2>{newsTitle}</h2>
<div class="article-meta">Posted {newsDate}</div>
<p class="summary">{newsTitle}</p>
<div class="article-body">
{newsContent}
<br><br>
<p><font face="Verdana" size="1"><b>- {newsAuthor}</b></p>
<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, "Image is loading");
});
});

$$('a.article-2729').each(function(a) {
a.replace(a.innerHTML);
});
});
</script>
</div>
</div>
</div>

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

<?php
$checkBan = mysql_query("SELECT cms_comment_banned FROM users WHERE cms_comment_banned = '1' AND id = '".$_SESSION['user']['id']."'");
if (mysql_num_rows($checkBan) == 1)
{
?>
<div class="habblet-container ">
<div class="cbb clearfix default ">
<h2 class="title">Banned from posting or seeing news comments!</h2>
<div style="padding: 5px;">
<p align="center">You're banned from posting news comments, due to this you cannot post or see comments.</p>
</div>
</div>
</div>
<script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script>
<?php
}
else {
$getArticle = mysql_query("SELECT * FROM cms_news WHERE id = '".filter($_GET['id'])."'") or die(mysql_error());
if (mysql_num_rows($getArticle) > 0)
{
$articleInfo = mysql_fetch_array($getArticle) or die(mysql_error());
if(isset($_POST['post_comment']) && $_SESSION['user']['id'] != null)
{
$checkBan = mysql_query("SELECT cms_comment_banned FROM users WHERE cms_comment_banned = '1' AND id = '".$_SESSION['user']['id']."'");
if (mysql_num_rows($checkBan) == 0)
{
if($_POST['comment'] == NULL)
$errorMessage = 'You have left a field empty.';
else
{
$checkInfo = mysql_query("SELECT * FROM cms_comments WHERE article = '".filter($_GET['id'])."' ORDER BY id DESC LIMIT 1") or die(mysql_error());
$newsInfo = mysql_fetch_array($checkInfo);
if($newsInfo['userid'] == $_SESSION['user']['id'])
$errorMessage = 'Hey! The last comment was from you, let somebody else comment first!';
else
{
mysql_query("INSERT INTO cms_comments (article, userid, comment, posted_on) VALUES ('".filter($_GET['id'])."', '".$_SESSION['user']['id']."', '".filter($_POST['comment'])."', '".date("M j, Y g:i A")."')") or die(mysql_error());
$successMessage = 'You have successfully left a comment.';
}
}
}
}
?>

<div class="habblet-container ">
<div class="cbb clearfix notitle ">
<div id="article-wrapper" align="center">
</div>
</div>
</div>
<div class="habblet-container ">
<div class="cbb clearfix notitle ">
<div id="article-wrapper">
<h2>Post Comment</h2>
<div class="article-meta"></div>
<div style="padding:5px">
<?php if (isset($errorMessage)) { ?>
<div class="action-error flash-message">
<div class="rounded">
<div class="rounded-done"><?php echo $errorMessage; ?></div>
</div>
</div>
<?php } else if (isset($successMessage)) { ?>
<div class="action-confirmation flash-message">
<div class="rounded">
<div class="rounded-done"><?php echo $successMessage; ?></div>
</div>
</div>
<?php } ?>

<form action="" method="post">
<textarea name="comment" maxlength="500"></textarea><br /><br />
<input type="submit" name="post_comment" value="Post Comment" />
</form>
</div>
</div>
</div>
</div>
<script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script>

<div class="habblet-container ">
<div class="cbb clearfix notitle ">
<div id="article-wrapper">
<?php $getComments = mysql_query("SELECT * FROM cms_comments WHERE article = '".filter($_GET['id'])."' ORDER BY id DESC"); ?>
<h2>Comments (<?php echo mysql_num_rows($getComments); ?>)</h2>
<div class="article-meta"></div>
<div style="padding:5px">
<?php
if(mysql_num_rows($getComments) == 0)
echo 'Sorry, but no one has posted a comment yet.';
else
{
echo '<table width="528px">';
while($commentInfo = mysql_fetch_array($getComments))
{
$userInfo = mysql_fetch_array(mysql_query("SELECT * FROM users WHERE id = '".$commentInfo['userid']."'"));

echo '
<tr>
<td width="90px" valign="top">
<div style="height: 80px; width: 50px; float: left; overflow: hidden;"><img src=" .'"></div>';
if($userInfo['rank'] > 7)
echo '<div style="position: absolute; z-index:1"><img src="{url}/images/OWNER.gif"></div>';

else if($userInfo['rank'] > 5)
echo '<div style="position: absolute; z-index:1"><img src="{url}/images/ADM.gif"></div>';

else if($userInfo['vip'] == 2 || $userInfo['rank'] == 3)
echo '<div style="position: absolute; z-index:1"><img src="{url}/images/VIP.gif"></div>';

if ($_SESSION['user']['rank'] >= 7)
echo '<br/><br/><br/><br/><br/><br/><br/><a href="{url}/news/'.$_GET['id'].'/delete/'.$commentInfo['id'].'">Delete</a> | <a href="{url}/news/'.$_GET['id'].'/ban/'.$commentInfo['id'].'">Ban</a>';
echo '</td>

<td width="427px" valign="top">
<strong>RE: {newsTitle}</strong><br /><br />'.$commentInfo['comment'].'
</td>
</tr>
<tr>
<td width="90px" valign="top">
</td>
<td width="427px" align="right">';
if ($_SESSION['user']['rank'] >= 5)
echo '<div align="right" style="margin-top: -16px;"><i>Posted by <strong><a href="#">'.$userInfo['username'].'</a></strong> on '.$commentInfo['posted_on'].'</i></div>';
else
echo '<div align="right"><i>Posted by <strong><a href="#">'.$userInfo['username'].'</a></strong> on '.$commentInfo['posted_on'].'</i></div>';
echo '<br /><br /><div style="width:125%; height:1px; background-color:#ccc; margin-top:-17px;"></div>

</td>

</tr>';
}
echo '</table>';
}
?>

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

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

<script type="text/javascript">
HabboView.run();
</script>
<?php }} ?>

<!--[if lt IE 7]>
<script type="text/javascript">
Pngfix.doPngImageFix();
</script>
<![endif]-->
</font>
</p>

<div id="footer" style="margin-top:-20px;">
<p class="footer-links"><a href=" ">Launch Client</a> l <a href="#" target="_blank">Terms of Service</a> l <a href=" ">Forums</a> l <a href=" ">Store</a></p>
<p class="copyright">Copyright &copy; {hotelName} Hotel 2017. All rights reserved to their respective owner(s). Credits to <strong>Kryptos</strong> for <strong>RevCMS</strong.</p>

</body>
</html>
 

Users who are viewing this thread

Top