class.ilChatroomAdmin.php

Go to the documentation of this file.

<?php
/* Copyright (c) 1998-2009 ILIAS open source, Extended GPL, see docs/LICENSE */


class ilChatroomAdmin
{

        private static $settingsTable = 'chatroom_admconfig';
        private $settings;
        private $config_id;

        public function __construct($config_id, stdClass $settings = null)
        {
                $this->config_id        = $config_id;
                $this->settings         = $settings;
        }

        public static function getDefaultConfiguration()
        {
                global $ilDB;

                $ilDB->setLimit( 1 );
                $query = 'SELECT * FROM ' . self::$settingsTable; // . ' WHERE default_config = 1';

                $rset = $ilDB->query( $query );

                if( $row = $ilDB->fetchObject( $rset ) )
                {
                        $obj = new ilChatroomAdmin( $row->instance_id, $row );
                        return $obj;
                }
        }

        public function getServerSettings()
        {
                require_once 'Modules/Chatroom/classes/class.ilChatroomServerSettings.php';
                return ilChatroomServerSettings::loadDefault();
                /*$data = json_decode( $this->settings->server_settings );

                $settings = new ilChatroomServerSettings();

                $settings->setDomain( $data->address );
                $settings->setPort( $data->port );
                $settings->setProtocol( $data->protocol );
                $settings->setInstance( $data->instance );

                return $settings;*/
        }

        public function saveGeneralSettings(stdClass $settings)
        {
                global $ilDB;

                $res = $ilDB->queryF("
                                SELECT  * 
                                FROM    chatroom_admconfig
                                WHERE   instance_id = %s",

                array('integer'),
                array($this->config_id)
                );

                $row = $ilDB->fetchAssoc($res);

                $ilDB->manipulateF("
                        DELETE 
                        FROM    chatroom_admconfig
                        WHERE   instance_id = %s",

                array('integer'),
                array($this->config_id)
                );

                $row['default_config'] !== null ? $def_conf = $row['default_config'] : $def_conf = "{}";
                $row['client_settings'] !== null ? $clnt_set = $row['client_settings'] : $clnt_set = "{}";

                $ilDB->manipulateF("
                        INSERT INTO             chatroom_admconfig
                                                        (instance_id, server_settings, default_config, client_settings)
                        VALUES                  (%s, %s, %s, %s)",

                array('integer', 'text', 'integer', 'text'),
                array($this->config_id, json_encode( $settings ), $def_conf, $clnt_set)
                );
        }


        public function saveClientSettings(stdClass $settings)
        {
                global $ilDB;

                $res = $ilDB->queryF("
                                SELECT  * 
                                FROM    chatroom_admconfig
                                WHERE   instance_id = %s",

                array('integer'),
                array($this->config_id)
                );

                $row = $ilDB->fetchAssoc($res);

                $ilDB->manipulateF("
                        DELETE 
                        FROM    chatroom_admconfig
                        WHERE   instance_id = %s",

                array('integer'),
                array($this->config_id)
                );

                $row['default_config'] !== null ? $def_conf = $row['default_config'] : $def_conf = "{}";
                $row['server_settings'] !== null ? $srv_set = $row['server_settings'] : $srv_set = "{}";

                $ilDB->manipulateF("
                        INSERT INTO             chatroom_admconfig
                                                        (instance_id, server_settings, default_config, client_settings)
                        VALUES                  (%s, %s, %s, %s)",

                array('integer', 'text', 'integer', 'text'),
                array($this->config_id, $srv_set, $def_conf, json_encode( $settings ))
                );
        }

        public function loadGeneralSettings()
        {
                global $ilDB;

                $query = 'SELECT * FROM ' . self::$settingsTable . ' WHERE instance_id = ' .
                $ilDB->quote( $this->config_id, 'integer' );

                if( ($row = $ilDB->fetchAssoc( $ilDB->query( $query ) )) && $row['server_settings'] )
                {
                        return json_decode( $row['server_settings'] );
                }

                return null;
        }

        public function loadClientSettings()
        {
                global $ilDB;

                $query = 'SELECT * FROM ' . self::$settingsTable . ' WHERE instance_id = ' .
                $ilDB->quote( $this->config_id, 'integer' );

                if( ($row = $ilDB->fetchAssoc( $ilDB->query( $query ) )) && $row['client_settings'] )
                {
                        return json_decode( $row['client_settings'] );
                }

                return null;
        }

}

?>