function create_table_contact_bank_controls()
{
$sql = 'CREATE TABLE ' . create_control_Table() . '(
control_id INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT,
field_id INTEGER(50) NOT NULL,
form_id INTEGER(10) NOT NULL,
column_dynamicId INTEGER(10) NOT NULL,
sorting_order INTEGER(10) NOT NULL,
PRIMARY KEY(control_id)
)ENGINE = MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_general_ci';
dbDelta($sql);
}
_e("Shortcode", contact_bank);
?>
</th>
<th style="width: 15%"><?php
_e("Total Controls", contact_bank);
?>
</th>
<th style="width: 45%" style="padding-left: 5%;"></th>
</tr>
</thead>
<tbody>
<?php
global $wpdb;
$form_data = $wpdb->get_results("SELECT * FROM " . contact_bank_contact_form());
for ($flag = 0; $flag < count($form_data); $flag++) {
$total_control = $wpdb->get_var($wpdb->prepare(" SELECT count(" . contact_bank_contact_form() . ".form_id) FROM " . contact_bank_contact_form() . " JOIN " . create_control_Table() . " ON " . create_control_Table() . ".form_id = " . contact_bank_contact_form() . ".form_id WHERE " . contact_bank_contact_form() . ".form_id = %d", $form_data[$flag]->form_id));
?>
<tr>
<td>
<?php
echo $form_data[$flag]->form_name;
?>
</td>
<td>
<?php
echo "[contact_bank form_id=" . $form_data[$flag]->form_id . "]";
?>
</td>
<td>
<?php
echo $total_control;
<?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;
if (isset($_REQUEST["param"])) {
if ($_REQUEST["param"] == "frontend_submit_controls") {
$form_id = intval($_REQUEST["form_id"]);
$fields = $wpdb->get_results($wpdb->prepare("SELECT field_id,column_dynamicId,control_id FROM " . create_control_Table() . " WHERE form_id = %d", $form_id));
$wpdb->query($wpdb->prepare("INSERT INTO " . contact_bank_frontend_forms_Table() . " (form_id) VALUES(%d)", $form_id));
echo $form_submit_id = $wpdb->insert_id;
$wpdb->query($wpdb->prepare("UPDATE " . contact_bank_frontend_forms_Table() . " SET submit_id = %d WHERE id = %d", $form_submit_id, $form_submit_id));
for ($flag = 0; $flag < count($fields); $flag++) {
$field_id = $fields[$flag]->field_id;
$dynamicId = $fields[$flag]->column_dynamicId;
$control_dynamicId = $fields[$flag]->control_id;
switch ($field_id) {
case 1:
$ux_txt = esc_attr($_REQUEST["ux_txt_control_" . $dynamicId]);
$wpdb->query($wpdb->prepare("INSERT INTO " . frontend_controls_data_Table() . " (form_id,field_id,dynamic_control_id,dynamic_frontend_value,form_submit_id) VALUES(%d,%d,%d,%s,%d)", $form_id, $field_id, $control_dynamicId, $ux_txt, $form_submit_id));
break;
case 2:
$ux_textarea = esc_attr($_REQUEST["ux_textarea_control_" . $dynamicId]);
$wpdb->query($wpdb->prepare("INSERT INTO " . frontend_controls_data_Table() . " (form_id,field_id,dynamic_control_id,dynamic_frontend_value,form_submit_id) VALUES(%d,%d,%d,%s,%d)", $form_id, $field_id, $control_dynamicId, $ux_textarea, $form_submit_id));
break;
case 3:
$ux_email = esc_attr($_REQUEST["ux_txt_email_" . $dynamicId]);
$wpdb->query($wpdb->prepare("INSERT INTO " . frontend_controls_data_Table() . " (form_id,field_id,dynamic_control_id,dynamic_frontend_value,form_submit_id) VALUES(%d,%d,%d,%s,%d)", $form_id, $field_id, $control_dynamicId, $ux_email, $form_submit_id));
break;
case 4:
$ux_dropdown = esc_attr($_REQUEST["ux_select_default_" . $dynamicId]);
$wpdb->query($wpdb->prepare("INSERT INTO " . frontend_controls_data_Table() . " (form_id,field_id,dynamic_control_id,dynamic_frontend_value,form_submit_id) VALUES(%d,%d,%d,%s,%d)", $form_id, $field_id, $control_dynamicId, $ux_dropdown, $form_submit_id));
break;
<?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;
?>
">
case 15:
alert("<?php
_e("This Feature is only available in Paid Premium Edition!", contact_bank);
?>
");
break;
case 16:
alert("<?php
_e("This Feature is only available in Paid Premium Edition!", contact_bank);
?>
");
break;
}
}
<?php
$form_data = $wpdb->get_results($wpdb->prepare("SELECT * FROM " . create_control_Table() . " where form_id= %d order by sorting_order asc", $form_id));
for ($flag = 0; $flag < count($form_data); $flag++) {
?>
create_control(<?php
echo $form_data[$flag]->field_id;
?>
,<?php
echo $form_data[$flag]->column_dynamicId;
?>
,"edit");
<?php
}
?>
function prevent_paste(control_id)
{
jQuery("#"+control_id).live("paste",function(e)
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") {
update_option("contact-bank-info-popup", "no");
die;
}
}
}
}
}
}
}
}
}
}
<?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++) {
?>
_e("Save", contact_bank);
?>
" />
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</form>
<script type="text/javascript">
<?php
$fields_email_controls = $wpdb->get_results($wpdb->prepare("SELECT dynamicId, dynamic_settings_value FROM " . contact_bank_dynamic_settings_form() . " JOIN " . create_control_Table() . " ON " . contact_bank_dynamic_settings_form() . ". dynamicId = " . create_control_Table() . ".control_id WHERE `dynamic_settings_key` = 'cb_admin_label' and field_id = 3 and form_id = %d", $form_id));
$fields_controls = $wpdb->get_results($wpdb->prepare("SELECT dynamicId, dynamic_settings_value FROM " . contact_bank_dynamic_settings_form() . " JOIN " . create_control_Table() . " ON " . contact_bank_dynamic_settings_form() . ". dynamicId = " . create_control_Table() . ".control_id WHERE `dynamic_settings_key` = 'cb_admin_label' and form_id = %d Order By " . create_control_Table() . ".sorting_order", $form_id));
for ($flag = 0; $flag < count($fields_email_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_email_controls[$flag]->dynamicId));
if ($show_in_email == "0") {
?>
jQuery("#ux_ddl_from_email").append(jQuery("<option></option>").attr("value", "<?php
echo $fields_email_controls[$flag]->dynamicId;
?>
").text("<?php
echo $fields_email_controls[$flag]->dynamic_settings_value;
?>
"));
jQuery("#ux_ddl_send_to_field").append(jQuery("<option></option>").attr("value", "<?php
echo $fields_email_controls[$flag]->dynamicId;
?>
").text("<?php
