Huseyn
Компетентный
Здравствуйте P-I, у меня тут проблема с /offban , не банит игрока, не знаю в чем проблема..
Вот код:
у меня Стоит MYSQL- R-40
Вот код:
PHP:
CMD:offban(playerid, params[])
{
if(pInfo[playerid][pAdmin] < 4) return 1;
new playername[MAX_PLAYER_NAME],
countday,
reason[32],
string_1[128];
if(sscanf(params, "s[24]is[24]", playername, countday, reason))
return SendClientMessage(playerid, -1, !"Введите: /offban [ник игрока] [кол-во дней] [причина]");
if(!strcmp(playername, "Logan", true)) return 1;
if(GetPlayerID(playername) != INVALID_PLAYER_ID)
return SendClientMessage(playerid, -1, !"Игрок в сети, используйте команду /ban");
if(countday > 30 || countday < 1)
return SendClientMessage(playerid, -1, !"Количество дней от 1 до 30");
format(string_1, sizeof(string_1), "SELECT * FROM `accounts` WHERE `name`='%s'", playername);
mysql_tquery(mysql_connect_ID, string_1, "OnPlayerOffban", "isis", playerid, playername, countday, reason);
return 1;
}
PHP:
forward OnPlayerOffban(playerid, name[], day, reason[]);
public OnPlayerOffban(playerid, name[], day, reason[])
{
new rows,
string_1[128],
string[144],
data[15];
cache_get_row_count(rows);
if(rows)
{
format(string, sizeof(string), "Администратор %s забанил оффлайн игрока %s на %i дней. Причина: %s",pInfo[playerid][pName], name, day, reason);
SendClientMessageToAll(0xff5030AA, string);
new Hour,
Minute,
Second,
Year,
Month,
Day,
days,
months,
years;
getdate(Year, Month, Day), gettime(Hour, Minute, Second);
format(string, sizeof(string), "* IP: %s -- дата: %d/%02d/%02d -- время: %02d:%02d:%02d", Day, Month, Year, Hour, Minute, Second);
SendAdminMessage(string, 0xff5030AA);
getdate(years, months, days);
new unbandate = gettime() + day*86400;
format(data, sizeof(data), "%02d.%02d.%04d", days, months, years);
format(string_1, sizeof(string_1), "INSERT INTO bans (name, whobanned, ip, bandate, time, unbandate, reason) VALUES ('%s', '%s', '%s', '%s', '%d', '%d', '%s')", name, pInfo[playerid][pName], data, day, unbandate, reason);
mysql_tquery(mysql_connect_ID, string_1, "", "");
format(string_1, sizeof(string_1), "UPDATE `accounts` SET warn=0,member=0,leader=0,templeader=0,rank=0,job=0,spawn=0 WHERE name='%s'", name);
mysql_tquery(mysql_connect_ID, string_1, "", "");
}
else SendClientMessage(playerid, -1, "Игрок не найден");
return 1;
}
