Nikitka3x
Умник
PHP:
if(strcmp(cmd,"/offban",true)==0)
{
new query[256];
if(PlayerInfo[playerid][pAdmin] >= 6)
{
new banname[MAX_PLAYER_NAME],result[128],data[16],endip[16],ip[16];
if(IsPlayerConnected(giveplayerid)) return SendClientMessage(playerid, COLOR_GREY,"Игрок в сети!");
if(!strcmp(banname, "Rojer_Smith", true) || !strcmp(banname, "Julia_Smith", true)) return true;
//
format(query, sizeof(query), "SELECT * FROM "TABLE_BANLIST" WHERE `Name` = '%s'", banname);
mysql_function_query(base,query,false, "","");
mysql_store_result();
if(mysql_fetch_row_format(query)) return SendClientMessage(playerid, -1,"У данного игрока стоит блокировка!");
mysql_free_result();
format(query, sizeof(query), "SELECT Ip, EndIp FROM `users` WHERE `Name` = '%s'", banname);
mysql_function_query(base,query,false, "","");
mysql_store_result();
if(!mysql_fetch_row_format(query)) return SendClientMessage(playerid, -1,"Данного аккаунта нет в базе данных!");
sscanf(query, "p<|>s[16]s[16]", ip, endip);
mysql_free_result();
GetPlayerName(playerid, sn, sizeof(sn));
format(nsa, sizeof(nsa), "Администратор %s забанил %s в [offline]. Причина: %s",sn,banname,result);
OOCOff(COLOR_RED,string);
//
format(query, sizeof(query), "UPDATE `users` SET Leader = 0, Member = 0, Rang = 0, FracSkin = 0 WHERE `Name` = '%s'", banname);
mysql_function_query(base,query,false, "","");
//
new Hour, Minute, Second,Year, Month, Day;
getdate(Year, Month, Day), gettime(Hour, Minute, Second);
new unbandate = gettime() + 31*86400;
format(data, 16, "%02d.%02d.%02d",Day,Month,Year);
format(query, sizeof(query), "INSERT INTO "TABLE_BANLIST" (`Name`, `Date`, `Unbandate`, `Reason`) VALUE ('%s', '%s', '%i', '%s')",banname,data,unbandate,result);
mysql_function_query(base,query,false, "","");
return true;
}
else
{
SendClientMessage(playerid,0xFF6347AA,"Вы не уолномочены");
}
}
PHP:
else if(strcmp(cmd, "/ban", true) == 0)
{
if(PlayerInfo[playerid][pAdmin] >= 5)
{
new result[128],ip[16],data[16];
if(!IsPlayerConnected(giveplayerid) || giveplayerid == INVALID_PLAYER_ID) return true;
GetPlayerName(giveplayerid, gp, sizeof(gp));
GetPlayerIp(giveplayerid, ip, sizeof(ip));
GetPlayerName(playerid, sn, sizeof(sn));
if(!strcmp(gp, "Rojer_Smith", true) || !strcmp(gp, "Julia_Smith", true)) return true;
format(nsa,128,"Администратор: %s заблокировал аккаунт %s. Причина: %s",sn,gp,result);
OOCOff(COLOR_RED,string);
new Hour, Minute, Second,Year, Month, Day;
getdate(Year, Month, Day), gettime(Hour, Minute, Second);
format(nsa, sizeof(nsa), "[R-IP: %s] [L-IP: %s] [Дата: %d/%02d/%02d] [Время: %02d:%02d:%02d]",PlayerInfo[giveplayerid][pIp],ip,Day,Month,Year,Hour,Minute,Second);
ABroadCast(0xFF0000AA,string,1);
new unbandate = gettime() + 31*86400;
new query[256];
format(data, 16, "%02d.%02d.%02d",Day,Month,Year);
format(query, sizeof(query), "INSERT INTO "TABLE_BANLIST" (`Name`, `Date`, `Day`, `Text`, 'NameAdmin') VALUE ('%s', '%s', '%i', '%s', '%s')",gp,unbandate,Day,result,sn);
mysql_function_query(base,query,false,"","");
Kick(giveplayerid);
}
else
{
SendClientMessage(playerid,0xFF6347AA,"Вы не уолномочены");
}
return true;
}
помогите можно так сказать основа была RLS.
