Choppra

Exile PHP Admin Tools/Portal

52 posts in this topic

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

AaZNH2C.png
LYPa4lq.png
wkei5I5.png
cc7vaVg.png
YnYhmAo.png
2le0xLs.png
70B57y6.png
BAIo64r.png
1BGMQQJ.png
PycYMfS.png

IihGl7J.png

djpYvOo.png

Edited by Choppra
  • Like 8

Share this post


Link to post
Share on other sites
Advertisement
Advertisement

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.