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>" . xl('You are not authorized for this.','e') . "</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 //  NOTE THAT ALL PARAMETERS SHOULD ALREADY BE ESCAPED TO PREPARE FOR MYSQL QUERIES
  19 //
  20 function insert_language_log($lang_desc,$lang_code,$cons_name,$def) {
  21
  22   // set up the mysql collation string to ensure case is sensitive in the mysql queries
  23   if (!$disable_utf8_flag) {
  24     $case_sensitive_collation = "COLLATE utf8_bin";
  25   }
  26   else {
  27     $case_sensitive_collation = "COLLATE latin_bin";
  28   }
  29
  30
  31   if ($cons_name == '') {
  32     // NEW LANGUAGE
  33     // (ensure not a repeat log entry)
  34     $sql = "SELECT * FROM lang_custom WHERE constant_name='' AND lang_description='".$lang_desc."' ".$case_sensitive_collation;
  35     $res_test = SqlStatement($sql);
  36     if (!SqlFetchArray($res_test)) {
  37       $sql="INSERT INTO lang_custom SET lang_code='".$lang_code."', lang_description='".$lang_desc."'";
  38       SqlStatement ($sql);
  39     }
  40   }
  41   elseif ($lang_desc == '') {
  42     // NEW CONSTANT
  43     // (ensure not a repeat entry)
  44     $sql = "SELECT * FROM lang_custom WHERE lang_description='' AND constant_name='".$cons_name."' ".$case_sensitive_collation;
  45     $res_test = SqlStatement($sql);
  46     if (!SqlFetchArray($res_test)) {
  47       $sql="INSERT INTO lang_custom SET constant_name='".$cons_name."'";
  48       SqlStatement ($sql);
  49     }
  50   }
  51   else {
  52     // FULL ENTRY
  53     // (ensure not a repeat log entry)
  54     $sql = "SELECT * FROM lang_custom WHERE lang_description='".$lang_desc."' ".$case_sensitive_collation." AND constant_name='".$cons_name."' ".$case_sensitive_collation." AND definition='".$def."' ".$case_sensitive_collation;
  55     $res_test = SqlStatement($sql);
  56     if (!SqlFetchArray($res_test)) {
  57       // either modify already existing log entry or create a new one
  58       $sql = "SELECT * FROM lang_custom WHERE lang_description='".$lang_desc."' ".$case_sensitive_collation." AND constant_name='".$cons_name."' ".$case_sensitive_collation;
  59       $res_test2 = SqlStatement($sql);
  60       if (SqlFetchArray($res_test2)) {
  61         // modify existing log entry(s)
  62         $sql = "UPDATE lang_custom SET definition = '".$def."' WHERE lang_description='".$lang_desc."' ".$case_sensitive_collation." AND constant_name='".$cons_name."' ".$case_sensitive_collation;
  63         SqlStatement($sql);
  64       }
  65       else {
  66         // create new log entry
  67         $sql = "INSERT INTO lang_custom (lang_description,lang_code,constant_name,definition) VALUES ";
  68         $sql .= "('".$lang_desc."','".$lang_code."','".$cons_name."','".$def."')";
  69         SqlStatement($sql);
  70       }
  71     }
  72   }
  73 }
  74
  75 ?>