[AjaxM]

Report system
Version: v0.1
Last updated: N/A

Description

A normal report system but with many features

Features

• RCON logged in admins are able to view all the reports (/reports)
• All reports are saved in a MySQL Table
• Uses MySQL R39-6 by BlueG
• RCON logged in admins are able to delete reports (/delrep [report id])
• Readablilty
• Good performance
• RCON logged in admins are able to delete all reports at once (/delallrep)

Credits

AjaxM - The script
SA-MP Team - SA-MP
BlueG - MySQL
Yashas / Zeex - I-ZCMD
sscanf - Y_Less & Emmet_

Bugs

Tested ; No bugs found.

Please report bugs ASAP if founded.

Table Creation

You should manually create the table with the following code:

PHP Code:

CREATE TABLE `YOUR_PORT_HERE`.`Reports`(
    `ReportID` INT(15) NOT NULL AUTO_INCREMENT ,
    `Reporter` VARCHAR(25) NOT NULL ,
    `Reported` VARCHAR(25) NOT NULL ,
    `ReportedOn` VARCHAR(25) NOT NULL ,
    `ReportReason` VARCHAR(25) NOT NULL ,
    PRIMARY KEY  (`ReportID`))
    ENGINE = InnoDB; 


Note: You should change the 'YOUR_PORT_HERE' to your database port.

The report IDs may go up to 1000 ; If you want to reset it back to 0, delete the MySQL Table and re-create it.

Download

GITHUB

Thanks & enjoy.

[Roozevelt]

Wemm done , adding Reward system will make it better

[AjaxM]

Quote:

Originally Posted by ItzzWesty Wemm done , adding Reward system will make it better

Elaborate, please ; What did you mean by reward system?

[Bolex_]

I like it just because this is MYSQL version! GJ

[AjaxM]

Quote:

Originally Posted by Bolex_ I like it just because this is MYSQL version! GJ

Thank you.

[jasperschellekens]

I canґt add this to my database?

Code:

CREATE TABLE `3306`.`Reports`( 
    `ReportID` INT(15) NOT NULL AUTO_INCREMENT , 
    `Reporter` VARCHAR(25) NOT NULL , 
    `Reported` VARCHAR(25) NOT NULL , 
    `ReportedOn` VARCHAR(25) NOT NULL , 
    `ReportReason` VARCHAR(25) NOT NULL , 
    PRIMARY KEY  (`ReportID`)) 
    ENGINE = InnoDB;

I did try to create the table manually in phpmyadmin, but it can't connect?

[Logic_]

You shouldn't put your port, you should put your database name there.

[jasperschellekens]

Quote:

Originally Posted by Logic_ You shouldn't put your port, you should put your database name there.

thanks

[DonaldDuck]

Nice keep it up.