function list_code_groups($form_id) { $sql = "select * FROM `form_fields` WHERE form_id='{$form_id}' AND (field_type='CHECK' OR field_type='RADIO' OR field_type='SELECT' OR field_type='MSELECT' ) "; $result = mysql_query($sql) or die(mysql_error()); //echo $sql; if (mysql_num_rows($result) == 0) { echo " (0 codes)"; } echo "<ul>"; while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { format_codes_translation_table($row[field_id]); ?> <li><a href="" onclick="window.open('maintain_codes.php?field_id=<?php echo $row[field_id]; ?> ', '', 'toolbar=no,scrollbars=yes,location=no,statusbar=no,menubar=no,resizable=1,width=400,height=500,left = 150,top = 150');return false;" ><?php echo $row[field_label]; ?> </a> <?php } echo "</ul>"; }
function insert_code($field_id, $code, $description) { $sql = "SELECT `code` FROM `codes` WHERE field_id='{$field_id}' AND `code` = '{$code}'"; $result = mysql_query($sql) or die($sql . mysql_error()); if (mysql_num_rows($result) > 0) { echo '<font color="#FF0000">'; echo "CANNOT INSERT a new Code: {$code} already exists in the database!<p>"; echo '</font>'; return; } $sql = "INSERT INTO `codes` ( `field_id` , `code` , `description` ) VALUES ('{$field_id}', '{$code}', '{$description}')"; mysql_query($sql) or die($sql . mysql_error()); if ($_SESSION['MDS_LANG'] != '') { $sql = "INSERT INTO `codes_translations` ( `field_id` , `code` , `description`, `lang` ) VALUES ('{$field_id}', '{$code}', '{$description}', '" . $SESSION['lang'] . "')"; mysql_query($sql) or die($sql . mysql_error()); } format_codes_translation_table($field_id); }
global $LANG_FILES; $sql = "SELECT * FROM lang "; $result = mysql_query($sql) or die(mysql_error()); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { $AVAILABLE_LANGS[$row['lang_code']] = $row['name']; $LANG_FILES[$row['lang_code']] = $row['lang_filename']; } // update category translations // (copy English to new lang) //format_cat_translation_table (0); // update code translations // (copy English to new lang) $sql = "SELECT * FROM form_fields WHERE `field_type`='RADIO' or `field_type`='CHECK' or `field_type`='MSELECT' or `field_type`='SELECT' "; $result = mysql_query($sql) or die(mysql_error() . $sql); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { format_codes_translation_table($row[field_id]); } // update forms // (copy English to new lang) format_field_translation_table(1); } else { } } ?> <table border="0" cellSpacing="1" cellPadding="3" bgColor="#d9d9d9" > <tr bgColor="#eaeaea"> <td><b><font size="2">Language</b></font></td> <td><b><font size="2">Code</b></font></td>
function save_field($error, $NEW_FIELD) { //print_r($_REQUEST); if ($NEW_FIELD == "YES") { $sql = "INSERT INTO `form_fields` ( `form_id` , `field_id` , `reg_expr` , `field_label` , `field_type` , `field_sort` , `is_required` , `display_in_list` , `error_message` , `field_init`, `field_width`, `field_height`, `is_in_search`, `list_sort_order`, `search_sort_order`, `template_tag`, `section`, `is_hidden`, `is_anon`, `field_comment`, `category_init_id`, `is_cat_multiple`, `cat_multiple_rows`, `is_blocked`, `multiple_sel_all`) VALUES ('{$_REQUEST['form_id']}', '', '{$_REQUEST['reg_expr']}', '{$_REQUEST['field_label']}', '{$_REQUEST['field_type']}', '{$_REQUEST['field_sort']}', '{$_REQUEST['is_required']}', '{$_REQUEST['display_in_list']}', '{$_REQUEST['error_message']}', '{$_REQUEST['field_init']}', '{$_REQUEST['field_width']}', '{$_REQUEST['field_height']}', '{$_REQUEST['is_in_search']}', '{$_REQUEST['list_sort_order']}', '{$_REQUEST['search_sort_order']}', '{$_REQUEST['template_tag']}', '{$_REQUEST['section']}', '{$_REQUEST['is_hidden']}', '{$_REQUEST['is_blcoked']}', '{$_REQUEST['field_comment']}', '{$_REQUEST['category_init_id']}', '{$_REQUEST['is_cat_multiple']}', '{$_REQUEST['cat_multiple_rows']}', '{$_REQUEST['is_blocked']}', '{$_REQUEST['multiple_sel_all']}' )"; } else { //if ($_SESSION['MDS_LANG'] == "EN") { $sql = "SELECT * FROM form_fields WHERE field_id='" . $_REQUEST['field_id'] . "' "; $result = mysql_query($sql) or die(mysql_error() . $sql); $row = mysql_fetch_array($result); if ($row['field_type'] != $_REQUEST['field_type']) { //echo "Cannot change this field type..."; } if (is_reserved_template_tag($_REQUEST['template_tag']) && true) { $tt = ""; // do not update template tag } elseif ($_REQUEST['template_tag'] != '') { $tt = "`template_tag` = '" . $_REQUEST['template_tag'] . "',"; } $sql = "UPDATE `form_fields` SET " . "`reg_expr` = '{$_REQUEST['reg_expr']}'," . "`field_label` = '{$_REQUEST['field_label']}'," . "`field_type` = '{$_REQUEST['field_type']}'," . "`field_init` = '{$_REQUEST['field_init']}'," . "`is_required` = '{$_REQUEST['is_required']}'," . "`field_width` = '{$_REQUEST['field_width']}'," . "`field_height` = '{$_REQUEST['field_height']}'," . "`is_in_search` = '{$_REQUEST['is_in_search']}'," . "`search_sort_order` = '{$_REQUEST['search_sort_order']}'," . "`section` = '{$_REQUEST['section']}'," . $tt . "`error_message` = '{$_REQUEST['error_message']}'," . "`is_hidden` = '{$_REQUEST['is_hidden']}', " . "`is_anon` = '{$_REQUEST['is_anon']}', " . "`is_cat_multiple` = '{$_REQUEST['is_cat_multiple']}', " . "`cat_multiple_rows` = '{$_REQUEST['cat_multiple_rows']}', " . "`field_comment` = '{$_REQUEST['field_comment']}', " . "`multiple_sel_all` = '{$_REQUEST['multiple_sel_all']}', " . "`is_blocked` = '{$_REQUEST['is_blocked']}', " . "`is_prefill` = '{$_REQUEST['is_prefill']}', " . "category_init_id = '{$_REQUEST['category_init_id']}' " . "WHERE `field_id` = '{$_REQUEST['field_id']}' ;"; //} //echo $sql."<br>"; //echo "<hr>"; //print_r($_REQUEST); if ($sql != '') { mysql_query($sql) or die($sql . mysql_error()); } mysql_query($sql) or die($sql . mysql_error()); // update translations $label = $_REQUEST['field_label']; $sql = "REPLACE INTO `form_field_translations` (`field_id`, `lang`, `field_label`, `error_message`, `field_comment`) VALUES ('" . $_REQUEST['field_id'] . "', '" . $_SESSION['MDS_LANG'] . "', '" . $label . "', '" . $_REQUEST['error_message'] . "', '" . $_REQUEST['field_comment'] . "' )"; mysql_query($sql) or die($sql . mysql_error()); // update template tag on the form_lists if ($_REQUEST['template_tag'] != '') { // sometimes template tag can be blank (reserved tags) $sql = "UPDATE form_lists SET `template_tag`='" . $_REQUEST['template_tag'] . "' WHERE `field_id`='" . $_REQUEST['field_id'] . "'"; mysql_query($sql) or die($sql . mysql_error()); } } $result = mysql_query($sql) or die(mysql_error() . $sql); //print_r($_REQUEST); if ($_REQUEST['field_type'] == 'RADIO' || $_REQUEST['field_type'] == 'CHECK' || $_REQUEST['field_type'] == 'MSELECT' || $_REQUEST['field_type'] == 'SELECT') { //echo 'formatting field..<br>'; if ($NEW_FIELD == 'YES') { $_REQUEST['field_id'] = mysql_insert_id(); } format_codes_translation_table($_REQUEST['field_id']); } if ($NEW_FIELD == 'YES') { $field_id = mysql_insert_id(); } else { $field_id = $_REQUEST['field_id']; } if (CACHE_ENABLED == 'YES') { global $CACHE_ENABLED; $CACHE_ENABLED = 'NO'; include '../include/codegen_functions.php'; generate_form_cache($_REQUEST['form_id']); $CACHE_ENABLED = 'YES'; } $_REQUEST['mode'] = 'EDIT'; global $NEW_FIELD; $NEW_FIELD = 'NO'; return $field_id; }