SA-MP Forums Archive
Hello Need Urgent Help - 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: Hello Need Urgent Help (/showthread.php?tid=588729)



Hello Need Urgent Help - MBilal - 11.09.2015

Why its not working i am trying to make ban offline player why its not working?
I am not getting any error in mysql logs.

Код:
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", "%s", Name);
        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;
	}
	else return ShowMessage(playerid, red, 1);
}

forward OnBanName(Name[]);
public OnBanName(Name[])
{
	new query[128];
	mysql_format(mysql, query, sizeof(query),"UPDATE `players` SET `Ban`= 1 WHERE `Username`= %s",Name);
 	mysql_tquery(mysql, query );
 	return 1;
}