PHP код:
CMD:unban(playerid, params[])
{
if(PlayerInfo[playerid][pAdmin] < 3) return true;
if(sscanf(params, "s[128]s[128]", params[0], params[1])) return SendClientMessage(playerid,COLOR_GREY228,"Используйте: /unban [Имя игрока][Причина разбана]");
printf("\nunban: \"%s\" | \"%s\"", params[0], params[1]);
new mysql_strinjik[41+MAX_PLAYER_NAME];
format(mysql_strinjik, sizeof(mysql_strinjik), "SELECT * FROM `BanIP` WHERE `Name` = '%s'", params[0]);
mysql_function_query(MYSQL_ARG, mysql_strinjik, true, "UnBan", "dss", playerid, params[0], params[1]);
return true;
}
forward UnBan(playerid, UnbanNick[], reason[]);
public UnBan(playerid, UnbanNick[], reason[])
{
printf("\nUnBan: \"%s\" | \"%s\"", UnbanNick, reason);
new rows,
fields,
mysql_string228[81+(MAX_PLAYER_NAME*2)+128];
cache_get_data(rows, fields);
if(!rows)
{
format(mysql_string228, sizeof(mysql_string228), "[ MySql ] Аккаунт %s не найден в базе данных.",UnbanNick);
return SendClientMessage(playerid, COLOR_GREY, mysql_string228);
}
format(mysql_string228, sizeof(mysql_string228), "DELETE FROM `BanIP` WHERE `Name` = '%s'", UnbanNick);
mysql_function_query(MYSQL_ARG, mysql_string228, false, "", "");
format(mysql_string228, sizeof(mysql_string228), "[ MySql ] Аккаунт %s успешно разбанен",UnbanNick);
SendClientMessage(playerid, COLOR_GREY, mysql_string228);
format(mysql_string228, sizeof(mysql_string228), "[UNBAN] {FFFFFF}Администратор {FF6347}%s {FFFFFF}разбанил {FF6347}%s. Причина: %s", PlayerInfo[playerid][pName], UnbanNick, reason);
SendAdminMessage(COLOR_ADMCHAT, mysql_string228);
return true;
}