interface/language/language.inc.php

   1 <?php
   2
   3 // gacl control
   4 $thisauth = acl_check('admin', 'language');
   5
   6 if (!$thisauth) {
   7   echo "<html>\n<body>\n";
   8   echo "<p>" . htmlspecialchars(xl('You are not authorized for this.'),ENT_NOQUOTES) . "</p>\n";
   9   echo "</body>\n</html>\n";
  10   exit();
  11  }
  12
  13 function check_pattern ($data,$pat) {
  14         if (ereg ($pat, $data)) { return TRUE ; } else { RETURN FALSE; }
  15 }
  16
  17 // Function to insert/modify items in the language log table, lang_custom
  18 //
  19 function insert_language_log($lang_desc,$lang_code,$cons_name,$def) {
  20
  21   // set up the mysql collation string to ensure case is sensitive in the mysql queries
  22   if (!$disable_utf8_flag) {
  23     $case_sensitive_collation = "COLLATE utf8_bin";
  24   }
  25   else {
  26     $case_sensitive_collation = "COLLATE latin_bin";
  27   }
  28
  29
  30   if ($cons_name == '') {
  31     // NEW LANGUAGE
  32     // (ensure not a repeat log entry)
  33     $sql = "SELECT * FROM lang_custom WHERE constant_name='' AND lang_description=? ".$case_sensitive_collation;
  34     $res_test = SqlStatement($sql, array($lang_desc) );
  35     if (!SqlFetchArray($res_test)) {
  36       $sql="INSERT INTO lang_custom SET lang_code=?, lang_description=?";
  37       SqlStatement($sql, array($lang_code, $lang_desc) );
  38     }
  39   }
  40   elseif ($lang_desc == '') {
  41     // NEW CONSTANT
  42     // (ensure not a repeat entry)
  43     $sql = "SELECT * FROM lang_custom WHERE lang_description='' AND constant_name=? ".$case_sensitive_collation;
  44     $res_test = SqlStatement($sql, array($cons_name) );
  45     if (!SqlFetchArray($res_test)) {
  46       $sql="INSERT INTO lang_custom SET constant_name=?";
  47       SqlStatement($sql, array($cons_name) );
  48     }
  49   }
  50   else {
  51     // FULL ENTRY
  52     // (ensure not a repeat log entry)
  53     $sql = "SELECT * FROM lang_custom WHERE lang_description=? ".$case_sensitive_collation." AND constant_name=? ".$case_sensitive_collation." AND definition=? ".$case_sensitive_collation;
  54     $res_test = SqlStatement($sql, array($lang_desc, $cons_name, $def) );
  55     if (!SqlFetchArray($res_test)) {
  56       // either modify already existing log entry or create a new one
  57       $sql = "SELECT * FROM lang_custom WHERE lang_description=? ".$case_sensitive_collation." AND constant_name=? ".$case_sensitive_collation;
  58       $res_test2 = SqlStatement($sql, array($lang_desc, $cons_name) );
  59       if (SqlFetchArray($res_test2)) {
  60         // modify existing log entry(s)
  61         $sql = "UPDATE lang_custom SET definition=? WHERE lang_description=? ".$case_sensitive_collation." AND constant_name=? ".$case_sensitive_collation;
  62         SqlStatement($sql, array($def, $lang_desc, $cons_name) );
  63       }
  64       else {
  65         // create new log entry
  66         $sql = "INSERT INTO lang_custom (lang_description,lang_code,constant_name,definition) VALUES (?,?,?,?)";
  67         SqlStatement($sql, array($lang_desc, $lang_code, $cons_name, $def) );
  68       }
  69     }
  70   }
  71 }
  72
  73 ?>