PHP Banlist Page

Personally I use a combination of this page and another called phpMyEdit (bear in mind that you have to configure the main page considering it will allow you to edit your listings.) It can be found here: phpMyEdit

Just Copy the Code in notepad, edit the mysql login info (No it will not display your login info from the web, unless you don't have php enabled), and save as banlist.php or whatever you like and upload to you apache/mysql/php server.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<title>Ultra Banlist</title>
</head>
<body>
<h1>Ultra Banlist</h1>
<?php

// change these things

   $server = "localhost";
   $dbuser = "root";
   $dbpass = "root";
   $dbname = "database";
   
mysql_connect($server, $dbuser, $dbpass);
mysql_select_db($dbname);

$result = mysql_query("SELECT * FROM banlist ORDER BY id DESC");
//This will display the most recent by id edit this query how you see fit. Limit, Order, ect.
echo "<table width=100% border=1 cellpadding=3 cellspacing=0>";

echo "<tr style=\"font-weight:bold\">
<td>Type</td>
<td>Name</td>
<td>Reason</td>
<td>Admin/Mod</td>
<td>Time</td>
<td>TimeTempBan</td>
<td>id</td>

</tr>";

while($row = mysql_fetch_assoc($result)){

if($col == "#eeeeee"){
$col = "#ffffff";
}else{
$col = "#eeeeee";
}
echo "<tr bgcolor=$col>";
if($row['type'] == "5"){
echo "<td>Unban</td>";
}else{
    if($row['type'] == "3"){
    echo "<td>Kick</td>";
    }else{
        if($row['type'] == "2"){
        echo "<td>Warn</td>";
        }else{
            if($row['type'] == "0"){
            echo "<td>Banned</td>";
            }else{
                if($row['type'] == "1"){
                echo "<td>IPBanned</td>";
                }else{
                    if($row['type'] == "4"){
                    echo "<td>Fine</td>";
                    }else{
                        if($row['type'] == "6"){
                        echo "<td>Jailed</td>";
                        }else{
                            if($row['type'] == "9"){
                            echo "<td>Perma</td>";
                            }else{
                            echo "<td>Unknown</td>";
//Holy Epic If Statement Batman!
                            }
                        }
                    }
                }
            }
        }
    }
}
echo "<td>".$row['name']."</td>";
echo "<td>".$row['reason']."</td>";
echo "<td>".$row['admin']."</td>";
//Convert Epoch Time to Standard format
$datetime = date("F j, Y, g:i a", $row['time']);
echo "<td>$datetime</td>";
$dateconvert = date("F j, Y, g:i a", $row['temptime']);  
if($row['temptime'] == "0"){
echo "<td>None</td>";
}else{
echo "<td>$dateconvert</td>";
}
echo "<td>".$row['id']."</td>";

echo "</tr>";
}

echo"</table>";

?>
</div>
Ban database provided by UltraBans.
</body></html>

Comments

_ForgeUser7446141
- Join Date: 8/26/2011
- Posts: 44
- Member Details
#1 _ForgeUser7446141

View User Profile

Send Message

Posted Dec 3, 2011
Working good, thanks. :)

Last edited by _ForgeUser7446141: Dec 3, 2011

Rollback Post to Revision RollBack

_ForgeUser441326

Join Date: 1/22/2008
Posts: 1
Member Details

#2 Posted Dec 5, 2011

You should change those awful if statements to

switch ($row['type'])
	{
	case 0:
		$type = "Banned";
		break;
	case 1:
		$type = "IP Banned";
		break;
	case 2:
		$type = "Warn";
		break;
	case 3:
		$type = "Kick";
		break;
	case 4:
		$type = "Fine";
		break;
	case 5:
		$type = "Unbanned";
		break;
	case 6:
		$type = "Jailed";
		break;
	case 9:
		$type = "Permanent Ban";
		break;
	default:
		$type = "Unknown";
	}
	
	echo "<td>$type</td>";

I am happy to do any PHP coding work for this project. I have some free time here and there so if you need anything hit me up.

_ForgeUser7792414
- Join Date: 10/31/2011
- Posts: 6
- Member Details
#3 _ForgeUser7792414

View User Profile

Send Message

Posted Apr 9, 2012
How would I go about getting my current database in my MySQL database?

Thanks!

Tom

Rollback Post to Revision RollBack

_ForgeUser8383609

Join Date: 2/7/2012
Posts: 235
Member Details

#4 Posted Apr 26, 2012

If you want to stop people abusing sql with refresh then here ya go...

session_start();
// Config
// Amount of times a user can refresh within time limit (seconds)
$refreshlimit = "10";
$refreshtimer = "30";
// End config

// Check if banned for refreshing too fast.
// If session vars dont exist then create them, else add 1 to count.
if (!isset($_SESSION['first_hit'])) {
    $_SESSION['first_hit'] = time();
    $_SESSION['count']     = 1;
    $_SESSION['banned']    = false;
} else {
    $timer = $_SESSION['first_hit'] + $refreshtimer;
    // If timer has passed then reset all
    if (time() > $timer) {
        $_SESSION['count']     = 0;
        $_SESSION['first_hit'] = time();
        $_SESSION['banned']    = false;
    } else {
        // If timer has not passed then add 1 to refresh count
        $_SESSION['count']++;
    }
}

// Ban user if they refresh over x times within the x second time limit
if ($_SESSION['count'] > $refreshlimit) {
    $_SESSION['banned'] = true;
}

// If person is banned, stop loading page
if ($_SESSION['banned'] == true) {
    echo "<div align='center'>";
    echo "<h2><strong>You reloaded the page too often. Come back in ";
    echo $refreshtimer;
    echo " seconds</strong></h2>";
    echo "</div>";
    die();
}

Last edited by _ForgeUser8383609: Apr 26, 2012

_ForgeUser8616991
- Join Date: 3/21/2012
- Posts: 22
- Member Details
#5 _ForgeUser8616991

View User Profile

Send Message

Posted Jul 19, 2012
why this Error? Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given on line 35

Rollback Post to Revision RollBack
Forge_User_52354827
- Join Date: 12/14/2011
- Posts: 165
- Member Details
#6 Forge_User_52354827

View User Profile

Send Message

Posted Jul 26, 2012
You could use elseif { } instead of else { if { }}

Rollback Post to Revision RollBack
_ForgeUser8202911
- Join Date: 1/5/2012
- Posts: 73
- Member Details
#7 _ForgeUser8202911

View User Profile

Send Message

Posted Aug 4, 2012
@VitaminBoy

Same... Dont get it..

Rollback Post to Revision RollBack
_ForgeUser8202911
- Join Date: 1/5/2012
- Posts: 73
- Member Details
#8 _ForgeUser8202911

View User Profile

Send Message

Posted Aug 6, 2012
@VitaminBoy

The web and server must be on the same DB and on the same VPS. Then it will work....

Rollback Post to Revision RollBack
_ForgeUser9303729
- Join Date: 7/28/2012
- Posts: 126
- Member Details
#9 _ForgeUser9303729

View User Profile

Send Message

Posted Aug 19, 2012
Hello.

I have a question.

Can i put a banlist page in my Blogger website? How??

Thanks, I dont know much about this.

Rollback Post to Revision RollBack
_ForgeUser6991210
- Join Date: 6/10/2011
- Posts: 248
- Member Details
#10 _ForgeUser6991210

View User Profile

Send Message

Posted Aug 23, 2012
date and time is displaying incorrectly for me. I have a feeling its set to the wrong timezone. I cant seem to figure out how to fix it

Last edited by _ForgeUser6991210: Aug 23, 2012

Rollback Post to Revision RollBack
_ForgeUser7341463
- Join Date: 8/7/2011
- Posts: 442
- Member Details
#11 _ForgeUser7341463

View User Profile

Send Message

Posted Sep 3, 2012
does the server and web host need to be on the same VPS? mine are seperate will it still work?

Rollback Post to Revision RollBack
_ForgeUser8689119
- Join Date: 4/4/2012
- Posts: 9
- Member Details
#12 _ForgeUser8689119

View User Profile

Send Message

Posted Sep 15, 2012
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/a1805279/public_html/bans/banlist.php on line 35 Anyway To Fix That Problem?

Rollback Post to Revision RollBack
_ForgeUser8043936
- Join Date: 12/9/2011
- Posts: 37
- Member Details
#13 _ForgeUser8043936

View User Profile

Send Message

Posted Nov 25, 2012
How can I Disable warns in SQL, I want that BanList show onls Bans, TempBans and IPBans, not some kicks and warns..

How can I do that?

Rollback Post to Revision RollBack

_ForgeUser7670762

Join Date: 10/8/2011
Posts: 6
Member Details

#14 Posted Dec 17, 2012

Heres the same script, with MySQli, and a check for if the database connection works.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
    <title>Ultra Banlist</title>
</head>
<body>
<h1>Ultra Banlist</h1>
<?php

date_default_timezone_set("GMT"); //http://php.net/manual/en/timezones.php

    $host     = "localhost";
    $user     = "root";
    $password = "root";
    $name     = "minecraft";

$link = @mysqli_connect($host, $user, $password, $name);

if ($link) {
$result = mysqli_query($link, "SELECT * FROM `banlist`
                               ORDER BY `id` DESC");

echo <<<END
<table width=100% border=1 cellpadding=3 cellspacing=0>
<tr style="font-weight: bold">
    <td>Type</td>
    <td>Name</td>
    <td>Reason</td>
    <td>Admin/Mod</td>
    <td>Time</td>
    <td>TimeTempBan</td>
</tr>
END;

while ($row = mysqli_fetch_assoc($result)) {

echo "<tr bgcolor=#FFFFFF>";


switch ($row['type']) {
    case '0':
        echo "<td>Banned</td>";
        break;

    case '1':
        echo "<td>IP Banned</td>";
        break;

    case '2':
        echo "<td>Warn</td>";
        break;

    case '3':
        echo "<td>Kick</td>";
        break;

    case '4':
        echo "<td>Fine</td>";
        break;

    case '5':
        echo "<td>Unbanned</td>";
        break;

    case '6':
        echo "<td>Jailed</td>";
        break;

    case '9':
        echo "<td>Perma</td>";
        break;

    default:
        echo "<td>Unknown</td>";
        break;
}

echo <<<END
<td>{$row['name']}</td>
<td>{$row['reason']}</td>
<td>{$row['admin']}</td>
END;

echo "<td>", date("F j Y, g:i A", $row['time']), "</td>";

echo ($row['temptime'] == "0") ? "<td>None</td>" : "<td>" . date("F j Y, g:i A", $row['temptime']) . "</td>" , "</tr>";

}

echo "</table>";

} else {
    echo "Error on MySQL Connection! <br />";
}
?>
</div>
Ban database provided by UltraBans.
</body>
</html>

_ForgeUser10261923
- Join Date: 12/24/2012
- Posts: 19
- Member Details
#16 _ForgeUser10261923

View User Profile

Send Message

Posted Dec 23, 2012
You could just use a switch statement to make things a little cleaner than if's.

Last edited by _ForgeUser10261923: Dec 23, 2012

Rollback Post to Revision RollBack
_ForgeUser10352580
- Join Date: 1/7/2013
- Posts: 1
- Member Details
#17 _ForgeUser10352580

View User Profile

Send Message

Posted Jan 29, 2013
How do you make the banlist with the zxq.net host, and mybb forums? Thanks

Rollback Post to Revision RollBack
_ForgeUser10195500
- Join Date: 12/11/2012
- Posts: 139
- Member Details
#18 _ForgeUser10195500

View User Profile

Send Message

Posted Feb 14, 2013
@emfjop

I would like to put one on my wordpress site, if anyone could help with that.

Rollback Post to Revision RollBack
_ForgeUser10195500
- Join Date: 12/11/2012
- Posts: 139
- Member Details
#19 _ForgeUser10195500

View User Profile

Send Message

Posted Feb 14, 2013
@saimon13

I got that error too. Just today actually, I mean it has worked for me before.

Rollback Post to Revision RollBack
_ForgeUser9502012
- Join Date: 8/29/2012
- Posts: 531
- Member Details
#20 _ForgeUser9502012

View User Profile

Send Message

Posted Feb 20, 2013
Help adding it to dreamweaver in a html page?

Rollback Post to Revision RollBack
_ForgeUser8260912
- Join Date: 1/15/2012
- Posts: 29
- Member Details
#21 _ForgeUser8260912

View User Profile

Send Message

Posted Mar 17, 2013
It's PHP.. not HTML

Rollback Post to Revision RollBack
To post a comment, please login or register a new account.

Ultrabans

Bukkit Plugins

Pages

Table of Contents