function create_table_contact_bank_front_end_forms()
{
$sql = 'CREATE TABLE ' . contact_bank_frontend_forms_Table() . '(
id INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT,
form_id INTEGER(10) NOT NULL,
submit_id INTEGER(10) NOT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_general_ci';
dbDelta($sql);
}
<?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;
$wpdb->query($wpdb->prepare("DELETE FROM " . contact_bank_email_template_admin() . " WHERE form_id = %d ", $form_id));
$wpdb->query($wpdb->prepare("DELETE FROM " . contact_bank_form_settings_Table() . " WHERE form_id = %d ", $form_id));
$wpdb->query($wpdb->prepare("DELETE FROM " . frontend_controls_data_Table() . " WHERE form_id = %d ", $form_id));
$wpdb->query($wpdb->prepare("DELETE FROM " . contact_bank_frontend_forms_Table() . " WHERE form_id = %d ", $form_id));
$wpdb->query($wpdb->prepare("DELETE FROM " . contact_bank_layout_settings_Table() . " WHERE form_id = %d ", $form_id));
$wpdb->query($wpdb->prepare("DELETE FROM " . create_control_Table() . " WHERE form_id = %d ", $form_id));
$wpdb->query($wpdb->prepare("DELETE FROM " . contact_bank_contact_form() . " WHERE form_id = %d ", $form_id));
die;
} else {
if ($_REQUEST["param"] == "delete_forms") {
global $wpdb;
$wpdb->query("TRUNCATE Table " . contact_bank_dynamic_settings_form());
$wpdb->query("TRUNCATE Table " . contact_bank_email_template_admin());
$wpdb->query("TRUNCATE Table " . contact_bank_form_settings_Table());
$wpdb->query("TRUNCATE Table " . frontend_controls_data_Table());
$wpdb->query("TRUNCATE Table " . contact_bank_frontend_forms_Table());
$wpdb->query("TRUNCATE Table " . contact_bank_layout_settings_Table());
$wpdb->query("TRUNCATE Table " . create_control_Table());
$wpdb->query("TRUNCATE Table " . contact_bank_contact_form());
die;
} else {
if ($_REQUEST["param"] == "submit_form_messages_settings") {
$sql = "";
$labels_for_email = "";
$sql1 = array();
$form_id = intval($_REQUEST["form_id"]);
$form_settings = json_decode(stripcslashes($_REQUEST["form_settings"]), true);
$array_delete_form_controls = json_decode(stripcslashes($_REQUEST["array_delete_form_controls"]), true);
foreach ($array_delete_form_controls as $element) {
$sql1[] = $element;
}
<?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);
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++) {
?>
<tr>
<?php
for ($flag2 = 0; $flag2 < count($form_data); $flag2++) {
$form_control_labels_values = $wpdb->get_var($wpdb->prepare("SELECT dynamic_frontend_value FROM " . frontend_controls_data_Table() . " WHERE dynamic_control_id = %d AND form_id = %d AND form_submit_id = %d", $form_data[$flag2]->control_id, $form_id, $form_submit_count[$flag1]->submit_id));
if ($form_data[$flag2]->field_id == 5) {
if ($form_control_labels_values != "") {
$chk_options = str_replace("-", ", ", $form_control_labels_values);
?>
<td><?php
echo $chk_options;
?>
</td>
<?php
