update_function.php ➔ xoops_module_update_extgallery()

Complexity

Conditions	11
Paths	240

Size

Total Lines	78
Code Lines	46

Duplication

Lines	20
Ratio	25.64 %

Importance

Changes	4
Bugs	0	Features	1

<?php
function xoops_module_update_extgallery(XoopsModule $xoopsModule, $oldVersion = null)
{
    $catHandler = xoops_getModuleHandler('publiccat', 'extgallery');
    $catHandler->rebuild();

    if ($oldVersion < 101) {

This code seems to be duplicated across your project.

        $db = XoopsDatabaseFactory::getDatabaseConnection();
        // Remove the UNIQUE key on the rating table. This constraint is software cheked now
        $sql = 'ALTER TABLE `' . $db->prefix('extgallery_publicrating') . '` DROP INDEX `photo_rate` ;';
        $db->query($sql);
    }

    if ($oldVersion < 102) {
        $db = XoopsDatabaseFactory::getDatabaseConnection();

        $sql = 'ALTER TABLE `' . $db->prefix('extgallery_publiccat') . '` ADD `cat_imgurl` VARCHAR(150) NOT NULL AFTER `cat_nb_photo` ;';
        $db->query($sql);

        $sql = 'ALTER TABLE `' . $db->prefix('extgallery_publicphoto') . '` ADD `photo_title` VARCHAR(150) NOT NULL AFTER `photo_id` ;';
        $db->query($sql);

        $sql = 'ALTER TABLE `' . $db->prefix('extgallery_publicphoto') . '` ADD `photo_weight` int(11) NOT NULL AFTER `photo_extra` ;';
        $db->query($sql);
    }

    if ($oldVersion < 104) {
        $db = XoopsDatabaseFactory::getDatabaseConnection();

        $sql = 'ALTER TABLE `' . $db->prefix('extgallery_publicphoto') . "` ADD `dohtml` BOOL NOT NULL DEFAULT '0';";
        $db->query($sql);

        $sql = 'ALTER TABLE `' . $db->prefix('extgallery_publicphoto') . '` CHANGE `photo_desc` `photo_desc` TEXT;';
        $db->query($sql);

        // Set display parmission for all XOOPS base Groups
        $sql          = 'SELECT cat_id FROM `' . $db->prefix('extgallery_publiccat') . '`;';
        $result       = $db->query($sql);
        $module_id    = $xoopsModule->getVar('mid');
        /** @var XoopsGroupPermHandler $gpermHandler*/
        $gpermHandler = xoops_getHandler('groupperm');
        while ($cat = $db->fetchArray($result)) {
            $gpermHandler->addRight('public_displayed', $cat['cat_id'], XOOPS_GROUP_ADMIN, $module_id);
            $gpermHandler->addRight('public_displayed', $cat['cat_id'], XOOPS_GROUP_USERS, $module_id);
            $gpermHandler->addRight('public_displayed', $cat['cat_id'], XOOPS_GROUP_ANONYMOUS, $module_id);
        }
    }

    if ($oldVersion < 106) {
        if (!file_exists(XOOPS_ROOT_PATH . '/uploads/extgallery/index.html')) {

This code seems to be duplicated across your project.

            $indexFile = XOOPS_ROOT_PATH . '/modules/extgallery/include/index.html';
            copy($indexFile, XOOPS_ROOT_PATH . '/uploads/extgallery/index.html');
        }

        if (!file_exists(XOOPS_ROOT_PATH . '/uploads/extgallery/public-photo/index.html')) {

This code seems to be duplicated across your project.

            $indexFile = XOOPS_ROOT_PATH . '/modules/extgallery/include/index.html';
            copy($indexFile, XOOPS_ROOT_PATH . '/uploads/extgallery/public-photo/index.html');
        }
    }

    if ($oldVersion < 107) {

        // Fix extension Bug if it's installed
        if (file_exists(XOOPS_ROOT_PATH . '/class/textsanitizer/gallery/gallery.php')) {
            $conf                          = include XOOPS_ROOT_PATH . '/class/textsanitizer/config.php';
            $conf['extensions']['gallery'] = 1;
            file_put_contents(XOOPS_ROOT_PATH . '/class/textsanitizer/config.custom.php', "<?php\rreturn \$config = " . var_export($conf, true) . "\r?>");
        }
    }

    if ($oldVersion < 109) {

This code seems to be duplicated across your project.

        $db = XoopsDatabaseFactory::getDatabaseConnection();

        $sql = 'ALTER TABLE `' . $db->prefix('extgallery_publiccat') . "` CHANGE `cat_weight` `cat_weight` INT( 11 ) NOT NULL DEFAULT '0' ;";
        $db->query($sql);
    }

    return true;
}