
I was able to customize marker to be picture of satellite photo plane, so everyone whos flying saw as as real as they can...but...I want callsign of pilot whos currently flying to be displayed over his aircraft in white or yellow colour. The callsign is taken from database, like long and lat which use for displaying plane...
this is my script and PLEASE HELP ME WITH IT...i got marker, icon, and i dont have a clue how to display callsign i think its $callsign in scripts...
<?php
/*
!!!A QUICK NOTE!!!
Some of the database fields may have changed and you will need to alter them to your
database.
Remember to backup your database before you make any changes or you will regret it.
You will need to have a registered Google Map key which you can get for free from
http://www.google.com/apis/maps/.
You will need to know your database structure with username and password details.
I have made db connection easy but you can edit it as your coding levels suit. Ideally
You should have a link to the db connection but that is entirely up to you.
Anyway, hope this helps you in working out how to use google maps on your VA.
Cheers
Steph.
*/
/* CHANGE THESE LINES TO YOUR DETAILS */
/* make connection to database */
$hostreal_name = "localhost";
$userreal_name = "xxx";
$pw = "xxx";
$dbreal_name = "xxx";
// Remember, you need to register with Google Map to get a valid registration key.
// This key must be placed where I have put "###UR_KEY_HERE###" located in the <script src=> tag below.
?>
<head>
<!--
Place you google map key in the line below over the "###UR_KEY_HERE###" text
If you do not have a key this will not work. You can obtain a key from http://www.google.com/apis/maps/
-->
<script src=" http://maps.google.com/maps?file=api&v= ... _x87dZ05Ig" type="text/javascript"></script>
<link href="../css/css.css" rel="stylesheet" type="text/css" />
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_reloadPage(init) { //reloads the window if Nav4 resized
if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
//-->
</script>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><style type="text/css">
<!--
body {
background-image: url(Images/Fsacarseurope.jpg);
}
-->
</style><title>Air Croatia virtual - FSAcars Europa</title></head>
<body class="content">
<div id="map" style="width: 750px; height: 500px; z-index:1; top: 150px; left: 138px;"> </div>
<script type="text/javascript">
// This is the google map part
// Thes map settings are set to show Australia, so you will
// need to change co ordinates to suit your needs.
//<![CDATA[
//Center map on Alice Springs
var map = new GMap(document.getElementById("map"));
//$GMap->setMapType('G_HYBRID_TYPE');
map.addControl(new GLargeMapControl());
map.addControl(new GMapTypeControl());
// Alice Springs
// LAT LON
// S2348'08.57 E13353'12.16
map.centerAndZoom(new GPoint(15.532080078125, 44.770059260080004), 13);
map.setMapType(G_SATELLITE_TYPE);
// Palo Alto
// LAT LON
// N3727'40.03 W12206'54.16
//map.centerAndZoom(new GPoint(-122.1419, 37.4419), 4);
// Creates a marker whose info window displays the given number
var icon2 = new GIcon();
icon2.image = "http://www.aircroatia-virtual.com/Image5.png";
icon2.iconSize = new GSize(20, 17);
icon2.iconAnchor = new GPoint(29, 14);
icon2.infoWindowAnchor = new GPoint(5, 1);
function createMarker(point, number)
{
var marker = new GMarker(point, icon2);
// Show this markers index in the info window when it is clicked
var html = number;
GEvent.addListener(marker, "click", function() {marker.openInfoWindowHtml(html);});
return marker;
};
<?php
$link = mysql_connect("$hostreal_name", "$userreal_name", "$pw") or die("Could not connect: " . mysql_error());
mysql_selectdb("$dbreal_name",$link) or die ("Can\'t use dbmapserver : " . mysql_error());
$result = mysql_query("SELECT * FROM positions WHERE last_update > DATE_SUB( NOW() , INTERVAL 5 MINUTE )", $link);
if (!$result)
{
echo "no results ";
}
while($row = mysql_fetch_array($result))
{
// This is the data displayed in the google map text box when you click on a pilot name
$info = "Pilot: ".$row['pilot_num'] . "<br>" . "From: " . $row['depAptICAO'] ." To: " . $row['destAptICAO'] . "<br>" . "Online: " . $row['Online'] . "<br>" . "GS: " . $row['gs'] . "<br>" . "ALT: " . $row['alt'] . "<br>" . "ETA: " . $row['timeDestApt'];
echo "var point = new GPoint(" . $row['lon'] . "," . $row['lat'] . ");\n";
echo "var marker = createMarker(point, '" . $info . "');\n";
echo "map.addOverlay (marker);\n";
echo "\n";
}
mysql_close($link);
?>
//]]>
</script>
<div id="Layer1" style="position:absolute; width:797px; height:344px; z-index:1; left: 153px; top: 669px;">
<?php
$cont = 1;
/* mysql error */
if (!$result) {
print "Error - Database Connection.";
$cont = 0;
}
if ($cont) {
if (mysql_numrows($result) == 0) {
print "<td><font face=Verdana color=#000080 size=2>Svi piloti se trenutno odmaraju...<br><br><br>";
} else {
print "<table align=left >";
print "<tr>";
print "<td bgcolor=#000080 height=12 align=center><font face=Verdana color=#FFFFFF size=1><b>Pilot</b></font></td>";
print "<td bgcolor=#000080 height=12 align=center><font face=Verdana color=#FFFFFF size=1><b>Flight#</b></font></td>";
print "<td bgcolor=#000080 height=12 align=center><font face=Verdana color=#FFFFFF size=1><b>From/To</b></font></td>";
print "<td bgcolor=#000080 height=12 align=center><font face=Verdana color=#FFFFFF size=1><b>Dist. from Ori.</b></font></td>";
print "<td bgcolor=#000080 height=12 align=center><font face=Verdana color=#FFFFFF size=1><b>Dist. to Dest.</b></font></td>";
print "<td bgcolor=#000080 height=12 align=center><font face=Verdana color=#FFFFFF size=1><b>Alt</b></font></td>";
print "<td bgcolor=#000080 height=12 align=center><font face=Verdana color=#FFFFFF size=1><b>GS</b></font></td>";
print "<td bgcolor=#000080 height=12 align=center><font face=Verdana color=#FFFFFF size=1><b>ETE</b></font></td>";
print "<td bgcolor=#000080 height=12 align=center><font face=Verdana color=#FFFFFF size=1><b>STATUS</b></font></td>";
print "<td bgcolor=#000080 height=12 align=center><font face=Verdana color=#FFFFFF size=1><b>Online</b></font></td>";
print "</tr>";
$phase_colors = array();
$phase_colors[0] = "color=#FFFFFF"; // Disconnected from ACARS - White
$phase_colors[1] = "color=#CCCCCC"; // Boarding - Gray
$phase_colors[2] = "color=#FF00FF"; // Taxi From Gate - Purple
$phase_colors[3] = "color=#0000FF"; // Departing - Blue
$phase_colors[4] = "color=#00FFFF"; // Climbing - Cyan
$phase_colors[5] = "color=#00FF00"; // Cruising - Green
$phase_colors[6] = "color=#FFFF00"; // Descending - Yellow
$phase_colors[7] = "color=#FF8800"; // Landed - Orange
$phase_colors[8] = "color=#FF0000"; // Taxi To Gate - Red
$phase_colors[9] = "color=#FFFFFF"; // Arrived at Gate - White
$phase_msgs = array();
$phase_msgs[0] = "Disconnected";
$phase_msgs[1] = "Boarding";
$phase_msgs[2] = "Taxi From Gate";
$phase_msgs[3] = "Departing";
$phase_msgs[4] = "Enroute";
$phase_msgs[5] = "Enroute";
$phase_msgs[6] = "Descending";
$phase_msgs[7] = "Landed";
$phase_msgs[8] = "Taxi To Gate";
$phase_msgs[9] = "Arrived At Gate";
$number = mysql_numrows($result);
for ($i=0; $i < $number; $i++) {
$pnum = mysql_result($result,$i,"pilot_num");
$alt = mysql_result($result,$i,"alt");
$gs = mysql_result($result,$i,"gs");
$callsign = mysql_result($result,$i,"IATA");
$dep = mysql_result($result,$i,"depAptICAO");
$depreal_name = mysql_result($result,$i,"depapt");
$dest = mysql_result($result,$i,"destAptICAO");
$destreal_name = mysql_result($result,$i,"destapt");
$distOrig = mysql_result($result,$i,"disDepApt");
$distDest = mysql_result($result,$i,"disDestApt");
$ETA = mysql_result($result,$i,"timeDestApt");
$phase = mysql_result($result,$i,"phase");
$Online = mysql_result($result,$i,"online");
print "<tr>";
print "<td width=30 height=12 align=center><font face=Verdana color=#000080 size=1>ACV$pnum</font></td>";
print "<td width=60 height=12 align=center><font face=Verdana color=#000080 size=1>$callsign</font></td>";
print "<td width=100 height=12 align=center><font face=Verdana color=#000080 size=1>$dep TO $dest</font></td>";
print "<td width=60 height=12 align=center><font face=Verdana color=#000080 size=1>$distOrig</font></td>";
print "<td width=60 height=12 align=center><font face=Verdana color=#000080 size=1>$distDest</font></td>";
print "<td width=60 height=12 align=center><font face=Verdana color=#000080 size=1>$alt</font></td>";
print "<td width=30 height=12 align=center><font face=Verdana color=#000080 size=1>$gs</font></td>";
print "<td width=60 height=12 align=center><font face=Verdana color=#000080 size=1>$ETA</font></td>";
print "<td bgcolor=#000000 width=150 height=12 align=center><font face=Verdana ".$phase_colors[$phase]." size=1><b>".$phase_msgs[$phase]."</b></font></td>";
print "</tr>";
}
}
}
?>
</div>
<div id="Layer2" style="position:absolute; width:64px; height:26px; z-index:2; top: 129px; left: 928px;"><a href="http://www.aircroatia-virtual.com/" target="_self"><img src="Images/h-053.gif" width="60" height="23" border="0"></a></div>
</body>
Thank YOU ALL!!!