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
}
