"; } 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 <?echo $Unit; ?> html5.php">
"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\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 "\n"; } else { $check=$CSType1{2}; If ($check=='+' ) { $rest = substr ($CSType1, 0,2); $rest1 = substr ($CSType1, 3,5); $serial=$rest.$rest1; echo "\n"; } else { $serial=$CSType1; echo "\n"; } } PhotoOrNot($CSType1,$CSType); echo "\n"; echo "\n"; //$CSMessageQShow=substr($CSMessageQ,0,5); //echo "\n"; echo "\n"; echo "\n"; if ($CSType2=="---") { echo "\n"; } else { // $CSType2\n"; } echo "\n"; Status($CSDateQ,$CSType3,$CSOperatorQ); //echo "\n"; $row_color=($row_count % 2) ? $color1 : $color2; $row_count++; if($row_count==25) { echo "
Serial
Callsign
GMT
Type
Country
Operator
Location
Squawk
Altitude
$CSType1$CSType1$CSType1$CSTimeQ $CSGMT$CSMessageQShow$CSSerial$CSType$CSType2$CSType3$CSGMT
"; echo "
"; echo "
"; ?>
"; echo "
"; echo "\n"; } } mysql_close($conn); echo "
\n "; ?>