function create_table_contact_bank_dynamic_settings() { $sql = 'CREATE TABLE ' . contact_bank_dynamic_settings_form() . '( dynamic_settings_id INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT, dynamicId INTEGER(10) NOT NULL, dynamic_settings_key VARCHAR(100) NOT NULL, dynamic_settings_value TEXT NOT NULL, PRIMARY KEY (dynamic_settings_id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_general_ci'; dbDelta($sql); }
<?php $form_settings = array(); $control_id = $wpdb->get_var($wpdb->prepare("SELECT control_id FROM " . create_control_Table() . " where form_id= %d and field_id = %d and column_dynamicId = %d", $form_id, $field_type, $dynamicId)); if (count($control_id) != 0) { $form_data = $wpdb->get_results($wpdb->prepare("SELECT * FROM " . contact_bank_dynamic_settings_form() . " where dynamicId= %d", $control_id)); $form_settings[$dynamicId]["dynamic_id"] = $dynamicId; $form_settings[$dynamicId]["control_type"] = "1"; for ($flag = 0; $flag < count($form_data); $flag++) { $form_settings[$dynamicId][$form_data[$flag]->dynamic_settings_key] = $form_data[$flag]->dynamic_settings_value; } } ?> <form id="ux_frm_email_control" action="#" method="post" class="layout-form"> <div class="fluid-layout"> <div class="layout-span12"> <div class="widget-layout"> <div class="widget-layout-title"> <h4><?php _e("Email Address", contact_bank); ?> </h4> </div> <div class="widget-layout-body" > <div class="layout-control-group"> <label class="layout-control-label"><?php _e("Label", contact_bank); ?> :</label> <div class="layout-controls"> <input type="text" onkeyup="enter_admin_label(<?php
<?php global $wpdb; $control_settings_array = array(); $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; ?> ">
} foreach ($element as $key => $value) { if ($key == "dynamic_id" || $key == "control_type") { continue; } else { if ($event == "add") { $sql[] = '(' . $dynamic_control_id . ',"' . mysql_real_escape_string($key) . '", "' . mysql_real_escape_string($value) . '")'; } else { $sql .= 'WHEN `dynamic_settings_key` = "' . mysql_real_escape_string($key) . '" THEN "' . mysql_real_escape_string($value) . '"'; } } } if ($event == "add") { $wpdb->query($wpdb->prepare("INSERT INTO " . contact_bank_dynamic_settings_form() . "(dynamicId,dynamic_settings_key,dynamic_settings_value) VALUES " . implode(',', $sql), "")); } else { $wpdb->query($wpdb->prepare("UPDATE " . contact_bank_dynamic_settings_form() . " SET `dynamic_settings_value` = CASE " . $sql . " END where dynamicId = %d ", $controlId)); } } die; } else { if ($_REQUEST["param"] == "form_fields_sorting_order") { $form_id = intval($_REQUEST["form_id"]); $field_dynamic_id = isset($_REQUEST["field_dynamic_id"]) ? json_decode(stripcslashes($_REQUEST["field_dynamic_id"]), true) : array(); $sql = ""; foreach ($field_dynamic_id as $key => $val) { $sql .= ' WHEN `column_dynamicId` = "' . $val . '" THEN "' . $key . '"'; } $wpdb->query($wpdb->prepare("UPDATE " . create_control_Table() . " SET `sorting_order` = CASE " . $sql . " END where form_id = %d ", $form_id)); die; } else { if ($_REQUEST["param"] == "update_option") {
<?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");
<?php global $wpdb; if (isset($_REQUEST["param"])) { if ($_REQUEST["param"] == "frontend_form_data") { $form_id = intval($_REQUEST["form_id"]); $form_data = $wpdb->get_results($wpdb->prepare("SELECT * FROM " . create_control_Table() . " WHERE form_id = %d ORDER BY sorting_order ASC", $form_id)); ?> <div id="dvData"> <table class="table table-striped" id="data-table-frontend" style="width:100%;"> <thead> <tr> <?php for ($flag = 0; $flag < count($form_data); $flag++) { $form_control_labels = $wpdb->get_var($wpdb->prepare("SELECT dynamic_settings_value FROM " . contact_bank_dynamic_settings_form() . " WHERE dynamicId = %d AND dynamic_settings_key = %s", $form_data[$flag]->control_id, "cb_label_value")); ?> <td><?php echo $form_control_labels; ?> </td> <?php } ?> <td></td> </tr> </thead> <tbody> <?php $form_submit_count = $wpdb->get_results($wpdb->prepare("SELECT * FROM " . contact_bank_frontend_forms_Table() . " WHERE form_id = %d", $form_id)); for ($flag1 = 0; $flag1 < count($form_submit_count); $flag1++) { ?>
").text("<?php echo $fields_email_controls[$flag]->dynamic_settings_value; ?> ")); jQuery("#ux_ddl_bcc").append(jQuery("<option></option>").attr("value", "<?php echo $fields_email_controls[$flag]->dynamicId; ?> ").text("<?php echo $fields_email_controls[$flag]->dynamic_settings_value; ?> ")); <?php } } for ($flag = 0; $flag < count($fields_controls); $flag++) { $show_in_email = $wpdb->get_var($wpdb->prepare("SELECT dynamic_settings_value FROM " . contact_bank_dynamic_settings_form() . " WHERE `dynamic_settings_key` = 'cb_show_email' and dynamicId = %d", $fields_controls[$flag]->dynamicId)); if ($show_in_email == "0") { ?> jQuery("#ux_ddl_from_name").append(jQuery("<option></option>").attr("value", "<?php echo $fields_controls[$flag]->dynamicId; ?> ").text("<?php echo stripslashes(htmlspecialchars_decode($fields_controls[$flag]->dynamic_settings_value, ENT_QUOTES)); ?> ")); jQuery("#ux_ddl_subject").append(jQuery("<option></option>").attr("value", "<?php echo $fields_controls[$flag]->dynamicId; ?> ").text("<?php echo stripslashes(htmlspecialchars_decode($fields_controls[$flag]->dynamic_settings_value, ENT_QUOTES)); ?>