Reply to thread

Message

<blockquote data-quote="emo-nemo-321" data-source="post: 67414" data-attributes="member: 11618">Hi devbest, usualy ive been seeing that people want the news comment sytem, but cant find it..Well, here you go! ENJOY!&nbsp;Ok, first off, open up your localhost/phpmyadmin and go to the SQL inject tab (after youve picked your DB, lol)Put this code in:[CODE]CREATE TABLE IF NOT EXISTS `site_news_comments` (&nbsp;&nbsp; `id` int(11) NOT NULL AUTO_INCREMENT,&nbsp;&nbsp; `article` int(11) NOT NULL,&nbsp;&nbsp; `userid` int(11) NOT NULL,&nbsp;&nbsp; `comment` varchar(500) NOT NULL,&nbsp;&nbsp; `posted_on` varchar(150) NOT NULL DEFAULT '',&nbsp;&nbsp; PRIMARY KEY (`id`)&nbsp;) ENGINE=MyISAM&nbsp; DEFAULT CHARSET=latin1 AUTO_INCREMENT=294 ;&nbsp; [/CODE]Great now thats done so open up your Comp-newsarticle.tpl and replace EVERYTHING with this:[PHP]&lt;?php$_SESSION['id'] = $users-&gt;GetUserVar(USER_ID, 'id');?&gt;&lt;div class=&quot;habblet-container &quot;&gt;&lt;div class=&quot;cbb clearfix notitle &quot;&gt;&nbsp;&nbsp; &nbsp; &lt;div id=&quot;article-wrapper&quot;&gt;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &lt;h2&gt;%news_article_title%&lt;/h2&gt;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &lt;div class=&quot;article-meta&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;?php if ($news_article_id &gt; 0) { ?&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; %news_article_date%&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; %news_category%&nbsp; &nbsp; &nbsp; &nbsp; &lt;?php } ?&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &lt;?php if (strlen(trim($news_article_summary)) &gt; 0) { ?&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;p class=&quot;summary&quot;&gt;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; %news_article_summary%&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &lt;/p&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;?php } ?&gt;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &lt;div class=&quot;article-body&quot;&gt;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; %news_article_body%&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &lt;?php if ($news_article_id &gt; 0) { ?&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;script type=&quot;text/javascript&quot; language=&quot;Javascript&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; document.observe(&quot;dom:loaded&quot;, function() {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $$('.article-images a').each(function(a) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Event.observe(a, 'click', function(e) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Event.stop(e);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Overlay.lightbox(a.href, &quot;Image is loading&quot;);&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; $$('a.article-%news_article_id%').each(function(a) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; a.replace(a.innerHTML);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; });&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; });&nbsp; &nbsp; &nbsp; &nbsp; &lt;/script&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;?php } ?&gt;&nbsp;&nbsp; &nbsp; &lt;/div&gt;&nbsp;&lt;/div&gt;&lt;/div&gt;&lt;?phpif(isset($_POST['post_comment']))&nbsp; $posted_on = date(&quot;M j, Y g:i A&quot;);if (! isset($_POST['comment'])) {&nbsp; $_POST['comment'] = '';&nbsp; // nu bestaat de variabele ten minste}&nbsp;$comment = strip_tags ($_POST['comment']);if($comment == NULL){&nbsp; &nbsp; $error_message = 'You have left a field empty.&lt;br /&gt;&lt;br /&gt;';&nbsp; }else{if (LOGGED_IN){&nbsp; &nbsp; mysql_query(&quot;INSERT INTO site_news_comments (article, userid, comment, posted_on) VALUES ('&quot;.&nbsp;$news_article_id.&quot;', '&quot;.$_SESSION['id'].&quot;', '&quot;.$comment.&quot;', '&quot;.$posted_on.&quot;');&quot;);&nbsp; &nbsp; $error_message = 'You have successfully left a comment.&lt;br /&gt;&lt;br /&gt;';&nbsp; }}?&gt;&nbsp;&lt;div class=&quot;habblet-container &quot;&gt;&nbsp; &lt;div class=&quot;cbb clearfix notitle &quot;&gt;&nbsp; &nbsp; &lt;div id=&quot;article-wrapper&quot;&gt;&lt;h2&gt;Post a comment!&lt;/h2&gt;&nbsp; &nbsp; &nbsp; &lt;div class=&quot;article-meta&quot;&gt;&lt;/div&gt;&nbsp; &nbsp; &nbsp; &lt;div class=&quot;article-body&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;form action=&quot;&quot; method=&quot;post&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;textarea name=&quot;comment&quot; maxlength=&quot;500&quot;&gt;&lt;/textarea&gt;&lt;br /&gt;&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;submit&quot; name=&quot;post_comment&quot; value=&quot;Post a comment!&quot; /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;/form&gt;&nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &lt;/div&gt;&nbsp; &lt;/div&gt;&lt;/div&gt;&lt;style type=&quot;text/css&quot;&gt;input[type=&quot;text&quot;], input[type=&quot;password&quot;] {&nbsp; background-color: #F1F1F1;&nbsp; border: 1px solid #999999;&nbsp; width: 175px;&nbsp; padding: 5px;&nbsp; font-family: verdana;&nbsp; font-size: 10px;&nbsp; color: #666666;}input[type=&quot;submit&quot;] {&nbsp; background-color: #F1F1F1;&nbsp; border: 1px solid #999999;&nbsp; padding: 5px;&nbsp; font-family: verdana;&nbsp; font-size: 10px;&nbsp; color: #666666;}textarea {&nbsp; background-color: #F1F1F1;&nbsp; border: 1px solid #999999;&nbsp; padding: 5px;&nbsp; width: 517px;&nbsp; height: 70px;&nbsp; font-family: verdana;&nbsp; font-size: 10px;&nbsp; color: #666666;}select {&nbsp; background-color: #F1F1F1;&nbsp; border: 1px solid #999999;&nbsp; padding: 5px;&nbsp; font-family: verdana;&nbsp; font-size: 10px;&nbsp; color: #666666;}&lt;/style&gt;&lt;?php$getComments = mysql_query(&quot;SELECT * FROM site_news_comments WHERE article = '&quot;.$news_article_id.&quot;' ORDER by&nbsp;id DESC&quot;);?&gt;&lt;div class=&quot;habblet-container &quot;&gt;&nbsp; &lt;div class=&quot;cbb clearfix notitle &quot;&gt;&nbsp; &nbsp; &lt;div id=&quot;article-wrapper&quot;&gt;&lt;h2&gt;Comments (&lt;?php echo mysql_num_rows($getComments); ?&gt;)&lt;/h2&gt;&nbsp; &nbsp; &nbsp; &lt;div class=&quot;article-meta&quot;&gt;&lt;/div&gt;&nbsp; &nbsp; &nbsp; &lt;div class=&quot;article-body&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;?php&nbsp; &nbsp; &nbsp; &nbsp; if(mysql_num_rows($getComments) == 0){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo 'Sorry, er zijn nog geen Reacties geplaatst!';&nbsp; &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 id = '&quot;.$Comments['userid'].&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;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div style=&quot;float:left&quot;&gt;&lt;img src=&quot;http://www.habbo.com/habbo-imaging/avatarimage?&nbsp;figure='.$userInfo['look'].'&amp;size=b&amp;direction=2&amp;head_direction=3&amp;gesture=sml&amp;size=s&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; if($userInfo['rank'] &gt; 8){&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&nbsp;src=&quot;http://www.ferbo.nl/c_images/album1584/AD1.gif&quot;&gt;&lt;/div&gt;';&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; &nbsp; &lt;strong&gt;RE: %news_article_title%&lt;/strong&gt;&lt;br /&gt;&lt;br /&gt;'.$Comments['comment'].'&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;90px&quot; valign=&quot;top&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;427px&quot; align=&quot;right&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;i&gt;Posted by: &lt;strong&gt;&lt;a href=&quot;#&quot;&gt;'.$userInfo['username'].'&lt;/a&gt;&lt;/strong&gt;&nbsp; On '.$Comments&nbsp;['posted_on'].'&lt;/i&gt;&lt;br /&gt;&lt;br /&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;&nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &lt;/div&gt;&nbsp; &lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;script type=&quot;text/javascript&quot;&gt;if (!$(document.body).hasClassName('process-template')) {&nbsp;Rounder.init(); }&lt;/script&gt;[/PHP]There you go! <img src="/styles/default/xenforo/smilies/emojione/biggrin.png"&nbsp; class="smilie" loading="lazy" alt=":D" title="Big Grin&nbsp; &nbsp; :D" data-shortname=":D" />====================================================================Screenie:<a href="http://prntscr.com/5epaj" target="_blank">http://prntscr.com/5epaj</a>Credis to Yabsoon from ******* Forums</blockquote>

[QUOTE="emo-nemo-321, post: 67414, member: 11618"] Hi devbest, usualy ive been seeing that people want the news comment sytem, but cant find it.. Well, here you go! ENJOY! Ok, first off, open up your localhost/phpmyadmin and go to the SQL inject tab (after youve picked your DB, lol) Put this code in: [CODE]CREATE TABLE IF NOT EXISTS `site_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=294 ; [/CODE] Great now thats done so open up your Comp-newsarticle.tpl and replace [B][U]EVERYTHING[/U][/B] with this: [PHP]<?php $_SESSION['id'] = $users->GetUserVar(USER_ID, 'id'); ?> <div class="habblet-container "> <div class="cbb clearfix notitle "> <div id="article-wrapper"> <h2>%news_article_title%</h2> <div class="article-meta"> <?php if ($news_article_id > 0) { ?> %news_article_date% %news_category% <?php } ?> </div> <?php if (strlen(trim($news_article_summary)) > 0) { ?> %news_article_summary% <?php } ?> <div class="article-body"> %news_article_body% </div> <?php if ($news_article_id > 0) { ?> <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-%news_article_id%').each(function(a) { a.replace(a.innerHTML); }); }); </script> <?php } ?> </div> </div> </div> <?php if(isset($_POST['post_comment'])) $posted_on = date("M j, Y g:i A"); if (! isset($_POST['comment'])) { $_POST['comment'] = ''; // nu bestaat de variabele ten minste } $comment = strip_tags ($_POST['comment']); if($comment == NULL){ $error_message = 'You have left a field empty. '; }else{ if (LOGGED_IN) { mysql_query("INSERT INTO site_news_comments (article, userid, comment, posted_on) VALUES ('". $news_article_id."', '".$_SESSION['id']."', '".$comment."', '".$posted_on."');"); $error_message = 'You have successfully left a comment. '; } } ?> <div class="habblet-container "> <div class="cbb clearfix notitle "> <div id="article-wrapper"><h2>Post a comment!</h2> <div class="article-meta"></div> <div class="article-body"> <form action="" method="post"> <textarea name="comment" maxlength="500"></textarea> <input type="submit" name="post_comment" value="Post a comment!" /> </form> </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 site_news_comments WHERE article = '".$news_article_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, er zijn nog geen Reacties geplaatst!'; }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.com/habbo-imaging/avatarimage? figure='.$userInfo['look'].'&size=b&direction=2&head_direction=3&gesture=sml&size=s"></div> '; if($userInfo['rank'] > 8){ echo '<div style="position: absolute; z-index:1"><img src="http://www.ferbo.nl/c_images/album1584/AD1.gif"></div>'; } echo ' </td> <td width="427px" valign="top"> RE: %news_article_title% '.$Comments['comment'].' </td> </tr> <tr> <td width="90px" valign="top"> </td> <td width="427px" align="right"> Posted by: <a href="#">'.$userInfo['username'].'</a> On '.$Comments ['posted_on'].' </td> </tr>'; } echo '</table>'; } ?> </div> </div> </div> </div> </div> <script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script>[/PHP] There you go! :D ==================================================================== Screenie:[url]http://prntscr.com/5epaj[/url] Credis to Yabsoon from ******* Forums [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members