/* Include Files *********************/
session_start();
error_reporting(0);
$connection = mysql_connect('85.25.235.202', SBSRemote,SBSRemote) or die ("Unable to connect to MySQL server.");
$db = mysql_select_db("modes") or die ("Unable to select requested database");
include("../../login.php");
//displayLogin();
include("../../save/Restricted.php");
// uitbreiden met password
$the__user=$_SESSION['username'];
$Unit="300SQN";
$Unit2="300SQN";
$aantal =2500;
if (empty($max)) $max = 50; // $max is het maximaal aantal resultaten per pagina
if (empty($start)) $start = 0; // Laten staan, hiermee begint de query op het goede punt
$eind = $start + $max; // Voor de query, tot welke record die moet gaan
$vorige = $start - $max; // Voor de variabele start voor 'vorige'-link
$volgende = $eind; // Voor de variabele start voor 'volgende'-link
$sorteervolgorde=$SortOrder;
$welkland=$WhichCountry;
$vorigserial='';
$datum2 =date("Y-m-d", mktime (0, 0, 0, date("m"),date("d")-2, date("Y")));
function PhotoOrNot($Serial, $Country)
{
$link = mysql_connect("localhost", "LiveModeS", "LiveModeS");
mysql_select_db("modes", $link);
$query321 = mysql_query("Select * from ModeSPhotos where Serial='$Serial'");
$aantal321 = mysql_num_rows($query321);
if($aantal321==0)
{
echo "
| ";
}
else
{
echo " | ";
}
mysql_close($link);
}
function Status($HEXCODE, $LOCATION,$DATE)
{
$link = mysql_connect("localhost", "LiveModeS", "LiveModeS");
mysql_select_db("modes", $link);
$query2 = mysql_query("SELECT * FROM statuslive where ((HexCode='$HEXCODE' ) and (Location='$LOCATION') and (Date='$DATE')) ORDER BY Time desc limit 0,1");
$aantal44 = mysql_num_rows($query2); // aantal records met verstuurd emailadres tellen
if($aantal44 == 0)
{
echo "--- | \n";
echo "--- | \n";
}
else
{
while ($row = mysql_fetch_assoc($query2))
{
$Varsquawk = $row[squawk];
$VarAltitude = $row[Altitude];
$Varsquawk = $row[squawk];
if (empty($Varsquawk))
{
$Varsquawk="---";
}
echo "$Varsquawk | \n";
echo "$VarAltitude | \n";
}
}
mysql_close($link);
}
?>
Mode-s logs
html5.php">
if ($the__user=='Albert')
{
echo "
";
echo " Type | Serial | Unit |
";
$query66 = mysql_query("SELECT * FROM code,NoADSBHex where code.code=NoADSBHex.HexCode and NoADSBHex.ICAO='$Unit2' " );
$query666 = mysql_query($query66);
if (!$query666) {
die('Invalid query: ' . mysql_error());
}
while ($row = mysql_fetch_assoc($query66))
{
$CSSerial66= $row["type"];
$CSType166= $row["serial"];
$CSType266= $row["Operator"];
$CSHexCode266= $row["HexCode"];
echo "$CSSerial66 | $CSType166 | $CSType266 |
";
echo "Remove | | |
";
}
echo " | | |
";
echo "Add |
";
echo "
";
}
else
{
echo "
";
echo " Type | Serial | Unit |
";
$query66 = mysql_query("SELECT * FROM code,NoADSBHex where code.code=NoADSBHex.HexCode and NoADSBHex.ICAO='$Unit2' " );
while ($row = mysql_fetch_assoc($query66))
{
$CSSerial66= $row["type"];
$CSType166= $row["serial"];
$CSType266= $row["Operator"];
echo "$CSSerial66 | $CSType166 | $CSType266 |
";
}
echo "If you have any updates please use contact form |
";
echo "
";
}
?>
$query1 = mysql_query("SELECT * FROM livegmt join code on code.code=livegmt.HexId join NoADSBHex on livegmt.HexId=NoADSBHex.HexCode where (NoADSBHex.ICAO='$Unit2') ORDER BY livegmt.GMT desc LIMIT $start, $max" );
$color1="#66CCFF";
$color2="#66CCCC";
$row_count=1;
$row_color="#66CCCC";
$vorigserial='';
$welkland=$WhichCountry;
echo "";
echo "\n";
echo " | \n";
echo "Serial | \n";
echo " | \n";
echo "Callsign
| \n";
echo "GMT | \n";
echo "Type | \n";
echo "Country
| \n";
echo "Operator | \n";
echo "Location | \n";
echo "Squawk | \n";
echo "Altitude |
\n";
while ($row = mysql_fetch_assoc($query1))
{
$CSDateQ= $row["HexId"];
$CSOperatorQ= $row["Date"];
$CSGMT= $row["GMT"];
$CSMessageQ= $row["Time"];
$CSTimeQ= $row["CSID"];
$CSSerial= $row["type"];
$CSType= $row["Country"];
$CSType1= $row["serial"];
$CSType2= $row["Operator"];
$CSType3= $row["Location"];
include ("../../search/flags.php");
if ($CSType1=="..+.."||$CSType1=="------")
{
echo "$CSType1 | \n";
}
else
{
$check=$CSType1{2};
If ($check=='+' )
{
$rest = substr ($CSType1, 0,2);
$rest1 = substr ($CSType1, 3,5);
$serial=$rest.$rest1;
echo "$CSType1 | \n";
}
else
{
$serial=$CSType1;
echo "$CSType1 | \n";
}
}
PhotoOrNot($CSType1,$CSType);
echo "$CSTimeQ | \n";
echo " $CSGMT | \n";
//$CSMessageQShow=substr($CSMessageQ,0,5);
//echo "$CSMessageQShow | \n";
echo "$CSSerial | \n";
echo "$CSType | \n";
if ($CSType2=="---")
{
echo "$CSType2 | \n";
}
else
{
// $CSType2\n";
}
echo "$CSType3 | \n";
Status($CSDateQ,$CSType3,$CSOperatorQ);
//echo "$CSGMT | \n";
$row_color=($row_count % 2) ? $color1 : $color2;
$row_count++;
if($row_count==25)
{
echo "
";
echo "
";
echo "
";
?>
echo "
";
echo "
";
echo "\n";
}
}
mysql_close($conn);
echo "
\n ";
?>