Reply to thread

Message

<blockquote data-quote="Tando" data-source="post: 271012" data-attributes="member: 8322">Ofcourse.As you can see, it says the user was banned successfully, but the ban is not added to the database.<img src="http://farbetaler.no/upload/uploads/p1.PNG" alt="" class="fr-fic fr-dii fr-draggable " style="" /><img src="http://farbetaler.no/upload/uploads/p2.PNG" alt="" class="fr-fic fr-dii fr-draggable " style="" /><img src="http://farbetaler.no/upload/uploads/p3.PNG" alt="" class="fr-fic fr-dii fr-draggable " style="" />Here's the code of the addban2.php page.[PHP]&lt;link rel=&quot;stylesheet&quot; href=&quot;{url}/app/tpl/skins/{skin}/hk/styles/global.css&quot; type=&quot;text/css&quot;&gt;&lt;div id=&quot;main&quot;&gt;&nbsp; &nbsp; &lt;div id=&quot;links&quot;&gt;&lt;/div&gt;&nbsp; &nbsp; &lt;div id=&quot;header&quot;&gt;&lt;img src=&quot;{url}/app/tpl/skins/{skin}/images/logo.png&quot; align=right style=&quot;margin-right: 480px; margin-top: 5px;&quot;&gt;&nbsp; &nbsp; &nbsp; &lt;div id=&quot;logo&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;div id=&quot;logo_text&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;!-- class=&quot;logo_colour&quot;, allows you to change the color of the logo text --&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;h1&gt;{hotelname} Housekeeping -- Welcome {username}&lt;/h1&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &lt;div id=&quot;site_content&quot;&gt;&nbsp; &nbsp; &nbsp; &lt;div id=&quot;sidebar_container&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;!-- insert your sidebar items here --&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;div class=&quot;sidebar&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class=&quot;sidebar_top&quot;&gt;&lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class=&quot;sidebar_item&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [ &lt;a href='dash'&gt;Return to Dashboard&lt;/a&gt; ] [ &lt;a href='logout'&gt;Log out&lt;/a&gt; ]&lt;br /&gt; &lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;p&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;?php if(mysql_result(mysql_query(&quot;SELECT rank FROM users WHERE id = '&quot; . $_SESSION['user']['id'] . &quot;'&quot;), 0) &gt;= 5)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; { ?&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Player Management &lt;br /&gt; &lt;img src='../app/tpl/skins/&lt;?php echo $_CONFIG['template']['style']; ?&gt;/hk/images/line.png'&gt; &lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;raquo; &lt;a href='vip'&gt;Give a user Regular VIP&lt;/a&gt; &lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;raquo; &lt;a href='edit'&gt;Edit a users account&lt;/a&gt; &lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Administration &lt;br /&gt; &lt;img src='../app/tpl/skins/&lt;?php echo $_CONFIG['template']['style']; ?&gt;/hk/images/line.png'&gt; &lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;raquo; &lt;a href='news'&gt;Post news article&lt;/a&gt;&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;raquo; &lt;a href='delnews'&gt;Delete a news article (By ID)&lt;/a&gt;&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;raquo; &lt;a href='cmdlogs'&gt;Command logs&lt;/a&gt;&lt;br /&gt;&amp;raquo; &lt;a href='motd'&gt;Change welcome message&lt;/a&gt;&lt;br /&gt;&amp;raquo; &lt;a href='empty'&gt;Empty a table&lt;/a&gt;&lt;br /&gt;&amp;raquo; &lt;a href='timer'&gt;Change the Credits &amp; Pixels timer&lt;/a&gt;&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;?php } if(mysql_result(mysql_query(&quot;SELECT rank FROM users WHERE id = '&quot; . $_SESSION['user']['id'] . &quot;'&quot;), 0) &gt;= 4) { ?&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Moderation &lt;br /&gt; &lt;img src='../app/tpl/skins/&lt;?php echo $_CONFIG['template']['style']; ?&gt;/hk/images/line.png'&gt; &lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;raquo; &lt;a href='banlist'&gt;Ban List&lt;/a&gt; &lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;raquo; &lt;a href='ip'&gt;IP lookup&lt;/a&gt; &lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;raquo; &lt;a href='unban'&gt;Unban a User&lt;/a&gt; &lt;br /&gt;&amp;raquo; &lt;a href='addban'&gt;Ban a user&lt;/a&gt;&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Badges &lt;br /&gt; &lt;img src='../app/tpl/skins/&lt;?php echo $_CONFIG['template']['style']; ?&gt;/hk/images/line.png'&gt; &lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;raquo; &lt;a href='listbadge'&gt;List badges&lt;/a&gt;&lt;br /&gt;&amp;raquo; &lt;a href='addbadge'&gt;Add a badge&lt;/a&gt;&lt;br /&gt;&amp;raquo; &lt;a href='delbadge'&gt;Delete a badge&lt;/a&gt;&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;?php } ?&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Statistics&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;img src='../app/tpl/skins/&lt;?php echo $_CONFIG['template']['style']; ?&gt;/hk/images/line.png'&gt; &lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Server Status:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {status} &lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {online} user(s) online &lt;br /&gt;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/p&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class=&quot;sidebar_base&quot;&gt;&lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &lt;div id=&quot;content_container&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;div id=&quot;content&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;!-- insert the page content here --&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;?phpinclude_once('databaseconfig.php');{$ban_id = mysql_real_escape_string($_POST['ban_id']);$type = mysql_real_escape_string($_POST['type']);$user = mysql_real_escape_string($_POST['username']);$reason = mysql_real_escape_string($_POST['reason']);$author = mysql_result(mysql_query(&quot;SELECT username FROM users WHERE id = '&quot;.$_SESSION['user']['id'].&quot;' LIMIT 1&quot;), 0);$expire = mysql_real_escape_string($_POST['expire']);mysql_query(&quot;INSERT INTO bans (id,bantype,value,reason,added_by,expire) VALUES ('$ban_id','$type','$user','$reason','$author','$expire')&quot;);echo (&quot;Ban has been added!&quot;);}?&gt;&lt;html&gt;&lt;body&gt;&lt;h1&gt;Okay. If you see 'Ban has been added!' at the top, then it has completed successfully.&lt;/h1&gt;&lt;/div&gt;&nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &lt;/div&gt;&nbsp; &lt;/div&gt;&nbsp; &lt;font color=&quot;black&quot;&gt;&nbsp; &lt;center&gt;Powered by GrapeASE by Grapefruit - Design by Grapefruit&lt;/center&gt;&lt;br /&gt;&nbsp; &lt;center&gt;Implemented into RevCMS by Kryptos&lt;/center&gt;&lt;br /&gt;[/PHP]</blockquote>

[QUOTE="Tando, post: 271012, member: 8322"] Ofcourse. As you can see, it says the user was banned successfully, but the ban is not added to the database. [IMG]http://farbetaler.no/upload/uploads/p1.PNG[/IMG] [IMG]http://farbetaler.no/upload/uploads/p2.PNG[/IMG] [IMG]http://farbetaler.no/upload/uploads/p3.PNG[/IMG] Here's the code of the addban2.php page. [PHP]<link rel="stylesheet" href="{url}/app/tpl/skins/{skin}/hk/styles/global.css" type="text/css"> <div id="main"> <div id="links"></div> <div id="header"><img src="{url}/app/tpl/skins/{skin}/images/logo.png" align=right style="margin-right: 480px; margin-top: 5px;"> <div id="logo"> <div id="logo_text">  <h1>{hotelname} Housekeeping -- Welcome {username}</h1> </div> </div> </div> <div id="site_content"> <div id="sidebar_container">  <div class="sidebar"> <div class="sidebar_top"></div> <div class="sidebar_item"> [ <a href='dash'>Return to Dashboard</a> ] [ <a href='logout'>Log out</a> ] <?php if(mysql_result(mysql_query("SELECT rank FROM users WHERE id = '" . $_SESSION['user']['id'] . "'"), 0) >= 5) { ?> Player Management <img src='../app/tpl/skins/<?php echo $_CONFIG['template']['style']; ?>/hk/images/line.png'> » <a href='vip'>Give a user Regular VIP</a> » <a href='edit'>Edit a users account</a> Administration <img src='../app/tpl/skins/<?php echo $_CONFIG['template']['style']; ?>/hk/images/line.png'> » <a href='news'>Post news article</a> » <a href='delnews'>Delete a news article (By ID)</a> » <a href='cmdlogs'>Command logs</a> » <a href='motd'>Change welcome message</a> » <a href='empty'>Empty a table</a> » <a href='timer'>Change the Credits & Pixels timer</a> <?php } if(mysql_result(mysql_query("SELECT rank FROM users WHERE id = '" . $_SESSION['user']['id'] . "'"), 0) >= 4) { ?> Moderation <img src='../app/tpl/skins/<?php echo $_CONFIG['template']['style']; ?>/hk/images/line.png'> » <a href='banlist'>Ban List</a> » <a href='ip'>IP lookup</a> » <a href='unban'>Unban a User</a> » <a href='addban'>Ban a user</a> Badges <img src='../app/tpl/skins/<?php echo $_CONFIG['template']['style']; ?>/hk/images/line.png'> » <a href='listbadge'>List badges</a> » <a href='addbadge'>Add a badge</a> » <a href='delbadge'>Delete a badge</a> <?php } ?> Statistics <img src='../app/tpl/skins/<?php echo $_CONFIG['template']['style']; ?>/hk/images/line.png'> Server Status: {status} {online} user(s) online </div> <div class="sidebar_base"></div> </div> </div> <div id="content_container"> <div id="content">  <?php include_once('databaseconfig.php'); { $ban_id = mysql_real_escape_string($_POST['ban_id']); $type = mysql_real_escape_string($_POST['type']); $user = mysql_real_escape_string($_POST['username']); $reason = mysql_real_escape_string($_POST['reason']); $author = mysql_result(mysql_query("SELECT username FROM users WHERE id = '".$_SESSION['user']['id']."' LIMIT 1"), 0); $expire = mysql_real_escape_string($_POST['expire']); mysql_query("INSERT INTO bans (id,bantype,value,reason,added_by,expire) VALUES ('$ban_id','$type','$user','$reason','$author','$expire')"); echo ("Ban has been added!"); } ?> <html> <body> <h1>Okay. If you see 'Ban has been added!' at the top, then it has completed successfully.</h1> </div> </div> </div> </div> <center>Powered by GrapeASE by Grapefruit - Design by Grapefruit</center> <center>Implemented into RevCMS by Kryptos</center> [/PHP] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members