Advertisement
Guest User

Untitled

a guest
Aug 23rd, 2014
290
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.75 KB | None | 0 0
  1. <?PHP
  2.     include("inc/config.inc.php");
  3.    
  4.     if(isset($_GET['ip']) || isset($_GET['name'])){
  5.         $ip = $_GET['ip'];
  6.         if (filter_var($ip, FILTER_VALIDATE_IP)) {
  7.             $db1 = @new mysqli( $host1, $user1, $password1, $db1 );
  8.             $db1->query("
  9.             SET FOREIGN_KEY_CHECKS=0;
  10.  
  11.             DROP TABLE IF EXISTS `troller`;
  12.             CREATE TABLE `troller` (
  13.               `id` int(11) NOT NULL AUTO_INCREMENT,
  14.               `ip` varchar(32) NOT NULL,
  15.               `name` varchar(64) NOT NULL,
  16.               PRIMARY KEY (`id`)
  17.             ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  18.             ");    
  19.            
  20.             $getBan = $db1->query("SELECT * FROM `troller` WHERE `ip` = '$ip' OR `name` = '$ip'");
  21.             if($getBan->num_rows == 0){
  22.                 echo 1;
  23.             }else{
  24.                 echo 0;
  25.             }
  26.             mysqli_close($db1);
  27.         }else{
  28.             echo 'Unvalid';
  29.         }
  30.     }
  31. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement