[Release] Report System

[Mohamed Boubekri]

Hello, Many People Say Me, Give Me Link of Any Report Sys, i Don't Find It.
So Now I'm Make It With My Self.

First of All Add it in Your ( OnSriptLoad )

Code Select Expand

rp <- ConnectSQL("scripts/report.db");
QuerySQL(rp, "create table if not exists report ( Plr TEXT, Name TEXT, Reason TEXT, Day VARCHAR(25), Month VARCHAR(25), Year VARCHAR(25), Hour VARCHAR(25), Min VARCHAR(25) )");Now Add it In Your Function ( command )

Code Select Expand

else if ( cmd == "report" )
{
if(!text) MessagePlayer("/report <Player> <Reason>",player);
//Here if You Like Make if player Not Registered
//Here if You Like Make if player Not Logged in
else {
local plr = GetPlayer( GetTok( text, " ", 1 ) );
if ( !plr ) MessagePlayer( "Unknow Player.", player );
{
local reason = GetTok( text, " ", 2 NumTok( text, " " ) );
if ( !reason ) MessagePlayer( "Make Reason.", player );
else if ( plr.Name==player.Name ) MessagePlayer( "You Can't Report yourself.", player );
else {
local now = date();
QuerySQL( rp, "INSERT INTO report ( Plr, Name, Reason, Day, Month, Year, Hour, Min ) VALUES ( '" + plr.Name + "', '" + player.Name + "', '" + reason + "', '" + now.day + "/', '" + now.month + "/', '" + now.year + "/', '" + now.hour + ":', '" + now.min + "' )" );
MessagePlayer("Report Successfully Inserted To DataBase",player);
Message("Player "+player.Name+" Has Report " +plr.Name+ " Reason: "+reason+"");
}
}
}
}NOTE: if You Want check who report & reason & time, Just Open The DataBase of The Report System.
NOTE: Thi its Just Sample System. Good Luck.

[pro]

Good job.
I'd suggest to add more information about "plr" IP/UID/Position/Vehicle and time()
Position/Vehicle may be useful in case of "fly-hack"/"abusing-map-bugs" reports.

[Mohamed Boubekri]

Hmmmm You Are Right, Will Add Time() Soon.
Thank

[Retard]

Good work bro

[Mohamed Boubekri]

Updated. Time Added.

[MEGAMIND]

Good work bro

ahm ahm

[Mohamed Boubekri]

Good work bro

ahm ahm

What

[Retard]

An Extra cmd

Code Select Expand

else if ( cmd == "reportlist" )
{
local query = QuerySQL( rp, "SELECT * FROM report" ), a=0;
if ( !query ) MessagePlayer(RED+"** >> No Players Are Reported.",player);
else {
while ( GetSQLColumnData( query, 0 ) != null )
{
MessagePlayer(RED+"** >> Player:[ "+GetSQLColumnData( query, 0 )+" ] Reported-Player:[ "+GetSQLColumnData( query, 1 )+" ] "+WHITE+"Reason:[ "+GetSQLColumnData( query, 2 )+" ].",player );
GetSQLNextRow( query );
a++;}
}
FreeSQLQuery( query );
}


[haxerx]

Good Work Man! I like your efforts instead of crying or begging for scripts

[Mohamed Boubekri]

Good Work Man! I like your efforts instead of crying or begging for scripts

Lol Thanks xD

[=RK=MarineForce]

bro its show only admins?

[=RK=MarineForce]

untested
else if ( cmd == "report" )
{
if(!text) MessagePlayer("/report <Player> <Reason>",player);
//Here if You Like Make if player Not Registered
//Here if You Like Make if player Not Logged in
else {
local plr = GetPlayer( GetTok( text, " ", 1 ) );
if ( !plr ) MessagePlayer( "Unknow Player.", player );
{
local reason = GetTok( text, " ", 2 NumTok( text, " " ) );
if ( !reason ) MessagePlayer( "Make Reason.", player );
else if ( plr.Name==player.Name ) MessagePlayer( "You Can't Report yourself.", player );
else {
local now = date();
QuerySQL( rp, "INSERT INTO report ( Plr, Name, Reason, Day, Month, Year, Hour, Min ) VALUES ( '" + plr.Name + "', '" + player.Name + "', '" + reason + "', '" + now.day + "/', '" + now.month + "/', '" + now.year + "/', '" + now.hour + ":', '" + now.min + "' )" );
MessagePlayer("Report Successfully Inserted To DataBase",player);
if ( status[ plr.ID ].Level > 2 )
MessagePlayer("Player "+player.Name+" Has Report " +plr.Name+ " Reason: "+reason+" ", plr);
}
}
}
}

[Mohamed Boubekri]

bro its show only admins?

Nah.

[Mohamed Boubekri]

untested
else if ( cmd == "report" )
{
if(!text) MessagePlayer("/report <Player> <Reason>",player);
//Here if You Like Make if player Not Registered
//Here if You Like Make if player Not Logged in
else {
local plr = GetPlayer( GetTok( text, " ", 1 ) );
if ( !plr ) MessagePlayer( "Unknow Player.", player );
{
local reason = GetTok( text, " ", 2 NumTok( text, " " ) );
if ( !reason ) MessagePlayer( "Make Reason.", player );
else if ( plr.Name==player.Name ) MessagePlayer( "You Can't Report yourself.", player );
else {
local now = date();
QuerySQL( rp, "INSERT INTO report ( Plr, Name, Reason, Day, Month, Year, Hour, Min ) VALUES ( '" + plr.Name + "', '" + player.Name + "', '" + reason + "', '" + now.day + "/', '" + now.month + "/', '" + now.year + "/', '" + now.hour + ":', '" + now.min + "' )" );
MessagePlayer("Report Successfully Inserted To DataBase",player);
if ( status[ plr.ID ].Level > 2 )
MessagePlayer("Player "+player.Name+" Has Report " +plr.Name+ " Reason: "+reason+" ", plr);
}
}
}
}

Thi its not warning system.
Player also can do it.

[=RK=MarineForce]

Nah,

i mean its send message Only Admins not players

look like : Player--- is Report plr Reason Hp hacked

if ( status[ plr.ID ].Level > 2 )
MessagePlayer("Player "+player.Name+" Has Report " +plr.Name+ " Reason: "+reason+" ", plr);