Jump to content

Recommended Posts

Posted

Hi all again!

Since i have no idea how to implement phpVMS into my site, i was wondering can someone help me with original FsACARS scripts, as they are easiest for me to install on site. It is work by hand in relation with phpVMS which is automated and perfectly assembled, but my lack of knowledge is frustrating me so...here is gmap script, take a look and tell me why it wouldnt show on site...

Code :

<?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/.'>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 = "***";

$pw = "***";

$dbreal_name = "***";

// 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=1&key=MAP KEY HERE!!!" 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>

</head>

<body class="content">

<div id="map" style="width: 750px; height: 500px; z-index:1; 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), 11);

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

function createMarker(point, number, $callsign)

{

var marker = new GMarker(point, $callsign);

// 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:800px; height:600px; z-index:1; left: 150px; top: 510px;">

  <?php

$cont = 1;

/* mysql error */

if (!$result) {

    print "Error - Database Connection.";

    $cont = 0;

}

if ($cont) {

    if (mysql_numrows($result) == 0) {

        print "No current flights<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>

</body>

Guest CableGuy
Posted

Well if you are wanting to implement the sata virtual acars into your own site, Please google search "Sata Virtual ACARS" and they original scripts and readme's will come with it. If you check out the phpVMS Docs, Their are tutorials on how to work with phpVMS and how to work with your custom skin and getting it integrated with VMS its self. Very easy.

Posted

Sure, sorry for my layk of knowledge, but did u try to search for FsACARS scripts which is dead allmost 3 years now? Hehe, didint think so...It seems that this is API key issue, map is just dont shown on page...never mind, ill try again with phpVMS, just need some site template...So all of my old site will be dead, too bad...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...