comment.class.php

Go to the documentation of this file.

<?php
/* Copyright (C) NAVER <http://www.navercorp.com> */

require_once(_XE_PATH_ . 'modules/comment/comment.item.php');

class comment extends ModuleObject
{

    function moduleInstall()
    {
        $oDB = DB::getInstance();

        // register the action forward (for using on the admin mode)
        $oModuleController = getController('module');

        $oDB->addIndex(
                "comments", "idx_module_list_order", array("module_srl", "list_order"), TRUE
        );

        // 2007. 10. 17 add a trigger to delete comments together with posting deleted
        $oModuleController->insertTrigger('document.deleteDocument', 'comment', 'controller', 'triggerDeleteDocumentComments', 'after');
        // 2007. 10. 17 add a trigger to delete all of comments together with module deleted
        $oModuleController->insertTrigger('module.deleteModule', 'comment', 'controller', 'triggerDeleteModuleComments', 'after');
        // 2008. 02. 22 add comment setting when a new module added
        $oModuleController->insertTrigger('module.dispAdditionSetup', 'comment', 'view', 'triggerDispCommentAdditionSetup', 'before');

        if(!is_dir('./files/cache/tmp'))
        {
            FileHandler::makeDir('./files/cache/tmp');
        }

        return new BaseObject();
    }

    function checkUpdate()
    {
        $oDB = DB::getInstance();
        $oModuleModel = getModel('module');
        $oModuleController = getController('module');
        $version_update_id = implode('.', array(__CLASS__, __XE_VERSION__, 'updated'));
        if($oModuleModel->needUpdate($version_update_id))
        {
            // 2007. 10. 17 add a trigger to delete comments together with posting deleted
            if(!$oModuleModel->getTrigger('document.deleteDocument', 'comment', 'controller', 'triggerDeleteDocumentComments', 'after'))
            {
                return TRUE;
            }
            // 2007. 10. 17 add a trigger to delete all of comments together with module deleted
            if(!$oModuleModel->getTrigger('module.deleteModule', 'comment', 'controller', 'triggerDeleteModuleComments', 'after'))
            {
                return TRUE;
            }
            // 2007. 10. 23 add a column for recommendation votes or notification of the comments
            if(!$oDB->isColumnExists("comments", "voted_count"))
            {
                return TRUE;
            }
            if(!$oDB->isColumnExists("comments", "notify_message"))
            {
                return TRUE;
            }
            // 2008. 02. 22 add comment setting when a new module added
            if(!$oModuleModel->getTrigger('module.dispAdditionSetup', 'comment', 'view', 'triggerDispCommentAdditionSetup', 'before'))
            {
                return TRUE;
            }
            // 2008. 05. 14 add a column for blamed count
            if(!$oDB->isColumnExists("comments", "blamed_count"))
            {
                return TRUE;
            }
            if(!$oDB->isColumnExists("comment_voted_log", "point"))
            {
                return TRUE;
            }

            if(!$oDB->isIndexExists("comments", "idx_module_list_order"))
            {
                return TRUE;
            }
            //2012. 02. 24 add comment published status column and index
            if(!$oDB->isColumnExists("comments", "status"))
            {
                return TRUE;
            }
            if(!$oDB->isIndexExists("comments", "idx_status"))
            {
                return TRUE;
            }

            // 2012. 08. 29 Add a trigger to copy additional setting when the module is copied 
            if(!$oModuleModel->getTrigger('module.procModuleAdminCopyModule', 'comment', 'controller', 'triggerCopyModule', 'after'))
            {
                return TRUE;
            }

            if(!$oDB->isIndexExists("comments", "idx_parent_srl"))
            {
                return TRUE;
            }

            $oModuleController->insertUpdatedLog($version_update_id);
        }

        return FALSE;
    }

    function moduleUpdate()
    {
        $oDB = DB::getInstance();
        $oModuleModel = getModel('module');
        $oModuleController = getController('module');
        $version_update_id = implode('.', array(__CLASS__, __XE_VERSION__, 'updated'));
        if($oModuleModel->needUpdate($version_update_id))
        {
            // 2007. 10. 17 add a trigger to delete comments together with posting deleted
            if(!$oModuleModel->getTrigger('document.deleteDocument', 'comment', 'controller', 'triggerDeleteDocumentComments', 'after'))
            {
                $oModuleController->insertTrigger('document.deleteDocument', 'comment', 'controller', 'triggerDeleteDocumentComments', 'after');
            }
            // 2007. 10. 17 add a trigger to delete all of comments together with module deleted
            if(!$oModuleModel->getTrigger('module.deleteModule', 'comment', 'controller', 'triggerDeleteModuleComments', 'after'))
            {
                $oModuleController->insertTrigger('module.deleteModule', 'comment', 'controller', 'triggerDeleteModuleComments', 'after');
            }
            // 2007. 10. 23 add a column for recommendation votes or notification of the comments
            if(!$oDB->isColumnExists("comments", "voted_count"))
            {
                $oDB->addColumn("comments", "voted_count", "number", "11");
                $oDB->addIndex("comments", "idx_voted_count", array("voted_count"));
            }

            if(!$oDB->isColumnExists("comments", "notify_message"))
            {
                $oDB->addColumn("comments", "notify_message", "char", "1");
            }
            // 2008. 02. 22 add comment setting when a new module added
            if(!$oModuleModel->getTrigger('module.dispAdditionSetup', 'comment', 'view', 'triggerDispCommentAdditionSetup', 'before'))
            {
                $oModuleController->insertTrigger('module.dispAdditionSetup', 'comment', 'view', 'triggerDispCommentAdditionSetup', 'before');
            }
            // 2008. 05. 14 add a column for blamed count
            if(!$oDB->isColumnExists("comments", "blamed_count"))
            {
                $oDB->addColumn('comments', 'blamed_count', 'number', 11, 0, TRUE);
                $oDB->addIndex('comments', 'idx_blamed_count', array('blamed_count'));
            }
            if(!$oDB->isColumnExists("comment_voted_log", "point"))
            {
                $oDB->addColumn('comment_voted_log', 'point', 'number', 11, 0, TRUE);
            }

            if(!$oDB->isIndexExists("comments", "idx_module_list_order"))
            {
                $oDB->addIndex(
                        "comments", "idx_module_list_order", array("module_srl", "list_order"), TRUE
                );
            }

            //2012. 02. 24 add comment published status column and index
            if(!$oDB->isColumnExists("comments", "status"))
            {
                $oDB->addColumn("comments", "status", "number", 1, 1, TRUE);
            }
            if(!$oDB->isIndexExists("comments", "idx_status"))
            {
                $oDB->addIndex(
                        "comments", "idx_status", array("status", "comment_srl", "module_srl", "document_srl"), TRUE
                );
            }

            // 2012. 08. 29 Add a trigger to copy additional setting when the module is copied 
            if(!$oModuleModel->getTrigger('module.procModuleAdminCopyModule', 'comment', 'controller', 'triggerCopyModule', 'after'))
            {
                $oModuleController->insertTrigger('module.procModuleAdminCopyModule', 'comment', 'controller', 'triggerCopyModule', 'after');
            }

            if(!$oDB->isIndexExists("comments", "idx_parent_srl"))
            {
                $oDB->addIndex('comments', 'idx_parent_srl', array('parent_srl'));
            }

            $oModuleController->insertUpdatedLog($version_update_id);
        }

        return new BaseObject(0, 'success_updated');
    }

    function recompileCache()
    {
        if(!is_dir('./files/cache/tmp'))
        {
            FileHandler::makeDir('./files/cache/tmp');
        }
    }

}
/* End of file comment.class.php */
/* Location: ./modules/comment/comment.class.php */