patsonluk / airline Goto Github PK

View Code? Open in Web Editor NEW

104.0 4.0 63.0 128.23 MB

License: Apache License 2.0

Scala 59.52% HTML 9.55% CSS 3.15% JavaScript 25.96% Shell 0.01% Java 1.81%

airline's Introduction

An opensource airline game.

Live at https://www.airline-club.com/

Version 2 alpha at https://v2.airline-club.com

Setup

install git :D of course
clone this repo ;D , to setup for V2 use git checkout v2
Install at least java development kit 8+
The 2 main projects are : airline-web (all the front-end stuff) and airline-data (the backend simulation).(Optional) If you want to import them to Scala IDE (if you want to code), goto the folder of those and run activator eclipse to generate the eclipse project files and then import those projects into your IDE
This runs on mysql db (install veresion 5.x, i heard newest version 8.x? might not work). install Mysql server and then create database airline_v2_1, create a user sa, for password you might use admin or change it to something else. Make sure you change the corresponding password logic in the code to match that (https://github.com/patsonluk/airline/blob/master/airline-data/src/main/scala/com/patson/data/Constants.scala#L99)
airline-web has dependency on airline-data, hence navigate to airline-data and run activator publishLocal. If you see encoding error, add character_set_server=utf8mb4 to your /etc/my.cnf and restart mysql. it's a unicode characters issue, see https://stackoverflow.com/questions/10957238/incorrect-string-value-when-trying-to-insert-utf-8-into-mysql-via-jdbc
You would need to initialize the DB and data on first run. In airline-data, run activator run, then choose the one that runs MainInit. It will take awhile to init everything.
Set google.mapKey in application.conf with ur google map API key value. This might not necessary if you run on local host (?) , but if you want to host a public one, your probably need to apply one from google and enable the map API. Be careful with setting budget and limit, google gives some free credit but it CAN go over and you might get charged!
(Optional) For the "Flight search" function to work, install elastic search 7.x, see https://www.elastic.co/guide/en/elasticsearch/reference/current/install-elasticsearch.html . For windows, I recommand downloading the zip archive and just unzip it - the MSI installer did not work on my PC
(Optional) For airport image search and email service for user pw reset - refer to https://github.com/patsonluk/airline/blob/master/airline-web/README
Now run the background simulation by staying in airline-data, run activator run, select option MainSimulation. It should now run the backgroun simulation
Open another terminal, navigate to airline-web, run the web server by activator run
The application should be accessible at localhost:9000

Banners

Self notes, too much trouble for other people to set it up right now. Just do NOT enable the banner. (disabled by default, to enable change bannerEnabled in application.conf

For the banners to work properly, need to setup google photo API. Download the oauth json and put it under airline-web/conf. Then run the app, the log should show an oauth url, use it, then it should generate a token under airline-web/google-tokens. Now for server deployment, copy the oauth json google-oauth-credentials.json to conf AND the google-tokens (as folder) to the root of airline-web.

Attribution

Some icons by Yusuke Kamiyamane. Licensed under a Creative Commons Attribution 3.0 License
Flag icons by famfamfam

airline's People

Contributors

Stargazers

Watchers

Forkers

polanpablo henderb daprof1 airline-club airairways kiike flybondi123 deltajets tp-cai marylandflyer acosaburca diogomartins96 duplominh germanwings jamartinez2018 billdong9 edoebzd s-aanaik foreverair frankpigeon reo-ar theqantas vanillacakepeople rhettung andreasv9 maeyanie grebfar lord-sausageroll bohaska xaos-interactive dmanoj9 stealthhydra179 dario2018 anthidote topspin85 swojtyla kiisterplaster crazywazza airlinesimworld redisperfect myflyclub readytostrike bwbama85 home-office-improvements-ltd nolimit751 bleu0 drvntechnologies zapsnh ciaran5933 garvark malaras ihrsoc felixm-byte backyardschool thedolphinsfan1 lenovix kockacat evamvid

airline's Issues

Multiple sort

Sort to keep previous order

Confirmation dialog for removing base

Sort Route by Aircraft

Websocket cannot connect if it's not localhost

Delay should impose higher cost

Both in terms of loyalty and profit

rebuild HQ gives undefined values in airport popup

Enter key to login

Change mediumtext column to bigint

For drop down, should always push owned airplane model (with available ones) to top of list

More obvious clues for service quality adjustment

Country screen ensure a default sort

Name sort not working?

Add depreciation computation

DB connection expires after inactivity

Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 32,976,431 milliseconds ago.  The last packet sent successfully to the server was 32,976,431 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_65]
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_65]
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_65]
        at java.lang.reflect.Constructor.newInstance(Constructor.java:422) ~[na:1.8.0_65]
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:404) ~[mysql-connector-java-5.1.38.jar:5.1.38]
        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:981) ~[mysql-connector-java-5.1.38.jar:5.1.38]
        at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3652) ~[mysql-connector-java-5.1.38.jar:5.1.38]
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2460) ~[mysql-connector-java-5.1.38.jar:5.1.38]
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625) ~[mysql-connector-java-5.1.38.jar:5.1.38]
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2551) ~[mysql-connector-java-5.1.38.jar:5.1.38]
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861) ~[mysql-connector-java-5.1.38.jar:5.1.38]
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1962) ~[mysql-connector-java-5.1.38.jar:5.1.38]
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:1418) ~[c3p0-0.9.5.jar:0.9.5]
        at com.patson.data.AirlineSource$.loadAirlineBasesByCriteria(AirlineSource.scala:284) ~[airline-data_2.11.jar:1.1-SNAPSHOT]
        at com.patson.data.AirlineSource$.loadAirlineBasesByAirline(AirlineSource.scala:237) ~[airline-data_2.11.jar:1.1-SNAPSHOT]
        at com.patson.data.AirlineSource$.loadAirlinesByQueryString(AirlineSource.scala:66) ~[airline-data_2.11.jar:1.1-SNAPSHOT]
        at com.patson.data.AirlineSource$.loadAirlinesByIds(AirlineSource.scala:25) ~[airline-data_2.11.jar:1.1-SNAPSHOT]
        at com.patson.data.LinkSource$.loadLinksByCriteria(LinkSource.scala:67) ~[airline-data_2.11.jar:1.1-SNAPSHOT]
        at com.patson.data.LinkSource$.loadLinkByAirportsAndAirline(LinkSource.scala:171) ~[airline-data_2.11.jar:1.1-SNAPSHOT]
        at controllers.LinkApplication$$anonfun$planLink$1.apply(LinkApplication.scala:400) ~[classes/:na]
        at controllers.LinkApplication$$anonfun$planLink$1.apply(LinkApplication.scala:394) ~[classes/:na]
        at play.api.mvc.ActionBuilder$$anonfun$apply$16.apply(Action.scala:408) ~[play_2.11-2.4.3.jar:2.4.3]
        at play.api.mvc.ActionBuilder$$anonfun$apply$16.apply(Action.scala:407) ~[play_2.11-2.4.3.jar:2.4.3]
        at play.api.mvc.Action$.invokeBlock(Action.scala:533) ~[play_2.11-2.4.3.jar:2.4.3]
        at play.api.mvc.Action$.invokeBlock(Action.scala:530) ~[play_2.11-2.4.3.jar:2.4.3]
        at play.api.mvc.ActionBuilder$$anon$1.apply(Action.scala:493) ~[play_2.11-2.4.3.jar:2.4.3]
        at play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4$$anonfun$apply$5.apply(Action.scala:105) ~[play_2.11-2.4.3.jar:2.4.3]
        at play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4$$anonfun$apply$5.apply(Action.scala:105) ~[play_2.11-2.4.3.jar:2.4.3]
        at play.utils.Threads$.withContextClassLoader(Threads.scala:21) ~[play_2.11-2.4.3.jar:2.4.3]
        at play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4.apply(Action.scala:104) ~[play_2.11-2.4.3.jar:2.4.3]
        at play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4.apply(Action.scala:103) ~[play_2.11-2.4.3.jar:2.4.3]
        at scala.Option.map(Option.scala:146) ~[scala-library-2.11.6.jar:na]
        at play.api.mvc.Action$$anonfun$apply$1.apply(Action.scala:103) ~[play_2.11-2.4.3.jar:2.4.3]
        at play.api.mvc.Action$$anonfun$apply$1.apply(Action.scala:96) ~[play_2.11-2.4.3.jar:2.4.3]
        at play.api.libs.iteratee.Iteratee$$anonfun$mapM$1.apply(Iteratee.scala:524) ~[play-iteratees_2.11-2.4.3.jar:2.4.3]
        at play.api.libs.iteratee.Iteratee$$anonfun$mapM$1.apply(Iteratee.scala:524) ~[play-iteratees_2.11-2.4.3.jar:2.4.3]
        at play.api.libs.iteratee.Iteratee$$anonfun$flatMapM$1.apply(Iteratee.scala:560) ~[play-iteratees_2.11-2.4.3.jar:2.4.3]
        at play.api.libs.iteratee.Iteratee$$anonfun$flatMapM$1.apply(Iteratee.scala:560) ~[play-iteratees_2.11-2.4.3.jar:2.4.3]
        at play.api.libs.iteratee.Iteratee$$anonfun$flatMap$1$$anonfun$apply$14.apply(Iteratee.scala:537) ~[play-iteratees_2.11-2.4.3.jar:2.4.3]
        at play.api.libs.iteratee.Iteratee$$anonfun$flatMap$1$$anonfun$apply$14.apply(Iteratee.scala:537) ~[play-iteratees_2.11-2.4.3.jar:2.4.3]
        at scala.concurrent.impl.Future$PromiseCompletingRunnable.liftedTree1$1(Future.scala:24) [scala-library-2.11.6.jar:na]
        at scala.concurrent.impl.Future$PromiseCompletingRunnable.run(Future.scala:24) [scala-library-2.11.6.jar:na]
        ... 6 common frames omitted
Caused by: java.net.SocketException: Software caused connection abort: socket write error
        at java.net.SocketOutputStream.socketWrite0(Native Method) ~[na:1.8.0_65]
        at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:109) ~[na:1.8.0_65]
        at java.net.SocketOutputStream.write(SocketOutputStream.java:153) ~[na:1.8.0_65]
        at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82) ~[na:1.8.0_65]
        at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140) ~[na:1.8.0_65]
        at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3634) ~[mysql-connector-java-5.1.38.jar:5.1.38]
        ... 41 common frames omitted```

Make loan option a Slider

As the input field might not be that obvious to users

Or some other options to make it user friendly

Airplane details does not show the sell value

Show month and year instead of weeks in profit chart

Deleting a user should remove the airline too

Shorter intercontinental routes

From user:

Would it be possible for routes that are short, say under 1000 km to not count as intercontinental and instead be regional? Right now cities at the edge of a continent are terrible for hubs because you can only fly in one direction without using up your precious few intercontinental routes. Cities such as Panama City (PTY) that make fine real-world hubs are bad in the game due to this reason.

Control airplane available based on country relationship

service funding in negative balance

Its possible to max fund the service even when you have a negative balance

Eliminate direct demand between 2 airports that are too close

Probably within 50km.

Need to consider the case for islands tho

Recapcha doesn't seem to allow players with ad block on

Zoom in the get more airports

Perhaps do a better job to put small airports into grids and only get those when zoomed in?

Better mechanism to purge user/airline

Deleting it in the middle of sim cause constraint error like:

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`airline`.`country_market_share`, CONSTRAINT `country_market_share_ibfk_2` FOREIGN KEY (`airline`) REFERENCES `airline` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
        at com.mysql.jdbc.Util.getInstance(Util.java:387)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:932)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2551)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
        at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2073)
        at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1751)
        ... 16 more

Need to stop sim and purge and restart

Passenger map to show traffic of alliance

Now that we have an alliance system, it would be great to see on the passenger map not only which passengers use your or other airlines, but also which ones use an allied airline. Besides the text, maybe you can use a different colour for these three categories?

setup cron job to backup DB

Price buttons

-If you click on routes, and then edit a route, clicking + or - for the ticket prices starts at the default value instead of at the current value.

-If you click on routes, and then edit a route, and then cancel, the direct competitions pie chart does not show the names of the airlines anymore.

Should sleep after cycle start to get consistent cycle duration

airport charms suggestions

Vacation hub:

Santorini (JTR) to scale 3 too
Crete (HER)
Malta (MLA)
Los Cabos (SJD)
The Bahamas (NAS)
British Virgin Islands (STT) later...not enough visitors it seems
US Virgin Islands (STX) later...not enough visitors it seems
FLL
Myrtle Beach (MYR) 14 milion visitors annually - https://en.wikipedia.org/wiki/Myrtle_Beach,_South_Carolina later...not enough visitors it seems
Savannah (SAV) 13.9 visitors annually - http://www.savannahnow.com/news/2017-05-12/more-savannah-tourists-spend-more-money-2016 later...not enough visitors it seems

Create link not selecting available plane by default

Remove plan route button if its a base

Sort inventory list by condition

Buy/Sell airplane does not update the list accordingly

Confirm delay compensation is not adding to profit...

Fix pie color in country screen

Fix database access stalling problem

Probably due to writing history

Maybe dropping the foreign key on link would help - might need to add an index for quicker load tho

Data simulation to reconnect on wait timeout

Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 50,018,094 milliseconds ago. The last packet sent successfully to the server was 50,018,094 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.

And it seems failed to resume