Cmd:unban error - Printable Version

Cmd:unban error - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Cmd:unban error (/showthread.php?tid=556343)

Cmd:unban error - Foxz - 10.01.2015

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