source: trunk/instant_messenger/inc/class.db_im.inc.php @ 260

<?php
define('PHPGW_INCLUDE_ROOT','../');     
define('PHPGW_API_INC','../phpgwapi/inc');
require_once(PHPGW_API_INC.'/class.db.inc.php');
        
class db_im
{       
        
        var $db;
        var $db_name;
        var $db_host;
        var $db_port;
        var $db_user;
        var $db_pass;
        var $db_type;
        var $user_id;
        var $teste;
        
        function db_im()
        {
                
                session_start();                
                $this->db_name = $_SESSION['phpgw_info']['instant_messenger']['server']['db_name'];
                $this->db_host = $_SESSION['phpgw_info']['instant_messenger']['server']['db_host'];
                $this->db_port = $_SESSION['phpgw_info']['instant_messenger']['server']['db_port'];
                $this->db_user = $_SESSION['phpgw_info']['instant_messenger']['server']['db_user'];
                $this->db_pass = $_SESSION['phpgw_info']['instant_messenger']['server']['db_pass'];
                $this->db_type = $_SESSION['phpgw_info']['instant_messenger']['server']['db_type'];
                $this->user_id = $_SESSION['phpgw_info']['instant_messenger']['user_id'];
                session_write_close();

                $this->db = new db();
                $this->db->connect($this->db_name,$this->db_host,$this->db_port,$this->db_user,$this->db_pass,$this->db_type);          
        }

        function get_accounts_acl()
        {
                $result = array();
                $query = "select acl_appname, acl_account from phpgw_acl where acl_appname = 'instant_messenger' order by acl_account"; 
                
                if (!$this->db->query($query))
                return null;
                
                while($this->db->next_record())
                        $result[] = $this->db->row();

                return $result;
        }
        
        function query_db($pQuery)
        {
                if (!$this->db->query($pQuery))
                return false;
                else
                        return true;
        }
        
        function set_preferences($param)
        {
                $preferences = $param['preferences'];
                $user_id  = $this->user_id;
                $app_name = $this->name_app();
                
                $query = "insert into phpgw_preferences values('".$user_id."','".$app_name."','".serialize($preferences)."')";
                
                if($this->query_db($query))
                { 
                        return "true";
                }
                else
                {
                        $query = "update phpgw_preferences set preference_value = '".serialize($preferences)."' where preference_app='".$app_name."' and preference_owner='".$user_id."'";
                        if($this->query_db($query))
                                return "true";
                        else
                                return "false";                 
                }               
        }
        
        function get_preferences()
        {
                $result = array();
                $user_id  = $this->user_id;
                $app_name = $this->name_app();
                
                $query = "select * from phpgw_preferences where preference_owner = '".$user_id."' and preference_app = '".$app_name."'";
                
                if (!$this->db->query($query))
                return NULL;
                
                while($this->db->next_record())
                        $result[] = $this->db->row();

                if(count($result) > 0)
                        return unserialize($result[0]['preference_value']);
                else
                        return "ch_offline:true;time_xa_im:1;rd_nm:true;rd_ch:false";
        }               
        
        function name_app()
        {
                return "instant_messenger";
        }
}
?>