[Xastir] Xastir => MySQL?? =>php

[Mike L]

Tnx Alex,

Yes I agree, the dash is a poor choice. I will change that. There is a row
in the table called "transmit_time datetime" but with out the database
running via Xastir, I have know way of knowing what it will output. If it
does what we are hoping I will use it as well as adding a selectable switch
between sort by callsign and sort by transmit time.

Yup, thats me! Hi Hi, always worried about syntax and forgetting the
spelling! tnx for catching that.

Mike

--


On Wed, Jan 27, 2010 at 10:59 PM, Alex Carver <kf4lvz at yahoo.com> wrote:

> I like it, it's a lot cleaner than the page I had made some time ago (but
> doesn't use Xastir).  A couple suggestions:  First, I would suggest you
> separate the coordinates with something other than a dash because some
> coordinates will be negative for some users (east/west, north/south).
>  Second, if there is a "last heard" timestamp in the database then you
> should add that to the table so people can tell the age of a report (finer
> resolution than just "less than 24 hours old").
>
> Also, you misspelled "coordinates" but I'm picky on everyone about spelling
> (including my parents) so don't take it personally. ;)
>
> -Alex
>
> --- On Wed, 1/27/10, Mike <w2swrster at gmail.com> wrote:
>
> > From: Mike <w2swrster at gmail.com>
> > Subject: Re: [Xastir] Xastir => MySQL?? =>php
> > To: Xastir at lists.xastir.org
> > Date: Wednesday, January 27, 2010, 10:51 PM
> > Hi all,
> >
> > Check out http://aprs.w2swr.com/xastir-online
> >
> > This is a working php linked to a MySQL db with junk data
> > thrown into the tables. Only thing keeping it from operating
> > is the Xastir link to MySQL. Once thats fixed I will go
> > further with a distro.
> >
> > 73
> > Mike, W2SWR
> >
> > --
> >
> > > Hi All,
> > >
> > >   Just an update. I have successfully
> > completed a working prototype php script to pull data from a
> > MySQL xastir_db.  This will allow users of Xastir on
> > linux to publish a webpage of their live aprs data plus
> > a  screenshot of their current Xastir map via the
> > snapshot module including a timestamp.
> > >   Due to the fact that the MySQL
> > support in Xastir is currently broken, the database I used
> > is a mockup which I built based on the db_gis_mysql.sql file
> > with random test data manually inserted into the tables.
> > Once the MySQL support in Xastir is repaired, I will clean
> > up and complete the php script and publish my php script for
> > all to use.
> > >
> > > Mike, W2SWR
> >
> > _______________________________________________
> > Xastir mailing list
> > Xastir at lists.xastir.org
> > http://lists.xastir.org/cgi-bin/mailman/listinfo/xastir
> >
>
>
>
> _______________________________________________
> Xastir mailing list
> Xastir at lists.xastir.org
> http://lists.xastir.org/cgi-bin/mailman/listinfo/xastir
>