AirNav RadarBox
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
 


Author Topic: RadarBox 2008 Log File  (Read 6243 times)

0 Members and 1 Guest are viewing this topic.

lennox2604

  • RadarBox Beta Testers
  • New Member
  • *
  • Posts: 32
RadarBox 2008 Log File
« on: March 06, 2008, 09:16:09 PM »
Just downloaded 2008

And it is GOOD

My onl very very small moan is that the Flight number is not includedin daily log .


Does anybody know a SQL set of commands to extract the information from the SQL database as I now very little of programming

Thanks AIRNAV

Any chance of a HFDL programme after Ship tracker

Jim C

tarbat

  • ShipTrax Beta Testers
  • Hero Member
  • *
  • Posts: 4219
    • Radarbox at Easter Ross
Re: RadarBox 2008 Log File
« Reply #1 on: March 06, 2008, 09:23:17 PM »
My onl very very small moan is that the Flight number is not includedin daily log .

SELECT
  Flights.ModeS,
  Flights.Registration,
  Flights.Callsign,
  Flights.Route,
  Flights.StartTime,
  Flights.EndTime,
  Flights.Session,
  Flights.MsgCount
FROM
 Flights
ORDER BY
  Flights.Registration

SQL generated using SQLite Maestro

And this retrieves almost everything from MyLog.db3:

SELECT DISTINCT
  Aircraft.ModeS,
  Aircraft.Registration,
  Aircraft.AircraftTypeSmall,
  Aircraft.AircraftTypeLong,
  Aircraft.Airline,
  Aircraft.ModeSCountry,
  Aircraft.Comment,
  Aircraft.FirstTime,
  Aircraft.LastTime,
  Flights.Callsign,
  Flights.Route,
  Flights.StartTime,
  Flights.EndTime,
  Flights.MsgCount,
  Sessions.ID,
  Sessions.Location,
  Sessions.StartTime,
  Sessions.EndTime,
  Sessions.MsgCount
FROM
 Sessions
 LEFT OUTER JOIN Flights ON (Sessions.ID=Flights.Session)
 LEFT OUTER JOIN Aircraft ON (Flights.ModeS=Aircraft.ModeS)
ORDER BY
  Aircraft.Registration,
  Flights.Callsign,
  Sessions.ID
« Last Edit: March 06, 2008, 10:05:54 PM by tarbat »

lennox2604

  • RadarBox Beta Testers
  • New Member
  • *
  • Posts: 32
Re: RadarBox 2008 Log File
« Reply #2 on: March 06, 2008, 10:06:32 PM »
Tarbat

 Many thanks for that script

I know we have just started but how do you specify a date to isolate any day

Jim C

tarbat

  • ShipTrax Beta Testers
  • Hero Member
  • *
  • Posts: 4219
    • Radarbox at Easter Ross
Re: RadarBox 2008 Log File
« Reply #3 on: March 06, 2008, 10:11:12 PM »

I know we have just started but how do you specify a date to isolate any day

WHERE
  (Flights.StartTime >= "2008/03/06 00:00:00") AND
  (Flights.EndTime < "2008/03/07 00:00:00")


will give you all flights on 6th March 2008.

BTW, I know almost nothing about SQL, but using SQLite Maestro lets you create SQL using the visual query builder.
« Last Edit: March 06, 2008, 10:33:51 PM by tarbat »

lennox2604

  • RadarBox Beta Testers
  • New Member
  • *
  • Posts: 32
Re: RadarBox 2008 Log File
« Reply #4 on: March 06, 2008, 10:39:41 PM »
Tarbat

Many thanks for that

Jim C