ModerateHandler::verifyUser() - Code Metrics - mambax7/newbb5 - Measure and Improve Code Quality continuously with Scrutinizer

ModerateHandler::verifyUser() C
last analyzed 2020-07-25 09:59 UTC

↳ Parent: ModerateHandler

Complexity

Conditions	15
Paths	193

Size

Total Lines	48
Code Lines	29

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	15
eloc	29
nc	193
nop	3
dl	0
loc	48
rs	5.1416
c	0
b	0
f	0

How to fix Complexity

<?php

namespace XoopsModules\Newbb;

/**
 * NewBB 5.0x,  the forum module for XOOPS project
 *
 * @copyright      XOOPS Project (https://xoops.org)
 * @license        GNU GPL 2 or later (https://www.gnu.org/licenses/gpl-2.0.html)
 * @author         Taiwen Jiang (phppp or D.J.) <[email protected]>
 * @since          4.00
 * @package        module::newbb
 */

use Xmf\IPAddress;

 /**
 * Class ModerateHandler
 */
class ModerateHandler extends \XoopsPersistableObjectHandler
{
    /**
     * @param null|\XoopsDatabase $db
     */
    public function __construct(\XoopsDatabase $db = null)
    {
        parent::__construct($db, 'newbb_moderates', Moderate::class, 'mod_id', 'uid');
    }

    /**
     * Clear garbage
     *
     * Delete all moderation information that has expired
     *
     * @param int $expire Expiration time in UNIX, 0 for time()
     */
    public function clearGarbage($expire = 0)
    {
        $expire = \time() - (int)$expire;
        $sql    = \sprintf('DELETE FROM `%s` WHERE mod_end < %u', $this->db->prefix('newbb_moderates'), $expire);
        $this->db->queryF($sql);
    }

    /**
     * Check if a user is moderated, according to his uid and ip
     *
     *
     * @param int         $uid user id
     * @param string|bool $ip  user ip
     * @param int         $forum
     * @return bool true if IP is banned
     */
    public function verifyUser($uid = -1, $ip = '', $forum = 0)
    {
        \error_reporting(\E_ALL);
        // if user is admin do not suspend
        if (\newbbIsAdmin($forum)) {
            return true;
        }

        $uid = ($uid < 0) ? (\is_object($GLOBALS['xoopsUser']) ? $GLOBALS['xoopsUser']->getVar('uid') : 0) : (int)$uid;

        $criteria      = new \CriteriaCompo(new \Criteria('uid', (int)$uid));
        $forumCriteria = new \CriteriaCompo(new \Criteria('forum_id', 0), 'OR');
        if (!empty($forum)) {
            $forumCriteria->add(new \Criteria('forum_id', (int)$forum), 'OR');
        }
        $criteria->add($forumCriteria);
        $criteria->add(new \Criteria('mod_end', \time(), '>'));

        $matches = $this->getAll($criteria);

        if (0 === \count($matches)) {
            return true; // no matches
        }

        if (\count($matches) > 0 && $uid > 0) {
            return false; // user is banned
        }
        // verify possible matches against IP address
        $ip = empty($ip) ? IPAddress::fromRequest()->asReadable() : $ip;

        foreach ($matches as $modMatch) {
            $rawModIp = \trim($modMatch->getVar('ip', 'n'));
            if (empty($rawModIp)) {
                return false; // banned without IP
            }
            $parts   = \explode('/', $rawModIp);
            $modIp   = $parts[0];
            $checkIp = new IPAddress($modIp);
            if (false !== $checkIp->asReadable()) {
                $defaultMask = (6 === $checkIp->ipVersion()) ? 128 : 32;
                $netMask     = isset($parts[1]) ? (int)$parts[1] : $defaultMask;
                if ($checkIp->sameSubnet($ip, $netMask, $netMask)) {
                    return false; // IP is banned
                }
            }
        }

        return true;
    }

    /**
     * Get latest expiration for a user moderation
     *
     *
     * @param mixed $item user id or ip
     * @param bool  $isUid
     * @return int
     */
    public function getLatest($item, $isUid = true)
    {
        $ips = [];
        if ($isUid) {
            $criteria = 'uid =' . (int)$item;
        } else {
            $ip_segs = \explode('.', $item);
            $segs    = \min(\count($ip_segs), 4);
            for ($i = 1; $i <= $segs; ++$i) {
                $ips[] = $this->db->quoteString(\implode('.', \array_slice($ip_segs, 0, $i)));
            }
            $criteria = 'ip IN(' . \implode(',', $ips) . ')';
        }
        $sql = 'SELECT MAX(mod_end) AS expire FROM ' . $this->db->prefix('newbb_moderates') . ' WHERE ' . $criteria;
        if (!$result = $this->db->query($sql)) {
            return -1;
        }
        $row = $this->db->fetchArray($result);

        return $row['expire'];
    }

    /**
     * clean orphan items from database
     *
     * @param string $table_link
     * @param string $field_link
     * @param string $field_object
     * @return bool   true on success
     */
    public function cleanOrphan($table_link = '', $field_link = '', $field_object = '') //cleanOrphan()
    {
        $sql = 'DELETE FROM ' . $this->table . ' WHERE (forum_id >0 AND forum_id NOT IN ( SELECT DISTINCT forum_id FROM ' . $this->db->prefix('newbb_forums') . ') )';
        if (!$result = $this->db->queryF($sql)) {

            //xoops_error($this->db->error());
            return false;
        }

        return true;
    }
}


1			<?php
2
3			namespace XoopsModules\Newbb;
4
5			/**
6			* NewBB 5.0x, the forum module for XOOPS project
7			*
8			* @copyright XOOPS Project (https://xoops.org)
9			* @license GNU GPL 2 or later (https://www.gnu.org/licenses/gpl-2.0.html)
10			* @author Taiwen Jiang (phppp or D.J.) <[email protected]>
11			* @since 4.00
12			* @package module::newbb
13			*/
14
15			use Xmf\IPAddress;
16
17			/**
18			* Class ModerateHandler
19			*/
20			class ModerateHandler extends \XoopsPersistableObjectHandler
21			{
22			/**
23			* @param null\|\XoopsDatabase $db
24			*/
25			public function __construct(\XoopsDatabase $db = null)
26			{
27			parent::__construct($db, 'newbb_moderates', Moderate::class, 'mod_id', 'uid');
28			}
29
30			/**
31			* Clear garbage
32			*
33			* Delete all moderation information that has expired
34			*
35			* @param int $expire Expiration time in UNIX, 0 for time()
36			*/
37			public function clearGarbage($expire = 0)
38			{
39			$expire = \time() - (int)$expire;
40			$sql = \sprintf('DELETE FROM `%s` WHERE mod_end < %u', $this->db->prefix('newbb_moderates'), $expire);
41			$this->db->queryF($sql);
42			}
43
44			/**
45			* Check if a user is moderated, according to his uid and ip
46			*
47			*
48			* @param int $uid user id
49			* @param string\|bool $ip user ip
50			* @param int $forum
51			* @return bool true if IP is banned
52			*/
53			public function verifyUser($uid = -1, $ip = '', $forum = 0)
54			{
55			\error_reporting(\E_ALL);
56			// if user is admin do not suspend
57			if (\newbbIsAdmin($forum)) {
58			return true;
59			}
60
61			$uid = ($uid < 0) ? (\is_object($GLOBALS['xoopsUser']) ? $GLOBALS['xoopsUser']->getVar('uid') : 0) : (int)$uid;
62
63			$criteria = new \CriteriaCompo(new \Criteria('uid', (int)$uid));
64			$forumCriteria = new \CriteriaCompo(new \Criteria('forum_id', 0), 'OR');
65			if (!empty($forum)) {
66			$forumCriteria->add(new \Criteria('forum_id', (int)$forum), 'OR');
67			}
68			$criteria->add($forumCriteria);
69			$criteria->add(new \Criteria('mod_end', \time(), '>'));
70
71			$matches = $this->getAll($criteria);
72
73			if (0 === \count($matches)) {
74			return true; // no matches
75			}
76
77			if (\count($matches) > 0 && $uid > 0) {
78			return false; // user is banned
79			}
80			// verify possible matches against IP address
81			$ip = empty($ip) ? IPAddress::fromRequest()->asReadable() : $ip;
82
83			foreach ($matches as $modMatch) {
84			$rawModIp = \trim($modMatch->getVar('ip', 'n'));
85			if (empty($rawModIp)) {
86			return false; // banned without IP
87			}
88			$parts = \explode('/', $rawModIp);
89			$modIp = $parts[0];
90			$checkIp = new IPAddress($modIp);
91			if (false !== $checkIp->asReadable()) {
92			$defaultMask = (6 === $checkIp->ipVersion()) ? 128 : 32;
93			$netMask = isset($parts[1]) ? (int)$parts[1] : $defaultMask;
94			if ($checkIp->sameSubnet($ip, $netMask, $netMask)) {
95			return false; // IP is banned
96			}
97			}
98			}
99
100			return true;
101			}
102
103			/**
104			* Get latest expiration for a user moderation
105			*
106			*
107			* @param mixed $item user id or ip
108			* @param bool $isUid
109			* @return int
110			*/
111			public function getLatest($item, $isUid = true)
112			{
113			$ips = [];
114			if ($isUid) {
115			$criteria = 'uid =' . (int)$item;
116			} else {
117			$ip_segs = \explode('.', $item);
118			$segs = \min(\count($ip_segs), 4);
119			for ($i = 1; $i <= $segs; ++$i) {
120			$ips[] = $this->db->quoteString(\implode('.', \array_slice($ip_segs, 0, $i)));
121			}
122			$criteria = 'ip IN(' . \implode(',', $ips) . ')';
123			}
124			$sql = 'SELECT MAX(mod_end) AS expire FROM ' . $this->db->prefix('newbb_moderates') . ' WHERE ' . $criteria;
125			if (!$result = $this->db->query($sql)) {
126			return -1;
127			}
128			$row = $this->db->fetchArray($result);
129
130			return $row['expire'];
131			}
132
133			/**
134			* clean orphan items from database
135			*
136			* @param string $table_link
137			* @param string $field_link
138			* @param string $field_object
139			* @return bool true on success
140			*/
141			public function cleanOrphan($table_link = '', $field_link = '', $field_object = '') //cleanOrphan()
142			{
143			$sql = 'DELETE FROM ' . $this->table . ' WHERE (forum_id >0 AND forum_id NOT IN ( SELECT DISTINCT forum_id FROM ' . $this->db->prefix('newbb_forums') . ') )';
144			if (!$result = $this->db->queryF($sql)) {
			0 ignored issues – show Unused Code introduced 2018-03-16 05:13 UTC by Report Bug Copy Issue Report The assignment to `$result` is dead and can be removed. Loading history...
145			//xoops_error($this->db->error());
146			return false;
147			}
148
149			return true;
150			}
151			}
152

mambax7 / newbb5

ModerateHandler::verifyUser() C last analyzed 2020-07-25 09:59 UTC

Complexity

Size

Duplication

Importance

How to fix Complexity

Long Method

Duplication Side-by-Side

Filter issues like

ModerateHandler::verifyUser() C
last analyzed 2020-07-25 09:59 UTC