Reply to thread

Message

<blockquote data-quote="Kristopher" data-source="post: 216456" data-attributes="member: 1958">Sledmores housekeeping editor.[CODE]&lt;?php $pagerank = 7; include &quot;templates/header.php&quot;; ?&gt;&nbsp;&nbsp; &nbsp; &lt;div id=&quot;site_content&quot;&gt;&nbsp; &nbsp; &lt;?php include &quot;templates/sidebar.php&quot;; ?&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;div id=&quot;content_container&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div id=&quot;content&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;h1&gt;{hotelName} Hotel ASE :: News Comments&lt;/h1&gt;&lt;hr/&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;?php&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (isset($_GET['edit']) &amp;&amp; $_GET['edit'] != null)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $two = mysql_fetch_assoc(mysql_query(&quot;SELECT * FROM cms_comments WHERE article = '&quot; . filter($_GET['edit']) . &quot;'&quot;));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ?&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;?php&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($_GET['delete'])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(mysql_num_rows(mysql_query(&quot;SELECT * FROM cms_comments WHERE id = '&quot;.filter($_GET['delete']).&quot;'&quot;)))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mysql_query(&quot;DELETE FROM cms_comments WHERE id = '&quot;.filter($_GET['delete']).&quot;'&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;div class=&quot;alert alert-success&quot; align=&quot;center&quot;&gt;That comment has now been deleted!&lt;/div&gt;';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;div class=&quot;alert alert-error&quot; align=&quot;center&quot;&gt;Couldn\'t find that comment, sorry!&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; &nbsp; &nbsp; ?&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;table class=&quot;table table-striped table-bordered table-condensed&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td&gt;&lt;b&gt;User&lt;/b&gt;&lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td&gt;&lt;b&gt;Comment&lt;/b&gt;&lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td&gt;&lt;b&gt;Action&lt;/b&gt;&lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;?php&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $getArticles = mysql_query(&quot;SELECT * FROM `cms_comments` WHERE `article` = '&quot;.filter($_GET['edit']).&quot;'&quot;);&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while(($articles = mysql_fetch_array($getArticles)))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $getUserInfo = mysql_query(&quot;SELECT * FROM users WHERE id = '&quot;.$articles['userid'].&quot;'&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $userInfo = mysql_fetch_array($getUserInfo);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td&gt;&lt;a href='?url=player_edit&amp;username=&quot;.$userInfo['username'].&quot;'&gt;&quot; . $userInfo['username'] .&quot;&lt;/a&gt;&lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td&gt;&quot; . $articles['comment'] .&quot;&lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td&gt;&lt;a href='?url=logs_news_comments&amp;edit=&quot;.$articles['article'].&quot;&amp;delete=&quot; . $articles['id'] . &quot;'&gt;&lt;b&gt;Delete&lt;/b&gt;&lt;/a&gt;&lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/tr&gt;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ?&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/table&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;?php&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ?&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;table class=&quot;table table-striped table-bordered table-condensed&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td&gt;&lt;b&gt;Article&lt;/b&gt;&lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td&gt;&lt;b&gt;View Comments&lt;/b&gt;&lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;?php&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $getArticles = mysql_query(&quot;SELECT * FROM `cms_news`&quot;);&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while(($articles = mysql_fetch_array($getArticles)))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td&gt;&quot; . $articles['title'] .&quot;&lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td&gt;&lt;a href='?url=logs_news_comments&amp;edit=&quot;.$articles['id'].&quot;'&gt;&lt;b&gt;View comments&lt;/b&gt;&lt;/a&gt;&lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/tr&gt;&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; ?&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/table&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &lt;/div&gt;&lt;/div&gt;&lt;?php include &quot;templates/footer.php&quot;; ?&gt;[/CODE]&nbsp;Changed a few querys so it works with my release:<a href="http://devbest.com/threads/revcms-working-news-comments.27532/" target="_blank">http://devbest.com/threads/revcms-working-news-comments.27532/</a>&nbsp;The housekeeping if you don't have:<a href="http://devbest.com/threads/1-x-x-housekeeping-release.24211/" target="_blank">http://devbest.com/threads/1-x-x-housekeeping-release.24211/</a>&nbsp;Credits:SledmoreStoner (Me)KryptosHejulaHolmes</blockquote>

[QUOTE="Kristopher, post: 216456, member: 1958"] Sledmores housekeeping editor. [CODE]<?php $pagerank = 7; include "templates/header.php"; ?> <div id="site_content"> <?php include "templates/sidebar.php"; ?> <div id="content_container"> <div id="content"> <h1>{hotelName} Hotel ASE :: News Comments</h1><hr/> <?php if (isset($_GET['edit']) && $_GET['edit'] != null) { $two = mysql_fetch_assoc(mysql_query("SELECT * FROM cms_comments WHERE article = '" . filter($_GET['edit']) . "'")); ?> <?php if($_GET['delete']) { if(mysql_num_rows(mysql_query("SELECT * FROM cms_comments WHERE id = '".filter($_GET['delete'])."'"))) { mysql_query("DELETE FROM cms_comments WHERE id = '".filter($_GET['delete'])."'"); echo '<div class="alert alert-success" align="center">That comment has now been deleted!</div>'; } else { echo '<div class="alert alert-error" align="center">Couldn\'t find that comment, sorry!</div>'; } } ?> <table class="table table-striped table-bordered table-condensed"> <tr> <td>User</td> <td>Comment</td> <td>Action</td> </tr> <?php $getArticles = mysql_query("SELECT * FROM `cms_comments` WHERE `article` = '".filter($_GET['edit'])."'"); while(($articles = mysql_fetch_array($getArticles))) { $getUserInfo = mysql_query("SELECT * FROM users WHERE id = '".$articles['userid']."'"); $userInfo = mysql_fetch_array($getUserInfo); echo " <tr> <td><a href='?url=player_edit&username=".$userInfo['username']."'>" . $userInfo['username'] ."</a></td> <td>" . $articles['comment'] ."</td> <td><a href='?url=logs_news_comments&edit=".$articles['article']."&delete=" . $articles['id'] . "'>Delete</a></td> </tr>"; } ?> </table> <?php } else { ?> <table class="table table-striped table-bordered table-condensed"> <tr> <td>Article</td> <td>View Comments</td> </tr> <?php $getArticles = mysql_query("SELECT * FROM `cms_news`"); while(($articles = mysql_fetch_array($getArticles))) { echo " <tr> <td>" . $articles['title'] ."</td> <td><a href='?url=logs_news_comments&edit=".$articles['id']."'>View comments</a></td> </tr>"; } } ?> </table> </div> </div> </div> </div> <?php include "templates/footer.php"; ?>[/CODE] Changed a few querys so it works with my release: [URL]http://devbest.com/threads/revcms-working-news-comments.27532/[/URL] The housekeeping if you don't have: [URL]http://devbest.com/threads/1-x-x-housekeeping-release.24211/[/URL] Credits: Sledmore Stoner (Me) Kryptos Hejula Holmes [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members