siegeengineers/aocrecs.com

Recorded games database website

aocrecs.com

Code for the website aocrecs.com. Includes both the server component and website interface.

Setup

Define the following environmental variables:

Variable	Purpose	Example
MGZ_DB	URL to MGZ database.	postgresql://username:password@localhost:5432/mgzdb
MGZ_GTM	Google Tag Manager ID.	UA-10051774-7
AWS_ACCESS_KEY_ID	AWS access key ID.
AWS_SECRET_ACCESS_KEY	AWS secret access key.
VOOBLY_USERNAME	Voobly username (to access metadata while uploading).
VOOBLY_PASSWORD	Voobly password.

The AWS keys provide access to the S3 bucket storing the compressed recorded games. The Voobly credentials are used to fetch account metadata when adding uploaded matches.

SSL certificate data must exist at data/. Follow the guide here. docker-compose.yaml is pre-configured.

docker-compose build will build all required images.

Deploy

docker-compose up -d will launch three containers:

• Python server
• nginx (reverse proxy in front of server; host for static Javascript assets)
• certbot (for SSL certificate renewal)

Development

Server (python/)

Create a Python virtual environment (Python 3.6+) and enter it: python3 -m venv venv && venv/bin/activate

Install dependencies: pip install -e .

Launch the Python server:

uvicorn aocrecs.main:APP (specify --host and --port as necessary)

UI (js/)

Ensure that node and yarn are installed.

Install dependencies: yarn

Launch the create-react-app development server (from js/):

REACT_APP_API="http://<server_host>:<server_port>/api" REACT_APP_GTM="<gtm_id>" yarn start (set HOSTNAME and PORT as necessary)

Contributions

Pull requests are welcome. If you want to add a feature that requires access to the data, contact me on Discord (happyleaves#4133) to arrange read-only database access.

aocrecs.com's Issues

API gateway seems to be down

The API server seems to be down atm.

• Getting 502 Bad Gateway if I try access: https://aocrecs.com/api
• The aocrecs website also shows Network error: JSON.parse: ..... on landing page.

Is this a build issue or something else. Let me know if I can help.

Add datasect select to Maps list

As the Civilization list page, it would be great to select the datasect for the Map list.

Upload multiple files

Implement multi-file uploading for the Upload Page.

It would be easier to populate the DE dataset if we could provide a lot of matches at once.

Aoe2recs.com is down

@happyleavesaoc

502 Bad Gateway
nginx/1.14.0 (Ubuntu)

Map image uses http url

The map preview image is loaded from http instead of https. This leads to a "not secure" indicator in the web browser due to mixed content.

The http url is already present in the api response and seems to stem from here.

I would have provided a pull request, but I could not find out where to fix it 🙍‍♂️

Add percentages on Most Wins per Map

Hello! First of all I love this project, I'm a web developer and a huge fan of aoe2, thank you for all your work!

It would be great to add percentages to the "Civilizations: Most Wins" in the map page.

I will do some suggestions and maybe do a PR myself, I'm not sure yet ;P

Thanks.