View GitHub Repository FlightAirMap

Schedule Inspection
Subscribe
Completed
Push — master ( 09e541...ad426a )
by Yannick
06:55
created
Status
Category
Toggle Patches
install/class.update_schema.php 1 patch
Spacing   +125 added lines, -125 removed lines patch added patch discarded remove patch 
@@ -14,11 +14,11 @@  discard block
 
 block discarded – undo
14 14 
             try {
15 15 
             	$sth = $Connection->db->prepare($query);
16 16 
 		$sth->execute();
17 
-    	    } catch(PDOException $e) {
17 
+    	    } catch (PDOException $e) {
18 18 
 		return "error : ".$e->getMessage()."\n";
19 19 
     	    }
20 20 
     	    while ($row = $sth->fetch(PDO::FETCH_ASSOC)) {
21 
-    		$Schedule->addSchedule($row['ident'],$row['departure_airport_icao'],$row['departure_airport_time'],$row['arrival_airport_icao'],$row['arrival_airport_time']);
21 
+    		$Schedule->addSchedule($row['ident'], $row['departure_airport_icao'], $row['departure_airport_time'], $row['arrival_airport_icao'], $row['arrival_airport_time']);
22 22 
     	    }
23 23
24 24 
 	}
 
@@ -50,7 +50,7 @@  discard block
 
 block discarded – undo
50 50 
         	try {
51 51 
             	    $sth = $Connection->db->prepare($query);
52 52 
 		    $sth->execute();
53 
-    		} catch(PDOException $e) {
53 
+    		} catch (PDOException $e) {
54 54 
 		    return "error (add new columns to routes table) : ".$e->getMessage()."\n";
55 55 
     		}
56 56 
     		// Copy schedules data to routes table
 
@@ -60,7 +60,7 @@  discard block
 
 block discarded – undo
60 60 
         	try {
61 61 
             	    $sth = $Connection->db->prepare($query);
62 62 
 		    $sth->execute();
63 
-    		} catch(PDOException $e) {
63 
+    		} catch (PDOException $e) {
64 64 
 		    return "error (delete schedule table) : ".$e->getMessage()."\n";
65 65 
     		}
66 66 
     		// Add source column
 
@@ -68,7 +68,7 @@  discard block
 
 block discarded – undo
68 68 
     		try {
69 69 
             	    $sth = $Connection->db->prepare($query);
70 70 
 		    $sth->execute();
71 
-    		} catch(PDOException $e) {
71 
+    		} catch (PDOException $e) {
72 72 
 		    return "error (add source column to aircraft_modes) : ".$e->getMessage()."\n";
73 73 
     		}
74 74 
 		// Delete unused column
 
@@ -76,7 +76,7 @@  discard block
 
 block discarded – undo
76 76 
     		try {
77 77 
             	    $sth = $Connection->db->prepare($query);
78 78 
 		    $sth->execute();
79 
-    		} catch(PDOException $e) {
79 
+    		} catch (PDOException $e) {
80 80 
 		    return "error (Delete unused column of aircraft_modes) : ".$e->getMessage()."\n";
81 81 
     		}
82 82 
 		// Add ModeS column
 
@@ -84,14 +84,14 @@  discard block
 
 block discarded – undo
84 84 
     		try {
85 85 
             	    $sth = $Connection->db->prepare($query);
86 86 
 		    $sth->execute();
87 
-    		} catch(PDOException $e) {
87 
+    		} catch (PDOException $e) {
88 88 
 		    return "error (Add ModeS column in spotter_output) : ".$e->getMessage()."\n";
89 89 
     		}
90 90 
 		$query = "ALTER TABLE `spotter_live`  ADD `ModeS` VARCHAR(255)";
91 91 
     		try {
92 92 
             	    $sth = $Connection->db->prepare($query);
93 93 
 		    $sth->execute();
94 
-    		} catch(PDOException $e) {
94 
+    		} catch (PDOException $e) {
95 95 
 		    return "error (Add ModeS column in spotter_live) : ".$e->getMessage()."\n";
96 96 
     		}
97 97 
     		// Add auto_increment for aircraft_modes
 
@@ -99,7 +99,7 @@  discard block
 
 block discarded – undo
99 99 
     		try {
100 100 
             	    $sth = $Connection->db->prepare($query);
101 101 
 		    $sth->execute();
102 
-    		} catch(PDOException $e) {
102 
+    		} catch (PDOException $e) {
103 103 
 		    return "error (Add Auto increment in aircraft_modes) : ".$e->getMessage()."\n";
104 104 
     		}
105 105 
     		$error = '';
 
@@ -110,7 +110,7 @@  discard block
 
 block discarded – undo
110 110 
         	try {
111 111 
             	    $sth = $Connection->db->prepare($query);
112 112 
 		    $sth->execute();
113 
-    		} catch(PDOException $e) {
113 
+    		} catch (PDOException $e) {
114 114 
 		    return "error (update schema_version) : ".$e->getMessage()."\n";
115 115 
     		}
116 116 
 		return $error;
 
@@ -123,7 +123,7 @@  discard block
 
 block discarded – undo
123 123 
         	try {
124 124 
             	    $sth = $Connection->db->prepare($query);
125 125 
 		    $sth->execute();
126 
-    		} catch(PDOException $e) {
126 
+    		} catch (PDOException $e) {
127 127 
 		    return "error (add new columns to routes table) : ".$e->getMessage()."\n";
128 128 
     		}
129 129 
     		$error = '';
 
@@ -134,7 +134,7 @@  discard block
 
 block discarded – undo
134 134 
         	try {
135 135 
             	    $sth = $Connection->db->prepare($query);
136 136 
 		    $sth->execute();
137 
-    		} catch(PDOException $e) {
137 
+    		} catch (PDOException $e) {
138 138 
 		    return "error (update schema_version) : ".$e->getMessage()."\n";
139 139 
     		}
140 140 
 		return $error;
 
@@ -147,7 +147,7 @@  discard block
 
 block discarded – undo
147 147 
         	try {
148 148 
             	    $sth = $Connection->db->prepare($query);
149 149 
 		    $sth->execute();
150 
-    		} catch(PDOException $e) {
150 
+    		} catch (PDOException $e) {
151 151 
 		    return "error (add new columns to aircraft_modes) : ".$e->getMessage()."\n";
152 152 
     		}
153 153 
     		// Add image_source_website column to spotter_image
 
@@ -155,7 +155,7 @@  discard block
 
 block discarded – undo
155 155 
         	try {
156 156 
             	    $sth = $Connection->db->prepare($query);
157 157 
 		    $sth->execute();
158 
-    		} catch(PDOException $e) {
158 
+    		} catch (PDOException $e) {
159 159 
 		    return "error (add new columns to spotter_image) : ".$e->getMessage()."\n";
160 160 
     		}
161 161 
     		$error = '';
 
@@ -164,7 +164,7 @@  discard block
 
 block discarded – undo
164 164 
         	try {
165 165 
             	    $sth = $Connection->db->prepare($query);
166 166 
 		    $sth->execute();
167 
-    		} catch(PDOException $e) {
167 
+    		} catch (PDOException $e) {
168 168 
 		    return "error (update schema_version) : ".$e->getMessage()."\n";
169 169 
     		}
170 170 
 		return $error;
 
@@ -182,7 +182,7 @@  discard block
 
 block discarded – undo
182 182 
         	    try {
183 183 
             		$sth = $Connection->db->prepare($query);
184 184 
 			$sth->execute();
185 
-    		    } catch(PDOException $e) {
185 
+    		    } catch (PDOException $e) {
186 186 
 			return "error (update schema_version) : ".$e->getMessage()."\n";
187 187 
     		    }
188 188 
     		}
 
@@ -196,7 +196,7 @@  discard block
 
 block discarded – undo
196 196 
         	try {
197 197 
             	    $sth = $Connection->db->prepare($query);
198 198 
 		    $sth->execute();
199 
-    		} catch(PDOException $e) {
199 
+    		} catch (PDOException $e) {
200 200 
 		    return "error (add new columns to translation) : ".$e->getMessage()."\n";
201 201 
     		}
202 202 
     		// Add aircraft_shadow column to aircraft
 
@@ -204,7 +204,7 @@  discard block
 
 block discarded – undo
204 204 
         	try {
205 205 
             	    $sth = $Connection->db->prepare($query);
206 206 
 		    $sth->execute();
207 
-    		} catch(PDOException $e) {
207 
+    		} catch (PDOException $e) {
208 208 
 		    return "error (add new column to aircraft) : ".$e->getMessage()."\n";
209 209 
     		}
210 210 
     		// Add aircraft_shadow column to spotter_live
 
@@ -212,7 +212,7 @@  discard block
 
 block discarded – undo
212 212 
         	try {
213 213 
             	    $sth = $Connection->db->prepare($query);
214 214 
 		    $sth->execute();
215 
-    		} catch(PDOException $e) {
215 
+    		} catch (PDOException $e) {
216 216 
 		    return "error (add new column to spotter_live) : ".$e->getMessage()."\n";
217 217 
     		}
218 218 
     		$error = '';
 
@@ -225,7 +225,7 @@  discard block
 
 block discarded – undo
225 225 
         	try {
226 226 
             	    $sth = $Connection->db->prepare($query);
227 227 
 		    $sth->execute();
228 
-    		} catch(PDOException $e) {
228 
+    		} catch (PDOException $e) {
229 229 
 		    return "error (update schema_version) : ".$e->getMessage()."\n";
230 230 
     		}
231 231 
 		return $error;
 
@@ -233,7 +233,7 @@  discard block
 
 block discarded – undo
233 233
234 234 
 	private static function update_from_6() {
235 235 
     		$Connection = new Connection();
236 
-    		if (!$Connection->indexExists('spotter_output','flightaware_id')) {
236 
+    		if (!$Connection->indexExists('spotter_output', 'flightaware_id')) {
237 237 
     		    $query = "ALTER TABLE spotter_output ADD INDEX(flightaware_id);
238 238 
 			ALTER TABLE spotter_output ADD INDEX(date);
239 239 
 			ALTER TABLE spotter_output ADD INDEX(ident);
 
@@ -250,7 +250,7 @@  discard block
 
 block discarded – undo
250 250 
         	    try {
251 251 
             		$sth = $Connection->db->prepare($query);
252 252 
 			$sth->execute();
253 
-    		    } catch(PDOException $e) {
253 
+    		    } catch (PDOException $e) {
254 254 
 			return "error (add some indexes) : ".$e->getMessage()."\n";
255 255 
     		    }
256 256 
     		}
 
@@ -265,7 +265,7 @@  discard block
 
 block discarded – undo
265 265 
         	try {
266 266 
             	    $sth = $Connection->db->prepare($query);
267 267 
 		    $sth->execute();
268 
-    		} catch(PDOException $e) {
268 
+    		} catch (PDOException $e) {
269 269 
 		    return "error (update schema_version) : ".$e->getMessage()."\n";
270 270 
     		}
271 271 
 		return $error;
 
@@ -274,12 +274,12 @@  discard block
 
 block discarded – undo
274 274 
 	private static function update_from_7() {
275 275 
 		global $globalDBname, $globalDBdriver;
276 276 
     		$Connection = new Connection();
277 
-    		$query="ALTER TABLE spotter_live ADD pilot_name VARCHAR(255) NULL, ADD pilot_id VARCHAR(255) NULL;
277 
+    		$query = "ALTER TABLE spotter_live ADD pilot_name VARCHAR(255) NULL, ADD pilot_id VARCHAR(255) NULL;
278 278 
     			ALTER TABLE spotter_output ADD pilot_name VARCHAR(255) NULL, ADD pilot_id VARCHAR(255) NULL;";
279 279 
         	try {
280 280 
             	    $sth = $Connection->db->prepare($query);
281 281 
 		    $sth->execute();
282 
-    		} catch(PDOException $e) {
282 
+    		} catch (PDOException $e) {
283 283 
 		    return "error (add pilot column to spotter_live and spotter_output) : ".$e->getMessage()."\n";
284 284 
     		}
285 285 
     		if ($globalDBdriver == 'mysql') {
 
@@ -287,7 +287,7 @@  discard block
 
 block discarded – undo
287 287 
 		    try {
288 288 
             		$sth = $Connection->db->prepare($query);
289 289 
 			$sth->execute();
290 
-    		    } catch(PDOException $e) {
290 
+    		    } catch (PDOException $e) {
291 291 
 			return "error (problem when select engine for spotter_engine) : ".$e->getMessage()."\n";
292 292 
     		    }
293 293 
     		    $row = $sth->fetch(PDO::FETCH_ASSOC);
 
@@ -299,15 +299,15 @@  discard block
 
 block discarded – undo
299 299 
 				DROP TABLE spotter_archive;
300 300 
 				RENAME TABLE copy TO spotter_archive;";
301 301 
             	    } else {
302 
-    			$query="ALTER TABLE spotter_archive ADD pilot_name VARCHAR(255) NULL, ADD pilot_id VARCHAR(255) NULL";
302 
+    			$query = "ALTER TABLE spotter_archive ADD pilot_name VARCHAR(255) NULL, ADD pilot_id VARCHAR(255) NULL";
303 303 
             	    }
304 304 
                 } else {
305 
-    		    $query="ALTER TABLE spotter_archive ADD pilot_name VARCHAR(255) NULL, ADD pilot_id VARCHAR(255) NULL";
305 
+    		    $query = "ALTER TABLE spotter_archive ADD pilot_name VARCHAR(255) NULL, ADD pilot_id VARCHAR(255) NULL";
306 306 
                 }
307 307 
         	try {
308 308 
             	    $sth = $Connection->db->prepare($query);
309 309 
 		    $sth->execute();
310 
-    		} catch(PDOException $e) {
310 
+    		} catch (PDOException $e) {
311 311 
 		    return "error (add pilot column to spotter_archive) : ".$e->getMessage()."\n";
312 312 
     		}
313 313 
 
@@ -320,7 +320,7 @@  discard block
 
 block discarded – undo
320 320 
         	try {
321 321 
             	    $sth = $Connection->db->prepare($query);
322 322 
 		    $sth->execute();
323 
-    		} catch(PDOException $e) {
323 
+    		} catch (PDOException $e) {
324 324 
 		    return "error (update schema_version) : ".$e->getMessage()."\n";
325 325 
     		}
326 326 
 		return $error;
 
@@ -339,14 +339,14 @@  discard block
 
 block discarded – undo
339 339 
         	try {
340 340 
             	    $sth = $Connection->db->prepare($query);
341 341 
 		    $sth->execute();
342 
-    		} catch(PDOException $e) {
342 
+    		} catch (PDOException $e) {
343 343 
 		    return "error (insert last_update values) : ".$e->getMessage()."\n";
344 344 
     		}
345 345 
 		$query = "UPDATE `config` SET `value` = '9' WHERE `name` = 'schema_version'";
346 346 
         	try {
347 347 
             	    $sth = $Connection->db->prepare($query);
348 348 
 		    $sth->execute();
349 
-    		} catch(PDOException $e) {
349 
+    		} catch (PDOException $e) {
350 350 
 		    return "error (update schema_version) : ".$e->getMessage()."\n";
351 351 
     		}
352 352 
 		return $error;
 
@@ -354,12 +354,12 @@  discard block
 
 block discarded – undo
354 354
355 355 
 	private static function update_from_9() {
356 356 
     		$Connection = new Connection();
357 
-    		$query="ALTER TABLE spotter_live ADD verticalrate INT(11) NULL;
357 
+    		$query = "ALTER TABLE spotter_live ADD verticalrate INT(11) NULL;
358 358 
     			ALTER TABLE spotter_output ADD verticalrate INT(11) NULL;";
359 359 
         	try {
360 360 
             	    $sth = $Connection->db->prepare($query);
361 361 
 		    $sth->execute();
362 
-    		} catch(PDOException $e) {
362 
+    		} catch (PDOException $e) {
363 363 
 		    return "error (add verticalrate column to spotter_live and spotter_output) : ".$e->getMessage()."\n";
364 364 
     		}
365 365 
 		$error = '';
 
@@ -371,7 +371,7 @@  discard block
 
 block discarded – undo
371 371 
         	try {
372 372 
             	    $sth = $Connection->db->prepare($query);
373 373 
 		    $sth->execute();
374 
-    		} catch(PDOException $e) {
374 
+    		} catch (PDOException $e) {
375 375 
 		    return "error (update schema_version) : ".$e->getMessage()."\n";
376 376 
     		}
377 377 
 		return $error;
 
@@ -379,11 +379,11 @@  discard block
 
 block discarded – undo
379 379
380 380 
 	private static function update_from_10() {
381 381 
     		$Connection = new Connection();
382 
-    		$query="ALTER TABLE atc CHANGE `type` `type` ENUM('Observer','Flight Information','Delivery','Tower','Approach','ACC','Departure','Ground','Flight Service Station','Control Radar or Centre') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL";
382 
+    		$query = "ALTER TABLE atc CHANGE `type` `type` ENUM('Observer','Flight Information','Delivery','Tower','Approach','ACC','Departure','Ground','Flight Service Station','Control Radar or Centre') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL";
383 383 
         	try {
384 384 
             	    $sth = $Connection->db->prepare($query);
385 385 
 		    $sth->execute();
386 
-    		} catch(PDOException $e) {
386 
+    		} catch (PDOException $e) {
387 387 
 		    return "error (add new enum to ATC table) : ".$e->getMessage()."\n";
388 388 
     		}
389 389 
 		$error = '';
 
@@ -401,7 +401,7 @@  discard block
 
 block discarded – undo
401 401 
         	try {
402 402 
             	    $sth = $Connection->db->prepare($query);
403 403 
 		    $sth->execute();
404 
-    		} catch(PDOException $e) {
404 
+    		} catch (PDOException $e) {
405 405 
 		    return "error (update schema_version) : ".$e->getMessage()."\n";
406 406 
     		}
407 407 
 		return $error;
 
@@ -410,18 +410,18 @@  discard block
 
 block discarded – undo
410 410 
 	private static function update_from_11() {
411 411 
 		global $globalDBdriver, $globalDBname;
412 412 
     		$Connection = new Connection();
413 
-    		$query="ALTER TABLE spotter_output ADD owner_name VARCHAR(255) NULL DEFAULT NULL, ADD format_source VARCHAR(255) NULL DEFAULT NULL, ADD ground BOOLEAN NOT NULL DEFAULT FALSE, ADD last_ground BOOLEAN NOT NULL DEFAULT FALSE, ADD last_seen DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, ADD last_latitude FLOAT NULL, ADD last_longitude FLOAT NULL, ADD last_altitude INT(11) NULL, ADD last_ground_speed INT(11), ADD real_arrival_airport_icao VARCHAR(999), ADD real_arrival_airport_time VARCHAR(20),ADD real_departure_airport_icao VARCHAR(999), ADD real_departure_airport_time VARCHAR(20)";
413 
+    		$query = "ALTER TABLE spotter_output ADD owner_name VARCHAR(255) NULL DEFAULT NULL, ADD format_source VARCHAR(255) NULL DEFAULT NULL, ADD ground BOOLEAN NOT NULL DEFAULT FALSE, ADD last_ground BOOLEAN NOT NULL DEFAULT FALSE, ADD last_seen DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, ADD last_latitude FLOAT NULL, ADD last_longitude FLOAT NULL, ADD last_altitude INT(11) NULL, ADD last_ground_speed INT(11), ADD real_arrival_airport_icao VARCHAR(999), ADD real_arrival_airport_time VARCHAR(20),ADD real_departure_airport_icao VARCHAR(999), ADD real_departure_airport_time VARCHAR(20)";
414 414 
         	try {
415 415 
             	    $sth = $Connection->db->prepare($query);
416 416 
 		    $sth->execute();
417 
-    		} catch(PDOException $e) {
417 
+    		} catch (PDOException $e) {
418 418 
 		    return "error (add owner_name & format_source column to spotter_output) : ".$e->getMessage()."\n";
419 419 
     		}
420 
-    		$query="ALTER TABLE spotter_live ADD format_source VARCHAR(255) NULL DEFAULT NULL, ADD ground BOOLEAN NOT NULL DEFAULT FALSE";
420 
+    		$query = "ALTER TABLE spotter_live ADD format_source VARCHAR(255) NULL DEFAULT NULL, ADD ground BOOLEAN NOT NULL DEFAULT FALSE";
421 421 
         	try {
422 422 
             	    $sth = $Connection->db->prepare($query);
423 423 
 		    $sth->execute();
424 
-    		} catch(PDOException $e) {
424 
+    		} catch (PDOException $e) {
425 425 
 		    return "error (format_source column to spotter_live) : ".$e->getMessage()."\n";
426 426 
     		}
427 427 
     		if ($globalDBdriver == 'mysql') {
 
@@ -429,7 +429,7 @@  discard block
 
 block discarded – undo
429 429 
 		    try {
430 430 
             		$sth = $Connection->db->prepare($query);
431 431 
 			$sth->execute();
432 
-    		    } catch(PDOException $e) {
432 
+    		    } catch (PDOException $e) {
433 433 
 			return "error (problem when select engine for spotter_engine) : ".$e->getMessage()."\n";
434 434 
     		    }
435 435 
     		    $row = $sth->fetch(PDO::FETCH_ASSOC);
 
@@ -441,15 +441,15 @@  discard block
 
 block discarded – undo
441 441 
 				DROP TABLE spotter_archive;
442 442 
 				RENAME TABLE copy TO spotter_archive;";
443 443 
             	    } else {
444 
-    			$query="ALTER TABLE spotter_archive ADD verticalrate INT(11) NULL, ADD format_source VARCHAR(255) NULL DEFAULT NULL, ADD ground BOOLEAN NOT NULL DEFAULT FALSE";
444 
+    			$query = "ALTER TABLE spotter_archive ADD verticalrate INT(11) NULL, ADD format_source VARCHAR(255) NULL DEFAULT NULL, ADD ground BOOLEAN NOT NULL DEFAULT FALSE";
445 445 
             	    }
446 446 
                 } else {
447 
-    		    $query="ALTER TABLE spotter_archive ADD verticalrate INT(11) NULL, ADD format_source VARCHAR(255) NULL DEFAULT NULL, ADD ground BOOLEAN NOT NULL DEFAULT FALSE";
447 
+    		    $query = "ALTER TABLE spotter_archive ADD verticalrate INT(11) NULL, ADD format_source VARCHAR(255) NULL DEFAULT NULL, ADD ground BOOLEAN NOT NULL DEFAULT FALSE";
448 448 
                 }
449 449 
         	try {
450 450 
             	    $sth = $Connection->db->prepare($query);
451 451 
 		    $sth->execute();
452 
-    		} catch(PDOException $e) {
452 
+    		} catch (PDOException $e) {
453 453 
 		    return "error (add columns to spotter_archive) : ".$e->getMessage()."\n";
454 454 
     		}
455 455 
 
@@ -459,7 +459,7 @@  discard block
 
 block discarded – undo
459 459 
         	try {
460 460 
             	    $sth = $Connection->db->prepare($query);
461 461 
 		    $sth->execute();
462 
-    		} catch(PDOException $e) {
462 
+    		} catch (PDOException $e) {
463 463 
 		    return "error (update schema_version) : ".$e->getMessage()."\n";
464 464 
     		}
465 465 
 		return $error;
 
@@ -487,7 +487,7 @@  discard block
 
 block discarded – undo
487 487 
         	try {
488 488 
             	    $sth = $Connection->db->prepare($query);
489 489 
 		    $sth->execute();
490 
-    		} catch(PDOException $e) {
490 
+    		} catch (PDOException $e) {
491 491 
 		    return "error (update schema_version) : ".$e->getMessage()."\n";
492 492 
     		}
493 493 
 		return $error;
 
@@ -495,12 +495,12 @@  discard block
 
 block discarded – undo
495 495
496 496 
 	private static function update_from_13() {
497 497 
     		$Connection = new Connection();
498 
-    		if (!$Connection->checkColumnName('spotter_archive_output','real_departure_airport_icao')) {
499 
-    			$query="ALTER TABLE spotter_archive_output ADD real_departure_airport_icao VARCHAR(20), ADD real_departure_airport_time VARCHAR(20)";
498 
+    		if (!$Connection->checkColumnName('spotter_archive_output', 'real_departure_airport_icao')) {
499 
+    			$query = "ALTER TABLE spotter_archive_output ADD real_departure_airport_icao VARCHAR(20), ADD real_departure_airport_time VARCHAR(20)";
500 500 
 			try {
501 501 
 				$sth = $Connection->db->prepare($query);
502 502 
 				$sth->execute();
503 
-	    		} catch(PDOException $e) {
503 
+	    		} catch (PDOException $e) {
504 504 
 				return "error (update spotter_archive_output) : ".$e->getMessage()."\n";
505 505 
     			}
506 506 
 		}
 
@@ -509,7 +509,7 @@  discard block
 
 block discarded – undo
509 509 
         	try {
510 510 
             	    $sth = $Connection->db->prepare($query);
511 511 
 		    $sth->execute();
512 
-    		} catch(PDOException $e) {
512 
+    		} catch (PDOException $e) {
513 513 
 		    return "error (update schema_version) : ".$e->getMessage()."\n";
514 514 
     		}
515 515 
 		return $error;
 
@@ -527,7 +527,7 @@  discard block
 
 block discarded – undo
527 527 
         	try {
528 528 
             	    $sth = $Connection->db->prepare($query);
529 529 
 		    $sth->execute();
530 
-    		} catch(PDOException $e) {
530 
+    		} catch (PDOException $e) {
531 531 
 		    return "error (update schema_version) : ".$e->getMessage()."\n";
532 532 
     		}
533 533 
 		return $error;
 
@@ -538,11 +538,11 @@  discard block
 
 block discarded – undo
538 538 
     		$Connection = new Connection();
539 539 
 		$error = '';
540 540 
     		// Add tables
541 
-    		$query="ALTER TABLE `stats` CHANGE `stats_date` `stats_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP";
541 
+    		$query = "ALTER TABLE `stats` CHANGE `stats_date` `stats_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP";
542 542 
         	try {
543 543 
             	    $sth = $Connection->db->prepare($query);
544 544 
 		    $sth->execute();
545 
-    		} catch(PDOException $e) {
545 
+    		} catch (PDOException $e) {
546 546 
 		    return "error (update stats) : ".$e->getMessage()."\n";
547 547 
     		}
548 548 
 		if ($error != '') return $error;
 
@@ -550,7 +550,7 @@  discard block
 
 block discarded – undo
550 550 
         	try {
551 551 
             	    $sth = $Connection->db->prepare($query);
552 552 
 		    $sth->execute();
553 
-    		} catch(PDOException $e) {
553 
+    		} catch (PDOException $e) {
554 554 
 		    return "error (update schema_version) : ".$e->getMessage()."\n";
555 555 
     		}
556 556 
 		return $error;
 
@@ -571,7 +571,7 @@  discard block
 
 block discarded – undo
571 571 
         	try {
572 572 
             	    $sth = $Connection->db->prepare($query);
573 573 
 		    $sth->execute();
574 
-    		} catch(PDOException $e) {
574 
+    		} catch (PDOException $e) {
575 575 
 		    return "error (update schema_version) : ".$e->getMessage()."\n";
576 576 
     		}
577 577 
 		return $error;
 
@@ -589,7 +589,7 @@  discard block
 
 block discarded – undo
589 589 
         	try {
590 590 
             	    $sth = $Connection->db->prepare($query);
591 591 
 		    $sth->execute();
592 
-    		} catch(PDOException $e) {
592 
+    		} catch (PDOException $e) {
593 593 
 		    return "error (update schema_version) : ".$e->getMessage()."\n";
594 594 
     		}
595 595 
 		return $error;
 
@@ -598,12 +598,12 @@  discard block
 
 block discarded – undo
598 598 
     		$Connection = new Connection();
599 599 
 		$error = '';
600 600 
     		// Modify stats_airport table
601 
-    		if (!$Connection->checkColumnName('stats_airport','airport_name')) {
601 
+    		if (!$Connection->checkColumnName('stats_airport', 'airport_name')) {
602 602 
     			$query = "ALTER TABLE `stats_airport` ADD `stats_type` VARCHAR(50) NOT NULL DEFAULT 'yearly', ADD `airport_name` VARCHAR(255) NOT NULL, ADD `date` DATE NULL DEFAULT NULL, DROP INDEX `airport_icao`, ADD UNIQUE `airport_icao` (`airport_icao`, `type`, `date`)";
603 603 
     	        	try {
604 604 
 	            	    $sth = $Connection->db->prepare($query);
605 605 
 			    $sth->execute();
606 
-    			} catch(PDOException $e) {
606 
+    			} catch (PDOException $e) {
607 607 
 			    return "error (update stats) : ".$e->getMessage()."\n";
608 608 
     			}
609 609 
     		}
 
@@ -612,7 +612,7 @@  discard block
 
 block discarded – undo
612 612 
         	try {
613 613 
             	    $sth = $Connection->db->prepare($query);
614 614 
 		    $sth->execute();
615 
-    		} catch(PDOException $e) {
615 
+    		} catch (PDOException $e) {
616 616 
 		    return "error (update schema_version) : ".$e->getMessage()."\n";
617 617 
     		}
618 618 
 		return $error;
 
@@ -629,73 +629,73 @@  discard block
 
 block discarded – undo
629 629 
         	try {
630 630 
             	    $sth = $Connection->db->prepare($query);
631 631 
 		    $sth->execute();
632 
-    		} catch(PDOException $e) {
632 
+    		} catch (PDOException $e) {
633 633 
 		    return "error (remove primary key on spotter_archive) : ".$e->getMessage()."\n";
634 634 
     		}
635 635 
 		$query = "alter table spotter_archive add spotter_archive_id INT(11)";
636 636 
         	try {
637 637 
             	    $sth = $Connection->db->prepare($query);
638 638 
 		    $sth->execute();
639 
-    		} catch(PDOException $e) {
639 
+    		} catch (PDOException $e) {
640 640 
 		    return "error (add id again on spotter_archive) : ".$e->getMessage()."\n";
641 641 
     		}
642 
-		if (!$Connection->checkColumnName('spotter_archive','over_country')) {
642 
+		if (!$Connection->checkColumnName('spotter_archive', 'over_country')) {
643 643 
 			// Add column over_country
644 644 
     			$query = "ALTER TABLE `spotter_archive` ADD `over_country` VARCHAR(5) NULL DEFAULT NULL";
645 645 
 			try {
646 646 
             			$sth = $Connection->db->prepare($query);
647 647 
 				$sth->execute();
648 
-			} catch(PDOException $e) {
648 
+			} catch (PDOException $e) {
649 649 
 				return "error (add over_country) : ".$e->getMessage()."\n";
650 650 
 			}
651 651 
 		}
652 
-		if (!$Connection->checkColumnName('spotter_live','over_country')) {
652 
+		if (!$Connection->checkColumnName('spotter_live', 'over_country')) {
653 653 
 			// Add column over_country
654 654 
     			$query = "ALTER TABLE `spotter_live` ADD `over_country` VARCHAR(5) NULL DEFAULT NULL";
655 655 
 			try {
656 656 
             			$sth = $Connection->db->prepare($query);
657 657 
 				$sth->execute();
658 
-			} catch(PDOException $e) {
658 
+			} catch (PDOException $e) {
659 659 
 				return "error (add over_country) : ".$e->getMessage()."\n";
660 660 
 			}
661 661 
 		}
662 
-		if (!$Connection->checkColumnName('spotter_output','source_name')) {
662 
+		if (!$Connection->checkColumnName('spotter_output', 'source_name')) {
663 663 
 			// Add source_name to spotter_output, spotter_live, spotter_archive, spotter_archive_output
664 664 
     			$query = "ALTER TABLE `spotter_output` ADD `source_name` VARCHAR(255) NULL AFTER `format_source`";
665 665 
 			try {
666 666 
 				$sth = $Connection->db->prepare($query);
667 667 
 				$sth->execute();
668 
-			} catch(PDOException $e) {
668 
+			} catch (PDOException $e) {
669 669 
 				return "error (add source_name column) : ".$e->getMessage()."\n";
670 670 
     			}
671 671 
     		}
672 
-		if (!$Connection->checkColumnName('spotter_live','source_name')) {
672 
+		if (!$Connection->checkColumnName('spotter_live', 'source_name')) {
673 673 
 			// Add source_name to spotter_output, spotter_live, spotter_archive, spotter_archive_output
674 674 
     			$query = "ALTER TABLE `spotter_live` ADD `source_name` VARCHAR(255) NULL AFTER `format_source`";
675 675 
 			try {
676 676 
 				$sth = $Connection->db->prepare($query);
677 677 
 				$sth->execute();
678 
-			} catch(PDOException $e) {
678 
+			} catch (PDOException $e) {
679 679 
 				return "error (add source_name column) : ".$e->getMessage()."\n";
680 680 
     			}
681 681 
     		}
682 
-		if (!$Connection->checkColumnName('spotter_archive_output','source_name')) {
682 
+		if (!$Connection->checkColumnName('spotter_archive_output', 'source_name')) {
683 683 
 			// Add source_name to spotter_output, spotter_live, spotter_archive, spotter_archive_output
684 684 
     			$query = "ALTER TABLE `spotter_archive_output` ADD `source_name` VARCHAR(255) NULL AFTER `format_source`";
685 685 
 			try {
686 686 
 				$sth = $Connection->db->prepare($query);
687 687 
 				$sth->execute();
688 
-			} catch(PDOException $e) {
688 
+			} catch (PDOException $e) {
689 689 
 				return "error (add source_name column) : ".$e->getMessage()."\n";
690 690 
     			}
691 691 
     		}
692 
-		if (!$Connection->checkColumnName('spotter_archive','source_name')) {
692 
+		if (!$Connection->checkColumnName('spotter_archive', 'source_name')) {
693 693 
 			// Add source_name to spotter_output, spotter_live, spotter_archive, spotter_archive_output
694 694 
     			$query = "ALTER TABLE `spotter_archive` ADD `source_name` VARCHAR(255) NULL AFTER `format_source`;";
695 695 
 			try {
696 696 
 				$sth = $Connection->db->prepare($query);
697 697 
 				$sth->execute();
698 
-			} catch(PDOException $e) {
698 
+			} catch (PDOException $e) {
699 699 
 				return "error (add source_name column) : ".$e->getMessage()."\n";
700 700 
     			}
701 701 
     		}
 
@@ -704,7 +704,7 @@  discard block
 
 block discarded – undo
704 704 
         	try {
705 705 
             	    $sth = $Connection->db->prepare($query);
706 706 
 		    $sth->execute();
707 
-    		} catch(PDOException $e) {
707 
+    		} catch (PDOException $e) {
708 708 
 		    return "error (update schema_version) : ".$e->getMessage()."\n";
709 709 
     		}
710 710 
 		return $error;
 
@@ -719,13 +719,13 @@  discard block
 
 block discarded – undo
719 719 
 			$error .= create_db::import_file('../db/airlines.sql');
720 720 
 			if ($error != '') return 'Import airlines.sql : '.$error;
721 721 
 		}
722 
-		if (!$Connection->checkColumnName('aircraft_modes','type_flight')) {
722 
+		if (!$Connection->checkColumnName('aircraft_modes', 'type_flight')) {
723 723 
 			// Add column over_country
724 724 
     			$query = "ALTER TABLE `aircraft_modes` ADD `type_flight` VARCHAR(50) NULL DEFAULT NULL;";
725 725 
         		try {
726 726 
 				$sth = $Connection->db->prepare($query);
727 727 
 				$sth->execute();
728 
-			} catch(PDOException $e) {
728 
+			} catch (PDOException $e) {
729 729 
 				return "error (add over_country) : ".$e->getMessage()."\n";
730 730 
     			}
731 731 
     		}
 
@@ -741,7 +741,7 @@  discard block
 
 block discarded – undo
741 741 
         	try {
742 742 
             	    $sth = $Connection->db->prepare($query);
743 743 
 		    $sth->execute();
744 
-    		} catch(PDOException $e) {
744 
+    		} catch (PDOException $e) {
745 745 
 		    return "error (update schema_version) : ".$e->getMessage()."\n";
746 746 
     		}
747 747 
 		return $error;
 
@@ -750,13 +750,13 @@  discard block
 
 block discarded – undo
750 750 
 	private static function update_from_21() {
751 751 
 		$Connection = new Connection();
752 752 
 		$error = '';
753 
-		if (!$Connection->checkColumnName('stats_airport','stats_type')) {
753 
+		if (!$Connection->checkColumnName('stats_airport', 'stats_type')) {
754 754 
 			// Rename type to stats_type
755 755 
 			$query = "ALTER TABLE `stats_airport` CHANGE `type` `stats_type` VARCHAR(50);ALTER TABLE `stats` CHANGE `type` `stats_type` VARCHAR(50);ALTER TABLE `stats_flight` CHANGE `type` `stats_type` VARCHAR(50);";
756 756 
 			try {
757 757 
 				$sth = $Connection->db->prepare($query);
758 758 
 				$sth->execute();
759 
-			} catch(PDOException $e) {
759 
+			} catch (PDOException $e) {
760 760 
 				return "error (rename type to stats_type on stats*) : ".$e->getMessage()."\n";
761 761 
 			}
762 762 
 			if ($error != '') return $error;
 
@@ -765,7 +765,7 @@  discard block
 
 block discarded – undo
765 765 
         	try {
766 766 
             	    $sth = $Connection->db->prepare($query);
767 767 
 		    $sth->execute();
768 
-    		} catch(PDOException $e) {
768 
+    		} catch (PDOException $e) {
769 769 
 		    return "error (update schema_version) : ".$e->getMessage()."\n";
770 770 
     		}
771 771 
 		return $error;
 
@@ -788,7 +788,7 @@  discard block
 
 block discarded – undo
788 788 
         	try {
789 789 
             	    $sth = $Connection->db->prepare($query);
790 790 
 		    $sth->execute();
791 
-    		} catch(PDOException $e) {
791 
+    		} catch (PDOException $e) {
792 792 
 		    return "error (update schema_version) : ".$e->getMessage()."\n";
793 793 
     		}
794 794 
 		return $error;
 
@@ -815,17 +815,17 @@  discard block
 
 block discarded – undo
815 815 
 			try {
816 816 
 				$sth = $Connection->db->prepare($query);
817 817 
 				$sth->execute();
818 
-			} catch(PDOException $e) {
818 
+			} catch (PDOException $e) {
819 819 
 				return "error (create index on spotter_archive) : ".$e->getMessage()."\n";
820 820 
 			}
821 821 
 		}
822 
-		if (!$Connection->checkColumnName('stats_aircraft','aircraft_manufacturer')) {
822 
+		if (!$Connection->checkColumnName('stats_aircraft', 'aircraft_manufacturer')) {
823 823 
 			// Add aircraft_manufacturer to stats_aircraft
824 824 
     			$query = "ALTER TABLE stats_aircraft ADD aircraft_manufacturer VARCHAR(255) NULL";
825 825 
 			try {
826 826 
 				$sth = $Connection->db->prepare($query);
827 827 
 				$sth->execute();
828 
-			} catch(PDOException $e) {
828 
+			} catch (PDOException $e) {
829 829 
 				return "error (add aircraft_manufacturer column) : ".$e->getMessage()."\n";
830 830 
     			}
831 831 
     		}
 
@@ -834,7 +834,7 @@  discard block
 
 block discarded – undo
834 834 
 		try {
835 835 
 			$sth = $Connection->db->prepare($query);
836 836 
 			$sth->execute();
837 
-		} catch(PDOException $e) {
837 
+		} catch (PDOException $e) {
838 838 
 			return "error (update schema_version) : ".$e->getMessage()."\n";
839 839 
 		}
840 840 
 		return $error;
 
@@ -850,26 +850,26 @@  discard block
 
 block discarded – undo
850 850 
 			$error .= create_db::import_file('../db/pgsql/airlines.sql');
851 851 
 		}
852 852 
 		if ($error != '') return 'Import airlines.sql : '.$error;
853 
-		if (!$Connection->checkColumnName('airlines','forsource')) {
853 
+		if (!$Connection->checkColumnName('airlines', 'forsource')) {
854 854 
 			// Add forsource to airlines
855 855 
 			$query = "ALTER TABLE airlines ADD forsource VARCHAR(255) NULL DEFAULT NULL";
856 856 
 			try {
857 857 
 				$sth = $Connection->db->prepare($query);
858 858 
 				$sth->execute();
859 
-			} catch(PDOException $e) {
859 
+			} catch (PDOException $e) {
860 860 
 				return "error (add forsource column) : ".$e->getMessage()."\n";
861 861 
 			}
862 862 
 		} else {
863 
-			$errort = $Connection->checkColumnName('airlines','forsource');
863 
+			$errort = $Connection->checkColumnName('airlines', 'forsource');
864 864 
 			if ($errort !== true && $errort !== false) return 'Error check column airlines : '.$errort;
865 865 
 		}
866 
-		if (!$Connection->checkColumnName('stats_aircraft','stats_airline')) {
866 
+		if (!$Connection->checkColumnName('stats_aircraft', 'stats_airline')) {
867 867 
 			// Add forsource to airlines
868 868 
 			$query = "ALTER TABLE stats_aircraft ADD stats_airline VARCHAR(255) NULL DEFAULT '', ADD filter_name VARCHAR(255) NULL DEFAULT ''";
869 869 
 			try {
870 870 
 				$sth = $Connection->db->prepare($query);
871 871 
 				$sth->execute();
872 
-			} catch(PDOException $e) {
872 
+			} catch (PDOException $e) {
873 873 
 				return "error (add stats_airline & filter_name column in stats_aircraft) : ".$e->getMessage()."\n";
874 874 
 			}
875 875 
 			// Add unique key
 
@@ -881,17 +881,17 @@  discard block
 
 block discarded – undo
881 881 
 			try {
882 882 
 				$sth = $Connection->db->prepare($query);
883 883 
 				$sth->execute();
884 
-			} catch(PDOException $e) {
884 
+			} catch (PDOException $e) {
885 885 
 				return "error (add unique key in stats_aircraft) : ".$e->getMessage()."\n";
886 886 
 			}
887 887 
 		}
888 
-		if (!$Connection->checkColumnName('stats_airport','stats_airline')) {
888 
+		if (!$Connection->checkColumnName('stats_airport', 'stats_airline')) {
889 889 
 			// Add forsource to airlines
890 890 
 			$query = "ALTER TABLE stats_airport ADD stats_airline VARCHAR(255) NULL DEFAULT '', ADD filter_name VARCHAR(255) NULL DEFAULT ''";
891 891 
 			try {
892 892 
 				$sth = $Connection->db->prepare($query);
893 893 
 				$sth->execute();
894 
-			} catch(PDOException $e) {
894 
+			} catch (PDOException $e) {
895 895 
 				return "error (add filter_name column in stats_airport) : ".$e->getMessage()."\n";
896 896 
 			}
897 897 
 			// Add unique key
 
@@ -903,20 +903,20 @@  discard block
 
 block discarded – undo
903 903 
 			try {
904 904 
 				$sth = $Connection->db->prepare($query);
905 905 
 				$sth->execute();
906 
-			} catch(PDOException $e) {
906 
+			} catch (PDOException $e) {
907 907 
 				return "error (add unique key in stats_airport) : ".$e->getMessage()."\n";
908 908 
 			}
909 909 
 		} else {
910 
-			$errort = $Connection->checkColumnName('stats_airport','stats_airline');
910 
+			$errort = $Connection->checkColumnName('stats_airport', 'stats_airline');
911 911 
 			if ($errort !== true && $errort !== false) return 'Error check column stats_airport : '.$errort;
912 912 
 		}
913 
-		if (!$Connection->checkColumnName('stats_country','stats_airline')) {
913 
+		if (!$Connection->checkColumnName('stats_country', 'stats_airline')) {
914 914 
 			// Add forsource to airlines
915 915 
 			$query = "ALTER TABLE stats_country ADD stats_airline VARCHAR(255) NULL DEFAULT '', ADD filter_name VARCHAR(255) NULL DEFAULT ''";
916 916 
 			try {
917 917 
 				$sth = $Connection->db->prepare($query);
918 918 
 				$sth->execute();
919 
-			} catch(PDOException $e) {
919 
+			} catch (PDOException $e) {
920 920 
 				return "error (add stats_airline & filter_name column in stats_country) : ".$e->getMessage()."\n";
921 921 
 			}
922 922 
 			// Add unique key
 
@@ -928,36 +928,36 @@  discard block
 
 block discarded – undo
928 928 
 			try {
929 929 
 				$sth = $Connection->db->prepare($query);
930 930 
 				$sth->execute();
931 
-			} catch(PDOException $e) {
931 
+			} catch (PDOException $e) {
932 932 
 				return "error (add unique key in stats_airline) : ".$e->getMessage()."\n";
933 933 
 			}
934 934 
 		}
935 
-		if (!$Connection->checkColumnName('stats_flight','stats_airline')) {
935 
+		if (!$Connection->checkColumnName('stats_flight', 'stats_airline')) {
936 936 
 			// Add forsource to airlines
937 937 
 			$query = "ALTER TABLE stats_flight ADD stats_airline VARCHAR(255) NULL DEFAULT '', ADD filter_name VARCHAR(255) NULL DEFAULT ''";
938 938 
 			try {
939 939 
 				$sth = $Connection->db->prepare($query);
940 940 
 				$sth->execute();
941 
-			} catch(PDOException $e) {
941 
+			} catch (PDOException $e) {
942 942 
 				return "error (add stats_airline & filter_name column in stats_flight) : ".$e->getMessage()."\n";
943 943 
 			}
944 944 
 		}
945 
-		if (!$Connection->checkColumnName('stats','stats_airline')) {
945 
+		if (!$Connection->checkColumnName('stats', 'stats_airline')) {
946 946 
 			// Add forsource to airlines
947 947 
 			$query = "ALTER TABLE stats ADD stats_airline VARCHAR(255) NULL DEFAULT '', ADD filter_name VARCHAR(255) NULL DEFAULT ''";
948 948 
 			try {
949 949 
 				$sth = $Connection->db->prepare($query);
950 950 
 				$sth->execute();
951 
-			} catch(PDOException $e) {
951 
+			} catch (PDOException $e) {
952 952 
 				return "error (add stats_airline & filter_name column in stats) : ".$e->getMessage()."\n";
953 953 
 			}
954 
-			if ($globalDBdriver == 'mysql' && $Connection->indexExists('stats','type')) {
954 
+			if ($globalDBdriver == 'mysql' && $Connection->indexExists('stats', 'type')) {
955 955 
 				// Add unique key
956 956 
 				$query = "drop index type on stats;ALTER TABLE stats ADD UNIQUE stats_type (stats_type,stats_date,stats_airline,filter_name);";
957 957 
 				try {
958 958 
 					$sth = $Connection->db->prepare($query);
959 959 
 					$sth->execute();
960 
-				} catch(PDOException $e) {
960 
+				} catch (PDOException $e) {
961 961 
 					return "error (add unique key in stats) : ".$e->getMessage()."\n";
962 962 
 				}
963 963 
 			} else {
 
@@ -970,18 +970,18 @@  discard block
 
 block discarded – undo
970 970 
 				try {
971 971 
 					$sth = $Connection->db->prepare($query);
972 972 
 					$sth->execute();
973 
-				} catch(PDOException $e) {
973 
+				} catch (PDOException $e) {
974 974 
 					return "error (add unique key in stats) : ".$e->getMessage()."\n";
975 975 
 				}
976 976 
 			}
977 977 
 		}
978 
-		if (!$Connection->checkColumnName('stats_registration','stats_airline')) {
978 
+		if (!$Connection->checkColumnName('stats_registration', 'stats_airline')) {
979 979 
 			// Add forsource to airlines
980 980 
 			$query = "ALTER TABLE stats_registration ADD stats_airline VARCHAR(255) NULL DEFAULT '', ADD filter_name VARCHAR(255) NULL DEFAULT ''";
981 981 
 			try {
982 982 
 				$sth = $Connection->db->prepare($query);
983 983 
 				$sth->execute();
984 
-			} catch(PDOException $e) {
984 
+			} catch (PDOException $e) {
985 985 
 				return "error (add stats_airline & filter_name column in stats_registration) : ".$e->getMessage()."\n";
986 986 
 			}
987 987 
 			// Add unique key
 
@@ -993,17 +993,17 @@  discard block
 
 block discarded – undo
993 993 
 			try {
994 994 
 				$sth = $Connection->db->prepare($query);
995 995 
 				$sth->execute();
996 
-			} catch(PDOException $e) {
996 
+			} catch (PDOException $e) {
997 997 
 				return "error (add unique key in stats_registration) : ".$e->getMessage()."\n";
998 998 
 			}
999 999 
 		}
1000 
-		if (!$Connection->checkColumnName('stats_callsign','filter_name')) {
1000 
+		if (!$Connection->checkColumnName('stats_callsign', 'filter_name')) {
1001 1001 
 			// Add forsource to airlines
1002 1002 
 			$query = "ALTER TABLE stats_callsign ADD filter_name VARCHAR(255) NULL DEFAULT ''";
1003 1003 
 			try {
1004 1004 
 				$sth = $Connection->db->prepare($query);
1005 1005 
 				$sth->execute();
1006 
-			} catch(PDOException $e) {
1006 
+			} catch (PDOException $e) {
1007 1007 
 				return "error (add filter_name column in stats_callsign) : ".$e->getMessage()."\n";
1008 1008 
 			}
1009 1009 
 			// Add unique key
 
@@ -1015,17 +1015,17 @@  discard block
 
 block discarded – undo
1015 1015 
 			try {
1016 1016 
 				$sth = $Connection->db->prepare($query);
1017 1017 
 				$sth->execute();
1018 
-			} catch(PDOException $e) {
1018 
+			} catch (PDOException $e) {
1019 1019 
 				return "error (add unique key in stats_callsign) : ".$e->getMessage()."\n";
1020 1020 
 			}
1021 1021 
 		}
1022 
-		if (!$Connection->checkColumnName('stats_airline','filter_name')) {
1022 
+		if (!$Connection->checkColumnName('stats_airline', 'filter_name')) {
1023 1023 
 			// Add forsource to airlines
1024 1024 
 			$query = "ALTER TABLE stats_airline ADD filter_name VARCHAR(255) NULL DEFAULT ''";
1025 1025 
 			try {
1026 1026 
 				$sth = $Connection->db->prepare($query);
1027 1027 
 				$sth->execute();
1028 
-			} catch(PDOException $e) {
1028 
+			} catch (PDOException $e) {
1029 1029 
 				return "error (add filter_name column in stats_airline) : ".$e->getMessage()."\n";
1030 1030 
 			}
1031 1031 
 			// Add unique key
 
@@ -1037,7 +1037,7 @@  discard block
 
 block discarded – undo
1037 1037 
 			try {
1038 1038 
 				$sth = $Connection->db->prepare($query);
1039 1039 
 				$sth->execute();
1040 
-			} catch(PDOException $e) {
1040 
+			} catch (PDOException $e) {
1041 1041 
 				return "error (add unique key in stats_callsign) : ".$e->getMessage()."\n";
1042 1042 
 			}
1043 1043 
 		}
 
@@ -1046,7 +1046,7 @@  discard block
 
 block discarded – undo
1046 1046 
 		try {
1047 1047 
 			$sth = $Connection->db->prepare($query);
1048 1048 
 			$sth->execute();
1049 
-		} catch(PDOException $e) {
1049 
+		} catch (PDOException $e) {
1050 1050 
 			return "error (update schema_version) : ".$e->getMessage()."\n";
1051 1051 
 		}
1052 1052 
 		return $error;
 
@@ -1056,13 +1056,13 @@  discard block
 
 block discarded – undo
1056 1056 
 		global $globalDBdriver;
1057 1057 
 		$Connection = new Connection();
1058 1058 
 		$error = '';
1059 
-		if (!$Connection->checkColumnName('stats_owner','stats_airline')) {
1059 
+		if (!$Connection->checkColumnName('stats_owner', 'stats_airline')) {
1060 1060 
 			// Add forsource to airlines
1061 1061 
 			$query = "ALTER TABLE stats_owner ADD stats_airline VARCHAR(255) NULL DEFAULT '', ADD filter_name VARCHAR(255) NULL DEFAULT ''";
1062 1062 
 			try {
1063 1063 
 				$sth = $Connection->db->prepare($query);
1064 1064 
 				$sth->execute();
1065 
-			} catch(PDOException $e) {
1065 
+			} catch (PDOException $e) {
1066 1066 
 				return "error (add stats_airline & filter_name column in stats_owner) : ".$e->getMessage()."\n";
1067 1067 
 			}
1068 1068 
 			// Add unique key
 
@@ -1074,17 +1074,17 @@  discard block
 
 block discarded – undo
1074 1074 
 			try {
1075 1075 
 				$sth = $Connection->db->prepare($query);
1076 1076 
 				$sth->execute();
1077 
-			} catch(PDOException $e) {
1077 
+			} catch (PDOException $e) {
1078 1078 
 				return "error (add unique key in stats_owner) : ".$e->getMessage()."\n";
1079 1079 
 			}
1080 1080 
 		}
1081 
-		if (!$Connection->checkColumnName('stats_pilot','stats_airline')) {
1081 
+		if (!$Connection->checkColumnName('stats_pilot', 'stats_airline')) {
1082 1082 
 			// Add forsource to airlines
1083 1083 
 			$query = "ALTER TABLE stats_pilot ADD stats_airline VARCHAR(255) NULL DEFAULT '', ADD filter_name VARCHAR(255) NULL DEFAULT ''";
1084 1084 
 			try {
1085 1085 
 				$sth = $Connection->db->prepare($query);
1086 1086 
 				$sth->execute();
1087 
-			} catch(PDOException $e) {
1087 
+			} catch (PDOException $e) {
1088 1088 
 				return "error (add stats_airline & filter_name column in stats_pilot) : ".$e->getMessage()."\n";
1089 1089 
 			}
1090 1090 
 			// Add unique key
 
@@ -1096,7 +1096,7 @@  discard block
 
 block discarded – undo
1096 1096 
 			try {
1097 1097 
 				$sth = $Connection->db->prepare($query);
1098 1098 
 				$sth->execute();
1099 
-			} catch(PDOException $e) {
1099 
+			} catch (PDOException $e) {
1100 1100 
 				return "error (add unique key in stats_pilot) : ".$e->getMessage()."\n";
1101 1101 
 			}
1102 1102 
 		}
 
@@ -1104,7 +1104,7 @@  discard block
 
 block discarded – undo
1104 1104 
 		try {
1105 1105 
 			$sth = $Connection->db->prepare($query);
1106 1106 
 			$sth->execute();
1107 
-		} catch(PDOException $e) {
1107 
+		} catch (PDOException $e) {
1108 1108 
 			return "error (update schema_version) : ".$e->getMessage()."\n";
1109 1109 
 		}
1110 1110 
 		return $error;
 
@@ -1127,7 +1127,7 @@  discard block
 
 block discarded – undo
1127 1127 
 		    try {
1128 1128 
             		$sth = $Connection->db->prepare($query);
1129 1129 
 		        $sth->execute();
1130 
-		    } catch(PDOException $e) {
1130 
+		    } catch (PDOException $e) {
1131 1131 
 			return "error : ".$e->getMessage()."\n";
1132 1132 
     		    }
1133 1133 
     		    $result = $sth->fetch(PDO::FETCH_ASSOC);
Please login to merge, or discard this patch.