interface/language/lang_definition.php

   1 <?php
   2 require_once("language.inc.php");
   3
   4 if ($_POST['Submit'] == "Load Definitions") {
   5         // query for entering new definitions it picks the cons_id because is existant.
   6         $sql = "INSERT INTO lang_definitions (`cons_id`,`lang_id`,`definition`) VALUES  ";
   7   if (!empty($_POST['cons_id'])) {
   8     foreach ($_POST['cons_id'] as $key => $value) {
   9       $value = mysql_real_escape_string (trim($value));
  10       $sql .= " ('$key', ";
  11       $sql .= "'" . $_POST['lang_id'] . "',";
  12       $sql .= "'" . $value . "'),";
  13       $go = 'yes';
  14     }
  15   }
  16         if ($go=='yes') {
  17                 $sql=substr($sql,0,-1);
  18                 if (SqlStatement($sql)) {
  19                         xl ("New Definition set added",'e');
  20                 }
  21         }
  22   // query for updating preexistant definitions uses def_id because there is no def yet.
  23   // echo ('<pre>');    print_r($_POST['def_id']);      echo ('</pre>');
  24   if (!empty($_POST['def_id'])) {
  25     foreach ($_POST['def_id'] as $key => $value) {
  26       $value = mysql_real_escape_string (trim($value));
  27       $sql = "UPDATE `lang_definitions` SET `definition` = '$value' WHERE `def_id`='$key' LIMIT 1";
  28       SqlStatement($sql);
  29     }
  30   }
  31 }
  32
  33 if ($_GET['edit'] != ''){
  34         $lang_id = (int)$_GET['edit'];
  35         $sql = "SELECT * FROM `lang_definitions` RIGHT JOIN (lang_constants, lang_languages ) ON ( lang_constants.cons_id = lang_definitions.cons_id AND lang_languages.lang_id = lang_definitions.lang_id ) WHERE lang_languages.lang_id=1 ";
  36                 if ($lang_id!=1) {
  37                 $sql .= " OR lang_languages.lang_id = '$lang_id'";
  38
  39                 $what = "SELECT * from lang_languages where lang_id=$lang_id LIMIT 1";
  40                 $res = SqlStatement($what);
  41                 $row = SqlFetchArray($res);
  42                 $lang_name = $row['lang_description'];
  43
  44         }
  45         $sql.=" ORDER BY lang_constants.constant_name ";
  46
  47         $res=SqlStatement($sql);
  48
  49         echo ('<table><FORM METHOD=POST ACTION="?m=definition">');
  50         // only english definitions
  51         if ($lang_id==1) {
  52                 while ($row=SqlFetchArray($res)){
  53                         echo ('<tr><td>'.$row['constant_name'].'</td>');
  54                         // if there is no definition
  55                         if ($row['def_id']=='' OR $row['def_id']=='NULL'){
  56                                 $cons_name="cons_id[".$row['cons_id']."]";
  57                         // if there is a previous definition
  58                         } else {
  59                                 $cons_name="def_id[".$row['def_id']."]";;
  60                         }
  61                         echo ('<td><INPUT TYPE="text" size="50" NAME="'.$cons_name.'" value="'.$row['definition'].'">');
  62
  63                         echo ('</td><td></td></tr>');
  64                 }
  65                 echo ('<INPUT TYPE="hidden" name="lang_id" value="'.$lang_id.'">');
  66         // english plus the other
  67         } else {
  68                 while ($row=SqlFetchArray($res)){
  69                         echo ('<tr><td>'.$row['constant_name'].'</td>');
  70                         if ($row['definition']=='' OR $row['definition']=='NULL') {
  71                                 $def="NULL" ;
  72                         } else {
  73                                 $def=$row['definition'];
  74                         }
  75                         echo ('<td>'.$def.'</td>');
  76                         $row=SqlFetchArray($res); // jump one to get the second language selected
  77                         if ($row['def_id']=='' OR $row['def_id']=='NULL'){
  78                                 $cons_name="cons_id[".$row['cons_id']."]";
  79                         // if there is a previous definition
  80                         } else {
  81                                 $cons_name="def_id[".$row['def_id']."]";;
  82                         }
  83                         echo ('<td><INPUT TYPE="text" size="50" NAME="'.$cons_name.'" value="'.$row['definition'].'">');
  84                         echo ('</td></tr>');
  85                 }
  86                 echo ('<INPUT TYPE="hidden" name="lang_id" value="'.$lang_id.'">');
  87         }
  88         echo ('<tr><td colspan=3><INPUT TYPE="submit" name="Submit" Value="Load Definitions"></td></tr>');
  89         echo ('</FORM></table>');
  90 }
  91
  92 ?>