Changeset 1809 for sandbox/filemanager/inc/class.user.inc.php

Timestamp:

12/11/09 09:34:51 (14 years ago)

Author:

amuller

Message:

Ticket #597 - Tratamento de erros no salvamento de preferencias no filmanager

File:

• sandbox/filemanager/inc/class.user.inc.php (modified) (2 diffs)

sandbox/filemanager/inc/class.user.inc.php

@@ -102 +102 @@
                 }
                 function save_preferences(){
-                        $string_serial = addslashes($this->preferences);
-                        $query = "update phpgw_preferences set preference_value = '".$string_serial."' where preference_app = 'filemanager'".
-                                " and preference_owner = '".$this->user_id."'";
+                        /* See if preferences exists or not */
+                        $query = "SELECT count(preference_owner) FROm phpgw_preferences WHERE preference_app = 'filemanager' AND preference_owner = 1009 LIMIT 1";
+                        if ($GLOBALS['phpgw']->db->query($query) && $GLOBALS['phpgw']->db->next_record())
+                                $val = $GLOBALS['phpgw']->db->row();
+                        else
+                        {
+                                echo $GLOBALS['phpgw']->db->error;
+                                return false;
+                        }
+
+                        $string_serial = addslashes($this->preferences);
+                        if ($val['count'] == '1')
+                        {
+                                $query = "UPDATE phpgw_preferences set preference_value = '".$string_serial.
+                                        "' where preference_app = 'filemanager'".
+                                        " and preference_owner = '".$this->user_id."'";
                                 if (!$GLOBALS['phpgw']->db->query($query)){
                                         echo $GLOBALS['phpgw']->db->error;
@@ -113 +126 @@
                                         return;
                                 }
+                        }
+                        else
+                        {
+                                /*preferences does not exist*/
+                                $query = "INSERT INTO phpgw_preferences values (".$this->user_id.",'filemanager','".$string_serial."')";
+                                if (!$GLOBALS['phpgw']->db->query($query)){
+                                        echo $GLOBALS['phpgw']->db->error;
+                                        return false;
+                                }
+                                else{
+                                        echo "True";
+                                        return;
+                                }
+
+                        }
                 }