Tom Posted November 6, 2009 Report Share Posted November 6, 2009 This was my half term (+ like a week :) project. Basically, you add your aircraft, select a type and enter a callsign, enter the table name of your aircraft table (by default phpvms_aircraft - this is only if you changed the prefix) and click create It then creates you a .sql file with all the rest of the information (full name, icao, empty weight [lbs], cruise speech [mach] etc) for you to import straight into your database. It's only really a one time use thing, unless you want to add bulk aircraft, or just cant be bothered to enter the information yourself, but I learnt making it so Have a go: http://www.europeangateway.info/fleetsql/ Please let me know if you have any problems. P.S. Yes I know there's only airbus and boeing aircraft - I'm working on it Quote Link to comment Share on other sites More sharing options...
James200410 Posted November 7, 2009 Report Share Posted November 7, 2009 Looks great Tom, I'm sure some will use it. Thanks Adam Quote Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted November 7, 2009 Administrators Report Share Posted November 7, 2009 Excellent, Tom! Small projects like this are great to learn. I like the use of jQuery. Will that be the permanent URL to it? I can add it to the downloads page Quote Link to comment Share on other sites More sharing options...
Tom Posted November 7, 2009 Author Report Share Posted November 7, 2009 Yes I'll be leaving it there for the foreseeable future And thanks Quote Link to comment Share on other sites More sharing options...
TAV1702 Posted November 7, 2009 Report Share Posted November 7, 2009 I swung by there and checked that out. I like it. Great job! Quote Link to comment Share on other sites More sharing options...
Tom Posted May 30, 2010 Author Report Share Posted May 30, 2010 Sorry for bringing back such an old thread, but I was wondering: if I were to work on an extensive database of aircraft for this and refine the interface and code a little, would people be interested in using it? I'll quickly go over how it works again: You select the aircraft in your airlines fleet, and add the callsign for each. The script takes all the relevant information (PAX No., Empty weight, Speed, Cargo weight etc) from the database and produces a .sql file for you to import to your database, instantly adding all your aircraft with correct information - saving you going through and making each aircraft individually. Contrary to what I wrote originally, I believe it would also work for additions to the fleet, so if you've opened a new division with a whole load of new aircraft you can add them all to the existing entries. So, would my summer be well spent improving this? Quote Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted May 30, 2010 Administrators Report Share Posted May 30, 2010 Tom, perhaps you can create the import CSV file now, since I've added an import/export in the admin panel for aircraft Quote Link to comment Share on other sites More sharing options...
Tom Posted May 30, 2010 Author Report Share Posted May 30, 2010 Tom, perhaps you can create the import CSV file now, since I've added an import/export in the admin panel for aircraft Is there? Is it in version 934? I can't find it.. just for schedules. But yeah that makes my life a lot easier! Quote Link to comment Share on other sites More sharing options...
avdesigns Posted December 11, 2011 Report Share Posted December 11, 2011 is there a way to still download this, thanks Quote Link to comment Share on other sites More sharing options...
Tom Posted December 11, 2011 Author Report Share Posted December 11, 2011 Ah I took this down ages ago, was a bit buggy. If I still have the code I can put it back up somewhere if you want? Quote Link to comment Share on other sites More sharing options...
avdesigns Posted December 11, 2011 Report Share Posted December 11, 2011 Please Thankyou Quote Link to comment Share on other sites More sharing options...
longhorns19 Posted September 19, 2014 Report Share Posted September 19, 2014 I know this is an old thread, but is there a way I can get the coding? I would love something like this Quote Link to comment Share on other sites More sharing options...
topher2880 Posted May 14, 2018 Report Share Posted May 14, 2018 On 9/20/2014 at 8:44 AM, longhorns19 said: I know this is an old thread, but is there a way I can get the coding? I would love something like this likewise, i have a huge amount of aircraft to import and i cant sit here for hours doing it manually (or copy paste in phpmyadmin and change registrations) 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.