Meteo VATSIM in the template

[AlessandroCuba]

Small code showing the VATSIM weather in the template, random

<div id="metar">

<?php

$sql = "SELECT ".TABLE_PREFIX."airports.id, ".TABLE_PREFIX."airports.icao as icao, ".TABLE_PREFIX."airports.name, ".TABLE_PREFIX."airports.country as country

FROM ".TABLE_PREFIX."airports ORDER BY RAND() LIMIT 1";

$result = mysql_query( $sql );

while ($row = mysql_fetch_row($result))

{

echo"<h3>METAR (ICAO: ".$row[1].")</h3>";

echo "Aeropuerto: <font color='#ff6600'>".$row[2]."</font><br />";

$adresse = 'http://metar.vatsim.net/metar.php?id=';

$homepage = file_get_contents($adresse.''.$row[1]);

echo "<font color='#2997ba'>".$homepage."<font>";

}

?>

</div>