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

[Alex Carver]

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
>