REVCMS NEWS PAGE

JoshuaS

Learning
Jan 9, 2014
119
13
So i have added the rewrite for news articles so they get a new news id site everytime. And its fine, but when i go to url/news i get this site where i can comment
. I want to end up at the latest news instead.
 

JoshuaS

Learning
Jan 9, 2014
119
13
At the top of the article or news page:

<?php
if(!isset($_GET['id']))
header('Location: /news/1');
?>
So where excactly? i've put the code in the spoiler
Code:
<!DOCTYPE html>
<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>

        <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>
    <div id="overlay"></div>
         <?php include ("includes/header.php"); ?>
            <ul id="navi">
                <li class="metab"><a href="{url}/me">{username}</a><span></span></li>
                <li class="selected"><strong>Community</strong><span></span></li>
      <li id="values"><a href= "{url}/values">Rare Values</a><span></span></li>
      <li id="tab-register-now"><a href="{url}/shop">Shop</a><span></span></li>
            </ul>
            <div id="habbos-online" style="background-color:#FFF;border-radius:6px;"><div class="rounded"><span>{online}<br> members playing</div></div>
        </div>
    </div>

    <div id="content-container">
        <div id="navi2-container" class="pngbg">
            <div id="navi2" class="pngbg clearfix">
                <ul>
                    <li><a href="{url}/community">Community</a></li>
                    <li class="selected">Articles</li>
        <li><a href="{url}/staff">Staff Team</a></li>
        <li><a href="{url}/topstats">Top Stats</a></li>
                </ul>
            </div>
        </div>
    <body id="news">
    <div id="container">
      <!-- Author Container -->
        <div id="content" style="position: relative" class="clearfix">
            <div id="column1" class="column">
              <div class="habblet-container">
                  <div style="height: 120px; overflow: hidden;" class="cbb clearfix red">
                      <h2 class="title">Forfatter</h2>
                      <div class="author_div" style="overflow: hidden; margin-top: 2px; word-wrap: break-word;">
                        <p class="author_name"><b>{newsAuthor}</b></p>
                        <p class="author_motto"><?php
                        $getCom = mysql_query("SELECT * FROM cms_news WHERE id = '".htmlentities($_GET['id'])."' ");

                                  while($Com = mysql_fetch_array($getCom)){
                                  $getusermotto = mysql_query("SELECT * FROM users WHERE username = '".$Com['author']."'");
                                  $usermotto = mysql_fetch_array($getusermotto);
                                          echo $usermotto['motto'];
                                        ;}


                        ?></p>
                        <!--<div class="author_status">
                        <?php
                        $getCom = mysql_query("SELECT * FROM cms_news WHERE id = '".htmlentities($_GET['id'])."' ");

                                  while($Com = mysql_fetch_array($getCom)){
                                  $getuserlook = mysql_query("SELECT * FROM users WHERE username = '".$Com['author']."'");
                                  $userlook = mysql_fetch_array($getuserlook);
                                          if ($userlook['online'] == 1) {
                                            echo '<img src="{url}/app/tpl/skins/Habbo/images/online.gif";>';
                                          } else {
                                            echo '<img src="{url}/app/tpl/skins/Habbo/images/offline.gif">';
                                          };
                                        };
                         ?>
                       </div>-->



                        <?php

                        $getCom = mysql_query("SELECT * FROM cms_news WHERE id = '".htmlentities($_GET['id'])."' ");

                                  while($Com = mysql_fetch_array($getCom)){
                                  $getuserlook = mysql_query("SELECT * FROM users WHERE username = '".$Com['author']."'");
                                  $userlook = mysql_fetch_array($getuserlook);
                                          echo'
                                              <img class="author_avatar" src="http://www.habbo.com/habbo-imaging/avatarimage?figure='.$userlook['look'].'&direction=2&head_direction=3&size=m&gesture=sml">
                                              ';}
                        ?>
                      </div>


                    </div>
                  </div>
                <div class="habblet-container ">
                    <div class="cbb clearfix red ">
                        <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>
                                    <ul>';

                                    while ($a = mysql_fetch_assoc($getArticles))
                                    {
                                      echo '<li>
                                      <a href="https://furyhotel.net/news/' . $a['id'] . '">' . $a['title'] . '&nbsp;&raquo;</a>
                                      </li>';
                                    }

                                    echo '</ul>';
                                  }
                                }
                              }

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


<!--Kommentar-funktion -->
    <?php
    if(isset($_POST['post_comment']))
    $posted_on = date("M j, Y g:i A");

    if (empty($_POST['comment']))
    $_POST['comment'] = '';

    $comment = strip_tags (filter($_POST['comment']));
    if($comment == NULL){
    //define("ERROR", "You have to type in a reply!<br /><br />");
    //$error_message = 'You have to type in a reply!<br /><br />';
    }else{
    if (isLogged)
    {
    mysql_query("INSERT INTO cms_comments (article, userid, comment, posted_on, author) VALUES ('".filter($_GET['id'])."', '".$_SESSION['user']['id']."', '".filter($comment)."', '".$posted_on."', '" . $_SESSION['user']['username']. "');") or die(mysql_error());
    define('SUCCESS', 'You have successfully posted a comment on this news article!');


    //define("ERROR", "<br>Thanks for your reply!<br />");

    //$error_message = 'Thanks for your reply!<br /><br />';
    }
    }
    ?>

    <div class="habblet-container ">
    <div class="cbb clearfix notitle ">
    <div id="article-wrapper"><h2>Place Comment</h2>
    <div class="article-meta"></div>
    <div class="article-body">
    <?php
    $userPosts = mysql_query("SELECT * FROM cms_comments WHERE article = '".htmlentities(mysql_real_escape_string($_GET['id']))."' AND userid = '" . $_SESSION['user']['id']. "'");
    $postNum = mysql_num_rows($userPosts);
    if($postNum >= 2)
    {
    define('ERROR', 'Sorry, you are only allowed one comment per article.');
    }
    if(defined("SUCCESS")){
    /* Refresh efter kommentar */
    header('Refresh:0;')
    ?>
        <div>&nbsp;</div>
    <?php
    }
    if(defined("ERROR")) {
    ?>
    <div class="rounded rounded-red" width="20%">
            <?php echo ERROR; ?><br />
        </div>
        <div>&nbsp;</div>
    <?php
    }
    else
    {
    ?>
    <form action="" method="post">
    <textarea name="comment" maxlength="500"></textarea><br /><br />
    <input type="submit" name="post_comment" value="Place Comment" />
    </form>
    <?php
    }
    ?>
    </div>
    </div>
    </div>
    </div>

    <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>
    <?php
    $getComments = mysql_query("SELECT * FROM cms_comments WHERE article = '".filter($_GET['id'])."' ORDER by id DESC");
    ?>
    <div class="habblet-container ">
    <div class="cbb clearfix notitle ">
    <div id="article-wrapper"><h2><?php echo mysql_num_rows($getComments); ?> Comments</h2>
    <div class="article-meta"></div>
    <div class="article-body">
    <?php
    if(mysql_num_rows($getComments) == 0) {
    echo "No comments for this article!";
    } else {
    echo '<table width="528px">';
    while($Comments = mysql_fetch_array($getComments)){
    $getUserInfo = mysql_query("SELECT * FROM users WHERE username = '".$Comments['author']."'");
    $userInfo = mysql_fetch_array($getUserInfo);
          echo '
          <tr>
            <td width="90px" valign="top"></div>
            <div style="
    height: 65px;
    width: 50px;
    float: left;
    overflow: hidden;
    ">
              <div style="float:left"><img position:absolute; src="http://www.habbo.nl/habbo-imaging/avatarimage?figure='.$userInfo['look'].'&size=b&direction=2&head_direction=3&gesture=sml&size=2"></div>
              ';
                if($userInfo['rank'] >= 5) {
                    echo $userinfo['rank'];
                    echo '<div style="position: absolute; z-index:1"><img src="{url}/swf/c_images/album1584/ADM.gif"></div>';
                }
                if($userInfo['rank'] == 3) {
                    echo '<div style="position: absolute; z-index:1"><img src="{url}/swf/c_images/badges/XXX.gif"></div>';
                }
                if($userInfo['rank'] == 4) {
                    echo '<div style="position: absolute; z-index:1"><img src="{url}/swf/c_images/badges/XXX.gif"></div>';
                }
                if($userInfo['rank'] == 2) {
                    echo '<div style="position: absolute; z-index:1"><img src="{url}/swf/c_images/badges/VIP.gif"></div>';
                }
                if($userInfo['rank'] == 1) {
                    echo '<div style="position: absolute; z-index:1"><img src="{url}/lid.png"></div>';
                }


        echo '

        </td>
            <td width="427px" valign="top">
            <i><a href="/me">'.$userInfo['username'].' </a></i>
                                <br /><br />'.$Comments['comment'].'


            </td>
          </tr>
    <tr>
            <td width="80px" valign="top">

            </td>
                        <td width="400px" align="right">






    </div></div></div></div>
    <br>
    <div style="width:100%; height:1px; background-color:#ccc; margin-top:-17px;"></div>


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

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

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


    <div id="footer" >
    <?php include "app/tpl/skins/Habbo/inc/footer.php"; ?>
    </div>

<!-- LIKE funktion -->



























    </body>
    </html>
 

JayC

Always Learning
Aug 8, 2013
5,493
1,398
It may be already setting it to
Code:
<?php

 If(mysql_num_rows(mysql_query("SELECT null FROM cms_news where ID = "'.filter($_GET['id']).'" LIMIT 1") == 0){
  $nextId = mysql_fetch_assoc(mysql_query("SELECT `id` FROM cms_news ORDER BY `id` DESC LIMIT 1"));
header('Location: /news/'.$nextId['id'].');
}



?>
1 inside the class.forms.template or whatever file under app and news article 1 doesn't exist. You will have to add code that selects the newest article and take them to that article instead of article 1. Pseudo code:
 

Users who are viewing this thread

Top