EZLIX
Ученик
Приветствую, проблема такая, захотел сделать логи для администрации и в mysql_log вылетает ошибка, код ниже.
Ошибка
Код:
stock WriteLogAdmins(playerid, whom, action[], reason[])
{
new year, month, day, hour, minuite, second, time[50], write[500];
getdate(year,month,day);
gettime(hour,minuite,second);
format(time, sizeof(time), "%i-%i-%i %i:%i:%i", day, month, year, hour, minuite, second);
format(write, sizeof(write), "INSERT INTO `logs_admins` (`date`, `who`, `whom, `action`, `reason`) VALUES ('%s', '%s', '%s', '%s', '%s')", time, PN(playerid), PN(whom), action, reason);
mysql_tquery(mysql, write);
}
CMD:writelog(playerid, params[]) /* Для теста */
{
if(sscanf(params, "is[41]", params[0], params[1], params[2])) return SendClientMessage(playerid, COLOR_YELLOW,"[Подсказка]{ffffff} /writelog [ID] [action], [reason]");
WriteLogAdmins(playerid, params[0], params[1], params[2]);
return 1;
}
Код:
[14:30:24 09/23/21] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'action`, `reason`) VALUES ('23-9-2021 14:30:24', 'Elesey_Morozov', 'Elesey_Moroz' at line 1 (Query: "INSERT INTO `logs_admins` (`date`, `who`, `whom, `action`, `reason`
