APX0475 Posted November 12, 2010 Report Share Posted November 12, 2010 Afternoon Gents, Im stuck in a delma and I just dont know how Im going to go about solving it. Is there anyone with a complete SQL database for the airports by any chance? I could go in manually and add EVERY airport because Im just going to have a universal Flight number that everyone will use. But I REALLY dont feel like adding all the airports in but If thats what needs to happen I will but if anyone can contribute the file I would be GRATEFUL! Best Regards, Greg 1 Quote Link to comment Share on other sites More sharing options...
Jon Posted November 13, 2010 Report Share Posted November 13, 2010 Yeah this is one addition i'd love to have in phpVMS Jon Quote Link to comment Share on other sites More sharing options...
Moderators mark1million Posted November 13, 2010 Moderators Report Share Posted November 13, 2010 To be Honest if we all did a dump of our airports in to a file then it could be combined to create a fairly complete file, last time i looked there was just over 10000 airport codes. 2 Quote Link to comment Share on other sites More sharing options...
Administrators simpilot Posted November 13, 2010 Administrators Report Share Posted November 13, 2010 Here is the data dump for my airports table for a charter system I have built if it will help. It has 41533 airfields, helipads, water strips, and private airfields in it, I think there are still some that I do not have in it but its a start. It is a big file so you may have to split it up to import it into your table, if you are on free hosting I would not even try. phpvms_airports.sql.zip 4 Quote Link to comment Share on other sites More sharing options...
TennShadow Posted November 13, 2010 Report Share Posted November 13, 2010 This site has over 43,000 aiports to download. http://www.ourairports.com/data/ Quote Link to comment Share on other sites More sharing options...
Moderators Kyle Posted November 14, 2010 Moderators Report Share Posted November 14, 2010 Here is the data dump for my airports table for a charter system I have built if it will help. It has 41533 airfields, helipads, water strips, and private airfields in it, I think there are still some that I do not have in it but its a start. It is a big file so you may have to split it up to import it into your table, if you are on free hosting I would not even try. WOW! Thanks simpilot. Quote Link to comment Share on other sites More sharing options...
APX0475 Posted November 15, 2010 Author Report Share Posted November 15, 2010 I would never use Free Hosting for a VA. Thanks for the reply's! Regards, Greg Quote Link to comment Share on other sites More sharing options...
Allan Posted December 3, 2010 Report Share Posted December 3, 2010 I am currently working on the database for airports, might be a while, I will post when its completed Regards, Allan 1 Quote Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted December 3, 2010 Administrators Report Share Posted December 3, 2010 I am currently working on the database for airports, might be a while, I will post when its completed Regards, Allan Simpilot posted one above Quote Link to comment Share on other sites More sharing options...
Allan Posted December 3, 2010 Report Share Posted December 3, 2010 Simpilot posted one above I understand that but its not complete Regards, Allan Quote Link to comment Share on other sites More sharing options...
TAV1702 Posted January 31, 2011 Report Share Posted January 31, 2011 Any of you sql wizards know if there is a way to make it skip entries that exist already instead of stopping? At most all I can get in is 58 airports. Before trying to run this I had only like 30 in my DB. I suppose I could drop all my airports and start from scratch since it is a dev site anyhow. I hate to do that though due to schedules I already have that I do fly with for testing purposes. Quote Link to comment Share on other sites More sharing options...
Allan Posted January 31, 2011 Report Share Posted January 31, 2011 If you drop all airport out of the db you will loose your hubs. Regards, Allan Quote Link to comment Share on other sites More sharing options...
Tom Posted January 31, 2011 Report Share Posted January 31, 2011 I have an export of all the FSX airports' data. If you fly in FSX that's about as complete a database you need? Quote Link to comment Share on other sites More sharing options...
TAV1702 Posted January 31, 2011 Report Share Posted January 31, 2011 If you drop all airport out of the db you will loose your hubs. Regards, Allan Loosing the hubs is the least of my worries. It is a dev site that only has me and the old lady on it anyhow. I could always manually remove the ones I already have from the "List O' Airports". Quote Link to comment Share on other sites More sharing options...
TAV1702 Posted January 31, 2011 Report Share Posted January 31, 2011 I have an export of all the FSX airports' data. If you fly in FSX that's about as complete a database you need? I am on FS9. I'm one of the ones that refuse to upgrade for various reasons. Quote Link to comment Share on other sites More sharing options...
Cor Posted February 1, 2011 Report Share Posted February 1, 2011 Import of the data works just fine, only the airport list won´t show up at the adminsite. Has more people experienced this. Regards, Cor Quote Link to comment Share on other sites More sharing options...
Moderators Kyle Posted February 1, 2011 Moderators Report Share Posted February 1, 2011 Cor, everything works for me. I'm using a dedicated server with the airports, and no load stress yet!! So are you sure you putted the import data in the right database, lets say your phpVMS DB is "JUZZ", you go in the database and click inport, and it should do that. Quote Link to comment Share on other sites More sharing options...
Cor Posted February 2, 2011 Report Share Posted February 2, 2011 The airports are in the right database. When I try to add for example EHAM, it tells me it is alreay present, so it is present in de the databse. It only does not show the list at the admin end. Regards, Cor Quote Link to comment Share on other sites More sharing options...
Moderators Kyle Posted February 2, 2011 Moderators Report Share Posted February 2, 2011 Ok I think its the tables. Go to the maintanice part in the admin and clear cache and optimize tables and it should show up. Quote Link to comment Share on other sites More sharing options...
Cor Posted February 2, 2011 Report Share Posted February 2, 2011 I will try tonight when I am home from work. Tnx!! Regards, Cor Quote Link to comment Share on other sites More sharing options...
Cor Posted February 3, 2011 Report Share Posted February 3, 2011 I tryed it, but still no list in the admin site. Regards, Cor 1 Quote Link to comment Share on other sites More sharing options...
TAV1702 Posted February 3, 2011 Report Share Posted February 3, 2011 Is it safe to say to only use this list for a new install? Upon further review, the only way for me to get around the duplicate error is to A) Drop current airports from database and start fresh, or edit the sql list and update ID numbers an remove airports I already have. Good times eh boys? lol This is one hell of a list though. Thanks Simpilot! Quote Link to comment Share on other sites More sharing options...
TAV1702 Posted February 3, 2011 Report Share Posted February 3, 2011 Ok so I dropped all my airports and added the sql file and tah dah!!! Got all the airports. Now I am fighting the exhausted memory error. Tried using my own fix I posted in the code snippets but not getting it to work. All the rest of the site works great. Now I can not view schedules. I'm sure in the end I will get it all fixed up nice like. Quote Link to comment Share on other sites More sharing options...
Txmmy83 Posted February 8, 2011 Report Share Posted February 8, 2011 Here is the data dump for my airports table for a charter system I have built if it will help. It has 41533 airfields, helipads, water strips, and private airfields in it, I think there are still some that I do not have in it but its a start. It is a big file so you may have to split it up to import it into your table, if you are on free hosting I would not even try. nice do I need to drop any of the airports that is currently in my DB or will they overwritten by yours? will maybe use it with a new VA Best Regards Tom Quote Link to comment Share on other sites More sharing options...
bravo27 Posted March 6, 2011 Report Share Posted March 6, 2011 I have an export of all the FSX airports' data. If you fly in FSX that's about as complete a database you need? Hello tom that file from fsx is it SQL database already and if so would it be possible to get from you thank you Quote Link to comment Share on other sites More sharing options...
vins Posted March 20, 2011 Report Share Posted March 20, 2011 Hi I have installed the big list in my free hosting webspace but after, when I have tried to Add a scheduled flight from the admin pannel I got the following message: Fatal error: Allowed memory size of 94371840 bytes exhausted (tried to allocate 8208111 bytes) in core/classes/CodonCache.class.php on line 202 what is happened? I hope you can help me...bye bye! Quote Link to comment Share on other sites More sharing options...
Moderators Kyle Posted March 20, 2011 Moderators Report Share Posted March 20, 2011 OK, Free hosting can limit limit you, so that's the problem, Free Hostings are not good. Paid ones, you won't have that kind of problems. Quote Link to comment Share on other sites More sharing options...
vins Posted March 20, 2011 Report Share Posted March 20, 2011 Hi, I have deleted the table phpvms_airports.sql and I don't know how to reinstall it. Could you help me!! Quote Link to comment Share on other sites More sharing options...
Moderators mark1million Posted March 20, 2011 Moderators Report Share Posted March 20, 2011 You do have a backup? This is from my development server its empty apart from the 2 airports but it will give you the table back, -- -- Table structure for table `phpvms_airports` -- CREATE TABLE IF NOT EXISTS `phpvms_airports` ( `id` int(11) NOT NULL AUTO_INCREMENT, `icao` varchar(5) NOT NULL DEFAULT '', `name` text NOT NULL, `country` varchar(50) NOT NULL DEFAULT '', `lat` float NOT NULL DEFAULT '0', `lng` float NOT NULL DEFAULT '0', `hub` smallint(6) NOT NULL DEFAULT '0', `fuelprice` float NOT NULL DEFAULT '0', `chartlink` text NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `icao` (`icao`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; -- -- Dumping data for table `phpvms_airports` -- INSERT INTO `phpvms_airports` (`id`, `icao`, `name`, `country`, `lat`, `lng`, `hub`, `fuelprice`, `chartlink`) VALUES (1, 'KJFK', 'Kennedy International', 'USA', 40.6398, -73.7787, 0, 0, ''), (2, 'EGKK', 'Gatwick Airport', 'United Kingdom', 51.1481, -0.190278, 1, 0, ''); Quote Link to comment Share on other sites More sharing options...
vins Posted March 20, 2011 Report Share Posted March 20, 2011 Thanks a lot for the help!!!!!!! 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.