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);
```````````
