How i can ban offline player using mysql ? Help Plz
#1

Код:
CMD:banname(playerid, params[])
{
    if(pInfo[playerid][pLevel] >= 4)
	{
		new Name[25]  ;
		if(sscanf(params, "s[25]", Name)) return SCM(playerid, yellow, "SERVER : /Banname <Player Name>");
 		new query[128];
 		mysql_format(mysql, query, sizeof(query), "SELECT * FROM `players` WHERE `Username` = '%e' LIMIT 1", Name);
		mysql_tquery(mysql, query, "OnBanName", "is",playerid ,Name);
		return 1;
	}
	else return ShowMessage(playerid, red, 1);
}

forward OnBanName(playerid,Name[] );
public OnBanName(playerid,Name[] )
{
			new query[128];
			mysql_format(mysql, query, sizeof(query),"UPDATE `players` SET `Ban`= '1' WHERE `Username`= '%e'",Name);
	 		mysql_tquery(mysql, query );
	        format(Jstring, sizeof(Jstring),"Account '%s has been successfully banned!",Name);
	        SCM(playerid,yellow,Jstring);
	        format(Jstring, sizeof(Jstring),"'%s' has banned account '%s'",GetName(playerid),Name);
	        AlertToAdmins(playerid,orange,Jstring);
	        format(Jstring,sizeof(Jstring),"[NAME BAN] %s has banned nick name %s",GetName(playerid),Name);
			WriteToLog(Jstring,"Bans");
 			return 1;
}
Why this not working? Kindly please helping.
Reply
#2

Fixed I was not Selecting Username from database.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)