[FilterScript] [MySQL] Report system [View all reports ; Delete reports & more]

[FilterScript] [MySQL] Report system [View all reports ; Delete reports & more] - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Filterscripts (https://sampforum.blast.hk/forumdisplay.php?fid=17)
+--- Thread: [FilterScript] [MySQL] Report system [View all reports ; Delete reports & more] (/showthread.php?tid=631555)

[MySQL] Report system [View all reports ; Delete reports & more] - AjaxM - 31.03.2017

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.

Re: [MySQL] Report system [View all reports ; Delete reports & more] - Roozevelt - 31.03.2017

Wemm done , adding Reward system will make it better

Re: [MySQL] Report system [View all reports ; Delete reports & more] - AjaxM - 31.03.2017

Quote:

Originally Posted by ItzzWesty

Wemm done , adding Reward system will make it better

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

Re: [MySQL] Report system [View all reports ; Delete reports & more] - Bolex_ - 31.03.2017

I like it just because this is MYSQL version! GJ

Re: [MySQL] Report system [View all reports ; Delete reports & more] - AjaxM - 31.03.2017

Quote:

Originally Posted by Bolex_

I like it just because this is MYSQL version! GJ

Thank you.

Re: [MySQL] Report system [View all reports ; Delete reports & more] - jasperschellekens - 14.12.2017

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?

Re: [MySQL] Report system [View all reports ; Delete reports & more] - Logic_ - 14.12.2017

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

Re: [MySQL] Report system [View all reports ; Delete reports & more] - jasperschellekens - 14.12.2017

Quote:

Originally Posted by Logic_

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

thanks

Re: [MySQL] Report system [View all reports ; Delete reports & more] - DonaldDuck - 14.12.2017

Nice keep it up.