[RELEASE] LogSystem by StrangeR

[Thorxx]

Hello ladies and gentlemans!

As you might know I've been working on a script called LogSystem.

And today I finally finished the script.

The scripts includes website to show the logs.

WHAT DO YOU NEED TO USE THIS SCRIPT?

- MySQL Database

- MTA Server

- Website that allows you to use php applications/systems

------------------------------------------------------------------------------------------

The script is under free licence (Copyleft)

------------------------------------------------------------------------------------------

1. Download the logSystem from https://community.multitheftauto.com/in ... ls&id=8824

2. Upload it into a server

3. Open logSys.lua and change your MySQL Database Settings!

4. Open your MySQL server and run this command through Query

DROP TABLE IF EXISTS `logBan`;

CREATE TABLE `logBan` (

`ID` int(11) NOT NULL AUTO_INCREMENT,

`Date` longtext NOT NULL,

`Time` longtext NOT NULL,

`bannedElement` longtext NOT NULL,

`Admin` longtext NOT NULL,

`Reason` longtext CHARACTER SET utf32 COLLATE utf32_czech_ci NOT NULL,

`Duration` longtext NOT NULL,

`banIP` longtext NOT NULL,

`serial` longtext NOT NULL,

PRIMARY KEY (`ID`)

) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `logCommand`;

CREATE TABLE `logCommand` (

`ID` int(11) NOT NULL AUTO_INCREMENT,

`Date` longtext NOT NULL,

`Time` longtext NOT NULL,

`Username` longtext NOT NULL,

`PlayerName` longtext NOT NULL,

`IP` longtext CHARACTER SET utf32 COLLATE utf32_czech_ci NOT NULL,

`Serial` longtext NOT NULL,

`Command` longtext NOT NULL,

PRIMARY KEY (`ID`)

) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `logChangeNick`;

CREATE TABLE `logChangeNick` (

`ID` int(11) NOT NULL AUTO_INCREMENT,

`Date` longtext NOT NULL,

`Time` longtext NOT NULL,

`Username` longtext NOT NULL,

`PlayerName` longtext NOT NULL,

`IP` longtext CHARACTER SET utf32 COLLATE utf32_czech_ci NOT NULL,

`Serial` longtext NOT NULL,

`NewNick` longtext NOT NULL,

PRIMARY KEY (`ID`)

) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `logChat`;

CREATE TABLE `logChat` (

`ID` int(11) NOT NULL AUTO_INCREMENT,

`Date` longtext NOT NULL,

`Time` longtext NOT NULL,

`Username` longtext NOT NULL,

`PlayerName` longtext NOT NULL,

`IP` longtext CHARACTER SET utf32 COLLATE utf32_czech_ci NOT NULL,

`Serial` longtext NOT NULL,

`Message` longtext CHARACTER SET armscii8 NOT NULL,

PRIMARY KEY (`ID`)

) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `logJoinQuit`;

CREATE TABLE `logJoinQuit` (

`ID` int(11) NOT NULL AUTO_INCREMENT,

`Date` longtext NOT NULL,

`Time` longtext NOT NULL,

`Username` longtext NOT NULL,

`PlayerName` longtext NOT NULL,

`IP` longtext CHARACTER SET utf32 COLLATE utf32_czech_ci NOT NULL,

`Serial` longtext NOT NULL,

`Text` longtext NOT NULL,

`Reason` longtext,

PRIMARY KEY (`ID`)

) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `logLoginLogout`;

CREATE TABLE `logLoginLogout` (

`ID` int(11) NOT NULL AUTO_INCREMENT,

`Date` longtext NOT NULL,

`Time` longtext NOT NULL,

`Username` longtext NOT NULL,

`PlayerName` longtext NOT NULL,

`IP` longtext CHARACTER SET utf32 COLLATE utf32_czech_ci NOT NULL,

`Serial` longtext NOT NULL,

`Text` longtext NOT NULL,

PRIMARY KEY (`ID`)

) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=latin1;

5. Download the Website files from http://uploaded.net/file/ksj01m0r

6. Upload the files into your website (FTP)

7. Open settings.php and change your MySQL Databse Settings!

8. Start the script

9. Check the website out!

http://www.img.tpx.cz/uploads/bans.png

http://www.img.tpx.cz/uploads/Commands.png

http://www.img.tpx.cz/uploads/Changenick.png

http://www.img.tpx.cz/uploads/chaticeke.png

http://www.img.tpx.cz/uploads/joinquit.png

http://www.img.tpx.cz/uploads/LoginLogout.png

THE SCRIPT WON'T WORK IF YOU WON'T CHANGE THE MYSQL SETTINGS!!!

IGNORE THE ADVERTS ABOVE THE TABLE I'M USING FREE WEB HOSTING!!!

DID YOU FIND A BUG? HAVE YOU GOT AN IDEA TO MAKE THE SCRIPT BETTER?

TYPE IT BELOW THE POST!

[Thorxx]

Download links are fixed now!