tableExists() - Code Metrics - mambax7/adslight - Measure and Improve Code Quality continuously with Scrutinizer

tableExists() A
last analyzed 2023-04-20 11:18 UTC

↳ Parent: Project

Complexity

Conditions	1
Paths	1

Size

Total Lines	5
Code Lines	2

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
eloc	2
c	1
b	0
f	0
dl	0
loc	5
rs	10
cc	1
nc	1
nop	1

<?php declare(strict_types=1);
/*
 * You may not change or alter any portion of this comment or credits
 * of supporting developers from this source code or any supporting source code
 * which is considered copyrighted (c) material of the original comment or credit authors.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
 */

/**
 * @copyright    XOOPS Project (https://xoops.org)/
 * @license      GNU GPL 2.0 or later (https://www.gnu.org/licenses/gpl-2.0.html)
 * @author       XOOPS Development Team
 */

use Xmf\Database\Tables;
use XoopsModules\Adslight\{
    Common\Configurator,
    Common\Migrate,
    Helper,
    Utility
};

/** @var Helper $helper */
/** @var Utility $utility */
/** @var Configurator $configurator */
if ((!defined('XOOPS_ROOT_PATH'))
    || !($GLOBALS['xoopsUser'] instanceof \XoopsUser)
    || !$GLOBALS['xoopsUser']->isAdmin()) {
    exit('Restricted access' . PHP_EOL);
}

/**
 * @param string $tablename
 */
function tableExists($tablename): bool
{
    $result = $GLOBALS['xoopsDB']->queryF("SHOW TABLES LIKE '{$tablename}'");

    return $GLOBALS['xoopsDB']->getRowsNum($result) > 0;
}

/**
 * Prepares system prior to attempting to install module
 * @param XoopsModule $module {@link XoopsModule}
 *
 * @return bool true if ready to install, false if not
 */
function xoops_module_pre_update_adslight(\XoopsModule $module): bool
{
    $helper  = Helper::getInstance();

    $utility = new Utility();

    $xoopsSuccess = $utility::checkVerXoops($module);

    $phpSuccess   = $utility::checkVerPhp($module);


    $migrate = new Xmf\Database\Migrate('adslight');
    $result  = $migrate->synchronizeSchema();


    return true;

    return $xoopsSuccess && $phpSuccess;
function fx() {
    try {
        doSomething();
        return true;
    }
    catch (\Exception $e) {
        return false;
    }

    return false;
}
}

/**
 * Performs tasks required during update of the module
 * @param XoopsModule     $module {@link XoopsModule}
 * @param null|string|int $previousVersion
 *
 * @return bool true if update successful, false if not
 */
function xoops_module_update_adslight(\XoopsModule $module, $previousVersion = null): bool
{
    global $xoopsDB;
    $moduleDirName = \basename(\dirname(__DIR__));
    $helper        = Helper::getInstance();

    $utility       = new Utility();
    $configurator  = new Configurator();

    $migrator = new Migrate();
    $migrator->synchronizeSchema();

    if ($previousVersion < 240) {
        //delete old HTML templates
        if (count($configurator->templateFolders) > 0) {
            foreach ($configurator->templateFolders as $folder) {
                $templateFolder = $GLOBALS['xoops']->path('modules/' . $moduleDirName . $folder);
                if (is_dir($templateFolder)) {
                    $templateList = array_diff(scandir($templateFolder, SCANDIR_SORT_NONE), ['..', '.']);
                    foreach ($templateList as $k => $v) {
                        $fileInfo = new \SplFileInfo($templateFolder . $v);
                        if ('html' === $fileInfo->getExtension() && 'index.html' !== $fileInfo->getFilename()) {
                            if (is_file($templateFolder . $v)) {
                                unlink($templateFolder . $v);
                            }
                        }
                    }
                }
            }
        }

        //  ---  DELETE OLD FILES ---------------
        if (count($configurator->oldFiles) > 0) {
            //    foreach (array_keys($GLOBALS['uploadFolders']) as $i) {
            foreach (array_keys($configurator->oldFiles) as $i) {
                $tempFile = $GLOBALS['xoops']->path('modules/' . $moduleDirName . $configurator->oldFiles[$i]);
                if (is_file($tempFile)) {
                    unlink($tempFile);
                }
            }
        }

        //  ---  DELETE OLD FOLDERS ---------------
        xoops_load('XoopsFile');
        if (count($configurator->oldFolders) > 0) {
            //    foreach (array_keys($GLOBALS['uploadFolders']) as $i) {
            foreach (array_keys($configurator->oldFolders) as $i) {
                $tempFolder = $GLOBALS['xoops']->path('modules/' . $moduleDirName . $configurator->oldFolders[$i]);
                /** @var \XoopsObjectHandler $folderHandler */
                $folderHandler = XoopsFile::getHandler('folder', $tempFolder);
                $folderHandler->delete($tempFolder);
            }
        }

        //  ---  CREATE FOLDERS ---------------
        if (count($configurator->uploadFolders) > 0) {
            //    foreach (array_keys($GLOBALS['uploadFolders']) as $i) {
            foreach (array_keys($configurator->uploadFolders) as $i) {
                $utility::createFolder($configurator->uploadFolders[$i]);
            }
        }

        //  ---  COPY blank.png FILES ---------------
        if (count($configurator->copyBlankFiles) > 0) {
            $file = \dirname(__DIR__) . '/assets/images/blank.png';
            foreach (array_keys($configurator->copyBlankFiles) as $i) {
                $dest = $configurator->copyBlankFiles[$i] . '/blank.png';
                $utility::copyFile($file, $dest);
            }
        }

        //delete .html entries from the tpl table
        $sql = 'DELETE FROM ' . $GLOBALS['xoopsDB']->prefix('tplfile') . " WHERE `tpl_module` = '" . $module->getVar('dirname', 'n') . "' AND `tpl_file` LIKE '%.html%'";
        $GLOBALS['xoopsDB']->queryF($sql);

        //delete .tpl entries from the tpl table
        $sql = 'DELETE FROM ' . $GLOBALS['xoopsDB']->prefix('tplfile') . " WHERE `tpl_module` = '" . $module->getVar('dirname', 'n') . "' AND `tpl_file` LIKE '%.tpl%'";
        $GLOBALS['xoopsDB']->queryF($sql);

        //delete tdmdownloads entries from the tpl_source table
        $sql = 'DELETE FROM ' . $GLOBALS['xoopsDB']->prefix('tplsource') . " WHERE `tpl_source` LIKE '%" . $module->getVar('dirname', 'n') . "%'";
        $GLOBALS['xoopsDB']->queryF($sql);

        //delete block entries from the newblocks table
        $sql = 'DELETE FROM ' . $GLOBALS['xoopsDB']->prefix('newblocks') . " WHERE `dirname` = '" . $module->getVar('dirname', 'n') . "'";
        $GLOBALS['xoopsDB']->queryF($sql);

        /** @var \XoopsGroupPermHandler $grouppermHandler */
        $grouppermHandler = xoops_getHandler('groupperm');

        return $grouppermHandler->deleteByModule($module->getVar('mid'), 'item_read');
    }

    return true;
}


1			<?php declare(strict_types=1);
2			/*
3			* You may not change or alter any portion of this comment or credits
4			* of supporting developers from this source code or any supporting source code
5			* which is considered copyrighted (c) material of the original comment or credit authors.
6			*
7			* This program is distributed in the hope that it will be useful,
8			* but WITHOUT ANY WARRANTY; without even the implied warranty of
9			* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
10			*/
11
12			/**
13			* @copyright XOOPS Project (https://xoops.org)/
14			* @license GNU GPL 2.0 or later (https://www.gnu.org/licenses/gpl-2.0.html)
15			* @author XOOPS Development Team
16			*/
17
18			use Xmf\Database\Tables;
19			use XoopsModules\Adslight\{
20			Common\Configurator,
21			Common\Migrate,
22			Helper,
23			Utility
24			};
25
26			/** @var Helper $helper */
27			/** @var Utility $utility */
28			/** @var Configurator $configurator */
29			if ((!defined('XOOPS_ROOT_PATH'))
30			\|\| !($GLOBALS['xoopsUser'] instanceof \XoopsUser)
31			\|\| !$GLOBALS['xoopsUser']->isAdmin()) {
32			exit('Restricted access' . PHP_EOL);
33			}
34
35			/**
36			* @param string $tablename
37			*/
38			function tableExists($tablename): bool
39			{
40			$result = $GLOBALS['xoopsDB']->queryF("SHOW TABLES LIKE '{$tablename}'");
41
42			return $GLOBALS['xoopsDB']->getRowsNum($result) > 0;
43			}
44
45			/**
46			* Prepares system prior to attempting to install module
47			* @param XoopsModule $module {@link XoopsModule}
48			*
49			* @return bool true if ready to install, false if not
50			*/
51			function xoops_module_pre_update_adslight(\XoopsModule $module): bool
52			{
53			$helper = Helper::getInstance();
			0 ignored issues – show Unused Code introduced 2019-01-19 12:03 UTC by Report Bug Copy Issue Report The assignment to `$helper` is dead and can be removed. Loading history...
54			$utility = new Utility();
55
56			$xoopsSuccess = $utility::checkVerXoops($module);
			0 ignored issues – show Unused Code introduced 2021-08-13 11:54 UTC by Report Bug Copy Issue Report The assignment to `$xoopsSuccess` is dead and can be removed. Loading history...
57			$phpSuccess = $utility::checkVerPhp($module);
			0 ignored issues – show Unused Code introduced 2021-08-13 11:54 UTC by Report Bug Copy Issue Report The assignment to `$phpSuccess` is dead and can be removed. Loading history...
58
59			$migrate = new Xmf\Database\Migrate('adslight');
60			$result = $migrate->synchronizeSchema();
			0 ignored issues – show Unused Code introduced 2021-08-13 11:54 UTC by Report Bug Copy Issue Report The assignment to `$result` is dead and can be removed. Loading history...
61
62			return true;
63
64			return $xoopsSuccess && $phpSuccess;
			0 ignored issues – show Unused Code introduced 2021-08-13 11:54 UTC by Report Bug Copy Issue Report `return $xoopsSuccess && $phpSuccess` is not reachable. This check looks for unreachable code. It uses sophisticated control flow analysis techniques to find statements which will never be executed. Unreachable code is most often the result of `return`, `die` or `exit` statements that have been added for debug purposes. function fx() { try { doSomething(); return true; } catch (\Exception $e) { return false; } return false; } In the above example, the last `return false` will never be executed, because a return statement has already been met in every possible execution path. Loading history...
65			}
66
67			/**
68			* Performs tasks required during update of the module
69			* @param XoopsModule $module {@link XoopsModule}
70			* @param null\|string\|int $previousVersion
71			*
72			* @return bool true if update successful, false if not
73			*/
74			function xoops_module_update_adslight(\XoopsModule $module, $previousVersion = null): bool
75			{
76			global $xoopsDB;
77			$moduleDirName = \basename(\dirname(__DIR__));
78			$helper = Helper::getInstance();
			0 ignored issues – show Unused Code introduced 2019-01-19 12:03 UTC by Report Bug Copy Issue Report The assignment to `$helper` is dead and can be removed. Loading history...
79			$utility = new Utility();
80			$configurator = new Configurator();
81
82			$migrator = new Migrate();
83			$migrator->synchronizeSchema();
84
85			if ($previousVersion < 240) {
86			//delete old HTML templates
87			if (count($configurator->templateFolders) > 0) {
88			foreach ($configurator->templateFolders as $folder) {
89			$templateFolder = $GLOBALS['xoops']->path('modules/' . $moduleDirName . $folder);
90			if (is_dir($templateFolder)) {
91			$templateList = array_diff(scandir($templateFolder, SCANDIR_SORT_NONE), ['..', '.']);
92			foreach ($templateList as $k => $v) {
93			$fileInfo = new \SplFileInfo($templateFolder . $v);
94			if ('html' === $fileInfo->getExtension() && 'index.html' !== $fileInfo->getFilename()) {
95			if (is_file($templateFolder . $v)) {
96			unlink($templateFolder . $v);
97			}
98			}
99			}
100			}
101			}
102			}
103
104			// --- DELETE OLD FILES ---------------
105			if (count($configurator->oldFiles) > 0) {
106			// foreach (array_keys($GLOBALS['uploadFolders']) as $i) {
107			foreach (array_keys($configurator->oldFiles) as $i) {
108			$tempFile = $GLOBALS['xoops']->path('modules/' . $moduleDirName . $configurator->oldFiles[$i]);
109			if (is_file($tempFile)) {
110			unlink($tempFile);
111			}
112			}
113			}
114
115			// --- DELETE OLD FOLDERS ---------------
116			xoops_load('XoopsFile');
117			if (count($configurator->oldFolders) > 0) {
118			// foreach (array_keys($GLOBALS['uploadFolders']) as $i) {
119			foreach (array_keys($configurator->oldFolders) as $i) {
120			$tempFolder = $GLOBALS['xoops']->path('modules/' . $moduleDirName . $configurator->oldFolders[$i]);
121			/** @var \XoopsObjectHandler $folderHandler */
122			$folderHandler = XoopsFile::getHandler('folder', $tempFolder);
123			$folderHandler->delete($tempFolder);
124			}
125			}
126
127			// --- CREATE FOLDERS ---------------
128			if (count($configurator->uploadFolders) > 0) {
129			// foreach (array_keys($GLOBALS['uploadFolders']) as $i) {
130			foreach (array_keys($configurator->uploadFolders) as $i) {
131			$utility::createFolder($configurator->uploadFolders[$i]);
132			}
133			}
134
135			// --- COPY blank.png FILES ---------------
136			if (count($configurator->copyBlankFiles) > 0) {
137			$file = \dirname(__DIR__) . '/assets/images/blank.png';
138			foreach (array_keys($configurator->copyBlankFiles) as $i) {
139			$dest = $configurator->copyBlankFiles[$i] . '/blank.png';
140			$utility::copyFile($file, $dest);
141			}
142			}
143
144			//delete .html entries from the tpl table
145			$sql = 'DELETE FROM ' . $GLOBALS['xoopsDB']->prefix('tplfile') . " WHERE `tpl_module` = '" . $module->getVar('dirname', 'n') . "' AND `tpl_file` LIKE '%.html%'";
146			$GLOBALS['xoopsDB']->queryF($sql);
147
148			//delete .tpl entries from the tpl table
149			$sql = 'DELETE FROM ' . $GLOBALS['xoopsDB']->prefix('tplfile') . " WHERE `tpl_module` = '" . $module->getVar('dirname', 'n') . "' AND `tpl_file` LIKE '%.tpl%'";
150			$GLOBALS['xoopsDB']->queryF($sql);
151
152			//delete tdmdownloads entries from the tpl_source table
153			$sql = 'DELETE FROM ' . $GLOBALS['xoopsDB']->prefix('tplsource') . " WHERE `tpl_source` LIKE '%" . $module->getVar('dirname', 'n') . "%'";
154			$GLOBALS['xoopsDB']->queryF($sql);
155
156			//delete block entries from the newblocks table
157			$sql = 'DELETE FROM ' . $GLOBALS['xoopsDB']->prefix('newblocks') . " WHERE `dirname` = '" . $module->getVar('dirname', 'n') . "'";
158			$GLOBALS['xoopsDB']->queryF($sql);
159
160			/** @var \XoopsGroupPermHandler $grouppermHandler */
161			$grouppermHandler = xoops_getHandler('groupperm');
162
163			return $grouppermHandler->deleteByModule($module->getVar('mid'), 'item_read');
164			}
165
166			return true;
167			}
168

mambax7 / adslight

tableExists() A last analyzed 2023-04-20 11:18 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

tableExists() A
last analyzed 2023-04-20 11:18 UTC