blocks/blocks.php ➔ b_gwiki_related_show()

Complexity

Conditions	12
Paths	325

Size

Total Lines	93
Code Lines	61

Duplication

Lines	15
Ratio	16.13 %

Importance

Changes	6
Bugs	1	Features	2

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

    $block = false;

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

    $q_exclude_page = '';

    if (empty($options[1])) {
        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_exclude_page = $wikiPage->escapeForDB($page);

            $sql = 'SELECT parent_page ';
            $sql .= ' FROM ' . $xoopsDB->prefix('gwiki_pages');
            $sql .= " WHERE active=1 and keyword='{$q_page}' ";

            $result = $xoopsDB->query($sql);

            $rows = $xoopsDB->getRowsNum($result);
            if ($rows) {
                $row = $xoopsDB->fetchArray($result);
                if (!empty($row['parent_page'])) {
                    $page = $row['parent_page'];
                }
            }
            $xoopsDB->freeRecordSet($result);
        }
    } else {
        $page = $options[1];
    }

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

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

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

    $relatedsort = ' lastmodified DESC, hit_count DESC, ';
    if ($sort === 1) {
        $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 .= " WHERE active=1 and parent_page = '{$q_page}' and keyword!='{$q_exclude_page}' ";
    $sql .= " ORDER BY {$relatedsort} keyword ";

    $related = false;
    $result  = $xoopsDB->query($sql, $limit, 0);
    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']);
        $related[]       = $row;
    }
    $xoopsDB->freeRecordSet($result);

    if ($related) {

This code seems to be duplicated across your project.

        $block['related'] = $related;

        $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;
}