Reply to thread

Message

<blockquote data-quote="HabboRetroHelper1" data-source="post: 371743" data-attributes="member: 27792">This is my Post Comment PHP CODE[CODE]&lt;?phpif(isset($_POST['post_comment']))&nbsp; $posted_on = date(&quot;M j, Y g:i A&quot;);if (empty($_POST['comment']))$_POST['comment'] = '';$comment = strip_tags (filter($_POST['comment']));if($comment == NULL){&nbsp; &nbsp; &nbsp; &nbsp; //define(&quot;ERROR&quot;, &quot;You have to type in a reply!&lt;br /&gt;&lt;br /&gt;&quot;);&nbsp; &nbsp; //$error_message = 'You have to type in a reply!&lt;br /&gt;&lt;br /&gt;';&nbsp; }else{if (isLogged){&nbsp; mysql_query(&quot;INSERT INTO cms_comments (article, userid, comment, posted_on, author) VALUES ('&quot;.filter($_GET['id']).&quot;', '&quot;.$_SESSION['user']['id'].&quot;', '&quot;.filter($comment).&quot;', '&quot;.$posted_on.&quot;', '&quot; . $_SESSION['user']['username']. &quot;');&quot;) or die(mysql_error());&nbsp; &nbsp; define('SUCCESS', 'You have successfully posted a comment on this news article!');&nbsp; &nbsp; define(&quot;ERROR&quot;, &quot;&lt;br&gt;Thanks for your reply!&lt;br /&gt;&quot;);&nbsp; &nbsp; &nbsp; &nbsp; //$error_message = 'Thanks for your reply!&lt;br /&gt;&lt;br /&gt;';&nbsp; }}?&gt;&lt;div class=&quot;habblet-container &quot;&gt;&lt;div class=&quot;cbb clearfix notitle &quot;&gt;&lt;div id=&quot;article-wrapper&quot;&gt;&lt;h2&gt;Place Comment&lt;/h2&gt;&lt;div class=&quot;article-meta&quot;&gt;&lt;/div&gt;&lt;div class=&quot;article-body&quot;&gt;&lt;?phpif($userPosts &gt;= 1){&nbsp; &nbsp; define('ERROR', 'Sorry, you are only allowed one comment per article.');}if(defined(&quot;SUCCESS&quot;)){?&gt;&lt;div class=&quot;rounded rounded-green&quot; width=&quot;20%&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;?php echo SUCCESS; ?&gt;&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div&gt;&amp;nbsp;&lt;/div&gt;&lt;?php}if(defined(&quot;ERROR&quot;)) {?&gt;&lt;div class=&quot;rounded rounded-red&quot; width=&quot;20%&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;?php echo ERROR; ?&gt;&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div&gt;&amp;nbsp;&lt;/div&gt;&lt;?php}else{?&gt;&lt;form action=&quot;&quot; method=&quot;post&quot;&gt;&lt;textarea name=&quot;comment&quot; maxlength=&quot;500&quot;&gt;&lt;/textarea&gt;&lt;br /&gt;&lt;br /&gt;&lt;input type=&quot;submit&quot; name=&quot;post_comment&quot; value=&quot;Place Comment&quot; /&gt;&lt;/form&gt;&lt;?php}?&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;style type=&quot;text/css&quot;&gt;input[type=&quot;text&quot;], input[type=&quot;password&quot;] {background-color: #F1F1F1;border: 1px solid #999999;width: 175px;padding: 5px;font-family: verdana;font-size: 10px;color: #666666;}input[type=&quot;submit&quot;] {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;}&lt;/style&gt;&lt;?php$getComments = mysql_query(&quot;SELECT * FROM cms_comments WHERE article = '&quot;.filter($_GET['id']).&quot;' ORDER by id DESC&quot;);?&gt;&lt;div class=&quot;habblet-container &quot;&gt;&lt;div class=&quot;cbb clearfix notitle &quot;&gt;&lt;div id=&quot;article-wrapper&quot;&gt;&lt;h2&gt;Comments &lt;?php echo mysql_num_rows($getComments); ?&gt;&lt;/h2&gt;&lt;div class=&quot;article-meta&quot;&gt;&lt;/div&gt;&lt;div class=&quot;article-body&quot;&gt;&lt;?php&nbsp; &nbsp; &nbsp; if(mysql_num_rows($getComments) == 0) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;No comments for this article!&quot;;&nbsp; &nbsp; &nbsp; } else {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;table width=&quot;528px&quot;&gt;';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while($Comments = mysql_fetch_array($getComments)){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $getUserInfo = mysql_query(&quot;SELECT * FROM users WHERE username = '&quot;.$Comments['author'].&quot;'&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $userInfo = mysql_fetch_array($getUserInfo);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo '&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;90px&quot; valign=&quot;top&quot;&gt;&lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div style=&quot;height: 65px;width: 50px;float: left;overflow: hidden;&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div style=&quot;float:left&quot;&gt;&lt;img position:absolute; src=&quot;http://www.habbo.nl/habbo-imaging/avatarimage?figure='.$userInfo['look'].'&amp;size=b&amp;direction=2&amp;head_direction=3&amp;gesture=sml&amp;size=2&quot;&gt;&lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($userInfo['rank'] &gt;= 4) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;div style=&quot;position: absolute; z-index:1&quot;&gt;&lt;img src=&quot;{url}/r63/c_images/album1584/ADM.gif&quot;&gt;&lt;/div&gt;';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($userInfo['rank'] == 2) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;div style=&quot;position: absolute; z-index:1&quot;&gt;&lt;img src=&quot;{url}/r63/c_images/album1584/VIP.gif&quot;&gt;&lt;/div&gt;';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($userInfo['rank'] == 1) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;div style=&quot;position: absolute; z-index:1&quot;&gt;&lt;img src=&quot;&quot;&gt;&lt;/div&gt;';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo '&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;427px&quot; valign=&quot;top&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;i&gt;&lt;a href=&quot;/me&quot;&gt;'.$userInfo['username'].' &lt;/a&gt;&lt;/i&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;br /&gt;&lt;br /&gt;'.$Comments['comment'].'&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;80px&quot; valign=&quot;top&quot;&gt;&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;400px&quot; align=&quot;right&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;br&gt;&lt;div style=&quot;width:125%; height:1px; background-color:#ccc; margin-top:-17px;&quot;&gt;&lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/tr&gt;';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;/table&gt;';&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; ?&gt;&lt;/div&gt; &lt;/div&gt; &lt;/div&gt; &lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;[/CODE]Run this SQL [CODE]DROP TABLE IF EXISTS `cms_comments`;CREATE TABLE `cms_comments` (&nbsp; `id` int(6) NOT NULL AUTO_INCREMENT,&nbsp; `story` int(6) DEFAULT NULL,&nbsp; `comment` text NOT NULL,&nbsp; `date` int(10) DEFAULT NULL,&nbsp; `author` varchar(999) NOT NULL,&nbsp; `article` int(9) NOT NULL,&nbsp; `userid` int(11) NOT NULL,&nbsp; `posted_on` varchar(50) NOT NULL,&nbsp; PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8;[/CODE]You may need to deleted cms_comments..... For other uses if i said anything wrong just correct me <img src="/styles/default/xenforo/smilies/emojione/smile.png"&nbsp; class="smilie" loading="lazy" alt=":)" title="Smile&nbsp; &nbsp; :)" data-shortname=":)" /></blockquote>

[QUOTE="HabboRetroHelper1, post: 371743, member: 27792"] This is my Post Comment PHP CODE [CODE]<?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! "); //$error_message = 'You have to type in a reply! '; }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", " Thanks for your reply! "); //$error_message = 'Thanks for your reply! '; } } ?> <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 if($userPosts >= 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; ?> </div> <div> </div> <?php } if(defined("ERROR")) { ?> <div class="rounded rounded-red" width="20%"> <?php echo ERROR; ?> </div> <div> </div> <?php } else { ?> <form action="" method="post"> <textarea name="comment" maxlength="500"></textarea> <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'] >= 4) { echo '<div style="position: absolute; z-index:1"><img src="{url}/r63/c_images/album1584/ADM.gif"></div>'; } if($userInfo['rank'] == 2) { echo '<div style="position: absolute; z-index:1"><img src="{url}/r63/c_images/album1584/VIP.gif"></div>'; } if($userInfo['rank'] == 1) { echo '<div style="position: absolute; z-index:1"><img src=""></div>'; } echo ' </td> <td width="427px" valign="top"> <a href="/me">'.$userInfo['username'].' </a> '.$Comments['comment'].' </td> </tr> <tr> <td width="80px" valign="top"> </td> <td width="400px" align="right"> </div></div></div></div> <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>[/CODE] Run this SQL [CODE] 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=101 DEFAULT CHARSET=utf8; [/CODE] You may need to deleted cms_comments..... For other uses if i said anything wrong just correct me :) [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members