@@ -66,7 +66,7 @@ |
||
66 | 66 | case 'viewtopic.php': |
67 | 67 | /** @var Newbb\TopicHandler $topicHandler */ |
68 | 68 | $topicHandler = Newbb\Helper::getInstance()->getHandler('Topic'); |
69 | - $post_id = Request::getInt('post_id', 0);// !empty($_REQUEST["post_id"]) ? (int)($_REQUEST["post_id"]) : 0; |
|
69 | + $post_id = Request::getInt('post_id', 0); // !empty($_REQUEST["post_id"]) ? (int)($_REQUEST["post_id"]) : 0; |
|
70 | 70 | $move = strtolower(Request::getString('move', '', 'GET')); // isset($_GET['move'])? strtolower($_GET['move']) : ''; |
71 | 71 | $topic_id = Request::getInt('topic_id', 0); // !empty($_REQUEST["topic_id"]) ? (int)($_REQUEST["topic_id"]) : 0; |
72 | 72 | if (!empty($post_id)) { |
@@ -85,14 +85,14 @@ |
||
85 | 85 | |
86 | 86 | /* clear tag-item links */ |
87 | 87 | $sql = " DELETE FROM {$linkHandler->table}" |
88 | - . ' WHERE ' |
|
89 | - . " tag_modid = {$mid}" |
|
90 | - . ' AND ' |
|
91 | - . ' ( tag_itemid NOT IN ' |
|
92 | - . " ( SELECT DISTINCT {$itemHandler->keyName} " |
|
93 | - . " FROM {$itemHandler->table} " |
|
94 | - . " WHERE {$itemHandler->table}.approved > 0" |
|
95 | - . ' ) ' |
|
96 | - . ' )'; |
|
88 | + . ' WHERE ' |
|
89 | + . " tag_modid = {$mid}" |
|
90 | + . ' AND ' |
|
91 | + . ' ( tag_itemid NOT IN ' |
|
92 | + . " ( SELECT DISTINCT {$itemHandler->keyName} " |
|
93 | + . " FROM {$itemHandler->table} " |
|
94 | + . " WHERE {$itemHandler->table}.approved > 0" |
|
95 | + . ' ) ' |
|
96 | + . ' )'; |
|
97 | 97 | $linkHandler->db->queryF($sql); |
98 | 98 | } |
@@ -48,7 +48,7 @@ |
||
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) { |
@@ -48,7 +48,7 @@ discard block |
||
48 | 48 | . " LEFT JOIN {$this->table} AS o ON o.{$this->keyName} = l.{$this->keyName} " |
49 | 49 | . ' WHERE ' |
50 | 50 | . ' l.forum_id ' |
51 | - . (empty($forums) ? 'IS NOT NULL' : 'IN (' . implode(', ', $forums) . ')') |
|
51 | + . (empty($forums) ? 'IS NOT NULL' : 'IN ('.implode(', ', $forums).')') |
|
52 | 52 | . ' ORDER BY l.type_order ASC'; |
53 | 53 | if (false === ($result = $this->db->query($sql))) { |
54 | 54 | //xoops_error($this->db->error()); |
@@ -104,8 +104,8 @@ discard block |
||
104 | 104 | $types_update = array_filter($types_update); |
105 | 105 | |
106 | 106 | if (!empty($types_valid)) { |
107 | - $sql = 'DELETE FROM ' . $this->db->prefix('newbb_type_forum') . ' WHERE ' . ' forum_id = ' . $forum_id . ' AND ' . // irmtfan bug fix: delete other forums types when update the type for a specific forum |
|
108 | - " {$this->keyName} NOT IN (" . implode(', ', $types_valid) . ')'; |
|
107 | + $sql = 'DELETE FROM '.$this->db->prefix('newbb_type_forum').' WHERE '.' forum_id = '.$forum_id.' AND '.// irmtfan bug fix: delete other forums types when update the type for a specific forum |
|
108 | + " {$this->keyName} NOT IN (".implode(', ', $types_valid).')'; |
|
109 | 109 | if (false === ($result = $this->db->queryF($sql))) { |
110 | 110 | } |
111 | 111 | } |
@@ -117,7 +117,7 @@ discard block |
||
117 | 117 | if ($types_existing[$key]['type_order'] == $order) { |
118 | 118 | continue; |
119 | 119 | } |
120 | - $sql = 'UPDATE ' . $this->db->prefix('newbb_type_forum') . " SET type_order = {$order}" . " WHERE {$this->keyName} = {$key} AND forum_id = {$forum_id}"; |
|
120 | + $sql = 'UPDATE '.$this->db->prefix('newbb_type_forum')." SET type_order = {$order}"." WHERE {$this->keyName} = {$key} AND forum_id = {$forum_id}"; |
|
121 | 121 | if (false === ($result = $this->db->queryF($sql))) { |
122 | 122 | } |
123 | 123 | } |
@@ -130,7 +130,7 @@ discard block |
||
130 | 130 | //if (!in_array($key, $types_add)) continue; |
131 | 131 | $type_query[] = "({$key}, {$forum_id}, {$order})"; |
132 | 132 | } |
133 | - $sql = 'INSERT INTO ' . $this->db->prefix('newbb_type_forum') . ' (type_id, forum_id, type_order) ' . ' VALUES ' . implode(', ', $type_query); |
|
133 | + $sql = 'INSERT INTO '.$this->db->prefix('newbb_type_forum').' (type_id, forum_id, type_order) '.' VALUES '.implode(', ', $type_query); |
|
134 | 134 | if (false === ($result = $this->db->queryF($sql))) { |
135 | 135 | //xoops_error($this->db->error()); |
136 | 136 | } |
@@ -156,7 +156,7 @@ discard block |
||
156 | 156 | /* |
157 | 157 | * Remove forum-type links |
158 | 158 | */ |
159 | - $sql = 'DELETE' . ' FROM ' . $this->db->prefix('newbb_type_forum') . ' WHERE ' . $this->keyName . ' = ' . $object->getVar($this->keyName); |
|
159 | + $sql = 'DELETE'.' FROM '.$this->db->prefix('newbb_type_forum').' WHERE '.$this->keyName.' = '.$object->getVar($this->keyName); |
|
160 | 160 | if (false === ($result = $this->db->{$queryFunc}($sql))) { |
161 | 161 | // xoops_error($this->db->error()); |
162 | 162 | } |
@@ -164,7 +164,7 @@ discard block |
||
164 | 164 | /* |
165 | 165 | * Reset topic type linked to this type |
166 | 166 | */ |
167 | - $sql = 'UPATE' . ' ' . $this->db->prefix('newbb_topics') . ' SET ' . $this->keyName . '=0' . ' WHERE ' . $this->keyName . ' = ' . $object->getVar($this->keyName); |
|
167 | + $sql = 'UPATE'.' '.$this->db->prefix('newbb_topics').' SET '.$this->keyName.'=0'.' WHERE '.$this->keyName.' = '.$object->getVar($this->keyName); |
|
168 | 168 | if (false === ($result = $this->db->{$queryFunc}($sql))) { |
169 | 169 | //xoops_error($this->db->error()); |
170 | 170 | } |
@@ -183,11 +183,11 @@ discard block |
||
183 | 183 | public function cleanOrphan($table_link = '', $field_link = '', $field_object = '') //cleanOrphan() |
184 | 184 | { |
185 | 185 | /* clear forum-type links */ |
186 | - $sql = 'DELETE FROM ' . $this->db->prefix('newbb_type_forum') . " WHERE ({$this->keyName} NOT IN ( SELECT DISTINCT {$this->keyName} FROM {$this->table}) )"; |
|
186 | + $sql = 'DELETE FROM '.$this->db->prefix('newbb_type_forum')." WHERE ({$this->keyName} NOT IN ( SELECT DISTINCT {$this->keyName} FROM {$this->table}) )"; |
|
187 | 187 | $this->db->queryF($sql); |
188 | 188 | |
189 | 189 | /* reconcile topic-type link */ |
190 | - $sql = 'UPATE ' . $this->db->prefix('newbb_topics') . " SET {$this->keyName} = 0" . " WHERE ({$this->keyName} NOT IN ( SELECT DISTINCT {$this->keyName} FROM {$this->table}) )"; |
|
190 | + $sql = 'UPATE '.$this->db->prefix('newbb_topics')." SET {$this->keyName} = 0"." WHERE ({$this->keyName} NOT IN ( SELECT DISTINCT {$this->keyName} FROM {$this->table}) )"; |
|
191 | 191 | $this->db->queryF($sql); |
192 | 192 | |
193 | 193 | return true; |
@@ -42,14 +42,14 @@ discard block |
||
42 | 42 | $forums = (is_array($forums) ? array_filter(array_map('intval', array_map('trim', $forums))) : (empty($forums) ? 0 : [(int)$forums])); |
43 | 43 | |
44 | 44 | $sql = ' SELECT o.type_id, o.type_name, o.type_color, l.type_order' |
45 | - . ' FROM ' |
|
46 | - . $this->db->prefix('newbb_type_forum') |
|
47 | - . ' AS l ' |
|
48 | - . " LEFT JOIN {$this->table} AS o ON o.{$this->keyName} = l.{$this->keyName} " |
|
49 | - . ' WHERE ' |
|
50 | - . ' l.forum_id ' |
|
51 | - . (empty($forums) ? 'IS NOT NULL' : 'IN (' . implode(', ', $forums) . ')') |
|
52 | - . ' ORDER BY l.type_order ASC'; |
|
45 | + . ' FROM ' |
|
46 | + . $this->db->prefix('newbb_type_forum') |
|
47 | + . ' AS l ' |
|
48 | + . " LEFT JOIN {$this->table} AS o ON o.{$this->keyName} = l.{$this->keyName} " |
|
49 | + . ' WHERE ' |
|
50 | + . ' l.forum_id ' |
|
51 | + . (empty($forums) ? 'IS NOT NULL' : 'IN (' . implode(', ', $forums) . ')') |
|
52 | + . ' ORDER BY l.type_order ASC'; |
|
53 | 53 | if (false === ($result = $this->db->query($sql))) { |
54 | 54 | //xoops_error($this->db->error()); |
55 | 55 | return $ret; |
@@ -105,7 +105,7 @@ discard block |
||
105 | 105 | |
106 | 106 | if (!empty($types_valid)) { |
107 | 107 | $sql = 'DELETE FROM ' . $this->db->prefix('newbb_type_forum') . ' WHERE ' . ' forum_id = ' . $forum_id . ' AND ' . // irmtfan bug fix: delete other forums types when update the type for a specific forum |
108 | - " {$this->keyName} NOT IN (" . implode(', ', $types_valid) . ')'; |
|
108 | + " {$this->keyName} NOT IN (" . implode(', ', $types_valid) . ')'; |
|
109 | 109 | if (false === ($result = $this->db->queryF($sql))) { |
110 | 110 | } |
111 | 111 | } |
@@ -50,7 +50,7 @@ |
||
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 |
@@ -50,7 +50,7 @@ discard block |
||
50 | 50 | { |
51 | 51 | if (!isset($this->_handler[$name])) { |
52 | 52 | // require_once __DIR__ . "/permission.{$name}.php"; |
53 | - $className = '\\XoopsModules\\Newbb\\Permission' . ucfirst($name) . 'Handler'; |
|
53 | + $className = '\\XoopsModules\\Newbb\\Permission'.ucfirst($name).'Handler'; |
|
54 | 54 | $this->_handler[$name] = new $className($this->db); |
55 | 55 | } |
56 | 56 | |
@@ -377,7 +377,7 @@ discard block |
||
377 | 377 | $criteria->add(new \Criteria('gperm_groupid', $groupid)); |
378 | 378 | $criteria->add(new \Criteria('gperm_itemid', $itemid)); |
379 | 379 | $criteria->add(new \Criteria('gperm_modid', $mid)); |
380 | - $permsObject =& $this->getObjects($criteria); |
|
380 | + $permsObject = & $this->getObjects($criteria); |
|
381 | 381 | if (!empty($permsObject)) { |
382 | 382 | foreach ($permsObject as $permObject) { |
383 | 383 | $this->delete($permObject); |
@@ -82,7 +82,7 @@ |
||
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 | } |
@@ -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,18 +79,18 @@ 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 | } |
@@ -98,7 +98,7 @@ discard block |
||
98 | 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'); |
@@ -37,13 +37,13 @@ discard block |
||
37 | 37 | //check for minimum XOOPS version |
38 | 38 | $currentVer = substr(XOOPS_VERSION, 6); // get the numeric part of string |
39 | 39 | if (null === $requiredVer) { |
40 | - $requiredVer = '' . $module->getInfo('min_xoops'); //making sure it's a string |
|
40 | + $requiredVer = ''.$module->getInfo('min_xoops'); //making sure it's a string |
|
41 | 41 | } |
42 | 42 | $success = true; |
43 | 43 | |
44 | 44 | if (version_compare($currentVer, $requiredVer, '<')) { |
45 | 45 | $success = false; |
46 | - $module->setErrors(sprintf(constant('CO_' . $moduleDirNameUpper . '_ERROR_BAD_XOOPS'), $requiredVer, $currentVer)); |
|
46 | + $module->setErrors(sprintf(constant('CO_'.$moduleDirNameUpper.'_ERROR_BAD_XOOPS'), $requiredVer, $currentVer)); |
|
47 | 47 | } |
48 | 48 | |
49 | 49 | return $success; |
@@ -66,7 +66,7 @@ discard block |
||
66 | 66 | $reqVer = $module->getInfo('min_php'); |
67 | 67 | if (false !== $reqVer && '' !== $reqVer) { |
68 | 68 | if (version_compare($verNum, $reqVer, '<')) { |
69 | - $module->setErrors(sprintf(constant('CO_' . $moduleDirNameUpper . '_ERROR_BAD_PHP'), $reqVer, $verNum)); |
|
69 | + $module->setErrors(sprintf(constant('CO_'.$moduleDirNameUpper.'_ERROR_BAD_PHP'), $reqVer, $verNum)); |
|
70 | 70 | $success = false; |
71 | 71 | } |
72 | 72 | } |
@@ -32,7 +32,7 @@ discard block |
||
32 | 32 | throw new \RuntimeException(sprintf('Unable to create the %s directory', $folder)); |
33 | 33 | } |
34 | 34 | |
35 | - file_put_contents($folder . '/index.html', '<script>history.go(-1);</script>'); |
|
35 | + file_put_contents($folder.'/index.html', '<script>history.go(-1);</script>'); |
|
36 | 36 | } |
37 | 37 | } catch (\Exception $e) { |
38 | 38 | echo 'Caught exception: ', $e->getMessage(), "\n", '<br>'; |
@@ -60,10 +60,10 @@ discard block |
||
60 | 60 | if (!mkdir($dst) && !is_dir($dst)) { |
61 | 61 | while (false !== ($file = readdir($dir))) { |
62 | 62 | if (('.' !== $file) && ('..' !== $file)) { |
63 | - if (is_dir($src . '/' . $file)) { |
|
64 | - self::recurseCopy($src . '/' . $file, $dst . '/' . $file); |
|
63 | + if (is_dir($src.'/'.$file)) { |
|
64 | + self::recurseCopy($src.'/'.$file, $dst.'/'.$file); |
|
65 | 65 | } else { |
66 | - copy($src . '/' . $file, $dst . '/' . $file); |
|
66 | + copy($src.'/'.$file, $dst.'/'.$file); |
|
67 | 67 | } |
68 | 68 | } |
69 | 69 | } |
@@ -158,7 +158,7 @@ discard block |
||
158 | 158 | self::rrmdir($fObj->getPathname()); |
159 | 159 | } |
160 | 160 | } |
161 | - $iterator = null; // clear iterator Obj to close file/directory |
|
161 | + $iterator = null; // clear iterator Obj to close file/directory |
|
162 | 162 | return rmdir($src); // remove the directory & return results |
163 | 163 | } |
164 | 164 | |
@@ -191,14 +191,14 @@ discard block |
||
191 | 191 | $iterator = new \DirectoryIterator($src); |
192 | 192 | foreach ($iterator as $fObj) { |
193 | 193 | if ($fObj->isFile()) { |
194 | - rename($fObj->getPathname(), "{$dest}/" . $fObj->getFilename()); |
|
194 | + rename($fObj->getPathname(), "{$dest}/".$fObj->getFilename()); |
|
195 | 195 | } elseif (!$fObj->isDot() && $fObj->isDir()) { |
196 | 196 | // Try recursively on directory |
197 | - self::rmove($fObj->getPathname(), "{$dest}/" . $fObj->getFilename()); |
|
197 | + self::rmove($fObj->getPathname(), "{$dest}/".$fObj->getFilename()); |
|
198 | 198 | // rmdir($fObj->getPath()); // now delete the directory |
199 | 199 | } |
200 | 200 | } |
201 | - $iterator = null; // clear iterator Obj to close file/directory |
|
201 | + $iterator = null; // clear iterator Obj to close file/directory |
|
202 | 202 | return rmdir($src); // remove the directory & return results |
203 | 203 | } |
204 | 204 | |
@@ -234,9 +234,9 @@ discard block |
||
234 | 234 | $iterator = new \DirectoryIterator($src); |
235 | 235 | foreach ($iterator as $fObj) { |
236 | 236 | if ($fObj->isFile()) { |
237 | - copy($fObj->getPathname(), "{$dest}/" . $fObj->getFilename()); |
|
237 | + copy($fObj->getPathname(), "{$dest}/".$fObj->getFilename()); |
|
238 | 238 | } elseif (!$fObj->isDot() && $fObj->isDir()) { |
239 | - self::rcopy($fObj->getPathname(), "{$dest}/" . $fObj->getFilename()); |
|
239 | + self::rcopy($fObj->getPathname(), "{$dest}/".$fObj->getFilename()); |
|
240 | 240 | } |
241 | 241 | } |
242 | 242 | return true; |