[Help] RevCMS, GrapeASE, Can't add bans

Tando

Tando

Norwegian Steam Engine
Oct 23, 2011
83
5
Hello, I've ran into a problem with GrapeASE. It seems like I cannot add bans trough the HK. If i add it manually in the db it does show up in the ban list.
Any help? Let me know if I should provide some codes etc.

Thanks in advance.
 
Sort by date Sort by votes
Tando

Tando

Norwegian Steam Engine
Oct 23, 2011
83
5
JayCustom said:
Code for the page please
Click to expand...
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">
          <!-- class="logo_colour", allows you to change the color of the logo text -->
        <h1>{hotelname} Housekeeping -- Welcome {username}</h1>
        </div>
      </div>
    </div>
    <div id="site_content">
      <div id="sidebar_container">
        <!-- insert your sidebar items here -->
        <div class="sidebar">
          <div class="sidebar_top"></div>
          <div class="sidebar_item">
          <br />
          [ <a href='dash'>Return to Dashboard</a> ] [ <a href='logout'>Log out</a> ]<br /> <br />
            <p>
            <?php if(mysql_result(mysql_query("SELECT rank FROM users WHERE id = '" . $_SESSION['user']['id'] . "'"), 0) >= 5)
            { ?>
            Player Management <br /> <img src='../app/tpl/skins/<?php echo $_CONFIG['template']['style']; ?>/hk/images/line.png'> <br />
           
            &raquo; <a href='vip'>Give a user Regular VIP</a> <br />
           
            &raquo; <a href='edit'>Edit a users account</a> <br />
            <br />
            Administration <br /> <img src='../app/tpl/skins/<?php echo $_CONFIG['template']['style']; ?>/hk/images/line.png'> <br />
            &raquo; <a href='news'>Post news article</a><br />
            &raquo; <a href='delnews'>Delete a news article (By ID)</a><br />
            &raquo; <a href='cmdlogs'>Command logs</a><br />&raquo; <a href='motd'>Change welcome message</a><br />&raquo; <a href='empty'>Empty a table</a><br />&raquo; <a href='timer'>Change the Credits & Pixels timer</a><br />
            <br />
            <?php } if(mysql_result(mysql_query("SELECT rank FROM users WHERE id = '" . $_SESSION['user']['id'] . "'"), 0) >= 4) { ?>
            Moderation <br /> <img src='../app/tpl/skins/<?php echo $_CONFIG['template']['style']; ?>/hk/images/line.png'> <br />
            &raquo; <a href='banlist'>Ban List</a> <br />
            &raquo; <a href='ip'>IP lookup</a> <br />
            &raquo; <a href='unban'>Unban a User</a> <br />&raquo; <a href='addban'>Ban a user</a><br />
            <br />
            Badges <br /> <img src='../app/tpl/skins/<?php echo $_CONFIG['template']['style']; ?>/hk/images/line.png'> <br />
            &raquo; <a href='listbadge'>List badges</a><br />&raquo; <a href='addbadge'>Add a badge</a><br />&raquo; <a href='delbadge'>Delete a badge</a><br />
           
            <?php } ?>
            <br />
            Statistics<br />
            <img src='../app/tpl/skins/<?php echo $_CONFIG['template']['style']; ?>/hk/images/line.png'> <br />
                    Server Status:
            {status} <br />
            {online} user(s) online <br />
   
            </p>
          </div>
          <div class="sidebar_base"></div>
        </div>
      </div>
      <div id="content_container">

        <div id="content">
          <!-- insert the page content here -->
          <br />         
<form method="post" action="addban2">
Ban ID (Make sure it has not been used!!!)<br />
    <input type="text" name="ban_id"/> <br /> <br />
    Username:<br />
    <input type="text" name="username"/> <br /> <br />
    Ban Type (Either 'user' or 'ip'):<br />
    <input type="text" name="type"/> <br /> <br />
    Reason:<br />
    <input type="text" name="reason"/> <br /> <br />
   
    <strong>NOTE: For the next step, please go to http://www.onlineconversion.com/unix_time.htm and use the 'Convert a Date/Time to a Unix timestamp'
    for when you want the ban to expire, and simply type in the numbers it gives you below:<br /><br /></strong>
   
    Expire:
    <input type="text" name="expire"/><br /><br />
   
    <input type="submit" value="Ban user" name="ban2" />
    </form>
    <?php
   

?>
</div>

      </div>
    </div>
  </div>
  <font color="black">  <center>Powered by GrapeASE by Grapefruit - Design by Grapefruit</center><br />  <center>Implemented into RevCMS by Kryptos</center><br />
 
Upvote 0 Downvote
Tando

Tando

Norwegian Steam Engine
Oct 23, 2011
83
5
Obodiah said:
Okay, Could you take a screenshot of the page when you try to add a ban?
Click to expand...
Ofcourse.
As you can see, it says the user was banned successfully, but the ban is not added to the database.

p1.PNG

p2.PNG

p3.PNG


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">
          <!-- class="logo_colour", allows you to change the color of the logo text -->
        <h1>{hotelname} Housekeeping -- Welcome {username}</h1>
        </div>
      </div>
    </div>
    <div id="site_content">
      <div id="sidebar_container">
        <!-- insert your sidebar items here -->
        <div class="sidebar">
          <div class="sidebar_top"></div>
          <div class="sidebar_item">
          <br />
          [ <a href='dash'>Return to Dashboard</a> ] [ <a href='logout'>Log out</a> ]<br /> <br />
            <p>
            <?php if(mysql_result(mysql_query("SELECT rank FROM users WHERE id = '" . $_SESSION['user']['id'] . "'"), 0) >= 5)
            { ?>
            Player Management <br /> <img src='../app/tpl/skins/<?php echo $_CONFIG['template']['style']; ?>/hk/images/line.png'> <br />
           
            &raquo; <a href='vip'>Give a user Regular VIP</a> <br />
           
            &raquo; <a href='edit'>Edit a users account</a> <br />
            <br />
            Administration <br /> <img src='../app/tpl/skins/<?php echo $_CONFIG['template']['style']; ?>/hk/images/line.png'> <br />
            &raquo; <a href='news'>Post news article</a><br />
            &raquo; <a href='delnews'>Delete a news article (By ID)</a><br />
            &raquo; <a href='cmdlogs'>Command logs</a><br />&raquo; <a href='motd'>Change welcome message</a><br />&raquo; <a href='empty'>Empty a table</a><br />&raquo; <a href='timer'>Change the Credits & Pixels timer</a><br />
            <br />
            <?php } if(mysql_result(mysql_query("SELECT rank FROM users WHERE id = '" . $_SESSION['user']['id'] . "'"), 0) >= 4) { ?>
            Moderation <br /> <img src='../app/tpl/skins/<?php echo $_CONFIG['template']['style']; ?>/hk/images/line.png'> <br />
            &raquo; <a href='banlist'>Ban List</a> <br />
            &raquo; <a href='ip'>IP lookup</a> <br />
            &raquo; <a href='unban'>Unban a User</a> <br />&raquo; <a href='addban'>Ban a user</a><br />
            <br />
            Badges <br /> <img src='../app/tpl/skins/<?php echo $_CONFIG['template']['style']; ?>/hk/images/line.png'> <br />
            &raquo; <a href='listbadge'>List badges</a><br />&raquo; <a href='addbadge'>Add a badge</a><br />&raquo; <a href='delbadge'>Delete a badge</a><br />
           
            <?php } ?>
            <br />
            Statistics<br />
            <img src='../app/tpl/skins/<?php echo $_CONFIG['template']['style']; ?>/hk/images/line.png'> <br />
                    Server Status:
            {status} <br />
            {online} user(s) online <br />
   
            </p>
          </div>
          <div class="sidebar_base"></div>
        </div>
      </div>
      <div id="content_container">

        <div id="content">
          <!-- insert the page content here -->
          <br />          <?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>
  <font color="black">  <center>Powered by GrapeASE by Grapefruit - Design by Grapefruit</center><br />  <center>Implemented into RevCMS by Kryptos</center><br />
 
Upvote 0 Downvote
Tando

Tando

Norwegian Steam Engine
Oct 23, 2011
83
5
JayCustom said:
"ID" table is something that is done by itself. There is no need to have that lol.

I need the other page for this please I am going to recode it for you, so it will work.
Click to expand...
Which page? I've provided both, addban.php and addban2.php, which page do you need?


Obodiah said:
I Recommend Getting Sledmore's Housekeeping Release.
Click to expand...
I've sent you a Skype Request
 
Upvote 0 Downvote

Users who are viewing this thread

Total: 2 (members: 0, guests: 2)
☀️  Switch to Light Theme

Latest posts

Top