Determine the user the web server is running as. (most likely www-data) Give the web server access to the files and set the correct permissions for the config file.
If you don't want to run the web app in it's on directory (https://yourdomain.com/Game-Server-Query-and-Control-Center-1.0.0-alpha/index.php), move every file and directory into the current folder.
Create database
Log in to mysql
Do you have a mysql user? If not:
Create the database. I called my database "tracker". You can use this name or use your own name.
Go to your Webbrowser and type in your Domain/IP. If your website is stored in an extra directory as described earlier, add the directory name to your input. https://yourdomain/<directoryname> The website will automatically redirect you to the installation page.
Enter your Steam Web API Key, and your Database credentials. Test the connection. If the connection succeed, click on submit.
Now your going to create an admin user. Enter a secure password and click on submit. You get redirected to the start page.
Click on Login in the top right corner.
If you're trying to add a Minecraft Server and your server doesn't support the query protocol, use 0 as query port.
After logging in click on the user avatar in the top right corner and click on Server in in the left.
Click on Add a server and fill out the form. If Rcon is disabled, use 0 as Rcon Port.
CREATE USER <username>@localhost IDENTIFIED BY '<yoursecurepassword>';
CREATE DATABASE <DBName> /*\!40100 DEFAULT CHARACTER SET utf8 */;
GRANT ALL PRIVILEGES ON <DBName>.* TO '<username>'@'localhost';
FLUSH PRIVILEGES;
USE <DBName>;
CREATE TABLE users (id INT auto_increment PRIMARY KEY AUTO_INCREMENT, username VARCHAR(100) NOT NULL, password VARCHAR(100) NOT NULL, server JSON NOT NULL, sprite VARCHAR(25) NOT NULL, seed VARCHAR(100) NOT NULL);
