function delete_404_event_records($entries)
{
global $wpdb, $aio_wp_security;
$events_table = AIOWPSEC_TBL_EVENTS;
if (is_array($entries)) {
if (isset($_REQUEST['_wp_http_referer'])) {
//Delete multiple records
$entries = array_map('esc_sql', $entries);
//escape every array element
$id_list = "(" . implode(",", $entries) . ")";
//Create comma separate list for DB operation
$delete_command = "DELETE FROM " . $events_table . " WHERE id IN " . $id_list;
$result = $wpdb->query($delete_command);
if ($result != NULL) {
AIOWPSecurity_Admin_Menu::show_msg_record_deleted_st();
}
}
} elseif ($entries != NULL) {
$nonce = isset($_GET['aiowps_nonce']) ? $_GET['aiowps_nonce'] : '';
if (!isset($nonce) || !wp_verify_nonce($nonce, 'delete_404_log')) {
$aio_wp_security->debug_logger->log_debug("Nonce check failed for delete selected 404 event logs operation!", 4);
die(__('Nonce check failed for delete selected 404 event logs operation!', 'aiowpsecurity'));
}
//Delete single record
$delete_command = "DELETE FROM " . $events_table . " WHERE id = '" . absint($entries) . "'";
//$delete_command = $wpdb->prepare("DELETE FROM $events_table WHERE id = %s", absint($entries));
$result = $wpdb->query($delete_command);
if ($result != NULL) {
AIOWPSecurity_Admin_Menu::show_msg_record_deleted_st();
}
}
}
function delete_lockdown_records($entries)
{
global $wpdb;
$lockdown_table = AIOWPSEC_TBL_LOGIN_LOCKDOWN;
if (is_array($entries)) {
//Delete multiple records
$id_list = "(" . implode(",", $entries) . ")";
//Create comma separate list for DB operation
$delete_command = "DELETE FROM " . $lockdown_table . " WHERE id IN " . $id_list;
$result = $wpdb->query($delete_command);
if ($result != NULL) {
AIOWPSecurity_Admin_Menu::show_msg_record_deleted_st();
}
} elseif ($entries != NULL) {
//Delete single record
$delete_command = "DELETE FROM " . $lockdown_table . " WHERE id = '" . absint($entries) . "'";
$result = $wpdb->query($delete_command);
if ($result != NULL) {
AIOWPSecurity_Admin_Menu::show_msg_record_deleted_st();
}
}
}
function unblock_ip_address($entries)
{
global $wpdb, $aio_wp_security;
if (is_array($entries)) {
if (isset($_REQUEST['_wp_http_referer'])) {
//Delete multiple records
$entries = array_filter($entries, 'is_numeric');
//discard non-numeric ID values
$id_list = "(" . implode(",", $entries) . ")";
//Create comma separate list for DB operation
$delete_command = "DELETE FROM " . AIOWPSEC_TBL_PERM_BLOCK . " WHERE id IN " . $id_list;
$result = $wpdb->query($delete_command);
if ($result != NULL) {
AIOWPSecurity_Admin_Menu::show_msg_record_deleted_st();
}
}
} elseif ($entries != NULL) {
$nonce = isset($_GET['aiowps_nonce']) ? $_GET['aiowps_nonce'] : '';
if (!isset($nonce) || !wp_verify_nonce($nonce, 'unblock_ip')) {
$aio_wp_security->debug_logger->log_debug("Nonce check failed for unblock IP operation!", 4);
die(__('Nonce check failed for unblock IP operation!', 'all-in-one-wp-security-and-firewall'));
}
//Delete single record
$delete_command = "DELETE FROM " . AIOWPSEC_TBL_PERM_BLOCK . " WHERE id = '" . absint($entries) . "'";
$result = $wpdb->query($delete_command);
if ($result != NULL) {
AIOWPSecurity_Admin_Menu::show_msg_record_deleted_st();
}
}
}
function delete_lockdown_records($entries)
{
global $wpdb, $aio_wp_security;
$lockdown_table = AIOWPSEC_TBL_LOGIN_LOCKDOWN;
if (is_array($entries)) {
if (isset($_REQUEST['_wp_http_referer'])) {
//Delete multiple records
$id_list = "(" . implode(",", $entries) . ")";
//Create comma separate list for DB operation
$delete_command = "DELETE FROM " . $lockdown_table . " WHERE id IN " . $id_list;
$result = $wpdb->query($delete_command);
if ($result != NULL) {
AIOWPSecurity_Admin_Menu::show_msg_record_deleted_st();
}
}
} elseif ($entries != NULL) {
$nonce = isset($_GET['aiowps_nonce']) ? $_GET['aiowps_nonce'] : '';
if (!isset($nonce) || !wp_verify_nonce($nonce, 'delete_lockdown_record')) {
$aio_wp_security->debug_logger->log_debug("Nonce check failed for delete lockdown record operation!", 4);
die(__('Nonce check failed for delete lockdown record operation!', 'aiowpsecurity'));
}
//Delete single record
$delete_command = "DELETE FROM " . $lockdown_table . " WHERE id = '" . absint($entries) . "'";
$result = $wpdb->query($delete_command);
if ($result != NULL) {
AIOWPSecurity_Admin_Menu::show_msg_record_deleted_st();
}
}
}
