[Foxz]

Quote:

CMD:unban(playerid, params[]) { LoginCheck(playerid); if(User[playerid][accountAdmin] >= 2) { new string[150], Account[24], DBResult:Result, Query[129], fIP[30] ; if(sscanf(params, "s[24]", Account)) return SendClientMessage(playerid, COLOR_RED, "USAGE: /unban [account name]"); format(Query, 129, "SELECT FROM `bans` WHERE `username` = '%s'", Account); Result = db_query(Database, Query); if(db_num_rows(Result)) { db_get_field_assoc(Result, "ip", fIP, 30); if(CheckBan(fIP)) { RemoveBan(fIP); } format(Query, 129, "DELETE FROM `bans` WHERE `username` = '%s'", Account); Result = db_query(Database, Query); db_free_result(Result); format(string, sizeof string, "[UNBANNED] "white"%s has been unbanned by an admin.", Account); SendPlayerMessage(COLOR_ORANGE, string); format(string, sizeof string, "[UNBANNED] "white"%s has been unbanned by %s.", Account, GetName(playerid)); SendAMessage(COLOR_ORANGE, string); format(string, sizeof string, "[UNBANNED] %s has been unbanned by %s.", Account, GetName(playerid)); Log("ban.txt", string); } else { db_free_result(Result); SendClientMessage(playerid, -1, "» "red"Player is not in the banned database."); return 1; } } else { SendClientMessage(playerid, -1, "» "red"You are not authorized to use this command."); } return 1; }

Quote:

CMD:ban(playerid, params[]) { LoginCheck(playerid); if(User[playerid][accountAdmin] >= 2) { new string[150], id, reason[128], when[128], ban_hr, ban_min, ban_sec, ban_month, ban_days, ban_years ; gettime(ban_hr, ban_min, ban_sec); getdate(ban_years, ban_month, ban_days); if(sscanf(params, "us[128]", id, reason)) return SendClientMessage(playerid, COLOR_RED, "USAGE: /ban [playerid] [reason]"); if(id == INVALID_PLAYER_ID) return SendClientMessage(playerid, -1, "» "red"Player not connected."); if(User[playerid][accountAdmin] < User[id][accountAdmin]) { SendClientMessage(playerid, -1, "» "red"You cannot use this command on high ranking admin."); format(string, sizeof(string), "[NOTIFY] "white"%s has attempted to banned you with the reason %s.", GetName(playerid), reason); SendClientMessage(id, COLOR_ORANGE, string); format(string, sizeof(string), "%s has attempted to banned %s but failed for %s", GetName(playerid), GetName(id), reason); Log("admin.txt", string); return 1; } format(when, 128, "%02d/%02d/%d %02d:%02d:%02d", ban_month, ban_days, ban_years, ban_hr, ban_min, ban_sec); format(sInfo[last_bperson], 256, "%s", GetName(id)); format(sInfo[last_bwho], 256, "%s", reason); savestatistics(); AddBan(User[id][accountIP], 1); BanAcc(id, GetName(playerid), reason); ShowBan(id, GetName(playerid), reason, when); format(string, sizeof(string), "[BANNED] "white"%s has been banned by an admin for "grey"%s"white".", GetName(id), reason); SendPlayerMessage(COLOR_RED, string); format(string, sizeof(string), "[BANNED] "white"%s has been banned by %s for "grey"%s"white".", GetName(id), GetName(playerid), reason); SendAMessage(COLOR_RED, string); format(string, sizeof(string), "[BANNED] %s has been banned by %s for %s.", GetName(id), GetName(playerid), reason); Log("ban.txt", string); KickDelay(id); } else { SendClientMessage(playerid, -1, "» "red"You are not authorized to use this command."); } return 1; }

why when i /unban error data base not found
help me pliss i ill give rep if u help meh