$form_settings_array = array();
$layout_settings_array = array();
$form_name = $wpdb->get_var($wpdb->prepare("SELECT form_name FROM " . contact_bank_contact_form() . " WHERE form_id = %d", $form_id));
$form_fields = $wpdb->get_results($wpdb->prepare("SELECT control_id,column_dynamicId,field_id,sorting_order FROM " . create_control_Table() . " WHERE form_id = %d ORDER BY sorting_order asc", $form_id));
for ($flag = 0; $flag < count($form_fields); $flag++) {
$control_settings = $wpdb->get_results($wpdb->prepare("SELECT * FROM " . contact_bank_dynamic_settings_form() . " WHERE dynamicId = %d", $form_fields[$flag]->control_id));
for ($flag1 = 0; $flag1 < count($control_settings); $flag1++) {
$column_dynamicId = $form_fields[$flag]->column_dynamicId;
$control_settings_array[$column_dynamicId][$control_settings[$flag1]->dynamic_settings_key] = $control_settings[$flag1]->dynamic_settings_value;
}
}
$form_settings = $wpdb->get_results($wpdb->prepare("SELECT form_message_key,form_message_value FROM " . contact_bank_form_settings_Table() . " WHERE form_id = %d", $form_id));
for ($flag2 = 0; $flag2 < count($form_settings); $flag2++) {
$form_settings_array[$form_id][$form_settings[$flag2]->form_message_key] = $form_settings[$flag2]->form_message_value;
}
$forms_layout_settings = $wpdb->get_results($wpdb->prepare("SELECT form_settings_key,form_settings_value FROM " . contact_bank_layout_settings_Table() . " WHERE form_id = %d", $form_id));
for ($flag3 = 0; $flag3 < count($forms_layout_settings); $flag3++) {
$layout_settings_array[$form_id][$forms_layout_settings[$flag3]->form_settings_key] = $forms_layout_settings[$flag3]->form_settings_value;
}
$forms_email_settings = $wpdb->get_row($wpdb->prepare("SELECT * FROM " . contact_bank_email_template_admin() . " WHERE form_id = %d", $form_id));
$rand_value = RAND(10, 10000);
?>
<div class="cb_form_wrapper" id="cb_form_wrapper_<?php
echo $form_id;
?>
">
<form id="ux_frm_front_end_form_<?php
echo $form_id . "_" . $rand_value;
?>
" class="form-horizontal" method="post" action="#">
function create_contact_bank_layout_settings()
{
$sql = 'CREATE TABLE ' . contact_bank_layout_settings_Table() . '(
id INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT,
form_id INTEGER(10) NOT NULL,
form_settings_key VARCHAR(200) NOT NULL,
form_settings_value VARCHAR(200) NOT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_general_ci';
dbDelta($sql);
}
<?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");
$wpdb->query($wpdb->prepare("DELETE FROM " . contact_bank_form_settings_Table() . " WHERE form_id = %d ", $form_id));
$wpdb->query($wpdb->prepare("DELETE FROM " . frontend_controls_data_Table() . " WHERE form_id = %d ", $form_id));
$wpdb->query($wpdb->prepare("DELETE FROM " . contact_bank_frontend_forms_Table() . " WHERE form_id = %d ", $form_id));
$wpdb->query($wpdb->prepare("DELETE FROM " . contact_bank_layout_settings_Table() . " WHERE form_id = %d ", $form_id));
$wpdb->query($wpdb->prepare("DELETE FROM " . create_control_Table() . " WHERE form_id = %d ", $form_id));
$wpdb->query($wpdb->prepare("DELETE FROM " . contact_bank_contact_form() . " WHERE form_id = %d ", $form_id));
die;
} else {
if ($_REQUEST["param"] == "delete_forms") {
global $wpdb;
$wpdb->query("TRUNCATE Table " . contact_bank_dynamic_settings_form());
$wpdb->query("TRUNCATE Table " . contact_bank_email_template_admin());
$wpdb->query("TRUNCATE Table " . contact_bank_form_settings_Table());
$wpdb->query("TRUNCATE Table " . frontend_controls_data_Table());
$wpdb->query("TRUNCATE Table " . contact_bank_frontend_forms_Table());
$wpdb->query("TRUNCATE Table " . contact_bank_layout_settings_Table());
$wpdb->query("TRUNCATE Table " . create_control_Table());
$wpdb->query("TRUNCATE Table " . contact_bank_contact_form());
die;
} else {
if ($_REQUEST["param"] == "submit_form_messages_settings") {
$sql = "";
$labels_for_email = "";
$sql1 = array();
$form_id = intval($_REQUEST["form_id"]);
$form_settings = json_decode(stripcslashes($_REQUEST["form_settings"]), true);
$array_delete_form_controls = json_decode(stripcslashes($_REQUEST["array_delete_form_controls"]), true);
foreach ($array_delete_form_controls as $element) {
$sql1[] = $element;
}
if (count($sql1) > 0) {
$settings["success_msg_bg_color"] = "#e5ffd5";
$settings["success_msg_border_color"] = "#e5ffd5";
$settings["success_msg_text_color"] = "#6aa500";
$settings["success_msg_rdl_text_align"] = "0";
$settings["success_msg_text_direction"] = "inherit";
$settings["error_msg_font_family"] = "inherit";
$settings["error_msg_font_size"] = "12";
$settings["error_msg_bg_color"] = "#ffcaca";
$settings["error_msg_border_color"] = "#ffcaca";
$settings["error_msg_text_color"] = "#ff2c38";
$settings["error_msg_rdl_text_align"] = "0";
$settings["error_msg_text_direction"] = "inherit";
foreach ($settings as $key => $value) {
$sql[] = '(' . $form_id . ',"' . $key . '", "' . $value . '")';
}
$wpdb->query("INSERT INTO " . contact_bank_layout_settings_Table() . "(form_id,form_settings_key,form_settings_value) VALUES " . implode(',', $sql));
$email_name = "Admin Notification";
$send_to = get_option('admin_email');
$email_address = get_option('admin_email');
$email_from_name = "Site Administration";
$email_from_email = get_option('admin_email');
$email_subject = "New Contact recieved from Website";
$uxDescription_email = "Hello Admin,<br><br>\r\n\t\t\t\tA new user has visited your website.<br><br>\r\n\t\t\t\tHere are the details :<br><br>\r\n\t\t\t\t<br>Thanks,<br><br>\r\n\t\t\t\t<strong>Technical Support Team</strong>";
$wpdb->query($wpdb->prepare("INSERT INTO " . contact_bank_email_template_admin() . " (email_to,email_from,body_content,subject,form_id,from_name,name,send_to) VALUES(%s,%s,%s,%s,%d,%s,%s,%d)", $email_address, $email_from_email, $uxDescription_email, $email_subject, $form_id, $email_from_name, $email_name, $send_to));
$email_name_client = "Client Notification";
$email_subject_client = "Thanks for visiting our website";
$email_from_name = "Site Administration";
$email_from_email = get_option('admin_email');
$uxDescription_email_client = "Hi,<br><br>\r\n\t\t\t\tThanks for visiting our website. We will be Contacting you soon next 24 hours.<br><br>\r\n\t\t\t\t<br>Thanks,<br><br>\r\n\t\t\t\t<strong>Support Team</strong>\r\n\t\t\t\t";
$wpdb->query($wpdb->prepare("INSERT INTO " . contact_bank_email_template_admin() . " (email_to,email_from,body_content,subject,form_id,from_name,name,send_to) VALUES(%s,%s,%s,%s,%d,%s,%s,%d)", "", $email_from_email, $uxDescription_email_client, $email_subject_client, $form_id, $email_from_name, $email_name_client, ""));
}
