[Zeus666]

, so, when I type /re something to report

It saves in mysql but it doesn't show that I sent the report / it doesn't show for admins that report was received.

Also I can spam with /re

Errors mentioned above applies for /report too

PHP код:

forward OnPlayerReport(playerid, targetid, reason);
public OnPlayerReport(playerid, targetid, reason)
{
    new rows, fields;
    cache_get_data(rows, fields, handle);
    new  reportid;
    new count = cache_num_rows();
    if(count > 0)
    {
        new reportstring[250],reportstring2[250];
           reportid = cache_get_field_content_int(0, "ID", handle);
        format(reportstring2,sizeof(reportstring2), ""chat""COL_YELLOW"[REF:#%d]: Your report upon %s(%d) has been sent "COL_WHITE" (Reason: %s)",reportid, PlayerName(targetid),targetid, reason);
        SendClientMessage(playerid,-1,reportstring2);
        format(reportstring,sizeof(reportstring), ""chat""COL_YELLOW"[REF:#%d]: Player %s(ID:%d) has reported %s(ID:%d)"COL_WHITE" (Reason: %s)",reportid, PlayerName(playerid),playerid,PlayerName(targetid),targetid,reason);
        SendMessageToAllAdmins(reportstring,-1);
          pInfo[playerid][pReported] = 1;
          timeras[playerid] = SetTimerEx("Report", 60000, 0, "i", playerid);
    }
}
forward OnPlayerReporte(playerid, reason);
public OnPlayerReporte(playerid, reason)
{
    new rows, fields;
    cache_get_data(rows, fields, handle);
    new  reportid;
    new count = cache_num_rows();
    if(count > 0)
    {
        new reportstring[250],reportstring2[250];
           reportid = cache_get_field_content_int(0, "ID", handle);
        format(reportstring2,sizeof(reportstring2), ""chat""COL_YELLOW"[REF:#%d]: Your report was sent. "COL_WHITE" Title: [%s].",reportid, reason);
        SendClientMessage(playerid,-1,reportstring2);
        format(reportstring,sizeof(reportstring), ""chat""COL_YELLOW"[REF:#%d]: Player %s(ID:%d) has reported an error. "COL_WHITE" (Title: %s)",reportid, PlayerName(playerid),playerid,reason);
        SendMessageToAllAdmins(reportstring,-1);
          pInfo[playerid][pReported] = 1;
          timeras[playerid] = SetTimerEx("Report", 60000, 0, "i", playerid);
    }
} 


PHP код:

CMD:report(playerid,params[])
{
    new targetid,reason[250];
    if(sscanf(params, "us[105]", targetid,reason)) return SendClientMessage(playerid,-1,""chat" /report [playerid] [Reason]");
    if(!IsPlayerConnected(targetid)) return SendClientMessage(playerid,-1,""COL_RED"Not online");
     if(targetid == playerid) return SendClientMessage(playerid,-1, ""COL_RED"EROARE:  Can report yourself.");
    if(!IsPlayerNPC(targetid))
    {
        if(pInfo[playerid][pReported] == 0)
        {
            format(jQuery, MAX_QUERY_LENGTH, "INSERT INTO `"#reportlog"` (Username, Targetname, Report, Data) VALUES ('%s', '%s', '%s', CURRENT_TIMESTAMP)",PlayerName(playerid),PlayerName(targetid), reason);
            mysql_tquery(handle, jQuery, "", "");
            mysql_tquery(handle, "SELECT * FROM `reportlog` ORDER BY ID DESC LIMIT 1", "OnPlayerReport", "uus[80]", playerid, targetid, reason);
        }
        else {
            SendClientMessage(playerid,-1,""COL_RED"Wait 1 minute");
        }
    }
    else return SendClientMessage(playerid,-1,""COL_RED"can't report npc !");
    return 1;
}
CMD:re(playerid,params[])
{
        new reason[250];
        if(sscanf(params, "s[80]",reason)) return SendClientMessage(playerid,-1,""chat" /(re)port [Reason]");
        if(pInfo[playerid][pReported] == 0)
        {
            format(jQuery, MAX_QUERY_LENGTH, "INSERT INTO `"#reportlog"` (Username, Report, Data) VALUES ('%s', '%s', CURRENT_TIMESTAMP)",PlayerName(playerid), reason);
            mysql_tquery(handle, jQuery, "", "");
            mysql_tquery(handle, "SELECT * FROM `reportlog` ORDER BY ID DESC LIMIT 1", "OnPlayerReporte", "s[80]", playerid, reason);
        }
        else {
            SendClientMessage(playerid,-1,""COL_RED"Wait one minute");
        }
        return 1;
}