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));
?>
