falon / RBL

		$query = sprintf("DELETE FROM `$table` WHERE

                        `$table`.`$type` = INET_ATON('%s') LIMIT 1", $value);

		break;

	  case 'network':

		list($sub['net'],$sub['mask'])=explode('/',$value);

		$query = sprintf("DELETE FROM `$table` WHERE

			`$table`.`$type` = INET_ATON('%s') AND `$table`.`netmask` = INET_ATON('%s') LIMIT 1",

			$sub['net'],$sub['mask']);

		break;

	  default:

		$query = sprintf("DELETE FROM `$table` WHERE

                        `$table`.`$type` = %s LIMIT 1", $value);

				$table,$table);

		else {

			switch ($type) {

				case 'network':

					list($sub['net'],$sub['mask'])=explode('/',$value);

					$query = sprintf('SELECT * FROM (

							SELECT *, GROUP_CONCAT(milt.name) as miltnames FROM `%s` LEFT JOIN milt ON (%s.idmilt=milt.id)

				 				WHERE (

									inet_aton(\'%s\') >= network AND

									( inet_aton(\'%s\') | ( inet_aton(\'%s\') ^ (power(2,32)-1) ) )

										<= network | ( netmask ^ (power(2,32)-1) )

								)

				 				GROUP by idmilt

							) AS val WHERE val.network IS NOT null', $table, $table, $sub['net'], $sub['net'], $sub['mask']);

					break;

				case 'ip':

					$query = sprintf('SELECT * FROM (

							SELECT *, GROUP_CONCAT(milt.name) as miltnames FROM `%s` LEFT JOIN milt ON (%s.idmilt=milt.id)' .

	                  case 'ip':

	                        $query= "select * from $table where $type =  INET_ATON('$value')";

	                        break;

	                  case 'network':

	                        list($sub['net'],$sub['mask'])=explode('/',$value);

	                        $query= sprintf('select * from `%s`

						WHERE (

							inet_aton(\'%s\') >= network AND

							( inet_aton(\'%s\') | ( inet_aton(\'%s\') ^ (power(2,32)-1) ) )

								<= network | ( netmask ^ (power(2,32)-1) )

						)', $table, $sub['net'], $sub['net'], $sub['mask']);

;

	                        break;

	                  default:

	                        $query= "select * from $table where $type = '$value'";

	                }