$controls .= "<strong>" . $fields_created[$flag]->dynamic_settings_value . "</strong>: " . "[control_" . $fields_created[$flag]->dynamicId . "] <br>"; } if ($fields_created[$flag]->field_id == 3) { $email_dynamicId = $fields_created[$flag]->dynamicId; } } $body_message = "Hello Admin,<br><br>\n\t\t\tA new user visited your website.<br><br>\n\t\t\tHere are the details :<br><br>\n\t\t\t" . $controls . "\n\t\t\t<br>Thanks,<br><br>\n\t\t\t<strong>Technical Support Team</strong>"; $wpdb->query($wpdb->prepare("UPDATE " . contact_bank_email_template_admin() . " SET `body_content` = %s where form_id = %d and name = %s", $body_message, $form_id, "Admin Notification")); $wpdb->query($wpdb->prepare("UPDATE " . contact_bank_email_template_admin() . " SET `email_to` = %s where form_id = %d and name = %s", "[control_" . $email_dynamicId . "]", $form_id, "Client Notification")); $wpdb->query($wpdb->prepare("UPDATE " . contact_bank_email_template_admin() . " SET `send_to` = %d where form_id = %d and name = %s", 1, $form_id, "Client Notification")); die; } else { if ($_REQUEST["param"] == "update_licensing_settings") { $api_key = esc_attr($_REQUEST["ux_api_key"]); $order_id = esc_attr($_REQUEST["ux_order_id"]); $wpdb->query($wpdb->prepare("UPDATE " . contact_bank_licensing() . " SET api_key = %s, order_id = %s ", $api_key, $order_id)); update_option("contact-bank-activation", $api_key); die; } else { if ($_REQUEST["param"] == "restore_factory_settings") { include_once CONTACT_BK_PLUGIN_DIR . "/lib/restore_factory_settings.php"; die; } else { if ($_REQUEST["param"] == "save_text_control") { $dynamic_Id = intval($_REQUEST["ux_hd_textbox_dynamic_id"]); $form_id = intval($_REQUEST["form_id"]); $event = esc_attr($_REQUEST["event"]); $controlId = isset($_REQUEST["controlId"]) ? intval($_REQUEST["controlId"]) : 0; $form_settings = isset($_REQUEST["form_settings"]) ? json_decode(stripcslashes($_REQUEST["form_settings"]), true) : array(); $form_settings[$dynamic_Id]["dynamic_id"] = $dynamic_Id; $form_settings[$dynamic_Id]["control_type"] = "1";
function create_cb_table_licensing() { global $wpdb; $sql = "CREATE TABLE " . contact_bank_licensing() . "(\r\n\t\tlicensing_id INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT,\r\n\t\tversion VARCHAR(10) NOT NULL,\r\n\t\ttype VARCHAR(100) NOT NULL,\r\n\t\turl TEXT NOT NULL,\r\n\t\tapi_key TEXT NOT NULL,\r\n\t\torder_id VARCHAR(100) NOT NULL,\r\n\t\tPRIMARY KEY (licensing_id)\r\n\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_general_ci"; dbDelta($sql); $wpdb->query($wpdb->prepare("INSERT INTO " . contact_bank_licensing() . "(version, type, url) VALUES(%s, %s, %s)", "2.1.0", "Contact Bank", "" . site_url() . "")); }
<?php global $wpdb; $sql = "DROP TABLE " . contact_bank_contact_form(); $wpdb->query($sql); $sql = "DROP TABLE " . create_control_Table(); $wpdb->query($sql); $sql = "DROP TABLE " . contact_bank_dynamic_settings_form(); $wpdb->query($sql); $sql = "DROP TABLE " . contact_bank_email_template_admin(); $wpdb->query($sql); $sql = "DROP TABLE " . frontend_controls_data_Table(); $wpdb->query($sql); $sql = "DROP TABLE " . contact_bank_frontend_forms_Table(); $wpdb->query($sql); $sql = "DROP TABLE " . contact_bank_form_settings_Table(); $wpdb->query($sql); $sql = "DROP TABLE " . contact_bank_layout_settings_Table(); $wpdb->query($sql); $sql = "DROP TABLE " . contact_bank_licensing(); $wpdb->query($sql); $sql = "DROP TABLE " . contact_bank_roles_capability(); $wpdb->query($sql); delete_option("contact-bank-info-popup"); delete_option("contact-bank-version-number");