[Cerealguy]

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.

[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");
}

[itsCody]

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.

[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.

[Cerealguy]

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!

[oMa37]

Quote:

Originally Posted by itsCody He's using MySQL, not an outdated system.

He is using SQLite.