@@ -8,7 +8,7 @@ discard block |
||
| 8 | 8 | $covers = $updated = $deleted = 0; |
| 9 | 9 | |
| 10 | 10 | if ($argc == 1 || $argv[1] != 'true') { |
| 11 | - exit($pdo->log->error("\nThis script will check all images in covers/book and compare to db->bookinfo.\nTo run:\nphp $argv[0] true\n")); |
|
| 11 | + exit($pdo->log->error("\nThis script will check all images in covers/book and compare to db->bookinfo.\nTo run:\nphp $argv[0] true\n")); |
|
| 12 | 12 | } |
| 13 | 13 | |
| 14 | 14 | |
@@ -17,20 +17,20 @@ discard block |
||
| 17 | 17 | $dirItr = new \RecursiveDirectoryIterator($path2covers); |
| 18 | 18 | $itr = new \RecursiveIteratorIterator($dirItr, \RecursiveIteratorIterator::LEAVES_ONLY); |
| 19 | 19 | foreach ($itr as $filePath) { |
| 20 | - if (is_file($filePath) && preg_match('/\d+\.jpg/', $filePath)) { |
|
| 21 | - preg_match('/(\d+)\.jpg/', basename($filePath), $match); |
|
| 22 | - if (isset($match[1])) { |
|
| 23 | - $run = $pdo->queryDirect("UPDATE bookinfo SET cover = 1 WHERE cover = 0 AND id = " . $match[1]); |
|
| 24 | - if ($run->rowCount() >= 1) { |
|
| 25 | - $covers++; |
|
| 26 | - } else { |
|
| 27 | - $run = $pdo->queryDirect("SELECT id FROM bookinfo WHERE id = " . $match[1]); |
|
| 28 | - if ($run->rowCount() == 0) { |
|
| 29 | - echo $pdo->log->info($filePath . " not found in db."); |
|
| 30 | - } |
|
| 31 | - } |
|
| 32 | - } |
|
| 33 | - } |
|
| 20 | + if (is_file($filePath) && preg_match('/\d+\.jpg/', $filePath)) { |
|
| 21 | + preg_match('/(\d+)\.jpg/', basename($filePath), $match); |
|
| 22 | + if (isset($match[1])) { |
|
| 23 | + $run = $pdo->queryDirect("UPDATE bookinfo SET cover = 1 WHERE cover = 0 AND id = " . $match[1]); |
|
| 24 | + if ($run->rowCount() >= 1) { |
|
| 25 | + $covers++; |
|
| 26 | + } else { |
|
| 27 | + $run = $pdo->queryDirect("SELECT id FROM bookinfo WHERE id = " . $match[1]); |
|
| 28 | + if ($run->rowCount() == 0) { |
|
| 29 | + echo $pdo->log->info($filePath . " not found in db."); |
|
| 30 | + } |
|
| 31 | + } |
|
| 32 | + } |
|
| 33 | + } |
|
| 34 | 34 | } |
| 35 | 35 | |
| 36 | 36 | $qry = $pdo->queryDirect("SELECT id FROM bookinfo WHERE cover = 1"); |
@@ -27,7 +27,7 @@ |
||
| 27 | 27 | echo $pdo->log->primary($gameInfo['release'] . ' not found'); |
| 28 | 28 | } else { |
| 29 | 29 | if (file_exists(NN_COVERS . 'games' . DS . $gameData . '.jpg')) { |
| 30 | - $pdo->queryExec(sprintf('UPDATE gamesinfo SET cover = 1 WHERE id = %d', $arr['id'])); |
|
| 30 | + $pdo->queryExec(sprintf('UPDATE gamesinfo SET cover = 1 WHERE id = %d', $arr['id'])); |
|
| 31 | 31 | } |
| 32 | 32 | } |
| 33 | 33 | } |
@@ -8,7 +8,7 @@ discard block |
||
| 8 | 8 | $covers = $updated = $deleted = 0; |
| 9 | 9 | |
| 10 | 10 | if ($argc == 1 || $argv[1] != 'true') { |
| 11 | - exit($pdo->log->error("\nThis script will check all images in covers/console and compare to db->consoleinfo.\nTo run:\nphp $argv[0] true\n")); |
|
| 11 | + exit($pdo->log->error("\nThis script will check all images in covers/console and compare to db->consoleinfo.\nTo run:\nphp $argv[0] true\n")); |
|
| 12 | 12 | } |
| 13 | 13 | |
| 14 | 14 | |
@@ -17,20 +17,20 @@ discard block |
||
| 17 | 17 | $dirItr = new \RecursiveDirectoryIterator($path2covers); |
| 18 | 18 | $itr = new \RecursiveIteratorIterator($dirItr, \RecursiveIteratorIterator::LEAVES_ONLY); |
| 19 | 19 | foreach ($itr as $filePath) { |
| 20 | - if (is_file($filePath) && preg_match('/\d+\.jpg/', $filePath)) { |
|
| 21 | - preg_match('/(\d+)\.jpg/', basename($filePath), $match); |
|
| 22 | - if (isset($match[1])) { |
|
| 23 | - $run = $pdo->queryDirect("UPDATE consoleinfo SET cover = 1 WHERE cover = 0 AND id = " . $match[1]); |
|
| 24 | - if ($run->rowCount() >= 1) { |
|
| 25 | - $covers++; |
|
| 26 | - } else { |
|
| 27 | - $run = $pdo->queryDirect("SELECT id FROM consoleinfo WHERE id = " . $match[1]); |
|
| 28 | - if ($run->rowCount() == 0) { |
|
| 29 | - echo $pdo->log->info($filePath . " not found in db."); |
|
| 30 | - } |
|
| 31 | - } |
|
| 32 | - } |
|
| 33 | - } |
|
| 20 | + if (is_file($filePath) && preg_match('/\d+\.jpg/', $filePath)) { |
|
| 21 | + preg_match('/(\d+)\.jpg/', basename($filePath), $match); |
|
| 22 | + if (isset($match[1])) { |
|
| 23 | + $run = $pdo->queryDirect("UPDATE consoleinfo SET cover = 1 WHERE cover = 0 AND id = " . $match[1]); |
|
| 24 | + if ($run->rowCount() >= 1) { |
|
| 25 | + $covers++; |
|
| 26 | + } else { |
|
| 27 | + $run = $pdo->queryDirect("SELECT id FROM consoleinfo WHERE id = " . $match[1]); |
|
| 28 | + if ($run->rowCount() == 0) { |
|
| 29 | + echo $pdo->log->info($filePath . " not found in db."); |
|
| 30 | + } |
|
| 31 | + } |
|
| 32 | + } |
|
| 33 | + } |
|
| 34 | 34 | } |
| 35 | 35 | |
| 36 | 36 | $qry = $pdo->queryDirect("SELECT id FROM consoleinfo WHERE cover = 1"); |
@@ -39,5 +39,5 @@ |
||
| 39 | 39 | $pdo->queryExec("UPDATE releases SET size = '{$filesize}' WHERE id = '{$item['id']}' LIMIT 1"); |
| 40 | 40 | |
| 41 | 41 | $compl++; |
| 42 | - echo sprintf("[%6d / %6d] %0.2f",$compl, $total, ($compl/$total) * 100) . '%' . "\n"; |
|
| 42 | + echo sprintf("[%6d / %6d] %0.2f", $compl, $total, ($compl / $total) * 100) . '%' . "\n"; |
|
| 43 | 43 | } |
@@ -19,8 +19,7 @@ |
||
| 19 | 19 | $compl = 0; |
| 20 | 20 | echo "Updating file size for " . count($items) . " release(s)\n"; |
| 21 | 21 | |
| 22 | -while ($item = array_pop($items)) |
|
| 23 | -{ |
|
| 22 | +while ($item = array_pop($items)) { |
|
| 24 | 23 | $nzbpath = $nzb->getNZBPath($item['guid'], $pdo->getSetting('nzbpath')); |
| 25 | 24 | |
| 26 | 25 | ob_start(); |
@@ -16,7 +16,7 @@ discard block |
||
| 16 | 16 | if ($totalArgs < 2) { |
| 17 | 17 | exit($cli->info($n . |
| 18 | 18 | 'This deletes releases based on a list of criteria you pass.' . $n . |
| 19 | - 'Usage:' . $n . $n. |
|
| 19 | + 'Usage:' . $n . $n . |
|
| 20 | 20 | 'List of supported criteria:' . $n . |
| 21 | 21 | 'fromname : Look for names of people who posted releases (the poster name). (modifiers: equals, like)' . $n . |
| 22 | 22 | 'groupname : Look in groups. (modifiers: equals, like)' . $n . |
@@ -44,11 +44,11 @@ discard block |
||
| 44 | 44 | $_SERVER['_'] . ' ' . $argv[0] . ' groupname=equals="alt.binaries.teevee" searchname=like="olympics 2014" postdate=bigger="5"' . $n . |
| 45 | 45 | $_SERVER['_'] . ' ' . $argv[0] . ' guid=equals="8fb5956bae3de4fb94edcc69da44d6883d586fd0"' . $n . |
| 46 | 46 | $_SERVER['_'] . ' ' . $argv[0] . ' size=smaller="104857600" size=bigger="2048" groupname=like="movies"' . $n . |
| 47 | - $_SERVER['_'] . ' ' . $argv[0] . ' fromname=like="@XviD.net" groupname=equals="alt.binaries.movies.divx" ignore' .$n . |
|
| 47 | + $_SERVER['_'] . ' ' . $argv[0] . ' fromname=like="@XviD.net" groupname=equals="alt.binaries.movies.divx" ignore' . $n . |
|
| 48 | 48 | $_SERVER['_'] . ' ' . $argv[0] . ' imdbid=equals=NULL categories_id=equals=2999 nzbstatus=equals=1 adddate=bigger=2880 # Remove other movie releases with non-cleaned names added > 120 days ago' |
| 49 | 49 | )); |
| 50 | 50 | } |
| 51 | 51 | |
| 52 | 52 | $RR = new ReleaseRemover(); |
| 53 | 53 | // Remove argv[0] and send the array. |
| 54 | -$RR->removeByCriteria(array_slice($argv, 1, $totalArgs-1)); |
|
| 54 | +$RR->removeByCriteria(array_slice($argv, 1, $totalArgs - 1)); |
|
@@ -54,7 +54,7 @@ |
||
| 54 | 54 | |
| 55 | 55 | $lastId = $minId - 1; |
| 56 | 56 | echo "[Starting to populate sphinx RT index $table with $total releases.]\n"; |
| 57 | - for ($i = $minId; $i <= ($total + $max + $minId) ; $i += $max) { |
|
| 57 | + for ($i = $minId; $i <= ($total + $max + $minId); $i += $max) { |
|
| 58 | 58 | |
| 59 | 59 | $rows = $pdo->queryDirect(sprintf($query, $lastId, $max)); |
| 60 | 60 | if (!$rows) { |
@@ -36,7 +36,7 @@ |
||
| 36 | 36 | filename VARCHAR(1000) NULL, |
| 37 | 37 | INDEX(query) |
| 38 | 38 | ) ENGINE=SPHINX CONNECTION="%sreleases_rt" |
| 39 | -DDLSQL; |
|
| 39 | +ddlsql; |
|
| 40 | 40 | |
| 41 | 41 | $tables = []; |
| 42 | 42 | $tables['releases_se'] = sprintf($tableSQL_releases, $sphinxConnection); |
@@ -8,16 +8,16 @@ |
||
| 8 | 8 | } |
| 9 | 9 | |
| 10 | 10 | switch (true) { |
| 11 | - case is_file(IRC_SCRAPER_CONFIG): |
|
| 12 | - break; |
|
| 13 | - case is_file(NN_ROOT . 'misc/testing/IRCScraper/settings.php'): |
|
| 14 | - rename(NN_ROOT . 'misc/testing/IRCScraper/settings.php', IRC_SCRAPER_CONFIG); |
|
| 15 | - break; |
|
| 16 | - default: |
|
| 17 | - exit( |
|
| 18 | - 'Copy ' . NN_CONFIGS . 'ircscraper_settings_example.php to ' . |
|
| 19 | - IRC_SCRAPER_CONFIG . ' and change the settings.' . PHP_EOL |
|
| 20 | - ); |
|
| 11 | + case is_file(IRC_SCRAPER_CONFIG): |
|
| 12 | + break; |
|
| 13 | + case is_file(NN_ROOT . 'misc/testing/IRCScraper/settings.php'): |
|
| 14 | + rename(NN_ROOT . 'misc/testing/IRCScraper/settings.php', IRC_SCRAPER_CONFIG); |
|
| 15 | + break; |
|
| 16 | + default: |
|
| 17 | + exit( |
|
| 18 | + 'Copy ' . NN_CONFIGS . 'ircscraper_settings_example.php to ' . |
|
| 19 | + IRC_SCRAPER_CONFIG . ' and change the settings.' . PHP_EOL |
|
| 20 | + ); |
|
| 21 | 21 | } |
| 22 | 22 | |
| 23 | 23 | if (!isset($argv[1]) || $argv[1] != 'true') { |
@@ -123,7 +123,7 @@ |
||
| 123 | 123 | continue; |
| 124 | 124 | } else { |
| 125 | 125 | if (NN_DEBUG) { |
| 126 | - echo "Dump {$match[2]} downloaded\n"; |
|
| 126 | + echo "dump {$match[2]} downloaded\n"; |
|
| 127 | 127 | } |
| 128 | 128 | } |
| 129 | 129 | |