cardinalhorizon / vaos

Virtual Aviation Operations System

NOTICE

This Git Repository is in a archive state and is not supported anymore.

The next version of the system will utilize a brand new repository.

In the meantime, if you need a Virtual Airline system, consider phpVMS 7, which is very similar in features to VAOS. https://github.com/nabeelio/phpvms

Download

https://github.com/FSVAOS/VAOS/releases

About

The Virtual Aviation Operations System project is an open source and modern Virtual Community Management System developed for use in flight simulators such as Microsoft Flight Simulator, Prepar3D and X-Plane. Development of the system started in late 2014.

Formerly known as the Virtual Airline Operations System.

License

GPL v3

System Requirements

• PHP: 7.0 or newer

• MySQL: MySQL Community Server 5.7.x or newer

• Apache 2.2+ or latest nginx version

Installing VAOS

Head over to the VAOS wiki to get started with the full installation guide for shared and dedicated hosting:

• VAOS Wiki

version 2.0.0b3

vaos's Issues

Some Bids don't have a flightnumber

Some Bids don't have a flightnumber

Add PHPUNIT Tests

JSON Format For 3rd Party Database Schema Mods

What the title says, I want to have a format for developers who want to sell or give out local system modifications to the end user a JSON file that contains the schema so all the user needs to do is upload a json file and he's good to go; just in case he needs to make a DB modification for the addon.

Discord

Hello :)

Noticed that in one of the closed issues there was a discord link.
But it was not functional.

Could you post a new one?

"Awaiting Approval"

Even when user status is set to 1 user status shows as "Awaiting Approval."

Error adding airline

have added some airlines with no issue. then suddenly i got this error.

[2018-09-02 13:12:33] local.ERROR: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'widget' at row 1 (SQL: insert into vaos_airlines (name, icao, iata, callsign, logo, widget) values (Air Canada, ACA, AC, AIR CANADA, https://upload.wikimedia.org/wikipedia/commons/thumb/2/24/Air_Canada_Logo.svg/600px-Air_Canada_Logo.svg.png, data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAOEAAADhCAMAAAAJbSJIAAAAkFBMVEX/////EwD/AAD/ZGH/hYD/+/r/tbT/9fT/+fj/wL3/8fD/4N7/7+7/4+H/1dL/7ev/sa3/qaT/x8T/SEL/T0v/vLj/5+X/0M3/jIb/c2z/e3X/nZj/YVr/aWL/y8j/1tT/OzL/pKD/lpH/W1T/HAz/g33/dm//SED/Qjn/npv/kYz/LCH/UEf/Oi3/NSj/JRc1LZHjAAAR9ElEQVR4nO1d13LiShCFNiJjBEs0YHIw2PD/f3dFljpMFGBX3fOyVV40mqNJnSeT+R/poXDHq7uSIoJCtT7OD3ofo7fh+t8V67e30Udv0B7Xq3+abKE07Q03WVAhuxn1ps0/SLPW/hpeqGXVuPxo+FXqvLrTxhjn+wcDapToYVUav7rzWtQ/l+uFJbk4zcV6+Vl/NQkZhbC/sx07Zix3q/BXrssgHPmyi7EctV/NB6PZT4vejeSq+WpSd9RmP6nSu5KcTGuvpnZE0O27by06jouP12+u7fmD6F1JvpVeyi+/s+EXF2UsHvrJv4peEBrxu5E6TCaT4dvb2zD6d5E15xqdH2HwCn75jZFEttjM+71GqV6PhOxCITgi+rdar3dKjV5/vlkYSXab0tM5dnXr7yiFbfrhe6WsbKdceW+MNgcdS4B590nMzqiPlD06Dsu8YSF+1T+na81YAvTV3ypNFLaqvkQdbX29OzTbHXwrSQJsnzRV2z9yN6Ie9sOya0eCaqOfVZCEyTOOjvJK7gIs5qGvltcJW1n5BfDxcKG8fZBeH+0sX5VU3jGeyQMJu8cOY6Ev8xul+eqSuFVHO04xxRchdKX5A9ll2jaIzof8Mpd9zARFaQuF3cz8YFga/7KW2wvvg4FL/7XoDIX3LbYWdocxWGhE9a0wjjB6gKljzL8MIGf1shV82Py89sHPG9ils6nFEAr8PqpWzVQgC3YrtsaLTwChVTM6BB88wW9bYXEZMcxZPtNc8y/PpSjhlNklCIep7b5dO0TP7Wy33eJswb5/lNqxUZ+wLxjaHxCzY0Mws36uMmd7MEmJYoUTYyDrsA6Kh9OzO4eOTbnVCItUTFVNbhN1266n55Zg6vBsnRtGOHw6NIXQZNYAQMOprcXl+YXLw8UBM4yw8LaqtrlmJ25iU/vaFLhZtJs7pi9ZT92/xE2NoaMGc5tnMHdroP7NdcfLpNrkWvxybKx7bwxcl8+A65DHWmwuaHPgrCSNYgxHro3k6arxWIuMsuS6BDMngS2NqcUsRlg4ttah5yCs3dXAhPIMfed2xlSngoOTqlGmBieYu1tJamjGu+sGhQ3t2MbB0lhsMQSde5XJ5JLN2SlRqGv08Ie5vRhOLTLQ9xDmy7i1rId9N6CagP0Xm6XQRhxT3J6D/H1HkaFoeYh90hacN/gTyBBmsz7NBcxEtToWO+muQdZE4CR/38FsNxYbKt1lPAkWaX+i/c9LuysTzR9a5g32yMP/7MwxGJx46yp/X1Ejpxn0TJ9tk0c9LVtFTmKOPpufiv5OWzSUKOv0Sc+ICLoxn5vd+jXL6AVmS5EuQk+PBG+JzHpvNpEYjhtsmTzWII85fOq4+EoajDXdiAkRDrLlivTVwHpUT2Ub/VhVzn0PxiOZ4FGbHl9+V1k6HLgBNaXqvxPuEOzcbE6w2TYaje1EG4Iw6R1/twYnIaeCNVi90kLWDDjZQaJNwDRe5vo7t9VOziHdPK1i5cvRkUWlPj1TN00dn92wV4v0Ofz7b6fXZsbWBLOORrMiGROlX6RCxtzxqK/trAkeHF/VJX1WGcKxxO7sbC1MrBlOXBVGMu+G8m+xkOAhb1MLgQau64ER6+UVXfyHu+UeEiC4xBUM3b8mGZiWZIzAEre5rE6xtGa4cn8ZtrhIWgsZwoVH/BFnnFYz9BDDscIO3/wg4sPey1NONDAtQ5+3YSsQ8GHFaMHCxOOV9NzRMvTS0JDwxvedrEIvz1zNmqGXkk3mH7cSkT/ATNUS0bE98g9+YWMGExBLkm4S9w0FcvKo4WSXjwFL4Ez3kdYEb14vzGTeLBkO/aJjsAGValFkw/UNHOdjjGSGXhb1DDOIWK3dpjyEuEEtQw/p4gQsu+HztYyCgnyNT0rrDMvQ0yhFXghIksdjvPN9HxsCoGLoH2GsPu2QoGzwRUONxZpYtDQMNYdFWy/yIKts0pXUOaAX6iXSJfSUJuuCJUPlG4MZ6GOLsRiVOGFDFX0efYBvlRhStDvyD6rPVfkGE8c/8h0khFO8z+iPiqB1tKYpvJKMh08BSRs4oXG0xP3TTyu0mcDm/l/oMIS1trHLlIC1bEy10hAV2uElZM9AMi//oEbv0xRPUgPb7MWIBwcx/fHLiqH4ymsKi8FCxFJGTCHDEptezL/Hjoh5OlYHohTsWF7ebcr6XnXF7QRrFXq/XsxfADt+1VodiILdYRwLWoovKwFVvJ9c/wOvUO0krSUdIrDkPkkKDJP2bNhoRxEZwG9iBP67uqHquIeDamHNDKP3LH3HjiVYLMdqNxH6qldhF8cl7K8b9/SYl4wx5NJ/gbEjWYnejCl+wAYnT+Zcn66G6wL6+WW91Xni0TLf8UVz2C7OkS09YMIvFNij81DKQWLr+RxucRTIrnhRofAyvC8JGgsgA5Asy4ZfKB5PLsSGVcp+N/Zc8n/OCxHH1AUZ6QHNi75jgiBWx7QPT2IrjI3Llx+NSVbIAHaZ/Gg+HOLfUsyoZF+VbVw3VT7LRvnw/EoxCMU8VfbBhBCNGJ6cNJ198o8Jc0LB6mXRphoWgkxQbFuO4OnZSb4YPVsIrQYwQiKYCX3Z/XFajZXaPfHOaboJsOm3VPnYqmezrf7ausBUsr94IR6lWbwlIAlXiPZRddSFnuuz2IL1yYwX0gF2WI2xnTRPBVGq6kld/iSvJ8976qisYP3/V4HoVMkd4GS5T/qjGbultRvpeWCEPaQnTeiwMhYfS+Pu88B57NG+cahjuQU4xzaTUfUrwJmv8Mb5TpQcTrFwiP95BlgbKz78mniV7Vm7paWJ/jngbTtoY4zk3S+0lbL6fcAG+b4WQnhXHe2cX0juljwy1k7rx0MweQbo9Muh3VW06lmLNo+G6I5LOi4juTw5/0SbXfHXMZSi11ZYgklaUeVANis96vGQg8TQ6f2TQbqTyFAMR38N5GxyFKu0RwlJshvPUo16NOR0FByN9WcZinlc2PJizNDSp/toCHFdGSq2YYbi4Fv65R8NecPQMRRtynbmz8dDrDyhYyi503/ZMlSsJx1DIVyv8OsEU1gLXj0dQ+HL/ELlQhLb3Bj+QoKihIkT2kwYMvnvvwLww+lP5MRHCiMnDAWl4UMLPrsBoBVyyixieMCmNuGY6Y7kkpsvAcD8kw9QQf7eCWYohgjWcunWlfcCwFIMPvnADJOuDFXWQ9B4RHF5e4C6UBxS6YdYYVTGlf6GBRlNz7wynJgMWfIgkBNqLhyPVfSfSykByI666h6iSgSwRccHbLSlBSpbN+eZP6LX9rQBJyhJINJBkAiwMEh7KIavWJAAe5O7S6g7FEdKmaWufPafzBFgZJbhgvl0cXUj42jkmqLq9QMI9k1TalAK1LGyIjJFmcfMN+18/D78FuZFQtBxuM8kgvCyvMNKAlMM7DGwqVaW1NRPobLIpfhj3ljm/TkMbXLMArSVHkNRGnTiGuMpZmKrOl7YHXrUJPDmY5OUR0r1PIShTTpNm2ylpLSEVc0snCj+GIY2KVE55njH7iiDMPYrmOp3j8DeooQTUnfPQigq8gK6Ru54ksvNYpqiPJaLqoQDpYyT8C0DLD0oGmdB42V4NlngiEXThdh+Er+syhSPgAO6zwdDGUk1hsUNnmp/M8zWD1BM5NXVjxMxTAoNvDvEV/rArDQsTv657sI4ZcbgFrDB0w1TRpdaIDvbbf1W0d+1aWJ8EfhHA+Y6/QJX/YTbMYPq8+lq1jZeZFnUVrrHe+ZdxsaDq9y5atalZ9IDtJRSM0omi81rpCOoNajwhZ5E2Cj3iH/yyY6CZA/KLxU8Rd7mAD2lloHTQ+JZB/ig1FwM8CKKOukNs4j/HGtQmmT1QHHz2gOhuxcD/TwZ+IZnsEZJJHWPnwHdgYiP9X+qLuuSuV8SUqv77CiZD+VhdXBr6gIAtJLyE6C5C4vEUiAKOK1NvahfEm6qMVZjNRdLZmTeKeWalyQoqAURUn4Gh4XhhEj1IL4knlatQWEFaUOOThzV9aMYxNeEfcNacd7jUq3ckY5HWTGI9qXKSHat5c3O52cUugXOeuGsTVhQWaRUEOLkFxuUmtOYRgLZr1JpsLdNxJPLKuBvzo5PHY+z2B4+WnT8Lhek3xNnr/V/KsLdfyLEMwwrrPzwkHq10vljs88AvN3m1i1E9X52V9RXJ+PGpFoIpBQbv8RwETlJsClYmGhgHRdEbgxjf2va7FqCbZjsfNL1fGQQeTGJVEKX+WUbie3vYmRAcfahuclAMJySmoLSLokL6sOEtbqZZrIBzJAycDFA4gIKwcx0qvJKD6kBJYsrOOiN/RaGAd/cBZ55nmEmU10acmSd8KRAq6yEBPhjcLlFRpn2AHPGvikyzGTGb0YcOXM1cS4cFJIBmdC0JoxR2U6YlLi3KBiK143ilsmpT0oGqL0cpKwykQVRzRhONsElMswYcsUwaK0RekoTaUZdqYd45rEn6l4I5fjq/ehrNsgl67korrHXMDxuBMmWNrnB7OttEmeJNVdaWF9j/scCGfwk94vzaX98Y2uZL5/3yqDWj/H+kKU9LcNMPRfjMrreDFHO51qLC0s0q2pk69BVzKqTMvWJeMzy6XvuW73PTuIkuCzgaINRlXrTM4xU9Wv4Y1KAKXY+t/Of48sTn5xcbQV77WUVdNTjiyqExSjsMo2c/OewV/v5TBhGPTh9ZM57Uu2Go0NCL6K3GhnEdNGbTWLa8qdoKwF5g7nBjOFZyhF9fLVYd+hwmNQ9D8imbXQZ1hC22iJopgwzhVlWX7uMvVrMKPSGfph/BlWMmwahdcYMo84b+LXr9E4rw7hDouDCKp1Lvi0YGoBeoGcceUPVI+8qv2eky5CU67C4p5tKZulQTJUhE49lEZJH7aGO91QnkSZDGgpiEn9wB7U1ed1dcEGKDGlquUn5zziobSEFiukxZAhSE7AaZeZiYe+JmhpDmpQMO+u6/DWaOeJdVTwthvQCFHC5S4mxVjhfjnRBSgwZa6ZbwXPudlRR9TNCKgy5QAnXBcR9Ky/p5nKE2e56CQREM/A5rZlD1eumjStDj12ZyqJ+c4KbEK5XtWdup6zd0ZzAmLEe+8lbHEVddJmMuS9DLqLO9+4PzpEGH46Lce3HMOBK48HIV+9hKe7dri66Pu7GsIZNSKe2fHatC7gQL73BggX4MGRLC6ej87ABUDG3oDGKHgwr7N1DviLIFWyJKFhYbzjX9E4HASRks4/9L6e5osR6TWBoec1W25UhX9wbPK8uT6DCBiOC5iIWjGsIr+WNbsUe/4E9r0NHqPI+NTioc+OTuG32NldjBiU+jxPmfhe10RcJUbMwF4tukSbWDgw/hbQA/j4GPwiF4AFGhmLcLevK/Jq8sRCqAamYjQgqQgxGxNFoUG4Kpy7b4Yp3KRQF9l7XQSrAL/mTy8lg87jNc7NU4+Y/ye/9iBl6RZsTnM4cW3mNWnW7Hsnk+s9qKPM7pHhIUHTE2+6P18ArZ1/t9kvt3caVnBzyBkObVGwXhPK7Ad4U8tgt0EgTRF5otOSwDEjDbKtDUVEuAo7lKwTH380Cq1IHOvlvRVRm1LrfXZ6maKruGAXYDUvMRLqHuEpJqoXx17+FKqoGNv5XCBqiMFWW4QE4zGdjFBF1t/lwQluhE640Fz9AdvacATyjo6lsEnV2MZo177t67LoeHHNfaA5WE13IcDRBH73DYOgjQ4+d3o2m+ffjwoyZ7W5Ffurv7XD7vTAIiOaDyB6O8dwgFO18W9EmfsjcYuS/DYO9NTEsj8Snaemv+M/uxbbMUjUBhsbC/QMwnltnzN6PQxOGAN+v5HfEMRrdiuTdeKRnCLB6xfojmHJXscm9vsk9GobRPjU1KQ3wDATdj50xyXtwoYphdNqsmunEuKSEejhXyiN33K+BExlG9FrTlI0UaaASmlxHFauJxDOM2phMUzUypYlqvq8VTu7xoZTh8eFR+GzhxRbvg9FCQTNm8E4wPD0y3NoZGl+G6ng2WgtXjMUCHa8MT+Q2b9tu9VdtLToUKs3BfLIgNGNlAFpnqe0wGW5LFYtaUL8KldJ2nyAZdxZ9b4bbfImLOP5jKIaxQpluYSG/H9XZzUj3p5aaDcq5k4hucgn8n8WpspSl2+mPoRBpzLYBhH8N88c4VH4Rgv7fPxn+xwvwH6l9FuMmrXgmAAAAAElFTkSuQmCC)) {"userId":1,"email":"[email protected]","exception":"[object] (Illuminate\\Database\\QueryException(code: 22001): SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'widget' at row 1 (SQL: insert into vaos_airlines (name, icao, iata, callsign, logo, widget) values (Air Canada, ACA, AC, AIR CANADA, https://upload.wikimedia.org/wikipedia/commons/thumb/2/24/Air_Canada_Logo.svg/600px-Air_Canada_Logo.svg.png, data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAOEAAADhCAMAAAAJbSJIAAAAkFBMVEX/////EwD/AAD/ZGH/hYD/+/r/tbT/9fT/+fj/wL3/8fD/4N7/7+7/4+H/1dL/7ev/sa3/qaT/x8T/SEL/T0v/vLj/5+X/0M3/jIb/c2z/e3X/nZj/YVr/aWL/y8j/1tT/OzL/pKD/lpH/W1T/HAz/g33/dm//SED/Qjn/npv/kYz/LCH/UEf/Oi3/NSj/JRc1LZHjAAAR9ElEQVR4nO1d13LiShCFNiJjBEs0YHIw2PD/f3dFljpMFGBX3fOyVV40mqNJnSeT+R/poXDHq7uSIoJCtT7OD3ofo7fh+t8V67e30Udv0B7Xq3+abKE07Q03WVAhuxn1ps0/SLPW/hpeqGXVuPxo+FXqvLrTxhjn+wcDapToYVUav7rzWtQ/l+uFJbk4zcV6+Vl/NQkZhbC/sx07Zix3q/BXrssgHPmyi7EctV/NB6PZT4vejeSq+WpSd9RmP6nSu5KcTGuvpnZE0O27by06jouP12+u7fmD6F1JvpVeyi+/s+EXF2UsHvrJv4peEBrxu5E6TCaT4dvb2zD6d5E15xqdH2HwCn75jZFEttjM+71GqV6PhOxCITgi+rdar3dKjV5/vlkYSXab0tM5dnXr7yiFbfrhe6WsbKdceW+MNgcdS4B590nMzqiPlD06Dsu8YSF+1T+na81YAvTV3ypNFLaqvkQdbX29OzTbHXwrSQJsnzRV2z9yN6Ie9sOya0eCaqOfVZCEyTOOjvJK7gIs5qGvltcJW1n5BfDxcKG8fZBeH+0sX5VU3jGeyQMJu8cOY6Ev8xul+eqSuFVHO04xxRchdKX5A9ll2jaIzof8Mpd9zARFaQuF3cz8YFga/7KW2wvvg4FL/7XoDIX3LbYWdocxWGhE9a0wjjB6gKljzL8MIGf1shV82Py89sHPG9ils6nFEAr8PqpWzVQgC3YrtsaLTwChVTM6BB88wW9bYXEZMcxZPtNc8y/PpSjhlNklCIep7b5dO0TP7Wy33eJswb5/lNqxUZ+wLxjaHxCzY0Mws36uMmd7MEmJYoUTYyDrsA6Kh9OzO4eOTbnVCItUTFVNbhN1266n55Zg6vBsnRtGOHw6NIXQZNYAQMOprcXl+YXLw8UBM4yw8LaqtrlmJ25iU/vaFLhZtJs7pi9ZT92/xE2NoaMGc5tnMHdroP7NdcfLpNrkWvxybKx7bwxcl8+A65DHWmwuaHPgrCSNYgxHro3k6arxWIuMsuS6BDMngS2NqcUsRlg4ttah5yCs3dXAhPIMfed2xlSngoOTqlGmBieYu1tJamjGu+sGhQ3t2MbB0lhsMQSde5XJ5JLN2SlRqGv08Ie5vRhOLTLQ9xDmy7i1rId9N6CagP0Xm6XQRhxT3J6D/H1HkaFoeYh90hacN/gTyBBmsz7NBcxEtToWO+muQdZE4CR/38FsNxYbKt1lPAkWaX+i/c9LuysTzR9a5g32yMP/7MwxGJx46yp/X1Ejpxn0TJ9tk0c9LVtFTmKOPpufiv5OWzSUKOv0Sc+ICLoxn5vd+jXL6AVmS5EuQk+PBG+JzHpvNpEYjhtsmTzWII85fOq4+EoajDXdiAkRDrLlivTVwHpUT2Ub/VhVzn0PxiOZ4FGbHl9+V1k6HLgBNaXqvxPuEOzcbE6w2TYaje1EG4Iw6R1/twYnIaeCNVi90kLWDDjZQaJNwDRe5vo7t9VOziHdPK1i5cvRkUWlPj1TN00dn92wV4v0Ofz7b6fXZsbWBLOORrMiGROlX6RCxtzxqK/trAkeHF/VJX1WGcKxxO7sbC1MrBlOXBVGMu+G8m+xkOAhb1MLgQau64ER6+UVXfyHu+UeEiC4xBUM3b8mGZiWZIzAEre5rE6xtGa4cn8ZtrhIWgsZwoVH/BFnnFYz9BDDscIO3/wg4sPey1NONDAtQ5+3YSsQ8GHFaMHCxOOV9NzRMvTS0JDwxvedrEIvz1zNmqGXkk3mH7cSkT/ATNUS0bE98g9+YWMGExBLkm4S9w0FcvKo4WSXjwFL4Ez3kdYEb14vzGTeLBkO/aJjsAGValFkw/UNHOdjjGSGXhb1DDOIWK3dpjyEuEEtQw/p4gQsu+HztYyCgnyNT0rrDMvQ0yhFXghIksdjvPN9HxsCoGLoH2GsPu2QoGzwRUONxZpYtDQMNYdFWy/yIKts0pXUOaAX6iXSJfSUJuuCJUPlG4MZ6GOLsRiVOGFDFX0efYBvlRhStDvyD6rPVfkGE8c/8h0khFO8z+iPiqB1tKYpvJKMh08BSRs4oXG0xP3TTyu0mcDm/l/oMIS1trHLlIC1bEy10hAV2uElZM9AMi//oEbv0xRPUgPb7MWIBwcx/fHLiqH4ymsKi8FCxFJGTCHDEptezL/Hjoh5OlYHohTsWF7ebcr6XnXF7QRrFXq/XsxfADt+1VodiILdYRwLWoovKwFVvJ9c/wOvUO0krSUdIrDkPkkKDJP2bNhoRxEZwG9iBP67uqHquIeDamHNDKP3LH3HjiVYLMdqNxH6qldhF8cl7K8b9/SYl4wx5NJ/gbEjWYnejCl+wAYnT+Zcn66G6wL6+WW91Xni0TLf8UVz2C7OkS09YMIvFNij81DKQWLr+RxucRTIrnhRofAyvC8JGgsgA5Asy4ZfKB5PLsSGVcp+N/Zc8n/OCxHH1AUZ6QHNi75jgiBWx7QPT2IrjI3Llx+NSVbIAHaZ/Gg+HOLfUsyoZF+VbVw3VT7LRvnw/EoxCMU8VfbBhBCNGJ6cNJ198o8Jc0LB6mXRphoWgkxQbFuO4OnZSb4YPVsIrQYwQiKYCX3Z/XFajZXaPfHOaboJsOm3VPnYqmezrf7ausBUsr94IR6lWbwlIAlXiPZRddSFnuuz2IL1yYwX0gF2WI2xnTRPBVGq6kld/iSvJ8976qisYP3/V4HoVMkd4GS5T/qjGbultRvpeWCEPaQnTeiwMhYfS+Pu88B57NG+cahjuQU4xzaTUfUrwJmv8Mb5TpQcTrFwiP95BlgbKz78mniV7Vm7paWJ/jngbTtoY4zk3S+0lbL6fcAG+b4WQnhXHe2cX0juljwy1k7rx0MweQbo9Muh3VW06lmLNo+G6I5LOi4juTw5/0SbXfHXMZSi11ZYgklaUeVANis96vGQg8TQ6f2TQbqTyFAMR38N5GxyFKu0RwlJshvPUo16NOR0FByN9WcZinlc2PJizNDSp/toCHFdGSq2YYbi4Fv65R8NecPQMRRtynbmz8dDrDyhYyi503/ZMlSsJx1DIVyv8OsEU1gLXj0dQ+HL/ELlQhLb3Bj+QoKihIkT2kwYMvnvvwLww+lP5MRHCiMnDAWl4UMLPrsBoBVyyixieMCmNuGY6Y7kkpsvAcD8kw9QQf7eCWYohgjWcunWlfcCwFIMPvnADJOuDFXWQ9B4RHF5e4C6UBxS6YdYYVTGlf6GBRlNz7wynJgMWfIgkBNqLhyPVfSfSykByI666h6iSgSwRccHbLSlBSpbN+eZP6LX9rQBJyhJINJBkAiwMEh7KIavWJAAe5O7S6g7FEdKmaWufPafzBFgZJbhgvl0cXUj42jkmqLq9QMI9k1TalAK1LGyIjJFmcfMN+18/D78FuZFQtBxuM8kgvCyvMNKAlMM7DGwqVaW1NRPobLIpfhj3ljm/TkMbXLMArSVHkNRGnTiGuMpZmKrOl7YHXrUJPDmY5OUR0r1PIShTTpNm2ylpLSEVc0snCj+GIY2KVE55njH7iiDMPYrmOp3j8DeooQTUnfPQigq8gK6Ru54ksvNYpqiPJaLqoQDpYyT8C0DLD0oGmdB42V4NlngiEXThdh+Er+syhSPgAO6zwdDGUk1hsUNnmp/M8zWD1BM5NXVjxMxTAoNvDvEV/rArDQsTv657sI4ZcbgFrDB0w1TRpdaIDvbbf1W0d+1aWJ8EfhHA+Y6/QJX/YTbMYPq8+lq1jZeZFnUVrrHe+ZdxsaDq9y5atalZ9IDtJRSM0omi81rpCOoNajwhZ5E2Cj3iH/yyY6CZA/KLxU8Rd7mAD2lloHTQ+JZB/ig1FwM8CKKOukNs4j/HGtQmmT1QHHz2gOhuxcD/TwZ+IZnsEZJJHWPnwHdgYiP9X+qLuuSuV8SUqv77CiZD+VhdXBr6gIAtJLyE6C5C4vEUiAKOK1NvahfEm6qMVZjNRdLZmTeKeWalyQoqAURUn4Gh4XhhEj1IL4knlatQWEFaUOOThzV9aMYxNeEfcNacd7jUq3ckY5HWTGI9qXKSHat5c3O52cUugXOeuGsTVhQWaRUEOLkFxuUmtOYRgLZr1JpsLdNxJPLKuBvzo5PHY+z2B4+WnT8Lhek3xNnr/V/KsLdfyLEMwwrrPzwkHq10vljs88AvN3m1i1E9X52V9RXJ+PGpFoIpBQbv8RwETlJsClYmGhgHRdEbgxjf2va7FqCbZjsfNL1fGQQeTGJVEKX+WUbie3vYmRAcfahuclAMJySmoLSLokL6sOEtbqZZrIBzJAycDFA4gIKwcx0qvJKD6kBJYsrOOiN/RaGAd/cBZ55nmEmU10acmSd8KRAq6yEBPhjcLlFRpn2AHPGvikyzGTGb0YcOXM1cS4cFJIBmdC0JoxR2U6YlLi3KBiK143ilsmpT0oGqL0cpKwykQVRzRhONsElMswYcsUwaK0RekoTaUZdqYd45rEn6l4I5fjq/ehrNsgl67korrHXMDxuBMmWNrnB7OttEmeJNVdaWF9j/scCGfwk94vzaX98Y2uZL5/3yqDWj/H+kKU9LcNMPRfjMrreDFHO51qLC0s0q2pk69BVzKqTMvWJeMzy6XvuW73PTuIkuCzgaINRlXrTM4xU9Wv4Y1KAKXY+t/Of48sTn5xcbQV77WUVdNTjiyqExSjsMo2c/OewV/v5TBhGPTh9ZM57Uu2Go0NCL6K3GhnEdNGbTWLa8qdoKwF5g7nBjOFZyhF9fLVYd+hwmNQ9D8imbXQZ1hC22iJopgwzhVlWX7uMvVrMKPSGfph/BlWMmwahdcYMo84b+LXr9E4rw7hDouDCKp1Lvi0YGoBeoGcceUPVI+8qv2eky5CU67C4p5tKZulQTJUhE49lEZJH7aGO91QnkSZDGgpiEn9wB7U1ed1dcEGKDGlquUn5zziobSEFiukxZAhSE7AaZeZiYe+JmhpDmpQMO+u6/DWaOeJdVTwthvQCFHC5S4mxVjhfjnRBSgwZa6ZbwXPudlRR9TNCKgy5QAnXBcR9Ky/p5nKE2e56CQREM/A5rZlD1eumjStDj12ZyqJ+c4KbEK5XtWdup6zd0ZzAmLEe+8lbHEVddJmMuS9DLqLO9+4PzpEGH46Lce3HMOBK48HIV+9hKe7dri66Pu7GsIZNSKe2fHatC7gQL73BggX4MGRLC6ej87ABUDG3oDGKHgwr7N1DviLIFWyJKFhYbzjX9E4HASRks4/9L6e5osR6TWBoec1W25UhX9wbPK8uT6DCBiOC5iIWjGsIr+WNbsUe/4E9r0NHqPI+NTioc+OTuG32NldjBiU+jxPmfhe10RcJUbMwF4tukSbWDgw/hbQA/j4GPwiF4AFGhmLcLevK/Jq8sRCqAamYjQgqQgxGxNFoUG4Kpy7b4Yp3KRQF9l7XQSrAL/mTy8lg87jNc7NU4+Y/ye/9iBl6RZsTnM4cW3mNWnW7Hsnk+s9qKPM7pHhIUHTE2+6P18ArZ1/t9kvt3caVnBzyBkObVGwXhPK7Ad4U8tgt0EgTRF5otOSwDEjDbKtDUVEuAo7lKwTH380Cq1IHOvlvRVRm1LrfXZ6maKruGAXYDUvMRLqHuEpJqoXx17+FKqoGNv5XCBqiMFWW4QE4zGdjFBF1t/lwQluhE640Fz9AdvacATyjo6lsEnV2MZo177t67LoeHHNfaA5WE13IcDRBH73DYOgjQ4+d3o2m+ffjwoyZ7W5Ffurv7XD7vTAIiOaDyB6O8dwgFO18W9EmfsjcYuS/DYO9NTEsj8Snaemv+M/uxbbMUjUBhsbC/QMwnltnzN6PQxOGAN+v5HfEMRrdiuTdeKRnCLB6xfojmHJXscm9vsk9GobRPjU1KQ3wDATdj50xyXtwoYphdNqsmunEuKSEejhXyiN33K+BExlG9FrTlI0UaaASmlxHFauJxDOM2phMUzUypYlqvq8VTu7xoZTh8eFR+GzhxRbvg9FCQTNm8E4wPD0y3NoZGl+G6ng2WgtXjMUCHa8MT+Q2b9tu9VdtLToUKs3BfLIgNGNlAFpnqe0wGW5LFYtaUL8KldJ2nyAZdxZ9b4bbfImLOP5jKIaxQpluYSG/H9XZzUj3p5aaDcq5k4hucgn8n8WpspSl2+mPoRBpzLYBhH8N88c4VH4Rgv7fPxn+xwvwH6l9FuMmrXgmAAAAAElFTkSuQmCC)) at /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664, Doctrine\\DBAL\\Driver\\PDOException(code: 22001): SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'widget' at row 1 at /home/mrsaminu/public_html/VAOS/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:144, PDOException(code: 22001): SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'widget' at row 1 at /home/mrsaminu/public_html/VAOS/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:142) [stacktrace] #0 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Database/Connection.php(624): Illuminate\\Database\\Connection->runQueryCallback('insert into va...', Array, Object(Closure))
#1 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Database/Connection.php(459): Illuminate\Database\Connection->run('insert into va...', Array, Object(Closure)) #2 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Database/Connection.php(411): Illuminate\\Database\\Connection->statement('insert into va...', Array)
#3 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Database/Query/Processors/Processor.php(32): Illuminate\Database\Connection->insert('insert into va...', Array) #4 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2159): Illuminate\\Database\\Query\\Processors\\Processor->processInsertGetId(Object(Illuminate\\Database\\Query\\Builder), 'insert into va...', Array, 'id')
#5 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1283): Illuminate\Database\Query\Builder->insertGetId(Array, 'id')
#6 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(722): Illuminate\Database\Eloquent\Builder->__call('insertGetId', Array)
#7 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(687): Illuminate\Database\Eloquent\Model->insertAndSetId(Object(Illuminate\Database\Eloquent\Builder), Array)
#8 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(550): Illuminate\Database\Eloquent\Model->performInsert(Object(Illuminate\Database\Eloquent\Builder))
#9 /home/mrsaminu/public_html/VAOS/app/Http/Controllers/Admin/AirlineController.php(62): Illuminate\Database\Eloquent\Model->save()
#10 [internal function]: App\Http\Controllers\Admin\AirlineController->store(Object(Illuminate\Http\Request))
#11 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): call_user_func_array(Array, Array)
#12 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\Routing\Controller->callAction('store', Array)
#13 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Routing/Route.php(212): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(App\Http\Controllers\Admin\AirlineController), 'store')
#14 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Routing/Route.php(169): Illuminate\Routing\Route->runController()
#15 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Routing/Router.php(658): Illuminate\Routing\Route->run()
#16 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#17 /home/mrsaminu/public_html/VAOS/app/Http/Middleware/AdminPerms.php(25): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#18 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): App\Http\Middleware\AdminPerms->handle(Object(Illuminate\Http\Request), Object(Closure))
#19 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#20 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#21 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure))
#22 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#23 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#24 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\Auth\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure))
#25 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#26 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(68): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#27 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure))
#28 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#29 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#30 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#31 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#32 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(63): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#33 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#34 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#35 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#36 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure))
#37 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#38 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(66): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#39 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure))
#40 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#41 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#42 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Routing/Router.php(660): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#43 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Routing/Router.php(635): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))
#44 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Routing/Router.php(601): Illuminate\Routing\Router->runRoute(Object(Illuminate\Http\Request), Object(Illuminate\Routing\Route))
#45 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Routing/Router.php(590): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))
#46 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))
#47 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request))
#48 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#49 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure))
#50 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#51 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#52 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(151): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#53 /home/mrsaminu/public_html/VAOS/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
#54 /home/mrsaminu/public_html/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
#55 {main}
"}`

Add Part 135 "Clients" Interface

The 2.1 Update

New User Account Exam System

i want to add idea for the VAOS:

pilot will create a user in the page for the pilot area and before they get access they need to pass
an examine to see they knowledge with fly aircraft like an IQ Test

Create Type Ratings Interface

Schedule Uploading Broken

Airline is being pulled in 2 places causing an error within the VAOS Core code. Fixing this in the next release. About to push changes to Cutting Edge for review.

2.1 Admin Overhaul

Looping Issue Followup

Hi, I replaced the file using your instructions. Still same issue. Here's a youtube link to a short recording I did clicking on the admin links. https://youtu.be/ktNI1tgfICo
Sorry about the blurryness. It's clear when I record, but youtube loves to not make things clear.

The links go nowhere or to a blank page or to a The Content You Were Looking For Was Not found page. Also the Settings and Modules links want to point to a charts.html page.

Originally posted by @RKillinger37 in #172 (comment)

Database Overhaul

Ok ladies and gents, we're switching up everything on the back end. Here's the current migration code:

Schema::create('airports', function (Blueprint $table) {
        	$table->increments('id');
        	$table->string('name');
        	$table->string('city');
        	$table->string('country');
        	$table->string('iata');
        	$table->string('icao');
        	$table->double('lat');
        	$table->double('lon');
        	$table->longText('data')->nullable(); //JSON Data for All gate information for the system.
            $table->softDeletes();
        });
        Schema::create('settings', function (Blueprint $table) {
        	$table->increments('id');
        	$table->string('friendlyname');
        	$table->string('name');
        	$table->string('value');
            $table->timestamps();
            $table->softDeletes();
        });
        Schema::create('airlines', function (Blueprint $table) {
            $table->increments('id');
            $table->string('icao');
            $table->string('iata')->nullable();
            $table->string('name');
            $table->string('logo')->nullable(); // References Storage
            $table->string('widget')->nullable(); // References Storage
            $table->string('callsign');
            $table->softDeletes();
        });
        Schema::create('hubs', function (Blueprint $table) {
            $table->increments('id');
            $table->integer('airport_id')->unsigned();
            $table->foreign('airport_id')->references('id')->on('airports')->onDelete('cascade');
            $table->integer('airline_id')->unsigned();
            $table->foreign('airline_id')->references('id')->on('airlines')->onDelete('cascade');
            $table->timestamps();
            $table->softDeletes();
        });

        Schema::create('codeshares', function (Blueprint $table) {
            $table->increments('id');
            $table->integer('airline_id')->unsigned();
            $table->foreign('airline_id')->references('id')->on('airlines')->onDelete('cascade');
            $table->string('weburl')->nullable();
            $table->string('apikey', 64);
            $table->timestamps();
        });
        // ACARS Global Sessions Table (Unused)
        Schema::create('acars_sessions', function (Blueprint $table) {
            $table->increments('id');
            $table->integer('user_id')->unsigned();
            $table->foreign('user_id')->references('id')->on('users')->onDelete('cascade');
            $table->string('session', 64);
            $table->timestamps();
            $table->softDeletes();
        });

        Schema::create('aircraft_groups', function (Blueprint $table) {
            $table->increments('id');
            $table->string('name');
            $table->string('icao')->nullable();
            $table->boolean('userdefined');
            $table->timestamps();
            $table->softDeletes();
        });
        Schema::create('aircraft', function (Blueprint $table) {
            $table->increments('id');
            $table->string('icao');
            $table->string('name');
            $table->string('manufacturer');
            $table->string('registration');
            $table->integer('range')->nullable();
            $table->integer('maxpax')->nullable();
            $table->integer('maxgw')->nullable();
            $table->integer('status');
            $table->integer('hub_id')->unsigned()->nullable();
            $table->foreign('hub_id')->references('id')->on('airports')->onDelete('set null');
            $table->integer('location_id')->unsigned()->nullable();
            $table->foreign('location_id')->references('id')->on('airports')->onDelete('set null');
            $table->integer('airline_id')->unsigned()->nullable();
            $table->foreign('airline_id')->references('id')->on('airlines')->onDelete('set null');
            $table->text('note')->nullable();
            $table->timestamps();
            $table->softDeletes();
        });
        Schema::create('aircraft_group_pivot', function (Blueprint $table) {
            $table->increments('id');
            $table->integer('aircraft_id')->unsigned();
            $table->foreign('aircraft_id')->references('id')->on('aircraft')->onDelete('cascade');
            $table->integer('aircraft_group_id')->unsigned();
            $table->foreign('aircraft_group_id')->references('id')->on('aircraft_groups')->onDelete('cascade');
            $table->timestamps();
            $table->softDeletes();
        });

        Schema::create('schedule_templates', function (Blueprint $table) {
            $table->increments('id');
            $table->integer('airline_id')->unsigned();
            $table->foreign('airline_id')->references('id')->on('airlines')->onDelete('cascade');
            $table->string('flightnum');
            $table->integer('depapt_id')->unsigned();
            $table->foreign('depapt_id')->references('id')->on('airports')->onDelete('cascade');
            $table->integer('arrapt_id')->unsigned();
            $table->foreign('arrapt_id')->references('id')->on('airports')->onDelete('cascade');
            $table->integer('altapt_id')->unsigned()->nullable();
            $table->foreign('altapt_id')->references('id')->on('airports')->onDelete('cascade');
            $table->integer('aircraft_group_id')->nullable()->unsigned();
            $table->foreign('aircraft_group_id')->references('id')->on('aircraft_groups')->onDelete('set null');
            $table->boolean('seasonal');
            $table->date('startdate')->nullable();
            $table->date('enddate')->nullable();
            $table->time('deptime')->nullable();
            $table->time('arrtime')->nullable();
            $table->integer('type');
            $table->boolean('enabled');
            $table->text('defaults')->nullable();
            $table->text('notes')->nullable();
            $table->timestamps();
            $table->softDeletes();
        });
        Schema::create('schedule_complete', function (Blueprint $table) {
            $table->increments('id');
            $table->integer('user_id')->unsigned();
            $table->foreign('user_id')->references('id')->on('users')->onDelete('cascade');
            $table->integer('fo_id')->unsigned()->nullable();
            $table->foreign('fo_id')->references('id')->on('users')->onDelete('cascade');
            $table->integer('airline_id')->unsigned();
            $table->foreign('airline_id')->references('id')->on('airlines')->onDelete('cascade');
            $table->string('flightnum');
            $table->integer('depapt_id')->unsigned();
            $table->foreign('depapt_id')->references('id')->on('airports')->onDelete('cascade');
            $table->integer('arrapt_id')->unsigned();
            $table->foreign('arrapt_id')->references('id')->on('airports')->onDelete('cascade');
            $table->integer('altapt_id')->unsigned()->nullable();
            $table->foreign('altapt_id')->references('id')->on('airports')->onDelete('cascade');
            $table->integer('aircraft_id')->unsigned();
            $table->foreign('aircraft_id')->references('id')->on('aircraft')->onDelete('cascade');
            $table->text('route')->nullable();
            $table->integer('cruise')->nullable();
            $table->text('route_data')->nullable();
            $table->text('load');
            $table->time('deptime');
            $table->time('arrtime');
            $table->timestamps();
        });
        Schema::create('pireps', function (Blueprint $table) {
            $table->increments('id');
            $table->integer('user_id')->unsigned()->nullable();
            $table->integer('airline_id')->unsigned()->nullable();
            $table->foreign('user_id')->references('id')->on('users')->onDelete('set null');
            $table->foreign('airline_id')->references('id')->on('airlines')->onDelete('set null');
            $table->integer('fo_id')->unsigned()->nullable();
            $table->foreign('fo_id')->references('id')->on('users')->onDelete('cascade');
            $table->string('flightnum');
            $table->integer('depapt_id')->unsigned()->nullable();
            $table->foreign('depapt_id')->references('id')->on('airports')->onDelete('set null');
            $table->integer('arrapt_id')->unsigned()->nullable();
            $table->foreign('arrapt_id')->references('id')->on('airports')->onDelete('set null');
            $table->text('route');
            $table->integer('aircraft_id')->unsigned()->nullable();
            $table->foreign('aircraft_id')->references('id')->on('aircraft')->onDelete('set null');
            $table->integer('finance_id')->unsigned()->nullable();
            $table->integer('landingrate')->nullable();
            $table->text('schedule_data')->nullable(); //JSON storage for everything else.
            $table->text('flight_data')->nullable(); //JSON storage for Flight Telemetry
            $table->time('out')->nullable();
            $table->time('off')->nullable();
            $table->time('on')->nullable();
            $table->time('in')->nullable();
            $table->integer('status');
            $table->timestamps();
            $table->softDeletes();
        });
        Schema::create('pirep_comments', function (Blueprint $table) {
            $table->increments('id');
            $table->integer('pirep_id')->unsigned();
            $table->foreign('pirep_id')->references('id')->on('pireps')->onDelete('cascade');
            $table->integer('user_id')->unsigned();
            $table->foreign('user_id')->references('id')->on('users')->onDelete('cascade');
            $table->text('comment');
            $table->timestamps();
            $table->softDeletes();
        });

Lets refine this and change quite a few names around.

NGINX Configuration

Installation documentation does not provide the NGINX configuration options. NGINX does not make use of the .htaccess or web.config included in the repo and needs to be handled manually when setting up the nginx vhost.

The following is a simple configuration to get base functionality working copied from laravel documentation. Addition configuration is necessary for the ACARS and authorization setup.

try_files $uri $uri/ @rewrite;
location @rewrite {
    rewrite ^/(.*)$ /index.php?_url=/$1;
}

No Setup File

Hello,

Under the installation guide, it says to go to www.YOURSITE.com/setup. I tried going to my site, which is www.bisonairwaysvirtual.com/setup, but it says 404 not found, meaning there isn't a setup file. Any help would be appreciated.

Adminpanel > Overview

Press on an entry and you get a white page.

Feature Request: Roster Generator

Allow pilots to generate random roster based on routes available in defined parameters .
ex. As Discussed on Discord.

KLAX-KSEA
KSEA-KMSP

UserControl php still not working Can't change Members Access

Try to change members access to give him Admin and errors SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'admin' cannot be null (SQL: update vaos_users set pilotid = , status = 1, admin = , updated_at = 2017-12-31 06:06:10 where id = 13)

Actually can;t even edit there Name and it errors

Have to go into Mysql database and change manually

Taylor can you look at code

Missing Airport

Airport FAOA Ondangwa Airport is missing - this causes issues with schedule creation

Still looping

Hi,

New to VAOS and love the look. Was able to get it installed, but even though it says you fixed the loop because of Identicon, I still seem to be loopsing no matter what menu I choose in admin and clicking on setting wants to take me to charts.html. I do have the latest release. Any help would be appreciated.

Also, pilot side seems to work fine.

Thanks.

Planes which are in the same Aircraft-Group but from different Airlines

If you create a Schedule and select a airline and aicraftgroup. The wrong airplane is selected.

Add Crew Bases Management for Airlines

FrontEndServiceProvider Not Found

Hi,

So, tried working on it again and now today, I get a 500 error page and this in the laravel.log

[2019-08-29 18:47:45] local.ERROR: Class 'Modules\FrontEnd\Providers\FrontEndServiceProvider' not found {"exception":"[object] (Symfony\\Component\\Debug\\Exception\\FatalThrowableError(code: 0): Class 'Modules\\FrontEnd\\Providers\\FrontEndServiceProvider' not found at /home/marrymem/kingsleyexecutivejet.tk/pilotcenter/vendor/laravel/framework/src/Illuminate/Foundation/ProviderRepository.php:208) [stacktrace] #0 /home/marrymem/kingsleyexecutivejet.tk/pilotcenter/vendor/laravel/framework/src/Illuminate/Foundation/ProviderRepository.php(144): Illuminate\\Foundation\\ProviderRepository->createProvider('Modules\\\\FrontEn...') #1 /home/marrymem/kingsleyexecutivejet.tk/pilotcenter/vendor/laravel/framework/src/Illuminate/Foundation/ProviderRepository.php(61): Illuminate\\Foundation\\ProviderRepository->compileManifest(Array) #2 /home/marrymem/kingsleyexecutivejet.tk/pilotcenter/vendor/nwidart/laravel-modules/src/Laravel/Module.php(27): Illuminate\\Foundation\\ProviderRepository->load(Array) #3 /home/marrymem/kingsleyexecutivejet.tk/pilotcenter/vendor/nwidart/laravel-modules/src/Module.php(251): Nwidart\\Modules\\Laravel\\Module->registerProviders() #4 /home/marrymem/kingsleyexecutivejet.tk/pilotcenter/vendor/nwidart/laravel-modules/src/Repository.php(299): Nwidart\\Modules\\Module->register() #5 /home/marrymem/kingsleyexecutivejet.tk/pilotcenter/vendor/nwidart/laravel-modules/src/Providers/BootstrapServiceProvider.php(22): Nwidart\\Modules\\Repository->register() #6 /home/marrymem/kingsleyexecutivejet.tk/pilotcenter/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(586): Nwidart\\Modules\\Providers\\BootstrapServiceProvider->register() #7 /home/marrymem/kingsleyexecutivejet.tk/pilotcenter/vendor/nwidart/laravel-modules/src/ModulesServiceProvider.php(38): Illuminate\\Foundation\\Application->register(Object(Nwidart\\Modules\\Providers\\BootstrapServiceProvider)) #8 /home/marrymem/kingsleyexecutivejet.tk/pilotcenter/vendor/nwidart/laravel-modules/src/LaravelModulesServiceProvider.php(15): Nwidart\\Modules\\ModulesServiceProvider->registerModules() #9 [internal function]: Nwidart\\Modules\\LaravelModulesServiceProvider->boot() #10 /home/marrymem/kingsleyexecutivejet.tk/pilotcenter/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(29): call_user_func_array(Array, Array) #11 /home/marrymem/kingsleyexecutivejet.tk/pilotcenter/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(87): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}() #12 /home/marrymem/kingsleyexecutivejet.tk/pilotcenter/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(31): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure)) #13 /home/marrymem/kingsleyexecutivejet.tk/pilotcenter/vendor/laravel/framework/src/Illuminate/Container/Container.php(549): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL) #14 /home/marrymem/kingsleyexecutivejet.tk/pilotcenter/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(792): Illuminate\\Container\\Container->call(Array) #15 /home/marrymem/kingsleyexecutivejet.tk/pilotcenter/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(775): Illuminate\\Foundation\\Application->bootProvider(Object(Nwidart\\Modules\\LaravelModulesServiceProvider)) #16 [internal function]: Illuminate\\Foundation\\Application->Illuminate\\Foundation\\{closure}(Object(Nwidart\\Modules\\LaravelModulesServiceProvider), 18) #17 /home/marrymem/kingsleyexecutivejet.tk/pilotcenter/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(776): array_walk(Array, Object(Closure)) #18 /home/marrymem/kingsleyexecutivejet.tk/pilotcenter/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/BootProviders.php(17): Illuminate\\Foundation\\Application->boot() #19 /home/marrymem/kingsleyexecutivejet.tk/pilotcenter/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(213): Illuminate\\Foundation\\Bootstrap\\BootProviders->bootstrap(Object(Illuminate\\Foundation\\Application)) #20 /home/marrymem/kingsleyexecutivejet.tk/pilotcenter/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(162): Illuminate\\Foundation\\Application->bootstrapWith(Array) #21 /home/marrymem/kingsleyexecutivejet.tk/pilotcenter/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(146): Illuminate\\Foundation\\Http\\Kernel->bootstrap() #22 /home/marrymem/kingsleyexecutivejet.tk/pilotcenter/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request)) #23 /home/marrymem/kingsleyexecutivejet.tk/index.php(53): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request)) #24 {main} "}

Not sure what's going on. I checked the folders and the file is there. Updated the url's in index and boot file.

Adminpanel > Core Settings > VAOS Settings

That page does not exist.

Manage Personal Aircraft (Root Only)

Flight Information Page Feedback (/flightops/flights)

Please post feedback regarding 2.0.0b2's flight information interface here. Anything is open and available to chat on.

Add ACARS Client Access Management Screen

Adminpanel > Dispatch > Dashboard

That page does not exist.

Support for HHVM?

Is VAOS expected to work with HHVM? When attempting to install (and using the base NGINX configuration noted in #36) VAOS is responding to the routing events ok. The /setup works and prompts for database information. After the first prompt for mysql db information and initial VA information, the .env file format is updated to include key/value pairs containing a large number of quotes (that is inconsistent with each setting).

APP_KEY=""""""""base64:EV5xsZUDKJzx6YYxBo6s9To5....................""""""""
APP_DEBUG=""""""""false""""""""
APP_LOG_LEVEL=""""""""warning""""""""
DB_CONNECTION=""""""""mysql""""""""
DB_HOST=""""""""127.0.0.1""""""""
DB_PORT=""""""""3306""""""""
DB_DATABASE=""""test_vaos""""
DB_USERNAME="""vaos"""

After submitting these details the URL will look like: https://vaossite/setup?mode=settings. The page displays "Whoops, looks like something went wrong."

At this point both the setup and main home controller result in the same behavior showing the "Whoops" error. Changing the "APP_DEBUG" to true has no affect on the display. There are also no error logs being generated in hhvm or nginx to better indicate the issue.

Issue displaying stats

Hey!

i like to display the average landing rate also on the dashbaord. We merged oneui with vaos and its working so far but implementing {{ \App\PIREP::where('user_id', $user->id)->avg('landingrate') }} or other functions getting an error

Adminpanel > Dispatch > Bids

Just a white Page

Question

Do you need someone who points out all "issues" in Beta?

ErrorException in Collection.php line 1320: Undefined offset: 0 (Simple BID)

Hello, I cannot bid any flight!

error is:

Whoops, looks like something went wrong.

1/1 ErrorException in Collection.php line 1320:
Undefined offset: 0

Reminder to Taylor to change code in FlightOPs Search from Jet Connect

Taylor Reminder to change code from old Jet Connect in Flight Operations Schedule page to stop 404 issue

Adminpanel > PIREPs > Overview

All you can see is "[]"

Database migrations seem to point to a nonexistant class

Installing VAOS on a blank Ubuntu server, the setup fails. Further testing seems to indicate that this is due to line 43 of the /install route. Running php artisan migrate results in the following output:

$ php artisan migrate
Migration table created successfully.


  [Symfony\Component\Debug\Exception\FatalThrowableError]
  Class '104Update' not found

This would seem to be simply a typo, as there is a class Update104, however I cannot find the occurence of this typo.

Hope this helps!

$ cat /etc/*-release
DISTRIB_ID=Ubuntu
DISTRIB_RELEASE=18.04
DISTRIB_CODENAME=bionic
DISTRIB_DESCRIPTION="Ubuntu 18.04.1 LTS"
NAME="Ubuntu"
VERSION="18.04.1 LTS (Bionic Beaver)"
ID=ubuntu
ID_LIKE=debian
PRETTY_NAME="Ubuntu 18.04.1 LTS"
VERSION_ID="18.04"
HOME_URL="https://www.ubuntu.com/"
SUPPORT_URL="https://help.ubuntu.com/"
BUG_REPORT_URL="https://bugs.launchpad.net/ubuntu/"
PRIVACY_POLICY_URL="https://www.ubuntu.com/legal/terms-and-policies/privacy-policy"
VERSION_CODENAME=bionic
UBUNTU_CODENAME=bionic

Check the server-side validation and add if necessary

Check the server-side validation and add if necessary. Send feedback to the user if something goes wrong

pilots can add the same shedule to his bid page

i dont know if its a bug but maybe the system should check if the pilot already has bid the flight?..

Migrate Existing Panel to VueJS and Vuetify SPA

Adminpanel > Airline > Codeshares

That page does not exist.

[SH] Modules Not Found Exception

got a file error on setup for shared hosting
https://pastebin.com/3rWPuG5P

Adminpanel > Core Settings > ACARS

That page does not exist.

Problems Installing on Fresh Server

Hello,

I am installing this on Ubuntu 16.0 with nginx/1.10.3 (Ubuntu), mysql 5.7.23 and PHP 7.1.20 with php-fpm enabled.

Here's the link to the info file http://149.56.91.84/info.php

I even reach the part where it says "'Well, welcome to your new system, or we would normally say that. So if you are seeing this message, your webserver dependencies should be in line and everything is working. There's just one problem."

But when I click on "Install", it goes to 404 not found? Is this project still being maintained?

http://149.56.91.84/setup

Thanks.

Add Aircraft Editing

Recaptcha no captcha testing on VAOS

Self assigned.

Installation Problem

Hello ,
Can someone help me with the installation ?

Unfortunaly my host doesnt provide access to .git , I tried to install manual but doesnt work .

Can someone help me?

Cheers
Rafael Letras

Manual Adding Flight Hours

Add the ability to add Part 93 hours to the logbook system.

Allow editable logbook entires for personal tracking.

consider to use repositories, instead to call Eloquent directly

Avatars and Cover Photos Not Working

Tracing it down to not saving in profile controllers. Will look at it for another hot patch.