SA-MP Forums Archive
unban cmd - 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: unban cmd (/showthread.php?tid=623930)


unban cmd - Cerealguy - 08.12.2016

PHP код:
CMD:unban(playerid, params[])
{
    if(pInfo[playerid][AdminLevel] >= 5 || IsPlayerAdmin(playerid))
    {
        new Query[128], targetid[MAX_PLAYER_NAME];
        if(sscanf(params, "s[24]", targetid)) return SendClientMessage(playerid, COLOR_SEXYGREEN, "Usage:"COL_WHITE"/unban [NAME]");
        format(Query, sizeof(Query), "SELECT * FROM Bans WHERE Name = '%q' COLLATE NOCASE", targetid);
        queryresult = db_query(Database, Query);
        if(db_num_rows(queryresult))
        {
            format(Query, sizeof(Query), "DELETE FROM `Bans` WHERE `Name` = '%q'", targetid);
            db_free_result(db_query(Database, Query));
            format(Query, sizeof(Query), "[ADMIN]"COL_WHITE" You have un-banned %s", targetid);
            SendClientMessage(playerid, COLOR_ADMIN, Query);
            format(Query, sizeof(Query), "[LOG] %s have un-banned %s", GetPlayerName(playerid), targetid);
            SendAdminLog(Query);
        }
        else
        {
             SendClientMessage(playerid, COLOR_ERROR, "[ERROR]"COL_WHITE" User not found in the database.");
        }
        db_free_result(queryresult);
    }
    else return ErrorMessages(playerid, 3);
    return 1;
} 
Even though the player is banned, it always comes out that the player is not found.

Re: unban cmd - vikoo - 08.12.2016

Try This
Код:
CMD:nameban(playerid,params[])
{
    if(PlayerInfo[playerid][Level] >= 13 || IsPlayerAdmin(playerid))
 {
		new tmp[256], Index;        tmp = strtok(params,Index);
		if(isnull(params)) return SendClientMessage(playerid, red, "USAGE: /nameban [name] ");
		new adminname[MAX_PLAYER_NAME], string[128], banname[256];
		banname = tmp;
		if(udb_Exists(banname))

		{
			dUserSetINT(banname).("Banned", 1);
			GetPlayerName(playerid, adminname, sizeof(adminname));
			CMDMessageToAdmins(playerid,"NAMEBAN");
			SaveToFile("BanNameLog",string);
			print(string);
			return 1;
    	}
	    else return SendClientMessage(playerid, red, "ERROR: No player with this name.");
	}
    else return SendClientMessage(playerid,red,"ERROR: You Need To Be A High Level Admin To Use This Command");
}

CMD:nameunban(playerid,params[])
{
	if(PlayerInfo[playerid][Level] >= 13 || IsPlayerAdmin(playerid))
	{
		new tmp[256], Index;        tmp = strtok(params,Index);
		if(isnull(params)) return SendClientMessage(playerid, red, "USAGE: /unnameban [name] ");
		new adminname[MAX_PLAYER_NAME], string[128], unbanname[256];
		unbanname = tmp;
		if(udb_Exists(unbanname))
		{
			dUserSetINT(unbanname).("Banned", 0);
			GetPlayerName(playerid, adminname, sizeof(adminname));
			CMDMessageToAdmins(playerid,"NAMEUNBAN");
			SaveToFile("UnBanNameLog",string);
			print(string);
			return 1;
    	}
	    else return SendClientMessage(playerid, red, "ERROR: No player with this name.");
	}
    else return SendClientMessage(playerid,red,"ERROR: You Need To Be A High Level Admin To Use This Command");
}


Re: unban cmd - itsCody - 08.12.2016

Quote:
Originally Posted by vikoo
Посмотреть сообщение
Try This
Код:
CMD:nameban(playerid,params[])
{
    if(PlayerInfo[playerid][Level] >= 13 || IsPlayerAdmin(playerid))
 {
		new tmp[256], Index;        tmp = strtok(params,Index);
		if(isnull(params)) return SendClientMessage(playerid, red, "USAGE: /nameban [name] ");
		new adminname[MAX_PLAYER_NAME], string[128], banname[256];
		banname = tmp;
		if(udb_Exists(banname))

		{
			dUserSetINT(banname).("Banned", 1);
			GetPlayerName(playerid, adminname, sizeof(adminname));
			CMDMessageToAdmins(playerid,"NAMEBAN");
			SaveToFile("BanNameLog",string);
			print(string);
			return 1;
    	}
	    else return SendClientMessage(playerid, red, "ERROR: No player with this name.");
	}
    else return SendClientMessage(playerid,red,"ERROR: You Need To Be A High Level Admin To Use This Command");
}

CMD:nameunban(playerid,params[])
{
	if(PlayerInfo[playerid][Level] >= 13 || IsPlayerAdmin(playerid))
	{
		new tmp[256], Index;        tmp = strtok(params,Index);
		if(isnull(params)) return SendClientMessage(playerid, red, "USAGE: /unnameban [name] ");
		new adminname[MAX_PLAYER_NAME], string[128], unbanname[256];
		unbanname = tmp;
		if(udb_Exists(unbanname))
		{
			dUserSetINT(unbanname).("Banned", 0);
			GetPlayerName(playerid, adminname, sizeof(adminname));
			CMDMessageToAdmins(playerid,"NAMEUNBAN");
			SaveToFile("UnBanNameLog",string);
			print(string);
			return 1;
    	}
	    else return SendClientMessage(playerid, red, "ERROR: No player with this name.");
	}
    else return SendClientMessage(playerid,red,"ERROR: You Need To Be A High Level Admin To Use This Command");
}
No.

This looks like a copy and paste command

+ He's using MySQL, not an outdated system.

Re: unban cmd - GangstaaSunny - 08.12.2016

You are selecting more than 1 information from the table.

Change this
PHP код:
format(Query, sizeof(Query), "SELECT * FROM Bans WHERE Name = '%q' COLLATE NOCASE", targetid); 
to this
PHP код:
format(Query, sizeof(Query), "SELECT Name FROM Bans WHERE Name = '%q' COLLATE NOCASE", targetid); 
Also check your mysql_log and see what is loading and what is not loading.

Respuesta: Re: unban cmd - Cerealguy - 08.12.2016

Quote:
Originally Posted by GangstaaSunny
Посмотреть сообщение
You are selecting more than 1 information from the table.

Change this
PHP код:
format(Query, sizeof(Query), "SELECT * FROM Bans WHERE Name = '%q' COLLATE NOCASE", targetid); 
to this
PHP код:
format(Query, sizeof(Query), "SELECT Name FROM Bans WHERE Name = '%q' COLLATE NOCASE", targetid); 
Also check your mysql_log and see what is loading and what is not loading.
thanks bro!

Re: unban cmd - oMa37 - 08.12.2016

Quote:
Originally Posted by itsCody
Посмотреть сообщение
He's using MySQL, not an outdated system.
He is using SQLite.