Menu
Forums
All threads
Latest threads
New posts
Trending threads
New posts
Search forums
Trending
What's new
New posts
New profile posts
Latest activity
Members
Current visitors
New profile posts
Search profile posts
Upgrades
Log in
Register
What's new
Search
Search
Search titles only
By:
All threads
Latest threads
New posts
Trending threads
New posts
Search forums
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
Server Development
Habbo Retros
Habbo Releases
CMS Releases
RevCMS Working News Comments!
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="Kristopher" data-source="post: 176583" data-attributes="member: 1958"><p><span style="font-size: 15px">Some of the forum members put something together for you RevCMS users. </span></p><p></p><p>[PHP]<!DOCTYPE html></p><p><html lang="en"></p><p> <head></p><p> <meta http-equiv="content-type" content="text/html; charset=utf-8"></p><p> <title>{hotelName} - News</title></p><p> <div id="fb-root"></div></p><p><script>(function(d, s, id) {</p><p>var js, fjs = d.getElementsByTagName(s)[0];</p><p>if (d.getElementById(id)) return;</p><p>js = d.createElement(s); js.id = id;</p><p>js.src = "//connect.facebook.net/en_US/all.js#xfbml=1&appId=138881106159184";</p><p>fjs.parentNode.insertBefore(js, fjs);</p><p>}(document, 'script', 'facebook-jssdk'));</script></p><p> <link rel="stylesheet" href="{url}/app/tpl/skins/Habbo/styles/common.css" type="text/css"></p><p> <script type="text/javascript" src="{url}/app/tpl/skins/Habbo/js/libs2.js"></script></p><p> <script type="text/javascript" src="{url}/app/tpl/skins/Habbo/js/visual.js"></script></p><p> <script type="text/javascript" src="{url}/app/tpl/skins/Habbo/js/libs.js"></script></p><p> <script type="text/javascript" src="{url}/app/tpl/skins/Habbo/js/common.js"></script></p><p> <script type="text/javascript" src="{url}/app/tpl/skins/Habbo/js/fullcontent.js"></script></p><p></p><p> <script type="text/javascript"></p><p> document.habboLoggedIn = true;</p><p> var habboName = "{username}";</p><p> var habboId = "{userid}";</p><p> var habboReqPath = "";</p><p> var habboStaticFilePath = "{url}/app/tpl/skins/Habbo";</p><p> var habboImagerUrl = "http://www.habbo.com/habbo-imaging/";</p><p> var habboPartner = "";</p><p> var habboDefaultClientPopupUrl = "{url}/client";</p><p> window.name = "habboMain";</p><p> if (typeof HabboClient != "undefined") {</p><p> HabboClient.windowName = "eac955c8dbc88172421193892a3e98fc7402021a";</p><p> HabboClient.maximizeWindow = true;</p><p> }</p><p> </script></p><p></p><p> <!--[if IE 8]></p><p> <link rel="stylesheet" href="{url}/app/tpl/skins/Habbo/styles/ie8.css" type="text/css"></p><p> <![endif]--></p><p> <!--[if lt IE 8]></p><p> <link rel="stylesheet" href="{url}/app/tpl/skins/Habbo/styles/ie.css" type="text/css" /></p><p> <![endif]--></p><p> <!--[if lt IE 7]></p><p> <link rel="stylesheet" href="{url}/app/tpl/skins/Habbo/styles/ie6.css" type="text/css" /></p><p> <script type="text/javascript" src="{url}/app/tpl/skins/Habbo/js/pngfix.js"></script></p><p> <script type="text/javascript"></p><p> try { document.execCommand('BackgroundImageCache', false, true); } catch(e) {}</p><p> </script></p><p> <style type="text/css"></p><p> body { behavior: url({url}/app/tpl/skins/Habbo/js/csshover.htc); }</p><p> </style></p><p> <![endif]--></p><p> </head></p><p></p><p> <body id="news"></p><p><div id="overlay"></div></p><p> <div id="header-container"></p><p> <div id="header" class="clearfix"></p><p> <h1><a href="http://shockhotel.com/"></a></h1></p><p> <div id="subnavi"></p><p> <div id="subnavi-user"></p><p> <ul></p><p> <li id="myfriends"><a href="#"><span>My Friends</span></a><span class="r"></span></li></p><p> <li id="mygroups"><a href="#"><span>My Groups</span></a><span class="r"></span></li></p><p> <li id="myrooms"><a href="#"><span>My Rooms</span></a><span class="r"></span></li></p><p> </ul></p><p> </div></p><p> <div id="subnavi-search"></p><p> <div id="subnavi-search-upper"></p><p> <ul id="subnavi-search-links"></p><p></p><p> <u><li><a href="http://shockhotel.com/logout" style="color:#000">Logout</a></li></u></p><p> </ul></p><p> </div></p><p> </div></p><p> <div id="to-hotel"></p><p> <a href="{url}/api.php" class="new-button green-button" target="eac955c8dbc88172421193892a3e98fc7402021a" onclick="HabboClient.openOrFocus(this); return false;"><b>Enter Strike Hotel</b><i></i></a></p><p> </div></p><p> </div></p><p> <ul id="navi"></p><p> <li class="metab"><a href="{url}/me">{username}</a><span></span></li></p><p> <li class="selected"><strong>Community</strong><span></span></li></p><p> <li><a href="{url}/vip">VIP</a><span></span></li></p><p> <li><a href="{url}/404">Coming Soon! ({vip_points}p)</a><span></span></li></p><p> </ul></p><p> </p><p> <div id="habbos-online"></p><p> <div id="content"></p><p> <div class="cbb "></p><p><span>{online} members online</span></div></p><p> </div></p><p></div></p><p> </div></p><p> </div></p><p> </div></p><p> <?php</p><p> if( $_GET['id'] ) {</p><p> </p><p> $query = mysql_query( "SELECT * FROM `cms_news` WHERE id = '".filter($_GET['id'])."'");</p><p> $array = mysql_fetch_assoc( $query );</p><p> </p><p> }</p><p> </p><p> ?></p><p> <div id="content-container"></p><p> <div id="navi2-container" class="pngbg"></p><p> <div id="navi2" class="pngbg clearfix"></p><p> <ul></p><p> </p><p> <li><a href="{url}/community">Community</a></li></p><p> <li class="selected">&#9734; News&#9734;</li></p><p> <li><a href="{url}/staff">Staff</a></li></p><p> <li><a href="{url}/topstats">Top User Stats</a></li></p><p> <li class=" last"><a href="{url}/expert">eXperts</a></li></p><p> </ul></p><p> </div></p><p> </div></p><p> <div id="container"></p><p> <div id="content" style="position: relative" class="clearfix"></p><p> <div id="column1" class="column"></p><p> <div class="habblet-container "></p><p> <div class="cbb clearfix red "></p><p> <h2 class="title">News</h2></p><p> <div id="article-archive"></p><p></p><p> <ul></p><p></p><p> {newsList}</p><p> </ul></p><p> </div></p><p> </div></p><p> </div></p><p> <script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script></p><p> </div></p><p> <div id="column2" class="column"></p><p> <div class="habblet-container "></p><p> <div class="cbb clearfix notitle "></p><p> <div id="article-wrapper"></p><p> <h2>{newsTitle} </h2></p><p> <div class="article-meta">Posted {newsDate}</div></p><p></p><p> <p class="summary">{newsTitle}</p></p><p> <div class="article-body"></p><p> {newsContent}</p><p> </p><p> </p><p> <script type="text/javascript" language="Javascript"></p><p> document.observe("dom:loaded", function() {</p><p> $$('.article-images a').each(function(a) {</p><p> Event.observe(a, 'click', function(e) {</p><p> Event.stop(e);</p><p> Overlay.lightbox(a.href, "Image is loading");</p><p> });</p><p> });</p><p> </p><p> $$('a.article-2729').each(function(a) {</p><p> a.replace(a.innerHTML);</p><p> });</p><p> });</p><p> </script></p><p> </div></p><p> </div></p><p> </div></p><p> </div></p><p> </p><p> </p><p><?php</p><p></p><p></p><p>if(isset($_POST['post_comment']))</p><p> $posted_on = date("M j, Y g:i A");</p><p></p><p>if (empty($_POST['comment']))</p><p>$_POST['comment'] = '';</p><p></p><p>$comment = strip_tags (filter($_POST['comment']));</p><p>if($comment == NULL){</p><p> //define("ERROR", "You have to type in a reply!<br /><br />");</p><p> //$error_message = 'You have to type in a reply!<br /><br />';</p><p> }else{</p><p>if (isLogged)</p><p>{</p><p> 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());</p><p> define('SUCCESS', 'You have successfully posted a comment on this news article!');</p><p></p><p></p><p> define("ERROR", "<br>Thanks for your reply!<br />");</p><p></p><p> //$error_message = 'Thanks for your reply!<br /><br />';</p><p> }</p><p>}</p><p>?></p><p></p><p><div class="habblet-container "></p><p><div class="cbb clearfix notitle "></p><p><div id="article-wrapper"><h2>Place Comment</h2></p><p><div class="article-meta"></div></p><p><div class="article-body"></p><p><?php</p><p>$userPosts = mysql_query("SELECT * FROM cms_comments WHERE article = '".htmlentities(mysql_real_escape_string($_GET['id']))."' AND userid = '" . $_SESSION['user']['id']. "'");</p><p>$postNum = mysql_num_rows($userPosts);</p><p>if($postNum >= 1)</p><p>{</p><p> define('ERROR', 'Sorry, you are only allowed one comment per article.');</p><p>}</p><p>if(defined("SUCCESS")){</p><p>?></p><p><div class="rounded rounded-green" width="20%"></p><p> <?php echo SUCCESS; ?><br /></p><p> </div></p><p> <div>&nbsp;</div></p><p><?php</p><p>}</p><p>if(defined("ERROR")) {</p><p>?></p><p><div class="rounded rounded-red" width="20%"></p><p> <?php echo ERROR; ?><br /></p><p> </div></p><p> <div>&nbsp;</div></p><p><?php</p><p>}</p><p>else</p><p>{</p><p>?></p><p><form action="" method="post"></p><p><textarea name="comment" maxlength="500"></textarea><br /><br /></p><p><input type="submit" name="post_comment" value="Place Comment" /></p><p></form></p><p><?php</p><p>}</p><p>?></p><p></div></p><p></div></p><p></div></p><p></div></p><p></p><p><style type="text/css"></p><p>input[type="text"], input[type="password"] {</p><p>background-color: #F1F1F1;</p><p>border: 1px solid #999999;</p><p>width: 175px;</p><p>padding: 5px;</p><p>font-family: verdana;</p><p>font-size: 10px;</p><p>color: #666666;</p><p>}</p><p>input[type="submit"] {</p><p>background-color: #F1F1F1;</p><p>border: 1px solid #999999;</p><p>padding: 5px;</p><p>font-family: verdana;</p><p>font-size: 10px;</p><p>color: #666666;</p><p>}</p><p>textarea {</p><p>background-color: #F1F1F1;</p><p>border: 1px solid #999999;</p><p>padding: 5px;</p><p>width: 517px;</p><p>height: 70px;</p><p>font-family: verdana;</p><p>font-size: 10px;</p><p>color: #666666;</p><p>}</p><p>select {</p><p>background-color: #F1F1F1;</p><p>border: 1px solid #999999;</p><p>padding: 5px;</p><p>font-family: verdana;</p><p>font-size: 10px;</p><p>color: #666666;</p><p>}</p><p></style></p><p><?php</p><p>$getComments = mysql_query("SELECT * FROM cms_comments WHERE article = '".filter($_GET['id'])."' ORDER by id DESC");</p><p>?></p><p><div class="habblet-container "></p><p><div class="cbb clearfix notitle "></p><p><div id="article-wrapper"><h2>Comments <?php echo mysql_num_rows($getComments); ?></h2></p><p><div class="article-meta"></div></p><p><div class="article-body"></p><p><?php</p><p> if(mysql_num_rows($getComments) == 0) {</p><p> echo "No comments for this article!";</p><p> } else {</p><p> echo '<table width="528px">';</p><p> while($Comments = mysql_fetch_array($getComments)){</p><p> $getUserInfo = mysql_query("SELECT * FROM users WHERE username = '".$Comments['author']."'");</p><p> $userInfo = mysql_fetch_array($getUserInfo);</p><p> echo '</p><p> <tr></p><p> <td width="90px" valign="top"></div></p><p> <div style="</p><p>height: 65px;</p><p>width: 50px;</p><p>float: left;</p><p>overflow: hidden;</p><p>"></p><p> <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></p><p> ';</p><p> if($userInfo['rank'] >= 5) {</p><p> echo '<div style="position: absolute; z-index:1"><img src="{url}/r63/c_images/album1584/ADM.gif"></div>';</p><p> }</p><p> if($userInfo['rank'] == 3) {</p><p> echo '<div style="position: absolute; z-index:1"><img src="{url}/r63/c_images/badges/XXX.gif"></div>';</p><p> }</p><p> if($userInfo['rank'] == 4) {</p><p> echo '<div style="position: absolute; z-index:1"><img src="{url}/r63/c_images/badges/XXX.gif"></div>';</p><p> }</p><p> if($userInfo['rank'] == 2) {</p><p> echo '<div style="position: absolute; z-index:1"><img src="{url}/r63/c_images/badges/VIP.gif"></div>';</p><p> }</p><p> if($userInfo['rank'] == 1) {</p><p> echo '<div style="position: absolute; z-index:1"><img src="{url}/lid.png"></div>';</p><p> }</p><p> </p><p></p><p> echo '</p><p></p><p> </td></p><p> <td width="427px" valign="top"></p><p> <i><a href="/me">'.$userInfo['username'].' </a></i></p><p> <br /><br />'.$Comments['comment'].'</p><p> </p><p></p><p> </td></p><p> </tr></p><p> <tr></p><p> <td width="80px" valign="top"></p><p> </p><p> </td></p><p> <td width="400px" align="right"></p><p></p><p> </p><p> </p><p></p><p> </p><p></p><p></div></div></div></div></p><p><br></p><p><div style="width:125%; height:1px; background-color:#ccc; margin-top:-17px;"></div></p><p></p><p></p><p> </td></p><p> </tr>';</p><p> }</p><p> echo '</table>';</p><p> }</p><p> ?></div> </div> </div> </div></p><p></div></p><p></div></p><p></div></p><p></div></p><p></p><p> <script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script></p><p> <script type="text/javascript"></p><p> HabboView.run();</p><p> </script></p><p></p><p> <!--[if lt IE 7]></p><p> <script type="text/javascript"></p><p> Pngfix.doPngImageFix();</p><p> </script></p><p> <![endif]--></p><p></p><p></p><p> <div id="footer" ></p><p> <?php include "app/tpl/skins/Habbo/inc/footer.php"; ?></p><p> </div></p><p></p><p> </body></p><p></html>[/PHP]</p><p></p><p>[HTML]-- ----------------------------</p><p>-- Table structure for `cms_comments`</p><p>-- ----------------------------</p><p>DROP TABLE IF EXISTS `cms_comments`;</p><p>CREATE TABLE `cms_comments` (</p><p> `id` int(6) NOT NULL AUTO_INCREMENT,</p><p> `story` int(6) DEFAULT NULL,</p><p> `comment` text NOT NULL,</p><p> `date` int(10) DEFAULT NULL,</p><p> `author` varchar(999) NOT NULL,</p><p> `article` int(9) NOT NULL,</p><p> `userid` int(11) NOT NULL,</p><p> `posted_on` varchar(50) NOT NULL,</p><p> PRIMARY KEY (`id`)</p><p>) ENGINE=InnoDB AUTO_INCREMENT=94 DEFAULT CHARSET=utf8;</p><p></p><p>[/HTML]</p><p></p><p></p><p></p><p></p><p>Screenshots:</p><p><img src="http://i.sharefa.st/eEliIzZBj6i0.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></p><p></p><p>Credits:</p><p>Sledmore: Cleaning up the exploits.</p><p>Holmes: Pin pointing error.</p><p>Me: Putting this all together and making it work for everyone and SQL! Hope this helps!</p><p>v1.2 working with sledmores housekeeping.</p><p><a href="http://devbest.com/threads/release-sledmores-ase-news-comment-editor.33795/" target="_blank">http://devbest.com/threads/release-sledmores-ase-news-comment-editor.33795/</a></p><p>v2.0</p><p>W/ Removed some unused code, fixed to where only one comment per user. (Not tested)</p></blockquote><p></p>
[QUOTE="Kristopher, post: 176583, member: 1958"] [SIZE=4]Some of the forum members put something together for you RevCMS users. [/SIZE] [PHP]<!DOCTYPE html> <html lang="en"> <head> <meta http-equiv="content-type" content="text/html; charset=utf-8"> <title>{hotelName} - News</title> <div id="fb-root"></div> <script>(function(d, s, id) { var js, fjs = d.getElementsByTagName(s)[0]; if (d.getElementById(id)) return; js = d.createElement(s); js.id = id; js.src = "//connect.facebook.net/en_US/all.js#xfbml=1&appId=138881106159184"; fjs.parentNode.insertBefore(js, fjs); }(document, 'script', 'facebook-jssdk'));</script> <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> <body id="news"> <div id="overlay"></div> <div id="header-container"> <div id="header" class="clearfix"> <h1><a href="http://shockhotel.com/"></a></h1> <div id="subnavi"> <div id="subnavi-user"> <ul> <li id="myfriends"><a href="#"><span>My Friends</span></a><span class="r"></span></li> <li id="mygroups"><a href="#"><span>My Groups</span></a><span class="r"></span></li> <li id="myrooms"><a href="#"><span>My Rooms</span></a><span class="r"></span></li> </ul> </div> <div id="subnavi-search"> <div id="subnavi-search-upper"> <ul id="subnavi-search-links"> <u><li><a href="http://shockhotel.com/logout" style="color:#000">Logout</a></li></u> </ul> </div> </div> <div id="to-hotel"> <a href="{url}/api.php" class="new-button green-button" target="eac955c8dbc88172421193892a3e98fc7402021a" onclick="HabboClient.openOrFocus(this); return false;"><b>Enter Strike Hotel</b><i></i></a> </div> </div> <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><a href="{url}/vip">VIP</a><span></span></li> <li><a href="{url}/404">Coming Soon! ({vip_points}p)</a><span></span></li> </ul> <div id="habbos-online"> <div id="content"> <div class="cbb "> <span>{online} members online</span></div> </div> </div> </div> </div> </div> <?php if( $_GET['id'] ) { $query = mysql_query( "SELECT * FROM `cms_news` WHERE id = '".filter($_GET['id'])."'"); $array = mysql_fetch_assoc( $query ); } ?> <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">☆ News☆</li> <li><a href="{url}/staff">Staff</a></li> <li><a href="{url}/topstats">Top User Stats</a></li> <li class=" last"><a href="{url}/expert">eXperts</a></li> </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 red "> <h2 class="title">News</h2> <div id="article-archive"> <ul> {newsList} </ul> </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} <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> <?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 >= 1) { define('ERROR', 'Sorry, you are only allowed one comment per article.'); } if(defined("SUCCESS")){ ?> <div class="rounded rounded-green" width="20%"> <?php echo SUCCESS; ?><br /> </div> <div> </div> <?php } if(defined("ERROR")) { ?> <div class="rounded rounded-red" width="20%"> <?php echo ERROR; ?><br /> </div> <div> </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>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 "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 '<div style="position: absolute; z-index:1"><img src="{url}/r63/c_images/album1584/ADM.gif"></div>'; } if($userInfo['rank'] == 3) { echo '<div style="position: absolute; z-index:1"><img src="{url}/r63/c_images/badges/XXX.gif"></div>'; } if($userInfo['rank'] == 4) { echo '<div style="position: absolute; z-index:1"><img src="{url}/r63/c_images/badges/XXX.gif"></div>'; } if($userInfo['rank'] == 2) { echo '<div style="position: absolute; z-index:1"><img src="{url}/r63/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:125%; 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> </body> </html>[/PHP] [HTML]-- ---------------------------- -- Table structure for `cms_comments` -- ---------------------------- DROP TABLE IF EXISTS `cms_comments`; CREATE TABLE `cms_comments` ( `id` int(6) NOT NULL AUTO_INCREMENT, `story` int(6) DEFAULT NULL, `comment` text NOT NULL, `date` int(10) DEFAULT NULL, `author` varchar(999) NOT NULL, `article` int(9) NOT NULL, `userid` int(11) NOT NULL, `posted_on` varchar(50) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=94 DEFAULT CHARSET=utf8; [/HTML] Screenshots: [IMG]http://i.sharefa.st/eEliIzZBj6i0.png[/IMG] Credits: Sledmore: Cleaning up the exploits. Holmes: Pin pointing error. Me: Putting this all together and making it work for everyone and SQL! Hope this helps! v1.2 working with sledmores housekeeping. [URL]http://devbest.com/threads/release-sledmores-ase-news-comment-editor.33795/[/URL] v2.0 W/ Removed some unused code, fixed to where only one comment per user. (Not tested) [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
Server Development
Habbo Retros
Habbo Releases
CMS Releases
RevCMS Working News Comments!
Top