blocks/blocks.php ➔ b_gwiki_linkshere_show()

Complexity

Conditions	11
Paths	514

Size

Total Lines	78
Code Lines	52

Duplication

Lines	15
Ratio	19.23 %

Importance

Changes

0

<?php
function b_gwiki_linkshere_show($options)
{
    global $xoTheme, $xoopsDB;

    $block = false;

    $dir = basename(dirname(__DIR__));
    include_once XOOPS_ROOT_PATH . '/modules/' . $dir . '/class/GwikiPage.php';
    $wikiPage = new GwikiPage;

    if (isset($_GET['page'])) {
        $page = $_GET['page'];
        $page   = html_entity_decode($page);
        $page   = trim($page);
        $page   = $wikiPage->getOOBFromKeyword($page);
        $q_page = $wikiPage->escapeForDB($page);

$q_page is not used, you could remove the assignment.

    }

    if (empty($page)) {
        return false;
    }

    $limit = (int)$options[0];
    if ($limit < 0) {
        $limit = 0;
    }

    $sort = (int)$options[1];
    if ($sort < 0) {
        $sort = 0;
    }
    if ($sort > 2) {
        $sort = 2;
    }

    $relatedsort = ' display_keyword, ';
    if ($sort === 1) {
        $relatedsort = ' lastmodified DESC, hit_count DESC, ';
    }
    if ($sort === 2) {
        $relatedsort = ' hit_count DESC, lastmodified DESC, ';
    }

    $q_page = $wikiPage->escapeForDB($page);

    $sql = 'SELECT keyword, display_keyword, title, lastmodified, uid, page_id, created, hit_count ';
    $sql .= ' FROM ' . $xoopsDB->prefix('gwiki_pages');
    $sql .= ' natural left join ' . $xoopsDB->prefix('gwiki_pageids');
    $sql .= ' left join ' . $xoopsDB->prefix('gwiki_pagelinks') . ' on from_keyword = keyword ';
    $sql .= " WHERE active=1 and to_keyword = '{$q_page}' ";
    $sql .= " ORDER BY {$relatedsort} keyword ";

    $linkshere = false;
    if ($limit) {
        $result = $xoopsDB->query($sql, $limit, 0);
    } else {
        $result = $xoopsDB->query($sql);
    }
    while ($row = $xoopsDB->fetchArray($result)) {

This code seems to be duplicated across your project.

        $row['pageurl']  = sprintf($wikiPage->getWikiLinkURL(), $row['keyword']);
        $row['pagelink'] = sprintf('<a href="%s" title="%s">%s</a>', $row['pageurl'], htmlspecialchars($row['title'], ENT_COMPAT), $row['title']);
        $linkshere[]     = $row;
    }
    $xoopsDB->freeRecordSet($result);

    if ($linkshere) {

This code seems to be duplicated across your project.

        $block['linkshere'] = $linkshere;

        $xoTheme->addStylesheet(XOOPS_URL . '/modules/' . $dir . '/assets/css/module.css');

        $block['keyword'] = $page;
        $block['moddir']  = $dir;
        $block['modpath'] = XOOPS_ROOT_PATH . '/modules/' . $dir;
        $block['modurl']  = XOOPS_URL . '/modules/' . $dir;
    }

    return $block;
}