function xyz_cfm_ajax_update_element()
{
global $wpdb;
// echo '<pre>';
// print_r($_POST);
// die;
if ($_REQUEST['id']) {
$_POST = stripslashes_deep($_POST);
$id = $_REQUEST['id'];
$elementId = $_REQUEST['elementId'];
$formId = $_REQUEST['formId'];
if ($id == 1) {
$required = $_POST['required'];
$elementName = str_replace(' ', '', $_POST['elementName']);
$elementNameTest = str_replace('_', '', $elementName);
if (ctype_alnum($elementNameTest) && ctype_alpha($elementNameTest[0])) {
$className = $_POST['className'];
$maxlength = intval($_POST['maxlength']);
if ($maxlength == 0) {
$maxlength = '';
}
$defaultValue = $_POST['defaultValue'];
$elementType = 1;
$element_count = $wpdb->query($wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "xyz_cfm_form_elements WHERE element_name= '%s' AND form_id= %d AND id!= %d LIMIT %d,%d", $elementName, $formId, $elementId, 0, 1));
if ($element_count == 0) {
$wpdb->update($wpdb->prefix . 'xyz_cfm_form_elements', array('element_required' => $required, 'element_name' => $elementName, 'css_class' => $className, 'max_length' => $maxlength, 'default_value' => $defaultValue), array('id' => $elementId));
echo "<font color=green>Element successfully updated.</font>";
} else {
echo "<font color=red>Element name already exists.</font>";
}
} else {
echo "<font color=red>Form element name must start with alphabet and must be alphanumeric .</font>";
}
}
if ($id == 2) {
$required = $_POST['required'];
$elementName = str_replace(' ', '', $_POST['elementName']);
$elementNameTest = str_replace('_', '', $elementName);
if (ctype_alnum($elementNameTest) && ctype_alpha($elementNameTest[0])) {
$className = $_POST['className'];
$maxlength = intval($_POST['maxlength']);
if ($maxlength == 0) {
$maxlength = '';
}
$defaultValue = $_POST['defaultValue'];
$elementType = 2;
$element_count = $wpdb->query($wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "xyz_cfm_form_elements WHERE element_name= '%s' AND form_id= %d AND id!= %d LIMIT %d,%d", $elementName, $formId, $elementId, 0, 1));
if ($element_count == 0) {
$wpdb->update($wpdb->prefix . 'xyz_cfm_form_elements', array('element_required' => $required, 'element_name' => $elementName, 'css_class' => $className, 'max_length' => $maxlength, 'default_value' => $defaultValue), array('id' => $elementId));
echo "<font color=green>Element successfully updated.</font>";
} else {
echo "<font color=red>Element name already exists.</font>";
}
} else {
echo "<font color=red>Form element name must start with alphabet and must be alphanumeric .</font>";
}
}
if ($id == 3) {
$required = $_POST['required'];
$elementName = str_replace(' ', '', $_POST['elementName']);
$elementNameTest = str_replace('_', '', $elementName);
if (ctype_alnum($elementNameTest) && ctype_alpha($elementNameTest[0])) {
$className = $_POST['className'];
$collength = intval($_POST['collength']);
if ($collength == 0) {
$collength = '';
}
$rowlength = intval($_POST['rowlength']);
if ($rowlength == 0) {
$rowlength = '';
}
$defaultValue = $_POST['defaultValue'];
$elementType = 3;
$element_count = $wpdb->query($wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "xyz_cfm_form_elements WHERE element_name= '%s' AND form_id= %d AND id!= %d LIMIT %d,%d", $elementName, $formId, $elementId, 0, 1));
if ($element_count == 0) {
$wpdb->update($wpdb->prefix . 'xyz_cfm_form_elements', array('element_required' => $required, 'element_name' => $elementName, 'css_class' => $className, 'cols' => $collength, 'rows' => $rowlength, 'default_value' => $defaultValue), array('id' => $elementId));
echo "<font color=green>Element successfully updated.</font>";
} else {
echo "<font color=red>Element name already exists.</font>";
}
} else {
echo "<font color=red>Form element name must start with alphabet and must be alphanumeric .</font>";
}
}
if ($id == 4) {
$required = $_POST['required'];
$elementName = str_replace(' ', '', $_POST['elementName']);
$elementNameTest = str_replace('_', '', $elementName);
if (ctype_alnum($elementNameTest) && ctype_alpha($elementNameTest[0])) {
$className = $_POST['className'];
$options = xyz_cfm_trimOptions($_POST['options']);
$defaultValue = xyz_cfm_trimOptions($_POST['defaultValue']);
$multipleSelect = $_POST['multipleSelect'];
$elementType = 4;
$element_count = $wpdb->query($wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "xyz_cfm_form_elements WHERE element_name= '%s' AND form_id= %d AND id!= %d LIMIT %d,%d", $elementName, $formId, $elementId, 0, 1));
if ($element_count == 0) {
$wpdb->update($wpdb->prefix . 'xyz_cfm_form_elements', array('element_required' => $required, 'element_name' => $elementName, 'css_class' => $className, 'options' => $options, 'default_value' => $defaultValue, 'client_view_multi_select_drop_down' => $multipleSelect), array('id' => $elementId));
echo "<font color=green>Element successfully updated.</font>";
} else {
echo "<font color=red>Element name already exists.</font>";
}
} else {
echo "<font color=red>Form element name must start with alphabet and must be alphanumeric .</font>";
}
}
if ($id == 5) {
$required = $_POST['required'];
$elementName = str_replace(' ', '', $_POST['elementName']);
$elementNameTest = str_replace('_', '', $elementName);
if (ctype_alnum($elementNameTest) && ctype_alpha($elementNameTest[0])) {
$className = $_POST['className'];
$elementType = 5;
$element_count = $wpdb->query($wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "xyz_cfm_form_elements WHERE element_name= '%s' AND form_id= %d AND id!= %d LIMIT %d,%d", $elementName, $formId, $elementId, 0, 1));
if ($element_count == 0) {
$wpdb->update($wpdb->prefix . 'xyz_cfm_form_elements', array('element_required' => $required, 'element_name' => $elementName, 'css_class' => $className), array('id' => $elementId));
echo "<font color=green>Element successfully updated.</font>";
} else {
echo "<font color=red>Element name already exists.</font>";
}
} else {
echo "<font color=red>Form element name must start with alphabet and must be alphanumeric .</font>";
}
}
if ($id == 6) {
$required = $_POST['required'];
$elementName = str_replace(' ', '', $_POST['elementName']);
$elementNameTest = str_replace('_', '', $elementName);
if (ctype_alnum($elementNameTest) && ctype_alpha($elementNameTest[0])) {
$className = $_POST['className'];
$options = xyz_cfm_trimOptions($_POST['options']);
$defaultValue = xyz_cfm_trimOptions($_POST['defaultValue']);
$singleLineView = $_POST['singleLineView'];
$elementType = 6;
$element_count = $wpdb->query($wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "xyz_cfm_form_elements WHERE element_name= '%s' AND form_id= %d AND id!= %d LIMIT %d,%d", $elementName, $formId, $elementId, 0, 1));
if ($element_count == 0) {
$wpdb->update($wpdb->prefix . 'xyz_cfm_form_elements', array('element_required' => $required, 'element_name' => $elementName, 'css_class' => $className, 'options' => $options, 'client_view_check_radio_line_break_count' => $singleLineView, 'default_value' => $defaultValue), array('id' => $elementId));
echo "<font color=green>Element successfully updated.</font>";
} else {
echo "<font color=red>Element name already exists.</font>";
}
} else {
echo "<font color=red>Form element name must start with alphabet and must be alphanumeric .</font>";
}
}
if ($id == 7) {
$required = $_POST['required'];
$elementName = str_replace(' ', '', $_POST['elementName']);
$elementNameTest = str_replace('_', '', $elementName);
if (ctype_alnum($elementNameTest) && ctype_alpha($elementNameTest[0])) {
$className = $_POST['className'];
$options = xyz_cfm_trimOptions($_POST['options']);
$defaultValue = xyz_cfm_trimOptions($_POST['defaultValue']);
$singleLineView = $_POST['singleLineView'];
$elementType = 7;
$element_count = $wpdb->query($wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "xyz_cfm_form_elements WHERE element_name= '%s' AND form_id= %d AND id!= %d LIMIT %d,%d", $elementName, $formId, $elementId, 0, 1));
if ($element_count == 0) {
$wpdb->update($wpdb->prefix . 'xyz_cfm_form_elements', array('element_required' => $required, 'element_name' => $elementName, 'css_class' => $className, 'options' => $options, 'client_view_check_radio_line_break_count' => $singleLineView, 'default_value' => $defaultValue), array('id' => $elementId));
echo "<font color=green>Element successfully updated.</font>";
} else {
echo "<font color=red>Element name already exists.</font>";
}
} else {
echo "<font color=red>Form element name must start with alphabet and must be alphanumeric .</font>";
}
}
if ($id == 8) {
$required = $_POST['required'];
$elementName = str_replace(' ', '', $_POST['elementName']);
$elementNameTest = str_replace('_', '', $elementName);
if (ctype_alnum($elementNameTest) && ctype_alpha($elementNameTest[0])) {
$className = $_POST['className'];
$fileSize = intval($_POST['fileSize']);
if ($fileSize == 0) {
$fileSize = '';
}
$fileType = $_POST['fileType'];
$elementType = 8;
$element_count = $wpdb->query($wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "xyz_cfm_form_elements WHERE element_name= '%s' AND form_id= %d AND id!= %d LIMIT %d,%d", $elementName, $formId, $elementId, 0, 1));
if ($element_count == 0) {
$wpdb->update($wpdb->prefix . 'xyz_cfm_form_elements', array('element_required' => $required, 'element_name' => $elementName, 'css_class' => $className, 'file_size' => $fileSize, 'file_type' => $fileType), array('id' => $elementId));
echo "<font color=green>Element successfully updated.</font>";
} else {
echo "<font color=red>Element name already exists.</font>";
}
} else {
echo "<font color=red>Form element name must start with alphabet and must be alphanumeric .</font>";
}
}
if ($id == 9) {
$displayName = $_POST['displayName'];
$elementName = str_replace(' ', '', $_POST['elementName']);
$elementNameTest = str_replace('_', '', $elementName);
if (ctype_alnum($elementNameTest) && ctype_alpha($elementNameTest[0])) {
$className = $_POST['className'];
$elementType = 9;
$element_count = $wpdb->query($wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "xyz_cfm_form_elements WHERE element_name= '%s' AND form_id= %d AND id!= %d LIMIT %d,%d", $elementName, $formId, $elementId, 0, 1));
if ($element_count == 0) {
$wpdb->update($wpdb->prefix . 'xyz_cfm_form_elements', array('element_diplay_name' => $displayName, 'element_name' => $elementName, 'css_class' => $className), array('id' => $elementId));
echo "<font color=green>Element successfully updated.</font>";
} else {
echo "<font color=red>Element already exists.</font>";
}
} else {
echo "<font color=red>Form element name must start with alphabet and must be alphanumeric .</font>";
}
}
if ($id == 10) {
$required = 1;
$elementName = str_replace(' ', '', $_REQUEST['elementName']);
$elementNameTest = str_replace('_', '', $elementName);
if (ctype_alnum($elementNameTest) && ctype_alpha($elementNameTest[0])) {
$className = $_REQUEST['className'];
$elementType = 10;
$reCaptcha = $_REQUEST['reCaptcha'];
$element_count = $wpdb->query($wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "xyz_cfm_form_elements WHERE element_name= '%s' AND form_id= %d AND id!= %d LIMIT %d,%d", $elementName, $formId, $elementId, 0, 1));
if ($element_count == 0) {
$wpdb->update($wpdb->prefix . 'xyz_cfm_form_elements', array('element_required' => $required, 'element_name' => $elementName, 'element_type' => $elementType, 'css_class' => $className, 're_captcha' => $reCaptcha), array('id' => $elementId));
echo "<font color=green>Element successfully updated.</font>";
} else {
echo "<font color=red>Element name already exists.</font>";
}
} else {
echo "<font color=red>Form element name must start with alphabet and must be alphanumeric .</font>";
}
}
}
die;
}
function xyz_cfm_ajax_insert_element()
{
global $wpdb;
// echo '<pre>';
// print_r($_POST);die;
if ($_POST) {
$_POST = stripslashes_deep($_POST);
$_POST = xyz_trim_deep($_POST);
$id = $_REQUEST['id'];
if ($id == 1) {
$required = $_POST['required'];
$elementName = str_replace(' ', '', $_POST['elementName']);
$elementNameTest = str_replace('_', '', $elementName);
if (ctype_alnum($elementNameTest) && ctype_alpha($elementNameTest[0])) {
$className = $_POST['className'];
$maxlength = abs(intval($_POST['maxlength']));
if ($maxlength == 0) {
$maxlength = '';
}
$defaultValue = $_POST['defaultValue'];
$formId = $_POST['formId'];
$elementType = 1;
$element_count = $wpdb->get_results($wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "xyz_cfm_form_elements WHERE element_name= '%s' AND form_id= %d LIMIT %d,%d", $elementName, $formId, 0, 1));
if (count($element_count) == 0) {
$wpdb->insert($wpdb->prefix . 'xyz_cfm_form_elements', array('form_id' => $formId, 'element_diplay_name' => '', 'element_name' => $elementName, 'element_type' => $elementType, 'element_required' => $required, 'css_class' => $className, 'max_length' => $maxlength, 'default_value' => $defaultValue, 'cols' => '', 'rows' => '', 'options' => '', 'file_size' => '', 'file_type' => '', 're_captcha' => 0, 'client_view_check_radio_line_break_count' => 0, 'client_view_multi_select_drop_down' => 0), array('%d', '%s', '%s', '%d', '%d', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%d', '%d', '%d'));
$lastElementId = $wpdb->insert_id;
echo "Copy this code and paste it into the form left.<br/>Code is [text-" . $lastElementId . "]";
} else {
echo "<font color=red>Element name already exists.</font>";
}
} else {
echo "<font color=red>Form element name must start with alphabet and must be alphanumeric .</font>";
}
}
if ($id == 2) {
$required = $_POST['required'];
$elementName = str_replace(' ', '', $_POST['elementName']);
$elementNameTest = str_replace('_', '', $elementName);
if (ctype_alnum($elementNameTest) && ctype_alpha($elementNameTest[0])) {
$className = $_POST['className'];
$maxlength = abs(intval($_POST['maxlength']));
if ($maxlength == 0) {
$maxlength = '';
}
$defaultValue = $_POST['defaultValue'];
$formId = $_POST['formId'];
$elementType = 2;
$element_count = $wpdb->get_results($wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "xyz_cfm_form_elements WHERE element_name= '%s' AND form_id= %d LIMIT %d,%d", $elementName, $formId, 0, 1));
if (count($element_count) == 0) {
$wpdb->insert($wpdb->prefix . 'xyz_cfm_form_elements', array('form_id' => $formId, 'element_diplay_name' => '', 'element_name' => $elementName, 'element_type' => $elementType, 'element_required' => $required, 'css_class' => $className, 'max_length' => $maxlength, 'default_value' => $defaultValue, 'cols' => '', 'rows' => '', 'options' => '', 'file_size' => '', 'file_type' => '', 're_captcha' => 0, 'client_view_check_radio_line_break_count' => 0, 'client_view_multi_select_drop_down' => 0), array('%d', '%s', '%s', '%d', '%d', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%d', '%d', '%d'));
$lastElementId = $wpdb->insert_id;
echo "Copy this code and paste it into the form left.<br/>Code is [email-" . $lastElementId . "]";
} else {
echo "<font color=red>Element name already exists.</font>";
}
} else {
echo "<font color=red>Form element name must start with alphabet and must be alphanumeric .</font>";
}
}
if ($id == 3) {
$required = $_POST['required'];
$elementName = str_replace(' ', '', $_POST['elementName']);
$elementNameTest = str_replace('_', '', $elementName);
if (ctype_alnum($elementNameTest) && ctype_alpha($elementNameTest[0])) {
$className = $_POST['className'];
$collength = abs(intval($_POST['collength']));
if ($collength == 0) {
$collength = '';
}
$rowlength = abs(intval($_POST['rowlength']));
if ($rowlength == 0) {
$rowlength = '';
}
$defaultValue = $_POST['defaultValue'];
$formId = $_POST['formId'];
$elementType = 3;
$element_count = $wpdb->get_results($wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "xyz_cfm_form_elements WHERE element_name= '%s' AND form_id= %d LIMIT %d,%d", $elementName, $formId, 0, 1));
if (count($element_count) == 0) {
$wpdb->insert($wpdb->prefix . 'xyz_cfm_form_elements', array('form_id' => $formId, 'element_diplay_name' => '', 'element_name' => $elementName, 'element_type' => $elementType, 'element_required' => $required, 'css_class' => $className, 'cols' => $collength, 'rows' => $rowlength, 'default_value' => $defaultValue, 'max_length' => '', 'options' => '', 'file_size' => '', 'file_type' => '', 're_captcha' => 0, 'client_view_check_radio_line_break_count' => 0, 'client_view_multi_select_drop_down' => 0), array('%d', '%s', '%s', '%d', '%d', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%d', '%d', '%d'));
$lastElementId = $wpdb->insert_id;
echo "Copy this code and paste it into the form left.<br/>Code is [textarea-" . $lastElementId . "]";
} else {
echo "<font color=red>Element name already exists.</font>";
}
} else {
echo "<font color=red>Form element name must start with alphabet and must be alphanumeric .</font>";
}
}
if ($id == 4) {
$required = $_POST['required'];
$elementName = str_replace(' ', '', $_POST['elementName']);
$elementNameTest = str_replace('_', '', $elementName);
if (ctype_alnum($elementNameTest) && ctype_alpha($elementNameTest[0])) {
$className = $_POST['className'];
$options = xyz_cfm_trimOptions($_POST['options']);
$defaultValue = xyz_cfm_trimOptions($_POST['defaultValue']);
$multipleSelect = $_POST['multipleSelect'];
$formId = $_POST['formId'];
$elementType = 4;
$element_count = $wpdb->get_results($wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "xyz_cfm_form_elements WHERE element_name= '%s' AND form_id= %d LIMIT %d,%d", $elementName, $formId, 0, 1));
if (count($element_count) == 0) {
$wpdb->insert($wpdb->prefix . 'xyz_cfm_form_elements', array('form_id' => $formId, 'element_diplay_name' => '', 'element_name' => $elementName, 'element_type' => $elementType, 'element_required' => $required, 'css_class' => $className, 'options' => $options, 'default_value' => $defaultValue, 'client_view_multi_select_drop_down' => $multipleSelect, 'max_length' => '', 'cols' => '', 'rows' => '', 'file_size' => '', 'file_type' => '', 're_captcha' => 0, 'client_view_check_radio_line_break_count' => 0), array('%d', '%s', '%s', '%d', '%d', '%s', '%s', '%s', '%d', '%s', '%s', '%s', '%s', '%s', '%d', '%d'));
$lastElementId = $wpdb->insert_id;
echo "Copy this code and paste it into the form left.<br/>Code is [dropdown-" . $lastElementId . "]";
} else {
echo "<font color=red>Element name already exists.</font> ";
}
} else {
echo "<font color=red>Form element name must start with alphabet and must be alphanumeric .</font>";
}
}
if ($id == 5) {
$required = $_POST['required'];
$elementName = str_replace(' ', '', $_POST['elementName']);
$elementNameTest = str_replace('_', '', $elementName);
if (ctype_alnum($elementNameTest) && ctype_alpha($elementNameTest[0])) {
$className = $_POST['className'];
$formId = $_POST['formId'];
$elementType = 5;
$element_count = $wpdb->get_results($wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "xyz_cfm_form_elements WHERE element_name= '%s' AND form_id= %d LIMIT %d,%d", $elementName, $formId, 0, 1));
if (count($element_count) == 0) {
$wpdb->insert($wpdb->prefix . 'xyz_cfm_form_elements', array('form_id' => $formId, 'element_diplay_name' => '', 'element_name' => $elementName, 'element_type' => $elementType, 'element_required' => $required, 'css_class' => $className, 'max_length' => '', 'default_value' => '', 'cols' => '', 'rows' => '', 'options' => '', 'file_size' => '', 'file_type' => '', 're_captcha' => 0, 'client_view_check_radio_line_break_count' => 0, 'client_view_multi_select_drop_down' => 0), array('%d', '%s', '%s', '%d', '%d', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%d', '%d', '%d'));
$lastElementId = $wpdb->insert_id;
echo "Copy this code and paste it into the form left.<br/>Code is [date-" . $lastElementId . "]";
} else {
echo "<font color=red>Element name already exists.</font>";
}
} else {
echo "<font color=red>Form element name must start with alphabet and must be alphanumeric .</font>";
}
}
if ($id == 6) {
$required = $_POST['required'];
$elementName = str_replace(' ', '', $_POST['elementName']);
$elementNameTest = str_replace('_', '', $elementName);
if (ctype_alnum($elementNameTest) && ctype_alpha($elementNameTest[0])) {
$className = $_POST['className'];
$options = xyz_cfm_trimOptions($_POST['options']);
$defaultValue = xyz_cfm_trimOptions($_POST['defaultValue']);
$formId = $_POST['formId'];
$singleLineView = $_POST['singleLineView'];
$elementType = 6;
$element_count = $wpdb->get_results($wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "xyz_cfm_form_elements WHERE element_name= '%s' AND form_id= %d LIMIT %d,%d", $elementName, $formId, 0, 1));
if (count($element_count) == 0) {
$wpdb->insert($wpdb->prefix . 'xyz_cfm_form_elements', array('form_id' => $formId, 'element_diplay_name' => '', 'element_name' => $elementName, 'element_type' => $elementType, 'element_required' => $required, 'css_class' => $className, 'options' => $options, 'client_view_check_radio_line_break_count' => $singleLineView, 'default_value' => $defaultValue, 'max_length' => '', 'cols' => '', 'rows' => '', 'file_size' => '', 'file_type' => '', 're_captcha' => 0, 'client_view_multi_select_drop_down' => 0), array('%d', '%s', '%s', '%d', '%d', '%s', '%s', '%d', '%s', '%s', '%s', '%s', '%s', '%s', '%d', '%d'));
$lastElementId = $wpdb->insert_id;
echo "Copy this code and paste it into the form left.<br/>Code is [checkbox-" . $lastElementId . "]";
} else {
echo "<font color=red>Element name already exists.</font>";
}
} else {
echo "<font color=red>Form element name must start with alphabet and must be alphanumeric .</font>";
}
}
if ($id == 7) {
$required = $_POST['required'];
$elementName = str_replace(' ', '', $_POST['elementName']);
$elementNameTest = str_replace('_', '', $elementName);
if (ctype_alnum($elementNameTest) && ctype_alpha($elementNameTest[0])) {
$className = $_POST['className'];
$options = xyz_cfm_trimOptions($_POST['options']);
$defaultValue = xyz_cfm_trimOptions($_POST['defaultValue']);
$formId = $_POST['formId'];
$singleLineView = $_POST['singleLineView'];
$elementType = 7;
$element_count = $wpdb->get_results($wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "xyz_cfm_form_elements WHERE element_name= '%s' AND form_id= %d LIMIT %d,%d", $elementName, $formId, 0, 1));
if (count($element_count) == 0) {
$wpdb->insert($wpdb->prefix . 'xyz_cfm_form_elements', array('form_id' => $formId, 'element_diplay_name' => '', 'element_name' => $elementName, 'element_type' => $elementType, 'element_required' => $required, 'css_class' => $className, 'options' => $options, 'client_view_check_radio_line_break_count' => $singleLineView, 'default_value' => $defaultValue, 'max_length' => '', 'cols' => '', 'rows' => '', 'file_size' => '', 'file_type' => '', 're_captcha' => 0, 'client_view_multi_select_drop_down' => 0), array('%d', '%s', '%s', '%d', '%d', '%s', '%s', '%d', '%s', '%s', '%s', '%s', '%s', '%s', '%d', '%d'));
$lastElementId = $wpdb->insert_id;
echo "Copy this code and paste it into the form left.<br/>Code is [radiobutton-" . $lastElementId . "]";
} else {
echo "<font color=red>Element name already exists.</font>";
}
} else {
echo "<font color=red>Form element name must start with alphabet and must be alphanumeric .</font>";
}
}
if ($id == 8) {
$required = $_POST['required'];
$elementName = str_replace(' ', '', $_POST['elementName']);
$elementNameTest = str_replace('_', '', $elementName);
if (ctype_alnum($elementNameTest) && ctype_alpha($elementNameTest[0])) {
$className = $_POST['className'];
$fileSize = abs(intval($_POST['fileSize']));
if ($fileSize == 0) {
$fileSize = '';
}
$fileType = $_POST['fileType'];
$formId = $_POST['formId'];
$elementType = 8;
$element_count = $wpdb->get_results($wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "xyz_cfm_form_elements WHERE element_name= '%s' AND form_id= %d LIMIT %d,%d", $elementName, $formId, 0, 1));
if (count($element_count) == 0) {
$wpdb->insert($wpdb->prefix . 'xyz_cfm_form_elements', array('form_id' => $formId, 'element_diplay_name' => '', 'element_name' => $elementName, 'element_type' => $elementType, 'element_required' => $required, 'css_class' => $className, 'file_size' => $fileSize, 'file_type' => $fileType, 'max_length' => '', 'default_value' => '', 'cols' => '', 'rows' => '', 'options' => '', 're_captcha' => 0, 'client_view_check_radio_line_break_count' => 0, 'client_view_multi_select_drop_down' => 0), array('%d', '%s', '%s', '%d', '%d', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%d', '%d', '%d'));
$lastElementId = $wpdb->insert_id;
echo "Copy this code and paste it into the form left.<br/>Code is [file-" . $lastElementId . "]";
} else {
echo "<font color=red>Element name already exists.</font>";
}
} else {
echo "<font color=red>Form element name must start with alphabet and must be alphanumeric .</font>";
}
}
if ($id == 9) {
$displayName = $_POST['displayName'];
$elementName = str_replace(' ', '', $_POST['elementName']);
$elementNameTest = str_replace('_', '', $elementName);
if (ctype_alnum($elementNameTest) && ctype_alpha($elementNameTest[0])) {
$className = $_POST['className'];
$formId = $_POST['formId'];
$elementType = 9;
$element_count = $wpdb->get_results($wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "xyz_cfm_form_elements WHERE element_type= %d AND form_id= %d LIMIT %d,%d", 9, $formId, 0, 1));
if (count($element_count) == 0) {
$wpdb->insert($wpdb->prefix . 'xyz_cfm_form_elements', array('form_id' => $formId, 'element_diplay_name' => $displayName, 'element_name' => $elementName, 'element_type' => $elementType, 'css_class' => $className, 'element_required' => '1', 'max_length' => '', 'default_value' => '', 'cols' => '', 'rows' => '', 'options' => '', 'file_size' => '', 'file_type' => '', 're_captcha' => 0, 'client_view_check_radio_line_break_count' => 0, 'client_view_multi_select_drop_down' => 0), array('%d', '%s', '%s', '%s', '%d', '%s', '%d', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%d', '%d', '%d'));
$lastElementId = $wpdb->insert_id;
echo "Copy this code and paste it into the form left.<br/>Code is [submit-" . $lastElementId . "]";
} else {
echo "<font color=red>Element already exists.</font>";
}
} else {
echo "<font color=red>Form element name must start with alphabet and must be alphanumeric .</font>";
}
}
if ($id == 10) {
$required = 1;
$reCaptcha = $_REQUEST['reCaptcha'];
$elementName = str_replace(' ', '', $_REQUEST['elementName']);
$elementNameTest = str_replace('_', '', $elementName);
if (ctype_alnum($elementNameTest) && ctype_alpha($elementNameTest[0])) {
$className = $_REQUEST['className'];
$formId = $_REQUEST['formId'];
$elementType = 10;
$element_count = $wpdb->get_results($wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "xyz_cfm_form_elements WHERE element_type= %d AND form_id= %d LIMIT %d,%d", 10, $formId, 0, 1));
if (count($element_count) == 0) {
$wpdb->insert($wpdb->prefix . 'xyz_cfm_form_elements', array('form_id' => $formId, 'element_required' => $required, 'element_name' => $elementName, 'element_type' => $elementType, 'css_class' => $className, 're_captcha' => $reCaptcha, 'element_diplay_name' => '', 'max_length' => '', 'default_value' => '', 'cols' => '', 'rows' => '', 'options' => '', 'file_size' => '', 'file_type' => '', 'client_view_check_radio_line_break_count' => 0, 'client_view_multi_select_drop_down' => 0), array('%d', '%d', '%s', '%d', '%s', '%d', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%d', '%d'));
$lastElementId = $wpdb->insert_id;
echo "Copy this code and paste it into the form left.<br/>Code is [captcha-" . $lastElementId . "]";
} else {
echo "<font color=red>Element already exists.</font>";
}
} else {
echo "<font color=red>Form element name must start with alphabet and must be alphanumeric .</font>";
}
}
}
die;
}
