Leaderboard

This project integrates game server data to drive the display of a leaderboard, with some additional facilities for logged in users to associate and manage elements of their respective in-game character(s).

Features

• Full account flow/lifecycle (register, login, recover, update, delete)
• Support for linking characters to an account and performing actions
• Steam user identifier (via OpenID) associating with an account (to match characters)
• Gravatar support for overriding character avatars with the one driven via user email instead of Steam
• Ko-fi webhook support to associate contributions and allow users to access a set of permission restricted features

Getting Started

Make a copy of the environment file:

cp .env.example .env

With laravel/sail start/build the project's containers:

./vendor/bin/sail up -d

For the remaining steps sail acts as an alias of ./vendor/bin/sail

Run vite:

sail npm run dev

Initial Setup

Generate an application key:

sail artisan key:generate

Run the migrations and seed the database:

sail artisan migrate && sail artisan db:seed

Ready

You should now be able to access the application via:

• http://laravel.test

Bridge

As the platform depends on data inserted from an Arma 2: Operation Arrowhead mission there will need to be SQF scripting considerations to utilitise the project as intended.

The following tables are used as part of this process:

Optional	Name	Fields	Purpose
❌	characters	guid name score	Stores the main data
✔️	character_statistic	character_id statistic_id value	Tracking statistics
✔️	model_has_roles	role_id model_id	Feature access based on a permissions library

For an example on how this has been integrated into an existing mission using Arma2NETMySQL, see the repo pridit-a2oa/co40_Domination.Takistan.

Deployment

For ease of use this application can be deployed through Docker, as it is already dockerized with support for SSR and a Queue Worker.

For non-Docker hosting solutions, such as Forge, please explore these on your own (with the above considerations).

Build the image:

docker build . -t leaderboard

Start the container:

docker run -d \
    --name leaderboard \
    --restart unless-stopped \
    -e KOFI_TOKEN=<OPTIONAL> \
    -e STEAM_AUTH_API_KEYS=<OPTIONAL> \
    -p 8080:8080 \
    leaderboard

Important

This barebones container does not include mail or database support, and won't work as-is. Check the .env.example file for applicable environment variables, as this will vary depending on other containers or the services you want to use (e.g. Mailgun/managed database).

Issues

1. (SSR) Link component v-html directive ignored: vuejs/core#6435
2. (SSR) Font Awesome hydration mismatch using strings: FortAwesome/vue-fontawesome#394
3. Web Components with SSR (missing exports, definitions, bundling) and general limitations (shadow DOM restricting styling)

Linting

For style fixing laravel/pint can be used.

./vendor/bin/pint

Testing

Create a new MySQL database called testing

Run the unit/feature tests:

sail artisan test

Run the browser tests supported by laravel/dusk:

sail dusk

While running Dusk tests Selenium can be observed using noVNC via:

• http://localhost:7900/?autoconnect=1&resize=scale&password=secret

Important

Dusk will not work with Vite running, so ensure it is off prior to running this test suite.

License

This project is licensed under the MIT License.