@@ -151,7 +151,7 @@ |
||
151 | 151 | 'search' => ['available' => 'yes', 'supportedParams' => 'q'], |
152 | 152 | 'tv-search' => ['available' => 'yes', 'supportedParams' => 'q,vid,tvdbid,traktid,rid,tvmazeid,imdbid,tmdbid,season,ep'], |
153 | 153 | 'movie-search' => ['available' => 'yes', 'supportedParams' => 'q,imdbid'], |
154 | - 'audio-search' => ['available' => 'no', 'supportedParams' => ''] |
|
154 | + 'audio-search' => ['available' => 'no', 'supportedParams' => ''] |
|
155 | 155 | ], |
156 | 156 | 'categories' => |
157 | 157 | ($this->type === 'caps' |
@@ -206,7 +206,7 @@ discard block |
||
206 | 206 | protected function addNode($element) |
207 | 207 | { |
208 | 208 | $this->xml->startElement($element['name']); |
209 | - foreach($element['data'] AS $attr => $val) { |
|
209 | + foreach ($element['data'] AS $attr => $val) { |
|
210 | 210 | $this->xml->writeAttribute($attr, $val); |
211 | 211 | } |
212 | 212 | $this->xml->endElement(); |
@@ -219,7 +219,7 @@ discard block |
||
219 | 219 | protected function addNodes($element) |
220 | 220 | { |
221 | 221 | $this->xml->startElement($element['name']); |
222 | - foreach($element['data'] AS $elem => $value) { |
|
222 | + foreach ($element['data'] AS $elem => $value) { |
|
223 | 223 | $subelement['name'] = $elem; |
224 | 224 | $subelement['data'] = $value; |
225 | 225 | $this->addNode($subelement); |
@@ -240,7 +240,7 @@ discard block |
||
240 | 240 | if ($p['description'] != '') { |
241 | 241 | $this->xml->writeAttribute('description', html_entity_decode($p['description'])); |
242 | 242 | } |
243 | - foreach($p['subcatlist'] AS $c) { |
|
243 | + foreach ($p['subcatlist'] AS $c) { |
|
244 | 244 | $this->xml->startElement('subcat'); |
245 | 245 | $this->xml->writeAttribute('id', $c['id']); |
246 | 246 | $this->xml->writeAttribute('name', html_entity_decode($c['title'])); |
@@ -259,7 +259,7 @@ discard block |
||
259 | 259 | */ |
260 | 260 | protected function includeRssAtom() |
261 | 261 | { |
262 | - switch($this->namespace) { |
|
262 | + switch ($this->namespace) { |
|
263 | 263 | case 'newznab': |
264 | 264 | $url = 'http://www.newznab.com/DTD/2010/feeds/attributes/'; |
265 | 265 | break; |
@@ -300,7 +300,7 @@ discard block |
||
300 | 300 | { |
301 | 301 | $server = $this->server['server']; |
302 | 302 | |
303 | - switch($this->namespace) { |
|
303 | + switch ($this->namespace) { |
|
304 | 304 | case 'newznab': |
305 | 305 | $path = 'apihelp/'; |
306 | 306 | $tag = 'API'; |
@@ -340,7 +340,7 @@ discard block |
||
340 | 340 | |
341 | 341 | public function includeTotalRows() |
342 | 342 | { |
343 | - $this->xml->startElement($this->namespace.":response"); |
|
343 | + $this->xml->startElement($this->namespace . ":response"); |
|
344 | 344 | $this->xml->writeAttribute('offset', $this->offset); |
345 | 345 | $this->xml->writeAttribute('total', isset($this->releases[0]['_totalrows']) ? $this->releases[0]['_totalrows'] : 0); |
346 | 346 | $this->xml->endElement(); |
@@ -351,7 +351,7 @@ discard block |
||
351 | 351 | */ |
352 | 352 | public function includeReleases() |
353 | 353 | { |
354 | - if(is_array($this->releases) && !empty($this->releases)) { |
|
354 | + if (is_array($this->releases) && !empty($this->releases)) { |
|
355 | 355 | foreach ($this->releases AS $this->release) { |
356 | 356 | $this->xml->startElement('item'); |
357 | 357 | $this->includeReleaseMain(); |
@@ -385,7 +385,7 @@ discard block |
||
385 | 385 | } else { |
386 | 386 | $this->writeRssCdata(); |
387 | 387 | } |
388 | - if((isset($this->parameters['dl']) && $this->parameters['dl'] == 1) || !isset($this->parameters['dl'])) { |
|
388 | + if ((isset($this->parameters['dl']) && $this->parameters['dl'] == 1) || !isset($this->parameters['dl'])) { |
|
389 | 389 | $this->xml->startElement('enclosure'); |
390 | 390 | $this->xml->writeAttribute( |
391 | 391 | 'url', |
@@ -416,7 +416,7 @@ discard block |
||
416 | 416 | if ($this->parameters['extended'] == 1) { |
417 | 417 | $this->writeZedAttr('files', $this->release['totalpart']); |
418 | 418 | $this->writeZedAttr('poster', $this->release['fromname']); |
419 | - if(($this->release['videos_id'] > 0 || $this->release['tv_episodes_id'] > 0) && $this->namespace === 'newznab') { |
|
419 | + if (($this->release['videos_id'] > 0 || $this->release['tv_episodes_id'] > 0) && $this->namespace === 'newznab') { |
|
420 | 420 | $this->setTvAttr(); |
421 | 421 | } |
422 | 422 | |
@@ -452,7 +452,7 @@ discard block |
||
452 | 452 | */ |
453 | 453 | protected function setTvAttr() |
454 | 454 | { |
455 | - switch(true) { |
|
455 | + switch (true) { |
|
456 | 456 | case !empty($this->release['title']): |
457 | 457 | $this->writeZedAttr('title', $this->release['title']); |
458 | 458 | break; |
@@ -514,7 +514,7 @@ discard block |
||
514 | 514 | $p = $this->parameters; |
515 | 515 | |
516 | 516 | $this->cdata = "\n\t<div>\n"; |
517 | - switch(1) { |
|
517 | + switch (1) { |
|
518 | 518 | case !empty($r['cover']): |
519 | 519 | $dir = 'movies'; |
520 | 520 | $column = 'imdbid'; |
@@ -618,7 +618,7 @@ discard block |
||
618 | 618 | |
619 | 619 | $cData = $this->buildCdata($musicCol); |
620 | 620 | |
621 | - if ($r['mu_url'] !== '' ) { |
|
621 | + if ($r['mu_url'] !== '') { |
|
622 | 622 | $cDataUrl = "<li>Amazon: <a href=\"{$r['mu_url']}\">{$r['mu_title']}</a></li>"; |
623 | 623 | } |
624 | 624 | |
@@ -679,7 +679,7 @@ discard block |
||
679 | 679 | $cData = ''; |
680 | 680 | |
681 | 681 | foreach ($columns AS $info) { |
682 | - if (!empty($r[$info])) { |
|
682 | + if (!empty($r[$info])) { |
|
683 | 683 | if ($info == 'mu_releasedate') { |
684 | 684 | $ucInfo = 'Released'; |
685 | 685 | $rDate = date('Y-m-d', strtotime($r[$info])); |
@@ -130,7 +130,7 @@ |
||
130 | 130 | $tsql .= sprintf("AND v.title LIKE %s", $this->pdo->escapeString("%" . $showname . "%")); |
131 | 131 | } |
132 | 132 | |
133 | - $qry = sprintf(" |
|
133 | + $qry = sprintf(" |
|
134 | 134 | SELECT v.* FROM |
135 | 135 | (SELECT v.*, |
136 | 136 | tve.firstaired AS prevdate, tve.title AS previnfo, |
@@ -75,7 +75,7 @@ discard block |
||
75 | 75 | /** |
76 | 76 | * @param array $options Class instances / Echo to cli. |
77 | 77 | */ |
78 | - public function __construct(array $options =[]) |
|
78 | + public function __construct(array $options = []) |
|
79 | 79 | { |
80 | 80 | $defaults = [ |
81 | 81 | 'Echo' => false, |
@@ -99,7 +99,7 @@ discard block |
||
99 | 99 | //$this->cleanconsole = ($this->pdo->getSetting('lookupgames') == 2) ? 'AND isrenamed = 1' : ''; |
100 | 100 | $this->catWhere = "AND categories_id BETWEEN " . Category::GAME_ROOT . " AND " . Category::GAME_OTHER; |
101 | 101 | |
102 | - $this->failCache =[]; |
|
102 | + $this->failCache = []; |
|
103 | 103 | } |
104 | 104 | |
105 | 105 | public function getConsoleInfo($id) |
@@ -321,7 +321,7 @@ discard block |
||
321 | 321 | public function makeFieldLinks($data, $field) |
322 | 322 | { |
323 | 323 | $tmpArr = explode(', ', $data[$field]); |
324 | - $newArr =[]; |
|
324 | + $newArr = []; |
|
325 | 325 | $i = 0; |
326 | 326 | foreach ($tmpArr as $ta) { |
327 | 327 | if (trim($ta) == '') { |
@@ -414,7 +414,7 @@ discard block |
||
414 | 414 | return $consoleId; |
415 | 415 | } |
416 | 416 | |
417 | - protected function _matchConToGameInfo($gameInfo =[], $con =[]) |
|
417 | + protected function _matchConToGameInfo($gameInfo = [], $con = []) |
|
418 | 418 | { |
419 | 419 | $matched = false; |
420 | 420 | |
@@ -428,7 +428,7 @@ discard block |
||
428 | 428 | similar_text(strtolower($gameInfo['platform']), strtolower($con['platform']), $platformpercent); |
429 | 429 | |
430 | 430 | if (NN_DEBUG) { |
431 | - echo(PHP_EOL ."Matched: Title Percentage 1: $titlepercent% between " . $gameInfo['title'] . " and " . $con['title'] . PHP_EOL); |
|
431 | + echo(PHP_EOL . "Matched: Title Percentage 1: $titlepercent% between " . $gameInfo['title'] . " and " . $con['title'] . PHP_EOL); |
|
432 | 432 | } |
433 | 433 | |
434 | 434 | // Since Wii Ware games and XBLA have inconsistent original platforms, as long as title is 50% its ok. |
@@ -463,7 +463,7 @@ discard block |
||
463 | 463 | |
464 | 464 | protected function _setConBeforeMatch($amaz, $gameInfo) |
465 | 465 | { |
466 | - $con =[]; |
|
466 | + $con = []; |
|
467 | 467 | $con['platform'] = (string)$amaz->Items->Item->ItemAttributes->Platform; |
468 | 468 | if (empty($con['platform'])) { |
469 | 469 | $con['platform'] = $gameInfo['platform']; |
@@ -486,7 +486,7 @@ discard block |
||
486 | 486 | |
487 | 487 | protected function _setConAfterMatch($amaz) |
488 | 488 | { |
489 | - $con =[]; |
|
489 | + $con = []; |
|
490 | 490 | $con['asin'] = (string)$amaz->Items->Item->ASIN; |
491 | 491 | |
492 | 492 | $con['url'] = (string)$amaz->Items->Item->DetailPageURL; |
@@ -501,7 +501,7 @@ discard block |
||
501 | 501 | $con['esrb'] = (string)$amaz->Items->Item->ItemAttributes->ESRBAgeRating; |
502 | 502 | $con['releasedate'] = (string)$amaz->Items->Item->ItemAttributes->ReleaseDate; |
503 | 503 | |
504 | - if(!isset($con['releasedate'])){ |
|
504 | + if (!isset($con['releasedate'])) { |
|
505 | 505 | $con['releasedate'] = ""; |
506 | 506 | } |
507 | 507 | |
@@ -587,7 +587,7 @@ discard block |
||
587 | 587 | $gen = new Genres(['Settings' => $this->pdo]); |
588 | 588 | |
589 | 589 | $defaultGenres = $gen->getGenres(Genres::CONSOLE_TYPE); |
590 | - $genreassoc =[]; |
|
590 | + $genreassoc = []; |
|
591 | 591 | foreach ($defaultGenres as $dg) { |
592 | 592 | $genreassoc[$dg['id']] = strtolower($dg['title']); |
593 | 593 | } |
@@ -663,7 +663,7 @@ discard block |
||
663 | 663 | return $platform; |
664 | 664 | } |
665 | 665 | |
666 | - protected function _updateConsoleTable($con =[]) |
|
666 | + protected function _updateConsoleTable($con = []) |
|
667 | 667 | { |
668 | 668 | $ri = new ReleaseImage($this->pdo); |
669 | 669 | |
@@ -694,19 +694,19 @@ discard block |
||
694 | 694 | $con['cover'] |
695 | 695 | ) |
696 | 696 | ); |
697 | - if($con['cover'] === 1){ |
|
697 | + if ($con['cover'] === 1) { |
|
698 | 698 | $con['cover'] = $ri->saveImage($consoleId, $con['coverurl'], $this->imgSavePath, 250, 250); |
699 | 699 | } |
700 | 700 | } else { |
701 | 701 | $consoleId = $check['id']; |
702 | 702 | |
703 | - if($con['cover'] === 1){ |
|
703 | + if ($con['cover'] === 1) { |
|
704 | 704 | $con['cover'] = $ri->saveImage($consoleId, $con['coverurl'], $this->imgSavePath, 250, 250); |
705 | 705 | } |
706 | 706 | |
707 | 707 | $this->update( |
708 | 708 | $consoleId, $con['title'], $con['asin'], $con['url'], $con['salesrank'], |
709 | - $con['platform'], $con['publisher'], (isset($con['releasedate']) ? $con['releasedate']: null), $con['esrb'], |
|
709 | + $con['platform'], $con['publisher'], (isset($con['releasedate']) ? $con['releasedate'] : null), $con['esrb'], |
|
710 | 710 | $con['cover'], $con['consolegenreid'], (isset($con['review']) ? $con['review'] : null) |
711 | 711 | ); |
712 | 712 | } |
@@ -852,14 +852,14 @@ discard block |
||
852 | 852 | function parseTitle($releasename) |
853 | 853 | { |
854 | 854 | $releasename = preg_replace('/\sMulti\d?\s/i', '', $releasename); |
855 | - $result =[]; |
|
855 | + $result = []; |
|
856 | 856 | |
857 | 857 | // Get name of the game from name of release. |
858 | 858 | if (preg_match('/^(.+((abgx360EFNet|EFNet\sFULL|FULL\sabgxEFNet|abgx\sFULL|abgxbox360EFNet)\s|illuminatenboard\sorg|Place2(hom|us)e.net|united-forums? co uk|\(\d+\)))?(?P<title>.*?)[\.\-_ ](v\.?\d\.\d|PAL|NTSC|EUR|USA|JP|ASIA|JAP|JPN|AUS|MULTI(\.?\d{1,2})?|PATCHED|FULLDVD|DVD5|DVD9|DVDRIP|PROPER|REPACK|RETAIL|DEMO|DISTRIBUTION|REGIONFREE|[\. ]RF[\. ]?|READ\.?NFO|NFOFIX|PSX(2PSP)?|PS[2-4]|PSP|PSVITA|WIIU|WII|X\-?BOX|XBLA|X360|3DS|NDS|N64|NGC)/i', $releasename, $matches)) { |
859 | 859 | $title = $matches['title']; |
860 | 860 | |
861 | 861 | // Replace dots, underscores, or brackets with spaces. |
862 | - $result['title'] = str_replace(['.','_','%20', '[', ']'], ' ', $title); |
|
862 | + $result['title'] = str_replace(['.', '_', '%20', '[', ']'], ' ', $title); |
|
863 | 863 | $result['title'] = str_replace([' RF ', '.RF.', '-RF-', '_RF_'], ' ', $result['title']); |
864 | 864 | //Remove format tags from release title for match |
865 | 865 | $result['title'] = trim(preg_replace('/PAL|MULTI(\d)?|NTSC-?J?|\(JAPAN\)/i', '', $result['title'])); |
@@ -13,8 +13,8 @@ discard block |
||
13 | 13 | const REQID_NONE = -3; // The Request id was not found locally or via web lookup. |
14 | 14 | const REQID_ZERO = -2; // The Request id was 0. |
15 | 15 | const REQID_NOLL = -1; // Request id was not found via local lookup. |
16 | - const REQID_UPROC = 0; // Release has not been processed. |
|
17 | - const REQID_FOUND = 1; // Request id found and release was updated. |
|
16 | + const REQID_UPROC = 0; // Release has not been processed. |
|
17 | + const REQID_FOUND = 1; // Request id found and release was updated. |
|
18 | 18 | |
19 | 19 | const IS_REQID_TRUE = 1; // releases.isrequestid is 1 |
20 | 20 | const IS_REQID_FALSE = 0; // releases.isrequestid is 0 |
@@ -144,9 +144,9 @@ discard block |
||
144 | 144 | case preg_match('/\[\s*(\d+)\s*\]/', $this->_release['name'], $requestID): |
145 | 145 | case preg_match('/^REQ\s*(\d{4,6})/i', $this->_release['name'], $requestID): |
146 | 146 | case preg_match('/^(\d{4,6})-\d{1}\[/', $this->_release['name'], $requestID): |
147 | - case preg_match('/(\d{4,6}) -/',$this->_release['name'], $requestID): |
|
148 | - if ((int) $requestID[1] > 0) { |
|
149 | - return (int) $requestID[1]; |
|
147 | + case preg_match('/(\d{4,6}) -/', $this->_release['name'], $requestID): |
|
148 | + if ((int)$requestID[1] > 0) { |
|
149 | + return (int)$requestID[1]; |
|
150 | 150 | } |
151 | 151 | } |
152 | 152 | return self::REQID_ZERO; |
@@ -190,7 +190,7 @@ |
||
190 | 190 | $category = explode(":", $li->plaintext); |
191 | 191 | if (trim($category[0]) == "Category") { |
192 | 192 | $g = explode(",", $category[1]); |
193 | - foreach($g as $genre) { |
|
193 | + foreach ($g as $genre) { |
|
194 | 194 | $genres[] = trim($genre); |
195 | 195 | } |
196 | 196 | $this->_res['genres'] = & $genres; |
@@ -112,7 +112,7 @@ discard block |
||
112 | 112 | $ch = curl_init($this->directLink); |
113 | 113 | $this->directLink = ""; |
114 | 114 | } |
115 | - if ($usepost === true){ |
|
115 | + if ($usepost === true) { |
|
116 | 116 | curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "POST"); |
117 | 117 | curl_setopt($ch, CURLOPT_POST, 1); |
118 | 118 | curl_setopt($ch, CURLOPT_POSTFIELDS, $this->_postParams); |
@@ -189,9 +189,9 @@ discard block |
||
189 | 189 | $results = array_merge($results, $this->covers()); |
190 | 190 | } |
191 | 191 | |
192 | - if (empty($results) === true){ |
|
192 | + if (empty($results) === true) { |
|
193 | 193 | return false; |
194 | - }else{ |
|
194 | + } else { |
|
195 | 195 | return $results; |
196 | 196 | } |
197 | 197 | } |
@@ -204,7 +204,7 @@ discard block |
||
204 | 204 | public function sypnosis() |
205 | 205 | { |
206 | 206 | if ($this->_html->find('.desc_link', 0)) { |
207 | - preg_match("/var descfullcontent = (?<content>.*)/", $this->_response,$matches); |
|
207 | + preg_match("/var descfullcontent = (?<content>.*)/", $this->_response, $matches); |
|
208 | 208 | if (is_array($matches)) { |
209 | 209 | $this->_res['sypnosis'] = rawurldecode($matches['content']); |
210 | 210 | } |
@@ -273,7 +273,7 @@ discard block |
||
273 | 273 | if ($this->_html->find('a[itemprop=actor]')) { |
274 | 274 | foreach ($this->_html->find('a[itemprop=actor]') as $e) { |
275 | 275 | $e = trim($e->title); |
276 | - $e = preg_replace('/\((.*)\)/',"",$e); |
|
276 | + $e = preg_replace('/\((.*)\)/', "", $e); |
|
277 | 277 | $cast[] = trim($e); |
278 | 278 | } |
279 | 279 | $this->_res['cast'] = & $cast; |
@@ -291,10 +291,10 @@ discard block |
||
291 | 291 | public function genres() |
292 | 292 | { |
293 | 293 | $genres = []; |
294 | - if ($ret = $this->_html->find('div.categories',0)) { |
|
294 | + if ($ret = $this->_html->find('div.categories', 0)) { |
|
295 | 295 | foreach ($ret->find('a') as $e) { |
296 | 296 | if (stristr($e->title, "->")) { |
297 | - $e = explode("->",$e->plaintext); |
|
297 | + $e = explode("->", $e->plaintext); |
|
298 | 298 | $genres[] = trim($e[1]); |
299 | 299 | } |
300 | 300 | } |
@@ -314,7 +314,7 @@ discard block |
||
314 | 314 | if ($ret = $this->_html->find('div#large_cover, img#cover', 1)) { |
315 | 315 | $this->_res['boxcover'] = trim($ret->src); |
316 | 316 | $this->_res['backcover'] = str_ireplace(".cover", ".back", trim($ret->src)); |
317 | - }else{ |
|
317 | + } else { |
|
318 | 318 | return false; |
319 | 319 | } |
320 | 320 | |
@@ -335,7 +335,7 @@ discard block |
||
335 | 335 | return false; |
336 | 336 | } else { |
337 | 337 | if ($ret = $this->_html->find('h3[class=title]', 0)) { |
338 | - if ($ret->find('a[title]',0)){ |
|
338 | + if ($ret->find('a[title]', 0)) { |
|
339 | 339 | $ret = $ret->find('a[title]', 0); |
340 | 340 | $title = trim($ret->title); |
341 | 341 | $title = preg_replace('/XXX/', '', $title); |
@@ -180,7 +180,7 @@ discard block |
||
180 | 180 | $this->pdo = null; |
181 | 181 | } |
182 | 182 | |
183 | - public function checkDbExists ($name = null) |
|
183 | + public function checkDbExists($name = null) |
|
184 | 184 | { |
185 | 185 | if (empty($name)) { |
186 | 186 | $name = $this->opts['dbname']; |
@@ -253,7 +253,7 @@ discard block |
||
253 | 253 | } |
254 | 254 | } |
255 | 255 | |
256 | - public function getTableList () |
|
256 | + public function getTableList() |
|
257 | 257 | { |
258 | 258 | $query = ($this->opts['dbtype'] === 'mysql' ? 'SHOW DATABASES' : 'SELECT datname AS Database FROM pg_database'); |
259 | 259 | $result = $this->pdo->query($query); |
@@ -412,12 +412,12 @@ discard block |
||
412 | 412 | * |
413 | 413 | * @return string |
414 | 414 | */ |
415 | - public function likeString($str, $left=true, $right=true) |
|
415 | + public function likeString($str, $left = true, $right = true) |
|
416 | 416 | { |
417 | 417 | return ( |
418 | 418 | 'LIKE ' . |
419 | 419 | $this->escapeString( |
420 | - ($left ? '%' : '') . |
|
420 | + ($left ? '%' : '') . |
|
421 | 421 | $str . |
422 | 422 | ($right ? '%' : '') |
423 | 423 | ) |
@@ -453,13 +453,13 @@ discard block |
||
453 | 453 | |
454 | 454 | $i = 2; |
455 | 455 | $error = ''; |
456 | - while($i < 11) { |
|
456 | + while ($i < 11) { |
|
457 | 457 | $result = $this->queryExecHelper($query, true); |
458 | 458 | if (is_array($result) && isset($result['deadlock'])) { |
459 | 459 | $error = $result['message']; |
460 | 460 | if ($result['deadlock'] === true) { |
461 | - $this->echoError("A Deadlock or lock wait timeout has occurred, sleeping.(" . ($i-1) . ")", 'queryInsert', 4); |
|
462 | - $this->ct->showsleep($i * ($i/2)); |
|
461 | + $this->echoError("A Deadlock or lock wait timeout has occurred, sleeping.(" . ($i - 1) . ")", 'queryInsert', 4); |
|
462 | + $this->ct->showsleep($i * ($i / 2)); |
|
463 | 463 | $i++; |
464 | 464 | } else { |
465 | 465 | break; |
@@ -498,13 +498,13 @@ discard block |
||
498 | 498 | |
499 | 499 | $i = 2; |
500 | 500 | $error = ''; |
501 | - while($i < 11) { |
|
501 | + while ($i < 11) { |
|
502 | 502 | $result = $this->queryExecHelper($query); |
503 | 503 | if (is_array($result) && isset($result['deadlock'])) { |
504 | 504 | $error = $result['message']; |
505 | 505 | if ($result['deadlock'] === true) { |
506 | - $this->echoError("A Deadlock or lock wait timeout has occurred, sleeping.(" . ($i-1) . ")", 'queryExec', 4); |
|
507 | - $this->ct->showsleep($i * ($i/2)); |
|
506 | + $this->echoError("A Deadlock or lock wait timeout has occurred, sleeping.(" . ($i - 1) . ")", 'queryExec', 4); |
|
507 | + $this->ct->showsleep($i * ($i / 2)); |
|
508 | 508 | $i++; |
509 | 509 | } else { |
510 | 510 | break; |
@@ -534,7 +534,7 @@ discard block |
||
534 | 534 | protected function queryExecHelper($query, $insert = false) |
535 | 535 | { |
536 | 536 | try { |
537 | - if ($insert === false ) { |
|
537 | + if ($insert === false) { |
|
538 | 538 | $run = $this->pdo->prepare($query); |
539 | 539 | $run->execute(); |
540 | 540 | return $run; |
@@ -687,7 +687,7 @@ discard block |
||
687 | 687 | // Remove LIMIT and OFFSET from query to allow queryCalc usage with browse |
688 | 688 | $query = preg_replace('#(\s+LIMIT\s+\d+)?\s+OFFSET\s+\d+\s*$#i', '', $query); |
689 | 689 | |
690 | - if ($cache === true && $this->cacheEnabled === true ) { |
|
690 | + if ($cache === true && $this->cacheEnabled === true) { |
|
691 | 691 | try { |
692 | 692 | $count = $this->cacheServer->get($this->cacheServer->createKey($query . 'count')); |
693 | 693 | if ($count !== false) { |
@@ -1109,7 +1109,7 @@ discard block |
||
1109 | 1109 | public function ping($restart = false) |
1110 | 1110 | { |
1111 | 1111 | try { |
1112 | - return (bool) $this->pdo->query('SELECT 1+1'); |
|
1112 | + return (bool)$this->pdo->query('SELECT 1+1'); |
|
1113 | 1113 | } catch (\PDOException $e) { |
1114 | 1114 | if ($restart == true) { |
1115 | 1115 | $this->initialiseDatabase(); |
@@ -1175,7 +1175,7 @@ discard block |
||
1175 | 1175 | * |
1176 | 1176 | * @return string |
1177 | 1177 | */ |
1178 | - public function getDbVersion () |
|
1178 | + public function getDbVersion() |
|
1179 | 1179 | { |
1180 | 1180 | return $this->dbVersion; |
1181 | 1181 | } |
@@ -1186,7 +1186,7 @@ discard block |
||
1186 | 1186 | * @return bool|null TRUE if Db version is greater than or eaqual to $requiredVersion, |
1187 | 1187 | * false if not, and null if the version isn't available to check against. |
1188 | 1188 | */ |
1189 | - public function isDbVersionAtLeast ($requiredVersion) |
|
1189 | + public function isDbVersionAtLeast($requiredVersion) |
|
1190 | 1190 | { |
1191 | 1191 | if (empty($this->dbVersion)) { |
1192 | 1192 | return null; |
@@ -1197,7 +1197,7 @@ discard block |
||
1197 | 1197 | /** |
1198 | 1198 | * Performs the fetch from the Db server and stores the resulting Major.Minor.Version number. |
1199 | 1199 | */ |
1200 | - private function fetchDbVersion () |
|
1200 | + private function fetchDbVersion() |
|
1201 | 1201 | { |
1202 | 1202 | $result = $this->queryOneRow("SELECT VERSION() AS version"); |
1203 | 1203 | if (!empty($result)) { |
@@ -82,7 +82,7 @@ discard block |
||
82 | 82 | 'enclosedby' => '', |
83 | 83 | 'fields' => '\t', |
84 | 84 | 'limit' => 0, |
85 | - 'lines' => '\r\n', // use Windows style endings so that text can contain \n |
|
85 | + 'lines' => '\r\n', // use Windows style endings so that text can contain \n |
|
86 | 86 | 'local' => false, |
87 | 87 | 'path' => null, |
88 | 88 | ]; |
@@ -98,7 +98,7 @@ discard block |
||
98 | 98 | |
99 | 99 | $enclosedby = empty($options['enclosedby']) ? '' : "ENCLOSED BY {$this->escapeString($options['enclosedby'])}"; |
100 | 100 | |
101 | - $sql = <<<SQL_EXPORT |
|
101 | + $sql = <<<SQL_EXPORT |
|
102 | 102 | SELECT title, nfo, size, files, filename, nuked, nukereason, category, predate, source, requestid, g.name |
103 | 103 | FROM {$this->tableMain} p LEFT OUTER JOIN groups g ON p.groups_id = g.id $limit |
104 | 104 | INTO OUTFILE '{$options['path']}' |
@@ -264,7 +264,7 @@ discard block |
||
264 | 264 | $defaults = [ |
265 | 265 | 'enclosedby' => "'", |
266 | 266 | 'fields' => '\t', |
267 | - 'lines' => '\r\n', // Windows' style EOL to allow \n to be used in text. |
|
267 | + 'lines' => '\r\n', // Windows' style EOL to allow \n to be used in text. |
|
268 | 268 | 'local' => false, |
269 | 269 | 'optional' => true, |
270 | 270 | ]; |