[ViruZz]

Inspired by spywhere (Bukkit Forums)
Created by ViruZz

Description
AdvLog+ provides logging for your whole SA-MP Server. From someone connecting all the way to a car exploding. This is very useful for administrators and which to keep track of their server in a proper way then using the original server log file that is over 100,000 lines long.

Features

• MySQL Supported
• SQLite Supported
• Logs when a player connects
• Logs when a player disconnects
• Logs when a player dies
• Logs when a player kills another player
• Logs when a player destroys a vehicle
• Logs when a vehicle has been destroyed
• Logs when a player attempts to login into the RCON
• Logs when a player spawns
• Logs when a player performs a command
• Logs when a player types in chat
• You can clear the logs directly IG using /clearlog <logname>
• Gives you an option to let you choose what saving method you wish to use.
• Command to see the currently MySQL Stats /mysqlstats
• Very Basic Webpage to view all the logs (MySQL Only)

Requirements

• MySQL R7
• ZCMD
• YSI (y_timers)

How to use this filterscript

You will need to configure the Filterscript by choosing which method you will like to use and disable the DEFAULT method.

Note: If DEFAULT is enabled, the script won't work.

MySQL: If you're using MySQL as a method, then you will need to enter your configuration like below.



After entering the information, import the SQL Dump file provided in the ZIP (You can use any database manager for this, example; PhpMyAdmin, Navicat, DatabaseManager and etc..)

SQLite: If you're using SQLite as a method, then you will need to use the advlogging.db database. Just place it inside the scriptfiles folder and you will be fine. To open and view the database, you will need to use a tool call SQL Browser (Above version 2)


Webpage: You will need to configure every single file with your MySQL Configuration. After doing so, just drag the php files inside your webhost (Make sure to have PHP installed).

Website Screenshot


Download


Revisions
(Last Update: 07/01/2013)
Revision 1 Completed - MySQL + Basic PHP Page is done
Revision 2 Completed - SQLite is done
Revision 3 Completed - Added /clearlog
First Official Release as r3 - Flatfile hasn't been started

[nor15]

1st comment , Nice work

[RedCrossER]

Good work

[[MM]18240[FMB]]

pawn Code:

C:\Users\Kalgon\Desktop\MySQL_END_Linux\pawno\include\YSI\y_iterate.inc(197) : fatal error 111: user error: "Old foreach.inc files are no longer compatible with YSI."


Compilation aborted.Pawn compiler 3.2.3664          Copyright (c) 1997-2006, ITB CompuPhase


1 Error.

My foreach is up to date.

[seanny]

Quote:

Originally Posted by [MM]18240[FMB] pawn Code: C:\Users\Kalgon\Desktop\MySQL_END_Linux\pawno\include\YSI\y_iterate.inc(197) : fatal error 111: user error: "Old foreach.inc files are no longer compatible with YSI." Compilation aborted.Pawn compiler 3.2.3664          Copyright (c) 1997-2006, ITB CompuPhase 1 Error. My foreach is up to date.

Try switching to Y_Iterate, is does the same job as foreach.