St1cker
Ученик
HTML:
stock GetBan(playerid)
{
new PlayerNick[MAX_PLAYER_NAME],str[255],unbandate,PlayerBan[32],reason[100],bandate[100];
GetPlayerName(playerid, PlayerNick, MAX_PLAYER_NAME);
mysql_format(1, str,sizeof(str), "SELECT * FROM `bans` WHERE `name` = '%s'", PlayerNick);
mysql_function_query(1, str, true, "", "");
if(mysql_num_rows()){
MYSQL_GetInt(4,unbandate);
MYSQL_GetString(2,bandate);
MYSQL_GetString(5,reason);
MYSQL_GetString(6,reason);
if(unbandate > gettime()){
ban[playerid]=1;
print("Cheked");
}
}
new string[300];
if(ban[playerid]==1){
format(string, 255, "Дата бана: %s\nДата разбана: %d\nЗабанил: %s\nПричина бана: %s\n",bandate,unbandate,PlayerBan,reason);
SPD(playerid,DIALOGUNBAN,0,"Вы забанены",string,"Выйти","");
print("Banned");
return Kick(playerid);
}else{
format(str, sizeof(str), "DELETE FROM `bans` WHERE `name` = '%s'", PlayerNick);
print("Delleted");
mysql_function_query(1,str,false,"","");
}
print("NOT CHECKED");
return true;
}
PHP:
CREATE TABLE IF NOT EXISTS `bans` (
`name` varchar(32) DEFAULT NULL,
`IP` varchar(32) DEFAULT NULL,
`bandate` varchar(32) DEFAULT NULL,
`time` int(11) NOT NULL,
`unbandate` int(11) NOT NULL,
`reason` varchar(100) NOT NULL,
`admin` varchar(32) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Последнее редактирование модератором:
