SA-MP Forums Archive
How i can ban offline player using mysql ? Help Plz - 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: How i can ban offline player using mysql ? Help Plz (/showthread.php?tid=588784)



How i can ban offline player using mysql ? Help Plz - MBilal - 12.09.2015

Код:
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.


Re: How i can ban offline player using mysql ? Help Plz - MBilal - 12.09.2015

Fixed I was not Selecting Username from database.