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" >