View GitHub Repository FlightAirMap

Schedule Inspection
Subscribe

Code Duplication    Length = 22-22 lines in 2 locations

install/class.update_schema.php 2 locations

@@ 285-306 (lines=22) @@
282 
    		} catch(PDOException $e) {
283 
		    return "error (add pilot column to spotter_live and spotter_output) : ".$e->getMessage()."\n";
284 
    		}
285 
    		if ($globalDBdriver == 'mysql') {
286 
    		    $query = "SELECT ENGINE FROM information_schema.TABLES where TABLE_SCHEMA = '".$globalDBname."' AND TABLE_NAME = 'spotter_archive'";
287 
		    try {
288 
            		$sth = $Connection->db->prepare($query);
289 
			$sth->execute();
290 
    		    } catch(PDOException $e) {
291 
			return "error (problem when select engine for spotter_engine) : ".$e->getMessage()."\n";
292 
    		    }
293 
    		    $row = $sth->fetch(PDO::FETCH_ASSOC);
294 
    		    if ($row['engine'] == 'ARCHIVE') {
295 
			$query = "CREATE TABLE copy LIKE spotter_archive;
296 
				ALTER TABLE copy ENGINE=ARCHIVE;
297 
				ALTER TABLE copy ADD pilot_name VARCHAR(255) NULL, ADD pilot_id VARCHAR(255) NULL;
298 
				INSERT INTO copy SELECT *, '' as pilot_name, '' as pilot_id FROM spotter_archive ORDER BY `spotter_archive_id`;
299 
				DROP TABLE spotter_archive;
300 
				RENAME TABLE copy TO spotter_archive;";
301 
            	    } else {
302 
    			$query="ALTER TABLE spotter_archive ADD pilot_name VARCHAR(255) NULL, ADD pilot_id VARCHAR(255) NULL";
303 
            	    }
304 
                } else {
305 
    		    $query="ALTER TABLE spotter_archive ADD pilot_name VARCHAR(255) NULL, ADD pilot_id VARCHAR(255) NULL";
306 
                }
307 
        	try {
308 
            	    $sth = $Connection->db->prepare($query);
309 
		    $sth->execute();
@@ 426-447 (lines=22) @@
423 
    		} catch(PDOException $e) {
424 
		    return "error (format_source column to spotter_live) : ".$e->getMessage()."\n";
425 
    		}
426 
    		if ($globalDBdriver == 'mysql') {
427 
    		    $query = "SELECT ENGINE FROM information_schema.TABLES where TABLE_SCHEMA = '".$globalDBname."' AND TABLE_NAME = 'spotter_archive'";
428 
		    try {
429 
            		$sth = $Connection->db->prepare($query);
430 
			$sth->execute();
431 
    		    } catch(PDOException $e) {
432 
			return "error (problem when select engine for spotter_engine) : ".$e->getMessage()."\n";
433 
    		    }
434 
    		    $row = $sth->fetch(PDO::FETCH_ASSOC);
435 
    		    if ($row['engine'] == 'ARCHIVE') {
436 
			$query = "CREATE TABLE copy LIKE spotter_archive;
437 
				ALTER TABLE copy ENGINE=ARCHIVE;
438 
				ALTER TABLE copy ADD verticalrate INT(11) NULL, ADD format_source VARCHAR(255) NULL DEFAULT NULL, ADD ground BOOLEAN NOT NULL DEFAULT FALSE;
439 
				INSERT INTO copy SELECT *, '' as verticalrate, '' as format_source, '0' as ground FROM spotter_archive ORDER BY `spotter_archive_id`;
440 
				DROP TABLE spotter_archive;
441 
				RENAME TABLE copy TO spotter_archive;";
442 
            	    } else {
443 
    			$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 
            	    }
445 
                } else {
446 
    		    $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 
                }
448 
        	try {
449 
            	    $sth = $Connection->db->prepare($query);
450 
		    $sth->execute();