Exile PHP Admin Tools/Portal

[Choppra 69]

www.choppra.net - stats page is being released soon.

I've been working on this project for a while now and I decided to release it.  

Link to github: https://github.com/Choppra/ExilePHPAdminTools

PLEASE READ THE FOLLOWING CAREFULLY! IT IS STRAIGHT FROM THE GITHUB PAGE!

I WILL NOT PROVIDE ANY SUPPORT HERE! READ BELOW!

If you would like to donate, send it to [email protected]

# Exile PHP Admin Portal by Choppra (www.ATDGaming.com)
# Install this at your own risk.  There are server overwrites.  
If you break something, it is NOT my fault.  
I've done my best to explain everything below.

# Introduction
I have no formal programming background.  This project originally started as a 
simple tool to be able to read logs and view server information.  As time went on
I decided to expand.  Some of you programmers and php experts may not agree with the
way I am doing things.  I am open to feedback and also suggestions but in the end this was
done as a fun project and I am far from an expert in this area.
I've also styled this based on a 24inch Monitor Setup running at 1920x1080.
You can adjust tables as you see fit to work with other resolutions.

# Prerequisites
* Knowledge of MySQL (Setting up Accounts and Creating Tables)
* Web server knowledge (how to set up, etc)

# Support
I will not provide support ANYWHERE except on the github page dedicated to this project.  
If you have a suggestion or issue, please submit an issue on github.

# Notes
I have this setup for use with 3 servers.  You will need to modify condb.php and navbar.php.
I will not provide support on how to edit these files.  It should be self explanatory.

Once you modify the databases and database menu, I suggest running logout.php after
making the changes.  It will close the current session and allow for the change to work.

# Requirements
* Infistar Log to Database Enabled
* Create Tables used by these tools (trader_log, trader_recycle_log)
```````````sql
CREATE TABLE `trader_log` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`playerid` VARCHAR(50) NULL DEFAULT NULL,
	`item_sold` VARCHAR(100) NULL DEFAULT NULL,
	`poptabs` INT(50) NULL DEFAULT NULL,
	`respect` VARCHAR(50) NULL DEFAULT NULL,
	`time_sold` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
	INDEX `Index 1` (`id`),
	INDEX `Index 2` (`item_sold`),
	INDEX `Index 3` (`playerid`),
	INDEX `Index 5` (`time_sold`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=1
;

CREATE TABLE `trader_recycle_log` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`playerid` VARCHAR(50) NULL DEFAULT NULL,
	`item_sold` VARCHAR(100) NULL DEFAULT NULL,
	`poptabs` INT(50) NULL DEFAULT NULL,
	`respect` VARCHAR(50) NULL DEFAULT NULL,
	`transactionid` INT(100) NULL DEFAULT NULL,
	`vehicleclass` VARCHAR(50) NULL DEFAULT NULL,
	`soldvehicle` VARCHAR(50) NULL DEFAULT NULL,
	`time_sold` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
	INDEX `Index 1` (`id`),
	INDEX `Index 2` (`item_sold`),
	INDEX `Index 3` (`playerid`),
	INDEX `Index 5` (`time_sold`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=1
;


```````````
* Exile.ini Updates (add the following)
```````````
[updateTraderRecycleLog]
SQL1_1 = INSERT INTO trader_recycle_log SET playerid = ?, item_sold = ?, poptabs = ?, respect = ?, vehicleclass = ?, transactionid = ?, soldvehicle = ?
Number of Inputs = 7
SQL1_INPUTS = 1,2,3,4,5,6,7

[updateTraderLog]
SQL1_1 = INSERT INTO trader_log SET playerid = ?, item_sold = ?, poptabs = ?, respect = ?
Number of Inputs = 4
SQL1_INPUTS = 1,2,3,4

```````````
* Exile Server PBO Ovewrites (see extras folder - remember to backup)
* MySQL Account with the following permissions (You can use root or a high privledged account but thats up to you)
	* Account - Select / Update
	* Clan - Select
	* Construction - Select / Update
	* Container - Select / Update
	* Infistar_Logs - Select
	* Territory - Select / Update
	* Trader_Log - Select
	* Trader_Recycle_log - Select

# Clean up Routines
Note:  I suggest running these clean up routines on server restart.  I have mine set to delete after 10 Days.

```````````sql
prerequisites
DELETE FROM exile_tanoa.infistar_logs WHERE exile_tanoa.infistar_logs.time < DATE_SUB(NOW(), INTERVAL 10 DAY);
DELETE FROM exile_tanoa.trader_log WHERE exile_tanoa.trader_log.time_sold < DATE_SUB(NOW(), INTERVAL 10 DAY);
DELETE FROM exile_tanoa.trader_recycle_log WHERE exile_tanoa.trader_recycle_log.time_sold < DATE_SUB(NOW(), INTERVAL 10 DAY);
```````````

Edited July 18, 2017 by Choppra

[Choppra 69]

Holding post

[Kronyx 8]

10/10

Works great, territory restore feature is wonderful.

[kuplion 1785]

How do I install this? Can you help me? I'll give you admin on my server!

[Nevo 10]

13 minutes ago, kuplion said:

How do I install this? Can you help me? I'll give you admin on my server!

https://github.com/ATDChoppra/ExilePHPAdminTools/blob/master/README.md

[kuplion 1785]

2 minutes ago, Nevo said:

https://github.com/ATDChoppra/ExilePHPAdminTools/blob/master/README.md

I was only winding @Choppra up, but thank you.

[eraser1 329]

Help it doesn't work

[kuplion 1785]

Is this used for admin abuse?

[Choppra 69]

Github Updated.  Added Support for Clans.  Find out whos in them and who the leader is.

[Z80CPU 527]

VERY kool Choppra!  While I did not get it, I say this based on the screenshots!

Excellent work!