CMD:cban(playerid,params[])
{
if(PlayerInfo[playerid][Admin] < 2) return SendClientMessage(playerid,Vermelho,"Vocк nгo tem permissгo para isso");
if(isnull(params)) return SendClientMessage(playerid,Cinza,"use: /cban <nick>");
new query[1024],string[256];
format(query,sizeof(query),"SELECT * FROM bans WHERE nick = '%s'",nome(params[0]));
mysql_query(Mysql, query);
mysql_store_result();
if(mysql_num_rows() > 0)
{
mysql_fetch_field_row(query,string);
SendClientMessage(playerid,-1,"Bans encontrados:");
format(string,sizeof(string),"%s\n",string);
SendClientMessage(playerid,Amarelo,string);
return 1;
}
else
{
SendClientMessage(playerid,Vermelho,"Nenhum ban encontrado.");
}
return 1;
}
format(query,sizeof(query),"SELECT * FROM bans WHERE nick = '%s'",nome(params[0])); |
if(!sscanf(params, "u", player)) {new nome[24]; GetPlayerName(player, nome, 24); format(query,sizeof(query),"SELECT * FROM `bans` WHERE `nick` = '%s';", nome);}
CMD:pban(playerid,params[])
{
if(PlayerInfo[playerid][Admin] < 2) return SendClientMessage(playerid,Vermelho,"Vocк nгo tem permissгo para isso");
if(isnull(params)) return SendClientMessage(playerid,Cinza,"use: /pban <nick/ip>");
new query[1024],savingstring[256],string[1024];
format(query,sizeof(query),"SELECT * FROM bans WHERE nick LIKE '%%%s%%' or ip LIKE '%%%s%% LIMIT 10'",params, params);
mysql_query(Mysql, query);
mysql_store_result();
new
BannedBy,
BannedName,
BannedIP,
BannedReason,
BannedDay,
BannedMonth,
BannedYear,
BannedHour,
BannedMinute
;
if(mysql_num_rows() > 0)
{
SendClientMessage(playerid,-1,"Bans encontrados:");
mysql_fetch_field_row(savingstring, "admin"); BannedBy = strval(savingstring);
mysql_fetch_field_row(savingstring, "motivo"); BannedReason = strval(savingstring);
mysql_fetch_field_row(savingstring, "dia"); BannedDay = strval(savingstring);
mysql_fetch_field_row(savingstring, "mes"); BannedMonth = strval(savingstring);
mysql_fetch_field_row(savingstring, "ano"); BannedYear = strval(savingstring);
mysql_fetch_field_row(savingstring, "hora"); BannedHour = strval(savingstring);
mysql_fetch_field_row(savingstring, "minutos"); BannedMinute = strval(savingstring);
mysql_fetch_field_row(savingstring, "nick"); BannedName = strval(savingstring);
mysql_fetch_field_row(savingstring, "ip"); BannedIP = strval(savingstring);
format(string,sizeof(string),"Dia %02d/%02d/%d бs %02d/%02d %s Baniu %s(%s) por %s",
BannedDay,
BannedMonth,
BannedYear,
BannedHour,
BannedMinute,
BannedBy,
BannedName,
BannedIP,
BannedReason
);
SendClientMessage(playerid,Amarelo,string);
}
else
{
SendClientMessage(playerid,Vermelho,"Nenhum ban encontrado.");
}
mysql_free_result();
return 1;
}