airhaul Posted December 6, 2013 Report Share Posted December 6, 2013 Cleaned up the code in fsbuildparse.php so it works better This is an updated version of Nabeel's code for navdata update which is avaliable by search in forums -All intersections uploaded with a lat/lng -All VOR / NDB correctly labeled -Intersections all go in instead of hanging up Works with fsbuild airac Used 1310 myself Loading airways segments...91220 airway segments loaded... Loading VORs...965 VORs added, 2834 updated Loading NDBs...2202 NDBs added, 1800 updated Loading INTs...93944 INTs added, 54743 bypassed already in DB Completed! -Would recommend backing up navdata table in database before running -Program deletes all previous data in phpvms_navdata table before updating -Also program will not work if the table phpvms_navdata is not present. If it isnt go to DBadmin and copy structure only from navdata table to phpvms_navdata -Inserts into phpvms_navdata table. If prefix is different rename phpvms_navdata to navdata for example when complete -Use at your own risk. Works great with me but can't say it will with everyone. How to load NAVDATA for phpVMS ------------- 1. Unzip navdata.zip 2. Obtain fsbuild airac 3. Install fsbuild airac into same folder as fsbuild.exe(airac file) 4. need to have three files awys.txt -airways (default fsbuild) ints.txt - intersections (default fsbuild) navs.txt - ndb/vor (default fsbuild - code fixed to label vor/ndb separately) 5. Take the 3 files listed above insert them into navdata/fsbuild folder Optional - Recommend sorting out lat/lng intersections in ints.txt and any intersection that is not 5 characters in length 6. Open db.php file and insert your DB username, password, & server name into the appropraiate places between '' 7. Upload navdata folder into root directory of site 8. Connect to server with ssh app. I use putty 9. cd to navdata 10. run php -f fsbuildparse.php at prompt 11. Takes maybe 5 mins or so then should get Loading airways segments...91220 airway segments loaded... Loading VORs...965 VORs added, 2834 updated Loading NDBs...2202 NDBs added, 1800 updated Loading INTs...93944 INTs added, 54743 bypassed already in DB Completed! navdata.zip 2 Quote Link to comment Share on other sites More sharing options...
ARV187 Posted December 6, 2013 Report Share Posted December 6, 2013 After i will try it. thanks by the aportation Quote Link to comment Share on other sites More sharing options...
ARV187 Posted December 7, 2013 Report Share Posted December 7, 2013 Is there another way without putty? i dont know how work that program Quote Link to comment Share on other sites More sharing options...
airhaul Posted December 7, 2013 Author Report Share Posted December 7, 2013 Sorry only have used putty. Could set it up to run in admin or load page from browser but it wipes out the table navdata everytime you run it Problem is you want to run once then delete the files and folders Putty pretty easy to use for me Select ssh put in web address then click connect At prompt type in login and password Then >cd public_html/navdata Then >php -f fsbuildparse.php Contact your Hosting company, they might have to enable SSH for putty to work Quote Link to comment Share on other sites More sharing options...
ARV187 Posted December 7, 2013 Report Share Posted December 7, 2013 <?phperror_reporting(E_ALL & ~E_NOTICE); $db = mysql_connect('localhost', 'db username goes here', 'db password goes here'); mysql_select_db('db server name goes here'); define('NAV_NDB', 2); define('NAV_VOR', 3); define('NAV_DME', 4); define('NAV_FIX', 5); Only db server name? not db name? Not work to me, in putty I enter the webpage of VA or name server... but i get error network no work time out. I find this option: Quote Link to comment Share on other sites More sharing options...
airhaul Posted December 7, 2013 Author Report Share Posted December 7, 2013 This process is not the easiest but I have listed all the steps. Try customer service at your Hosting company for SSH problems open local.config.php in core folder, then copy the DB info name, password, server name into db.php $db = mysql_connect('localhost', 'joetest', 'password') mysql_select_db('aerodb'); Mine is localhost and is for most people but change it if different in local.config.php Quote Link to comment Share on other sites More sharing options...
Jakubovsky Posted December 12, 2013 Report Share Posted December 12, 2013 Loading airways segments...============ MySQL server has gone away ========== Quote Link to comment Share on other sites More sharing options...
Luka.Niko Posted December 16, 2013 Report Share Posted December 16, 2013 Hello! I have the same problem: Loading airways segments...============ MySQL server has gone away ========== Quote Link to comment Share on other sites More sharing options...
FSX30HD Posted December 17, 2013 Report Share Posted December 17, 2013 look to you php. ini this value upload_max_filesize = 64M post_max_size = 64M max_execution_time = 600 1 Quote Link to comment Share on other sites More sharing options...
Strider Posted December 26, 2013 Report Share Posted December 26, 2013 I am getting a max_allowed_packet error. Anyway of fixing that? Quote Link to comment Share on other sites More sharing options...
FSX30HD Posted December 27, 2013 Report Share Posted December 27, 2013 I am getting a max_allowed_packet error. Anyway of fixing that? just put this in my.ini max_allowed_packet = 16M or shell> mysqld --max_allowed_packet=16M http://dev.mysql.com/doc/refman/5.5/en/packet-too-large.html Regards Fred Quote Link to comment Share on other sites More sharing options...
Strider Posted December 27, 2013 Report Share Posted December 27, 2013 I tried looking for my.ini but cant find it. Can I use the second one with putty? Quote Link to comment Share on other sites More sharing options...
Strider Posted December 27, 2013 Report Share Posted December 27, 2013 IT has been done. Updated my navdata table to 1313 Quote Link to comment Share on other sites More sharing options...
Sava Posted December 27, 2013 Report Share Posted December 27, 2013 Is someone willing to export the phpvms_navdata they have in their DB so not all of us have to go through the process/ 3 Quote Link to comment Share on other sites More sharing options...
ARV187 Posted December 28, 2013 Report Share Posted December 28, 2013 Is someone willing to export the phpvms_navdata they have in their DB so not all of us have to go through the process/ Good post!! Quote Link to comment Share on other sites More sharing options...
Cor Posted December 28, 2013 Report Share Posted December 28, 2013 Good post!! +1 Everyone have a great and healthy 2014 Regards, Cor Quote Link to comment Share on other sites More sharing options...
Jakubovsky Posted December 29, 2013 Report Share Posted December 29, 2013 IT has been done. Updated my navdata table to 1313 can you please share your 1313 navdata? Quote Link to comment Share on other sites More sharing options...
Strider Posted December 30, 2013 Report Share Posted December 30, 2013 I can share the table, but the airac cycle from navigraph no. Quote Link to comment Share on other sites More sharing options...
Jakubovsky Posted December 30, 2013 Report Share Posted December 30, 2013 Table:) Quote Link to comment Share on other sites More sharing options...
freshJet Posted December 31, 2013 Report Share Posted December 31, 2013 I can share the table, but the airac cycle from navigraph no. Could you please? Can anyone verify all is OK with it too? Quote Link to comment Share on other sites More sharing options...
Angel Air Posted January 5, 2014 Report Share Posted January 5, 2014 It looks like fivedev does not support SSH I have tried to connect to the server using putty but it can not connect so if anyone has managed this would the mind uploading the .SQL file for navdata so we have all got a working copy. Please and thankyou Quote Link to comment Share on other sites More sharing options...
FSX30HD Posted January 17, 2014 Report Share Posted January 17, 2014 Optional - Recommend sorting out lat/lng intersections in ints.txt and any intersection that is not 5 characters in length Howto make that ? Please Regards Fred Quote Link to comment Share on other sites More sharing options...
McWilliams Posted January 27, 2014 Report Share Posted January 27, 2014 Anyone willing to export navdata table? Quote Link to comment Share on other sites More sharing options...
ARV187 Posted February 3, 2014 Report Share Posted February 3, 2014 Not, nobody, that i know at least. Its a pity. Quote Link to comment Share on other sites More sharing options...
FSX30HD Posted February 3, 2014 Report Share Posted February 3, 2014 Anyone willing to export navdata table? Yes but not for Navigraph copyright, sorry. Regards Fred Quote Link to comment Share on other sites More sharing options...
ARV187 Posted February 3, 2014 Report Share Posted February 3, 2014 (edited) Ok, navigraph, but Navdata table is confidential? if i search all routes in routefinder or public civil aviation authorities, not is the same? (with more work obvious). Is a eternal cuestion, public info packed by a private enterprise, is ethical? or is ethical take public info from enterprise without pay?, are complicate cuestions. Edited February 3, 2014 by ARV187 Quote Link to comment Share on other sites More sharing options...
FSX30HD Posted February 3, 2014 Report Share Posted February 3, 2014 Is a eternal cuestion, public info packed by a private enterprise, is ethical? or is ethical take public info from enterprise without pay?, are complicate cuestions. I'm agree with you in this point. In my case a pay Navigraph to "work" with free datas and make them in Setup... But look at jeff's website http://www.fs-products.net/index.php/downloads/viewcategory/6-phpvms-modules Quote Link to comment Share on other sites More sharing options...
ARV187 Posted May 11, 2014 Report Share Posted May 11, 2014 Hi again, I have Jeff's navdata, but i have much errors: Here is public information about navdata, so this information share in .csv or .sql format not is illegal!!! I think that pay to navigraft is because setups to diferents devices & sims, not by data wich is public. http://www.icao.int/...3freqlist02.pdf Quote Link to comment Share on other sites More sharing options...
Kapitan Posted September 29, 2014 Report Share Posted September 29, 2014 Works perfect , i do a bit changes to the script it self and works ...if anyone intrested pm. Quote Link to comment Share on other sites More sharing options...
Sava Posted September 29, 2014 Report Share Posted September 29, 2014 Might be easier for you to post it here so if down the line someone needs it, he can find it here 1 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.