@@ -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; |
@@ -70,7 +70,7 @@ |
||
| 70 | 70 | require_once $GLOBALS['xoops']->path('class/template.php'); |
| 71 | 71 | $breadcrumbTpl = new \XoopsTpl(); |
| 72 | 72 | $breadcrumbTpl->assign('breadcrumb', $this->bread); |
| 73 | - $html = $breadcrumbTpl->fetch('db:' . $this->dirname . '_common_breadcrumb.tpl'); |
|
| 73 | + $html = $breadcrumbTpl->fetch('db:'.$this->dirname.'_common_breadcrumb.tpl'); |
|
| 74 | 74 | unset($breadcrumbTpl); |
| 75 | 75 | |
| 76 | 76 | return $html; |
@@ -102,7 +102,7 @@ |
||
| 102 | 102 | $this->synchronizeTable($tableName); |
| 103 | 103 | $updateTable = $GLOBALS['xoopsDB']->prefix($tableName); |
| 104 | 104 | $joinTable = $GLOBALS['xoopsDB']->prefix($srcTableName); |
| 105 | - $sql = "UPDATE `$updateTable` t1 INNER JOIN `$joinTable` t2 ON t1.post_id = t2.post_id \n" . "SET t1.dohtml = t2.dohtml, t1.dosmiley = t2.dosmiley, t1.doxcode = t2.doxcode\n" . ' , t1.doimage = t2.doimage, t1.dobr = t2.dobr'; |
|
| 105 | + $sql = "UPDATE `$updateTable` t1 INNER JOIN `$joinTable` t2 ON t1.post_id = t2.post_id \n"."SET t1.dohtml = t2.dohtml, t1.dosmiley = t2.dosmiley, t1.doxcode = t2.doxcode\n".' , t1.doimage = t2.doimage, t1.dobr = t2.dobr'; |
|
| 106 | 106 | $this->tableHandler->addToQueue($sql); |
| 107 | 107 | } |
| 108 | 108 | } |
@@ -58,7 +58,7 @@ discard block |
||
| 58 | 58 | { |
| 59 | 59 | $id = (int)$id; |
| 60 | 60 | $post = null; |
| 61 | - $sql = 'SELECT p.*, t.* FROM ' . $this->db->prefix('newbb_posts') . ' p LEFT JOIN ' . $this->db->prefix('newbb_posts_text') . ' t ON p.post_id=t.post_id WHERE p.post_id=' . $id; |
|
| 61 | + $sql = 'SELECT p.*, t.* FROM '.$this->db->prefix('newbb_posts').' p LEFT JOIN '.$this->db->prefix('newbb_posts_text').' t ON p.post_id=t.post_id WHERE p.post_id='.$id; |
|
| 62 | 62 | if ($array = $this->db->fetchArray($this->db->query($sql))) { |
| 63 | 63 | $post = $this->create(false); |
| 64 | 64 | $post->assignVars($array); |
@@ -87,7 +87,7 @@ discard block |
||
| 87 | 87 | $topic_id = 0, |
| 88 | 88 | $approved = 1 |
| 89 | 89 | ) { |
| 90 | - $sql = 'SELECT p.*, t.*, tp.topic_status FROM ' |
|
| 90 | + $sql = 'SELECT p.*, t.*, tp.topic_status FROM ' |
|
| 91 | 91 | . $this->db->prefix('newbb_posts') |
| 92 | 92 | . ' p LEFT JOIN ' |
| 93 | 93 | . $this->db->prefix('newbb_posts_text') |
@@ -380,14 +380,14 @@ discard block |
||
| 380 | 380 | |
| 381 | 381 | /* Set active post as deleted */ |
| 382 | 382 | if ($post->getVar('approved') > 0 && empty($force)) { |
| 383 | - $sql = 'UPDATE ' . $this->db->prefix('newbb_posts') . ' SET approved = -1 WHERE post_id = ' . $post->getVar('post_id'); |
|
| 383 | + $sql = 'UPDATE '.$this->db->prefix('newbb_posts').' SET approved = -1 WHERE post_id = '.$post->getVar('post_id'); |
|
| 384 | 384 | if (!$result = $this->db->queryF($sql)) { |
| 385 | 385 | } |
| 386 | 386 | /* delete pending post directly */ |
| 387 | 387 | } else { |
| 388 | 388 | $sql = sprintf('DELETE FROM `%s` WHERE post_id = %u', $this->db->prefix('newbb_posts'), $post->getVar('post_id')); |
| 389 | 389 | if (!$result = $this->db->queryF($sql)) { |
| 390 | - $post->setErrors('delete post error: ' . $sql); |
|
| 390 | + $post->setErrors('delete post error: '.$sql); |
|
| 391 | 391 | |
| 392 | 392 | return false; |
| 393 | 393 | } |
@@ -395,7 +395,7 @@ discard block |
||
| 395 | 395 | |
| 396 | 396 | $sql = sprintf('DELETE FROM %s WHERE post_id = %u', $this->db->prefix('newbb_posts_text'), $post->getVar('post_id')); |
| 397 | 397 | if (!$result = $this->db->queryF($sql)) { |
| 398 | - $post->setErrors('Could not remove post text: ' . $sql); |
|
| 398 | + $post->setErrors('Could not remove post text: '.$sql); |
|
| 399 | 399 | |
| 400 | 400 | return false; |
| 401 | 401 | } |
@@ -432,11 +432,11 @@ discard block |
||
| 432 | 432 | } |
| 433 | 433 | } |
| 434 | 434 | } else { |
| 435 | - $sql = 'UPDATE ' . $this->db->prefix('newbb_topics') . ' t |
|
| 436 | - LEFT JOIN ' . $this->db->prefix('newbb_posts') . ' p ON p.topic_id = t.topic_id |
|
| 435 | + $sql = 'UPDATE '.$this->db->prefix('newbb_topics').' t |
|
| 436 | + LEFT JOIN ' . $this->db->prefix('newbb_posts').' p ON p.topic_id = t.topic_id |
|
| 437 | 437 | SET t.topic_last_post_id = p.post_id |
| 438 | - WHERE t.topic_last_post_id = ' . $post->getVar('post_id') . ' |
|
| 439 | - AND p.post_id = (SELECT MAX(post_id) FROM ' . $this->db->prefix('newbb_posts') . ' WHERE topic_id=t.topic_id)'; |
|
| 438 | + WHERE t.topic_last_post_id = ' . $post->getVar('post_id').' |
|
| 439 | + AND p.post_id = (SELECT MAX(post_id) FROM ' . $this->db->prefix('newbb_posts').' WHERE topic_id=t.topic_id)'; |
|
| 440 | 440 | if (!$result = $this->db->queryF($sql)) { |
| 441 | 441 | } |
| 442 | 442 | } |
@@ -458,7 +458,7 @@ discard block |
||
| 458 | 458 | } |
| 459 | 459 | // irmtfan - just update the pid for approved posts when the post is not topic (pid=0) |
| 460 | 460 | if (!$post->isTopic()) { |
| 461 | - $sql = 'UPDATE ' . $this->db->prefix('newbb_posts') . ' SET pid = ' . $post->getVar('pid') . ' WHERE approved=1 AND pid=' . $post->getVar('post_id'); |
|
| 461 | + $sql = 'UPDATE '.$this->db->prefix('newbb_posts').' SET pid = '.$post->getVar('pid').' WHERE approved=1 AND pid='.$post->getVar('post_id'); |
|
| 462 | 462 | if (!$result = $this->db->queryF($sql)) { |
| 463 | 463 | //xoops_error($this->db->error()); |
| 464 | 464 | } |
@@ -482,12 +482,12 @@ discard block |
||
| 482 | 482 | return parent::getCount($criteria); |
| 483 | 483 | } |
| 484 | 484 | |
| 485 | - $sql = 'SELECT COUNT(*) as count' . ' FROM ' . $this->db->prefix('newbb_posts') . ' AS p' . ' LEFT JOIN ' . $this->db->prefix('newbb_posts_text') . ' AS t ON t.post_id = p.post_id'; |
|
| 485 | + $sql = 'SELECT COUNT(*) as count'.' FROM '.$this->db->prefix('newbb_posts').' AS p'.' LEFT JOIN '.$this->db->prefix('newbb_posts_text').' AS t ON t.post_id = p.post_id'; |
|
| 486 | 486 | // LEFT JOIN |
| 487 | 487 | $sql .= $join; |
| 488 | 488 | // WHERE |
| 489 | 489 | if (isset($criteria) && is_subclass_of($criteria, 'CriteriaElement')) { |
| 490 | - $sql .= ' ' . $criteria->renderWhere(); |
|
| 490 | + $sql .= ' '.$criteria->renderWhere(); |
|
| 491 | 491 | } |
| 492 | 492 | if (!$result = $this->db->query($sql)) { |
| 493 | 493 | //xoops_error($this->db->error().'<br>'.$sql); |
@@ -512,14 +512,14 @@ discard block |
||
| 512 | 512 | public function getPostsByLimit($criteria = null, $limit = 1, $start = 0, $join = null) |
| 513 | 513 | { |
| 514 | 514 | $ret = []; |
| 515 | - $sql = 'SELECT p.*, t.* ' . ' FROM ' . $this->db->prefix('newbb_posts') . ' AS p' . ' LEFT JOIN ' . $this->db->prefix('newbb_posts_text') . ' AS t ON t.post_id = p.post_id'; |
|
| 515 | + $sql = 'SELECT p.*, t.* '.' FROM '.$this->db->prefix('newbb_posts').' AS p'.' LEFT JOIN '.$this->db->prefix('newbb_posts_text').' AS t ON t.post_id = p.post_id'; |
|
| 516 | 516 | if (!empty($join)) { |
| 517 | 517 | $sql .= $join; |
| 518 | 518 | } |
| 519 | 519 | if (isset($criteria) && is_subclass_of($criteria, 'CriteriaElement')) { |
| 520 | - $sql .= ' ' . $criteria->renderWhere(); |
|
| 520 | + $sql .= ' '.$criteria->renderWhere(); |
|
| 521 | 521 | if ('' !== $criteria->getSort()) { |
| 522 | - $sql .= ' ORDER BY ' . $criteria->getSort() . ' ' . $criteria->getOrder(); |
|
| 522 | + $sql .= ' ORDER BY '.$criteria->getSort().' '.$criteria->getOrder(); |
|
| 523 | 523 | } |
| 524 | 524 | } |
| 525 | 525 | $result = $this->db->query($sql, (int)$limit, (int)$start); |
@@ -560,7 +560,7 @@ discard block |
||
| 560 | 560 | parent::cleanOrphan($this->db->prefix('newbb_topics'), 'topic_id'); |
| 561 | 561 | parent::cleanOrphan($this->db->prefix('newbb_posts_text'), 'post_id'); |
| 562 | 562 | |
| 563 | - $sql = 'DELETE FROM ' . $this->db->prefix('newbb_posts_text') . ' WHERE (post_id NOT IN ( SELECT DISTINCT post_id FROM ' . $this->table . ') )'; |
|
| 563 | + $sql = 'DELETE FROM '.$this->db->prefix('newbb_posts_text').' WHERE (post_id NOT IN ( SELECT DISTINCT post_id FROM '.$this->table.') )'; |
|
| 564 | 564 | if (!$result = $this->db->queryF($sql)) { |
| 565 | 565 | //xoops_error($this->db->error()); |
| 566 | 566 | return false; |