mambax7 / wflinks

class/Utility.php

<?php

namespace XoopsModules\Wflinks;

/*
 Utility Class Definition

 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.
 */

/**
 * Module:  wflinks
 *
 * @package      \module\xsitemap\class
 * @license      http://www.fsf.org/copyleft/gpl.html GNU public license
 * @copyright    https://xoops.org 2001-2017 &copy; XOOPS Project
 * @author       ZySpec <zyspec@yahoo.com>
 * @author       Mamba <mambax7@gmail.com>
 * @since        File available since version 1.54
 */

use Xmf\Request;
use XoopsModules\Wflinks;
use XoopsModules\Wflinks\Common;
use XoopsModules\Wflinks\Constants;

/**
 * Class Utility
 */
class Utility extends Common\SysUtility
{
    //--------------- Custom module methods -----------------------------
    /**
     * getHandler()
     *
     * @param         $name
     * @param bool    $optional
     *
     * @return bool
     */
    public static function getHandler($name, $optional = false)
    {
        global $handlers, $xoopsModule;

        $name = mb_strtolower(\trim($name));
        if (!isset($handlers[$name])) {
            if (\is_file($hnd_file = XOOPS_ROOT_PATH . '/modules/' . $xoopsModule->getVar('dirname') . '/class/class_' . $name . '.php')) {
                require_once $hnd_file;
            }
            $class = 'wfl' . \ucfirst($name) . 'Handler';
            if (\class_exists($class)) {
                $handlers[$name] = new $class($GLOBALS['xoopsDB']);
            }
        }
        if (!$optional && !isset($handlers[$name])) {
            \trigger_error(
                '<div>Class <b>' . $class . '</b> does not exist.</div>

The variable $class does not seem to be defined for all execution paths leading up to this point.

                        <div>Handler Name: ' . $name,
                \E_USER_ERROR
            ) . '</div>';
        }

        return $handlers[$name] ?? false;
    }

    /**
     * @param int    $cid
     * @param string $permType
     * @param bool   $redirect
     *
     * @return bool
     */
    public static function checkGroups($cid = 0, $permType = 'WFLinkCatPerm', $redirect = false)
    {
        global $xoopsUser, $xoopsModule;

        $groups = \is_object($xoopsUser) ? $xoopsUser->getGroups() : XOOPS_GROUP_ANONYMOUS;
        /** @var \XoopsGroupPermHandler $grouppermHandler */
        $grouppermHandler = \xoops_getHandler('groupperm');
        if (!$grouppermHandler->checkRight($permType, $cid, $groups, $xoopsModule->getVar('mid'))) {
            if (false === $redirect) {
                return false;
            }

            \redirect_header('index.php', 3, _NOPERM);
        }

        return true;
    }

    /**
     * @param int $lid
     * @return array|bool|false
     */
    public static function getVoteDetails($lid = 0)
    {
        global $xoopsDB;

        $sql = 'SELECT
        COUNT(rating) AS rate,
        MIN(rating) AS min_rate,
        MAX(rating) AS max_rate,
        AVG(rating) AS avg_rate,
        COUNT(ratinguser) AS rating_user,
        MAX(ratinguser) AS max_user,
        MAX(title) AS max_title,
        MIN(title) AS min_title,
        sum(ratinguser = 0) AS null_ratinguser
        FROM ' . $xoopsDB->prefix('wflinks_votedata');
        if ($lid > 0) {
            $sql .= " WHERE lid = $lid";
        }
        if (!$result = $xoopsDB->query($sql)) {
            return false;
        }
        $ret = $xoopsDB->fetchArray($result);

        return $ret;
    }

    /**
     * @param int $sel_id
     *
     * @return array|bool
     */
    public static function calculateVoteData($sel_id = 0)
    {
        $ret                  = [];
        $ret['useravgrating'] = 0;

        $sql = 'SELECT rating FROM ' . $xoopsDB->prefix('wflinks_votedata');

The variable $xoopsDB seems to be never defined.

        if (0 != $sel_id) {
            ' WHERE lid = ' . $sel_id;
        }
        if (!$result = $xoopsDB->query($sql)) {
            return false;
        }
        $ret['uservotes'] = $xoopsDB->getRowsNum($result);
        while (list($rating) = $xoopsDB->fetchRow($result)) {
            $ret['useravgrating'] += (int)$rating;
        }
        if ($ret['useravgrating'] > 0) {
            $ret['useravgrating'] = \number_format($ret['useravgrating'] / $ret['uservotes'], 2);
        }

        return $ret;
    }

    /**
     * @param int $cid
     *
     * @return string
     */
    public static function getToolbar($cid = 0)
    {
        $toolbar = '[ ';
        if (true === static::checkGroups($cid, 'WFLinkSubPerm')) {
            $toolbar .= "<a href='submit.php?cid=" . $cid . "'>" . _MD_WFL_SUBMITLINK . '</a> | ';
        }
        $toolbar .= "<a href='newlist.php?newlinkshowdays=7'>" . _MD_WFL_LATESTLIST . "</a> | <a href='topten.php?list=hit'>" . _MD_WFL_POPULARITY . '</a>  ]';

        return $toolbar;
    }

    // displayicons()
    // @param  $time
    // @param integer $status
    // @param integer $counter
    // @return

    /**
     * @param     $time
     * @param int $status
     * @param int $counter
     *
     * @return string
     */
    public static function displayIcons($time, $status = 0, $counter = 0)
    {
        global $xoopsModule;
        /** @var Wflinks\Helper $helper */
        $helper = Wflinks\Helper::getInstance();

        $new = '';
        $pop = '';

        $newdate = (\time() - (86400 * (int)$helper->getConfig('daysnew')));
        $popdate = (\time() - (86400 * (int)$helper->getConfig('daysupdated')));

        if (3 != $helper->getConfig('displayicons')) {
            if ($newdate < $time) {
                if ((int)$status > 1) {
                    if (1 == $helper->getConfig('displayicons')) {
                        $new = '&nbsp;<img src="' . XOOPS_URL . '/modules/' . $xoopsModule->getVar('dirname') . '/assets/images/icon/update.png" alt="" align="top">';
                    }
                    if (2 == $helper->getConfig('displayicons')) {
                        $new = '<i>Updated!</i>';
                    }
                } else {
                    if (1 == $helper->getConfig('displayicons')) {
                        $new = '&nbsp;<img src="' . XOOPS_URL . '/modules/' . $xoopsModule->getVar('dirname') . '/assets/images/icon/new.png" alt="" align="top">';
                    }
                    if (2 == $helper->getConfig('displayicons')) {
                        $new = '<i>New!</i>';
                    }
                }
            }
            if ($popdate > $time) {
                if ($counter >= $helper->getConfig('popular')) {
                    if (1 == $helper->getConfig('displayicons')) {
                        $pop = '&nbsp;<img src ="' . XOOPS_URL . '/modules/' . $xoopsModule->getVar('dirname') . '/assets/images/icon/popular.png" alt="" align="top">';
                    }
                    if (2 == $helper->getConfig('displayicons')) {
                        $pop = '<i>Popular!</i>';
                    }
                }
            }
        }
        $icons = $new . ' ' . $pop;

        return $icons;
    }

    // updaterating()
    // @param  $sel_id
    // @return updates rating data in itemtable for a given item

    /**
     * @param $sel_id
     */
    public static function updateRating($sel_id)
    {
        global $xoopsDB;
        $query       = 'SELECT rating FROM ' . $xoopsDB->prefix('wflinks_votedata') . ' WHERE lid=' . $sel_id;
        $voteresult  = $xoopsDB->query($query);
        $votesDB     = $xoopsDB->getRowsNum($voteresult);
        $totalrating = 0;
        while (list($rating) = $xoopsDB->fetchRow($voteresult)) {
            $totalrating += $rating;
        }
        $finalrating = $totalrating / $votesDB;
        $finalrating = \number_format($finalrating, 4);
        $sql         = \sprintf('UPDATE `%s` SET rating = %u, votes = %u WHERE lid = %u', $xoopsDB->prefix('wflinks_links'), $finalrating, $votesDB, $sel_id);
        $xoopsDB->query($sql);
    }

    // totalcategory()
    // @param integer $pid
    // @return

    /**
     * @param int $pid
     *
     * @return int
     */
    public static function getTotalCategory($pid = 0)
    {
        global $xoopsDB;

        $sql = 'SELECT cid FROM ' . $xoopsDB->prefix('wflinks_cat');
        if ($pid > 0) {
            $sql .= ' WHERE pid=0';
        }
        $result     = $xoopsDB->query($sql);
        $catlisting = 0;
        while (list($cid) = $xoopsDB->fetchRow($result)) {
            if (static::checkGroups($cid)) {
                ++$catlisting;
            }
        }

        return $catlisting;
    }

    // static::getTotalItems()
    // @param integer $sel_id
    // @param integer $get_child
    // @param integer $return_sql
    // @return

    /**
     * @param int $sel_id
     * @param int $get_child
     * @param int $return_sql
     *
     * @return mixed
     */
    public static function getTotalItems($sel_id = 0, $get_child = 0, $return_sql = 0)
    {
        global $xoopsDB, $mytree, $_check_array;

        if ($sel_id > 0) {
            $sql = 'SELECT DISTINCT a.lid, a.cid, published FROM '
                   . $xoopsDB->prefix('wflinks_links')
                   . ' a LEFT JOIN '
                   . $xoopsDB->prefix('wflinks_altcat')
                   . ' b '
                   . 'ON b.lid=a.lid '
                   . 'WHERE published > 0 AND published <= '
                   . \time()
                   . ' AND (expired = 0 OR expired > '
                   . \time()
                   . ') AND offline = 0 '
                   . ' AND (b.cid=a.cid OR (a.cid='
                   . $sel_id
                   . ' OR b.cid='
                   . $sel_id
                   . ')) ';
        } else {
            $sql = 'SELECT lid, cid, published FROM ' . $xoopsDB->prefix('wflinks_links') . ' WHERE offline = 0 AND published > 0 AND published <= ' . \time() . ' AND (expired = 0 OR expired > ' . \time() . ')';
        }
        if (1 == $return_sql) {
            return $sql;
        }

        $count          = 0;
        $published_date = 0;

        $items  = [];

The assignment to $items is dead and can be removed.

        $result = $xoopsDB->query($sql);
        while (list($lid, $cid, $published) = $xoopsDB->fetchRow($result)) {
            if (true === static::checkGroups()) {
                ++$count;
                $published_date = ($published > $published_date) ? $published : $published_date;
            }
        }

        $child_count = 0;
        if (1 == $get_child) {
            $items = $mytree->getAllChildId($sel_id);
            foreach ($items as $item) {
                $query2 = 'SELECT DISTINCT a.lid, a.cid, published FROM '
                          . $xoopsDB->prefix('wflinks_links')
                          . ' a LEFT JOIN '
                          . $xoopsDB->prefix('wflinks_altcat')
                          . ' b '
                          . 'ON b.lid=a.lid '
                          . 'WHERE published > 0 AND published <= '
                          . \time()
                          . ' AND (expired = 0 OR expired > '
                          . \time()
                          . ') AND offline = 0 '
                          . ' AND (b.cid=a.cid OR (a.cid='
                          . $item
                          . ' OR b.cid='
                          . $item
                          . ')) ';

                $result2 = $xoopsDB->query($query2);
                while (list($lid, $published) = $xoopsDB->fetchRow($result2)) {
                    if (0 == $published) {
                        continue;
                    }
                    $published_date = ($published > $published_date) ? $published : $published_date;
                    ++$child_count;
                }
            }
        }
        $info['count']     = $count + $child_count;

$info was never initialized. Although not strictly required by PHP, it is generally a good practice to add $info = array(); before regardless.

        $info['published'] = $published_date;

        return $info;
    }

    /**
     * @param string $indeximage
     * @param string $indexheading
     *
     * @return string
     */
    public static function getImageHeader($indeximage = '', $indexheading = '')
    {
        global $xoopsDB;
        /** @var Wflinks\Helper $helper */
        $helper = Wflinks\Helper::getInstance();

        if ('' == $indeximage) {
            $result = $xoopsDB->query('SELECT indeximage, indexheading FROM ' . $xoopsDB->prefix('wflinks_indexpage'));
            list($indeximage, $indexheading) = $xoopsDB->fetchRow($result);
        }

        $image = '';
        if (!empty($indeximage)) {
            $image = static::displayImage($indeximage, "'index.php'", $helper->getConfig('mainimagedir'), $indexheading);
        }

        return $image;
    }

    /**
     * @param string $image
     * @param string $path
     * @param string $imgsource
     * @param string $alttext
     *
     * @return string
     */
    public static function displayImage($image = '', $path = '', $imgsource = '', $alttext = '')
    {
        global $xoopsConfig, $xoopsUser, $xoopsModule;

        $showimage = '';
        // Check to see if link is given
        if ($path) {
            $showimage = '<a href=' . $path . '>';
        }

        // checks to see if the file is valid else displays default blank image
        if (!\is_dir(XOOPS_ROOT_PATH . "/{$imgsource}/{$image}")
            && \is_dir(XOOPS_ROOT_PATH . "/{$imgsource}/{$image}")) {
            $showimage .= "<img src='" . XOOPS_URL . "/{$imgsource}/{$image}' border='0' alt='" . $alttext . "'></a>";
        } elseif ($xoopsUser && $xoopsUser->isAdmin($xoopsModule->getVar('mid'))) {
            $showimage .= "<img src='" . XOOPS_URL . '/modules/' . $xoopsModule->getVar('dirname') . "/assets/images/brokenimg.gif' alt='" . _MD_WFL_ISADMINNOTICE . "'></a>";
        } else {
            $showimage .= "<img src='" . XOOPS_URL . '/modules/' . $xoopsModule->getVar('dirname') . "/assets/images/blank.gif' alt='" . $alttext . "'></a>";
        }

        \clearstatcache();

        return $showimage;
    }

    /**
     * @return string
     */
    public static function getLetters()
    {
        global $xoopsModule;

        $letterchoice = '<div>' . _MD_WFL_BROWSETOTOPIC . '</div>';
        $letterchoice .= '[  ';
        $alphabet     = [
            '0',
            '1',
            '2',
            '3',
            '4',
            '5',
            '6',
            '7',
            '8',
            '9',
            'A',
            'B',
            'C',
            'D',
            'E',
            'F',
            'G',
            'H',
            'I',
            'J',
            'K',
            'L',
            'M',
            'N',
            'O',
            'P',
            'Q',
            'R',
            'S',
            'T',
            'U',
            'V',
            'W',
            'X',
            'Y',
            'Z',
        ];
        $num          = \count($alphabet) - 1;
        $counter      = 0;
        //    while (list(, $ltr) = each($alphabet)) {
        foreach ($alphabet as $key => $ltr) {
            $letterchoice .= "<a href='" . XOOPS_URL . '/modules/' . $xoopsModule->getVar('dirname') . "/viewcat.php?list=$ltr'>$ltr</a>";
            if ($counter == \round($num / 2)) {
                $letterchoice .= ' ]<br>[ ';
            } elseif ($counter != $num) {
                $letterchoice .= '&nbsp;|&nbsp;';
            }
            ++$counter;
        }
        $letterchoice .= ' ]';

        return $letterchoice;
    }

    /**
     * @param $published
     *
     * @return mixed
     */
    public static function isNewImage($published)
    {
        global $xoopsModule, $xoopsDB;

        $oneday    = (\time() - (86400 * 1));
        $threedays = (\time() - (86400 * 3));
        $week      = (\time() - (86400 * 7));

        $path = 'modules/' . $xoopsModule->getVar('dirname') . '/assets/images/icon';

        if ($published > 0 && $published < $week) {
            $indicator['image']   = "$path/linkload4.gif";

$indicator was never initialized. Although not strictly required by PHP, it is generally a good practice to add $indicator = array(); before regardless.

            $indicator['alttext'] = _MD_WFL_NEWLAST;
        } elseif ($published >= $week && $published < $threedays) {
            $indicator['image']   = "$path/linkload3.gif";
            $indicator['alttext'] = _MD_WFL_NEWTHIS;
        } elseif ($published >= $threedays && $published < $oneday) {
            $indicator['image']   = "$path/linkload2.gif";
            $indicator['alttext'] = _MD_WFL_THREE;
        } elseif ($published >= $oneday) {
            $indicator['image']   = "$path/linkload1.gif";
            $indicator['alttext'] = _MD_WFL_TODAY;
        } else {
            $indicator['image']   = "$path/linkload.gif";
            $indicator['alttext'] = _MD_WFL_NO_FILES;
        }

        return $indicator;
    }

    /**
     * @param $haystack
     * @param $needle
     *
     * @return string
     */
    public static function searchString($haystack, $needle)
    {
        return mb_substr($haystack, 0, mb_strpos($haystack, $needle) + 1);
    }

    /**
     * @param $selected
     * @param $dirarray
     * @param $namearray
     */
    public static function getDirSelectOption($selected, $dirarray, $namearray)

The parameter $dirarray is not used and could be removed.

    {
        echo "<select size='1' name='workd' onchange='location.href=\"upload.php?rootpath=\"+this.options[this.selectedIndex].value'>";
        echo "<option value=''>--------------------------------------</option>";
        foreach ($namearray as $namearray => $workd) {
            if ($workd === $selected) {
                $opt_selected = 'selected';
            } else {
                $opt_selected = '';
            }
            echo "<option value='" . \htmlspecialchars($namearray, \ENT_QUOTES) . "' $opt_selected>" . $workd . '</option>';
        }
        echo '</select>';
    }

    /**
     * @param        $FILES
     * @param string $uploaddir
     * @param string $allowed_mimetypes
     * @param string $redirecturl
     * @param int    $num
     * @param int    $redirect
     * @param int    $usertype
     *
     * @return array|null
     */
    public static function uploadFiles(
        $FILES,

The parameter $FILES is not used and could be removed.

        $uploaddir = 'uploads',
        $allowed_mimetypes = '',
        $redirecturl = 'index.php',
        $num = 0,

The parameter $num is not used and could be removed.

        $redirect = 0,
        $usertype = 1
    ) {
        global $FILES, $xoopsConfig, $xoopsModule;
        /** @var Wflinks\Helper $helper */
        $helper = Wflinks\Helper::getInstance();

        $down = [];
        //        require_once XOOPS_ROOT_PATH . '/modules/' . $xoopsModule->getVar('dirname') . '/class/uploader.php';
        require_once XOOPS_ROOT_PATH . '/class/uploader.php';
        if (empty($allowed_mimetypes)) {
            $allowed_mimetypes = wfl_getmime($FILES['userfile']['name'], $usertype);
        }
        $upload_dir = XOOPS_ROOT_PATH . '/' . $uploaddir . '/';

        $maxfilesize   = $helper->getConfig('maxfilesize');
        $maxfilewidth  = $helper->getConfig('maximgwidth');
        $maxfileheight = $helper->getConfig('maximgheight');

        $uploader = new \XoopsMediaUploader($upload_dir, $allowed_mimetypes, $maxfilesize, $maxfilewidth, $maxfileheight);
        //        $uploader->noAdminSizeCheck(1);
        if ($uploader->fetchMedia($_POST['xoops_upload_file'][0])) {
            if (!$uploader->upload()) {
                $errors = $uploader->getErrors();
                \redirect_header($redirecturl, 2, $errors);
            } elseif ($redirect) {
                \redirect_header($redirecturl, 1, _AM_WFL_UPLOADFILE);
            } else {
                if (\is_file($uploader->savedDestination)) {
                    $down['url']  = XOOPS_URL . '/' . $uploaddir . '/' . mb_strtolower($uploader->savedFileName);
                    $down['size'] = \filesize(XOOPS_ROOT_PATH . '/' . $uploaddir . '/' . mb_strtolower($uploader->savedFileName));
                }

                return $down;
            }
        } else {
            $errors = $uploader->getErrors();
            \redirect_header($redirecturl, 1, $errors);
        }

        return null;
    }

    /**
     * @param $forumid
     *
     * @return mixed
     */
    public static function getForum($forumid)
    {
        global $xoopsDB, $xoopsConfig;

        echo "<select name='forumid'>";
        echo "<option value='0'>----------------------</option>";
        if ($forumid < 4) {
            $result = $xoopsDB->query('SELECT forum_name, forum_id FROM ' . $xoopsDB->prefix('bb_forums') . ' ORDER BY forum_id');
        } else {
            $result = $xoopsDB->query('SELECT forum_name, forum_id FROM ' . $xoopsDB->prefix('bbex_forums') . ' ORDER BY forum_id');
        }
        while (list($forum_name, $forum_id) = $xoopsDB->fetchRow($result)) {
            if ($forum_id == $forumid) {
                $opt_selected = 'selected';
            } else {
                $opt_selected = '';
            }
            echo "<option value='" . $forum_id . "' $opt_selected>" . $forum_name . '</option>';
        }
        echo '</select></div>';

        return $forumid;
    }

    /**
     * @param $heading
     */
    public static function getLinkListHeader($heading)
    {
        echo "
<!--        <h4 style='font-weight: bold; color: #0A3760;'>" . $heading . "</h4>\n -->
        <table width='100%' cellspacing='1' class='outer' style='font-size: smaller;' summary>\n
        <tr>\n
        <th class='txtcenter;'>" . _AM_WFL_MINDEX_ID . "</th>\n
        <th style='text-align: left;'><b>" . _AM_WFL_MINDEX_TITLE . "</th>\n
        <th style='text-align: left;'><b>" . _AM_WFL_CATTITLE . "</th>\n
        <th class='txtcenter;'>" . _AM_WFL_MINDEX_POSTER . "</th>\n
        <th class='txtcenter;'>" . _AM_WFL_MINDEX_PUBLISH . "</th>\n
        <th class='txtcenter;'>" . _AM_WFL_MINDEX_EXPIRE . "</th>\n
        <th class='txtcenter;'>" . _AM_WFL_MINDEX_ONLINE . "</th>\n
        <th class='txtcenter;'>" . _AM_WFL_MINDEX_ACTION . "</th>\n
        </tr>\n
        ";
    }

    /**
     * @param $published
     */
    public static function getLinkListBody($published)
    {
        global $myts, $imageArray, $xoopsModule;
        /** @var Wflinks\Helper $helper */
        $helper = Wflinks\Helper::getInstance();
        \xoops_load('XoopsUserUtility');
        $lid = $published['lid'];
        $cid = $published['cid'];

        $title     = "<a href='../singlelink.php?cid=" . $published['cid'] . '&amp;lid=' . $published['lid'] . "'>" . htmlspecialchars(\trim($published['title']), ENT_QUOTES | ENT_HTML5) . '</a>';
        $maintitle = \urlencode(htmlspecialchars(\trim($published['title']), ENT_QUOTES | ENT_HTML5));

The assignment to $maintitle is dead and can be removed.

        $cattitle  = static::getCategoryTitle($published['cid']);
        $submitter = \XoopsUserUtility::getUnameFromId($published['submitter']);
        $hwhoisurl = \str_replace('http://', '', $published['url']);
        $submitted = \formatTimestamp($published['date'], $helper->getConfig('dateformat'));

The assignment to $submitted is dead and can be removed.

        $publish   = ($published['published'] > 0) ? \formatTimestamp($published['published'], $helper->getConfig('dateformatadmin')) : 'Not Published';
        $expires   = $published['expired'] ? \formatTimestamp($published['expired'], $helper->getConfig('dateformatadmin')) : _AM_WFL_MINDEX_NOTSET;
        //    if ( ( $published['published'] && $published['published'] < time() ) && $published['offline'] == 0 ) {
        //        $published_status = $imageArray['online'];
        //    } else {
        //        $published_status = ( $published['published'] == 0 ) ? "<a href='newlinks.php'>" . $imageArray['offline'] . "</a>" : $imageArray['offline'];
        //    }
        if (0 == $published['offline']
            && ($published['published'] && $published['published'] < \time())
            && (($published['expired'] && $published['expired'] > \time()) || 0 == $published['expired'])) {
            $published_status = $imageArray['online'];
        } elseif (0 == $published['offline'] && ($published['expired'] && $published['expired'] < \time())) {
            $published_status = $imageArray['expired'];
        } else {
            $published_status = (0 == $published['published']) ? "<a href='newlinks.php'>" . $imageArray['offline'] . '</a>' : $imageArray['offline'];
        }
        $icon = "<a href='main.php?op=edit&amp;lid=" . $lid . "' title='" . _AM_WFL_ICO_EDIT . "'>" . $imageArray['editimg'] . '</a>&nbsp;';
        $icon .= "<a href='main.php?op=delete&amp;lid=" . $lid . "' title='" . _AM_WFL_ICO_DELETE . "'>" . $imageArray['deleteimg'] . '</a>&nbsp;';
        $icon .= "<a href='altcat.php?op=main&amp;cid=" . $cid . '&amp;lid=' . $lid . '&amp;title=' . htmlspecialchars(\trim($published['title']), ENT_QUOTES | ENT_HTML5) . "' title='" . _AM_WFL_ALTCAT_CREATEF . "'>" . $imageArray['altcat'] . '</a>&nbsp;';
        $icon .= '<a href="http://whois.domaintools.com/' . $hwhoisurl . '" target="_blank"><img src="' . XOOPS_URL . '/modules/' . $xoopsModule->getVar('dirname') . '/assets/images/icon/domaintools.png" alt="WHOIS" title="WHOIS" align="absmiddle"></a>';

        echo "
        <tr class='txtcenter;'>\n
        <td class='head'><small>" . $lid . "</small></td>\n
        <td class='even' style='text-align: left;'><small>" . $title . "</small></td>\n
        <td class='even' style='text-align: left;'><small>" . $cattitle . "</small></td>\n
        <td class='even'><small>" . $submitter . "</small></td>\n
        <td class='even'><small>" . $publish . "</small></td>\n
        <td class='even'><small>" . $expires . "</small></td>\n
        <td class='even' width='4%'>" . $published_status . "</td>\n
        <td class='even' style='text-align: center; width: 6%; white-space: nowrap;'>$icon</td>\n
        </tr>\n
        ";
        unset($published);
    }

    /**
     * @param $catt
     *
     * @return mixed
     */
    public static function getCategoryTitle($catt)
    {
        global $xoopsDB;
        $sql    = 'SELECT title FROM ' . $xoopsDB->prefix('wflinks_cat') . ' WHERE cid=' . $catt;
        $result = $xoopsDB->query($sql);
        $result = $xoopsDB->fetchArray($result);

        return $result['title'];
    }

    public static function getLinkListFooter()
    {
        echo "<tr class='txtcenter;'>\n<td class='head' colspan='7'>" . _AM_WFL_MINDEX_NOLINKSFOUND . "</td>\n</tr>\n";
    }

    /**
     * @param        $pubrowamount
     * @param        $start
     * @param string $art
     * @param string $_this
     *
     * @return bool|null
     */
    public static function getLinkListPageNav($pubrowamount, $start, $art = 'art', $_this = '')
    {
        /** @var Wflinks\Helper $helper */
        $helper = Wflinks\Helper::getInstance();

        echo "</table>\n";
        if ($pubrowamount < $helper->getConfig('admin_perpage')) {
            return false;
        }
        // Display Page Nav if published is > total display pages amount.
        require_once XOOPS_ROOT_PATH . '/class/pagenav.php';
        //    $page = ( $pubrowamount > $helper->getConfig('admin_perpage') ) ? _AM_WFL_MINDEX_PAGE : '';
        $pagenav = new \XoopsPageNav($pubrowamount, $helper->getConfig('admin_perpage'), $start, 'st' . $art, $_this);
        echo '<div align="right" style="padding: 8px;">' . $pagenav->renderNav() . '</div>';

        return null;
    }

    /**
     * @param        $pubrowamount
     * @param        $start
     * @param string $art
     * @param string $_this
     *
     * @return bool|null
     */
    public static function getLinkListPageNavLeft($pubrowamount, $start, $art = 'art', $_this = '')
    {
        /** @var Wflinks\Helper $helper */
        $helper = Wflinks\Helper::getInstance();

        //    echo "</table>\n";
        if ($pubrowamount < $helper->getConfig('admin_perpage')) {
            return false;
        }
        // Display Page Nav if published is > total display pages amount.
        require_once XOOPS_ROOT_PATH . '/class/pagenav.php';
        //    $page = ( $pubrowamount > $helper->getConfig('admin_perpage') ) ? _AM_WFL_MINDEX_PAGE : '';
        $pagenav = new \XoopsPageNav($pubrowamount, $helper->getConfig('admin_perpage'), $start, 'st' . $art, $_this);
        echo '<div align="left" style="padding: 8px;">' . $pagenav->renderNav() . '</div>';

        return null;
    }

    // Retreive an editor according to the module's option "form_options"

    /**
     * @param $caption
     * @param $name
     * @param $value
     *
     * @return bool|\XoopsFormDhtmlTextArea|\XoopsFormEditor|\XoopsFormHtmlarea|\XoopsFormTextArea
     */
    public static function getWysiwygForm($caption, $name, $value)
    {
        global $xoopsUser, $xoopsModule;
        /** @var Wflinks\Helper $helper */
        $helper = Wflinks\Helper::getInstance();

        $editor = false;
        $x22    = false;
        $xv     = \str_replace('XOOPS ', '', \XOOPS_VERSION);
        if ('2' == mb_substr($xv, 2, 1)) {
            $x22 = true;
        }
        $editor_configs           = [];
        $editor_configs['name']   = $name;
        $editor_configs['value']  = $value;
        $editor_configs['rows']   = 35;
        $editor_configs['cols']   = 60;
        $editor_configs['width']  = '100%';
        $editor_configs['height'] = '400px';

        $isadmin = ((\is_object($xoopsUser) && null !== $xoopsUser)
                    && $xoopsUser->isAdmin($xoopsModule->mid()));
        if (true === $isadmin) {
            $formuser = $helper->getConfig('form_options');
        } else {
            $formuser = $helper->getConfig('form_optionsuser');
        }

        switch ($formuser) {
            case 'htmlarea':
                if ($x22) {
                    if (\is_readable(XOOPS_ROOT_PATH . '/class/htmlarea/formhtmlarea.php')) {
                        require_once XOOPS_ROOT_PATH . '/class/htmlarea/formhtmlarea.php';
                        $editor = new \XoopsFormHtmlarea($caption, $name, $value);
                    }
                } else {
                    $editor = new \XoopsFormEditor($caption, 'htmlarea', $editor_configs);
                }
                break;
            case 'dhtml':
                if ($x22) {
                    $editor = new \XoopsFormEditor($caption, 'dhtmltextarea', $editor_configs);
                } else {
                    $editor = new \XoopsFormDhtmlTextArea($caption, $name, $value, 20, 60);
                }
                break;
            case 'textarea':
                $editor = new \XoopsFormTextArea($caption, $name, $value);
                break;
            case 'tinyeditor':
                if ($x22) {
                    $editor = new \XoopsFormEditor($caption, 'tinyeditor', $editor_configs);
                } elseif (\is_readable(XOOPS_ROOT_PATH . '/class/xoopseditor/tinyeditor/formtinyeditortextarea.php')) {
                    require_once XOOPS_ROOT_PATH . '/class/xoopseditor/tinyeditor/formtinyeditortextarea.php';
                    $editor = new \XoopsFormTinyeditorTextArea(
                        [
                            'caption' => $caption,
                            'name'    => $name,
                            'value'   => $value,
                            'width'   => '100%',
                            'height'  => '400px',
                        ]
                    );
                } elseif ($dhtml) {

The variable $dhtml seems to be never defined.

                    $editor = new \XoopsFormDhtmlTextArea($caption, $name, $value, 50, 60);
                } else {
                    $editor = new \XoopsFormTextArea($caption, $name, $value, 7, 60);
                }
                break;
            case 'dhtmlext':
                if ($x22) {
                    $editor = new \XoopsFormEditor($caption, 'dhtmlext', $editor_configs);
                } elseif (\is_readable(XOOPS_ROOT_PATH . '/class/xoopseditor/dhtmlext/dhtmlext.php')) {
                    require_once XOOPS_ROOT_PATH . '/class/xoopseditor/dhtmlext/dhtmlext.php';
                    $editor = new \XoopsFormDhtmlTextAreaExtended($caption, $name, $value, 10, 50);
                } elseif ($dhtml) {
                    $editor = new \XoopsFormDhtmlTextArea($caption, $name, $value, 50, 60);
                } else {
                    $editor = new \XoopsFormTextArea($caption, $name, $value, 7, 60);
                }

                break;
            case 'tinymce':
                if ($x22) {
                    $editor = new \XoopsFormEditor($caption, 'tinymce', $editor_configs);
                } elseif (\is_readable(XOOPS_ROOT_PATH . '/class/xoopseditor/tinymce/formtinymce.php')) {
                    require_once XOOPS_ROOT_PATH . '/class/xoopseditor/tinymce/formtinymce.php';
                    $editor = new \XoopsFormTinymce(
                        [
                            'caption' => $caption,
                            'name'    => $name,
                            'value'   => $value,
                            'width'   => '100%',
                            'height'  => '400px',
                        ]
                    );
                } elseif (\is_readable(XOOPS_ROOT_PATH . '/editors/tinymce/formtinymce.php')) {
                    require_once XOOPS_ROOT_PATH . '/editors/tinymce/formtinymce.php';
                    $editor = new \XoopsFormTinymce(
                        [
                            'caption' => $caption,
                            'name'    => $name,
                            'value'   => $value,
                            'width'   => '100%',
                            'height'  => '400px',
                        ]
                    );
                } elseif ($dhtml) {
                    $editor = new \XoopsFormDhtmlTextArea($caption, $name, $value, 20, 60);
                } else {
                    $editor = new \XoopsFormTextArea($caption, $name, $value, 7, 60);
                }
                break;
        }

        return $editor;
    }

    /**
     * @param $countryn
     *
     * @return mixed
     */
    public static function getCountryName($countryn)
    {
        $country_array = [
            ''   => 'Unknown',
            '-'  => 'Unknown',
            'AD' => 'Andorra',
            'AE' => 'United Arab Emirates',
            'AF' => 'Afghanistan',
            'AG' => 'Antigua and Barbuda',
            'AI' => 'Anguilla',
            'AL' => 'Albania',
            'AM' => 'Armenia',
            'AN' => 'Netherlands Antilles',
            'AO' => 'Angola',
            'AQ' => 'Antarctica',
            'AR' => 'Argentina',
            'AS' => 'American Samoa',
            'AT' => 'Austria',
            'AU' => 'Australia',
            'AW' => 'Aruba',
            'AX' => 'Åland Islands',   // Added
            'AZ' => 'Azerbaijan',
            'BA' => 'Bosnia and Herzegovina',
            'BB' => 'Barbados',
            'BD' => 'Bangladesh',
            'BE' => 'Belgium',
            'BF' => 'Burkina Faso',
            'BG' => 'Bulgaria',
            'BH' => 'Bahrain',
            'BI' => 'Burundi',
            'BJ' => 'Benin',
            'BL' => 'Saint Barthélemy',   // Added
            'BM' => 'Bermuda',
            'BN' => 'Brunei Darussalam',
            'BO' => 'Bolivia',
            'BR' => 'Brazil',
            'BS' => 'Bahamas',
            'BT' => 'Bhutan',
            'BV' => 'Bouvet Island',
            'BW' => 'Botswana',
            'BY' => 'Belarus',
            'BZ' => 'Belize',
            'CA' => 'Canada',
            'CC' => 'Cocos (Keeling) Islands',
            'CD' => 'Congo (Dem. Rep.)',   // Added
            'CF' => 'Central African Republic',
            'CG' => 'Congo',
            'CH' => 'Switzerland',
            'CI' => "Cote D'Ivoire", // Removed: (Ivory Coast)
            'CK' => 'Cook Islands',
            'CL' => 'Chile',
            'CM' => 'Cameroon',
            'CN' => 'China',
            'CO' => 'Colombia',
            'CR' => 'Costa Rica',
            'CS' => 'Czechoslovakia (former)',   // Not listed anymore
            'CU' => 'Cuba',
            'CV' => 'Cape Verde',
            'CX' => 'Christmas Island',
            'CY' => 'Cyprus',
            'CZ' => 'Czech Republic',
            'DE' => 'Germany',
            'DJ' => 'Djibouti',
            'DK' => 'Denmark',
            'DM' => 'Dominica',
            'DO' => 'Dominican Republic',
            'DZ' => 'Algeria',
            'EC' => 'Ecuador',
            'EE' => 'Estonia',
            'EG' => 'Egypt',
            'EH' => 'Western Sahara',
            'ER' => 'Eritrea',
            'ES' => 'Spain',
            'EU' => 'Europe',
            'ET' => 'Ethiopia',
            'FI' => 'Finland',
            'FJ' => 'Fiji',
            'FK' => 'Falkland Islands (Malvinas)',
            'FM' => 'Micronesia',
            'FO' => 'Faroe Islands',
            'FR' => 'France',
            'FX' => 'France, Metropolitan',   // Not listed anymore
            'GA' => 'Gabon',
            'GB' => 'Great Britain',     // Name was: Great Britain (UK)
            'GD' => 'Grenada',
            'GE' => 'Georgia',
            'GF' => 'French Guiana',
            'GG' => 'Guernsey',   // Added
            'GH' => 'Ghana',
            'GI' => 'Gibraltar',
            'GL' => 'Greenland',
            'GM' => 'Gambia',
            'GN' => 'Guinea',
            'GP' => 'Guadeloupe',
            'GQ' => 'Equatorial Guinea',
            'GR' => 'Greece',
            'GS' => 'S. Georgia and S. Sandwich Isls.',
            'GT' => 'Guatemala',
            'GU' => 'Guam',
            'GW' => 'Guinea-Bissau',
            'GY' => 'Guyana',
            'HK' => 'Hong Kong',
            'HM' => 'Heard and McDonald Islands',
            'HN' => 'Honduras',
            'HR' => 'Croatia',
            'HT' => 'Haiti',
            'HU' => 'Hungary',
            'ID' => 'Indonesia',
            'IE' => 'Ireland',
            'IL' => 'Israel',
            'IM' => 'Isle of Man',    //  Added
            'IN' => 'India',
            'IO' => 'British Indian Ocean Territory',
            'IQ' => 'Iraq',
            'IR' => 'Iran',   //  Changed name
            'IS' => 'Iceland',
            'IT' => 'Italy',
            'JE' => 'Jersey',
            'JM' => 'Jamaica',
            'JO' => 'Jordan',
            'JP' => 'Japan',
            'KE' => 'Kenya',
            'KG' => 'Kyrgyzstan',
            'KH' => 'Cambodia',
            'KI' => 'Kiribati',
            'KM' => 'Comoros',
            'KN' => 'Saint Kitts and Nevis',
            'KP' => 'Korea (North)',    // Official name: Korea, Democratic People's Republic of
            'KR' => 'Korea (South)',    // Official name: Korea, Republic of
            'KW' => 'Kuwait',
            'KY' => 'Cayman Islands',
            'KZ' => 'Kazakhstan',
            'LA' => 'Laos',             // Official name: Lao People's Democratic Republic
            'LB' => 'Lebanon',
            'LC' => 'Saint Lucia',
            'LI' => 'Liechtenstein',
            'LK' => 'Sri Lanka',
            'LR' => 'Liberia',
            'LS' => 'Lesotho',
            'LT' => 'Lithuania',
            'LU' => 'Luxembourg',
            'LV' => 'Latvia',
            'LY' => 'Libya',            // Official name: Libyan Arab Jamahiriya
            'MA' => 'Morocco',
            'MC' => 'Monaco',
            'MD' => 'Moldova',          // Official name: Moldova, Republic of
            'ME' => 'Montenegro',       // Added
            'MF' => 'Saint Martin',     // Added
            'MG' => 'Madagascar',
            'MH' => 'Marshall Islands',
            'MK' => 'Macedonia',        // Official name: Macedonia, The Former Yugoslav Republic of
            'ML' => 'Mali',
            'MM' => 'Myanmar',
            'MN' => 'Mongolia',
            'MO' => 'Macao',            // Corrected name
            'MP' => 'Northern Mariana Islands',
            'MQ' => 'Martinique',
            'MR' => 'Mauritania',
            'MS' => 'Montserrat',
            'MT' => 'Malta',
            'MU' => 'Mauritius',
            'MV' => 'Maldives',
            'MW' => 'Malawi',
            'MX' => 'Mexico',
            'MY' => 'Malaysia',
            'MZ' => 'Mozambique',
            'NA' => 'Namibia',
            'NC' => 'New Caledonia',
            'NE' => 'Niger',
            'NF' => 'Norfolk Island',
            'NG' => 'Nigeria',
            'NI' => 'Nicaragua',
            'NL' => 'Netherlands',
            'NO' => 'Norway',
            'NP' => 'Nepal',
            'NR' => 'Nauru',
            'NT' => 'Neutral Zone',
            'NU' => 'Niue',
            'NZ' => 'New Zealand',
            'OM' => 'Oman',
            'PA' => 'Panama',
            'PE' => 'Peru',
            'PF' => 'French Polynesia',
            'PG' => 'Papua New Guinea',
            'PH' => 'Philippines',
            'PK' => 'Pakistan',
            'PL' => 'Poland',
            'PM' => 'St. Pierre and Miquelon',
            'PN' => 'Pitcairn',
            'PR' => 'Puerto Rico',
            'PS' => 'Palestinian Territory, Occupied',   // Added
            'PT' => 'Portugal',
            'PW' => 'Palau',
            'PY' => 'Paraguay',
            'QA' => 'Qatar',
            'RE' => 'Reunion',
            'RO' => 'Romania',
            'RS' => 'Serbia',     // Added
            'RU' => 'Russian Federation',
            'RW' => 'Rwanda',
            'SA' => 'Saudi Arabia',
            'SB' => 'Solomon Islands',
            'SC' => 'Seychelles',
            'SD' => 'Sudan',
            'SE' => 'Sweden',
            'SG' => 'Singapore',
            'SH' => 'St. Helena',
            'SI' => 'Slovenia',
            'SJ' => 'Svalbard and Jan Mayen Islands',
            'SK' => 'Slovakia',              // Changed name, was: Slovak Republic
            'SL' => 'Sierra Leone',
            'SM' => 'San Marino',
            'SN' => 'Senegal',
            'SO' => 'Somalia',
            'SR' => 'Suriname',
            'ST' => 'Sao Tome and Principe',
            'SU' => 'USSR (former)',          // Removed from ISO list, doesn' exsist anymore
            'SV' => 'El Salvador',
            'SY' => 'Syrian Arab Republic',   // Changed name, was: Syria
            'SZ' => 'Swaziland',
            'TC' => 'Turks and Caicos Islands',
            'TD' => 'Chad',
            'TF' => 'French Southern Territories',
            'TG' => 'Togo',
            'TH' => 'Thailand',
            'TJ' => 'Tajikistan',
            'TK' => 'Tokelau',
            'TL' => 'Timor-Leste',    // Added
            'TM' => 'Turkmenistan',
            'TN' => 'Tunisia',
            'TO' => 'Tonga',
            'TP' => 'East Timor',             // Removed from ISO list, doesn' exsist anymore
            'TR' => 'Turkey',
            'TT' => 'Trinidad and Tobago',
            'TV' => 'Tuvalu',
            'TW' => 'Taiwan',         // Official name acc. to iso-list: Taiwan, Province of China
            'TZ' => 'Tanzania',
            'UA' => 'Ukraine',
            'UG' => 'Uganda',
            'UK' => 'United Kingdom',      // Doesn't exsist in iso-list ?
            'UM' => 'US Minor Outlying Islands',
            'US' => 'United States',
            'UY' => 'Uruguay',
            'UZ' => 'Uzbekistan',
            'VA' => 'Vatican City State',
            'VC' => 'Saint Vincent and the Grenadines',
            'VE' => 'Venezuela',
            'VG' => 'Virgin Islands, British',
            'VI' => 'Virgin Islands, U.S.',
            'VN' => 'Viet Nam',
            'VU' => 'Vanuatu',
            'WF' => 'Wallis and Futuna Islands',
            'WS' => 'Samoa',
            'YE' => 'Yemen',
            'YT' => 'Mayotte',
            'YU' => 'Yugoslavia',        // Removed from iso list
            'ZA' => 'South Africa',
            'ZM' => 'Zambia',
            'ZR' => 'Zaire',             // Removed from iso list
            'ZW' => 'Zimbabwe',
        ];

        return $country_array[$countryn];
    }

    /**
     * @param $document
     *
     * @return mixed
     */
    public static function convertHtml2text($document)
    {
        $search = [
            "'<script[^>]*?>.*?</script>'si", // Strip out javascript
            "'<img.*?>'si", // Strip out img tags
            "'<[\/\!]*?[^<>]*?>'si", // Strip out HTML tags
            "'([\r\n])[\s]+'", // Strip out white space
            "'&(quot|#34);'i", // Replace HTML entities
            "'&(amp|#38);'i",
            "'&(lt|#60);'i",
            "'&(gt|#62);'i",
            "'&(nbsp|#160);'i",
            "'&(iexcl|#161);'i",
            "'&(cent|#162);'i",
            "'&(pound|#163);'i",
            "'&(copy|#169);'i",
        ]; // evaluate as php

        $replace = [
            '',
            '',
            '',
            '\\1',
            '"',
            '&',
            '<',
            '>',
            ' ',
            \chr(161),
            \chr(162),
            \chr(163),
            \chr(169),
        ];

        $text = \preg_replace($search, $replace, $document);

        \preg_replace_callback(
            '/&#(\d+);/',
            static function ($matches) {
                return \chr($matches[1]);
            },
            $document
        );

        return $text;
    }

    //    Start functions for Google PageRank
    //    Source: http://www.sws-tech.com/scripts/googlepagerank.php
    //    This code is released under the public domain

    /**
     * @param $a
     * @param $b
     *
     * @return float|int
     */
    public static function fillZeroes($a, $b)
    {
        $z = \hexdec(80000000);
        //echo $z;
        if ($z & $a) {
            $a >>= 1;
            $a &= (~$z);
            $a |= 0x40000000;
            $a >>= ($b - 1);
        } else {
            $a >>= $b;
        }

        return $a;
    }

    /**
     * @param $a
     * @param $b
     * @param $c
     *
     * @return array
     */
    public static function mix($a, $b, $c)
    {
        $a -= $b;
        $a -= $c;
        $a ^= static::fillZeroes($c, 13);
        $b -= $c;
        $b -= $a;
        $b ^= ($a << 8);
        $c -= $a;
        $c -= $b;
        $c ^= static::fillZeroes($b, 13);
        $a -= $b;
        $a -= $c;
        $a ^= static::fillZeroes($c, 12);
        $b -= $c;
        $b -= $a;
        $b ^= ($a << 16);
        $c -= $a;
        $c -= $b;
        $c ^= static::fillZeroes($b, 5);
        $a -= $b;
        $a -= $c;
        $a ^= static::fillZeroes($c, 3);
        $b -= $c;
        $b -= $a;
        $b ^= ($a << 10);
        $c -= $a;
        $c -= $b;
        $c ^= static::fillZeroes($b, 15);

        return [$a, $b, $c];
    }

    /**
     * @param array|null $url
     * @param null       $length

Are you sure the doc-type for parameter $length is correct as it would always require null to be passed?

     * @param int        $init
     *
     * @return mixed
     */
    public static function googleCh($url, $length = null, $init = 0xE6359A60)
    {
        if (null === $length) {
            $length = \count($url);
        }
        $a   = $b = 0x9E3779B9;
        $c   = $init;
        $k   = 0;
        $len = $length;
        while ($len >= 12) {
            $a   += ($url[$k + 0] + ($url[$k + 1] << 8) + ($url[$k + 2] << 16) + ($url[$k + 3] << 24));
            $b   += ($url[$k + 4] + ($url[$k + 5] << 8) + ($url[$k + 6] << 16) + ($url[$k + 7] << 24));
            $c   += ($url[$k + 8] + ($url[$k + 9] << 8) + ($url[$k + 10] << 16) + ($url[$k + 11] << 24));
            $mix = static::mix($a, $b, $c);
            $a   = $mix[0];
            $b   = $mix[1];
            $c   = $mix[2];
            $k   += 12;
            $len -= 12;
        }
        $c += $length;
        switch ($len) {              /* all the case statements fall through */ case 11:
            $c += ($url[$k + 10] << 24);
            // no break
            case 10:
                $c += ($url[$k + 9] << 16);
            // no break
            case 9:
                $c += ($url[$k + 8] << 8);
            /* the first byte of c is reserved for the length */ // no break
            case 8:
                $b += ($url[$k + 7] << 24);
            // no break
            case 7:
                $b += ($url[$k + 6] << 16);
            // no break
            case 6:
                $b += ($url[$k + 5] << 8);
            // no break
            case 5:
                $b += $url[$k + 4];
            // no break
            case 4:
                $a += ($url[$k + 3] << 24);
            // no break
            case 3:
                $a += ($url[$k + 2] << 16);
            // no break
            case 2:
                $a += ($url[$k + 1] << 8);
            // no break
            case 1:
                $a += $url[$k + 0];
            /* case 0: nothing left to add */
        }
        $mix = static::mix($a, $b, $c);
        //echo $mix[0];
        /*-------------------------------------------- report the result */

        return $mix[2];
    }

    //converts a string into an array of integers containing the numeric value of the char

    /**
     * @param $string
     *
     * @return mixed
     */
    public static function strord($string)
    {
        $iMax = mb_strlen($string);
        for ($i = 0; $i < $iMax; ++$i) {
            $result[$i] = \ord($string[$i]);
        }

        return $result;

The variable $result does not seem to be defined for all execution paths leading up to this point.

    }

    /**
     * @param $url
     *
     * @return bool|string
     */
    public static function pagerank($url)
    {
        $pagerank = '';
        $ch       = '6' . static::googleCh(static::strord('info:' . $url));
        $fp       = \fsockopen('www.google.com', 80, $errno, $errstr, 30);
        if ($fp) {
            $out = 'GET /search?client=navclient-auto&ch=' . $ch . '&features=Rank&q=info:' . $url . " HTTP/1.1\r\n";
            $out .= "Host: www.google.com\r\n";
            $out .= "Connection: Close\r\n\r\n";

            \fwrite($fp, $out);

            while (!\feof($fp)) {
                $data = \fgets($fp, 128);
                $pos  = mb_strpos($data, 'Rank_');
                if (false !== $pos) {
                    $pagerank = mb_substr($data, $pos + 9);
                } else {
                }
            }
            \fclose($fp);
        } else {
            echo "$errstr ($errno)<br>\n";
        }

        return $pagerank;
    }

    //  End functions for Google PageRank

    // Check if Tag module is installed

    /**
     * @return bool
     */
    public static function isTagModuleIncluded()
    {
        static $wfl_tag_module_included;
        if (!isset($wfl_tag_module_included)) {
            /** @var \XoopsModuleHandler $moduleHandler */
            $modulesHandler = \xoops_getHandler('module');
            $tag_mod        = $modulesHandler->getByDirname('tag');
            if ($tag_mod) {
                $wfl_tag_module_included = 1 == $tag_mod->getVar('isactive');
            } else {
                $tag_mod = false;

The assignment to $tag_mod is dead and can be removed.

            }
        }

        return $wfl_tag_module_included;
    }

    // Add item_tag to Tag-module

    /**
     * @param $lid
     * @param $item_tag
     */
    public static function updateTag($lid, $item_tag)
    {
        global $xoopsModule;
        if (static::isTagModuleIncluded()) {
            require_once XOOPS_ROOT_PATH . '/modules/tag/include/formtag.php';
            $tagHandler = \XoopsModules\Tag\Helper::getInstance()->getHandler('Tag'); // xoops_getModuleHandler('tag', 'tag');
            $tagHandler->updateByItem($item_tag, $lid, $xoopsModule->getVar('dirname'), 0);
        }
    }

    // Check if News module is installed

    /**
     * @return bool
     */
    public static function isNewsModuleIncluded()
    {
        static $wfl_news_module_included;
        if (!isset($wfl_news_module_included)) {
            $modulesHandler = \xoops_getHandler('module');
            $news_mod       = $modulesHandler->getByDirname('news');
            if ($news_mod) {
                $wfl_news_module_included = 1 == $news_mod->getVar('isactive');
            } else {
                $news_mod = false;

The assignment to $news_mod is dead and can be removed.

            }
        }

        return $wfl_news_module_included;
    }

    /**
     * @param $banner_id
     *
     * @return null|string
     */
    public static function getBannerFromIdBanner($banner_id)
    {
        ###### Hack by www.stefanosilvestrini.com ######
        global $xoopsConfig;
        $db      = \XoopsDatabaseFactory::getDatabaseConnection();
        $bresult = $db->query('SELECT COUNT(*) FROM ' . $db->prefix('banner') . ' WHERE bid=' . $banner_id);
        list($numrows) = $db->fetchRow($bresult);
        if ($numrows > 1) {
            --$numrows;
            $bannum = \mt_rand(0, $numrows);
        } else {
            $bannum = 0;
        }
        if ($numrows > 0) {
            $bresult = $db->query('SELECT * FROM ' . $db->prefix('banner') . ' WHERE bid=' . $banner_id, 1, $bannum);
            list($bid, $cid, $imptotal, $impmade, $clicks, $imageurl, $clickurl, $date, $htmlbanner, $htmlcode) = $db->fetchRow($bresult);
            if ($xoopsConfig['my_ip'] == \xoops_getenv('REMOTE_ADDR')) {
                // EMPTY
            } else {
                $db->queryF(\sprintf('UPDATE `%s` SET impmade = impmade+1 WHERE bid = %u', $db->prefix('banner'), $bid));
            }
            /* Check if this impression is the last one and print the banner */
            if ($imptotal == $impmade) {
                $newid = $db->genId($db->prefix('bannerfinish') . '_bid_seq');
                $sql   = \sprintf('INSERT INTO `%s` (bid, cid, impressions, clicks, datestart, dateend) VALUES (%u, %u, %u, %u, %u, %u)', $db->prefix('bannerfinish'), $newid, $cid, $impmade, $clicks, $date, \time());
                $db->queryF($sql);
                $db->queryF(\sprintf('DELETE FROM `%s` WHERE bid = %u', $db->prefix('banner'), $bid));
            }
            if ($htmlbanner) {
                $bannerobject = $htmlcode;
            } else {
                $bannerobject = '<div align="center"><a href="' . XOOPS_URL . '/banners.php?op=click&bid=' . $bid . '" target="_blank">';
                if (false !== mb_stripos($imageurl, '.swf')) {
                    $bannerobject = $bannerobject
                                    . '<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,40,0" width="468" height="60">'
                                    . '<param name="movie" value="'
                                    . $imageurl
                                    . '"></param>'
                                    . '<param name="quality" value="high"></param>'
                                    . '<embed src="'
                                    . $imageurl
                                    . '" quality="high" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="468" height="60">'
                                    . '</embed>'
                                    . '</object>';
                } else {
                    $bannerobject = $bannerobject . '<img src="' . $imageurl . '" alt="">';
                }
                $bannerobject .= '</a></div>';
            }

            return $bannerobject;
        }

        return null;
    }

    /**
     * @param $client_id
     *
     * @return string
     */
    public static function getBannerFromIdClient($client_id)
    {
        ###### Hack by www.stefanosilvestrini.com ######
        global $xoopsConfig;
        $db      = \XoopsDatabaseFactory::getDatabaseConnection();
        $bresult = $db->query('SELECT COUNT(*) FROM ' . $db->prefix('banner') . ' WHERE cid=' . $client_id);
        list($numrows) = $db->fetchRow($bresult);
        if ($numrows > 1) {
            --$numrows;
            $bannum = \mt_rand(0, $numrows);
        } else {
            $bannum = 0;
        }
        if ($numrows > 0) {
            $bresult = $db->query('SELECT * FROM ' . $db->prefix('banner') . ' WHERE cid=' . $client_id . ' ORDER BY rand()', 1, $bannum);
            list($bid, $cid, $imptotal, $impmade, $clicks, $imageurl, $clickurl, $date, $htmlbanner, $htmlcode) = $db->fetchRow($bresult);
            if ($xoopsConfig['my_ip'] == \xoops_getenv('REMOTE_ADDR')) {
                // EMPTY
            } else {
                $db->queryF(\sprintf('UPDATE `%s` SET impmade = impmade+1 WHERE bid = %u', $db->prefix('banner'), $bid));
            }
            /* Check if this impression is the last one and print the banner */
            if ($imptotal == $impmade) {
                $newid = $db->genId($db->prefix('bannerfinish') . '_bid_seq');
                $sql   = \sprintf('INSERT INTO `%s` (bid, cid, impressions, clicks, datestart, dateend) VALUES (%u, %u, %u, %u, %u, %u)', $db->prefix('bannerfinish'), $newid, $cid, $impmade, $clicks, $date, \time());
                $db->queryF($sql);
                $db->queryF(\sprintf('DELETE FROM `%s` WHERE bid = %u', $db->prefix('banner'), $bid));
            }
            if ($htmlbanner) {
                $bannerobject = $htmlcode;
            } else {
                $bannerobject = '<div align="center"><a href="' . XOOPS_URL . '/banners.php?op=click&bid=' . $bid . '" target="_blank">';
                if (false !== mb_stripos($imageurl, '.swf')) {
                    $bannerobject = $bannerobject
                                    . '<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,40,0" width="468" height="60">'
                                    . '<param name="movie" value="'
                                    . $imageurl
                                    . '"></param>'
                                    . '<param name="quality" value="high"></param>'
                                    . '<embed src="'
                                    . $imageurl
                                    . '" quality="high" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="468" height="60">'
                                    . '</embed>'
                                    . '</object>';
                } else {
                    $bannerobject = $bannerobject . '<img src="' . $imageurl . '" alt="">';
                }
                $bannerobject .= '</a></div>';
            }

            return $bannerobject;
        }

        return null;
    }

    /**
     * @param $email
     *
     * @return mixed
     */
    public static function convertEmail($email)
    {
        $search = [
            "/\@/",
            "/\./",
            "/\mailto:/",
        ];

        $replace = [
            ' AT ',
            ' DOT ',
            '',
        ];

        $text = \preg_replace($search, $replace, $email);

        return $text;
    }

    /**
     * @param $email
     *
     * @return mixed
     */
    public static function printemailcnvrt($email)
    {
        $search = [
            "/\ AT /",
            "/\ DOT /",
        ];

        $replace = [
            '@',
            '.',
        ];

        $text = \preg_replace($search, $replace, $email);

        return $text;
    }

    /**
     * @param        $str
     * @param        $start
     * @param        $length
     * @param string $trimmarker
     *
     * @return string
     */
    public static function getSubstring($str, $start, $length, $trimmarker = '...')
    {
        $configHandler          = \xoops_getHandler('config');
        $im_multilanguageConfig = $configHandler->getConfigsByCat(IM_CONF_MULILANGUAGE);

        if ($im_multilanguageConfig['ml_enable']) {
            $tags  = \explode(',', $im_multilanguageConfig['ml_tags']);
            $strs  = [];
            $hasML = false;
            foreach ($tags as $tag) {
                if (\preg_match("/\[" . $tag . "](.*)\[\/" . $tag . "\]/sU", $str, $matches)) {
                    if (\count($matches) > 0) {
                        $hasML  = true;
                        $strs[] = $matches[1];
                    }
                }
            }
        } else {
            $hasML = false;
        }

        if (!$hasML) {
            $strs = [$str];
        }

        for ($i = 0; $i <= \count($strs) - 1; ++$i) {

The variable $strs does not seem to be defined for all execution paths leading up to this point.

            if (!XOOPS_USE_MULTIBYTES) {
                $strs[$i] = (mb_strlen($strs[$i]) - $start <= $length) ? mb_substr($strs[$i], $start, $length) : mb_substr($strs[$i], $start, $length - mb_strlen($trimmarker)) . $trimmarker;
            }

            if (\function_exists('mb_internal_encoding') && @mb_internal_encoding(_CHARSET)) {
                $str2     = mb_strcut($strs[$i], $start, $length - mb_strlen($trimmarker));
                $strs[$i] = $str2 . (mb_strlen($strs[$i]) != mb_strlen($str2) ? $trimmarker : '');
            }

            // phppp patch
            $DEP_CHAR = 127;

The assignment to $DEP_CHAR is dead and can be removed.

            $pos_st   = 0;
            $action   = false;
            for ($pos_i = 0, $pos_iMax = mb_strlen($strs[$i]); $pos_i < $pos_iMax; ++$pos_i) {
                if (\ord(mb_substr($strs[$i], $pos_i, 1)) > 127) {
                    ++$pos_i;
                }
                if ($pos_i <= $start) {
                    $pos_st = $pos_i;
                }
                if ($pos_i >= $pos_st + $length) {
                    $action = true;
                    break;
                }
            }
            $strs[$i] = $action ? mb_substr($strs[$i], $pos_st, $pos_i - $pos_st - mb_strlen($trimmarker)) . $trimmarker : $strs[$i];

            $strs[$i] = $hasML ? '[' . $tags[$i] . ']' . $strs[$i] . '[/' . $tags[$i] . ']' : $strs[$i];

The variable $tags does not seem to be defined for all execution paths leading up to this point.

        }
        $str = \implode('', $strs);

        return $str;
    }

    // Reusable Link Sorting Functions
    // convertOrderByIn()
    // @param  $orderby
    // @return

    /**
     * @param $orderby
     *
     * @return string
     */
    public static function convertOrderByIn($orderby)
    {
        switch (\trim($orderby)) {
            case 'titleA':
                $orderby = 'title ASC';
                break;
            case 'dateA':
                $orderby = 'published ASC';
                break;
            case 'hitsA':
                $orderby = 'hits ASC';
                break;
            case 'ratingA':
                $orderby = 'rating ASC';
                break;
            case 'countryA':
                $orderby = 'country ASC';
                break;
            case 'titleD':
                $orderby = 'title DESC';
                break;
            case 'hitsD':
                $orderby = 'hits DESC';
                break;
            case 'ratingD':
                $orderby = 'rating DESC';
                break;
            case'dateD':
                $orderby = 'published DESC';
                break;
            case 'countryD':
                $orderby = 'country DESC';
                break;
        }

        return $orderby;
    }

    /**
     * @param $orderby
     *
     * @return string
     */
    public static function convertOrderByTrans($orderby)
    {
        if ('hits ASC' === $orderby) {
            $orderbyTrans = _MD_WFL_POPULARITYLTOM;
        }
        if ('hits DESC' === $orderby) {
            $orderbyTrans = _MD_WFL_POPULARITYMTOL;
        }
        if ('title ASC' === $orderby) {
            $orderbyTrans = _MD_WFL_TITLEATOZ;
        }
        if ('title DESC' === $orderby) {
            $orderbyTrans = _MD_WFL_TITLEZTOA;
        }
        if ('published ASC' === $orderby) {
            $orderbyTrans = _MD_WFL_DATEOLD;
        }
        if ('published DESC' === $orderby) {
            $orderbyTrans = _MD_WFL_DATENEW;
        }
        if ('rating ASC' === $orderby) {
            $orderbyTrans = _MD_WFL_RATINGLTOH;
        }
        if ('rating DESC' === $orderby) {
            $orderbyTrans = _MD_WFL_RATINGHTOL;
        }
        if ('country ASC' === $orderby) {
            $orderbyTrans = _MD_WFL_COUNTRYLTOH;
        }
        if ('country DESC' === $orderby) {
            $orderbyTrans = _MD_WFL_COUNTRYHTOL;
        }

        return $orderbyTrans;

The variable $orderbyTrans does not seem to be defined for all execution paths leading up to this point.

    }

    /**
     * @param $orderby
     *
     * @return string
     */
    public static function convertOrderByOut($orderby)
    {
        if ('title ASC' === $orderby) {
            $orderby = 'titleA';
        }
        if ('published ASC' === $orderby) {
            $orderby = 'dateA';
        }
        if ('hits ASC' === $orderby) {
            $orderby = 'hitsA';
        }
        if ('rating ASC' === $orderby) {
            $orderby = 'ratingA';
        }
        if ('country ASC' === $orderby) {
            $orderby = 'countryA';
        }
        if ('weight ASC' === $orderby) {
            $orderby = 'weightA';
        }
        if ('title DESC' === $orderby) {
            $orderby = 'titleD';
        }
        if ('published DESC' === $orderby) {
            $orderby = 'dateD';
        }
        if ('hits DESC' === $orderby) {
            $orderby = 'hitsD';
        }
        if ('rating DESC' === $orderby) {
            $orderby = 'ratingD';
        }
        if ('country DESC' === $orderby) {
            $orderby = 'countryD';
        }

        return $orderby;
    }
}