Apcal   A
last analyzed

Complexity

Total Complexity 5

Size/Duplication

Total Lines 32
Duplicated Lines 0 %

Importance

Changes 1
Bugs 0 Features 0
Metric Value
eloc 21
c 1
b 0
f 0
dl 0
loc 32
rs 10
wmc 5

2 Methods

Rating   Name   Duplication   Size   Complexity  
A grabEntries() 0 22 3
A __construct() 0 4 2
1
<?php
2
3
declare(strict_types=1);
4
5
namespace XoopsModules\Rssfit\Plugins;
6
7
/*
8
 * You may not change or alter any portion of this comment or credits
9
 * of supporting developers from this source code or any supporting source code
10
 * which is considered copyrighted (c) material of the original comment or credit authors.
11
 *
12
 * This program is distributed in the hope that it will be useful,
13
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
14
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
15
 */
16
17
/**
18
 * @copyright    XOOPS Project (https://xoops.org)
19
 * @license      GNU GPL 2 or later (https://www.gnu.org/licenses/gpl-2.0.html)
20
 * @package      RSSFit - Extendable XML news feed generator
21
 * @author       NS Tai (aka tuff) <http://www.brandycoke.com>
22
 * @author       XOOPS Development Team
23
 */
24
25
/**
26
 * About this RSSFit plug-in
27
 * Author: jayjay <http://www.sint-niklaas.be>
28
 * Requirements (Tested with):
29
 *  Module: Apcal <https://xoops.org>
30
 *  Version: 1.0
31
 *  RSSFit version: 1.21
32
 *  XOOPS version: 2.0.18.1
33
 */
34
35
use XoopsModules\Apcal\Helper as PluginHelper;
36
use XoopsModules\Rssfit\{
37
    AbstractPlugin
38
};
39
40
if (!\defined('RSSFIT_ROOT_PATH')) {
41
    exit();
42
}
43
44
/**
45
 * Class Apcal
46
 */
47
final class Apcal extends AbstractPlugin
48
{
49
    public function __construct() {
50
        if (\class_exists(PluginHelper::class)) {
51
            $this->helper = PluginHelper::getInstance();
52
            $this->dirname = $this->helper->dirname();
53
        }
54
    }
55
56
57
    public function grabEntries(\XoopsMySQLDatabase $xoopsDB): ?array
58
    {
59
        $myts   = \MyTextSanitizer::getInstance();
60
        $ret    = null;
61
        $i      = 0;
62
        $sql    = 'SELECT id, uid, summary, location, description, categories, start, end, UNIX_TIMESTAMP(dtstamp) as dtstamp FROM ' . $xoopsDB->prefix('apcal_event') . ' WHERE admission>0 AND (rrule_pid=0 OR rrule_pid=id) ORDER BY dtstamp DESC';
63
        $result = $xoopsDB->query($sql, $this->grab, 0);
64
        if ($result instanceof \mysqli_result) {
65
            $ret = [];
66
            while (false !== ($row = $xoopsDB->fetchArray($result))) {
67
                $ret[$i]['title']       = $row['summary'];
68
                $link                   = XOOPS_URL . '/modules/' . $this->dirname . '/index.php?event_id=' . $row['id'];
69
                $ret[$i]['link']        = $ret[$i]['guid'] = $link;
70
                $ret[$i]['timestamp']   = $row['dtstamp'];
71
                $ret[$i]['description'] = $myts->displayTarea($row['description']);
72
                $ret[$i]['category']    = $this->modname;
73
                $ret[$i]['domain']      = XOOPS_URL . '/modules/' . $this->dirname . '/';
74
                $i++;
75
            }
76
        }
77
78
        return $ret;
79
    }
80
}
81