Rust PHP Stats page

Shows stats of players like KDR and played time.

18.07.2017: This is rewritten to support oxide plugin: Player Ranks

git clone https://github.com/kennethrisa/Stats.git

Short Example:

rename example-mconfig.php to mconfig.php rename example-api-server1.php to api-server1.php Edit api-server1.php, find $url and provide your api key after key=yourKey
for rust-servers.info you only need to change to your server ID

• Support for multiple servers
• Support for rust-servers.net and rust-servers.info
• Updated oxide plugin to Player Ranks

Im not a pro devloper, just testing and learning!

See the how to section for setup.

Demo: https://demo.altirust.no/ Kenna - Altirust.no

Required:

• Oxide
• Oxide plugin: Player Ranks
• rust-servers.net - you need to register your server to get api key
• rust-servers.info - you need to register your server
• MySql/MariaDB
• Webserver
• php 5.6>

Oxide plugin:

Player Ranks (http://oxidemod.org/plugins/player-ranks.2359/) Se how to install on oxidemod.org

How to:

Im gonna assume you own a dedi box, and we are gonna install all on the same machine where rust server are running. We are gonna create a subdomain to this so you can add it to your website, like stats.yourdomain.com, this will be pointed to your dedi server.

• OS: Win 2012 r2.
• MariaDB 10.2.6 stable.
• Nginx 1.13.2 windows with fast-cgi php7.

If you are gonna use a sql server who is not on the same server, make sure thats the latency is not big, or you are gonna have performance issues.

Download the content

1. Create a folder c:\git\ and go to this folder.
2. git clone https://github.com/kennethrisa/Stats.git or download it as a zip and extract the content to c:\git\stats

MariaDB

1. How to install mariaDB on windows
   Direct Download link: https://downloads.mariadb.org/interstitial/mariadb-10.2.6/winx64-packages/mariadb-10.2.6-winx64.msi/from/http%3A//mirror.host.ag/mariadb/
   
2. Follow the step by step guide here: https://mariadb.com/kb/en/mariadb/installing-mariadb-msi-packages-on-windows/
   
3. The installer above install's HeidiSQL, we will use this client to create user, or choose your fav one, some use phpmyadmin.
   
4. After you have installed mariaDB and HeidiSQL client, Open HeidiSQL and connect to your server.(Hit start icon, and type HeidiSQL -> Enter)
   Choose New -> Session in root folder -> Enter localhost or your ip -> Enter root/password with what you entred in the setup and hit Save -> open.
   
5. Right click on start menu and hit run, type: services.msc and see if MySQL is running. this service has to run.
6. HeidiSQL: Hit the Query (Blue Play button) and paste this in, so we can create the database as rust and sql user as rust :
   

CREATE DATABASE rust;

CREATE USER rust@'%' IDENTIFIED BY 'yourpassword';
GRANT ALL privileges ON rust.* TO 'rust'@'%' WITH GRANT OPTION;;
FLUSH PRIVILEGES;

7. Try to login with the rust user and see if you have access (re-run step 4, just with rust user), this is the credentials you are gonna use in the website and oxide config.
   

Nginx:

1. Download nginx/windows 1.13.2 (latest stable version)
   Download link: http://nginx.org/en/download.html
   
2. Click on nginx/windows-1.13.2 - it will now download a zip. Extract this zip file and copy the files to c:\nginx
   
3. move c:\git\stats\nginx\start.bat and stop.bat content to c:\nginx and dobbel click on start.bat - this will start nginx, so if you restart your server, you will have to start this again. You can also verify it start to open taskmgr, and see it in the "Details tab" called "nginx.exe" two times.
   
4. Download php 7.1.6: http://windows.php.net/downloads/releases/php-7.1.6-nts-Win32-VC14-x86.zip
   
5. Extract content and rename the folder to php, move it to c: so the path is c:\php
   
6. Now we need to copy a program called RunHiddenConsole to get php to run on port 9000.
   
7. Extract RunHiddenConsole.zip in path c:\git\stats\nginx\ and make a new dir called "bin" in c:\ so the path will be c:\bin\ copy the RunHiddenConsole.exe and paste it in to c:\bin.
   
8. To get php to start we need Visual C++ 2015 redist x86(Not x64), download from micrisoft: https://www.microsoft.com/en-us/download/details.aspx?id=52685 and install the package afterward.
   
9. Copy start-php-fcgi.bat from c:\git\stats\nginx to c:\nginx\ and dobbel tap it so it starts. this you will also need to start after a reboot of the server. Verify it has started, open taskmgr and see the details tab after "php-cgi.exe"
   
10. If you get a an error that you are missing vcruntime140.dll, you have not installed the correct one in step 8(vc_redist.x86.exe).
    
11. Now we need to edit the c:\nginx\conf\nginx.conf file to get it working with php.
    
12. Edit: c:\nginx\conf\nginx.conf go down to line 65 and uncomment to line 71 like this:

        # pass the PHP scripts to FastCGI server listening on 127.0.0.1:9000
        #
        location ~ \.php$ {
            root           html;
            fastcgi_pass   127.0.0.1:9000;
            fastcgi_index  index.php;
            fastcgi_param  SCRIPT_FILENAME  /scripts$fastcgi_script_name;
            include        fastcgi_params;
            include        fastcgi.conf;
        }

Make sure you also add the last line: include fastcgi.conf; or you can get a error like this: no input file specified
13. Now try to go to your browser and see if nginx have started successful: http://localhost/
14. If you see "Welcome to nginx", then the nginx is successful installed.
15. Now we need to make sure php works.
16. create a file in c:\nginx\html\helloworld.php

<?php echo "Hello world"; ?>

try now to browse to http://localhost/helloworld.php
If it says Hello world, than everything is now fine.
17. Now we need to add so the index.php is the default who is being loaded. Edit c:\nginx\conf\nginx.conf
and add this to the line: index.php on line 45 like so:

index  index.php index.html index.htm;

18. Edit the php.ini file. First we need to rename c:\php\php.ini-production to php.ini. you can also copy c:\git\stats\nginx\php.ini to c:\php\php.ini if you don't want to edit it.
    
19. edit the file and remove the ; on line 905 and 907 like it will be like this:

before:
;extension=php_mysqli.dll
;extension=php_openssl.dll
After:
extension=php_mysqli.dll
extension=php_openssl.dll

20. Restart php, go to taskmgr and kill php-cgi.exe and use the start-php.fcgi.bat to start it again.
    

Web files

1. Copy the all the files/folders from c:\git\stats exept for folders: nginx, rust_plugin and CreateDatabases.txt to c:\nginx\html<br>
2. Rename example-mconfig.php to mconfig.php
   
3. Rename example-navbar.php to navbar.php
   
4. Rename example-api-server1.php to api-server1.php
   
5. Now edit mconfig.php and fill inn sql credentials.
   
6. Edit api-server1.php and fill inn your rust-server.net api key and rust-servers.info server ID.
   
7. Now browse to http://localhost/ and you should see you get info from rust-servers.info and rust-servers.net
   

Rust plugin PlayerRanks.cs

1. Get latest update from http://oxidemod.org/plugins/player-ranks.2359/ and add it into your rust plugin folder.
   
2. you should now edit the file oxide\config\PlayerRanks.json and fill inn the database information like below
   

"MySQL - Database Name": "rust",
"MySQL - Host": "localhost",
"MySQL - Password": "your password",
"MySQL - Port": 3306,
"MySQL - Table Name": "playerranksdb",
"MySQL - Use MySQL": true,
"MySQL - Username": "rust",

3. Go into rust console and type reload PlayerRanks - this plugin will auto create the sql tables.
4. Wait 15 min and it should save the data to the SQL database server, or run this console command: playerranks.save

Subdomain

I have no idea what hosting company you use, but you should now just create a "A Record" stats.yourdomain.com and point it to your external IP
just remember to open port 80/443 TCP from same as you open the rust port.

You should also consider to move your domain to Cloudflare for faster cdn and website
You also get free ssl and auto renewal.

Hardning nginx

More coming

Template by bootstrap

Credits

The man who made this rust plugin: Oxide user: =BBUK= Steenamaroo