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         if ($err=='y'){
  18                 $val_lang_code=$_POST['lang_code'];
  19                 $val_lang_name=$_POST['lang_name'];
  20         } else {
  21                 //insert into the main table
  22                 $sql="INSERT INTO lang_languages SET lang_code=?, lang_description=?";
  23                 SqlStatement($sql, array($_POST['lang_code'],$_POST['lang_name']) );
  24
  25                 //insert into the log table - to allow persistant customizations
  26                 insert_language_log($_POST['lang_name'],$_POST['lang_code'],'','');
  27
  28                 echo htmlspecialchars(xl('Language definition added'),ENT_NOQUOTES).'<br>';
  29         }
  30 }
  31
  32 ?>
  33
  34 <TABLE>
  35 <FORM name="lang_form" METHOD=POST ACTION="?m=language" onsubmit="return top.restoreSession()">
  36 <TR>
  37         <TD><?php  echo htmlspecialchars(xl('Language Code'),ENT_NOQUOTES); ?>:</TD>
  38         <TD><INPUT TYPE="text" NAME="lang_code" size="2" maxlength="2" value="<?php echo htmlspecialchars($val_lang_code,ENT_QUOTES); ?>"></TD>
  39 </TR>
  40 <TR>
  41         <TD><?php  echo htmlspecialchars(xl('Language Name'),ENT_NOQUOTES); ?>:</TD>
  42         <TD><INPUT TYPE="text" NAME="lang_name" size="24" value="<?php echo htmlspecialchars($val_lang_name,ENT_QUOTES); ?>"></TD>
  43 </TR>
  44 <TR>
  45         <TD></TD>
  46         <TD><INPUT TYPE="submit" name="add" value="<?php echo htmlspecialchars(xl('Add'),ENT_QUOTES); ?>"></TD>
  47 </TR>
  48 </FORM>
  49 </TABLE>