PHP код:
CMD:ban(playerid, params[])
{
new string[128], data[16], unbandate, year, month, day;
if(PlayerInfo[playerid][pLogged] == 0) return true;
if(PlayerInfo[playerid][pAdmin] < 3) return true;
if(sscanf(params, "uds[128]", params[0], params[1], params[2])) return SendClientMessage(playerid, COLOR_GRAD, "Используйте: /ban [id игрока] [Дней] [причина]");
if(params[1] > 30 || params[1] < 1) return SendClientMessage(playerid, COLOR_GRAD, "Время бана от 1 до 30 дней");
format(string, sizeof(string), "Администратор %s забанил игрока %s на %d дней. Причина: %s",PlayerInfo[playerid][pName],PlayerInfo[params[0]][pName],params[1],params[2]);
SendClientMessageToAll(COLOR_LIGHTRED, string);
getdate(year, month, day);
format(data, 16, "%02d.%02d.%04d", day, month, year);
unbandate = gettime() + params[1]*86400;
format(mysql_string, sizeof(mysql_string), "INSERT INTO `"TABLE_BANS"` (Name_Admin, Name_Player, Lvl_Admin, Ban_Data, Unban_Data, Ban_Reason) VALUES ('%s', '%s','%d', '%d', %d, '%s')", PlayerInfo[playerid][pName], PlayerInfo[params[0]][pName], PlayerInfo[playerid][pAdmin], data, unbandate, params[2]);
mysql_function_query(connect_to_mysql, mysql_string, false, "", "");
return true;
}
В таблице тип varchar(32)