11.09.2015, 22:30
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.
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;
}

