function create_table_contact_bank_email_templates()
{
$sql = 'CREATE TABLE ' . contact_bank_email_template_admin() . '(
email_id INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT,
email_to VARCHAR(100) NOT NULL,
email_from VARCHAR(100) NOT NULL,
body_content TEXT NOT NULL,
subject VARCHAR(400) NOT NULL,
send_to INTEGER(1) NOT NULL,
form_id INTEGER(10) NOT NULL,
from_name VARCHAR(200) NOT NULL,
reply_to VARCHAR(200) NOT NULL,
cc VARCHAR(200) NOT NULL,
bcc VARCHAR(200) NOT NULL,
name VARCHAR(100) NOT NULL,
PRIMARY KEY (email_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_general_ci';
dbDelta($sql);
}
} else {
if ($_REQUEST["param"] == "update_email_controls") {
$form_id = intval($_REQUEST["form_id"]);
$email_id = intval($_REQUEST["email_id"]);
$email_name = esc_attr($_REQUEST["ux_txt_name"]);
$send_to = intval($_REQUEST["ux_rdl_send_to"]);
if ($send_to == 0) {
$email_address = esc_attr($_REQUEST["ux_txt_email"]);
} else {
$email_address = esc_attr($_REQUEST["ux_txt_send_to_field"]);
}
$email_from_name = esc_attr($_REQUEST["ux_txt_from_name"]);
$email_from_email = esc_attr($_REQUEST["ux_txt_from_email"]);
$email_reply_to = esc_attr($_REQUEST["ux_txt_reply_to"]);
$email_cc = esc_attr($_REQUEST["ux_txt_cc"]);
$email_bcc = esc_attr($_REQUEST["ux_txt_bcc"]);
$email_subject = esc_attr($_REQUEST["ux_txt_subject"]);
$uxDescription_email = html_entity_decode($_REQUEST["uxEmailTemplate"]);
$wpdb->query($wpdb->prepare("UPDATE " . contact_bank_email_template_admin() . " SET email_to = %s,email_from = %s,body_content = %s,subject = %s,form_id = %d,from_name = %s,reply_to = %s,cc = %s,bcc = %s,name = %s,send_to = %d WHERE email_id = %d", $email_address, $email_from_email, $uxDescription_email, $email_subject, $form_id, $email_from_name, $email_reply_to, $email_cc, $email_bcc, $email_name, $send_to, $email_id));
die;
} else {
if ($_REQUEST["param"] == "delete_email_settings") {
$email_id = intval($_REQUEST["email_id"]);
$wpdb->query($wpdb->prepare("DELETE FROM " . contact_bank_email_template_admin() . " WHERE email_id = %d ", $email_id));
die;
}
}
}
}
}
}
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="#">
<div id="form_success_message_frontend_<?php
echo $rand_value;
?>
" class="custom-message success_message" style="display: none;margin-bottom: 10px;">
$fields_created = $wpdb->get_results($wpdb->prepare("SELECT dynamicId, dynamic_settings_value,field_id\tFROM " . 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));
$controls = "";
$email_dynamicId = "";
for ($flag = 0; $flag < count($fields_created); $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_created[$flag]->dynamicId));
if ($show_in_email == "0") {
$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"]);
<a class="btn btn-info" href="admin.php?page=contact_dashboard"><?php
_e("Back to Dashboard", contact_bank);
?>
</a>
<div class="separator-doubled"></div>
<div class="fluid-layout">
<div class="layout-control-group span">
<label class="layout-control-label"><?php
_e("Select Form", contact_bank);
?>
:</label>
<div class="layout-controls">
<?php
global $wpdb;
$forms = $wpdb->get_results("SELECT form_id,form_name FROM " . contact_bank_contact_form());
$email_count = $wpdb->get_var("SELECT count(email_id) FROM " . contact_bank_email_template_admin());
?>
<select class=" layout-span10" id="ux_ddl_select_form" name="ux_ddl_select_form" onchange="select_form();">
<option value="0"><?php
_e("Select Form", contact_bank);
?>
</option>
<?php
for ($flag = 0; $flag < count($forms); $flag++) {
if (isset($_REQUEST["form_id"]) && intval($_REQUEST["form_id"]) == $forms[$flag]->form_id) {
?>
<option value="<?php
echo $forms[$flag]->form_id;
?>
" selected="selected"><?php
echo $forms[$flag]->form_name;
<?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"] == "email_management") {
$form_id = intval($_REQUEST["form_id"]);
$form_submit_id = intval($_REQUEST["submit_id"]);
$file_uploaded_path_admin = "";
$email_content = $wpdb->get_results($wpdb->prepare("SELECT * FROM " . contact_bank_email_template_admin() . " WHERE form_id = %d ", $form_id));
$frontend_control_value = $wpdb->get_results($wpdb->prepare("SELECT * FROM " . contact_bank_frontend_forms_Table() . " JOIN " . frontend_controls_data_Table() . " ON " . contact_bank_frontend_forms_Table() . ".submit_id = " . frontend_controls_data_Table() . ".form_submit_id WHERE " . contact_bank_frontend_forms_Table() . ".submit_id = %d", $form_submit_id));
for ($flag = 0; $flag < count($email_content); $flag++) {
$email_exits = "";
$email_to = $email_content[$flag]->email_to;
$email_from = stripslashes($email_content[$flag]->email_from);
$messageTxt = stripcslashes($email_content[$flag]->body_content);
$email_subject = stripslashes($email_content[$flag]->subject);
$email_from_name = stripslashes(htmlspecialchars_decode($email_content[$flag]->from_name, ENT_QUOTES));
$email_reply_to = $email_content[$flag]->reply_to;
$email_cc = $email_content[$flag]->cc;
$email_bcc = $email_content[$flag]->bcc;
for ($flag1 = 0; $flag1 < count($frontend_control_value); $flag1++) {
$dynamicId = $frontend_control_value[$flag1]->dynamic_control_id;
$email_to = str_replace("[control_" . $dynamicId . "]", $frontend_control_value[$flag1]->dynamic_frontend_value, $email_to);
$email_from = str_replace("[control_" . $dynamicId . "]", $frontend_control_value[$flag1]->dynamic_frontend_value, $email_from);
$email_subject = str_replace("[control_" . $dynamicId . "]", $frontend_control_value[$flag1]->dynamic_frontend_value, $email_subject);
$email_from_name = str_replace("[control_" . $dynamicId . "]", $frontend_control_value[$flag1]->dynamic_frontend_value, $email_from_name);
$email_reply_to = str_replace("[control_" . $dynamicId . "]", $frontend_control_value[$flag1]->dynamic_frontend_value, $email_reply_to);
$email_cc = str_replace("[control_" . $dynamicId . "]", $frontend_control_value[$flag1]->dynamic_frontend_value, $email_cc);
$email_bcc = str_replace("[control_" . $dynamicId . "]", $frontend_control_value[$flag1]->dynamic_frontend_value, $email_bcc);
if ($frontend_control_value[$flag1]->field_Id == 5) {
$chk_options = str_replace("-", ", ", $frontend_control_value[$flag1]->dynamic_frontend_value);
$cb_user_role_permission = "manage_options";
break;
case "editor":
$cb_user_role_permission = "publish_pages";
break;
case "author":
$cb_user_role_permission = "publish_posts";
break;
}
if (!current_user_can($cb_user_role_permission)) {
return;
} else {
$form_id = intval($_REQUEST["form_id"]);
isset($_REQUEST["email_id"]) ? $email_id = intval($_REQUEST["email_id"]) : ($email_id = "");
$fields_email = $wpdb->get_results($wpdb->prepare("SELECT * FROM " . create_control_Table() . " WHERE form_id = %d and field_id = %d ORDER BY " . create_control_Table() . ".sorting_order", $form_id, 3));
$email_data = $wpdb->get_row($wpdb->prepare("SELECT * FROM " . contact_bank_email_template_admin() . " where form_id= %d and email_id = %d", $form_id, $email_id));
?>
<form id="ux_frm_add_email" class="layout-form">
<div id="poststuff" style="width: 99% !important;">
<div id="post-body" class="metabox-holder">
<div id="postbox-container" class="postbox-container">
<div id="advanced" class="meta-box-sortables">
<div id="contact_bank_get_started" class="postbox" >
<div class="handlediv" data-target="#ux_form_email_div" title="Click to toggle" data-toggle="collapse"><br></div>
<h3 class="hndle"><span><?php
_e("Email Confirmation", contact_bank);
?>
</span></h3>
<div class="inside">
<div id="ux_form_email_div" class="contact_bank_layout">
<a class="btn btn-info" href="admin.php?page=contact_email"><?php
}
$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, ""));
}
}
$form_data = $wpdb->get_results($wpdb->prepare("SELECT * FROM " . contact_bank_form_settings_Table() . " where form_id = %d", $form_id));
for ($flag = 0; $flag < count($form_data); $flag++) {
$form_settings[$form_id][$form_data[$flag]->form_message_key] = $form_data[$flag]->form_message_value;
}
$form_name = $wpdb->get_var($wpdb->prepare("SELECT form_name FROM " . contact_bank_contact_form() . " where form_id = %d", $form_id));
//}
?>
<form id="ux_dynamic_form_submit" class="layout-form">
<div id="poststuff" style="width: 99% !important;">
<div id="post-body" class="metabox-holder">
<div id="postbox-container" class="postbox-container">
<div id="advanced" class="meta-box-sortables">
<div id="contact_bank_get_started" class="postbox" >
