<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2769" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=375223309-09122005><FONT face=Arial
size=2>Gudday</FONT></SPAN></DIV>
<DIV><SPAN class=375223309-09122005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=375223309-09122005><FONT face=Arial size=2>Need some help from
the APRS community. </FONT></SPAN><SPAN class=375223309-09122005><FONT
face=Arial size=2>googleearth and aprs down here is gaining momentum.
</FONT></SPAN></DIV>
<DIV><SPAN class=375223309-09122005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=375223309-09122005><FONT face=Arial size=2>I am getting more
and more requests to use my cgi. (which telnets into findu and then returns data
- clunky)</FONT></SPAN></DIV>
<DIV><SPAN class=375223309-09122005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=375223309-09122005><FONT face=Arial size=2>What I need is some
help by hosting a google_earth.cgi on an aprs database server, findu.com
aprsworld, openaprs, that will return some simple data.</FONT></SPAN></DIV>
<DIV><SPAN class=375223309-09122005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=375223309-09122005><FONT face=Arial size=2>At the moment my
cgi is really clunky because it has to telnet into findu,com every
time it wants a position. Not to mention slow. And the port
limitations.</FONT></SPAN></DIV>
<DIV><SPAN class=375223309-09122005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=375223309-09122005><FONT face=Arial size=2>And it is using the
posit.cgi script on Steve's box and it returns lots of positions and I throw
away everything except the last posit,</FONT></SPAN></DIV>
<DIV><SPAN class=375223309-09122005></SPAN><SPAN class=375223309-09122005><FONT
face=Arial size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=375223309-09122005><FONT face=Arial size=2>I will write all the
code. What we really need is the database host to talk to google earth
directly.</FONT></SPAN></DIV>
<DIV><SPAN class=375223309-09122005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=375223309-09122005><FONT face=Arial size=2>Here is the code at
the moment, as you can see it telnet's findu.com, what we really need is a mysql
connection and one posit returned :-</FONT></SPAN></DIV>
<DIV><SPAN class=375223309-09122005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=375223309-09122005><FONT face=Arial size=2>What it has to do is
return lat and lon, given callsign</FONT></SPAN></DIV>
<DIV><SPAN class=375223309-09122005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=375223309-09122005><FONT face=Arial size=2>Here you can see an
example output</FONT></SPAN></DIV>
<DIV><SPAN class=375223309-09122005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=375223309-09122005><FONT face=Arial size=2><A
href="http://vk4tec.no-ip.org/cgi-bin/google_earth.cgi?Call=vk4tec-9">http://vk4tec.no-ip.org/cgi-bin/google_earth.cgi?Call=vk4tec-9</A></FONT></SPAN></DIV>
<DIV><SPAN class=375223309-09122005></SPAN><SPAN
class=375223309-09122005></SPAN><SPAN class=375223309-09122005></SPAN><SPAN
class=375223309-09122005></SPAN><SPAN class=375223309-09122005></SPAN><SPAN
class=375223309-09122005><FONT face=Arial size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=375223309-09122005><FONT face=Arial size=2>All it has to do is
return a lat and lon from a callsign.</FONT></SPAN></DIV>
<DIV><SPAN class=375223309-09122005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=375223309-09122005><FONT face=Arial size=2>#!/usr/bin/perl
<BR># </FONT></SPAN></DIV>
<DIV><SPAN class=375223309-09122005><FONT face=Arial size=2># APRS and
GoogleEarth kml file gen from findu.com data</FONT></SPAN></DIV>
<DIV><SPAN class=375223309-09122005><FONT face=Arial size=2># Andrew Rich VK4TEC
</FONT></SPAN></DIV>
<DIV><SPAN class=375223309-09122005><FONT face=Arial
size=2>#</FONT></SPAN></DIV>
<DIV><SPAN class=375223309-09122005><FONT face=Arial size=2>use
Net::Telnet;<BR>my $host = "<A
href="http://www.findu.com">www.findu.com</A>";<BR>my (@data, $line);<BR>my $t =
new Net::Telnet(Timeout=> '50', port =>
'80');<BR>$t->errmode('return');<BR>$t->Net::Telnet::open($host);<BR>#sleep
5;<BR>print $t "GET
/cgi-bin/posit.cgi?call=".$FORM{Call}."&comma=1\n";<BR>while
(<$t>)<BR>{<BR>if (m/,/)<BR>{<BR>@data = split/,/;<BR>$long =
$data[1];<BR>$lat =
$data[0];<BR>}<BR>}<BR>$t->close;<BR></FONT></SPAN></DIV><SPAN
class=375223309-09122005><FONT face=Arial size=2>
<DIV> </DIV>
<DIV></FONT></SPAN> </DIV>
<P><FONT face=Arial size=2>-----------------------------------------<BR>Andrew
Rich - VK4TEC<BR></FONT><A href="mailto:vk4tec@tech-software.net"><FONT
face=Arial size=2>vk4tec@tech-software.net</FONT></A><BR><FONT face=Arial
size=2>www.tech-software.net<BR>Brisbane AUSTRALIA </FONT></P>
<DIV><SPAN class=375223309-09122005><FONT face=Arial
size=2> </FONT></SPAN></DIV></BODY></HTML>