コード例 #1
0
<?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;
?>
">
コード例 #2
0
    function create_contact_bank_form_settings()
    {
        $sql = 'CREATE TABLE ' . contact_bank_form_settings_Table() . '(
		id INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT,
		form_id INTEGER(10) NOT NULL,
		form_message_key VARCHAR(200) NOT NULL,
		form_message_value TEXT NOT NULL,
		PRIMARY KEY (id)
		) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE utf8_general_ci';
        dbDelta($sql);
    }
コード例 #3
0
ファイル: uninstall-script.php プロジェクト: diegomtzb/cmg
<?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");
コード例 #4
0
ファイル: contact_view-class.php プロジェクト: diegomtzb/cmg
     $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++) {
     $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"));
コード例 #5
0
            $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" >
						<div class="handlediv" data-target="#ux_form_entries_div" title="Click to toggle" data-toggle="collapse"><br></div>
						<h3 class="hndle"><span><?php 
    _e("Add New Form", contact_bank);