[RevCMS] White News Page

D

Detox

Member
Jul 24, 2010
365
24
Hey so I finally placed my up for CMS beta testing but for some reason my news page is blank even if I view source F12 Firebug whatever named I've attempted I have funny feeling it has to do with phpMyAdmin because on my localhost I'm using version 4.5.2 and on Server it's 4.7.0 so when I Imported the database I was getting some weird error about MariaDB.Syntax (I'll post Image) But anyways here are some Images and my news.php file is exactly the same from localhost so their been no adjustment to these files whatsoever!

Live CMS Demo:
You must be registered for see links


Image on Localhost:

1yr6zd.png


Image on server:

2s9t6ox.png
 
Sort by date Sort by votes
D

Detox

Member
Jul 24, 2010
365
24
Boosted said:
Can you send here your news.php?
Click to expand...
PHP: 
<!DOCTYPE html>
<?php include('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 = "http://www.habbo.com/habbo-imaging/";
            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="http://www.habbo.fr/habbo-imaging/avatarimage?figure='.$userInfo['look'].'"></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>
<? }} ?>
        <!--[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="https://cheerhotel.com/client">Launch Client</a> l <a href="#" target="_blank">Terms of Service</a> l <a href="http://cheerboards.com/">Forums</a> l <a href="https://cheerhotel.com/store">Store</a></p>
<p class="copyright">Copyright &copy; {hotelName} Hotel 2016. All rights reserved to their respective owner(s). Credits to <strong>Kryptos</strong> for <strong>RevCMS</strong.</p>

    </body>
</html>

 
Last edited:
Upvote 0 Downvote

Users who are viewing this thread

Total: 2 (members: 0, guests: 2)
☀️  Switch to Light Theme

Latest posts

Top