04.01.2018, 20:41
Код:
[21:23:43 01/04/18] [DEBUG] mysql_format - connection: 3, len: 2500, format: "INSERT INTO `Reports` (`uID`, `vID`, `Reason`, `Time`, `Status`) VALUES(%d, %d, '%s', %d, '0')" [21:23:43 01/04/18] [DEBUG] mysql_tquery - connection: 3, query: "INSERT INTO `Reports` (`uID`, `vID`, `Reason`, `Time`, `Status`)", callback: "SendReportDB", format: "iis[200]" [21:23:43 01/04/18] [ERROR] mysql_tquery - callback parameter count does not match format specifier length (Query: "INSERT INTO `Reports` (`uID`, `vID`, `Reason`, `Time`, `Status`) VALUES(1258, 1, 'd', 1515101023, '0')")
Код:
CMD:report(playerid, params[]) { new pid, info[200], query[2500]; if(Account[playerid][reportMuted] == 1) return SendClientMessage(playerid, COLOR_GREY, "{1E90FF}(Server):{dadada} You have been report muted!"); if(sscanf(params, "us[200]", pid, info)) return SendClientMessage(playerid, COLOR_GRAY, "{1E90FF}(Server):{dadada} /report [playerid] [reason]"); if(playerid == pid) return SendClientMessage(playerid, COLOR_GREY, "{1E90FF}(Server):{dadada} You cannot report yourself!"); if(!IsPlayerConnected(pid)) return SendClientMessage(playerid, COLOR_GREY, "{1E90FF}(Server):{dadada} This player is not conneted therefor you cannot report them!"); if(Account[playerid][lastReport] == pid) return SendClientMessage(playerid, COLOR_GREY, "{1E90FF}(Server):{dadada} You must use /cancelreport [playerid] before making a new report on this player!"); Account[playerid][lastReport] = pid; mysql_format(SQL_CONNECTION, query, sizeof(query), "INSERT INTO `Reports` (`uID`, `vID`, `Reason`, `Time`, `Status`) VALUES(%d, %d, '%s', %d, '0')", Account[playerid][SQLID], Account[pid][SQLID], info, gettime()); mysql_tquery(SQL_CONNECTION, query, "SendReportDB", "iis[190]", playerid, pid, info); return true; }
Код:
forward SendReportDB(playerid, pid, info); public SendReportDB(playerid, pid, info) { new ReportSQLID, str[2000], str1[2000]; ReportSQLID = cache_insert_id(); format(str, sizeof(str), "(#%d) Report from: [%s] | Report on: [%s] | Reason:[%s]", ReportSQLID, GetName(playerid), GetName(pid), info); SendReportMessage(1, COLOR_LIGHTRED, str); format(str1, sizeof(str1), "{1E90FF}|-{dadada} [ID - #%d] Report has been sent to all online staff! Please wait for a response. /myreports {1E90FF}-|", ReportSQLID); SendClientMessage(playerid, COLOR_GREY, str1); return true; }