@@ -663,7 +663,7 @@ |
||
| 663 | 663 | |
| 664 | 664 | protected function _processConditions($key, $value, $context, $schema = null, $glue = 'AND') |
| 665 | 665 | { |
| 666 | - $constraintTypes =& $this->_constraintTypes; |
|
| 666 | + $constraintTypes = & $this->_constraintTypes; |
|
| 667 | 667 | $model = $context->model(); |
| 668 | 668 | $models = $context->models(); |
| 669 | 669 | |
@@ -1466,7 +1466,7 @@ |
||
| 1466 | 1466 | |
| 1467 | 1467 | return [ |
| 1468 | 1468 | 'first' => function($self, $params, $chain) { |
| 1469 | - $options =& $params['options']; |
|
| 1469 | + $options = & $params['options']; |
|
| 1470 | 1470 | $options['limit'] = 1; |
| 1471 | 1471 | $data = $chain->next($self, $params, $chain); |
| 1472 | 1472 | |
@@ -6,10 +6,10 @@ discard block |
||
| 6 | 6 | |
| 7 | 7 | class Games |
| 8 | 8 | { |
| 9 | - const REQID_FOUND = 1; // Request id found and release was updated. |
|
| 10 | - const REQID_NO_LOCAL = -1; // Request id was not found via local lookup. |
|
| 9 | + const REQID_FOUND = 1; // Request id found and release was updated. |
|
| 10 | + const REQID_NO_LOCAL = -1; // Request id was not found via local lookup. |
|
| 11 | 11 | const REQID_NONE = -3; // The Request id was not found locally or via web lookup. |
| 12 | - const REQID_UNPROCESSED = 0; // Release has not been processed. |
|
| 12 | + const REQID_UNPROCESSED = 0; // Release has not been processed. |
|
| 13 | 13 | const REQID_ZERO = -2; // The Request id was 0. |
| 14 | 14 | |
| 15 | 15 | /** |
@@ -417,7 +417,7 @@ discard block |
||
| 417 | 417 | $this->_classUsed = "steam"; |
| 418 | 418 | $this->_getGame->cookie = $this->cookie; |
| 419 | 419 | $this->_getGame->searchTerm = $gameInfo['title']; |
| 420 | - if($this->_getGame->search() !== false){ |
|
| 420 | + if ($this->_getGame->search() !== false) { |
|
| 421 | 421 | $this->_gameResults = $this->_getGame->getAll(); |
| 422 | 422 | } |
| 423 | 423 | if (count($this->_gameResults) < 1) { |
@@ -444,10 +444,10 @@ discard block |
||
| 444 | 444 | return false; |
| 445 | 445 | } |
| 446 | 446 | } |
| 447 | - if(empty($this->_gameResults['title'])){ |
|
| 447 | + if (empty($this->_gameResults['title'])) { |
|
| 448 | 448 | return false; |
| 449 | 449 | } |
| 450 | - if(!is_array($this->_gameResults)){ |
|
| 450 | + if (!is_array($this->_gameResults)) { |
|
| 451 | 451 | return false; |
| 452 | 452 | } |
| 453 | 453 | if (count($this->_gameResults) > 1) { |
@@ -636,14 +636,14 @@ discard block |
||
| 636 | 636 | if (empty($con['title'])) { |
| 637 | 637 | $con['title'] = $gameInfo['title']; |
| 638 | 638 | } |
| 639 | - if(!isset($con['releasedate'])){ |
|
| 639 | + if (!isset($con['releasedate'])) { |
|
| 640 | 640 | $con['releasedate'] = ""; |
| 641 | 641 | } |
| 642 | 642 | |
| 643 | 643 | if ($con['releasedate'] == "''") { |
| 644 | 644 | $con['releasedate'] = ""; |
| 645 | 645 | } |
| 646 | - if(!isset($con['review'])){ |
|
| 646 | + if (!isset($con['review'])) { |
|
| 647 | 647 | $con['review'] = 'No Review'; |
| 648 | 648 | } |
| 649 | 649 | $con['classused'] = $this->_classUsed; |
@@ -730,17 +730,17 @@ discard block |
||
| 730 | 730 | $this->pdo->log->primary($con['title']) |
| 731 | 731 | ); |
| 732 | 732 | } |
| 733 | - if($con['cover'] === 1){ |
|
| 733 | + if ($con['cover'] === 1) { |
|
| 734 | 734 | $con['cover'] = $ri->saveImage($gamesId, $con['coverurl'], $this->imgSavePath, 250, 250); |
| 735 | 735 | } |
| 736 | - if($con['backdrop'] === 1){ |
|
| 736 | + if ($con['backdrop'] === 1) { |
|
| 737 | 737 | $con['backdrop'] = $ri->saveImage($gamesId . '-backdrop', $con['backdropurl'], $this->imgSavePath, 1920, 1024); |
| 738 | 738 | } |
| 739 | 739 | } else { |
| 740 | 740 | if ($this->echoOutput) { |
| 741 | 741 | $this->pdo->log->doEcho( |
| 742 | 742 | $this->pdo->log->headerOver("Nothing to update: ") . |
| 743 | - $this->pdo->log->primary($con['title'] . ' (PC)' ) |
|
| 743 | + $this->pdo->log->primary($con['title'] . ' (PC)') |
|
| 744 | 744 | ); |
| 745 | 745 | } |
| 746 | 746 | } |
@@ -856,7 +856,7 @@ discard block |
||
| 856 | 856 | if ($this->echoOutput) { |
| 857 | 857 | $this->pdo->log->doEcho( |
| 858 | 858 | $this->pdo->log->headerOver('Looking up: ') . |
| 859 | - $this->pdo->log->primary($gameInfo['title'] . ' (PC)' ) |
|
| 859 | + $this->pdo->log->primary($gameInfo['title'] . ' (PC)') |
|
| 860 | 860 | ); |
| 861 | 861 | } |
| 862 | 862 | |
@@ -870,7 +870,7 @@ discard block |
||
| 870 | 870 | $gameId = -2; |
| 871 | 871 | |
| 872 | 872 | // Leave gamesinfo_id 0 to parse again |
| 873 | - if($this->maxHitRequest === true){ |
|
| 873 | + if ($this->maxHitRequest === true) { |
|
| 874 | 874 | $gameId = 0; |
| 875 | 875 | } |
| 876 | 876 | } |
@@ -942,7 +942,7 @@ discard block |
||
| 942 | 942 | $result['title'] = $dlc[0]; |
| 943 | 943 | } |
| 944 | 944 | } |
| 945 | - if(empty($result['title'])){ |
|
| 945 | + if (empty($result['title'])) { |
|
| 946 | 946 | return false; |
| 947 | 947 | } |
| 948 | 948 | $browseNode = '94'; |
@@ -1010,7 +1010,7 @@ discard block |
||
| 1010 | 1010 | break; |
| 1011 | 1011 | } |
| 1012 | 1012 | } |
| 1013 | - if(empty($genreName)){ |
|
| 1013 | + if (empty($genreName)) { |
|
| 1014 | 1014 | $genreName = $tmpGenre[0]; |
| 1015 | 1015 | } |
| 1016 | 1016 | } else { |
@@ -30,14 +30,14 @@ |
||
| 30 | 30 | * |
| 31 | 31 | * @return array|bool |
| 32 | 32 | */ |
| 33 | - public function getEpisodeInfoByName($showtitle, $fullep, $epabsolute='0') |
|
| 33 | + public function getEpisodeInfoByName($showtitle, $fullep, $epabsolute = '0') |
|
| 34 | 34 | { |
| 35 | 35 | $db = new Settings(); |
| 36 | 36 | |
| 37 | - if($epabsolute == '0') //as string - not int. |
|
| 38 | - if(!preg_match('/[21]\d{3}\/\d{2}\/\d{2}/', $fullep)) |
|
| 37 | + if ($epabsolute == '0') //as string - not int. |
|
| 38 | + if (!preg_match('/[21]\d{3}\/\d{2}\/\d{2}/', $fullep)) |
|
| 39 | 39 | $additionalSql = sprintf('AND fullep = %s', $db->escapeString($fullep)); |
| 40 | - else $additionalSql = sprintf('AND airdate LIKE %s', $db->escapeString($fullep.' %')); |
|
| 40 | + else $additionalSql = sprintf('AND airdate LIKE %s', $db->escapeString($fullep . ' %')); |
|
| 41 | 41 | else $additionalSql = sprintf('AND epabsolute = %s', $db->escapeString($epabsolute)); |
| 42 | 42 | |
| 43 | 43 | return $db->queryOneRow(sprintf('SELECT * FROM episodeinfo WHERE showtitle = %s %s', $db->escapeString($showtitle), $additionalSql)); |
@@ -22,8 +22,7 @@ discard block |
||
| 22 | 22 | */ |
| 23 | 23 | public function getState($code = 0) |
| 24 | 24 | { |
| 25 | - $states = array |
|
| 26 | - ( |
|
| 25 | + $states = array( |
|
| 27 | 26 | 0 => 'Waiting', |
| 28 | 27 | 1 => 'Downloading', |
| 29 | 28 | 2 => 'Waiting for save', |
@@ -89,8 +88,7 @@ discard block |
||
| 89 | 88 | $data = $user->getById($user->currentUserId()); |
| 90 | 89 | $url = sprintf("%sgetnzb/%s.nzb&i=%s&r=%s", $host, $nzb, $data['id'], $data['rsstoken']); |
| 91 | 90 | |
| 92 | - $params = array |
|
| 93 | - ( |
|
| 91 | + $params = array( |
|
| 94 | 92 | 'sessionid' => $this->session, |
| 95 | 93 | 'url' => $url |
| 96 | 94 | ); |
@@ -252,8 +250,7 @@ discard block |
||
| 252 | 250 | $hash = hash('sha256', sprintf("%s:%s:%s", $this->nonce, $cnonce, $data['nzbvortex_api_key']), true); |
| 253 | 251 | $hash = base64_encode($hash); |
| 254 | 252 | |
| 255 | - $params = array |
|
| 256 | - ( |
|
| 253 | + $params = array( |
|
| 257 | 254 | 'nonce' => $this->nonce, |
| 258 | 255 | 'cnonce' => $cnonce, |
| 259 | 256 | 'hash' => $hash |
@@ -70,7 +70,7 @@ discard block |
||
| 70 | 70 | /** |
| 71 | 71 | * @param array $options Class instances / Echo to cli. |
| 72 | 72 | */ |
| 73 | - public function __construct(array $options =[]) |
|
| 73 | + public function __construct(array $options = []) |
|
| 74 | 74 | { |
| 75 | 75 | $defaults = [ |
| 76 | 76 | 'Echo' => false, |
@@ -376,7 +376,7 @@ discard block |
||
| 376 | 376 | */ |
| 377 | 377 | public function processBookReleases() |
| 378 | 378 | { |
| 379 | - $bookids =[]; |
|
| 379 | + $bookids = []; |
|
| 380 | 380 | if (preg_match('/^\d+$/', $this->bookreqids)) { |
| 381 | 381 | $bookids[] = $this->bookreqids; |
| 382 | 382 | } else { |
@@ -523,7 +523,7 @@ discard block |
||
| 523 | 523 | { |
| 524 | 524 | $ri = new ReleaseImage($this->pdo); |
| 525 | 525 | |
| 526 | - $book =[]; |
|
| 526 | + $book = []; |
|
| 527 | 527 | |
| 528 | 528 | $amaz = false; |
| 529 | 529 | if ($bookInfo != '') { |
@@ -209,7 +209,7 @@ discard block |
||
| 209 | 209 | } |
| 210 | 210 | if ($matches['req'] !== 'N/A' && preg_match('/^(?P<req>\d+):(?P<group>.+)$/i', $matches['req'], $matches2)) { |
| 211 | 211 | $this->_curPre['reqid'] = $matches2['req']; |
| 212 | - $this->_curPre['group_id'] = $this->_getGroupID($matches2['group']); |
|
| 212 | + $this->_curPre['group_id'] = $this->_getGroupID($matches2['group']); |
|
| 213 | 213 | } |
| 214 | 214 | if ($matches['size'] !== 'N/A') { |
| 215 | 215 | $this->_curPre['size'] = $matches['size']; |
@@ -275,28 +275,28 @@ discard block |
||
| 275 | 275 | |
| 276 | 276 | $query = 'INSERT INTO predb ('; |
| 277 | 277 | |
| 278 | - $query .= (!empty($this->_curPre['size']) ? 'size, ' : ''); |
|
| 279 | - $query .= (!empty($this->_curPre['category']) ? 'category, ' : ''); |
|
| 280 | - $query .= (!empty($this->_curPre['source']) ? 'source, ' : ''); |
|
| 281 | - $query .= (!empty($this->_curPre['reason']) ? 'nukereason, ' : ''); |
|
| 282 | - $query .= (!empty($this->_curPre['files']) ? 'files, ' : ''); |
|
| 283 | - $query .= (!empty($this->_curPre['reqid']) ? 'requestid, ' : ''); |
|
| 284 | - $query .= (!empty($this->_curPre['group_id']) ? 'groups_id, ' : ''); |
|
| 285 | - $query .= (!empty($this->_curPre['nuked']) ? 'nuked, ' : ''); |
|
| 286 | - $query .= (!empty($this->_curPre['filename']) ? 'filename, ' : ''); |
|
| 278 | + $query .= (!empty($this->_curPre['size']) ? 'size, ' : ''); |
|
| 279 | + $query .= (!empty($this->_curPre['category']) ? 'category, ' : ''); |
|
| 280 | + $query .= (!empty($this->_curPre['source']) ? 'source, ' : ''); |
|
| 281 | + $query .= (!empty($this->_curPre['reason']) ? 'nukereason, ' : ''); |
|
| 282 | + $query .= (!empty($this->_curPre['files']) ? 'files, ' : ''); |
|
| 283 | + $query .= (!empty($this->_curPre['reqid']) ? 'requestid, ' : ''); |
|
| 284 | + $query .= (!empty($this->_curPre['group_id']) ? 'groups_id, ' : ''); |
|
| 285 | + $query .= (!empty($this->_curPre['nuked']) ? 'nuked, ' : ''); |
|
| 286 | + $query .= (!empty($this->_curPre['filename']) ? 'filename, ' : ''); |
|
| 287 | 287 | |
| 288 | 288 | $query .= 'predate, title) VALUES ('; |
| 289 | 289 | |
| 290 | - $query .= (!empty($this->_curPre['size']) ? $this->_pdo->escapeString($this->_curPre['size']) . ', ' : ''); |
|
| 291 | - $query .= (!empty($this->_curPre['category']) ? $this->_pdo->escapeString($this->_curPre['category']) . ', ' : ''); |
|
| 292 | - $query .= (!empty($this->_curPre['source']) ? $this->_pdo->escapeString($this->_curPre['source']) . ', ' : ''); |
|
| 293 | - $query .= (!empty($this->_curPre['reason']) ? $this->_pdo->escapeString($this->_curPre['reason']) . ', ' : ''); |
|
| 294 | - $query .= (!empty($this->_curPre['files']) ? $this->_pdo->escapeString($this->_curPre['files']) . ', ' : ''); |
|
| 295 | - $query .= (!empty($this->_curPre['reqid']) ? $this->_curPre['reqid'] . ', ' : ''); |
|
| 296 | - $query .= (!empty($this->_curPre['group_id']) ? $this->_curPre['group_id'] . ', ' : ''); |
|
| 297 | - $query .= (!empty($this->_curPre['nuked']) ? $this->_curPre['nuked'] . ', ' : ''); |
|
| 298 | - $query .= (!empty($this->_curPre['filename']) ? $this->_pdo->escapeString($this->_curPre['filename']) . ', ' : ''); |
|
| 299 | - $query .= (!empty($this->_curPre['predate']) ? $this->_curPre['predate'] . ', ' : 'NOW(), '); |
|
| 290 | + $query .= (!empty($this->_curPre['size']) ? $this->_pdo->escapeString($this->_curPre['size']) . ', ' : ''); |
|
| 291 | + $query .= (!empty($this->_curPre['category']) ? $this->_pdo->escapeString($this->_curPre['category']) . ', ' : ''); |
|
| 292 | + $query .= (!empty($this->_curPre['source']) ? $this->_pdo->escapeString($this->_curPre['source']) . ', ' : ''); |
|
| 293 | + $query .= (!empty($this->_curPre['reason']) ? $this->_pdo->escapeString($this->_curPre['reason']) . ', ' : ''); |
|
| 294 | + $query .= (!empty($this->_curPre['files']) ? $this->_pdo->escapeString($this->_curPre['files']) . ', ' : ''); |
|
| 295 | + $query .= (!empty($this->_curPre['reqid']) ? $this->_curPre['reqid'] . ', ' : ''); |
|
| 296 | + $query .= (!empty($this->_curPre['group_id']) ? $this->_curPre['group_id'] . ', ' : ''); |
|
| 297 | + $query .= (!empty($this->_curPre['nuked']) ? $this->_curPre['nuked'] . ', ' : ''); |
|
| 298 | + $query .= (!empty($this->_curPre['filename']) ? $this->_pdo->escapeString($this->_curPre['filename']) . ', ' : ''); |
|
| 299 | + $query .= (!empty($this->_curPre['predate']) ? $this->_curPre['predate'] . ', ' : 'NOW(), '); |
|
| 300 | 300 | |
| 301 | 301 | $query .= '%s)'; |
| 302 | 302 | |
@@ -325,26 +325,26 @@ discard block |
||
| 325 | 325 | |
| 326 | 326 | $query = 'UPDATE predb SET '; |
| 327 | 327 | |
| 328 | - $query .= (!empty($this->_curPre['size']) ? 'size = ' . $this->_pdo->escapeString($this->_curPre['size']) . ', ' : ''); |
|
| 329 | - $query .= (!empty($this->_curPre['source']) ? 'source = ' . $this->_pdo->escapeString($this->_curPre['source']) . ', ' : ''); |
|
| 330 | - $query .= (!empty($this->_curPre['files']) ? 'files = ' . $this->_pdo->escapeString($this->_curPre['files']) . ', ' : ''); |
|
| 331 | - $query .= (!empty($this->_curPre['reason']) ? 'nukereason = ' . $this->_pdo->escapeString($this->_curPre['reason']) . ', ' : ''); |
|
| 332 | - $query .= (!empty($this->_curPre['reqid']) ? 'requestid = ' . $this->_curPre['reqid'] . ', ' : ''); |
|
| 333 | - $query .= (!empty($this->_curPre['group_id']) ? 'groups_id = ' . $this->_curPre['group_id'] . ', ' : ''); |
|
| 334 | - $query .= (!empty($this->_curPre['predate']) ? 'predate = ' . $this->_curPre['predate'] . ', ' : ''); |
|
| 335 | - $query .= (!empty($this->_curPre['nuked']) ? 'nuked = ' . $this->_curPre['nuked'] . ', ' : ''); |
|
| 336 | - $query .= (!empty($this->_curPre['filename']) ? 'filename = ' . $this->_pdo->escapeString($this->_curPre['filename']) . ', ' : ''); |
|
| 328 | + $query .= (!empty($this->_curPre['size']) ? 'size = ' . $this->_pdo->escapeString($this->_curPre['size']) . ', ' : ''); |
|
| 329 | + $query .= (!empty($this->_curPre['source']) ? 'source = ' . $this->_pdo->escapeString($this->_curPre['source']) . ', ' : ''); |
|
| 330 | + $query .= (!empty($this->_curPre['files']) ? 'files = ' . $this->_pdo->escapeString($this->_curPre['files']) . ', ' : ''); |
|
| 331 | + $query .= (!empty($this->_curPre['reason']) ? 'nukereason = ' . $this->_pdo->escapeString($this->_curPre['reason']) . ', ' : ''); |
|
| 332 | + $query .= (!empty($this->_curPre['reqid']) ? 'requestid = ' . $this->_curPre['reqid'] . ', ' : ''); |
|
| 333 | + $query .= (!empty($this->_curPre['group_id']) ? 'groups_id = ' . $this->_curPre['group_id'] . ', ' : ''); |
|
| 334 | + $query .= (!empty($this->_curPre['predate']) ? 'predate = ' . $this->_curPre['predate'] . ', ' : ''); |
|
| 335 | + $query .= (!empty($this->_curPre['nuked']) ? 'nuked = ' . $this->_curPre['nuked'] . ', ' : ''); |
|
| 336 | + $query .= (!empty($this->_curPre['filename']) ? 'filename = ' . $this->_pdo->escapeString($this->_curPre['filename']) . ', ' : ''); |
|
| 337 | 337 | $query .= ( |
| 338 | 338 | (empty($this->_oldPre['category']) && !empty($this->_curPre['category'])) |
| 339 | 339 | ? 'category = ' . $this->_pdo->escapeString($this->_curPre['category']) . ', ' |
| 340 | 340 | : '' |
| 341 | 341 | ); |
| 342 | 342 | |
| 343 | - if ($query === 'UPDATE predb SET '){ |
|
| 343 | + if ($query === 'UPDATE predb SET ') { |
|
| 344 | 344 | return; |
| 345 | 345 | } |
| 346 | 346 | |
| 347 | - $query .= 'title = ' . $this->_pdo->escapeString($this->_curPre['title']); |
|
| 347 | + $query .= 'title = ' . $this->_pdo->escapeString($this->_curPre['title']); |
|
| 348 | 348 | $query .= ' WHERE title = ' . $this->_pdo->escapeString($this->_curPre['title']); |
| 349 | 349 | |
| 350 | 350 | $this->_pdo->ping(true); |
@@ -367,7 +367,7 @@ discard block |
||
| 367 | 367 | |
| 368 | 368 | $nukeString = ''; |
| 369 | 369 | if ($this->_nuked !== false) { |
| 370 | - switch((int)$this->_curPre['nuked']) { |
|
| 370 | + switch ((int)$this->_curPre['nuked']) { |
|
| 371 | 371 | case PreDb::PRE_NUKED: |
| 372 | 372 | $nukeString = '[ NUKED ] '; |
| 373 | 373 | break; |
@@ -67,16 +67,16 @@ discard block |
||
| 67 | 67 | * |
| 68 | 68 | * @return |
| 69 | 69 | */ |
| 70 | - public function getCommentCount($refdate=Null, $localOnly=Null) |
|
| 70 | + public function getCommentCount($refdate = Null, $localOnly = Null) |
|
| 71 | 71 | { |
| 72 | - if($refdate !== Null){ |
|
| 73 | - if(is_string($refdate)){ |
|
| 72 | + if ($refdate !== Null) { |
|
| 73 | + if (is_string($refdate)) { |
|
| 74 | 74 | // ensure we're in the right format |
| 75 | - $refdate=date("Y-m-d H:i:s", strtotime($refdate)); |
|
| 76 | - }else if(is_int($refdate)){ |
|
| 75 | + $refdate = date("Y-m-d H:i:s", strtotime($refdate)); |
|
| 76 | + } else if (is_int($refdate)) { |
|
| 77 | 77 | // ensure we're in the right format |
| 78 | - $refdate=date("Y-m-d H:i:s", $refdate); |
|
| 79 | - }else{ |
|
| 78 | + $refdate = date("Y-m-d H:i:s", $refdate); |
|
| 79 | + } else { |
|
| 80 | 80 | // leave it as null (bad content anyhow) |
| 81 | 81 | $refdate = Null; |
| 82 | 82 | } |
@@ -84,20 +84,20 @@ discard block |
||
| 84 | 84 | |
| 85 | 85 | $q = "SELECT count(id) AS num FROM release_comments"; |
| 86 | 86 | $clause = []; |
| 87 | - if($refdate !== Null) |
|
| 87 | + if ($refdate !== Null) |
|
| 88 | 88 | $clause[] = "createddate >= '$refdate'"; |
| 89 | 89 | |
| 90 | 90 | // set localOnly to Null to include both local and remote |
| 91 | 91 | // set localOnly to true to only receive local comment count |
| 92 | 92 | // set localOnly to false to only receive remote comment count |
| 93 | - if($localOnly === true){ |
|
| 93 | + if ($localOnly === true) { |
|
| 94 | 94 | $clause[] = "sourceid = 0"; |
| 95 | - }else if($localOnly === false){ |
|
| 95 | + } else if ($localOnly === false) { |
|
| 96 | 96 | $clause[] = "sourceid != 0"; |
| 97 | 97 | } |
| 98 | 98 | |
| 99 | - if(count($clause)) |
|
| 100 | - $q .= " WHERE ".implode(" AND ", $clause); |
|
| 99 | + if (count($clause)) |
|
| 100 | + $q .= " WHERE " . implode(" AND ", $clause); |
|
| 101 | 101 | |
| 102 | 102 | $res = $this->pdo->queryOneRow($q); |
| 103 | 103 | return $res["num"]; |
@@ -217,7 +217,7 @@ discard block |
||
| 217 | 217 | { |
| 218 | 218 | $this->pdo->queryExec(sprintf("update releases |
| 219 | 219 | SET comments = (SELECT count(id) FROM release_comments WHERE release_comments.gid = releases.gid AND isvisible = 1) |
| 220 | - WHERE releases.gid = %s", $this->pdo->escapeString($gid) )); |
|
| 220 | + WHERE releases.gid = %s", $this->pdo->escapeString($gid))); |
|
| 221 | 221 | } |
| 222 | 222 | |
| 223 | 223 | /** |
@@ -247,8 +247,8 @@ discard block |
||
| 247 | 247 | if ($start === false) |
| 248 | 248 | $limit = ""; |
| 249 | 249 | else |
| 250 | - $limit = " LIMIT ".$start.",".$num; |
|
| 250 | + $limit = " LIMIT " . $start . "," . $num; |
|
| 251 | 251 | |
| 252 | - return $this->pdo->query(sprintf("SELECT release_comments.*, r.guid, r.searchname, users.username FROM release_comments INNER JOIN releases r ON r.id = release_comments.releases_id LEFT OUTER JOIN users ON users.id = release_comments.users_id WHERE users_id = %d ORDER BY release_comments.createddate DESC ".$limit, $uid)); |
|
| 252 | + return $this->pdo->query(sprintf("SELECT release_comments.*, r.guid, r.searchname, users.username FROM release_comments INNER JOIN releases r ON r.id = release_comments.releases_id LEFT OUTER JOIN users ON users.id = release_comments.users_id WHERE users_id = %d ORDER BY release_comments.createddate DESC " . $limit, $uid)); |
|
| 253 | 253 | } |
| 254 | 254 | } |
@@ -78,7 +78,7 @@ discard block |
||
| 78 | 78 | */ |
| 79 | 79 | public function __construct(array $options = []) |
| 80 | 80 | { |
| 81 | - $defaults= [ |
|
| 81 | + $defaults = [ |
|
| 82 | 82 | 'Settings' => null, |
| 83 | 83 | 'NNTP' => null, |
| 84 | 84 | ]; |
@@ -548,7 +548,7 @@ discard block |
||
| 548 | 548 | if (!isset($body['USER']) || !isset($body['SID']) || !isset($body['RID']) || !isset($body['TIME']) | !isset($body['BODY'])) { |
| 549 | 549 | return false; |
| 550 | 550 | } |
| 551 | - $cid = md5($body['SID'].$body['USER'].$body['TIME'].$siteID); |
|
| 551 | + $cid = md5($body['SID'] . $body['USER'] . $body['TIME'] . $siteID); |
|
| 552 | 552 | |
| 553 | 553 | // Insert the comment. |
| 554 | 554 | if ($this->pdo->queryExec( |