ocmd:checkban(playerid, params[])
{
// if(!IsPlayerAdmin(playerid)) return 0;
if(IsNull(params)) return SendClientMessage(playerid, USAGE,"Usage: /checkban [Name]");
new str[128];
mysql_format(handle, str, sizeof(str), "SELECT * FROM Banned WHERE BannedUser = '%e'",params);
mysql_tquery(handle, str, "CheckBans", "i", playerid);
return 1;
}
forward CheckBans(playerid);
public CheckBans(playerid)
{
new count = cache_num_rows();
if(!count) return SendClientMessage(playerid, RED, "There are currently no Bans!");
SendClientMessage(playerid, USAGE, "Banlist:");
new BanAdmin[25], BannedUser[25], BanID, BannedOn[25], BannedWhy[25],BanDuration[25], shosbans[145];
for(new i; i < count; i++)
{
cache_get_value_name_int(0, "BanID", BanID);
cache_get_value_name(0, "BanAdmin", BanAdmin);
cache_get_value_name(0, "BannedUser", BannedUser);
cache_get_value_name(0, "BannedOn", BannedOn);
cache_get_value_name(0, "BannedWhy", BannedWhy);
cache_get_value_name(0, "BanDuration", BanDuration);
format(shosbans, sizeof(shosbans), "[#%d] (%s) %s has banned %s, for: %s! [Reason: %s]", BanID, BannedOn, BanAdmin, BannedUser, BanDuration,BannedWhy);
SendClientMessage(playerid, COOLRED, shosbans);
}
}
Alles anzeigen