function insert_data($tbl, $data) { global $wpdb; $wpdb->insert($tbl, $data); } function update_data($tbl, $data, $where) { global $wpdb; $wpdb->update($tbl, $data, $where); } } } if (isset($_REQUEST["param"])) { global $wpdb; if ($_REQUEST["param"] == "add_mail_detail") { $insert = new save_data(); $email_setup = array(); $email_setup["from_name"] = htmlspecialchars_decode(esc_attr($_REQUEST["from_name"])); $email_setup["from_email"] = esc_attr($_REQUEST["ux_email_from_email"]); $email_setup["mailer_type"] = intval($_REQUEST["ux_rdl_ends"]); $email_setup["return_path"] = isset($_REQUEST["ux_chk_return_path"]) ? intval($_REQUEST["ux_chk_return_path"]) : 0; $email_setup["return_email"] = esc_attr($_REQUEST["ux_return_email"]); $email_setup["word_wrap"] = intval($_REQUEST["ux_word_wrap"]); $email_setup["smtp_host"] = esc_attr($_REQUEST["ux_smtp_host"]); $email_setup["smtp_port"] = esc_attr($_REQUEST["ux_smtp_port"]); $email_setup["encryption"] = intval($_REQUEST["ux_rdl_encrption"]); $email_setup["smtp_keep_alive"] = intval($_REQUEST["ux_rdl_smtp_alive"]); $email_setup["authentication"] = intval($_REQUEST["ux_rdl_authentication_bank"]); $email_setup["smtp_username"] = esc_attr($_REQUEST["ux_txt_username"]); $email_setup["smtp_password"] = htmlspecialchars_decode(esc_attr($_REQUEST["password"])); $count_direction = $wpdb->get_var("SELECT count(id) FROM " . wp_mail_bank());
$meta_map_array["scale_control"] = isset($_REQUEST["ux_rdl_scale_control"]) ? intval($_REQUEST["ux_rdl_scale_control"]) : "0"; $meta_map_array["overview_control"] = isset($_REQUEST["ux_rdl_overview"]) ? intval($_REQUEST["ux_rdl_overview"]) : "0"; foreach ($meta_map_array as $key => $val) { $meta_map_key["map_id"] = intval($_REQUEST["map_id"]); $meta_map_key["map_meta_key"] = $key; $meta_map_value["map_meta_value"] = $val; $insert->update_data(map_bank_meta_table(), $meta_map_value, $meta_map_key); } die; } break; case "single_map_delete": if (wp_verify_nonce($_REQUEST["_wpnonce"], "one_map_delete")) { $wpdb->query($wpdb->prepare("DELETE FROM " . map_bank_meta_table() . " WHERE map_id IN (SELECT id FROM " . map_bank_create_new_map_table() . " WHERE parent_id = %d)", intval($_REQUEST["map_id"]))); $wpdb->query($wpdb->prepare("DELETE FROM " . map_bank_create_new_map_table() . " WHERE parent_id = %d)", intval($_REQUEST["map_id"]))); $delete_single_map = new save_data(); $where = array(); $where["map_id"] = intval($_REQUEST["map_id"]); $delete_single_map->delete_data(map_bank_meta_table(), $where); $where = array(); $where["parent_id"] = intval($_REQUEST["map_id"]); $delete_single_map->delete_data(map_bank_create_new_map_table(), $where); $where = array(); $where["id"] = intval($_REQUEST["map_id"]); $delete_single_map->delete_data(map_bank_create_new_map_table(), $where); die; } break; case "google_map_plugin_updates": if (wp_verify_nonce($_REQUEST["_wpnonce"], "update_plugin_nonce")) { $plugin_update = esc_attr($_REQUEST["google_map_updates"]);