function create_table_contact_bank_forms() { $sql = 'CREATE TABLE ' . contact_bank_contact_form() . '( form_id INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT, form_name VARCHAR(200) NOT NULL, PRIMARY KEY (form_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;
<h4><?php _e("Form", contact_bank); ?> </h4> </div> <div class="widget-layout-body" > <div class="fluid-layout"> <div class="layout-control-group"> <label class="layout-control-label"><?php _e("Select Form", contact_bank); ?> :</label> <div class="layout-controls"> <?php global $wpdb; $form_data = $wpdb->get_results("SELECT * FROM " . contact_bank_contact_form()); ?> <select class=" layout-span12" id="select_form" name="select_form" onchange="select_form_id();"> <option value="0"><?php _e("Select Form", contact_bank); ?> </option> <?php for ($flag = 0; $flag < count($form_data); $flag++) { if (isset($_REQUEST["form_id"]) && intval($_REQUEST["form_id"]) == $form_data[$flag]->form_id) { ?> <option value="<?php echo $form_data[$flag]->form_id; ?> " selected="selected"><?php echo $form_data[$flag]->form_name;
<?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; ?> ">
function widget($args, $instance) { global $wpdb; $form_data = $wpdb->get_var($wpdb->prepare("SELECT count(*) FROM " . contact_bank_contact_form() . " WHERE form_id = %d", $instance["form_id"])); extract($args, EXTR_SKIP); echo $before_widget; $title = empty($instance["title"]) ? " " : apply_filters("widget_title", $instance["title"]); if ($form_data > 0) { if ($instance["form_id"] != 0) { echo $before_title . $title . $after_title; $shortcode_for_contact_bank_form = "[contact_bank form_id=" . $instance["form_id"] . " ]"; echo do_shortcode($shortcode_for_contact_bank_form); echo $after_widget; } } }
$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; } if (count($sql1) > 0) { $wpdb->query($wpdb->prepare("Delete FROM " . contact_bank_dynamic_settings_form() . " where dynamicId in (" . implode(',', $sql1) . ")", "")); $wpdb->query($wpdb->prepare("Delete FROM " . create_control_Table() . " where control_id in (" . implode(',', $sql1) . ")", "")); } foreach ($form_settings as $element) { foreach ($element as $val => $keyInner) { if ($val == "form_name") { $wpdb->query($wpdb->prepare("UPDATE " . contact_bank_contact_form() . " SET `form_name` = '" . $keyInner . "' where form_id = %d ", $form_id)); } else { $labels_for_email = $val; if ($val == "redirect_url") { $sql .= ' WHEN `form_message_key` = "' . mysql_real_escape_string($val) . '" THEN "' . mysql_real_escape_string(html_entity_decode($keyInner)) . '"'; } else { $sql .= ' WHEN `form_message_key` = "' . mysql_real_escape_string($val) . '" THEN "' . mysql_real_escape_string($keyInner) . '"'; } } } $wpdb->query($wpdb->prepare("UPDATE " . contact_bank_form_settings_Table() . " SET `form_message_value` = CASE " . $sql . " END where form_id = %d ", $form_id)); } $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++) {
<div id="ux_contact_email_settings" class="contact_bank_layout"> <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
<?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");
$sql1 = array(); $form_id = intval($_REQUEST["form_id"]); $form_settings = json_decode(urldecode(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; } if (count($sql1) > 0) { $wpdb->query($wpdb->prepare("Delete FROM " . contact_bank_dynamic_settings_form() . " where dynamicId in (" . implode(',', $sql1) . ")", "")); $wpdb->query($wpdb->prepare("Delete FROM " . create_control_Table() . " where control_id in (" . implode(',', $sql1) . ")", "")); } foreach ($form_settings as $element) { foreach ($element as $val => $keyInner) { if ($val == "form_name") { $form_name = htmlspecialchars(htmlspecialchars_decode($keyInner)); $wpdb->query($wpdb->prepare("UPDATE " . contact_bank_contact_form() . " SET `form_name` =%s where form_id = %d ", $form_name, $form_id)); } else { $labels_for_email = $val; if ($val == "redirect_url") { $sql .= ' WHEN `form_message_key` = "' . $val . '" THEN "' . html_entity_decode($keyInner) . '"'; } else { $sql .= ' WHEN `form_message_key` = "' . $val . '" THEN "' . htmlspecialchars(htmlspecialchars_decode($keyInner)) . '"'; } } } $wpdb->query($wpdb->prepare("UPDATE " . contact_bank_form_settings_Table() . " SET `form_message_value` = CASE " . strip_tags($sql) . " END where form_id = %d ", $form_id)); } $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++) {
function add_contact_mce_popup() { ?> <?php add_thickbox(); ?> <div id="contact-bank" style="display:none;"> <div class="fluid-layout responsive"> <div style="padding:20px 0 10px 15px;"> <h3 class="label-shortcode"><?php _e("Insert Contact Bank Form", contact_bank); ?> </h3> <span> <i><?php _e("Select a form below to add it to your post or page.", contact_bank); ?> </i> </span> </div> <div class="layout-span12 responsive" style="padding:15px 15px 0 0;"> <div class="layout-control-group"> <label class="custom-layout-label" for="ux_form_name"><?php _e("Form Name", contact_bank); ?> : </label> <select id="add_contact_form_id" class="layout-span9"> <option value="0"><?php _e("Select a Form", contact_bank); ?> </option> <?php global $wpdb; $forms = $wpdb->get_results("SELECT * FROM " . contact_bank_contact_form()); for ($flag = 0; $flag < count($forms); $flag++) { ?> <option value="<?php echo intval($forms[$flag]->form_id); ?> "><?php echo esc_html($forms[$flag]->form_name); ?> </option> <?php } ?> </select> </div> <div class="layout-control-group"> <label class="custom-layout-label"><?php _e("Show Form Title", contact_bank); ?> : </label> <input type="checkbox" checked="checked" name="ux_form_title" id="ux_form_title"/> </div> <div class="layout-control-group"> <label class="custom-layout-label"></label> <input type="button" class="button-primary" value="<?php _e("Insert Form", contact_bank); ?> " onclick="Insert_Contact_Form();"/> <a class="button" style="color:#bbb;" href="#" onclick="tb_remove(); return false;"><?php _e("Cancel", contact_bank); ?> </a> </div> </div> </div> </div> <script type="text/javascript"> function Insert_Contact_Form() { var form_id = jQuery("#add_contact_form_id").val(); var show_title = jQuery("#ux_form_title").prop("checked"); if(form_id == 0) { alert("<?php _e("Please choose a Form to insert into Shortcode", contact_bank); ?> "); return; } window.send_to_editor("[contact_bank form_id=" + form_id + " show_title=" + show_title +" ]"); } </script> <?php }