mambax7 / newbb

rss.php

<?php declare(strict_types=1);

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

/**
 * @copyright    XOOPS Project (https://xoops.org)/
 * @license      GNU GPL 2.0 or later (https://www.gnu.org/licenses/gpl-2.0.html)
 * @author       phppp (D.J., infomax@gmail.com)
 * @author       XOOPS Development Team
 */

use Xmf\Request;
use XoopsModules\Newbb\{
    TypeHandler,
    XmlrssHandler,
    ForumHandler,
    TopicHandler
};
/** @var TypeHandler $typeHandler */
/** @var XmlrssHandler $xmlrssHandler */
require_once __DIR__ . '/header.php';
require_once $GLOBALS['xoops']->path('class/template.php');
require_once $GLOBALS['xoops']->path('modules/newbb/include/functions.rpc.php');

if (!empty($GLOBALS['xoopsModuleConfig']['do_rewrite'])) {
    require_once __DIR__ . '/seo_url.php';
}
/* for seo */

error_reporting(E_ALL);
$xoopsLogger->activated = false;

$forums   = [];
$category = Request::getInt('c', 0, 'GET');
$forumSet = Request::getString('f', '', 'GET');
if ('' !== $forumSet) {
    $forums = array_map('\intval', array_map('\trim', explode('|', (string) $forumSet)));
}

///** @var ForumHandler $forumHandler */
//$forumHandler = Helper::getInstance()->getHandler('Forum');
//$topicHandler = Helper::getInstance()->getHandler('Topic');
$validForums = $forumHandler->getIdsByPermission(); // get all accessible forums

if ($forums && is_array($forums)) {
    $validForums = array_intersect($forums, $validForums);
} elseif ($category > 0) {
    $crit_top = new \CriteriaCompo(new \Criteria('cat_id', (string)$category));
    $crit_top->add(new \Criteria('forum_id', '(' . implode(', ', $validForums) . ')', 'IN'));
    $forums_top  = $forumHandler->getIds($crit_top);
    $validForums = array_intersect($forums_top, $validForums);
}
if (0 === (is_countable($validForums) ? count($validForums) : 0)) {
    newbbTrackbackResponse(1, _NOPERM);
}

asort($validForums);
$forumSet = implode(',', $validForums);

$charset = 'UTF-8';
header('Content-Type:text/xml; charset=' . $charset);

/** @var \XoopsTpl $tpl */
$tpl                 = new \XoopsTpl();
$tpl->caching        = 2;
$tpl->cache_lifetime = $GLOBALS['xoopsModuleConfig']['rss_cachetime'] * 60;
if (!empty($GLOBALS['xoopsConfig']['rewrite'])) {
    $tpl->load_filter('output', 'xoRewriteModule');
}

//mod_loadFunctions('cache');
$xoopsCachedTemplateId = "newbbb_rss_$forumSet";
$compile_id            = null;
$type_list = null;
$users = null;
if (!$tpl->is_cached('db:newbb_rss.tpl', $xoopsCachedTemplateId, $compile_id)) {
    require_once __DIR__ . '/include/functions.time.php';

    //    $xmlrssHandler = \XoopsModules\Newbb\Helper::getInstance()->getHandler('Xmlrss');
    $rss = $xmlrssHandler->create();

    $rss->setVarRss('channel_title', $GLOBALS['xoopsConfig']['sitename'] . ' :: ' . _MD_NEWBB_FORUM);
    $rss->channel_link = XOOPS_URL . '/';
    $rss->setVarRss('channel_desc', $GLOBALS['xoopsConfig']['slogan'] . ' :: ' . $xoopsModule->getInfo('description'));
    $rss->setVarRss('channel_lastbuild', formatTimestamp(time(), 'rss'));
    $rss->channel_webmaster = $GLOBALS['xoopsConfig']['adminmail'];
    $rss->channel_editor    = $GLOBALS['xoopsConfig']['adminmail'];
    $rss->setVarRss('channel_category', $xoopsModule->getVar('name'));
    $rss->channel_generator = 'NewBB ' . $xoopsModule->getInfo('version');
    $rss->channel_language  = _LANGCODE;
    $rss->xml_encoding      = $charset;
    $rss->image_url         = XOOPS_URL . '/modules/' . $xoopsModule->getVar('dirname') . '/' . $xoopsModule->getInfo('image');

    $dimension = @getimagesize($GLOBALS['xoops']->path('modules/' . $xoopsModule->getVar('dirname') . '/' . $xoopsModule->getInfo('image')));
    if (empty($dimension[0])) {
        $width = 88;
    } else {
        $width = ($dimension[0] > 144) ? 144 : $dimension[0];
    }
    if (empty($dimension[1])) {
        $height = 31;
    } else {
        $height = ($dimension[1] > 400) ? 400 : $dimension[1];
    }
    $rss->image_width  = $width;
    $rss->image_height = $height;

    $rss->max_items            = $GLOBALS['xoopsModuleConfig']['rss_maxitems'];
    $rss->max_item_description = $GLOBALS['xoopsModuleConfig']['rss_maxdescription'];

    $forumCriteria = ' AND t.forum_id IN (' . implode(',', $validForums) . ')';
    unset($validForums);
    $approveCriteria = ' AND t.approved = 1 AND p.approved = 1';

    $sql = 'SELECT'
             . '    f.forum_id, f.forum_name,'
             . '    t.topic_id, t.topic_title, t.type_id,'
             . '    p.post_id, p.post_time, p.subject, p.uid, p.poster_name, p.post_karma, p.require_reply, '
             . '    pt.dohtml, pt.dosmiley, pt.doxcode, pt.dobr,'
             . '    pt.post_text'
             . '    FROM '
             . $GLOBALS['xoopsDB']->prefix('newbb_posts')
             . ' AS p'
             . '    LEFT JOIN '
             . $GLOBALS['xoopsDB']->prefix('newbb_topics')
             . ' AS t ON t.topic_last_post_id=p.post_id'
             . '    LEFT JOIN '
             . $GLOBALS['xoopsDB']->prefix('newbb_posts_text')
             . ' AS pt ON pt.post_id=p.post_id'
             . '    LEFT JOIN '
             . $GLOBALS['xoopsDB']->prefix('newbb_forums')
             . ' AS f ON f.forum_id=p.forum_id'
             . '    WHERE 1=1 '
             . $forumCriteria
             . $approveCriteria
             . ' ORDER BY p.post_id DESC';
    $limit = (int)($GLOBALS['xoopsModuleConfig']['rss_maxitems'] * 1.5);
    $result = $GLOBALS['xoopsDB']->query($sql, $limit);
    if (!$GLOBALS['xoopsDB']->isResultSet($result)) {
        //                \trigger_error("Query Failed! SQL: $sql- Error: " . $GLOBALS['xoopsDB']->error(), E_USER_ERROR);
        newbbTrackbackResponse(1, _MD_NEWBB_ERROR);
        //xoops_error($GLOBALS['xoopsDB']->error());
        //return $xmlrssHandler->get($rss);
    }
    $rows  = [];
    $types = [];
    while (false !== ($row = $GLOBALS['xoopsDB']->fetchArray($result))) {
        $users[$row['uid']] = 1;
        if ($row['type_id'] > 0) {
            $types[$row['type_id']] = 1;
        }
        $rows[] = $row;
    }

    if (count($rows) < 1) {
        newbbTrackbackResponse(1, _MD_NEWBB_NORSS_DATA);
        //return $xmlrssHandler->get($rss);
    }
    $users = newbbGetUnameFromIds(array_keys($users), $GLOBALS['xoopsModuleConfig']['show_realname']);

$users of type null is incompatible with the type array expected by parameter $array of array_keys().

    if (count($types) > 0) {
        //        $typeHandler = \XoopsModules\Newbb\Helper::getInstance()->getHandler('Type');
        $type_list = $typeHandler->getList(new \Criteria('type_id', '(' . implode(', ', array_keys($types)) . ')', 'IN'));
    }

    foreach ($rows as $topic) {
        if ($topic['post_karma'] > 0 && $GLOBALS['xoopsModuleConfig']['enable_karma']) {
            continue;
        }
        if ($topic['require_reply'] && $GLOBALS['xoopsModuleConfig']['allow_require_reply']) {
            continue;
        }
        if (!empty($users[$topic['uid']])) {
            $topic['uname'] = $users[$topic['uid']];
        } else {
            $topic['uname'] = $topic['poster_name'] ? htmlspecialchars((string)$topic['poster_name'], ENT_QUOTES | ENT_HTML5) : htmlspecialchars((string)$GLOBALS['xoopsConfig']['anonymous'], ENT_QUOTES | ENT_HTML5);
        }
        $description            = $topic['forum_name'] . '::';
        $topic['topic_subject'] = empty($type_list[$topic['type_id']]) ? '' : '[' . $type_list[$topic['type_id']] . '] ';
        $description            .= $topic['topic_subject'] . $topic['topic_title'] . "<br>\n";
        $description            .= $myts->displayTarea($topic['post_text'], $topic['dohtml'], $topic['dosmiley'], $topic['doxcode'], $topic['dobr']);
        $label                  = _MD_NEWBB_BY . ' ' . $topic['uname'];
        $time                   = formatTimestamp($topic['post_time'], 'rss');
        $link                   = XOOPS_URL . '/modules/' . $xoopsModule->getVar('dirname') . '/viewtopic.php?post_id=' . $topic['post_id'] . '';
        if (!empty($GLOBALS['xoopsModuleConfig']['do_rewrite'])) {
            $link   = XOOPS_URL . '/' . REAL_MODULE_NAME . '/viewtopic.php?post_id=' . $topic['post_id'] . '';
            $oldurl = '<a href=\'' . $link . '\'>';
            $newurl = seo_urls($oldurl);
            $newurl = str_replace('<a href=\'', '', $newurl);
            $newurl = str_replace('\'>', '', $newurl);
            $link   = $newurl;
        }
        $title = $topic['subject'];
        if (false === $rss->addItem($title, $link, $description, $label, $time)) {
            break;
        }
    }

    $rss_feed = $xmlrssHandler->get($rss);

    $tpl->assign('rss', $rss_feed);
    unset($rss);
}
$tpl->display('db:newbb_rss.tpl', $xoopsCachedTemplateId, $compile_id);