interface/language/lang_language.php

   1 <?php
   2
   3 if ($_POST['add']) {
   4     //validate
   5     $pat="^[a-z]{2}\$";
   6     if (!check_pattern($_POST['lang_code'], $pat)) {
   7         echo htmlspecialchars(xl("Code must be two letter lowercase"), ENT_NOQUOTES).'<br>';
   8         $err='y';
   9     }
  10
  11     $sql="SELECT * FROM lang_languages WHERE lang_code LIKE ? or lang_description LIKE ? limit 1" ;
  12     $res=SqlQuery($sql, array("%".$_POST['lang_code']."%","%".$_POST['lang_name']));
  13     if ($res) {
  14         echo htmlspecialchars(xl("Data Alike is already in database, please change code and/or description"), ENT_NOQUOTES).'<br>';
  15         $err='y';
  16     }
  17
  18     if ($err=='y') {
  19         $val_lang_code=$_POST['lang_code'];
  20         $val_lang_name=$_POST['lang_name'];
  21     } else {
  22             //insert into the main table
  23         $sql="INSERT INTO lang_languages SET lang_code=?, lang_description=?";
  24         SqlStatement($sql, array($_POST['lang_code'],$_POST['lang_name']));
  25
  26         //insert into the log table - to allow persistant customizations
  27         insert_language_log($_POST['lang_name'], $_POST['lang_code'], '', '');
  28
  29             echo htmlspecialchars(xl('Language definition added'), ENT_NOQUOTES).'<br>';
  30     }
  31 }
  32
  33 ?>
  34
  35 <TABLE>
  36 <FORM name="lang_form" METHOD=POST ACTION="?m=language" onsubmit="return top.restoreSession()">
  37 <TR>
  38     <TD><?php  echo htmlspecialchars(xl('Language Code'), ENT_NOQUOTES); ?>:</TD>
  39     <TD><INPUT TYPE="text" NAME="lang_code" size="2" maxlength="2" value="<?php echo htmlspecialchars($val_lang_code, ENT_QUOTES); ?>"></TD>
  40 </TR>
  41 <TR>
  42     <TD><?php  echo htmlspecialchars(xl('Language Name'), ENT_NOQUOTES); ?>:</TD>
  43     <TD><INPUT TYPE="text" NAME="lang_name" size="24" value="<?php echo htmlspecialchars($val_lang_name, ENT_QUOTES); ?>"></TD>
  44 </TR>
  45 <TR>
  46     <TD></TD>
  47     <TD><INPUT TYPE="submit" name="add" value="<?php echo htmlspecialchars(xl('Add'), ENT_QUOTES); ?>"></TD>
  48 </TR>
  49 </FORM>
  50 </TABLE>