UberCMS Appeals

Anyone can help me with my appeals page on ubercms housekeeping I'm trying to fix it but i failed. I hope anyone can help me.
The problem is its not showing any table here is the screenshot : Screenshot by Lightshot

PHP Code :

Code:

---

<?php
/*=======================================================================
| UberCMS - Advanced Website and Content Management System for uberEmu
| #######################################################################
| Copyright (c) 2010, Roy 'Meth0d' and updates by Matthew 'MDK'
| http://www.meth0d.org & http://www.sulake.biz
| #######################################################################
| This program is free software: you can redistribute it and/or modify
| it under the terms of the GNU General Public License as published by
| the Free Software Foundation, either version 3 of the License, or
| (at your option) any later version.
| #######################################################################
| This program is distributed in the hope that it will be useful,
| but WITHOUT ANY WARRANTY; without even the implied warranty of
| MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
| GNU General Public License for more details.
\======================================================================*/

require_once "../includes/class.rooms.php";

if (!defined('IN_HK') || !IN_HK)
{
        exit;
}

if (!HK_LOGGED_IN || !$users->hasFuse(USER_ID, 'fuse_housekeeping_moderation'))
{
        exit;
}

if (isset($_GET['doDenyAppeal']) && is_numeric($_GET['doDenyAppeal']))
{
        dbquery("UPDATE bans SET appeal_state = '2' WHERE id = '" . intval($_GET['doDenyAppeal']) . "'" . (($users->HasFuse(USER_ID, 'fuse_admin')) ? "" : " AND added_by = '" . HK_USER_NAME . "'") . " LIMIT 1");
       
        if (mysql_affected_rows() >= 1)
        {
                dbquery("DELETE FROM bans_appeals WHERE ban_id = '" . intval($_GET['doDenyAppeal']) . "' LIMIT 1");
                fMessage('ok', 'Ban appeal denied.');
               
                header("Location: index.php?_cmd=bans");
                exit;               
        }
}

if (isset($_GET['unban']) && is_numeric($_GET['unban']))
{
        dbquery("DELETE FROM bans WHERE id = '" . intval($_GET['unban']) . "'" . (($users->HasFuse(USER_ID, 'fuse_admin')) ? "" : " AND added_by = '" . HK_USER_NAME . "'") . " LIMIT 1");
       
        if (mysql_affected_rows() >= 1)
        {
                dbquery("DELETE FROM bans_appeals WHERE ban_id = '" . intval($_GET['unban']) . "' LIMIT 1");
                fMessage('ok', 'Ban removed.');
               
                $core->Mus('reloadbans');
               
                header("Location: index.php?_cmd=bans");
                exit;
        }
}

if (isset($_POST['bantype']))
{
        $bantype = filter($_POST['bantype']);
        $value = filter($_POST['value']);
        $reason = filter($_POST['reason']);
        $length = filter($_POST['length']);
        $noAppeal = '';
       
        if (isset($_POST['no-appeal']))
        {
                $noAppeal = filter($_POST['no-appeal']);
        }
       
        if ($bantype != "ip" && $bantype != "user")
        {
                $bantype = "user";
        }
       
        if (strlen($value) <= 0 || strlen($reason) <= 0 || !is_numeric($length) || intval($length) < 600)
        {
                fMessage('error', 'Please fill in all fields correctly! (Also take note a ban must be at least 10 minutes in length!)');
                header("Location: index.php?_cmd=bans");
                exit;
        }
       
        // $type, $value, $reason, $expireTime, $addedBy
        uberCore::AddBan($bantype, $value, $reason, time() + $length, HK_USER_NAME, (($noAppeal == "checked") ? true : false));
        $core->Mus('reloadbans');
}

require_once "top.php";

?>                       

<h1>Manage bans & appeals</h1>

<br />

<p>
        This tool allows you to place and manage bans, as well as review ban appeals.
</p>

<br />

<h2>Appeals for your bans pending reviewal</h2>

<br />

<p>
        This is an overview of appeals made against bans you placed. Take note that administrators can also
        manage your ban appeals.
</p>

<br />

<table width="100%" border="1">
<thead>
<tr>
        <td>Ban details</td>
        <td>IP Address</td>
        <td>Date submitted</td>
        <td>Reply e-mail</td>
        <td>Plea</td>
        <td>Review</td>
</tr>
</thead>
<tbody>
<?php

$getMyBans = dbquery("SELECT id,bantype,value,expire,added_date,appeal_state FROM bans WHERE appeal_state = '1'" . (($users->HasFuse(USER_ID, 'fuse_admin')) ? "" : " AND added_by = '" . HK_USER_NAME . "'"));

while ($ban = mysql_fetch_assoc($getMyBans))
{
        $findAppeal = dbquery("SELECT * FROM bans_appeals WHERE ban_id = '" . $ban['id'] . "' LIMIT 1");
       
        if (mysql_num_rows($findAppeal) == 1)
        {
                $data = mysql_fetch_assoc($findAppeal);
               
                if ($data['plea'] == '')
                {
                        continue;
                }
       
                echo '<tr>
                <td>' . strtoupper($ban['bantype']) . ' Ban: <b>' . clean($ban['value']) . '</b><br />
                Placed on <u>' . $ban['added_date'] . '</u>,<br />set to expire on <u>' . date('d F, Y', $ban['expire']) . '</u>.</td>
                <td>' . $data['send_ip'] . '</td>
                <td>' . $data['send_date'] . '</td>
                <td>' . clean($data['email']) . '</td>
                <td style="background-color: #CEE3F6; text-align: center; font-size: 90%;">' . nl2br(clean($data['plea'])) . '</td>
                <td><input type="button" style="color: darkgreen;" onclick="document.location = \'index.php?_cmd=bans&unban=' . $data['ban_id'] . '\';" value="Accept and unban">&nbsp;<input style="color: darkred;" type="button" onclick="document.location = \'index.php?_cmd=bans&doDenyAppeal=' . $ban['id'] . '\';" value="Deny"></td>
                </tr>';
        }
}

?>
</tbody>
</table>

<br />
<h2>Add new ban</h2>
<br />
<form method="post">

Ban type:<br />
<select name="bantype" onclick="onchange="if (this.value == 'ip') { document.getElementById('ban-value-heading').innerHTML = 'IP Address'; } else { document.getElementById('ban-value-heading').innerHTML = 'Username'; }" onkeyup="onchange="if (this.value == 'ip') { document.getElementById('ban-value-heading').innerHTML = 'IP Address'; } else { document.getElementById('ban-value-heading').innerHTML = 'Username'; }" onchange="if (this.value == 'ip') { document.getElementById('ban-value-heading').innerHTML = 'IP Address'; } else { document.getElementById('ban-value-heading').innerHTML = 'Username'; }">
<option value="ip">IP Ban</option>
<option value="user">User ban</option>
</select><br />
<br />

<span id="ban-value-heading">IP Address</span>:<Br />
<input type="text" name="value"><br />
<br />

Reason:<br />
<input type="text" name="reason"><br />
<br />

<script type="text/javascript">
function banPreset(val)
{
        document.getElementById('banlength').value = val;
}
</script>

Length (in seconds!):<br />
<input type="text" name="length" id="banlength"> secs<br />
<small>(Presets: <a href="#" onclick="banPreset(3600);">1hr</a> <a href="#" onclick="banPreset(10800);">3hr</a> <a href="#" onclick="banPreset(43200);">12hr</a> <a href="#" onclick="banPreset(86400);">1day</a> <a href="#" onclick="banPreset(259200);">3day</a> <a href="#" onclick="banPreset(604800);">1wk</a> <a href="#" onclick="banPreset(1209600);">2wk</a> <a href="#" onclick="banPreset(2592000);">1mo</a> <a href="#" onclick="banPreset(7776000);">3mo</a> <a href="#" onclick="banPreset(1314000);">1yr</a> <a href="#" onclick="banPreset(2628000);">2yr</a> <a href="#" onclick="banPreset(360000000);">Perm</a>)</small><br />
<br />

<input type="checkbox" name="no-appeal" value="checked"> Do NOT allow the user to appeal this ban<br />
<br />

<input type="submit" value="Ban!">

</form>

<br />
<h2>Bans list</h2>

<br />

<table width="100%" border="1">
<thead>
<tr>
        <td>Ban ID</td>
        <td>Data</td>
        <td>Reason</td>
        <td>Expires</td>
        <td>Added</td>
        <td>Appeal status</td>
        <td>Option</td>
</tr>
</thead>
<tbody>
<?php

$getBans = dbquery("SELECT * FROM bans ORDER BY expire DESC");

while ($ban = mysql_fetch_assoc($getBans))
{
        echo '<tr>
        <td>' . $ban['id'] . '</td>
        <td>' . strtoupper($ban['bantype']) . ' Ban: <b>' . clean($ban['value']) . '</b></td>
        <td style="text-align: center; font-size: 90%;">' . clean($ban['reason'], true, true) . '</td>
        ' . (($ban['expire'] <= time()) ? '<td style="text-align: center; background-color: #F6CECE; color: #B40404;">Expired ' . date('d F, Y', $ban['expire']) . '</td>' : '<td>Expires ' . date('d F, Y', $ban['expire']) . '</td>') . '
        <td>On ' . $ban['added_date'] . ' by ' . clean($ban['added_by']) . '</td>
        <td style="text-align: center;">';
       
        if ($ban['appeal_state'] == "0")
        {
                echo 'Not allowed to appeal!';
        }
        else if ($ban['appeal_state'] == "1")
        {
                if (mysql_num_rows(dbquery("SELECT null FROM bans_appeals WHERE ban_id = '" . $ban['id'] . "' AND plea != '' LIMIT 1")) > 0)
                {
                        echo '<b style="color: blue;">User has appealed ban, awaiting reviewal by moderator</b>';
                }
                else
                {
                        echo 'User has not appealed ban yet';
                }
        }
        else if ($ban['appeal_state'] == "2")
        {
                echo '<b style="color: red;">Appeal reviewed and declined</b>';
        }
       
        echo '</td>
        <td>';
       
        if (strtolower($ban['added_by']) == strtolower(HK_USER_NAME) || $users->HasFuse(USER_ID, 'fuse_admin'))
        {
                echo '<input type="button" onclick="document.location = \'index.php?_cmd=bans&unban=' . $ban['id'] . '\';" value="' . (($ban['expire'] <= time()) ? 'Remove' : 'Unban') . '">';
        }
       
        echo '</td></tr>';
}

?>
</body>
</table>

<?php

require_once "bottom.php";

?>

---