<script src="//netdna.bootstrapcdn.com/bootstrap/3.1.1/js/bootstrap.min.js"></script>
<link href="//netdna.bootstrapcdn.com/font-awesome/4.0.3/css/font-awesome.css" rel="stylesheet">
<link type="text/css" rel="stylesheet" href="<?php
print $globalURL;
?>
/css/style-tv.css?<?php
print time();
?>
" />
</head>
<body>
<?php
if (isset($_GET['q'])) {
$spotter_array = Spotter::searchSpotterData($_GET['q'], "", "", "", "", "", "", "", "", "", "", "", "", "", "0,10", "", "");
} else {
$spotter_array = Spotter::getLatestSpotterData("0,10", "");
}
print '<div class="table-responsive">';
print '<table id="table-tv">';
print '<tbody>';
foreach ($spotter_array as $spotter_item) {
if (isset($globalTimezone)) {
date_default_timezone_set($globalTimezone);
} else {
date_default_timezone_set('UTC');
}
print '<tr>';
if (isset($_GET['image']) && $_GET['image'] == "true") {
if ($spotter_item['image'] != "") {
}
} else {
$limit_explode = explode(",", $_GET['limit']);
$limit_start = $limit_explode[0];
$limit_end = $limit_explode[1];
}
$absolute_difference = abs($limit_start - $limit_end);
$limit_next = $limit_end + $absolute_difference;
$limit_previous_1 = $limit_start - $absolute_difference;
$limit_previous_2 = $limit_end - $absolute_difference;
if ($_GET['download'] == "true") {
header('Content-disposition: attachment; filename="barriespotter.rss"');
}
header('Content-Type: application/rss+xml; charset=utf-8');
$date = date("c", time());
$spotter_array = Spotter::searchSpotterData($_GET['q'], $_GET['registration'], $_GET['aircraft'], strtolower(str_replace("-", " ", $_GET['manufacturer'])), $_GET['highlights'], $_GET['airline'], $_GET['airline_country'], $_GET['airline_type'], $_GET['airport'], $_GET['airport_country'], $_GET['callsign'], $_GET['departure_airport_route'], $_GET['arrival_airport_route'], $sql_altitude, $sql_date, $limit_start . "," . $absolute_difference, $_GET['sort'], '');
print '<?xml version="1.0" encoding="UTF-8" ?>';
print '<feed xmlns="http://www.w3.org/2005/Atom" xmlns:georss="http://www.georss.org/georss" xmlns:gml="http://www.opengis.net/gml">';
print '<title>Barrie Spotter GeoRSS Feed</title>';
print '<link href="http://www.barriespotter.com/"/>';
print '<subtitle>The latest airplanes flying over the Barrie area</subtitle>';
print '<updated>' . $date . '</updated>';
print '<author>';
print '<name>Barrie Spotter</name>';
print '<email>no-reply@barriespotter.com</email>';
print '</author>';
print '<id>http://www.barriespotter.com/</id>';
if (!empty($spotter_array)) {
foreach ($spotter_array as $spotter_item) {
print '<entry>';
print '<title>' . $spotter_item['ident'] . ' ' . $spotter_item['airline_name'] . ' | ' . $spotter_item['registration'] . ' ' . $spotter_item['aircraft_name'] . ' (' . $spotter_item['aircraft_type'] . ') | ' . $spotter_item['departure_airport'] . ' - ' . $spotter_item['arrival_airport'] . '</title>';
$registration = filter_input(INPUT_GET, 'registratrion', FILTER_SANITIZE_STRING);
$aircraft = filter_input(INPUT_GET, 'aircraft', FILTER_SANITIZE_STRING);
$manufacturer = filter_input(INPUT_GET, 'manufacturer', FILTER_SANITIZE_STRING);
$highlights = filter_input(INPUT_GET, 'highlights', FILTER_SANITIZE_STRING);
$airline = filter_input(INPUT_GET, 'airline', FILTER_SANITIZE_STRING);
$airline_country = filter_input(INPUT_GET, 'airline_country', FILTER_SANITIZE_STRING);
$airline_type = filter_input(INPUT_GET, 'airline_type', FILTER_SANITIZE_STRING);
$airport = filter_input(INPUT_GET, 'airport', FILTER_SANITIZE_STRING);
$airport_country = filter_input(INPUT_GET, 'airport_country', FILTER_SANITIZE_STRING);
$callsign = filter_input(INPUT_GET, 'callsign', FILTER_SANITIZE_STRING);
$owner = filter_input(INPUT_GET, 'owner', FILTER_SANITIZE_STRING);
$pilot_id = filter_input(INPUT_GET, 'pilot_id', FILTER_SANITIZE_STRING);
$pilot_name = filter_input(INPUT_GET, 'pilot_name', FILTER_SANITIZE_STRING);
$departure_airport_route = filter_input(INPUT_GET, 'departure_airport_route', FILTER_SANITIZE_STRING);
$arrival_airport_route = filter_input(INPUT_GET, 'arrival_airport_route', FILTER_SANITIZE_STRING);
$spotter_array = $Spotter->searchSpotterData($q, $registration, $aircraft, strtolower(str_replace("-", " ", $manufacturer)), $highlights, $airline, $airline_country, $airline_type, $airport, $airport_country, $callsign, $departure_airport_route, $arrival_airport_route, $owner, $pilot_id, $pilot_name, $sql_altitude, $sql_date, $limit_start . "," . $absolute_difference, $sort, '');
$output = '{';
$output .= '"flightairmap": {';
$output .= '"title": "FlightAirMap JSON Feed",';
$output .= '"link": "http://www.flightairmap.fr",';
$output .= '"aircraft": [';
if (!empty($spotter_array)) {
foreach ($spotter_array as $spotter_item) {
$output .= '{';
$output .= '"id": "' . $spotter_item['spotter_id'] . '",';
$output .= '"ident": "' . $spotter_item['ident'] . '",';
$output .= '"registration": "' . $spotter_item['registration'] . '",';
$output .= '"aircraft_icao": "' . $spotter_item['aircraft_type'] . '",';
$output .= '"aircraft_name": "' . $spotter_item['aircraft_name'] . '",';
$output .= '"aircraft_manufacturer": "' . $spotter_item['aircraft_manufacturer'] . '",';
$output .= '"airline_name": "' . $spotter_item['airline_name'] . '",';
<script src="//netdna.bootstrapcdn.com/bootstrap/3.1.1/js/bootstrap.min.js"></script>
<link href="//netdna.bootstrapcdn.com/font-awesome/4.0.3/css/font-awesome.css" rel="stylesheet">
<link type="text/css" rel="stylesheet" href="<?php
print $globalURL;
?>
/css/style-tv.css?<?php
print time();
?>
" />
</head>
<body>
<?php
if (isset($_GET['q'])) {
$spotter_array = $Spotter->searchSpotterData($_GET['q'], "", "", "", "", "", "", "", "", "", "", "", "", "", "0,10", "", "");
} else {
$spotter_array = $Spotter->getLatestSpotterData("0,10", "");
}
print '<div class="table-responsive">';
print '<table id="table-tv">';
print '<tbody>';
foreach ($spotter_array as $spotter_item) {
if (isset($globalTimezone)) {
date_default_timezone_set($globalTimezone);
} else {
date_default_timezone_set('UTC');
}
print '<tr>';
if (isset($_GET['image']) && $_GET['image'] == "true") {
if ($spotter_item['image'] != "") {
