Asimo

Read the database and use a bot on your discord server could track this information to apply commands to change the roles of your users. Question for @DisposableHero: "Can the PhpVMS API retrieve information from a user? Or obtain a XML-like (or Json) of users ?"

I just updated with full world timezone. Maybe some errors in Argentina, Brazil, USA because multi timezones 😄

Iata is fixed. Null is apply by default.

That fixed, didn't think that phpvms worked like that That fixed too When i see that the push is on master and live, i'll edit this "-" to null So, it's my next job, timezones are pretty complicated to obtain by airport, you've some countries who use multi-timezones, and need to check all of that. I'll inject new datas during the next weeks. Thanks !)

I added a warning 😅

47k means just the full possibility to have all airport around the world. The tool really helps you to have a list of airports and select the ones you want. To export them directly in CSV and import in PHPVMS That's why I explain that over 500 can be a problem.

Hi everyone ! I created a little google sheets who can help to create a airports.CSV with 47k+ Airports. Datas are from OurAirports and refresh every month. BEFORE TO USE, SELECT ONLY AIRPORTS THAT YOU NEED. A LOT OF AIRPORTS INSIDE YOUR PHPVMS DB CAN CAUSE SOME ISSUES. Easy to use : Access to https://docs.google.com/spreadsheets/d/1qhO6lzIK4gRzRiP--Fp0_Hq7sKVh5aAoK2Nd0aVWYoA/edit#gid=0 You can create a copy if you want (but you'll lose the auto-update) Go to "1. Select Airports" bottom tab Select your airport with checkbox Select your Hub (if you want) Go to "2. Export CSV" tab Check if all is ok Press on the top tab : "File" > "Download" > ".csv" Import in your PHPVMS Notes & Known issues : In notes, you'll have the elevation of the airport. If you want another informations, ask, i can update the script. About timezone, i can admit that's super complicated to find a good dataset with all airport + their timezone. Most airports have all informations but some little like ULM or military base are not. So if your airport have : - no timezone reported, CSV will put "GMT" By default costs are at 0 It's possible that you can have error with +500 airports (google limit)