@@ -24,7 +24,7 @@ discard block |
||
24 | 24 | |
25 | 25 | function newname($filename) |
26 | 26 | { |
27 | - rename($filename, dirname($filename)."/".basename($filename,".gz")."_".date("Y_m_d_His", filemtime($filename)).".gz"); |
|
27 | + rename($filename, dirname($filename) . "/" . basename($filename, ".gz") . "_" . date("Y_m_d_His", filemtime($filename)) . ".gz"); |
|
28 | 28 | } |
29 | 29 | |
30 | 30 | function builddefaultsfile() |
@@ -42,7 +42,7 @@ discard block |
||
42 | 42 | ."password = " . DB_PASSWORD; |
43 | 43 | |
44 | 44 | $filehandle = fopen("mysql-defaults.txt", "w+"); |
45 | - if(!$filehandle) { |
|
45 | + if (!$filehandle) { |
|
46 | 46 | exit("Unable to write mysql defaults file! Exiting"); |
47 | 47 | } else { |
48 | 48 | fwrite($filehandle, $filetext); |
@@ -67,16 +67,16 @@ discard block |
||
67 | 67 | //generate defaults file used to store database login information so it is not in cleartext in ps command for mysqldump |
68 | 68 | builddefaultsfile(); |
69 | 69 | |
70 | -if((isset($argv[1]) && $argv[1] == "db") && (isset($argv[2]) && $argv[2] == "dump") && (isset($argv[3]) && file_exists($argv[3]))) { |
|
71 | - $filename = $argv[3]."/".$dbname.".gz"; |
|
70 | +if ((isset($argv[1]) && $argv[1] == "db") && (isset($argv[2]) && $argv[2] == "dump") && (isset($argv[3]) && file_exists($argv[3]))) { |
|
71 | + $filename = $argv[3] . "/" . $dbname . ".gz"; |
|
72 | 72 | echo $pdo->log->header("Dumping $dbname."); |
73 | 73 | if (file_exists($filename)) { |
74 | 74 | newname($filename); |
75 | 75 | } |
76 | - $command = "mysqldump --defaults-file=mysql-defaults.txt $exportopts -h$dbhost $use "."$dbname | gzip -9 > $filename"; |
|
76 | + $command = "mysqldump --defaults-file=mysql-defaults.txt $exportopts -h$dbhost $use " . "$dbname | gzip -9 > $filename"; |
|
77 | 77 | system($command); |
78 | -} else if((isset($argv[1]) && $argv[1] == "db") && (isset($argv[2]) && $argv[2] == "restore") && (isset($argv[3]) && file_exists($argv[3]))) { |
|
79 | - $filename = $argv[3]."/".$dbname.".gz"; |
|
78 | +} else if ((isset($argv[1]) && $argv[1] == "db") && (isset($argv[2]) && $argv[2] == "restore") && (isset($argv[3]) && file_exists($argv[3]))) { |
|
79 | + $filename = $argv[3] . "/" . $dbname . ".gz"; |
|
80 | 80 | if (file_exists($filename)) { |
81 | 81 | echo $pdo->log->header("Restoring $dbname."); |
82 | 82 | $command = "zcat < $filename | mysql --defaults-file=mysql-defaults.txt -h$dbhost $use $dbname"; |
@@ -84,26 +84,26 @@ discard block |
||
84 | 84 | system($command); |
85 | 85 | $pdo->queryExec("SET FOREIGN_KEY_CHECKS=1"); |
86 | 86 | } |
87 | -} else if((isset($argv[1]) && $argv[1] == "all") && (isset($argv[2]) && $argv[2] == "dump") && (isset($argv[3]) && file_exists($argv[3]))) { |
|
87 | +} else if ((isset($argv[1]) && $argv[1] == "all") && (isset($argv[2]) && $argv[2] == "dump") && (isset($argv[3]) && file_exists($argv[3]))) { |
|
88 | 88 | $sql = "SHOW tables"; |
89 | 89 | $tables = $pdo->query($sql); |
90 | - foreach($tables as $row) { |
|
91 | - $tbl = $row['Tables_in_'.DB_NAME]; |
|
92 | - $filename = $argv[3]."/".$tbl.".gz"; |
|
90 | + foreach ($tables as $row) { |
|
91 | + $tbl = $row['Tables_in_' . DB_NAME]; |
|
92 | + $filename = $argv[3] . "/" . $tbl . ".gz"; |
|
93 | 93 | echo $pdo->log->header("Dumping $tbl."); |
94 | 94 | if (file_exists($filename)) { |
95 | 95 | newname($filename); |
96 | 96 | } |
97 | - $command = "mysqldump --defaults-file=mysql-defaults.txt $exportopts -h$dbhost $use "."$dbname $tbl | gzip -9 > $filename"; |
|
97 | + $command = "mysqldump --defaults-file=mysql-defaults.txt $exportopts -h$dbhost $use " . "$dbname $tbl | gzip -9 > $filename"; |
|
98 | 98 | system($command); |
99 | 99 | } |
100 | -} else if((isset($argv[1]) && $argv[1] == "all") && (isset($argv[2]) && $argv[2] == "restore") && (isset($argv[3]) && file_exists($argv[3]))) { |
|
100 | +} else if ((isset($argv[1]) && $argv[1] == "all") && (isset($argv[2]) && $argv[2] == "restore") && (isset($argv[3]) && file_exists($argv[3]))) { |
|
101 | 101 | $sql = "SHOW tables"; |
102 | 102 | $tables = $pdo->query($sql); |
103 | 103 | $pdo->queryExec("SET FOREIGN_KEY_CHECKS=0"); |
104 | - foreach($tables as $row) { |
|
105 | - $tbl = $row['Tables_in_'.DB_NAME]; |
|
106 | - $filename = $argv[3]."/".$tbl.".gz"; |
|
104 | + foreach ($tables as $row) { |
|
105 | + $tbl = $row['Tables_in_' . DB_NAME]; |
|
106 | + $filename = $argv[3] . "/" . $tbl . ".gz"; |
|
107 | 107 | if (file_exists($filename)) { |
108 | 108 | echo $pdo->log->header("Restoring $tbl."); |
109 | 109 | $command = "zcat < $filename | mysql --defaults-file=mysql-defaults.txt -h$dbhost $use $dbname"; |
@@ -111,22 +111,22 @@ discard block |
||
111 | 111 | } |
112 | 112 | } |
113 | 113 | $pdo->queryExec("SET FOREIGN_KEY_CHECKS=1"); |
114 | -} else if((isset($argv[1]) && $argv[1] == "test") && (isset($argv[2]) && $argv[2] == "dump") && (isset($argv[3]) && file_exists($argv[3]))) { |
|
114 | +} else if ((isset($argv[1]) && $argv[1] == "test") && (isset($argv[2]) && $argv[2] == "dump") && (isset($argv[3]) && file_exists($argv[3]))) { |
|
115 | 115 | $arr = array("parts", "binaries", "missed_parts", "groups"); |
116 | 116 | foreach ($arr as &$tbl) { |
117 | - $filename = $argv[3]."/".$tbl.".gz"; |
|
117 | + $filename = $argv[3] . "/" . $tbl . ".gz"; |
|
118 | 118 | echo $pdo->log->header("Dumping $tbl.."); |
119 | 119 | if (file_exists($filename)) { |
120 | 120 | newname($filename); |
121 | 121 | } |
122 | - $command = "mysqldump --defaults-file=mysql-defaults.txt $exportopts -h$dbhost $use "."$dbname $tbl | gzip -9 > $filename"; |
|
122 | + $command = "mysqldump --defaults-file=mysql-defaults.txt $exportopts -h$dbhost $use " . "$dbname $tbl | gzip -9 > $filename"; |
|
123 | 123 | system($command); |
124 | 124 | } |
125 | -} else if((isset($argv[1]) && $argv[1] == "test") && (isset($argv[2]) && $argv[2] == "restore") && (isset($argv[3]) && file_exists($argv[3]))) { |
|
125 | +} else if ((isset($argv[1]) && $argv[1] == "test") && (isset($argv[2]) && $argv[2] == "restore") && (isset($argv[3]) && file_exists($argv[3]))) { |
|
126 | 126 | $arr = array("parts", "binaries", "missed_parts", "groups"); |
127 | 127 | $pdo->queryExec("SET FOREIGN_KEY_CHECKS=0"); |
128 | 128 | foreach ($arr as &$tbl) { |
129 | - $filename = $argv[3]."/".$tbl.".gz"; |
|
129 | + $filename = $argv[3] . "/" . $tbl . ".gz"; |
|
130 | 130 | if (file_exists($filename)) { |
131 | 131 | echo $pdo->log->header("Restoring $tbl."); |
132 | 132 | $command = "zcat < $filename | mysql --defaults-file=mysql-defaults.txt -h$dbhost $use $dbname"; |
@@ -134,25 +134,25 @@ discard block |
||
134 | 134 | } |
135 | 135 | } |
136 | 136 | $pdo->queryExec("SET FOREIGN_KEY_CHECKS=1"); |
137 | -} else if((isset($argv[1]) && $argv[1] == "all") && (isset($argv[2]) && $argv[2] == "outfile") && (isset($argv[3]) && file_exists($argv[3]))) { |
|
137 | +} else if ((isset($argv[1]) && $argv[1] == "all") && (isset($argv[2]) && $argv[2] == "outfile") && (isset($argv[3]) && file_exists($argv[3]))) { |
|
138 | 138 | $sql = "SHOW tables"; |
139 | 139 | $tables = $pdo->query($sql); |
140 | - foreach($tables as $row) { |
|
141 | - $tbl = $row['Tables_in_'.DB_NAME]; |
|
142 | - $filename = $argv[3].$tbl.".csv"; |
|
140 | + foreach ($tables as $row) { |
|
141 | + $tbl = $row['Tables_in_' . DB_NAME]; |
|
142 | + $filename = $argv[3] . $tbl . ".csv"; |
|
143 | 143 | echo $pdo->log->header("Dumping $tbl."); |
144 | 144 | if (file_exists($filename)) { |
145 | 145 | newname($filename); |
146 | 146 | } |
147 | 147 | $pdo->queryDirect(sprintf("SELECT * INTO OUTFILE %s FROM %s", $pdo->escapeString($filename), $tbl)); |
148 | 148 | } |
149 | -} else if((isset($argv[1]) && $argv[1] == "all") && (isset($argv[2]) && $argv[2] == "infile") && (isset($argv[3]) && is_dir($argv[3]))) { |
|
149 | +} else if ((isset($argv[1]) && $argv[1] == "all") && (isset($argv[2]) && $argv[2] == "infile") && (isset($argv[3]) && is_dir($argv[3]))) { |
|
150 | 150 | $sql = "SHOW tables"; |
151 | 151 | $tables = $pdo->query($sql); |
152 | 152 | $pdo->queryExec("SET FOREIGN_KEY_CHECKS=0"); |
153 | - foreach($tables as $row) { |
|
154 | - $tbl = $row['Tables_in_'.DB_NAME]; |
|
155 | - $filename = $argv[3].$tbl.".csv"; |
|
153 | + foreach ($tables as $row) { |
|
154 | + $tbl = $row['Tables_in_' . DB_NAME]; |
|
155 | + $filename = $argv[3] . $tbl . ".csv"; |
|
156 | 156 | if (file_exists($filename)) { |
157 | 157 | echo $pdo->log->header("Restoring $tbl."); |
158 | 158 | $pdo->queryExec(sprintf("LOAD DATA INFILE %s INTO TABLE %s", $pdo->escapeString($filename), $tbl)); |
@@ -177,6 +177,6 @@ discard block |
||
177 | 177 | . "php $argv[0] all infile /path/to/restore/from ...: To restore all tables, using INFILE.\n\n"); |
178 | 178 | } |
179 | 179 | |
180 | -if(file_exists("mysql-defaults.txt")) { |
|
180 | +if (file_exists("mysql-defaults.txt")) { |
|
181 | 181 | @unlink("mysql-defaults.txt"); |
182 | 182 | } |
@@ -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 | } |
@@ -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 | } |
@@ -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) { |
@@ -309,7 +309,7 @@ |
||
309 | 309 | 'gray' => "\033[37m", |
310 | 310 | 'grey' => "\033[37m", |
311 | 311 | 'hidden' => "\033[8m", |
312 | - 'info' => "\033[35m", // replace with updated version of: |
|
312 | + 'info' => "\033[35m", // replace with updated version of: |
|
313 | 313 | // "\033[" . self::coloursForeground['purple'] . "mInfo: $text\033[0m" |
314 | 314 | // when we switch to PHP 5.6 |
315 | 315 | 'normal' => "\033[0m", |
@@ -26,9 +26,9 @@ discard block |
||
26 | 26 | /** |
27 | 27 | * These constants are bitwise for checking what has changed. |
28 | 28 | */ |
29 | - const UPDATED_GIT_TAG = 1; |
|
30 | - const UPDATED_SQL_DB_PATCH = 2; |
|
31 | - const UPDATED_SQL_FILE_LAST = 4; |
|
29 | + const UPDATED_GIT_TAG = 1; |
|
30 | + const UPDATED_SQL_DB_PATCH = 2; |
|
31 | + const UPDATED_SQL_FILE_LAST = 4; |
|
32 | 32 | |
33 | 33 | /** |
34 | 34 | * @var integer Bitwise mask of elements that have been changed. |
@@ -305,7 +305,7 @@ discard block |
||
305 | 305 | parent::_init(); |
306 | 306 | |
307 | 307 | if ($this->_config['git'] instanceof \app\extensions\util\Git) { |
308 | - $this->git =& $this->_config['git']; |
|
308 | + $this->git = & $this->_config['git']; |
|
309 | 309 | } |
310 | 310 | } |
311 | 311 |
@@ -65,8 +65,7 @@ discard block |
||
65 | 65 | for ($chr = 0; $chr < $encodedLength; $chr++) { |
66 | 66 | $decoded .= ( |
67 | 67 | $encoded[$chr] == '=' ? |
68 | - chr((ord($encoded[$chr]) - 42) % 256) : |
|
69 | - chr((((ord($encoded[++$chr]) - 64) % 256) - 42) % 256) |
|
68 | + chr((ord($encoded[$chr]) - 42) % 256) : chr((((ord($encoded[++$chr]) - 64) % 256) - 42) % 256) |
|
70 | 69 | ); |
71 | 70 | } |
72 | 71 | |
@@ -129,8 +128,7 @@ discard block |
||
129 | 128 | for ($chr = 0; $chr < $length; $chr++) { |
130 | 129 | $text .= ( |
131 | 130 | $input[$chr] == '=' ? |
132 | - chr((((ord($input[++$chr]) - 64) % 256) - 42) % 256) : |
|
133 | - chr((ord($input[$chr]) - 42) % 256) |
|
131 | + chr((((ord($input[++$chr]) - 64) % 256) - 42) % 256) : chr((ord($input[$chr]) - 42) % 256) |
|
134 | 132 | ); |
135 | 133 | } |
136 | 134 | } |
@@ -150,7 +150,7 @@ |
||
150 | 150 | { |
151 | 151 | parent::_init(); |
152 | 152 | |
153 | - $this->request->params['args'] += ['sqlcheck' => 'all']; // Default to all versions/ |
|
153 | + $this->request->params['args'] += ['sqlcheck' => 'all']; // Default to all versions/ |
|
154 | 154 | $this->versions = new Versions(); |
155 | 155 | } |
156 | 156 | } |