AirNav Systems Forum

AirNav RadarBox and RadarBox24.com => AirNav RadarBox and RadarBox24.com Discussion => Topic started by: apjwright on July 24, 2010, 08:31:50 PM

Title: MyFlights list
Post by: apjwright on July 24, 2010, 08:31:50 PM

Hi.  Can anybody shed light (AirNav support?) on where exactly (if anywhere) the aircraft that are listed on the MyFlights tab are stored ... in a database table (if so, which)?  File?

Thanks in advance,
Tony

Title: Re: MyFlights list
Post by: neroon79 on July 24, 2010, 08:43:49 PM

Goto Radarbox Main Directory. (E:\Programme\AirNav Systems\AirNav RadarBox\Data e.g.)
Then goto Subdirectory Data an look for the MyLog.db3 File. This is the Database were the MyLog Tables are stored.

There are various free ware Database Programs / Tools like SQLite Browser available in the www. Some are mentioned here in the forum as well. Please try the search function. But before tooling (messing) around with your Database file be sure to make a Back UP file ;-)

Title: Re: MyFlights list
Post by: apjwright on July 24, 2010, 08:46:27 PM

Thanks for the response.

I understand that, but 'exactly' where are the flights that are currently displayed stored?  If in MyLog.db3, which table ?

Title: Re: MyFlights list
Post by: neroon79 on July 24, 2010, 09:05:41 PM

Don't know if I'm guessing right, but I think you could find the actual flights in the db3 journal file. But the problem is, that you won't get acces to this file, while RB software is running. That you can't copy it (Windows refuses) neither you can open it with a Database tool. And if you shut down RB Soft, the journal files are finally integrated into the MyLog.db3 I guess. So the only way to get look into this files is to shut down RB Soft by crowbar...

Title: Re: MyFlights list
Post by: AirNav Support on July 24, 2010, 10:58:55 PM

apjwright,

Do you mean the current aircraft in your MyFlights at that time? If so this data is kept in memory and cannot be read.

Title: Re: MyFlights list
Post by: apjwright on July 25, 2010, 04:04:51 AM

Quote from: AirNav Support on July 24, 2010, 10:58:55 PM

apjwright,

Do you mean the current aircraft in your MyFlights at that time? If so this data is kept in memory and cannot be read.

Yes.  This is interesting.  I'm wondering how tools like ADQ are able to provide a utility that integrates the MyFlights content with ADQ data to show what aircraft are needed, etc?  I am trying to do the same thing with my ADU database ...

Thanks,
Tony

Title: Re: MyFlights list
Post by: tarbat on July 25, 2010, 07:32:51 AM

Maybe ADQ uses the port 30003 output?

Title: Re: MyFlights list
Post by: AirNav Support on July 26, 2010, 09:08:08 AM

apjwright,

The software you are talking about and others will read off from the port data from 30003/7879 and then apply timeouts to the data it has got and update the rest with the latest values.

An example is one of our support team members site (it doesn't have all the information but it can do):

http://www.akzah.com/anrb/data.xml