b_lxentries_new_show()

Complexity

Conditions	12
Paths	1024

Size

Total Lines	50
Code Lines	34

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
function b_lxentries_new_show($options)
{
    global $xoopsDB, $xoopsUser;

    $myts = MyTextSanitizer:: getInstance();

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

    /** @var \XoopsModuleHandler $moduleHandler */
    $moduleHandler = xoops_getHandler('module');
    $lexikon       = $moduleHandler->getByDirname('lexikon');
    if (!isset($lxConfig)) {

The variable $lxConfig seems to never exist and therefore isset should always be false.

        /** @var \XoopsConfigHandler $configHandler */
        $configHandler = xoops_getHandler('config');
        $lxConfig      = $configHandler->getConfigsByCat(0, $lexikon->getVar('mid'));
    }
    $groups = is_object($xoopsUser) ? $xoopsUser->getGroups() : XOOPS_GROUP_ANONYMOUS;
    /** @var \XoopsGroupPermHandler $grouppermHandler */
    $grouppermHandler = xoops_getHandler('groupperm');
    $module_id        = $lexikon->getVar('mid');
    $allowed_cats     = $grouppermHandler->getItemIds('lexikon_view', $groups, $module_id);
    $catids           = implode(',', $allowed_cats);
    $catperms         = " AND categoryID IN ($catids) ";

    $words      = $xoopsDB->query('SELECT entryID FROM ' . $xoopsDB->prefix('lxentries') . " WHERE offline = '0' AND submit='0' AND request='0' AND block = '1' ");
    $totalwords = $xoopsDB->getRowsNum($words);

    $block              = [];
    $block['marquee']   = (1 == $options[2]) ? 1 : 0;
    $block['alternate'] = (1 == $options[3]) ? 1 : 0;
    $block['showdate']  = (1 == $options[4]) ? 1 : 0;
    $block['direction'] = $options[5];
    $block['speed']     = isset($options[6]) && '' != $options[6] ? $options[6] : '2';
    $block['bgcolor']   = isset($options[7]) && '' != $options[7] ? $options[7] : '#FFFFFF';

    $sql    = 'SELECT entryID, categoryID, term, datesub FROM ' . $xoopsDB->prefix('lxentries') . ' WHERE datesub < ' . time() . " AND datesub > 0 AND offline = '0' " . $catperms . ' ORDER BY ' . $options[0] . ' DESC';
    $result = $xoopsDB->query($sql, $options[1], 0);

    if ($totalwords > 0) { // If there are definitions
        while (list($entryID, $categoryID, $term, $datesub) = $xoopsDB->fetchRow($result)) {
            $newentries             = [];
            $linktext               = ucfirst(htmlspecialchars($term, ENT_QUOTES | ENT_HTML5));
            $newentries['dir']      = $lexikon->dirname();
            $newentries['linktext'] = $linktext;
            $newentries['id']       = (int)$entryID;
            $newentries['date']     = formatTimestamp($datesub, $lxConfig['dateformat']);

            $block['newstuff'][] = $newentries;
        }
    }

    return $block;
}