06.01.2014, 23:03
Got a problem with this command too:
Doesn't matter if i do /unban Face9000 or /unban Test, it will always return "Usage: /isbanned <playername>"
Anything wrong here?
pawn Код:
CMD:unban(playerid,params[])
{
if(Logged[playerid] == 1)
{
if(PlayerInfo[playerid][Admin] >= 4)
{
new Query[200];
new playertounban[24];
if (!strlen(playertounban)) return SendClientMessage(playerid,-1,"{F70505}Usage: {FFFFFF}/unban <playername>");
format(Query, sizeof(Query), "SELECT `Username` FROM `Bans` WHERE Username = '%s' AND Banned = 1 LIMIT 1", playertounban);
mysql_query(Query);
mysql_store_result();
if(!mysql_num_rows())
{
new string[200];
format(string, sizeof(string), "%s was not found in the database. Probably is not banned or the account does not exist.", playertounban);
mysql_free_result();
return SendClientMessage(playerid,-1,string);
}
else if(mysql_num_rows() != 0)
{
new pName[24];
GetPlayerName(playerid,pName,128);
format(Query, sizeof(Query), "UPDATE `Bans` SET `Banned` = 0 WHERE Username = '%s'", playertounban);
mysql_query(Query);
mysql_store_result();
new string[200];
format(string, sizeof(string), "%s has been unbanned by %s (lvl %d) %s (%d)", playertounban, AdminLevelToName(playerid),PlayerInfo[playerid][Admin], pName, playerid);
SendClientMessageToAll(0x66FF33, string);
new echos[200];
format(echos,sizeof(echos),"1,8%s has been unbanned by %s (lvl %d) %s (%d)",playertounban, AdminLevelToName(playerid),PlayerInfo[playerid][Admin], pName, playerid);
IRC_GroupSay(gGroupID, IRC_ACHANNEL, echos);
}
}
}
return 1;
}
