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(); } } }