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 $DIC;
 
        $DIC->database()->setLimit(1);
        $query = 'SELECT * FROM ' . self::$settingsTable;
 
        $rset = $DIC->database()->query($query);
        if ($row = $DIC->database()->fetchObject($rset)) {
            return new self((int) $row->instance_id, $row);
        }
    }
 
    public function getServerSettings()
    {
        require_once 'Modules/Chatroom/classes/class.ilChatroomServerSettings.php';
        return ilChatroomServerSettings::loadDefault();
    }
 
    public function saveGeneralSettings(stdClass $settings)
    {
        global $DIC;
 
        $res = $DIC->database()->queryF(
            "
                                SELECT  * 
                                FROM    chatroom_admconfig
                                WHERE   instance_id = %s",
            array('integer'),
            array($this->config_id)
        );
 
        $row = $DIC->database()->fetchAssoc($res);
 
        $DIC->database()->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 = "{}";
 
        $DIC->database()->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 $DIC;
 
        $res = $DIC->database()->queryF(
            "
                                SELECT  * 
                                FROM    chatroom_admconfig
                                WHERE   instance_id = %s",
            array('integer'),
            array($this->config_id)
        );
 
        $row = $DIC->database()->fetchAssoc($res);
 
        $DIC->database()->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 = "{}";
 
        $DIC->database()->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 $DIC;
 
        $query = 'SELECT * FROM ' . self::$settingsTable . ' WHERE instance_id = ' . $DIC->database()->quote($this->config_id, 'integer');
 
        if (($row = $DIC->database()->fetchAssoc($DIC->database()->query($query))) && $row['server_settings']) {
            $settings = json_decode($row['server_settings'], true);
 
            if (!$settings['protocol']) {
                $settings['protocol'] = 'http';
            }
 
            return $settings;
        }
 
        return array();
    }
 
    public function loadClientSettings()
    {
        global $DIC;
 
        $query = 'SELECT * FROM ' . self::$settingsTable . ' WHERE instance_id = ' . $DIC->database()->quote($this->config_id, 'integer');
        if (($row = $DIC->database()->fetchAssoc($DIC->database()->query($query))) && $row['client_settings']) {
            $settings = json_decode($row['client_settings'], true);
 
            if (!$settings['osd_intervall']) {
                $settings['osd_intervall'] = 60;
            }
 
            if (!$settings['client']) {
                $settings['client'] = CLIENT_ID;
            }
 
            $settings['client_name'] = (string) $settings['name'];
            if (!$settings['client_name']) {
                $settings['client_name'] = CLIENT_ID;
            }
 
            return $settings;
        }
 
        return array();
    }
}