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;
}
