|
BBS IP blokker(mysql uitgebrijd)
Zet de install.php en admin.php in een map run de install.php en klaar is kees (wel schrijfrechten nodig)
<? include('ban.inc.php'); ?> moet je in elke pagina zetten waar je het ban systeem wilt laten werken
Wil je nu een ip bannen of unbannen ga dan naar admin.php en vul je naam en wachtwoord in de jij hebt opgegeven(het werkt met cookies dus zet wel cookies aan)
Succes er mee vragen pm mij
!!!!!!!!!!!!!!!!!cassy-web Zo doe dit maar eens!!!!!!!!!!!!!!!!!!!!
<-----------------------admin.php------------------------------->
<?
include('config.php');
?>
<html>
<head>
<meta http-equiv="Content-Language" content="en-us">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Admin van Bad8t-Ban Syteem</title>
</head>
<body bgcolor="#333333" text="#FF9900" link="#FF9900" vlink="#FF9900" alink="#FF9900" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<div align="center"><font size="7" face="Arial, Helvetica, sans-serif">Admin<br>
BBS</font></div>
<font face="Arial, Helvetica, sans-serif"><br>
</font>
<?
if(isset($_COOKIE['admin']))
{
?>
<table width="100%" height="100%" border="1" cellpadding="2" cellspacing="0" bordercolor="#999999" bordercolordark="#999999" bordercolorlight="#999999">
<tr>
<td width="52%" height="19" valign="top"> <div align="center"><font face="Arial, Helvetica, sans-serif"><strong><font size="4">Gebande
mensen</font></strong></font></div></td>
<td width="48%" valign="top"><div align="center"><font face="Arial, Helvetica, sans-serif"><strong><font size="4">Bezoekers</font></strong></font></div></td>
</tr>
<tr>
<td valign="top"> <font face="Arial, Helvetica, sans-serif">
<?
if(isset($_POST['verwijderenban']))
{
$query = mysql_query('DROP TABLE `ban`');
@mysql_query('CREATE TABLE `ban` ('
. ' `id` INT(10) NOT NULL AUTO_INCREMENT, '
. ' `ip` VARCHAR(50) NOT NULL, '
. ' `datumstart` VARCHAR(50) NOT NULL,'
. ' `datumend` VARCHAR(50) NOT NULL,'
. ' PRIMARY KEY (`id`)'
. ' )');
header('location: admin.php');
}
if(isset($_POST['Submitunban']))
{
$queryunban = mysql_query('DELETE FROM `ban` WHERE id="'.$_POST["radiounban"].'"');
if($queryunban==true)
{
echo'<center><font size="4">De unban is succes vol uitgevoerd.</font></center>';
header('location: admin.php');
}else
{
echo'<center><font size="4">Er is iets fout gegaan.</font></center>';
}
}else{?>
</font>
<form name="form1" method="post" action="">
<font face="Arial, Helvetica, sans-serif">
<?
$result=mysql_query("SELECT * FROM ban");
while($row= mysql_fetch_assoc($result))
{
echo'
<table width="100%" border="1" cellspacing="0" cellpadding="0" bordercolor="#333333" bordercolordark="#333333" bordercolorlight="#333333">
<tr>
<td width="14%" bgcolor="#666666">Ban:
<input type="radio" name="radiounban" value="'.$row["id"].'">
</td>
<td width="" bgcolor="#666666">ip: '.$row["ip"].'</td>
</tr>
</table>';
}
?>
</font>
<center>
<font face="Arial, Helvetica, sans-serif">
<input type="submit" name="Submitunban" value="unBan">
<input type="reset" name="Reset" value="Reset">
<br>
<input type="submit" name="verwijderenban" value="Verwijderen van alle ban's">
</font>
</center>
</form>
<font face="Arial, Helvetica, sans-serif">
<?
}
?>
</font></td>
<td width="48%" valign="top"> <font face="Arial, Helvetica, sans-serif">
<?
if(isset($_POST['verwijderenbezoekers']))
{
$query = mysql_query('DROP TABLE `bezoekers`');
@mysql_query('CREATE TABLE `bezoekers` ('
. ' `id` INT(10) NOT NULL AUTO_INCREMENT, '
. ' `ip` VARCHAR(50) NOT NULL, '
. ' `datum` VARCHAR(50) NOT NULL,'
. ' PRIMARY KEY (`id`)'
. ' )');
header('location: admin.php');
}
if(isset($_POST['Submitban']))
{
$query = mysql_query('SELECT * FROM `bezoekers` WHERE id="'.$_POST['radioban'].'"');
$object = mysql_fetch_object($query);
$time = date("m-d-y g:i a");
$queryban = mysql_query('INSERT INTO `ban` (`id`, `ip`) VALUES ("", "'.$object->ip.'")');
if($queryban==true && $query==true)
{
echo'<center><font size="4">De ban is succes vol uitgevoerd.</font></center>';
header('location: admin.php');
}else
{
echo'<center><font size="4">Er is iets fout gegaan.</font></center>';
}
}else{?>
</font>
<form name="form1" method="post" action="">
<font face="Arial, Helvetica, sans-serif">
<?
$result=mysql_query("SELECT * FROM bezoekers ORDER BY datum DESC");
while($row= mysql_fetch_assoc($result))
{
echo'
<table width="100%" border="1" cellspacing="0" cellpadding="0" bordercolor="#333333" bordercolordark="#333333" bordercolorlight="#333333">
<tr>
<td width="14%" bgcolor="#666666">Ban:
<input type="radio" name="radioban" value="'.$row["id"].'">
</td>
<td width="43%" bgcolor="#666666">ip: '.$row["ip"].'</td>
<td width="43%" bgcolor="#666666">datum: '.$row["datum"].'</td>
</tr>
</table>';
}
?>
</font>
<center>
<font face="Arial, Helvetica, sans-serif">
<input type="submit" name="Submitban" value="Ban">
<input type="reset" name="Reset" value="Reset">
<br><input type="submit" name="verwijderenbezoekers" value="Verwijderen van alle bezoekers"></font>
</center>
</form>
<font face="Arial, Helvetica, sans-serif">
<?
}
?>
</font></td>
</tr>
</table>
<?
}else{
if(isset($_POST['inloggen']))
{
include('config.php');
if($_POST['naam']=="$adminname" && $_POST['pass']=="$adminpass ")
{
setcookie("admin", "ja");
header('location: admin.php');
}else{
echo"
<script>
alert('Foute naam en/of wachtwoord');
</script>";
header('location: admin.php');
}
}
else{
?>
<form name="form2" method="post" action="">
<div align="center">
<table width="38%" height="6%" border="1" cellpadding="2" cellspacing="0" bordercolor="#999999" bordercolordark="#999999" bordercolorlight="#999999">
<tr>
<td height="27" colspan="2" valign="top">
<div align="center"><font size="4" face="Arial, Helvetica, sans-serif"><strong>Login
Admin </strong></font></div></td>
</tr>
<tr>
<td width="67%" height="25" valign="top"> <font face="Arial, Helvetica, sans-serif">Naam:</font></td>
<td width="33%" valign="top"> <input name="naam" type="text" size="40">
</td>
</tr>
<tr>
<td height="28" valign="top">Wachtwoord:</td>
<td height="28" valign="top">
<input name="pass" type="password" size="40"></td>
</tr>
</table><br>
<input type="submit" name="inloggen" value="Inloggen">
<input type="reset" name="Submit2" value="Reset">
</div>
</form>
<?
}
}
?>
<div align="left"></div>
<div align="center"> <font face="Arial, Helvetica, sans-serif">
<script>-->Laat alstubliefd mijn link staan je mag hem weg hallen maar laat hem alsublieft staan<--</script>
<font size="1"><a href="http://www.kevinvalk.nl">Dit ban systeem is gemaakt
door Bad8T-Kevin</a></font></font> <font face="Arial, Helvetica, sans-serif">
<script>-->Laat alstubliefd mijn link staan je mag hem weg hallen maar laat hem alsublieft staan<--</script>
</font></div>
</body>
</html>
<--------------------------install.php-------------------------->
<html>
<head>
<meta http-equiv="Content-Language" content="en-us">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Install van Bad8t-Ban Syteem</title>
</head>
<body bgcolor="#333333" text="#FF9900" link="#FF9900" vlink="#FF9900" alink="#FF9900" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<?
if(isset($_POST['Submit']))
{
$hostnameinstall = "".$_POST['host']."";
$usernameinstall = "".$_POST['user']."";
$passwordinstall = "".$_POST['pass']."";
$databaseinstall = "".$_POST['db']."";
mysql_connect($hostnameinstall, $usernameinstall, $passwordinstall) or die(mysql_error());
mysql_select_db($databaseinstall);
if(mysql_select_db("".$_POST['db']."")==true)
{
}else{
mysql_query('CREATE DATABASE `'.$_POST['db'].'`');
}
@mysql_query('CREATE TABLE `ban` ('
. ' `id` INT(10) NOT NULL AUTO_INCREMENT, '
. ' `ip` VARCHAR(50) NOT NULL, '
. ' `datumstart` VARCHAR(50) NOT NULL,'
. ' `datumend` VARCHAR(50) NOT NULL,'
. ' PRIMARY KEY (`id`)'
. ' )');
@mysql_query('CREATE TABLE `bezoekers` ('
. ' `id` INT(10) NOT NULL AUTO_INCREMENT, '
. ' `ip` VARCHAR(50) NOT NULL, '
. ' `datum` VARCHAR(50) NOT NULL,'
. ' PRIMARY KEY (`id`)'
. ' )');
//------------------------------config.php------------------------------------//
$fp=fopen("config.php","w");
fputs($fp,'<?
$hostname = "'.$_POST['host'].'";
$username = "'.$_POST['user'].'";
$password = "'.$_POST['pass'].'";
$database = "'.$_POST['db'].'";
$adminpass = "'.$_POST['adminpass'].'";
$adminname = "'.$_POST['adminnaam'].'";
mysql_connect($hostname,$username,$password) or die(mysql_error());
mysql_select_db($database);
?>');
fclose($fp);
//------------------------------ban.inc.php------------------------------------//
$fp=fopen("ban.inc.php","w");
fputs($fp,'<?
include("config.php");
$ip=$_SERVER["REMOTE_ADDR"];
$time = date("m-d-y g:i a");
@mysql_query("INSERT INTO bezoekers SET datum='".$time."', ip='".$ip."'");
?>
<?
$result=mysql_query("SELECT * FROM ban");
while($row= mysql_fetch_assoc($result))
{
if($row["ip"]==$ip)
{
echo"
<script>
alert("Jij mag hier niet komen. Jij bent geband!");
</script>";
$waar=$_SERVER["HTTP_REFERRER"];
header("location: ".$waar."");
}
}
?>');
fclose($fp);
echo'<center><font size="6" face="Arial, Helvetica, sans-serif">BBS<br><br><font size="4">Het ban systeem is succes vol geinstalleerd<font size="3"><br><br>
<font color="#FF0000"><?</font><font color="#0000FF"> include(</font><font color="#FF0000">"ban.inc.php"</font><font color="#0000FF">)</font><font color="#000000">;</font><font color="#FF0000">
?></font><br>
<br><font size="4">voeg dit nu in elke pagina waar je het ban syteem wilt hebben.</center></font> ';
}else{
?>
<div align="center"><font size="6" face="Arial, Helvetica, sans-serif">Installeren</font><font face="Arial, Helvetica, sans-serif"><br>
<font size="5">Van<br>
Bad8t Ban Syteem<br>
BBS </font></font></div>
<center>
<form name="form1" method="post">
<table width="560" border="1" cellpadding="2" cellspacing="0" bordercolor="#999999" bordercolordark="#999999" bordercolorlight="#999999">
<tr>
<td colspan="2"><div align="center"><font face="Arial, Helvetica, sans-serif"><strong>Mysql
Setup</strong></font></div></td>
</tr>
<tr>
<td width="306"><font face="Arial, Helvetica, sans-serif">Hostname: </font></td>
<td width="240"><font face="Arial, Helvetica, sans-serif">
<input name="host" type="text" size="40">
</font></td>
</tr>
<tr>
<td><font face="Arial, Helvetica, sans-serif">Username: </font></td>
<td><font face="Arial, Helvetica, sans-serif">
<input name="user" type="text" id="user" size="40">
</font></td>
</tr>
<tr>
<td><font face="Arial, Helvetica, sans-serif">Wachtwoord:</font></td>
<td><font face="Arial, Helvetica, sans-serif">
<input name="pass" type="password" size="40">
</font></td>
</tr>
<tr>
<td><font face="Arial, Helvetica, sans-serif">Database naam:<font size="1">(als
de db niet bestaad word hij aangemaakt)</font></font></td>
<td><font face="Arial, Helvetica, sans-serif">
<input name="db" type="text" size="40">
</font></td>
</tr>
</table>
<font face="Arial, Helvetica, sans-serif"><br>
</font>
<table width="561" border="1" cellpadding="2" cellspacing="0" bordercolor="#999999" bordercolordark="#999999" bordercolorlight="#999999">
<tr>
<td colspan="2"><div align="center"><font face="Arial, Helvetica, sans-serif"><strong>Admin
setup</strong></font></div></td>
</tr>
<tr>
<td width="307"><font face="Arial, Helvetica, sans-serif">Usernaam:</font></td>
<td width="240"><font face="Arial, Helvetica, sans-serif">
<input name="adminnaam" type="text" id="adminnaam" size="40">
</font></td>
</tr>
<tr>
<td><font face="Arial, Helvetica, sans-serif">Wachtwoord:</font></td>
<td><font face="Arial, Helvetica, sans-serif">
<input name="adminpass" type="password" id="adminpass" size="40">
</font></td>
</tr>
</table>
<font face="Arial, Helvetica, sans-serif"><br>
<input type="submit" name="Submit" value="Installeer">
<input type="reset" name="Submit2" value="Reset">
</font>
</form>
</center>
<?
}
?>
</body>
</html>
download het script
Reacties van leden
Auteur: kevin @ 12-04-2005
Ik ben bezig met versie 1.0 daar haal ik alle bugs uit en zet ik een paar extra functies in
Greets kevin
|