[FilterScript] [MYSQL R41-2] Ban / Unban System
#25

their is problem with ban cmd
it wont work till you replace this with it
Код:
CMD:ban(playerid, params[])
{
    if(pInfo[playerid][pAdminLevel] < 4) return 0;
	new PlayerIP[17];
	new giveplayerid, reason[128], string[150], query[700];
	GetPlayerIp(giveplayerid, PlayerIP, sizeof(PlayerIP));
	if(sscanf(params, "us[128]", giveplayerid, reason)) return Usage(playerid, "/ban [playerid] [reason]"); 
	if(!IsPlayerConnected(giveplayerid)) return SendClientMessage(playerid, -1, "That player is not connected");
	mysql_format(BansDB, query, sizeof(query), "INSERT INTO `bans` (`Username`, `BannedBy`, `BanReason`, `IpAddress`, `Date`) VALUES ('%e', '%e', '%e', '%e'), '%e'", playername(giveplayerid), playername(playerid), reason, PlayerIP, ReturnDate());
	mysql_tquery(BansDB, query, "", "");
	format(string, sizeof(string), "SERVER: %s[%d] was banned by %s, Reason: %s", playername(giveplayerid), giveplayerid, playername(playerid), reason);
	SendClientMessageToAll(-1, string);
	pkickbantimer[playerid] = SetTimerEx("KickBanTimer", 1000, 0, "dd", giveplayerid, 2);
	return 1;
}
Код:
CMD:ban(playerid, params[])
{
    if(pInfo[playerid][pAdminLevel] < 4) return 0;
	new PlayerIP[17];
	new giveplayerid, reason[128], string[150], query[700];
	GetPlayerIp(giveplayerid, PlayerIP, sizeof(PlayerIP));
	if(sscanf(params, "us[128]", giveplayerid, reason)) return Usage(playerid, "/ban [playerid] [reason]"); 
	if(!IsPlayerConnected(giveplayerid)) return SendClientMessage(playerid, -1, "That player is not connected");
	mysql_format(BansDB, query, sizeof(query), "INSERT INTO `bans` (`Username`, `BannedBy`, `BanReason`, `IpAddress`, `Date`) VALUES ('%e', '%e', '%e', '%e', '%e')", playername(giveplayerid), playername(playerid), reason, PlayerIP, ReturnDate());
	mysql_tquery(BansDB, query, "", "");
	format(string, sizeof(string), "SERVER: %s[%d] was banned by %s, Reason: %s", playername(giveplayerid), giveplayerid, playername(playerid), reason);
	SendClientMessageToAll(-1, string);
	pkickbantimer[playerid] = SetTimerEx("KickBanTimer", 1000, 0, "dd", giveplayerid, 2);
	return 1;
}
their is problem with your bracket here too
Reply


Messages In This Thread
[MYSQL R41-4] Ban / Unban System - by solstice_ - 03.09.2018, 00:33
Re: [MYSQL R41-2] Ban / Unban System - by solstice_ - 03.09.2018, 03:32
Re: [MYSQL R41-2] Ban / Unban System - by ZJK - 03.09.2018, 05:30
Re: [MYSQL R41-2] Ban / Unban System - by ZigGamerx - 03.09.2018, 06:30
Re: [MYSQL R41-2] Ban / Unban System - by OPcode - 03.09.2018, 06:33
Re: [MYSQL R41-2] Ban / Unban System - by solstice_ - 03.09.2018, 07:08
Re: [MYSQL R41-2] Ban / Unban System - by solstice_ - 03.09.2018, 20:49
Re: [MYSQL R41-2] Ban / Unban System - by solstice_ - 04.09.2018, 12:29
Re: [MYSQL R41-2] Ban / Unban System - by KinderClans - 04.09.2018, 13:01
Re: [MYSQL R41-2] Ban / Unban System - by solstice_ - 04.09.2018, 13:08
Re: [MYSQL R41-2] Ban / Unban System - by KinderClans - 04.09.2018, 13:17
Re: [MYSQL R41-2] Ban / Unban System - by solstice_ - 04.09.2018, 13:20
Re: [MYSQL R41-2] Ban / Unban System - by Banditul18 - 04.09.2018, 13:37
Re: [MYSQL R41-2] Ban / Unban System - by solstice_ - 04.09.2018, 13:49
Re: [MYSQL R41-2] Ban / Unban System - by KinderClans - 04.09.2018, 13:50
Re: [MYSQL R41-2] Ban / Unban System - by solstice_ - 04.09.2018, 13:55
Re: [MYSQL R41-2] Ban / Unban System - by KinderClans - 04.09.2018, 13:58
Re: [MYSQL R41-2] Ban / Unban System - by solstice_ - 04.09.2018, 14:00
Re: [MYSQL R41-2] Ban / Unban System - by SonnyGamer - 04.09.2018, 15:55
Re: [MYSQL R41-2] Ban / Unban System - by brauf - 04.09.2018, 16:53
Re: [MYSQL R41-2] Ban / Unban System - by TheToretto - 04.09.2018, 17:13
Re: [MYSQL R41-2] Ban / Unban System - by KinderClans - 04.09.2018, 19:31
Re: [MYSQL R41-2] Ban / Unban System - by solstice_ - 04.09.2018, 22:09
Re: [MYSQL R41-2] Ban / Unban System - by CaptainBoi - 05.09.2018, 09:58
Re: [MYSQL R41-2] Ban / Unban System - by CaptainBoi - 05.09.2018, 11:16
Re: [MYSQL R41-2] Ban / Unban System - by solstice_ - 05.09.2018, 13:04
Re: [MYSQL R41-2] Ban / Unban System - by CaptainBoi - 05.09.2018, 13:31
Re: [MYSQL R41-2] Ban / Unban System - by solstice_ - 05.09.2018, 13:33
Re: [MYSQL R41-2] Ban / Unban System - by AlfaSufaIndo - 09.09.2018, 15:09
Re: [MYSQL R41-2] Ban / Unban System - by solstice_ - 09.09.2018, 19:13
Re: [MYSQL R41-2] Ban / Unban System - by solstice_ - 11.09.2018, 15:41
Re: [MYSQL R41-2] Ban / Unban System - by NoahF - 14.09.2018, 15:15
Re: [MYSQL R41-2] Ban / Unban System - by solstice_ - 14.09.2018, 19:53

Forum Jump:


Users browsing this thread: 1 Guest(s)