[PHPRETRO] News Comment

Dion West · Apr 28, 2011

Now, you might have seen this script on roleplay hotel's it's also able for phpretro normal

Replace Articles.php With the following code

Code:

<?php 
/*================================================================+\ 
|| # PHPRetro - An extendable virtual hotel site and management 
|+================================================================== 
|| # Copyright (C) 2009 Yifan Lu. All rights reserved. 
|| # [url]http://www.yifanlu.com[/url] 
|| # Parts Copyright (C) 2009 Meth0d. All rights reserved. 
|| # [url]http://www.meth0d.org[/url] 
|| # All images, scripts, and layouts 
|| # Copyright (C) 2009 Sulake Ltd. All rights reserved. 
|+================================================================== 
|| # PHPRetro is provided "as is" and comes without 
|| # warrenty of any kind. PHPRetro is free software! 
|| # License: GNU Public License 3.0 
|| # [url]http://opensource.org/licenses/gpl-license.php[/url] 
\+================================================================*/ 

$page['allow_guests'] = true; 
require_once('./includes/core.php'); 
require_once('./includes/session.php'); 
$data = new community_sql; 
$lang->addLocale("community.news"); 

$id = $input->FilterText($_GET['id']); 
$category = $input->stringToURL($input->HoloText($_GET['category'],true),true,false); 
$archive = $_GET['archive']; 
$pagenum = $_GET['pageNumber']; 
if(!isset($_GET['pageNumber'])){ $pagenum = 1; } 

if(!isset($id) || $id == ""){ $id = $db->result($db->query("SELECT MAX(id) AS count FROM ".PREFIX."news LIMIT 1")); } 

$news_row = $db->fetch_assoc($db->query("SELECT * FROM ".PREFIX."news WHERE id = '".$id."' LIMIT 1")); 
foreach ($news_row as &$value) { 
    $value = $input->HoloText($value, true); 
} 
$page['id'] = "news"; 
$page['name'] = $lang->loc['pagename.news']." - ".$news_row['title']; 
$page['bodyid'] = "news"; 
$page['cat'] = "community"; 

require_once('./templates/community_header.php'); 
?> 
<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"><?php echo $lang->loc['pagename.news']; ?> 
                            </h2> 
                        <div id="article-archive"> 
<?php if(isset($_GET['archive']) && $archive = "true"){ 
$count = $db->result($db->query("SELECT COUNT(*) FROM ".PREFIX."news")); 
$pages = ceil($count / 20); ?> 
<div id="article-paging" class="clearfix"> 
        <?php if(($pagenum + 1) <= $pages){ ?><a href="<?php echo PATH; ?>/articles/archive?pageNumber=<?php echo $pagenum + 1; ?>" class="older">&lt;&lt; <?php echo $lang->loc['older']; ?></a><?php } ?> 
        <?php if(($pagenum - 1) > 0){ ?><a href="<?php echo PATH; ?>/articles/archive?pageNumber=<?php echo $pagenum - 1; ?>" class="newer"><?php echo $lang->loc['newer']; ?> &gt;&gt;</a><?php } ?> 
</div> 
<?php } ?> 
<?php 
if((!isset($archive) || $archive == "false") && (!isset($_GET['category']) || $_GET['category'] = "")){ 
$time['stop'] = time() - 60*60*24; 
$sql = $db->query("SELECT * FROM ".PREFIX."news WHERE time > ".$time['stop']." ORDER BY id DESC"); 
if($db->num_rows($sql) > 0){ ?> 
<h2><?php echo $lang->loc['today']; ?></h2> 
<ul> 

<?php while($row = $db->fetch_assoc($sql)){ $row['title_safe'] = $input->stringToURL($input->HoloText($row['title'],true),true,true); ?> 
    <li> 
        <a href="<?php echo PATH; ?>/articles/<?php echo $row['id']."-".$row['title_safe']; ?>" class="article-<?php echo $row['id']; ?>"><?php echo stripslashes($row['title']); ?>&nbsp;&raquo;</a> 
    </li> 

<?php } ?> 

</ul> 
<?php } 
$time['start'] = time() - 60*60*24; $time['stop'] = time() - 60*60*24*2; 
$sql = $db->query("SELECT * FROM ".PREFIX."news WHERE time < ".$time['start']." AND time > ".$time['stop']." ORDER BY id DESC"); 
if($db->num_rows($sql) > 0){ ?> 
<h2><?php echo $lang->loc['yesterday']; ?></h2> 
<ul> 

<?php while($row = $db->fetch_assoc($sql)){ $row['title_safe'] = $input->stringToURL($input->HoloText($row['title'],true),true,true); ?> 
    <li> 
        <a href="<?php echo PATH; ?>/articles/<?php echo $row['id']."-".$row['title_safe']; ?>" class="article-<?php echo $row['id']; ?>"><?php echo stripslashes($row['title']); ?>&nbsp;&raquo;</a> 
    </li> 

<?php } ?> 

</ul> 
<?php } 
$time['start'] = time() - 60*60*24*2; $time['stop'] = time() - 60*60*24*7; 
$sql = $db->query("SELECT * FROM ".PREFIX."news WHERE time < ".$time['start']." AND time > ".$time['stop']." ORDER BY id DESC"); 
if($db->num_rows($sql) > 0){ ?> 
<h2><?php echo $lang->loc['this.week']; ?></h2> 
<ul> 

<?php while($row = $db->fetch_assoc($sql)){ $row['title_safe'] = $input->stringToURL($input->HoloText($row['title'],true),true,true); ?> 
    <li> 
        <a href="<?php echo PATH; ?>/articles/<?php echo $row['id']."-".$row['title_safe']; ?>" class="article-<?php echo $row['id']; ?>"><?php echo stripslashes($row['title']); ?>&nbsp;&raquo;</a> 
    </li> 

<?php } ?> 

</ul> 
<?php } 
$time['start'] = time() - 60*60*24*7; $time['stop'] = time() - 60*60*24*14; 
$sql = $db->query("SELECT * FROM ".PREFIX."news WHERE time < ".$time['start']." AND time > ".$time['stop']." ORDER BY id DESC"); 
if($db->num_rows($sql) > 0){ ?> 
<h2><?php echo $lang->loc['last.week']; ?></h2> 
<ul> 

<?php while($row = $db->fetch_assoc($sql)){ $row['title_safe'] = $input->stringToURL($input->HoloText($row['title'],true),true,true); ?> 
    <li> 
        <a href="<?php echo PATH; ?>/articles/<?php echo $row['id']."-".$row['title_safe']; ?>" class="article-<?php echo $row['id']; ?>"><?php echo stripslashes($row['title']); ?>&nbsp;&raquo;</a> 
    </li> 

<?php } ?> 

</ul> 
<?php } 
$time['start'] = time() - 60*60*24*14; $time['stop'] = time() - 60*60*24*30; 
$sql = $db->query("SELECT * FROM ".PREFIX."news WHERE time < ".$time['start']." AND time > ".$time['stop']." ORDER BY id DESC"); 
if($db->num_rows($sql) > 0){ ?> 
<h2><?php echo $lang->loc['this.month']; ?></h2> 
<ul> 

<?php while($row = $db->fetch_assoc($sql)){ $row['title_safe'] = $input->stringToURL($input->HoloText($row['title'],true),true,true); ?> 
    <li> 
        <a href="<?php echo PATH; ?>/articles/<?php echo $row['id']."-".$row['title_safe']; ?>" class="article-<?php echo $row['id']; ?>"><?php echo stripslashes($row['title']); ?>&nbsp;&raquo;</a> 
    </li> 

<?php } ?> 

</ul> 
<?php } 
}elseif(isset($_GET['archive']) && $archive = "true"){ ?> 
<h2><?php echo $lang->loc['pagename.news']; ?></h2> 
<ul> 

<?php 
$sql = "SELECT * FROM ".PREFIX."news ORDER BY time DESC LIMIT 20"; 
if($pagenum > 1){ $sql = $sql." OFFSET ".($pagenum - 1) * 20; } 
$sql = $db->query($sql); 
while($row = $db->fetch_assoc($sql)){ $row['title_safe'] = $input->stringToURL($input->HoloText($row['title'],true),true,true); ?> 
    <li> 
        <a href="<?php echo PATH; ?>/articles/<?php echo $row['id']."-".$row['title_safe']; ?>/in/archive<?php if($pagenum > 1){ echo $pagenum; } ?>" class="article-<?php echo $row['id']; ?>"><?php echo stripslashes($row['title']); ?>&nbsp;&raquo;</a> 
    </li> 

<?php } ?> 

</ul> 
<?php }elseif(isset($_GET['category'])){ ?> 
<h2><?php echo $lang->loc['pagename.news']; ?></h2> 
<ul> 

<?php 
$sql = $db->query("SELECT * FROM ".PREFIX."news WHERE categories LIKE '%".$category."%'"); 
while($row = $db->fetch_assoc($sql)){ $row['title_safe'] = $input->stringToURL($input->HoloText($row['title'],true),true,true); ?> 
    <li> 
        <a href="<?php echo PATH; ?>/articles/<?php echo $row['id']."-".$row['title_safe']; ?>/in/category/<?php echo $category; ?>" class="article-<?php echo $row['id']; ?>"><?php echo stripslashes($row['title']); ?>&nbsp;&raquo;</a> 
    </li> 

<?php } ?> 

</ul> 
<?php } ?> 

<a href="<?php echo PATH; ?>/articles/archive"><?php echo $lang->loc['more.news']; ?> &raquo;</a> 
</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><?php echo $news_row['title']; ?></h2> 
    <div class="article-meta"><?php echo $lang->loc['posted']." ".date('M j, Y',$news_row['time']); ?> 
    <?php $categories = explode(",",$news_row['categories']); $output = ""; foreach($categories as &$value){ $output = $output."<a href=\"".PATH."/articles/category/".$input->stringToURL($input->HoloText($value,true),true,true)."\">".$value."</a>, "; } $output = substr_replace($output,"",-2); ?> 
        <?php echo $output; ?></div> 

    <?php $images = explode(",",$news_row['images']); if(!empty($images[0])){ ?> 
            <img src="<?php echo $images[0]; ?>" class="article-image"/> 
    <?php } ?> 
    <p class="summary"><?php echo nl2br($news_row['summary']); ?></p> 

    <div class="article-body"> 
<p><?php echo nl2br($news_row['story']); ?></p> 
<div class="article-author">- <?php echo $news_row['author']; ?></div> 

<?php if(count($images) > 1){ unset($images[0]); $output = ""; foreach($images as &$value){ $output = $output."<a href=\"".$value."\" style=\"background-image: url(".$value."); background-position: -0px -0px\"></a>\n"; } ?> 
    <div class="article-images clearfix"> 

        <?php echo $output; ?> 

    </div> 
<?php } ?> 

    <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, "<?php echo $lang->loc['image.loading']; ?>"); 
                }); 
            }); 

            $$('a.article-<?php echo $news_row['id']; ?>').each(function(a) { 
                a.replace(a.innerHTML); 
            }); 
        }); 
    </script> 
    </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 
if(isset($_POST['post_comment']) && $user->name != 'Guest'){ 
  $posted_on = date("M j, Y g:i A"); 
  $comment = strip_tags($input->FilterText($_POST['comment'])); 
  if($comment == NULL){ 
    $error_message = 'You have left a field empty.<br /><br />'; 
  }else{ 
    mysql_query("INSERT INTO cms_news_comments (article, userid, comment, posted_on) VALUES ('".$news_row['id']."', '".$user->id."', '".$comment."', '".$posted_on."');"); 
    $error_message = 'You have successfully left a comment.<br /><br />'; 
  } 
} 
?> 

<div class="habblet-container "> 
  <div class="cbb clearfix notitle "> 
    <div id="article-wrapper"><h2>Post Comment</h2> 
      <div class="article-meta"></div> 
      <div class="article-body"> 
        <?php 
        if($user->name != 'Guest'){ 
        echo $error_message; ?> 
        <form action="" method="post"> 
        <textarea name="comment" maxlength="500"></textarea><br /><br /> 
        <input type="submit" name="post_comment" value="Post Comment" /> 
        </form> 
        <?php 
        }else{ 
          echo 'You must login to post a comment.'; 
        } 
        ?> 
      </div> 
    </div> 
  </div> 
</div> 

<?php 
$getComments = mysql_query("SELECT * FROM cms_news_comments WHERE article = '".$news_row['id']."' ORDER by id DESC"); 
?> 
<div class="habblet-container "> 
  <div class="cbb clearfix notitle "> 
    <div id="article-wrapper"><h2>Comments (<?php echo mysql_num_rows($getComments); ?>)</h2> 
      <div class="article-meta"></div> 
      <div class="article-body"> 
        <?php 
        if(mysql_num_rows($getComments) == 0){ 
          echo 'Sorry, but no one has posted a comment yet.'; 
        }else{ 
          echo '<table width="528px">'; 
          while($Comments = mysql_fetch_array($getComments)){ 
          $getUserInfo = mysql_query("SELECT * FROM users WHERE id = '".$Comments['userid']."'"); 
          $userInfo = mysql_fetch_array($getUserInfo); 
                  echo ' 
                  <tr> 
                    <td width="90px" valign="top"> 
                      <div style="float:left"><img src="http://www.habbo.co.uk/habbo-imaging/avatarimage?figure='.$userInfo['figure'].'&size=b&direction=2&head_direction=3&gesture=sml&size=m"></div> 
                      '; 
                      if($userInfo['rank'] > 5){ 
                        echo '<div style="position: absolute; z-index:1"><img src="http://habbocity.ath.cx/26_6d82813456b38f80ad83a827eef0fde3/c_images/ADM.gif"></div>'; 
                      } 
                 echo ' 
                </td> 
                    <td width="427px" valign="top"> 
                      <strong>RE: '.$news_row['title'].'</strong><br /><br />'.$Comments['comment'].' 
                    </td> 
                  </tr> 
          <tr> 
                    <td width="90px" valign="top"> 
                    </td> 
            <td width="427px" align="right"> 
              <i>Posted by <strong><a href="#">'.$userInfo['name'].'</a></strong> on '.$Comments['posted_on'].'</i><br /><br /> 
            </td> 
          </tr>'; 
          } 
          echo '</table>'; 
        } 
        ?> 
      </div> 
    </div> 
  </div> 
</div> 

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


</div> 
<script type="text/javascript"> 
HabboView.run(); 
</script> 
<?php require_once('./templates/community_footer.php'); ?>

And for the last add this to youre database

Code:

CREATE TABLE IF NOT EXISTS `cms_news_comments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `article` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `comment` varchar(500) NOT NULL,
  `posted_on` varchar(150) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=254 ;

Screenshot

Also be sure if you want the Admin badge near youre head to change the Adm Link in articles.php

Credit's:

Rastalulz
Aaron - Coding badges bit for staff (HabboRP.com)
PHPRetro Developers - Coding the CMS

Gio · Apr 28, 2011

I like the background, where did you get it?

Logitech · Apr 28, 2011

Why is Haro down?

Dion West · Apr 28, 2011

Gio: Thanks i got it from you

Logitech: Who are you and also, haro isent down but im just not telling the link yet

ComputerFreak · Apr 28, 2011

Dion i want the backround too :eek:

help me get it :d

Gio · Apr 28, 2011

I made it, I was just trolling.

ComputerFreak · Apr 28, 2011

gio can u help me get it D:

Gio · Apr 28, 2011

Sure, what do you want on it? Name, colors, pattern etc...

ComputerFreak · Apr 28, 2011

I want name to say HabTown And All the same colors you got

Dion West · Apr 29, 2011

Please discuss this on msn and not on my thread because it's a release not a general discussion for arts

TheJoshy · May 15, 2011

Dion West said:

Now, you might have seen this script on roleplay hotel's it's also able for phpretro normal

Replace Articles.php With the following code

Code:

<?php 
/*================================================================+\ 
|| # PHPRetro - An extendable virtual hotel site and management 
|+================================================================== 
|| # Copyright (C) 2009 Yifan Lu. All rights reserved. 
|| # [url]http://www.yifanlu.com[/url] 
|| # Parts Copyright (C) 2009 Meth0d. All rights reserved. 
|| # [url]http://www.meth0d.org[/url] 
|| # All images, scripts, and layouts 
|| # Copyright (C) 2009 Sulake Ltd. All rights reserved. 
|+================================================================== 
|| # PHPRetro is provided "as is" and comes without 
|| # warrenty of any kind. PHPRetro is free software! 
|| # License: GNU Public License 3.0 
|| # [url]http://opensource.org/licenses/gpl-license.php[/url] 
\+================================================================*/ 

$page['allow_guests'] = true; 
require_once('./includes/core.php'); 
require_once('./includes/session.php'); 
$data = new community_sql; 
$lang->addLocale("community.news"); 

$id = $input->FilterText($_GET['id']); 
$category = $input->stringToURL($input->HoloText($_GET['category'],true),true,false); 
$archive = $_GET['archive']; 
$pagenum = $_GET['pageNumber']; 
if(!isset($_GET['pageNumber'])){ $pagenum = 1; } 

if(!isset($id) || $id == ""){ $id = $db->result($db->query("SELECT MAX(id) AS count FROM ".PREFIX."news LIMIT 1")); } 

$news_row = $db->fetch_assoc($db->query("SELECT * FROM ".PREFIX."news WHERE id = '".$id."' LIMIT 1")); 
foreach ($news_row as &$value) { 
    $value = $input->HoloText($value, true); 
} 
$page['id'] = "news"; 
$page['name'] = $lang->loc['pagename.news']." - ".$news_row['title']; 
$page['bodyid'] = "news"; 
$page['cat'] = "community"; 

require_once('./templates/community_header.php'); 
?> 
<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"><?php echo $lang->loc['pagename.news']; ?> 
                            </h2> 
                        <div id="article-archive"> 
<?php if(isset($_GET['archive']) && $archive = "true"){ 
$count = $db->result($db->query("SELECT COUNT(*) FROM ".PREFIX."news")); 
$pages = ceil($count / 20); ?> 
<div id="article-paging" class="clearfix"> 
        <?php if(($pagenum + 1) <= $pages){ ?><a href="<?php echo PATH; ?>/articles/archive?pageNumber=<?php echo $pagenum + 1; ?>" class="older">&lt;&lt; <?php echo $lang->loc['older']; ?></a><?php } ?> 
        <?php if(($pagenum - 1) > 0){ ?><a href="<?php echo PATH; ?>/articles/archive?pageNumber=<?php echo $pagenum - 1; ?>" class="newer"><?php echo $lang->loc['newer']; ?> &gt;&gt;</a><?php } ?> 
</div> 
<?php } ?> 
<?php 
if((!isset($archive) || $archive == "false") && (!isset($_GET['category']) || $_GET['category'] = "")){ 
$time['stop'] = time() - 60*60*24; 
$sql = $db->query("SELECT * FROM ".PREFIX."news WHERE time > ".$time['stop']." ORDER BY id DESC"); 
if($db->num_rows($sql) > 0){ ?> 
<h2><?php echo $lang->loc['today']; ?></h2> 
<ul> 

<?php while($row = $db->fetch_assoc($sql)){ $row['title_safe'] = $input->stringToURL($input->HoloText($row['title'],true),true,true); ?> 
    <li> 
        <a href="<?php echo PATH; ?>/articles/<?php echo $row['id']."-".$row['title_safe']; ?>" class="article-<?php echo $row['id']; ?>"><?php echo stripslashes($row['title']); ?>&nbsp;&raquo;</a> 
    </li> 

<?php } ?> 

</ul> 
<?php } 
$time['start'] = time() - 60*60*24; $time['stop'] = time() - 60*60*24*2; 
$sql = $db->query("SELECT * FROM ".PREFIX."news WHERE time < ".$time['start']." AND time > ".$time['stop']." ORDER BY id DESC"); 
if($db->num_rows($sql) > 0){ ?> 
<h2><?php echo $lang->loc['yesterday']; ?></h2> 
<ul> 

<?php while($row = $db->fetch_assoc($sql)){ $row['title_safe'] = $input->stringToURL($input->HoloText($row['title'],true),true,true); ?> 
    <li> 
        <a href="<?php echo PATH; ?>/articles/<?php echo $row['id']."-".$row['title_safe']; ?>" class="article-<?php echo $row['id']; ?>"><?php echo stripslashes($row['title']); ?>&nbsp;&raquo;</a> 
    </li> 

<?php } ?> 

</ul> 
<?php } 
$time['start'] = time() - 60*60*24*2; $time['stop'] = time() - 60*60*24*7; 
$sql = $db->query("SELECT * FROM ".PREFIX."news WHERE time < ".$time['start']." AND time > ".$time['stop']." ORDER BY id DESC"); 
if($db->num_rows($sql) > 0){ ?> 
<h2><?php echo $lang->loc['this.week']; ?></h2> 
<ul> 

<?php while($row = $db->fetch_assoc($sql)){ $row['title_safe'] = $input->stringToURL($input->HoloText($row['title'],true),true,true); ?> 
    <li> 
        <a href="<?php echo PATH; ?>/articles/<?php echo $row['id']."-".$row['title_safe']; ?>" class="article-<?php echo $row['id']; ?>"><?php echo stripslashes($row['title']); ?>&nbsp;&raquo;</a> 
    </li> 

<?php } ?> 

</ul> 
<?php } 
$time['start'] = time() - 60*60*24*7; $time['stop'] = time() - 60*60*24*14; 
$sql = $db->query("SELECT * FROM ".PREFIX."news WHERE time < ".$time['start']." AND time > ".$time['stop']." ORDER BY id DESC"); 
if($db->num_rows($sql) > 0){ ?> 
<h2><?php echo $lang->loc['last.week']; ?></h2> 
<ul> 

<?php while($row = $db->fetch_assoc($sql)){ $row['title_safe'] = $input->stringToURL($input->HoloText($row['title'],true),true,true); ?> 
    <li> 
        <a href="<?php echo PATH; ?>/articles/<?php echo $row['id']."-".$row['title_safe']; ?>" class="article-<?php echo $row['id']; ?>"><?php echo stripslashes($row['title']); ?>&nbsp;&raquo;</a> 
    </li> 

<?php } ?> 

</ul> 
<?php } 
$time['start'] = time() - 60*60*24*14; $time['stop'] = time() - 60*60*24*30; 
$sql = $db->query("SELECT * FROM ".PREFIX."news WHERE time < ".$time['start']." AND time > ".$time['stop']." ORDER BY id DESC"); 
if($db->num_rows($sql) > 0){ ?> 
<h2><?php echo $lang->loc['this.month']; ?></h2> 
<ul> 

<?php while($row = $db->fetch_assoc($sql)){ $row['title_safe'] = $input->stringToURL($input->HoloText($row['title'],true),true,true); ?> 
    <li> 
        <a href="<?php echo PATH; ?>/articles/<?php echo $row['id']."-".$row['title_safe']; ?>" class="article-<?php echo $row['id']; ?>"><?php echo stripslashes($row['title']); ?>&nbsp;&raquo;</a> 
    </li> 

<?php } ?> 

</ul> 
<?php } 
}elseif(isset($_GET['archive']) && $archive = "true"){ ?> 
<h2><?php echo $lang->loc['pagename.news']; ?></h2> 
<ul> 

<?php 
$sql = "SELECT * FROM ".PREFIX."news ORDER BY time DESC LIMIT 20"; 
if($pagenum > 1){ $sql = $sql." OFFSET ".($pagenum - 1) * 20; } 
$sql = $db->query($sql); 
while($row = $db->fetch_assoc($sql)){ $row['title_safe'] = $input->stringToURL($input->HoloText($row['title'],true),true,true); ?> 
    <li> 
        <a href="<?php echo PATH; ?>/articles/<?php echo $row['id']."-".$row['title_safe']; ?>/in/archive<?php if($pagenum > 1){ echo $pagenum; } ?>" class="article-<?php echo $row['id']; ?>"><?php echo stripslashes($row['title']); ?>&nbsp;&raquo;</a> 
    </li> 

<?php } ?> 

</ul> 
<?php }elseif(isset($_GET['category'])){ ?> 
<h2><?php echo $lang->loc['pagename.news']; ?></h2> 
<ul> 

<?php 
$sql = $db->query("SELECT * FROM ".PREFIX."news WHERE categories LIKE '%".$category."%'"); 
while($row = $db->fetch_assoc($sql)){ $row['title_safe'] = $input->stringToURL($input->HoloText($row['title'],true),true,true); ?> 
    <li> 
        <a href="<?php echo PATH; ?>/articles/<?php echo $row['id']."-".$row['title_safe']; ?>/in/category/<?php echo $category; ?>" class="article-<?php echo $row['id']; ?>"><?php echo stripslashes($row['title']); ?>&nbsp;&raquo;</a> 
    </li> 

<?php } ?> 

</ul> 
<?php } ?> 

<a href="<?php echo PATH; ?>/articles/archive"><?php echo $lang->loc['more.news']; ?> &raquo;</a> 
</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><?php echo $news_row['title']; ?></h2> 
    <div class="article-meta"><?php echo $lang->loc['posted']." ".date('M j, Y',$news_row['time']); ?> 
    <?php $categories = explode(",",$news_row['categories']); $output = ""; foreach($categories as &$value){ $output = $output."<a href=\"".PATH."/articles/category/".$input->stringToURL($input->HoloText($value,true),true,true)."\">".$value."</a>, "; } $output = substr_replace($output,"",-2); ?> 
        <?php echo $output; ?></div> 

    <?php $images = explode(",",$news_row['images']); if(!empty($images[0])){ ?> 
            <img src="<?php echo $images[0]; ?>" class="article-image"/> 
    <?php } ?> 
    <p class="summary"><?php echo nl2br($news_row['summary']); ?></p> 

    <div class="article-body"> 
<p><?php echo nl2br($news_row['story']); ?></p> 
<div class="article-author">- <?php echo $news_row['author']; ?></div> 

<?php if(count($images) > 1){ unset($images[0]); $output = ""; foreach($images as &$value){ $output = $output."<a href=\"".$value."\" style=\"background-image: url(".$value."); background-position: -0px -0px\"></a>\n"; } ?> 
    <div class="article-images clearfix"> 

        <?php echo $output; ?> 

    </div> 
<?php } ?> 

    <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, "<?php echo $lang->loc['image.loading']; ?>"); 
                }); 
            }); 

            $$('a.article-<?php echo $news_row['id']; ?>').each(function(a) { 
                a.replace(a.innerHTML); 
            }); 
        }); 
    </script> 
    </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 
if(isset($_POST['post_comment']) && $user->name != 'Guest'){ 
  $posted_on = date("M j, Y g:i A"); 
  $comment = strip_tags($input->FilterText($_POST['comment'])); 
  if($comment == NULL){ 
    $error_message = 'You have left a field empty.<br /><br />'; 
  }else{ 
    mysql_query("INSERT INTO cms_news_comments (article, userid, comment, posted_on) VALUES ('".$news_row['id']."', '".$user->id."', '".$comment."', '".$posted_on."');"); 
    $error_message = 'You have successfully left a comment.<br /><br />'; 
  } 
} 
?> 

<div class="habblet-container "> 
  <div class="cbb clearfix notitle "> 
    <div id="article-wrapper"><h2>Post Comment</h2> 
      <div class="article-meta"></div> 
      <div class="article-body"> 
        <?php 
        if($user->name != 'Guest'){ 
        echo $error_message; ?> 
        <form action="" method="post"> 
        <textarea name="comment" maxlength="500"></textarea><br /><br /> 
        <input type="submit" name="post_comment" value="Post Comment" /> 
        </form> 
        <?php 
        }else{ 
          echo 'You must login to post a comment.'; 
        } 
        ?> 
      </div> 
    </div> 
  </div> 
</div> 

<?php 
$getComments = mysql_query("SELECT * FROM cms_news_comments WHERE article = '".$news_row['id']."' ORDER by id DESC"); 
?> 
<div class="habblet-container "> 
  <div class="cbb clearfix notitle "> 
    <div id="article-wrapper"><h2>Comments (<?php echo mysql_num_rows($getComments); ?>)</h2> 
      <div class="article-meta"></div> 
      <div class="article-body"> 
        <?php 
        if(mysql_num_rows($getComments) == 0){ 
          echo 'Sorry, but no one has posted a comment yet.'; 
        }else{ 
          echo '<table width="528px">'; 
          while($Comments = mysql_fetch_array($getComments)){ 
          $getUserInfo = mysql_query("SELECT * FROM users WHERE id = '".$Comments['userid']."'"); 
          $userInfo = mysql_fetch_array($getUserInfo); 
                  echo ' 
                  <tr> 
                    <td width="90px" valign="top"> 
                      <div style="float:left"><img src="http://www.habbo.co.uk/habbo-imaging/avatarimage?figure='.$userInfo['figure'].'&size=b&direction=2&head_direction=3&gesture=sml&size=m"></div> 
                      '; 
                      if($userInfo['rank'] > 5){ 
                        echo '<div style="position: absolute; z-index:1"><img src="http://habbocity.ath.cx/26_6d82813456b38f80ad83a827eef0fde3/c_images/ADM.gif"></div>'; 
                      } 
                 echo ' 
                </td> 
                    <td width="427px" valign="top"> 
                      <strong>RE: '.$news_row['title'].'</strong><br /><br />'.$Comments['comment'].' 
                    </td> 
                  </tr> 
          <tr> 
                    <td width="90px" valign="top"> 
                    </td> 
            <td width="427px" align="right"> 
              <i>Posted by <strong><a href="#">'.$userInfo['name'].'</a></strong> on '.$Comments['posted_on'].'</i><br /><br /> 
            </td> 
          </tr>'; 
          } 
          echo '</table>'; 
        } 
        ?> 
      </div> 
    </div> 
  </div> 
</div> 

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


</div> 
<script type="text/javascript"> 
HabboView.run(); 
</script> 
<?php require_once('./templates/community_footer.php'); ?>

And for the last add this to youre database

Code:

CREATE TABLE IF NOT EXISTS `cms_news_comments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `article` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `comment` varchar(500) NOT NULL,
  `posted_on` varchar(150) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=254 ;

Screenshot

Also be sure if you want the Admin badge near youre head to change the Adm Link in articles.php

Credit's:

Rastalulz
Aaron - Coding badges bit for staff (HabboRP.com)
PHPRetro Developers - Coding the CMS

Dude... this was one of the first posts ever made by Rasta... no need for you to post it again, it's only on the 2nd page of CMS Releases.

PanchoJr · Sep 6, 2011

Could you please help me i dont understand it you dont say where to put it or anything

[PHPRETRO] News Comment

Dion West

Member

Gio

New Member

Logitech

New Member

Dion West

Member

ComputerFreak

New Member

Gio

New Member

ComputerFreak

New Member

Gio

New Member

ComputerFreak

New Member

Dion West

Member

TheJoshy

PlusHost.org -> GOGOGO

PanchoJr

New Member

Users who are viewing this thread

Latest posts

Connect with us

Newest members