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 {
  15     if (preg_match("/" . addcslashes($pat, '/') . "/", $data)) {
  16         return true ;
  17     } else {
  18         return false;
  19     }
  20 }
  21
  22 // Function to insert/modify items in the language log table, lang_custom
  23 //
  24 function insert_language_log($lang_desc, $lang_code, $cons_name, $def)
  25 {
  26
  27   // set up the mysql collation string to ensure case is sensitive in the mysql queries
  28     if (!$disable_utf8_flag) {
  29         $case_sensitive_collation = "COLLATE utf8_bin";
  30     } else {
  31         $case_sensitive_collation = "COLLATE latin_bin";
  32     }
  33
  34
  35     if ($cons_name == '') {
  36         // NEW LANGUAGE
  37         // (ensure not a repeat log entry)
  38         $sql = "SELECT * FROM lang_custom WHERE constant_name='' AND lang_description=? ".$case_sensitive_collation;
  39         $res_test = SqlStatement($sql, array($lang_desc));
  40         if (!SqlFetchArray($res_test)) {
  41             $sql="INSERT INTO lang_custom SET lang_code=?, lang_description=?";
  42             SqlStatement($sql, array($lang_code, $lang_desc));
  43         }
  44     } elseif ($lang_desc == '') {
  45         // NEW CONSTANT
  46         // (ensure not a repeat entry)
  47         $sql = "SELECT * FROM lang_custom WHERE lang_description='' AND constant_name=? ".$case_sensitive_collation;
  48         $res_test = SqlStatement($sql, array($cons_name));
  49         if (!SqlFetchArray($res_test)) {
  50             $sql="INSERT INTO lang_custom SET constant_name=?";
  51             SqlStatement($sql, array($cons_name));
  52         }
  53     } else {
  54         // FULL ENTRY
  55         // (ensure not a repeat log entry)
  56         $sql = "SELECT * FROM lang_custom WHERE lang_description=? ".$case_sensitive_collation." AND constant_name=? ".$case_sensitive_collation." AND definition=? ".$case_sensitive_collation;
  57         $res_test = SqlStatement($sql, array($lang_desc, $cons_name, $def));
  58         if (!SqlFetchArray($res_test)) {
  59             // either modify already existing log entry or create a new one
  60             $sql = "SELECT * FROM lang_custom WHERE lang_description=? ".$case_sensitive_collation." AND constant_name=? ".$case_sensitive_collation;
  61             $res_test2 = SqlStatement($sql, array($lang_desc, $cons_name));
  62             if (SqlFetchArray($res_test2)) {
  63                 // modify existing log entry(s)
  64                 $sql = "UPDATE lang_custom SET definition=? WHERE lang_description=? ".$case_sensitive_collation." AND constant_name=? ".$case_sensitive_collation;
  65                 SqlStatement($sql, array($def, $lang_desc, $cons_name));
  66             } else {
  67                 // create new log entry
  68                 $sql = "INSERT INTO lang_custom (lang_description,lang_code,constant_name,definition) VALUES (?,?,?,?)";
  69                 SqlStatement($sql, array($lang_desc, $lang_code, $cons_name, $def));
  70             }
  71         }
  72     }
  73 }