Passed
Pull Request — master (#8)
by Michael
03:27
created

Mylinks::loadModule()   A

Complexity

Conditions 2
Paths 2

Size

Total Lines 12
Code Lines 7

Duplication

Lines 0
Ratio 0 %

Importance

Changes 1
Bugs 0 Features 0
Metric Value
cc 2
eloc 7
c 1
b 0
f 0
nc 2
nop 0
dl 0
loc 12
rs 10
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: tuff <http://www.brandycoke.com>
28
* Requirements (Tested with):
29
*  Module: MyLinks <https://xoops.org>
30
*  Version: 1.1
31
*  RSSFit verision: 1.2 / 1.5
32
*  XOOPS version: 2.0.13.2 / 2.2.3
33
*/
34
35
use XoopsModules\Mylinks\Helper as PluginHelper;
36
use XoopsModules\Rssfit\{
37
    AbstractPlugin
38
};
39
40
if (!\defined('RSSFIT_ROOT_PATH')) {
41
    exit();
42
}
43
44
/**
45
 * Class Mylinks
46
 * @package XoopsModules\Rssfit\Plugins
47
 */
48
final class Mylinks extends AbstractPlugin
49
{
50
    public function __construct() {
51
        if (\class_exists(PluginHelper::class)) {
52
            $this->helper = PluginHelper::getInstance();
53
            $this->dirname = $this->helper->dirname();
54
        }
55
    }
56
57
58
    public function grabEntries(\XoopsMySQLDatabase $xoopsDB): ?array
59
    {
60
        $myts   = \MyTextSanitizer::getInstance();
61
        $ret    = null;
62
        $i      = 0;
63
        $sql    = 'SELECT l.lid, l.cid, l.title, l.date, t.description FROM ' . $xoopsDB->prefix('mylinks_links') . ' l, ' . $xoopsDB->prefix('mylinks_text') . ' t WHERE l.status>0 AND l.lid=t.lid ORDER BY date DESC';
64
        $result = $xoopsDB->query($sql, $this->grab, 0);
65
        if ($result instanceof \mysqli_result) {
66
            $ret = [];
67
            while (false !== ($row = $xoopsDB->fetchArray($result))) {
68
                $ret[$i]['title']       = $row['title'];
69
                $link                   = XOOPS_URL . '/modules/' . $this->dirname . '/singlelink.php?cid=' . $row['cid'] . '&amp;lid=' . $row['lid'];
70
                $ret[$i]['link']        = $ret[$i]['guid'] = $link;
71
                $ret[$i]['timestamp']   = $row['date'];
72
                $ret[$i]['description'] = $myts->displayTarea($row['description']);
73
                $ret[$i]['category']    = $this->modname;
74
                $ret[$i]['domain']      = XOOPS_URL . '/modules/' . $this->dirname . '/';
75
                $i++;
76
            }
77
        }
78
        return $ret;
79
    }
80
}
81