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

[Mike L]

I didn't think of it that way. I will work on it. Tnx

Mike



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

> If the field is set up as a datetime type (not a string, an actual MySQL
> datetime column) then it doesn't matter what Xastir does you can still
> extract the date in the query.
>
> Use "describe <tablename>"  to find out if it's of type datetime and you're
> set.
>
> --- On Wed, 1/27/10, Mike L <w2swrster at gmail.com> wrote:
>
> > From: Mike L <w2swrster at gmail.com>
> > Subject: Re: [Xastir] Xastir => MySQL?? =>php
> > To: "Xastir - APRS client software discussion" <xastir at lists.xastir.org>
> > Date: Wednesday, January 27, 2010, 11:15 PM
> > 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
> > >
> > _______________________________________________
> > 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
>