Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- YCMD:unban(playerid, params[], help) {
- if(PlayerInfo[playerid][pAdmin] >= 3) {
- new id[30],escape[30],str1[256],string[128],sendername[30],qstr[256];
- if(sscanf(params, "s[30]", id)) return SendClientMessage(playerid, 0xB8DBFFFF, "Usage: {FFFFFF}/unban [name]");
- mysql_real_escape_string(id, escape);
- format(qstr,sizeof(qstr),"SELECT * FROM bans WHERE `PlayerName`='%s' AND `Active`='1'",escape);
- new Cache: banuri = mysql_query(SQL,qstr);
- if(cache_get_row_count() > 0)
- {
- GetPlayerName(playerid, sendername, sizeof(sendername));
- format(string,sizeof(string),"AdmCmd: %s has unbanned user %s.",sendername,escape);
- SendAdminMessage(0xDBA458FF, string,1);
- mysql_format(SQL,str1,sizeof(str1),"UPDATE bans SET `Active`='0' WHERE `PlayerName`='%s'",escape);
- mysql_tquery(SQL,str1,"","");
- }
- else SendClientMessage(playerid, -1, "Invalid player.");
- cache_delete(banuri);
- }
- return 1;
- }
- YCMD:unbanip(playerid, params[], help) {
- if(PlayerInfo[playerid][pAdmin] >= 5) {
- new ip[16],escape[16],str1[256],string[256],sendername[30],qstr[256];
- if(sscanf(params, "s[16]", ip)) return SendClientMessage(playerid, 0xB8DBFFFF, "Usage: {FFFFFF}/unbanip [ip]");
- mysql_real_escape_string(ip, escape);
- format(qstr,sizeof(qstr),"SELECT * FROM bans WHERE `IP`='%s' AND `Active`='1'",escape);
- new Cache: banuri = mysql_query(SQL,qstr);
- if(cache_get_row_count() > 0)
- {
- GetPlayerName(playerid, sendername, sizeof(sendername));
- format(string,sizeof(string),"AdmCmd: %s has unbanned IP %s.",sendername,escape);
- SendAdminMessage(0xDBA458FF, string,1);
- mysql_format(SQL,str1,sizeof(str1),"UPDATE bans SET `Active`='0' WHERE `IP`='%s'",escape);
- mysql_tquery(SQL,str1,"","");
- }
- else SendClientMessage(playerid, COLOR_LIGHTRED, "This IP is not banned.");
- cache_delete(banuri);
- }
- return 1;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement