class.ilChatroomSmilies.php

Go to the documentation of this file.

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

class ilChatroomSmilies
{
        public static function _initial()
        {
                self::_setupDatabase();
                self::_insertDefaultValues();
                self::_setupFolder();
        }

        private static function _setupDatabase()
        {
                global $ilDB;

                $fields = array(
                        'smiley_id'       => array(
                                'type'   => 'integer',
                                'length' => 4,
                        ),
                        'smiley_keywords' => array(
                                'type'   => 'text',
                                'length' => 100,
                        ),
                        'smiley_path'     => array(
                                'type'   => 'text',
                                'length' => 200,
                        )
                );

                //$ilDB->dropTable( "chatroom_smilies" );
                //$ilDB->dropTable( "chatroom_smilies_seq" );

                $ilDB->createTable('chatroom_smilies', $fields);
                $ilDB->addPrimaryKey('chatroom_smilies', array('smiley_id'));
                $ilDB->createSequence('chatroom_smilies');
        }

        private static function _insertDefaultValues()
        {
                global $ilDB;

                $values = array(
                        array("icon_smile.gif", ":)\n:-)\n:smile:"),
                        array("icon_wink.gif", ";)\n;-)\n:wink:"),
                        array("icon_laugh.gif", ":D\n:-D\n:laugh:\n:grin:\n:biggrin:"),
                        array("icon_sad.gif", ":(\n:-(\n:sad:"),
                        array("icon_shocked.gif", ":o\n:-o\n:shocked:"),
                        array("icon_tongue.gif", ":p\n:-p\n:tongue:"),
                        array("icon_cool.gif", ":cool:"),
                        array("icon_eek.gif", ":eek:"),
                        array("icon_angry.gif", ":||\n:-||\n:angry:"),
                        array("icon_flush.gif", ":flush:"),
                        array("icon_idea.gif", ":idea:"),
                        array("icon_thumbup.gif", ":thumbup:"),
                        array("icon_thumbdown.gif", ":thumbdown:"),
                );

                $stmt = $ilDB->prepareManip("
                        INSERT INTO chatroom_smilies (smiley_id, smiley_keywords, smiley_path)
                        VALUES (?, ?, ?)",
                        array("integer", "text", "text")
                );

                foreach($values as $val)
                {
                        $row = array(
                                $ilDB->nextId("chatroom_smilies"),
                                $val[1],
                                $val[0]
                        );
                        $stmt->execute($row);
                }
        }

        private static function _setupFolder()
        {
                $path = ilUtil::getWebspaceDir() . '/chatroom/smilies';

                if(!is_dir($path))
                {
                        mkdir($path, 0755, true);
                }
        }

        public static function _checkSetup()
        {
                global $lng;

                $path = self::_getSmileyDir();

                if(!is_dir($path))
                {
                        ilUtil::sendInfo($lng->txt('chatroom_smilies_dir_not_exists'));
                        ilUtil::makeDirParents($path);

                        if(!is_dir($path))
                        {
                                ilUtil::sendFailure($lng->txt('chatroom_smilies_dir_not_available'));
                                return false;
                        }
                        else
                        {
                                $smilies = array(
                                        "icon_smile.gif",
                                        "icon_wink.gif",
                                        "icon_laugh.gif",
                                        "icon_sad.gif",
                                        "icon_shocked.gif",
                                        "icon_tongue.gif",
                                        "icon_cool.gif",
                                        "icon_eek.gif",
                                        "icon_angry.gif",
                                        "icon_flush.gif",
                                        "icon_idea.gif",
                                        "icon_thumbup.gif",
                                        "icon_thumbdown.gif",
                                );

                                foreach($smilies as $smiley)
                                {
                                        copy("templates/default/images/emoticons/$smiley", $path . "/$smiley");
                                }

                                self::_insertDefaultValues();
                                ilUtil::sendSuccess($lng->txt('chatroom_smilies_initialized'));
                        }
                }

                if(!is_writable($path))
                {
                        ilUtil::sendInfo($lng->txt('chatroom_smilies_dir_not_writable'));
                }

                return true;
        }

        public static function _getSmileyDir()
        {
                return ilUtil::getWebspaceDir() . '/chatroom/smilies';
        }

        public static function _getSmilies()
        {
                global $ilDB;

                $res    = $ilDB->query("SELECT smiley_id, smiley_keywords, smiley_path FROM chatroom_smilies");
                $result = array();

                while($row = $ilDB->fetchAssoc($res))
                {
                        $result[] = array(
                                "smiley_id"       => $row['smiley_id'],
                                "smiley_keywords" => $row['smiley_keywords'],
                                "smiley_path"     => $row['smiley_path'],
                                "smiley_fullpath" => ilUtil::getWebspaceDir() . '/chatroom/smilies/' . $row['smiley_path']
                        );
                }

                return $result;
        }

        public static function _deleteMultipleSmilies($ids = array())
        {
                global $ilDB;

                $smilies = self::_getSmiliesById($ids);

                if(count($smilies) <= 0)
                        return;

                $sql_parts = array();

                foreach($smilies as $s)
                {
                        unlink($s["smiley_fullpath"]);
                        $sql_parts[] = "smiley_id = " . $ilDB->quote($s["smiley_id"], 'integer');
                }

                $ilDB->manipulate("DELETE FROM chatroom_smilies WHERE " . implode(" OR ", $sql_parts));
        }

        public static function _getSmiliesById($ids = array())
        {
                global $ilDB;

                if(!count($ids))
                        return;

                $sql = "SELECT smiley_id, smiley_keywords, smiley_path FROM chatroom_smilies WHERE ";

                $sql_parts = array();

                foreach($ids as $id)
                {
                        $sql_parts[] .= "smiley_id = " . $ilDB->quote($id, "integer");
                }

                $sql .= join(" OR ", $sql_parts);
                $res    = $ilDB->query($sql);
                $result = array();

                while($row = $ilDB->fetchAssoc($res))
                {
                        $result[] = array(
                                "smiley_id"       => $row['smiley_id'],
                                "smiley_keywords" => $row['smiley_keywords'],
                                "smiley_path"     => $row['smiley_path'],
                                "smiley_fullpath" => ilUtil::getWebspaceDir() . '/chatroom/smilies/' . $row['smiley_path']
                        );
                }

                return $result;
        }

        public static function _updateSmiley($data)
        {
                global $ilDB;

                $ilDB->manipulateF(
                        "UPDATE chatroom_smilies
                                        SET smiley_keywords = %s
                                WHERE
                                        smiley_id = %s",
                        array('text', 'integer'),
                        array($data["smiley_keywords"], $data["smiley_id"])
                );

                if($data["smiley_path"])
                {
                        $sm = self::_getSmiley($data["smiley_id"]);
                        unlink($sm["smiley_fullpath"]);
                        $ilDB->manipulateF(
                                "UPDATE chatroom_smilies
                                                SET smiley_path = %s
                                        WHERE
                                                smiley_id = %s",
                                array('text', 'integer'),
                                array($data["smiley_path"], $data["smiley_id"])
                        );
                }
        }

        public static function _getSmiley($a_id)
        {
                global $ilDB;

                $res = $ilDB->queryF("
                        SELECT smiley_id, smiley_keywords, smiley_path
                        FROM chatroom_smilies
                        WHERE smiley_id = %s ",
                        array('integer'), array($a_id)
                );

                if($ilDB->numRows($res))
                {
                        while($row = $ilDB->fetchAssoc($res))
                        {
                                return array(
                                        "smiley_id"       => $row['smiley_id'],
                                        "smiley_keywords" => $row['smiley_keywords'],
                                        "smiley_path"     => $row['smiley_path'],
                                        "smiley_fullpath" => ilUtil::getWebspaceDir() . '/chatroom/smilies/' . $row['smiley_path']
                                );
                        }
                }

                throw new Exception('smiley with id $a_id not found');
        }

        public static function _getSmiliesBasePath()
        {
                return ilUtil::getWebspaceDir() . '/chatroom/smilies/';
        }

        public static function _deleteSmiley($a_id)
        {
                global $ilDB;

                try
                {
                        $smiley = self::_getSmiley($a_id);
                        $path   = ilUtil::getWebspaceDir() . '/chatroom/smilies/' . $smiley["smiley_path"];

                        if(is_file($path))
                                unlink($path);

                        $ilDB->manipulateF(
                                "DELETE FROM chatroom_smilies
                                WHERE
                                        smiley_id = %s",
                                array('integer'),
                                array($a_id)
                        );
                }
                catch(Exception $e)
                {

                }
        }

        public static function _storeSmiley($keywords, $path)
        {
                global $ilDB;

                $stmt = $ilDB->prepareManip("
                        INSERT INTO chatroom_smilies (smiley_id, smiley_keywords, smiley_path)
                        VALUES (?, ?, ?)",
                        array(
                                "integer", "text", "text"
                        )
                );
                $row  = array(
                        $ilDB->nextId("chatroom_smilies"),
                        $keywords,
                        $path
                );
                $stmt->execute($row);
        }

        public static function _prepareKeywords($words)
        {
                $keywordscheck = true;

                // check keywords
                $keywords_unchecked = explode("\n", $words);
                if(count($keywords_unchecked) <= 0)
                        $keywordscheck = false;

                if($keywordscheck)
                {
                        $keywords = array();

                        foreach($keywords_unchecked as $word)
                        {
                                if(trim($word))
                                        $keywords[] = trim($word);
                        }
                }

                if($keywordscheck && count($keywords) <= 0)
                        $keywordscheck = false;

                if($keywordscheck)
                        return $keywords;
                else
                        return array();
        }
}