if (preg_match('#\\$label\\[.([a-z0-9_]+).\\].*#i', $buffer, $m)) {
$source_code[$m[1]] = $buffer;
}
}
JBPLUG_append_english_default_source($source_code);
// append the english_default.php of all plugins
jb_theme_append_english_default_source($source_code);
// // append the english_default.php of all themes
if ($_REQUEST['save'] != '') {
require_once '../include/dynamic_forms.php';
require_once '../include/code_functions.php';
require_once '../include/category.inc.php';
$sql = "SELECT * FROM form_fields WHERE `field_type`='RADIO' or `field_type`='CHECK' or `field_type`='MSELECT' ";
$result = JB_mysql_query($sql) or die(mysql_error() . $sql);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
JB_format_codes_translation_table($row['field_id']);
}
// update forms
// (copy English to new lang)
JB_format_field_translation_table(1);
JB_format_field_translation_table(2);
JB_format_field_translation_table(3);
// update email templates
JB_format_email_translation_table();
$out = "<?php\n";
$out .= "///////////////////////////////////////////////////////////////////////////\n";
$out .= "// IMPORTANT NOTICE\n";
$out .= "///////////////////////////////////////////////////////////////////////////\n";
$out .= "// This file was generated by a script!\n";
$out .= "// (Admin->Translation tools)\n";
$out .= "// Please do not edit the language files by hand\n";
<?php
}
?>
<form method="POST" action="<?php
echo htmlentities($_SERVER['PHP_SELF']);
?>
">
<p>
<table border="1">
<tr>
<td><b>Code</b></td>
<td><b>Description</b></td>
<td></td>
</tr>
<?php
JB_format_codes_translation_table($field_id);
if ($_SESSION['LANG'] == '') {
$sql = "SELECT `code`, `description` FROM `codes` WHERE field_id='" . jb_escape_sql($field_id) . "'";
} else {
$sql = "SELECT `code`, `description` FROM `codes_translations` WHERE field_id='" . jb_escape_sql($field_id) . "' AND `lang`='" . jb_escape_sql($_SESSION['LANG']) . "' ";
}
$result = JB_mysql_query($sql) or die($sql . mysql_error());
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
if ($code == $row['code']) {
echo '<tr bgcolor="FFFFCC">' . "\n";
} else {
echo "<tr>\n";
}
echo "<td>\n";
echo '<A Href="' . htmlentities($_SERVER['PHP_SELF']) . '?field_id=' . jb_escape_html($field_id) . '&code=' . jb_escape_html($row['code']) . '">' . "\n";
echo $row['code'];
function JB_insert_code($field_id, $code, $description)
{
$sql = "SELECT `code` FROM `codes` WHERE field_id='" . jb_escape_sql($field_id) . "' AND `code` = '" . jb_escape_sql($code) . "'";
$result = JB_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 ('" . jb_escape_sql($field_id) . "', '" . jb_escape_sql($code) . "', '" . jb_escape_sql($description) . "')";
JB_mysql_query($sql) or die($sql . mysql_error());
if ($_SESSION["LANG"] != '') {
$sql = "INSERT INTO `codes_translations` ( `field_id` , `code` , `description`, `lang` ) VALUES ('" . jb_escape_sql($field_id) . "', '" . jb_escape_sql($code) . "', '" . jb_escape_sql($description) . "', '" . jb_escape_sql($_SESSION['LANG']) . "')";
JB_mysql_query($sql) or die($sql . mysql_error());
}
JB_format_codes_translation_table($field_id);
JB_cache_del_keys_for_codes($field_id);
}
function JB_save_field($error, $NEW_FIELD)
{
$_REQUEST['field_sort'] = (int) $_REQUEST['field_sort'];
$_REQUEST['field_width'] = (int) $_REQUEST['field_width'];
$_REQUEST['field_height'] = (int) $_REQUEST['field_height'];
$_REQUEST['list_sort_order'] = (int) $_REQUEST['list_sort_order'];
$_REQUEST['category_init_id'] = (int) $_REQUEST['category_init_id'];
$_REQUEST['search_sort_order'] = (int) $_REQUEST['search_sort_order'];
$_REQUEST['cat_multiple_rows'] = (int) $_REQUEST['cat_multiple_rows'];
if ($_REQUEST['field_type'] == 'GMAP') {
if (!$_REQUEST['field_width']) {
$_REQUEST['field_width'] = 300;
}
if (!$_REQUEST['field_height']) {
$_REQUEST['field_height'] = 400;
}
}
if ($_REQUEST['field_type'] == 'EDITOR') {
}
if ($NEW_FIELD == "YES") {
$sql = "INSERT INTO `form_fields` ( `form_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`, `is_member`) VALUES ('" . JB_escape_sql($_REQUEST['form_id']) . "', '" . JB_escape_sql($_REQUEST['reg_expr']) . "', '" . JB_escape_sql($_REQUEST['field_label']) . "', '" . JB_escape_sql($_REQUEST['field_type']) . "', '" . JB_escape_sql($_REQUEST['field_sort']) . "', '" . JB_escape_sql($_REQUEST['is_required']) . "', '" . JB_escape_sql($_REQUEST['display_in_list']) . "', '" . JB_escape_sql($_REQUEST['error_message']) . "', '" . JB_escape_sql($_REQUEST['field_init']) . "', '" . JB_escape_sql($_REQUEST['field_width']) . "', '" . JB_escape_sql($_REQUEST['field_height']) . "', '" . JB_escape_sql($_REQUEST['is_in_search']) . "', '" . JB_escape_sql($_REQUEST['list_sort_order']) . "', '" . JB_escape_sql($_REQUEST['search_sort_order']) . "', '" . JB_escape_sql($_REQUEST['template_tag']) . "', '" . JB_escape_sql($_REQUEST['section']) . "', '" . JB_escape_sql($_REQUEST['is_hidden']) . "', '" . JB_escape_sql($_REQUEST['is_blcoked']) . "', '" . JB_escape_sql($_REQUEST['field_comment']) . "', '" . JB_escape_sql($_REQUEST['category_init_id']) . "', '" . JB_escape_sql($_REQUEST['is_cat_multiple']) . "', '" . JB_escape_sql($_REQUEST['cat_multiple_rows']) . "', '" . JB_escape_sql($_REQUEST['is_blocked']) . "', '" . JB_escape_sql($_REQUEST['multiple_sel_all']) . "', '" . JB_escape_sql($_REQUEST['is_member']) . "' )";
} else {
//if ($_SESSION["LANG"] == "EN") {
$sql = "SELECT * FROM form_fields WHERE field_id='" . JB_escape_sql($_REQUEST['field_id']) . "' ";
$result = JB_mysql_query($sql) or die(mysql_error() . $sql);
$row = mysql_fetch_array($result, MYSQL_ASSOC);
if (JB_is_reserved_template_tag($_REQUEST['template_tag']) && true) {
$tt = "";
// do not update template tag
} elseif ($_REQUEST['template_tag'] != '') {
$tt = "`template_tag` = '" . JB_escape_sql($_REQUEST['template_tag']) . "',";
}
$sql = "UPDATE `form_fields` SET " . "`reg_expr` = '" . JB_escape_sql($_REQUEST['reg_expr']) . "'," . "`field_label` = '" . JB_escape_sql($_REQUEST['field_label']) . "'," . "`field_type` = '" . JB_escape_sql($_REQUEST['field_type']) . "'," . "`field_init` = '" . JB_escape_sql($_REQUEST['field_init']) . "'," . "`is_required` = '" . JB_escape_sql($_REQUEST['is_required']) . "'," . "`field_width` = '" . JB_escape_sql($_REQUEST['field_width']) . "'," . "`field_height` = '" . JB_escape_sql($_REQUEST['field_height']) . "'," . "`is_in_search` = '" . JB_escape_sql($_REQUEST['is_in_search']) . "'," . "`search_sort_order` = '" . JB_escape_sql($_REQUEST['search_sort_order']) . "'," . "`section` = '" . JB_escape_sql($_REQUEST['section']) . "'," . $tt . "`error_message` = '" . JB_escape_sql($_REQUEST['error_message']) . "'," . "`is_hidden` = '" . JB_escape_sql($_REQUEST['is_hidden']) . "', " . "`is_anon` = '" . JB_escape_sql($_REQUEST['is_anon']) . "', " . "`is_cat_multiple` = '" . JB_escape_sql($_REQUEST['is_cat_multiple']) . "', " . "`cat_multiple_rows` = '" . JB_escape_sql($_REQUEST['cat_multiple_rows']) . "', " . "`field_comment` = '" . JB_escape_sql($_REQUEST['field_comment']) . "', " . "`multiple_sel_all` = '" . JB_escape_sql($_REQUEST['multiple_sel_all']) . "', " . "`is_blocked` = '" . JB_escape_sql($_REQUEST['is_blocked']) . "', " . "`is_prefill` = '" . JB_escape_sql($_REQUEST['is_prefill']) . "', " . "`is_member` = '" . JB_escape_sql($_REQUEST['is_member']) . "', " . "category_init_id = '" . JB_escape_sql($_REQUEST['category_init_id']) . "' " . "WHERE `field_id` = '" . JB_escape_sql($_REQUEST['field_id']) . "' ;";
// update template tag on the form_lists
if ($_REQUEST['template_tag'] != '') {
// sometimes template tag can be blank (reserved tags)
$sql_tt = "UPDATE form_lists SET `template_tag`='" . JB_escape_sql($_REQUEST['template_tag']) . "' WHERE `field_id`='" . JB_escape_sql($_REQUEST['field_id']) . "'";
JB_mysql_query($sql_tt) or die($sql . mysql_error());
}
}
// Do the SQL query, UPDATE or INSERT
JB_mysql_query($sql) or die($sql . mysql_error());
if ($_REQUEST['field_id'] == false) {
$_REQUEST['field_id'] = jb_mysql_insert_id();
}
// update translations
$label = $_REQUEST['field_label'];
$sql_fft = "RePLACE INTO `form_field_translations` (`field_id`, `lang`, `field_label`, `error_message`, `field_comment`) VALUES ('" . JB_escape_sql($_REQUEST['field_id']) . "', '" . JB_escape_sql($_SESSION["LANG"]) . "', '" . JB_escape_sql($label) . "', '" . JB_escape_sql($_REQUEST['error_message']) . "', '" . JB_escape_sql($_REQUEST['field_comment']) . "' )";
JB_mysql_query($sql_fft) or die($sql . mysql_error());
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'] = JB_mysql_insert_id();
}
JB_format_codes_translation_table($_REQUEST['field_id']);
}
if ($NEW_FIELD == 'YES') {
$field_id = JB_mysql_insert_id();
} else {
$field_id = $_REQUEST['field_id'];
}
JB_cache_del_keys_for_form($_REQUEST['form_id']);
$_REQUEST['mode'] = 'EDIT';
global $NEW_FIELD;
$_REQUEST['NEW_FIELD'] = 'NO';
return $field_id;
}
