EQdkp Plus

#cms #lang-php #web 

EQdkp-Plus is an open source Content Management System (CMS) and Guild Management System in PHP. It is focused on supporting guilds and clans playing online games, especially MMORPGs. Therefore it brings tools for planning raids or distributing loot or points like DKP (Dragon Kill Points).

Note

For this guide you should be familiar with the basic concepts of

License

EQdkp-Plus is released under the AGPLv3 License.

Prerequisites

We’re using PHP in the stable version 7.4:

[isabell@stardust ~]$ uberspace tools version show php
Using 'PHP' version: '7.4'
[isabell@stardust ~]$

You’ll need your MySQL credentials. Get them with my_print_defaults:

[isabell@stardust ~]$ my_print_defaults client
--default-character-set=utf8mb4
--user=isabell
--password=MySuperSecretPassword
[isabell@stardust ~]$

If you want to use your EQdkp Plus with your own domain you need to setup your domain first:

[isabell@stardust ~]$ uberspace web domain list
isabell.uber.space
[isabell@stardust ~]$

Create Database

EQdkp-Plus saves your data in a MySQL database. It is recommended to use an additional database (e.g. isabell_eqdkp) instead of the default database.

[isabell@stardust ~]$ mysql -e "CREATE  DATABASE ${USER}_eqdkp"
[isabell@stardust ~]$

Installation

cd to your document root, then download the latest release of EQdkp Plus and extract it:

[isabell@stardust ~]$ cd ~/html/
[isabell@stardust html]$ curl -L https://eqdkp-plus.eu/repository/download/latestcore -o eqdkp-plus.zip
 % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                Dload  Upload   Total   Spent    Left  Speed
 100 25565    0 25565    0     0  22942      0 --:--:--  0:00:01 --:--:-- 22948
 100 5138k  100 5138k    0     0   769k      0  0:00:06  0:00:06 --:--:-- 1108k
[isabell@stardust html]$ unzip eqdkp-plus.zip && rm eqdkp-plus.zip
[isabell@stardust html]$

Now point your browser to your uberspace URL and follow the instructions of the Installer Assistant.

You will need to enter the following information:

  • your MySQL hostname, username and password: the hostname is localhost and you should know your MySQL credentials by now. If you don’t, start reading again at the top.

  • your MySQL database name: insert the name of the created additional MySQL database

  • an encryption key: choose a strong encryption key, as sensitive data is encrypted using this key. You can generate a strong key:

[isabell@stardust html]$ pwgen 32 1
SuperSecretPassword
[isabell@stardust html]$

  • Make additional settings like setting first day of week etc. The script path setting is automatically detected and only needs to be changed if the detection will fail. The script path is the subfolder of your domain. If you follow this tutorial, it is /.

  • Administrator username and password: choose a username (maybe not admin) and a strong password for the admin user

Updates

The easiest way to update EQdkp Plus is to use the web updater provided in the admin section of the Web Interface.

Note

Check the news regularly to stay informed about new updates and releases.

Backup

Backup the following directories:

  • ~/html/

Additionally, backup the MySQL database:

[isabell@stardust ~]$ mysqldump isabell_eqdkp | xz - > ~/isabell_eqdkp.sql.xz

Tested with EQdkp Plus 2.3.39.0, Uberspace 7.13, PHP 8.1

Written by: GodMod <godmod@eqdkp-plus.eu>