phpvms_navdata updated from Airac 1307 =)

[AndreNix]

This is an alternative update for phpvms_navdata.

I decided to update my table but I had no patience to make manually.

In addition to complicated and exhaustive update manually, I decided to use the AIRAC

How to?

Simple!

I used FSBUILD_1307.exe, extracted and renamed the files.

I don't have fsbuild installed on my pc, just grabbed the file for FSUILD and extract in a single folder.

Note:

To unzip and install the AIRAC effective, I created fsbuild.exe in Notepad.

I selected the folder on the supposed fsbuild.exe and extract the files

Which files?

FSBUILD_1307.exe ORIGINAL RENAMED

** ints.txt <-----> INTERSECTIONS.txt

** awys.txt <-----> AIRWAYS.txt

** navs.txt <-----> NDB-VOR.txt

I used the phpvms_navdata from Nabeel Shahzad (Thank´s Nabeel) and I analyzed the fsbuildparse.php!

GitHub - https://github.com/nshahzad/phpvms_navdata

https://github.com/nshahzad/phpvms_navdata/blob/master/fsbuildparse.php

Airways = Line 82 ----> $handle = fopen('fsbuild/fsb_awy2.txt', 'r'); --- awys.txt

VORs = Line 159 ---> $handle = fopen("fsbuild/fsb_vor.txt", "r"); --- navs.txt

NDBs = Line 235 ---> $handle = fopen('fsbuild/fsb_ndb.txt', 'r'); --- navs.txt again

INTs = Line 312 ---> $handle = fopen('fsbuild/fsb_int.txt', 'r'); --- ints.txt

Simple, no?

I changed the file fsbuildparse.php for my personal use.

How do I update my table (index)?

How to use?

modify the db.php file for your data (mysqlserver, user, password and database) and run the following command:

php-f update.php

this works!!!

19.0 MB - phpvms_navdata

284.843 lines =)

Perhaps not a great alternative, but it's a great start!!

Change, create, deploy and distribute.

navdata_update.zip

[FSX30HD]

Thanks for sharing

Have you an idea to put SID / STAR in your modified script ?

I see also your NAT are all to lat long at zero edit manually mine to do that

http://www.vataware.com/flight.cfm?id=10515757

the command it's php -f update.php not php-f

But I'm happy for your script good job

Regards Fred

[Boogace]

Hi great work by the way but can you tell me where to run php -f update.php please i have followed it letter by letter but this part stumps me ?

[web541]

Hi,

You may consider using this tutorial as it is updated and works as it should.

http://forum.phpvms.net/topic/19993-navdata-update/#entry109279

[hurkulez]

phpvms_navdata_1601.zip

[hurkulez]

phpvms_navdata 1607: UPDATED 22 June 2016 | 1330 Hrs US Central Time | 1830 Zulu

See Original Post

[hurkulez]

phpvms_navdata 1609: UPDATED 18 August 2016 | 06:58 Hrs US Central Time | 11:58 Zulu

See Original Post