Changeset 414 for trunk/expressoAdmin1_2/inc/class.db_functions.inc.php

Timestamp:

09/12/08 11:39:24 (16 years ago)

Author:

niltonneto

Message:

Alterações feitas por João Alfredo.
Email: jakjr@…

File:

• trunk/expressoAdmin1_2/inc/class.db_functions.inc.php (modified) (18 diffs)

trunk/expressoAdmin1_2/inc/class.db_functions.inc.php

@@ -106 +106 @@
         {
                 $return['status'] = false;
-                        $return['msg'] = "Problemas executando a query accounts no Banco de Dados.";
+                        $result['msg'] = $this->functions->lang('Problems running query on DB') . '.';
                         $db->disconnect();
                 return $return;
@@ -120 +120 @@
         {
                 $return['status'] = false;
-                        $return['msg'] = "Problemas executando a query groups no Banco de Dados.";
+                        $result['msg'] = $this->functions->lang('Problems running query on DB') . '.';
                         $db->disconnect();
                 return $return;
@@ -142 +142 @@
                 {
                 $return['status'] = false;
-                        $return['msg'] = "Problemas executando a query update id no Banco de Dados.";
+                        $result['msg'] = $this->functions->lang('Problems running query on DB') . '.';
                 }
                 $db->disconnect();
@@ -148 +148 @@
         }
         
-        /*
-        function increment_id($id, $type)
-        {
-                $current_config = $_SESSION['phpgw_info']['expresso']['expressoAdmin'];
-                if ($current_config['expressoAdmin_nextid_db_host'] != '')
-                {
-                        $this->db->disconnect();
-                        $host = $current_config['expressoAdmin_nextid_db_host'];
-                        $port = $current_config['expressoAdmin_nextid_db_port'];
-                        $name = $current_config['expressoAdmin_nextid_db_name'];
-                        $user = $current_config['expressoAdmin_nextid_db_user'];
-                        $pass = $current_config['expressoAdmin_nextid_db_pass'];
-                        
-                        $db = new db();
-                        $db->Halt_On_Error = 'no';
-                        $db->connect($name, $host, $port, $user, $pass, 'pgsql');
-                }
-                else
-                {
-                        $db = $this->db;
-                }
-
-                $sql = "UPDATE phpgw_nextid set id = '".$id."' WHERE appname = '" . $type . "'";
-                if (!$db->query($sql))
-                {
-                        $db->disconnect();
-                        return 'Erro em increment_id:' . pg_last_error();
-                }
-                else
-                {
-                        $db->disconnect();
-                        return true;
-                }
-        }
-        */
-        
         function add_user2group($gidnumber, $uidnumber)
         {
@@ -190 +154 @@
                 {
                         $result['status'] = false;
-                        $result['msg'] = 'Erro em add_user2group:' . pg_last_error();
+                        $result['msg'] = $this->functions->lang('Error on function') . " db_functions->add_user2group.\n" . $this->functions->lang('Server returns') . ': ' . pg_last_error();
                         return $result;
                 }
@@ -203 +167 @@
                         {
                                 $result['status'] = false;
-                                $result['msg'] = 'Erro em add_user2group:' . pg_last_error();
+                                $result['msg'] = $this->functions->lang('Error on function') . " db_functions->add_user2group.\n" . $this->functions->lang('Server returns') . ': ' . pg_last_error();
                                 return $result;
                         }
@@ -217 +181 @@
                 {
                         $result['status'] = false;
-                        $result['msg'] = 'Erro em add_user2group:' . pg_last_error();
+                        $result['msg'] = $this->functions->lang('Error on function') . " db_functions->remove_user2group.\n" . $this->functions->lang('Server returns') . ': ' . pg_last_error();
                         return $result;
                 }
@@ -229 +193 @@
                         {
                                 $result['status'] = false;
-                                $result['msg'] = 'Erro em add_user2group:' . pg_last_error();
+                                $result['msg'] = $this->functions->lang('Error on function') . " db_functions->remove_user2group.\n" . $this->functions->lang('Server returns') . ': ' . pg_last_error();
                                 return $result;
                         }
@@ -243 +207 @@
                 {
                         $result['status'] = false;
-                        $result['msg'] = 'Erro em add_pref_changepassword:' . pg_last_error();
+                        $result['msg'] = $this->functions->lang('Error on function') . " db_functions->add_pref_changepassword.\n" . $this->functions->lang('Server returns') . ': ' . pg_last_error();
                         return $result;
                 }
@@ -256 +220 @@
                         {
                                 $result['status'] = false;
-                                $result['msg'] = 'Erro em add_pref_changepassword:' . pg_last_error();
+                                $result['msg'] = $this->functions->lang('Error on function') . " db_functions->add_pref_changepassword.\n" . $this->functions->lang('Server returns') . ': ' . pg_last_error();
                                 return $result;
                         }
@@ -270 +234 @@
                 {
                         $result['status'] = false;
-                        $result['msg'] = 'Erro em add_pref_changepassword:' . pg_last_error();
+                        $result['msg'] = $this->functions->lang('Error on function') . " db_functions->remove_pref_changepassword.\n" . $this->functions->lang('Server returns') . ': ' . pg_last_error();
                         return $result;
                 }
@@ -282 +246 @@
                         {
                                 $result['status'] = false;
-                                $result['msg'] = 'Erro em remove_pref_changepassword:' . pg_last_error();
+                                $result['msg'] = $this->functions->lang('Error on function') . " db_functions->remove_pref_changepassword.\n" . $this->functions->lang('Server returns') . ': ' . pg_last_error();
                                 return $result;
                         }
@@ -301 +265 @@
                                 {
                                         $result['status'] = false;
-                                        $result['msg'] = 'Erro em add_id2apps: ' . pg_last_error();
+                                        $result['msg'] = $this->functions->lang('Error on function') . " db_functions->add_id2apps.\n" . $this->functions->lang('Server returns') . ': ' . pg_last_error();
                                         return $result;
                                 }
@@ -316 +280 @@
                                         {
                                                 $result['status'] = false;
-                                                $result['msg'] = 'Erro em add_id2apps: ' . pg_last_error();
+                                                $result['msg'] = $this->functions->lang('Error on function') . " db_functions->add_id2apps.\n" . $this->functions->lang('Server returns') . ': ' . pg_last_error();
                                                 return $result;
                                         }
                                         else
                                         {
-                                                $this->write_log("Adicionado aplicativo $app ao id",$id,'','','');      
+                                                $this->write_log("Added application","$id:$app");       
                                         }
                                 }
@@ -341 +305 @@
                                 {
                                         $result['status'] = false;
-                                        $result['msg'] = 'Erro em remove_id2apps:' . pg_last_error();
+                                        $result['msg'] = $this->functions->lang('Error on function') . " db_functions->remove_id2apps.\n" . $this->functions->lang('Server returns') . ': ' . pg_last_error();
                                         return $result;
                                 }
@@ -353 +317 @@
                                         {
                                                 $result['status'] = false;
-                                                $result['msg'] = 'Erro em remove_id2apps:' . pg_last_error();
+                                                $result['msg'] = $this->functions->lang('Error on function') . " db_functions->remove_id2apps.\n" . $this->functions->lang('Server returns') . ': ' . pg_last_error();
                                                 return $result;
                                         }
                                         else
                                         {
-                                                $this->write_log("Removido aplicativo $app do id",$id,'','','');        
+                                                $this->write_log("Removed application from id","$id: $app");    
                                         }
                                 }
@@ -467 +431 @@
                         {
                                 $result['status'] = false;
-                                $result['msg'] = 'Erro em set_user_password: ' . pg_last_error();
+                                $result['msg'] = $this->functions->lang('Error on function') . " db_functions->set_user_password.\n" . $this->functions->lang('Server returns') . ': ' . pg_last_error();
                                 return $result;
                         }
@@ -578 +542 @@
         }
         
-        function write_log($action, $groupinfo='', $userinfo='', $appinfo='', $msg_log='')
-        {
-                $sql = "INSERT INTO phpgw_expressoadmin_log (date, manager, action, groupinfo, userinfo, appinfo, msg) "
-                . "VALUES('now','" . $_SESSION['phpgw_info']['expresso']['user']['account_lid'] . "','" . strtolower($action) . "','" . strtolower($groupinfo) . "','" . strtolower($userinfo) . "','" . strtolower($appinfo) . "','" .strtolower($msg_log) . "')";
+        function write_log($action, $about)
+        {
+                $sql = "INSERT INTO phpgw_expressoadmin_log (date, manager, action, userinfo) "
+                . "VALUES('now','" . $_SESSION['phpgw_info']['expresso']['user']['account_lid'] . "','" . strtolower($action) . "','" . strtolower($about) . "')";
                 $this->db->query($sql);
                 return;