prefix.'absp_ipdeny';
$result = $wpdb->query($wpdb->prepare("DELETE FROM " .$table_name
. " WHERE ID = " .$id ));
if($result)
{
echo "Success::".$id;
?>
prefix . "absp_ipdeny"; //table Name
$result = mysql_list_tables(DB_NAME);
$tables = array();
while ($row = mysql_fetch_row($result)) {
$tables[] = $row[0];
}
// Only install if the table doesn't exist
if ( !in_array($table_name, $tables) ) {
$query="CREATE TABLE ".$table_name ." ( `ID` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`ip_address` VARCHAR(200),
`ip_type` VARCHAR(200),
`cur_timestamp` TIMESTAMP)";
$result=mysql_query($query) or die('Unable to create table, Error is'.mysql_error());
if($result)
{
update_option('apptivo_ipdeny_table','yes');
}
}
if (!$result) {
return false;
}
return true;
}
function settings()
{
global $wpdb;
$table_name = $wpdb->prefix . "absp_ipdeny"; //table Name
if(isset($_POST['absp_ip'])){
$ip_type= AWP_Request::get_string("ip_type");
$error = "";
if($ip_type == 'Single') :
$ip_address= AWP_Request::get_string("ip_address");
if(!$ip_address) {
$error .= "Please Enter IP Address
";
}else {
$validate = validateIpAddress($ip_address);
if(!$validate) :
$error .= "Please Enter Valid IP Address
";
endif;
}
else :
$ip_address1= AWP_Request::get_string("ip_address1");
$ip_address2= AWP_Request::get_string("ip_address2");
$ip_address = $ip_address1.'-'.$ip_address2;
if(!$ip_address1) {
$error .= "Please Enter Starting IP Address
";
}else{
$validate = validateIpAddress($ip_address1);
if(!$validate) :
$error .= "Please Enter Valid Starting IP Address
";
endif;
}
if(!$ip_address2) {
$error .= "Please Enter Ending IP Address
";
}else {
$validate = validateIpAddress($ip_address2);
if(!$validate) :
$error .= "Please Enter Valid Ending IP Address
";
endif;
}
if(empty($error)) :
$start_ip = ip2long($ip_address1);
$end_ip = ip2long($ip_address2);
if($end_ip <= $start_ip)
{
$error .= "Ending IP Address Should be greater than Starting IP Address.
";
}
endif;
endif;
if(empty($error)) {
$selected_results = $wpdb->get_results("SELECT * FROM " . $table_name . " where ip_address = '". $ip_address . "' ");
if(!empty($selected_results))
{
$error = 'This IP Address already banned, Please change Your IP';
}
}
if(empty($error)) :
/* Insert into table */
$query = "INSERT INTO " . $table_name . " (ip_address, ip_type) VALUES ('". $ip_address . "','". $ip_type. "' )";
$result=mysql_query($query) or die('Unable to insert table, Error is'.mysql_error());
if($result):
echo 'Sucessfully Added
';
$ip_address = '';
$ip_type = 'Single';
endif;
else:
echo ''.$error.'
';
endif;
}
$single_select = '';
$range_select = '';
if(trim($ip_type) == 'Range') :
$range_select = ' selected="selected"';
else:
$single_select = ' selected="selected"';
endif;
/* Create Table */
$this->create_table();
echo 'Block IP Addresses
';
echo '';
$this->list_table();
?>
prefix . "absp_ipdeny"; //table Name
$Results = $wpdb->get_results("SELECT * FROM " . $table_name . " ORDER BY cur_timestamp DESC");
$datas = '';
if(empty($Results)) {
$datas = ' | No data available. | ';
}else {
foreach($Results as $selected_results):
$datas .= '
';
$datas .= '| '.$selected_results->ip_address .' | ';
$datas .= ''.$selected_results->ip_type .' | ';
$datas .= 'Delete | ';
$datas .= '
';
endforeach;
}
echo 'Blocked IP Addresses
| IP Address | IP Type | Action |
|---|
| IP Address | IP Type | Action |
|---|
'.$datas.'