From 1e45da277b6e28ff65967d38c12b298872efb059 Mon Sep 17 00:00:00 2001 From: tbrehm <t.brehm@ispconfig.org> Date: Fri, 01 Aug 2008 17:37:59 -0400 Subject: [PATCH] Added translation functions for the tabs of forms. --- interface/lib/classes/tform.inc.php | 113 ++++++++++++++++++++++++++++++++++---------------------- 1 files changed, 68 insertions(+), 45 deletions(-) diff --git a/interface/lib/classes/tform.inc.php b/interface/lib/classes/tform.inc.php index e631e23..9f920c6 100644 --- a/interface/lib/classes/tform.inc.php +++ b/interface/lib/classes/tform.inc.php @@ -135,10 +135,16 @@ $this->formDef = $form; $this->module = $module; + $wb = array(); + if($module == '') { + if(is_file("lib/lang/".$_SESSION["s"]["language"]."_".$this->formDef["name"].".lng")) { include_once("lib/lang/".$_SESSION["s"]["language"]."_".$this->formDef["name"].".lng"); + } } else { + if(is_file("../$module/lib/lang/".$_SESSION["s"]["language"]."_".$this->formDef["name"].".lng")) { include_once("../$module/lib/lang/".$_SESSION["s"]["language"]."_".$this->formDef["name"].".lng"); + } } $this->wordbook = $wb; @@ -156,7 +162,8 @@ */ function decode($record,$tab) { if(!is_array($this->formDef['tabs'][$tab])) $app->error("Tab ist leer oder existiert nicht (TAB: $tab)."); - if(is_array($record)) { + $new_record = ''; + if(is_array($record)) { foreach($this->formDef['tabs'][$tab]['fields'] as $key => $field) { switch ($field['datatype']) { case 'VARCHAR': @@ -191,6 +198,7 @@ } } + return $new_record; } @@ -216,7 +224,11 @@ $querystring = str_replace("{GROUPID}",$_SESSION["s"]["user"]["default_group"],$querystring); $querystring = str_replace("{GROUPS}",$_SESSION["s"]["user"]["groups"],$querystring); $table_idx = $this->formDef['db_table_idx']; - $querystring = str_replace("{RECORDID}",$record[$table_idx],$querystring); + + $tmp_recordid = (isset($record[$table_idx]))?$record[$table_idx]:0; + $querystring = str_replace("{RECORDID}",$tmp_recordid,$querystring); + unset($tmp_recordid); + $querystring = str_replace("{AUTHSQL}",$this->getAuthSQL('r'),$querystring); // Getting the records @@ -273,14 +285,14 @@ $val = $record[$key]; // If Datasource is set, get the data from there - if(is_array($field['datasource'])) { + if(isset($field['datasource']) && is_array($field['datasource'])) { $field["value"] = $this->getDatasourceData($field, $record); } switch ($field['formtype']) { case 'SELECT': + $out = ''; if(is_array($field['value'])) { - $out = ''; foreach($field['value'] as $k => $v) { $selected = ($k == $val)?' SELECTED':''; $out .= "<option value='$k'$selected>$v</option>\r\n"; @@ -362,7 +374,7 @@ foreach($this->formDef['tabs'][$tab]['fields'] as $key => $field) { // If Datasource is set, get the data from there - if(is_array($field['datasource'])) { + if(@is_array($field['datasource'])) { $field["value"] = $this->getDatasourceData($field, $record); } @@ -371,11 +383,12 @@ if(is_array($field['value'])) { $out = ''; foreach($field['value'] as $k => $v) { - $selected = ($k == $val)?' SELECTED':''; - $out .= "<option value='$k'$selected>$v</option>\r\n"; + //$selected = ($k == $val)?' SELECTED':''; + $selected = ''; + $out .= "<option value='$k'$selected>$v</option>\r\n"; } } - $new_record[$key] = $out; + if(isset($out)) $new_record[$key] = $out; break; case 'MULTIPLE': if(is_array($field['value'])) { @@ -464,12 +477,12 @@ if(is_array($record)) { foreach($this->formDef['tabs'][$tab]['fields'] as $key => $field) { - if(is_array($field['validators'])) $this->validateField($key, $record[$key], $field['validators']); + if(isset($field['validators']) && is_array($field['validators'])) $this->validateField($key, (isset($record[$key]))?$record[$key]:'', $field['validators']); switch ($field['datatype']) { case 'VARCHAR': - if(!is_array($record[$key])) { - $new_record[$key] = addslashes($record[$key]); + if(!@is_array($record[$key])) { + $new_record[$key] = (isset($record[$key]))?addslashes($record[$key]):''; } else { $new_record[$key] = implode($field['separator'],$record[$key]); } @@ -490,7 +503,7 @@ } break; case 'INTEGER': - $new_record[$key] = intval($record[$key]); + $new_record[$key] = (isset($record[$key]))?intval($record[$key]):0; //if($new_record[$key] != $record[$key]) $new_record[$key] = $field['default']; //if($key == 'refresh') die($record[$key]); break; @@ -503,7 +516,7 @@ } // The use of the field value is deprecated, use validators instead - if($field['regex'] != '') { + if(isset($field['regex']) && $field['regex'] != '') { // Enable that "." matches also newlines $field['regex'] .= 's'; if(!preg_match($field['regex'], $record[$key])) { @@ -531,6 +544,8 @@ global $app; + $escape = '`'; + // loop trough the validators foreach($validators as $validator) { @@ -539,7 +554,11 @@ $validator['regex'] .= 's'; if(!preg_match($validator['regex'], $field_value)) { $errmsg = $validator['errmsg']; - $this->errorMessage .= $this->wordbook[$errmsg]."<br>\r\n"; + if(isset($this->wordbook[$errmsg])) { + $this->errorMessage .= $this->wordbook[$errmsg]."<br>\r\n"; + } else { + $this->errorMessage .= $errmsg."<br>\r\n"; + } } break; case 'UNIQUE': @@ -674,7 +693,7 @@ $sql_insert_key .= "`$key`, "; if($field['encryption'] == 'CRYPT') { $salt="$1$"; - for ($n=0;$n<8;$n++) { + for ($n=0;$n<11;$n++) { $salt.=chr(mt_rand(64,126)); } $salt.="$"; @@ -683,7 +702,7 @@ } else { $record[$key] = md5($record[$key]); } - $sql_insert_val .= "'".$record[$key]."', "; + $sql_insert_val .= "'".addslashes($record[$key])."', "; } elseif ($field['formtype'] == 'CHECKBOX') { $sql_insert_key .= "`$key`, "; if($record[$key] == '') { @@ -699,9 +718,9 @@ } } else { if($field['formtype'] == 'PASSWORD') { - if($field['encryption'] == 'CRYPT') { + if(isset($field['encryption']) && $field['encryption'] == 'CRYPT') { $salt="$1$"; - for ($n=0;$n<8;$n++) { + for ($n=0;$n<11;$n++) { $salt.=chr(mt_rand(64,126)); } $salt.="$"; @@ -710,7 +729,7 @@ } else { $record[$key] = md5($record[$key]); } - $sql_update .= "`$key` = '".$record[$key]."', "; + $sql_update .= "`$key` = '".addslashes($record[$key])."', "; } elseif ($field['formtype'] == 'CHECKBOX') { if($record[$key] == '') { // if a checkbox is not set, we set it to the unchecked value @@ -802,6 +821,9 @@ // �berpr�fe, ob das Template existiert, wenn nicht // dann generiere das Template + + // Translate the title of the tab + $tab['title'] = $this->lng($tab['title']); if(!is_file($tab["template"])) { $app->uses('tform_tpl_generator'); @@ -830,8 +852,8 @@ $app->tpl->setVar('form_active_tab',$active_tab); // Set form title - $form_hint = '<b>'.$this->formDef["title"].'</b>'; - if($this->formDef["description"] != '') $form_hint .= '<br><br>'.$this->formDef["description"]; + $form_hint = '<b>'.$this->lng($this->formDef["title"]).'</b>'; + if($this->formDef["description"] != '') $form_hint .= '<br><br>'.$this->lng($this->formDef["description"]); $app->tpl->setVar('form_hint',$form_hint); // Set Wordbook for this form @@ -841,6 +863,7 @@ function getDataRecord($primary_id) { global $app; + $escape = '`'; $sql = "SELECT * FROM ".$escape.$this->formDef['db_table'].$escape." WHERE ".$this->formDef['db_table_idx']." = ".$primary_id; return $app->db->queryOneRecord($sql); } @@ -855,23 +878,14 @@ } else { $escape = '`'; } - - /* - if($action == "UPDATE" or $action == "DELETE") { - $sql = "SELECT * FROM ".$escape.$this->formDef['db_table'].$escape." WHERE ".$this->formDef['db_table_idx']." = ".$primary_id; - $record_old = $app->db->queryOneRecord($sql); - } else { - $record_old = array(); - } - */ $diffrec = array(); if(is_array($record_new) && count($record_new) > 0) { foreach($record_new as $key => $val) { - if($record_old[$key] != $val) { + if(@$record_old[$key] != $val) { // Record has changed - $diffrec[$key] = array('old' => $record_old[$key], + $diffrec[$key] = array('old' => @$record_old[$key], 'new' => $val); } } @@ -892,7 +906,8 @@ if(is_array($record_old) && count($record_old) > 0) { foreach($record_old as $key => $val) { - if(isset($record_new[$key]) && $record_new[$key] != $val) { + //if(isset($record_new[$key]) && $record_new[$key] != $val) { + if(!isset($record_new[$key]) || $record_new[$key] != $val) { // Record has changed $diffrec_full['old'][$key] = $val; $diffrec_full['new'][$key] = $record_new[$key]; @@ -914,14 +929,8 @@ } } - /* - echo "<pre>"; - print_r($diffrec_full); - echo "</pre>"; - */ - // Insert the server_id, if the record has a server_id - $server_id = ($record_old["server_id"] > 0)?$record_old["server_id"]:0; + $server_id = (isset($record_old["server_id"]) && $record_old["server_id"] > 0)?$record_old["server_id"]:0; if(isset($record_new["server_id"])) $server_id = $record_new["server_id"]; if(count($this->diffrec) > 0) { @@ -945,9 +954,10 @@ if($_SESSION["s"]["user"]["typ"] == 'admin') { return '1'; } else { - $sql = '('; + $groups = ( $_SESSION["s"]["user"]["groups"] ) ? $_SESSION["s"]["user"]["groups"] : 0; + $sql = '('; $sql .= "(sys_userid = ".$_SESSION["s"]["user"]["userid"]." AND sys_perm_user like '%$perm%') OR "; - $sql .= "(sys_groupid IN (".$_SESSION["s"]["user"]["groups"].") AND sys_perm_group like '%$perm%') OR "; + $sql .= "(sys_groupid IN (".$groups.") AND sys_perm_group like '%$perm%') OR "; $sql .= "sys_perm_other like '%$perm%'"; $sql .= ')'; @@ -978,8 +988,8 @@ } } else { $result = false; - if($this->formDef["auth_preset"]["userid"] == $_SESSION["s"]["user"]["userid"] && stristr($perm,$this->formDef["auth_preset"]["perm_user"])) $result = true; - if($this->formDef["auth_preset"]["groupid"] == $_SESSION["s"]["user"]["groupid"] && stristr($perm,$this->formDef["auth_preset"]["perm_group"])) $result = true; + if(@$this->formDef["auth_preset"]["userid"] == $_SESSION["s"]["user"]["userid"] && stristr($perm,$this->formDef["auth_preset"]["perm_user"])) $result = true; + if(@$this->formDef["auth_preset"]["groupid"] == $_SESSION["s"]["user"]["groupid"] && stristr($perm,$this->formDef["auth_preset"]["perm_group"])) $result = true; if(@stristr($this->formDef["auth_preset"]["perm_other"],$perm)) $result = true; // if preset == 0, everyone can insert a record of this type @@ -995,7 +1005,7 @@ // Welcher Tab wird angezeigt if($this->errorMessage == '') { // wenn kein Fehler vorliegt - if($_REQUEST["next_tab"] != '') { + if(isset($_REQUEST["next_tab"]) && $_REQUEST["next_tab"] != '') { // wenn n�chster Tab bekannt $active_tab = $_REQUEST["next_tab"]; } else { @@ -1013,6 +1023,19 @@ function getCurrentTab() { return $_SESSION["s"]["form"]["tab"]; } + + + // translation function for forms, tries the form wordbook first and if this fails, it tries the global wordbook + function lng($msg) { + global $app; + + if(isset($this->wordbook[$msg])) { + return $this->wordbook[$msg]; + } else { + return $app->lng($msg); + } + + } } -- Gitblit v1.9.1