b_sitemap_oledrion()

Complexity

Conditions	8
Paths	10

Size

Total Lines	61
Code Lines	43

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
function b_sitemap_oledrion()
{
    require_once dirname(__DIR__) . '/oledrion/header.php';
    global $sitemap_configs;
    $xoopsDB    = \XoopsDatabaseFactory::getDatabaseConnection();
    $table      = $xoopsDB->prefix('oledrion_cat');
    $id_name    = 'cat_cid';
    $pid_name   = 'cat_pid';
    $title_name = 'cat_title';
    $url        = 'category.php?cat_cid=';
    $order      = 'cat_title';

    require_once XOOPS_ROOT_PATH . '/class/xoopstree.php';
    $mytree  = new \XoopsTree($table, $id_name, $pid_name);
    $xoopsDB = \XoopsDatabaseFactory::getDatabaseConnection();

    $sitemap = [];
    $myts    = \MyTextSanitizer::getInstance();

    $i   = 0;
    $sql = "SELECT `$id_name`,`$title_name` FROM `$table` WHERE `$pid_name`=0";
    if ('' !== $order) {

The condition '' !== $order is always true.

        $sql .= " ORDER BY `$order`";
    }
    $result = $xoopsDB->query($sql);
    while (list($catid, $name) = $xoopsDB->fetchRow($result)) {
        $sitemap['parent'][$i]['id']    = $catid;
        $sitemap['parent'][$i]['title'] = $myts->htmlSpecialChars($name);
        if (1 == Oledrion\Utility::getModuleOption('urlrewriting')) {
            // On utilise l'url rewriting
            $url = 'category' . '-' . (int)$catid . Oledrion\Utility::makeSeoUrl($name) . '.html';
        } else {
            // Pas d'utilisation de l'url rewriting
            $url = 'category.php?cat_cid=' . (int)$catid;
        }
        $sitemap['parent'][$i]['url'] = $url;

        if (@$sitemap_configs['show_subcategoris']) {
            $j         = 0;
            $child_ary = $mytree->getChildTreeArray($catid, $order);
            foreach ($child_ary as $child) {
                $count                                       = mb_strlen($child['prefix']) + 1;
                $sitemap['parent'][$i]['child'][$j]['id']    = $child[$id_name];
                $sitemap['parent'][$i]['child'][$j]['title'] = $myts->htmlSpecialChars($child[$title_name]);
                $sitemap['parent'][$i]['child'][$j]['image'] = (($count > 3) ? 4 : $count);
                if (1 == Oledrion\Utility::getModuleOption('urlrewriting')) {
                    // On utilise l'url rewriting
                    $url = 'category' . '-' . (int)$child[$id_name] . Oledrion\Utility::makeSeoUrl($child[$title_name]) . '.html';
                } else {
                    // Pas d'utilisation de l'url rewriting
                    $url = 'category.php?cat_cid=' . (int)$child[$id_name];
                }
                $sitemap['parent'][$i]['child'][$j]['url'] = $url;

                ++$j;
            }
        }
        ++$i;
    }

    return $sitemap;
}