$err = 'y';
    }
    $sql = "SELECT * FROM lang_constants WHERE constant_name=? limit 1";
    $res = SqlQuery($sql, array($_POST['constant_name']));
    if ($res) {
        echo htmlspecialchars(xl('Data Alike is already in database, please change constant name'), ENT_NOQUOTES) . '<br>';
        $err = 'y';
    }
    if ($err == 'y') {
        $val_constant = $_POST['constant_name'];
    } else {
        //insert into the main table
        $sql = "INSERT INTO lang_constants SET constant_name=?";
        SqlStatement($sql, array($_POST['constant_name']));
        //insert into the log table - to allow persistant customizations
        insert_language_log('', '', $_POST['constant_name'], '');
        echo htmlspecialchars(xl('Constant', '', '', ' ') . $_POST['constant_name'] . xl('added', '', ' '), ENT_NOQUOTES) . '<br>';
    }
    // echo "$sql here ";
}
?>

<TABLE>
<FORM name="cons_form" METHOD=POST ACTION="?m=constant" onsubmit="return top.restoreSession()">
<TR>
	<TD><?php 
echo htmlspecialchars(xl('constant name'), ENT_NOQUOTES);
?>
</TD>
	<TD><INPUT TYPE="text" NAME="constant_name" size="100" value="<?php 
echo htmlspecialchars($val_constant, ENT_QUOTES);
            $value = trim($value);
            // only continue if the definition is new
            $sql = "SELECT * FROM lang_definitions WHERE def_id=? AND definition=? " . $case_sensitive_collation;
            $res_test = SqlStatement($sql, array($key, $value));
            if (!SqlFetchArray($res_test)) {
                // insert into the main language tables
                $sql = "UPDATE `lang_definitions` SET `definition`=? WHERE `def_id`=? LIMIT 1";
                SqlStatement($sql, array($value, $key));
                // insert each entry into the log table - to allow persistant customizations
                $sql = "SELECT ll.lang_description, ll.lang_code, lc.constant_name ";
                $sql .= "FROM lang_definitions AS ld, lang_languages AS ll, lang_constants AS lc ";
                $sql .= "WHERE ld.def_id=? ";
                $sql .= "AND ll.lang_id = ld.lang_id AND lc.cons_id = ld.cons_id LIMIT 1";
                $res = SqlStatement($sql, array($key));
                $row = SqlFetchArray($res);
                insert_language_log($row['lang_description'], $row['lang_code'], $row['constant_name'], $value);
                $go = 'yes';
            }
        }
    }
    if ($go == 'yes') {
        echo htmlspecialchars(xl("New Definition set added"), ENT_NOQUOTES);
    }
}
if ($_POST['edit']) {
    if ($_POST['language_select'] == '') {
        exit(htmlspecialchars(xl("Please select a language"), ENT_NOQUOTES));
    }
    $lang_id = (int) formData('language_select');
    $lang_filter = isset($_POST['filter_cons']) ? $_POST['filter_cons'] : '';
    $lang_filter .= '%';
Exemple #3
0
    }
    $sql = "SELECT * FROM lang_languages WHERE lang_code LIKE ? or lang_description LIKE ? limit 1";
    $res = SqlQuery($sql, array("%" . $_POST['lang_code'] . "%", "%" . $_POST['lang_name']));
    if ($res) {
        echo htmlspecialchars(xl("Data Alike is already in database, please change code and/or description"), ENT_NOQUOTES) . '<br>';
        $err = 'y';
    }
    if ($err == 'y') {
        $val_lang_code = $_POST['lang_code'];
        $val_lang_name = $_POST['lang_name'];
    } else {
        //insert into the main table
        $sql = "INSERT INTO lang_languages SET lang_code=?, lang_description=?";
        SqlStatement($sql, array($_POST['lang_code'], $_POST['lang_name']));
        //insert into the log table - to allow persistant customizations
        insert_language_log($_POST['lang_name'], $_POST['lang_code'], '', '');
        echo htmlspecialchars(xl('Language definition added'), ENT_NOQUOTES) . '<br>';
    }
}
?>

<TABLE>
<FORM name="lang_form" METHOD=POST ACTION="?m=language" onsubmit="return top.restoreSession()">
<TR>
	<TD><?php 
echo htmlspecialchars(xl('Language Code'), ENT_NOQUOTES);
?>
:</TD>
	<TD><INPUT TYPE="text" NAME="lang_code" size="2" maxlength="2" value="<?php 
echo htmlspecialchars($val_lang_code, ENT_QUOTES);
?>