@@ -50,7 +50,7 @@ discard block |
||
50 | 50 | if (!$valid_ids = $this->getIdsByPermission($permission)) { |
51 | 51 | return $categories; |
52 | 52 | } |
53 | - $criteria = new \Criteria('cat_id', '(' . implode(', ', $valid_ids) . ')', 'IN'); |
|
53 | + $criteria = new \Criteria('cat_id', '('.implode(', ', $valid_ids).')', 'IN'); |
|
54 | 54 | $criteria->setSort('cat_order'); |
55 | 55 | $categories = $this->getAll($criteria, $tags, $asObject); |
56 | 56 | |
@@ -115,7 +115,7 @@ discard block |
||
115 | 115 | return true; |
116 | 116 | } |
117 | 117 | |
118 | - $cat_id = is_object($category) ? $category->getVar('cat_id') : (int)$category; |
|
118 | + $cat_id = is_object($category) ? $category->getVar('cat_id') : (int) $category; |
|
119 | 119 | /** @var PermissionHandler $permHandler */ |
120 | 120 | $permHandler = Newbb\Helper::getInstance()->getHandler('Permission'); |
121 | 121 | return $permHandler->getPermission('category', $perm, $cat_id); |
@@ -42,13 +42,13 @@ |
||
42 | 42 | // catid is not used in newbb, so just skip it |
43 | 43 | foreach (array_keys($items[$cat_id]) as $item_id) { |
44 | 44 | // In newbb, the item_id is "topic_id" |
45 | - $items_id[] = (int)$item_id; |
|
45 | + $items_id[] = (int) $item_id; |
|
46 | 46 | } |
47 | 47 | } |
48 | 48 | /** @var TopicHandler $itemHandler */ |
49 | 49 | $itemHandler = Newbb\Helper::getInstance()->getHandler('Topic'); |
50 | 50 | /** @var \XoopsObject $itemsObject */ |
51 | - $itemsObject = $itemHandler->getObjects(new \Criteria('topic_id', '(' . implode(', ', $items_id) . ')', 'IN'), true); |
|
51 | + $itemsObject = $itemHandler->getObjects(new \Criteria('topic_id', '('.implode(', ', $items_id).')', 'IN'), true); |
|
52 | 52 | |
53 | 53 | foreach (array_keys($items) as $cat_id) { |
54 | 54 | foreach (array_keys($items[$cat_id]) as $item_id) { |
@@ -88,9 +88,9 @@ discard block |
||
88 | 88 | { |
89 | 89 | $topic_id = $object->getVar('topic_id'); |
90 | 90 | if ($force) { |
91 | - $sql = 'UPDATE ' . $this->db->prefix('newbb_topics') . " SET approved = -1 WHERE topic_id = {$topic_id}"; |
|
91 | + $sql = 'UPDATE '.$this->db->prefix('newbb_topics')." SET approved = -1 WHERE topic_id = {$topic_id}"; |
|
92 | 92 | } else { |
93 | - $sql = 'UPDATE ' . $this->db->prefix('newbb_topics') . " SET approved = 1 WHERE topic_id = {$topic_id}"; |
|
93 | + $sql = 'UPDATE '.$this->db->prefix('newbb_topics')." SET approved = 1 WHERE topic_id = {$topic_id}"; |
|
94 | 94 | } |
95 | 95 | if (!$result = $this->db->queryF($sql)) { |
96 | 96 | //xoops_error($this->db->error()); |
@@ -130,7 +130,7 @@ discard block |
||
130 | 130 | { |
131 | 131 | $topic = null; |
132 | 132 | if (!empty($action)) { |
133 | - $sql = 'SELECT * FROM ' . $this->table . ' WHERE 1=1' . (($forum_id > 0) ? ' AND forum_id=' . (int)$forum_id : '') . ' AND topic_id ' . (($action > 0) ? '>' : '<') . (int)$topic_id . ' ORDER BY topic_id ' . (($action > 0) ? 'ASC' : 'DESC') . ' LIMIT 1'; |
|
133 | + $sql = 'SELECT * FROM '.$this->table.' WHERE 1=1'.(($forum_id > 0) ? ' AND forum_id='.(int) $forum_id : '').' AND topic_id '.(($action > 0) ? '>' : '<').(int) $topic_id.' ORDER BY topic_id '.(($action > 0) ? 'ASC' : 'DESC').' LIMIT 1'; |
|
134 | 134 | if ($result = $this->db->query($sql)) { |
135 | 135 | if ($row = $this->db->fetchArray($result)) { |
136 | 136 | $topic = $this->create(false); |
@@ -152,8 +152,8 @@ discard block |
||
152 | 152 | public function &getByPost($post_id) |
153 | 153 | { |
154 | 154 | $topic = null; |
155 | - $sql = 'SELECT t.* FROM ' . $this->db->prefix('newbb_topics') . ' t, ' . $this->db->prefix('newbb_posts') . ' p |
|
156 | - WHERE t.topic_id = p.topic_id AND p.post_id = ' . (int)$post_id; |
|
155 | + $sql = 'SELECT t.* FROM '.$this->db->prefix('newbb_topics').' t, '.$this->db->prefix('newbb_posts').' p |
|
156 | + WHERE t.topic_id = p.topic_id AND p.post_id = ' . (int) $post_id; |
|
157 | 157 | $result = $this->db->query($sql); |
158 | 158 | if (!$result) { |
159 | 159 | //xoops_error($this->db->error()); |
@@ -200,10 +200,10 @@ discard block |
||
200 | 200 | public function &getTopPost($topic_id) |
201 | 201 | { |
202 | 202 | $post = null; |
203 | - $sql = 'SELECT p.*, t.* FROM ' . $this->db->prefix('newbb_posts') . ' p, |
|
204 | - ' . $this->db->prefix('newbb_posts_text') . ' t |
|
203 | + $sql = 'SELECT p.*, t.* FROM '.$this->db->prefix('newbb_posts').' p, |
|
204 | + ' . $this->db->prefix('newbb_posts_text').' t |
|
205 | 205 | WHERE |
206 | - p.topic_id = ' . $topic_id . ' AND p.pid = 0 |
|
206 | + p.topic_id = ' . $topic_id.' AND p.pid = 0 |
|
207 | 207 | AND t.post_id = p.post_id'; |
208 | 208 | |
209 | 209 | $result = $this->db->query($sql); |
@@ -227,7 +227,7 @@ discard block |
||
227 | 227 | */ |
228 | 228 | public function getTopPostId($topic_id) |
229 | 229 | { |
230 | - $sql = 'SELECT MIN(post_id) AS post_id FROM ' . $this->db->prefix('newbb_posts') . ' WHERE topic_id = ' . $topic_id . ' AND pid = 0'; |
|
230 | + $sql = 'SELECT MIN(post_id) AS post_id FROM '.$this->db->prefix('newbb_posts').' WHERE topic_id = '.$topic_id.' AND pid = 0'; |
|
231 | 231 | $result = $this->db->query($sql); |
232 | 232 | if (!$result) { |
233 | 233 | //xoops_error($this->db->error()); |
@@ -250,8 +250,8 @@ discard block |
||
250 | 250 | public function &getAllPosts(&$topic, $order = 'ASC', $perpage = 10, &$start, $post_id = 0, $type = '') |
251 | 251 | { |
252 | 252 | $ret = []; |
253 | - $perpage = ((int)$perpage > 0) ? (int)$perpage : (empty($GLOBALS['xoopsModuleConfig']['posts_per_page']) ? 10 : $GLOBALS['xoopsModuleConfig']['posts_per_page']); |
|
254 | - $start = (int)$start; |
|
253 | + $perpage = ((int) $perpage > 0) ? (int) $perpage : (empty($GLOBALS['xoopsModuleConfig']['posts_per_page']) ? 10 : $GLOBALS['xoopsModuleConfig']['posts_per_page']); |
|
254 | + $start = (int) $start; |
|
255 | 255 | switch ($type) { |
256 | 256 | case 'pending': |
257 | 257 | $approveCriteria = ' AND p.approved = 0'; |
@@ -272,17 +272,17 @@ discard block |
||
272 | 272 | $operator_for_position = '<'; |
273 | 273 | } |
274 | 274 | //$approveCriteria = ' AND approved = 1'; // any others? |
275 | - $sql = 'SELECT COUNT(*) FROM ' . $this->db->prefix('newbb_posts') . ' AS p WHERE p.topic_id=' . (int)$topic->getVar('topic_id') . $approveCriteria . " AND p.post_id $operator_for_position $post_id"; |
|
275 | + $sql = 'SELECT COUNT(*) FROM '.$this->db->prefix('newbb_posts').' AS p WHERE p.topic_id='.(int) $topic->getVar('topic_id').$approveCriteria." AND p.post_id $operator_for_position $post_id"; |
|
276 | 276 | $result = $this->db->query($sql); |
277 | 277 | if (!$result) { |
278 | 278 | //xoops_error($this->db->error()); |
279 | 279 | return $ret; |
280 | 280 | } |
281 | 281 | list($position) = $this->db->fetchRow($result); |
282 | - $start = (int)($position / $perpage) * $perpage; |
|
282 | + $start = (int) ($position / $perpage) * $perpage; |
|
283 | 283 | } |
284 | 284 | |
285 | - $sql = 'SELECT p.*, t.* FROM ' . $this->db->prefix('newbb_posts') . ' p, ' . $this->db->prefix('newbb_posts_text') . ' t WHERE p.topic_id=' . $topic->getVar('topic_id') . ' AND p.post_id = t.post_id' . $approveCriteria . " ORDER BY p.post_id $order"; |
|
285 | + $sql = 'SELECT p.*, t.* FROM '.$this->db->prefix('newbb_posts').' p, '.$this->db->prefix('newbb_posts_text').' t WHERE p.topic_id='.$topic->getVar('topic_id').' AND p.post_id = t.post_id'.$approveCriteria." ORDER BY p.post_id $order"; |
|
286 | 286 | $result = $this->db->query($sql, $perpage, $start); |
287 | 287 | if (!$result) { |
288 | 288 | //xoops_error($this->db->error()); |
@@ -327,18 +327,18 @@ discard block |
||
327 | 327 | $postArray['post_time'] = newbbFormatTimestamp($postArray['post_time']); |
328 | 328 | |
329 | 329 | if (!empty($postArray['icon'])) { |
330 | - $postArray['icon'] = '<img src="' . XOOPS_URL . '/images/subject/' . htmlspecialchars($postArray['icon'], ENT_QUOTES | ENT_HTML5) . '" alt="" />'; |
|
330 | + $postArray['icon'] = '<img src="'.XOOPS_URL.'/images/subject/'.htmlspecialchars($postArray['icon'], ENT_QUOTES | ENT_HTML5).'" alt="" />'; |
|
331 | 331 | } else { |
332 | - $postArray['icon'] = '<a name="' . $postArray['post_id'] . '"><img src="' . XOOPS_URL . '/images/icons/no_posticon.gif" alt="" /></a>'; |
|
332 | + $postArray['icon'] = '<a name="'.$postArray['post_id'].'"><img src="'.XOOPS_URL.'/images/icons/no_posticon.gif" alt="" /></a>'; |
|
333 | 333 | } |
334 | 334 | |
335 | - $postArray['subject'] = '<a href="viewtopic.php?viewmode=thread&topic_id=' . $topic->getVar('topic_id') . '&forum=' . $postArray['forum_id'] . '&post_id=' . $postArray['post_id'] . '">' . $postArray['subject'] . '</a>'; |
|
335 | + $postArray['subject'] = '<a href="viewtopic.php?viewmode=thread&topic_id='.$topic->getVar('topic_id').'&forum='.$postArray['forum_id'].'&post_id='.$postArray['post_id'].'">'.$postArray['subject'].'</a>'; |
|
336 | 336 | |
337 | 337 | $isActiveUser = false; |
338 | 338 | if (isset($viewtopic_users[$postArray['uid']]['name'])) { |
339 | 339 | $postArray['poster'] = $viewtopic_users[$postArray['uid']]['name']; |
340 | 340 | if ($postArray['uid'] > 0) { |
341 | - $postArray['poster'] = '<a href="' . XOOPS_URL . '/userinfo.php?uid=' . $postArray['uid'] . '">' . $viewtopic_users[$postArray['uid']]['name'] . '</a>'; |
|
341 | + $postArray['poster'] = '<a href="'.XOOPS_URL.'/userinfo.php?uid='.$postArray['uid'].'">'.$viewtopic_users[$postArray['uid']]['name'].'</a>'; |
|
342 | 342 | } |
343 | 343 | } else { |
344 | 344 | $postArray['poster'] = empty($postArray['poster_name']) ? $myts->htmlSpecialChars($GLOBALS['xoopsConfig']['anonymous']) : $postArray['poster_name']; |
@@ -354,7 +354,7 @@ discard block |
||
354 | 354 | */ |
355 | 355 | public function &getAllPosters(&$topic, $isApproved = true) |
356 | 356 | { |
357 | - $sql = 'SELECT DISTINCT uid FROM ' . $this->db->prefix('newbb_posts') . ' WHERE topic_id=' . $topic->getVar('topic_id') . ' AND uid>0'; |
|
357 | + $sql = 'SELECT DISTINCT uid FROM '.$this->db->prefix('newbb_posts').' WHERE topic_id='.$topic->getVar('topic_id').' AND uid>0'; |
|
358 | 358 | if ($isApproved) { |
359 | 359 | $sql .= ' AND approved = 1'; |
360 | 360 | } |
@@ -378,7 +378,7 @@ discard block |
||
378 | 378 | */ |
379 | 379 | public function delete(\XoopsObject $topic, $force = true) |
380 | 380 | { |
381 | - $topic_id = is_object($topic) ? $topic->getVar('topic_id') : (int)$topic; |
|
381 | + $topic_id = is_object($topic) ? $topic->getVar('topic_id') : (int) $topic; |
|
382 | 382 | if (empty($topic_id)) { |
383 | 383 | return false; |
384 | 384 | } |
@@ -408,12 +408,12 @@ discard block |
||
408 | 408 | public function getPermission($forum, $topic_locked = 0, $type = 'view') |
409 | 409 | { |
410 | 410 | static $_cachedTopicPerms; |
411 | - require_once dirname(__DIR__) . '/include/functions.user.php'; |
|
411 | + require_once dirname(__DIR__).'/include/functions.user.php'; |
|
412 | 412 | if (newbbIsAdmin($forum)) { |
413 | 413 | return true; |
414 | 414 | } |
415 | 415 | |
416 | - $forum_id = is_object($forum) ? $forum->getVar('forum_id') : (int)$forum; |
|
416 | + $forum_id = is_object($forum) ? $forum->getVar('forum_id') : (int) $forum; |
|
417 | 417 | if ($forum_id < 1) { |
418 | 418 | return false; |
419 | 419 | } |
@@ -457,14 +457,14 @@ discard block |
||
457 | 457 | // irmtfan if 0 no cleanup look include/plugin.php |
458 | 458 | if (!func_num_args()) { |
459 | 459 | $newbbConfig = newbbLoadConfig(); |
460 | - $expire = isset($newbbConfig['pending_expire']) ? (int)$newbbConfig['pending_expire'] : 7; |
|
460 | + $expire = isset($newbbConfig['pending_expire']) ? (int) $newbbConfig['pending_expire'] : 7; |
|
461 | 461 | $expire = $expire * 24 * 3600; // days to seconds |
462 | 462 | } |
463 | 463 | if (empty($expire)) { |
464 | 464 | return false; |
465 | 465 | } |
466 | 466 | $crit_expire = new \CriteriaCompo(new \Criteria('approved', 0, '<=')); |
467 | - $crit_expire->add(new \Criteria('topic_time', time() - (int)$expire, '<')); |
|
467 | + $crit_expire->add(new \Criteria('topic_time', time() - (int) $expire, '<')); |
|
468 | 468 | |
469 | 469 | return $this->deleteAll($crit_expire, true/*, true*/); |
470 | 470 | } |
@@ -479,7 +479,7 @@ discard block |
||
479 | 479 | public function synchronization($object = null, $force = true) |
480 | 480 | { |
481 | 481 | if (!is_object($object)) { |
482 | - $object = $this->get((int)$object); |
|
482 | + $object = $this->get((int) $object); |
|
483 | 483 | } |
484 | 484 | if (!is_object($object) || !$object->getVar('topic_id')) { |
485 | 485 | return false; |
@@ -505,7 +505,7 @@ discard block |
||
505 | 505 | } |
506 | 506 | $b1 = $this->insert($object, $force); |
507 | 507 | $criteria->add(new \Criteria('post_id', $top_post, '<>'), 'AND'); |
508 | - $criteria->add(new \Criteria('pid', '(' . implode(', ', $post_ids) . ')', 'NOT IN'), 'AND'); |
|
508 | + $criteria->add(new \Criteria('pid', '('.implode(', ', $post_ids).')', 'NOT IN'), 'AND'); |
|
509 | 509 | $b2 = $postHandler->updateAll('pid', $top_post, $criteria, $force); |
510 | 510 | $criteria = new \CriteriaCompo(); |
511 | 511 | $criteria->add(new \Criteria('post_id', $top_post, '='), 'AND'); |
@@ -526,7 +526,7 @@ discard block |
||
526 | 526 | $allDirs = xoops_getActiveModules(); |
527 | 527 | foreach ($allDirs as $dirname) { |
528 | 528 | // pollresults.php file is exist in all xoopspoll versions and umfrage versions |
529 | - if (file_exists($GLOBALS['xoops']->path('modules/' . $dirname . '/pollresults.php'))) { |
|
529 | + if (file_exists($GLOBALS['xoops']->path('modules/'.$dirname.'/pollresults.php'))) { |
|
530 | 530 | $pollDirs[$dirname] = $dirname; |
531 | 531 | } |
532 | 532 | } |
@@ -37,7 +37,7 @@ discard block |
||
37 | 37 | { |
38 | 38 | // $this->PermissionHandler($db); |
39 | 39 | parent::__construct($db); |
40 | - $this->templateFilename = XOOPS_VAR_PATH . '/configs/newbb_permission_template.php'; |
|
40 | + $this->templateFilename = XOOPS_VAR_PATH.'/configs/newbb_permission_template.php'; |
|
41 | 41 | } |
42 | 42 | |
43 | 43 | /** |
@@ -47,16 +47,16 @@ discard block |
||
47 | 47 | public function getValidPerms($fullname = false) |
48 | 48 | { |
49 | 49 | static $validPerms = []; |
50 | - if (isset($validPerms[(int)$fullname])) { |
|
51 | - return $validPerms[(int)$fullname]; |
|
50 | + if (isset($validPerms[(int) $fullname])) { |
|
51 | + return $validPerms[(int) $fullname]; |
|
52 | 52 | } |
53 | 53 | $items = array_filter(array_map('trim', explode(',', FORUM_PERM_ITEMS))); |
54 | 54 | if (!empty($fullname)) { |
55 | 55 | foreach (array_keys($items) as $key) { |
56 | - $items[$key] = 'forum_' . $items[$key]; |
|
56 | + $items[$key] = 'forum_'.$items[$key]; |
|
57 | 57 | } |
58 | 58 | } |
59 | - $validPerms[(int)$fullname] = $items; |
|
59 | + $validPerms[(int) $fullname] = $items; |
|
60 | 60 | |
61 | 61 | return $items; |
62 | 62 | } |
@@ -74,7 +74,7 @@ discard block |
||
74 | 74 | return $full_items; |
75 | 75 | } |
76 | 76 | |
77 | - require_once dirname(__DIR__) . '/include/functions.user.php'; |
|
77 | + require_once dirname(__DIR__).'/include/functions.user.php'; |
|
78 | 78 | $uid = is_object($GLOBALS['xoopsUser']) ? $GLOBALS['xoopsUser']->getVar('uid') : 0; |
79 | 79 | $ip = \Xmf\IPAddress::fromRequest()->asReadable(); |
80 | 80 | if (!empty($GLOBALS['xoopsModuleConfig']['enable_usermoderate']) && !isset($suspension[$uid][$id]) |
@@ -133,18 +133,18 @@ discard block |
||
133 | 133 | } |
134 | 134 | // Create criteria for getting only the permissions regarding this module and this user's groups |
135 | 135 | $criteria = new \CriteriaCompo(new \Criteria('gperm_modid', $modid)); |
136 | - $criteria->add(new \Criteria('gperm_groupid', '(' . implode(',', $groups) . ')', 'IN')); |
|
136 | + $criteria->add(new \Criteria('gperm_groupid', '('.implode(',', $groups).')', 'IN')); |
|
137 | 137 | if ($id) { |
138 | 138 | if (is_array($id)) { |
139 | - $criteria->add(new \Criteria('gperm_itemid', '(' . implode(',', $id) . ')', 'IN')); |
|
139 | + $criteria->add(new \Criteria('gperm_itemid', '('.implode(',', $id).')', 'IN')); |
|
140 | 140 | } else { |
141 | - $criteria->add(new \Criteria('gperm_itemid', (int)$id)); |
|
141 | + $criteria->add(new \Criteria('gperm_itemid', (int) $id)); |
|
142 | 142 | } |
143 | 143 | } |
144 | 144 | $gperm_names = implode(', ', $this->getValidItems($modid, $id)); |
145 | 145 | |
146 | 146 | // Add criteria for gpermnames |
147 | - $criteria->add(new \Criteria('gperm_name', '(' . $gperm_names . ')', 'IN')); |
|
147 | + $criteria->add(new \Criteria('gperm_name', '('.$gperm_names.')', 'IN')); |
|
148 | 148 | // Get all permission objects in this module and for this user's groups |
149 | 149 | $userpermissions = $this->getObjects($criteria, true); |
150 | 150 | |
@@ -182,12 +182,12 @@ discard block |
||
182 | 182 | continue; |
183 | 183 | } |
184 | 184 | if ($isAdmin |
185 | - || (isset($permission_set[$forumId]['forum_' . $item]) |
|
185 | + || (isset($permission_set[$forumId]['forum_'.$item]) |
|
186 | 186 | && (!$topic_locked |
187 | 187 | || 'view' === $item))) { |
188 | - $perm[] = constant('_MD_NEWBB_CAN_' . strtoupper($item)); |
|
188 | + $perm[] = constant('_MD_NEWBB_CAN_'.strtoupper($item)); |
|
189 | 189 | } else { |
190 | - $perm[] = constant('_MD_NEWBB_CANNOT_' . strtoupper($item)); |
|
190 | + $perm[] = constant('_MD_NEWBB_CANNOT_'.strtoupper($item)); |
|
191 | 191 | } |
192 | 192 | } |
193 | 193 | |
@@ -200,14 +200,14 @@ discard block |
||
200 | 200 | */ |
201 | 201 | public function deleteByForum($forum_id) |
202 | 202 | { |
203 | - $forum_id = (int)$forum_id; |
|
203 | + $forum_id = (int) $forum_id; |
|
204 | 204 | if (empty($forum_id)) { |
205 | 205 | return false; |
206 | 206 | } |
207 | 207 | $grouppermHandler = xoops_getHandler('groupperm'); |
208 | 208 | $criteria = new \CriteriaCompo(new \Criteria('gperm_modid', $GLOBALS['xoopsModule']->getVar('mid'))); |
209 | 209 | $items = $this->getValidPerms(true); |
210 | - $criteria->add(new \Criteria('gperm_name', "('" . implode("', '", $items) . "')", 'IN')); |
|
210 | + $criteria->add(new \Criteria('gperm_name', "('".implode("', '", $items)."')", 'IN')); |
|
211 | 211 | $criteria->add(new \Criteria('gperm_itemid', $forum_id)); |
212 | 212 | |
213 | 213 | return $grouppermHandler->deleteAll($criteria); |
@@ -40,7 +40,7 @@ discard block |
||
40 | 40 | if (!is_array($posts)) { |
41 | 41 | $posts = [$posts]; |
42 | 42 | } |
43 | - $post_criteria = new \Criteria('post_id', '(' . implode(', ', $posts) . ')', 'IN'); |
|
43 | + $post_criteria = new \Criteria('post_id', '('.implode(', ', $posts).')', 'IN'); |
|
44 | 44 | $ret = $this->getAll($post_criteria); |
45 | 45 | |
46 | 46 | return $ret; |
@@ -79,26 +79,26 @@ discard block |
||
79 | 79 | if (empty($start)) { |
80 | 80 | $start = 0; |
81 | 81 | } |
82 | - $result_criteria = ' AND r.report_result = ' . $report_result; |
|
82 | + $result_criteria = ' AND r.report_result = '.$report_result; |
|
83 | 83 | |
84 | 84 | if ($forums) { |
85 | 85 | $forumCriteria = ''; |
86 | 86 | } elseif (!is_array($forums)) { |
87 | 87 | $forums = [$forums]; |
88 | - $forumCriteria = ' AND p.forum_id IN (' . implode(',', $forums) . ')'; |
|
88 | + $forumCriteria = ' AND p.forum_id IN ('.implode(',', $forums).')'; |
|
89 | 89 | } |
90 | - $tables_criteria = ' FROM ' . $this->db->prefix('newbb_report') . ' r, ' . $this->db->prefix('newbb_posts') . ' p WHERE r.post_id= p.post_id'; |
|
90 | + $tables_criteria = ' FROM '.$this->db->prefix('newbb_report').' r, '.$this->db->prefix('newbb_posts').' p WHERE r.post_id= p.post_id'; |
|
91 | 91 | |
92 | 92 | if ($report_id) { |
93 | - $result = $this->db->query('SELECT COUNT(*) as report_count' . $tables_criteria . $forumCriteria . $result_criteria . " AND report_id $operator_for_position $report_id" . $order_criteria); |
|
93 | + $result = $this->db->query('SELECT COUNT(*) as report_count'.$tables_criteria.$forumCriteria.$result_criteria." AND report_id $operator_for_position $report_id".$order_criteria); |
|
94 | 94 | if ($result) { |
95 | 95 | $row = $this->db->fetchArray($result); |
96 | 96 | } |
97 | 97 | $position = $row['report_count']; |
98 | - $start = (int)($position / $perpage) * $perpage; |
|
98 | + $start = (int) ($position / $perpage) * $perpage; |
|
99 | 99 | } |
100 | 100 | |
101 | - $sql = 'SELECT r.*, p.subject, p.topic_id, p.forum_id' . $tables_criteria . $forumCriteria . $result_criteria . $order_criteria; |
|
101 | + $sql = 'SELECT r.*, p.subject, p.topic_id, p.forum_id'.$tables_criteria.$forumCriteria.$result_criteria.$order_criteria; |
|
102 | 102 | $result = $this->db->query($sql, $perpage, $start); |
103 | 103 | $ret = []; |
104 | 104 | //$reportHandler = Newbb\Helper::getInstance()->getHandler('Report'); |
@@ -85,7 +85,7 @@ discard block |
||
85 | 85 | { |
86 | 86 | if (count($this->items) < $this->max_items) { |
87 | 87 | if (!empty($label)) { |
88 | - $label = '[' . $this->cleanup($label) . ']'; |
|
88 | + $label = '['.$this->cleanup($label).']'; |
|
89 | 89 | } |
90 | 90 | if (!empty($description)) { |
91 | 91 | $description = $this->cleanup($description, $this->max_item_description); |
@@ -94,7 +94,7 @@ discard block |
||
94 | 94 | //$description = $label; |
95 | 95 | } |
96 | 96 | |
97 | - $title = $this->cleanup($title) . ' ' . $label; |
|
97 | + $title = $this->cleanup($title).' '.$label; |
|
98 | 98 | $pubdate = $this->cleanup($pubdate); |
99 | 99 | $this->items[] = [ |
100 | 100 | 'title' => $title, |
@@ -119,7 +119,7 @@ discard block |
||
119 | 119 | $text = \XoopsLocal::convert_encoding($text, 'utf-8'); |
120 | 120 | } |
121 | 121 | if (!empty($trim)) { |
122 | - $text = xoops_substr($text, 0, (int)$trim); |
|
122 | + $text = xoops_substr($text, 0, (int) $trim); |
|
123 | 123 | } |
124 | 124 | $text = htmlspecialchars($text, ENT_QUOTES); |
125 | 125 |
@@ -50,7 +50,7 @@ discard block |
||
50 | 50 | public function get($id = null, $fields = null) //get($id) |
51 | 51 | { |
52 | 52 | $object = null; |
53 | - if (!$id = (int)$id) { |
|
53 | + if (!$id = (int) $id) { |
|
54 | 54 | return $object; |
55 | 55 | } |
56 | 56 | $object = $this->create(false); |
@@ -82,7 +82,7 @@ discard block |
||
82 | 82 | if (empty($id)) { |
83 | 83 | return null; |
84 | 84 | } |
85 | - $sql = 'SELECT * FROM ' . $this->table . ' WHERE ' . $this->keyName . ' = ' . (int)$id; |
|
85 | + $sql = 'SELECT * FROM '.$this->table.' WHERE '.$this->keyName.' = '.(int) $id; |
|
86 | 86 | if (!$result = $this->db->query($sql)) { |
87 | 87 | return null; |
88 | 88 | } |
@@ -36,7 +36,7 @@ discard block |
||
36 | 36 | */ |
37 | 37 | public function clearGarbage($expire = 0) |
38 | 38 | { |
39 | - $expire = time() - (int)$expire; |
|
39 | + $expire = time() - (int) $expire; |
|
40 | 40 | $sql = sprintf('DELETE FROM `%s` WHERE mod_end < %u', $this->db->prefix('newbb_moderates'), $expire); |
41 | 41 | $this->db->queryF($sql); |
42 | 42 | } |
@@ -58,12 +58,12 @@ discard block |
||
58 | 58 | return true; |
59 | 59 | } |
60 | 60 | |
61 | - $uid = ($uid < 0) ? (is_object($GLOBALS['xoopsUser']) ? $GLOBALS['xoopsUser']->getVar('uid') : 0) : (int)$uid; |
|
61 | + $uid = ($uid < 0) ? (is_object($GLOBALS['xoopsUser']) ? $GLOBALS['xoopsUser']->getVar('uid') : 0) : (int) $uid; |
|
62 | 62 | |
63 | - $criteria = new \CriteriaCompo(new \Criteria('uid', (int)$uid)); |
|
63 | + $criteria = new \CriteriaCompo(new \Criteria('uid', (int) $uid)); |
|
64 | 64 | $forumCriteria = new \CriteriaCompo(new \Criteria('forum_id', 0), 'OR'); |
65 | 65 | if (!empty($forum)) { |
66 | - $forumCriteria->add(new \Criteria('forum_id', (int)$forum), 'OR'); |
|
66 | + $forumCriteria->add(new \Criteria('forum_id', (int) $forum), 'OR'); |
|
67 | 67 | } |
68 | 68 | $criteria->add($forumCriteria); |
69 | 69 | $criteria->add(new \Criteria('mod_end', time(), '>')); |
@@ -90,7 +90,7 @@ discard block |
||
90 | 90 | $checkIp = new IPAddress($modIp); |
91 | 91 | if (false !== $checkIp->asReadable()) { |
92 | 92 | $defaultMask = (6 === $checkIp->ipVersion()) ? 128 : 32; |
93 | - $netMask = isset($parts[1]) ? (int)$parts[1] : $defaultMask; |
|
93 | + $netMask = isset($parts[1]) ? (int) $parts[1] : $defaultMask; |
|
94 | 94 | if ($checkIp->sameSubnet($ip, $netMask, $netMask)) { |
95 | 95 | return false; // IP is banned |
96 | 96 | } |
@@ -112,16 +112,16 @@ discard block |
||
112 | 112 | { |
113 | 113 | $ips = []; |
114 | 114 | if ($isUid) { |
115 | - $criteria = 'uid =' . (int)$item; |
|
115 | + $criteria = 'uid ='.(int) $item; |
|
116 | 116 | } else { |
117 | 117 | $ip_segs = explode('.', $item); |
118 | 118 | $segs = min(count($ip_segs), 4); |
119 | 119 | for ($i = 1; $i <= $segs; ++$i) { |
120 | 120 | $ips[] = $this->db->quoteString(implode('.', array_slice($ip_segs, 0, $i))); |
121 | 121 | } |
122 | - $criteria = 'ip IN(' . implode(',', $ips) . ')'; |
|
122 | + $criteria = 'ip IN('.implode(',', $ips).')'; |
|
123 | 123 | } |
124 | - $sql = 'SELECT MAX(mod_end) AS expire FROM ' . $this->db->prefix('newbb_moderates') . ' WHERE ' . $criteria; |
|
124 | + $sql = 'SELECT MAX(mod_end) AS expire FROM '.$this->db->prefix('newbb_moderates').' WHERE '.$criteria; |
|
125 | 125 | if (!$result = $this->db->query($sql)) { |
126 | 126 | return -1; |
127 | 127 | } |
@@ -140,7 +140,7 @@ discard block |
||
140 | 140 | */ |
141 | 141 | public function cleanOrphan($table_link = '', $field_link = '', $field_object = '') //cleanOrphan() |
142 | 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') . ') )'; |
|
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 | 144 | if (!$result = $this->db->queryF($sql)) { |
145 | 145 | //xoops_error($this->db->error()); |
146 | 146 | return false; |
@@ -52,7 +52,7 @@ discard block |
||
52 | 52 | { |
53 | 53 | if (!isset($this->_handler[$name])) { |
54 | 54 | // require_once __DIR__ . "/permission.{$name}.php"; |
55 | - $className = '\\XoopsModules\\Newbb\\Permission' . ucfirst($name) . 'Handler'; |
|
55 | + $className = '\\XoopsModules\\Newbb\\Permission'.ucfirst($name).'Handler'; |
|
56 | 56 | $this->_handler[$name] = new $className($this->db); |
57 | 57 | } |
58 | 58 | |
@@ -252,7 +252,7 @@ discard block |
||
252 | 252 | } |
253 | 253 | } else { |
254 | 254 | $grouppermHandler = xoops_getHandler('groupperm'); |
255 | - $criteria = new \CriteriaCompo(new \Criteria('gperm_modid', $modid)); |
|
255 | + $criteria = new \CriteriaCompo(new \Criteria('gperm_modid', $modid)); |
|
256 | 256 | if (!empty($perm_name) && 'forum_all' !== $perm_name && 'category_all' !== $perm_name) { |
257 | 257 | $criteria->add(new \Criteria('gperm_name', $perm_name)); |
258 | 258 | } |
@@ -260,7 +260,7 @@ discard block |
||
260 | 260 | |
261 | 261 | foreach ($permissions as $gperm) { |
262 | 262 | $item_id = $gperm->getVar('gperm_itemid'); |
263 | - $group_id = (int)$gperm->getVar('gperm_groupid'); |
|
263 | + $group_id = (int) $gperm->getVar('gperm_groupid'); |
|
264 | 264 | $perms[$gperm->getVar('gperm_name')][$item_id][] = $group_id; |
265 | 265 | } |
266 | 266 | } |
@@ -331,7 +331,7 @@ discard block |
||
331 | 331 | $ret = false; |
332 | 332 | $criteria = new \CriteriaCompo(new \Criteria('gperm_modid', $gperm_modid)); |
333 | 333 | $criteria->add(new \Criteria('gperm_name', $gperm_name)); |
334 | - $gperm_itemid = (int)$gperm_itemid; |
|
334 | + $gperm_itemid = (int) $gperm_itemid; |
|
335 | 335 | if ($gperm_itemid > 0) { |
336 | 336 | $criteria->add(new \Criteria('gperm_itemid', $gperm_itemid)); |
337 | 337 | } |