Problem With /ban - 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: Problem With /ban (/showthread.php?tid=577015)
+- 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: Problem With /ban (/showthread.php?tid=577015)
Problem With /ban - keyvanik - 08.06.2015
Hi When i want ban some one like for 2 days adminwarn say player ... banned for 2 days reason ... but he/she can join server again this cmd just kick him but when not use days use 0 for Perementaly Ban He/she ban successfully can you help me to fix it?
when ban for days i see this on mysql_log.txt
PHP код:
[10:52:19] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'pBanDays' in 'field list'
Re: Problem With /ban - Dangjai - 08.06.2015
You don't have pBanDays column in MySQL database, create it.
Re: Problem With /ban - keyvanik - 08.06.2015
Quote:
|
Originally Posted by Kinglee
 You don't have pBanDays column in MySQL database, create it.
|
Re: Problem With /ban - Dangjai - 08.06.2015
Change varchar to varchar(11) and try in your server again.
Re: Problem With /ban - keyvanik - 08.06.2015
Quote:
|
Originally Posted by Kinglee
Change varchar to varchar(11) and try in your server again.
|
Re: Problem With /ban - Dangjai - 08.06.2015
Quote:
|
Originally Posted by keyvanik
I do it Now but not work player join server again
|
Re: Problem With /ban - keyvanik - 08.06.2015
Quote:
|
Originally Posted by Kinglee
Change varchar to varchar(11) and try in your server again.
|
Quote:
|
Originally Posted by keyvanik
i creat it on my user and banned database
|
Quote:
|
Originally Posted by keyvanik
I do it Now but not work player join server again
|
Quote:
|
Originally Posted by Kinglee
Show me your ban command code please.
|
PHP код:
if(!strcmp(cmd,"/ban",true))
{
if(PlayerInfo[playerid][pAdmin] <= 3) return SCM(playerid,COLOR_YELLOW2,"Error: Shoma Admin Nisti");
new Fullname[256];
Fullname = strtok(cmdtext,idx);
if(!strlen(Fullname)) return SCM(playerid,COL_SYN,"Syntax: /ban <FullName> <Days(1-60 , 0= Perementaly Ban)> <UseIP(1=Yes 0=No)> <Reason>");
tmp = strtok(cmdtext,idx);
if(!strlen(tmp)) return SCM(playerid,COL_SYN,"Syntax: /ban <FullName> <Days(1-60 , 0= Perementaly Ban)> <UseIP(1=Yes 0=No)> <Reason>");
new days = strval(tmp);
if(days < 0 || days > 60) return SCM(playerid,COLOR_ALI,"Type a day between 1 and 60.");
tmp = strtok(cmdtext,idx);
if(!strlen(tmp)) return SCM(playerid, COL_SYN, "Syntax: /ban <FullName> <Days(1-60 , 0= Perementaly Ban)> <UseIP(1=Yes 0=No)> <Reason>");
new UseIP = strval(tmp);
if(UseIP != 1 && UseIP != 0) return SCM(playerid, COLOR_ALI, "UseIP must be 0 or 1");
tmp = strtokEx(cmdtext,idx);
if(!strlen(tmp)) return SCM(playerid,COL_SYN,"Syntax: /ban <FullName> <Days(1-60 , 0= Perementaly Ban)> <UseIP(1=Yes 0=No)> <Reason>");
BanPlayer(playerid, Fullname, days, tmp, UseIP);
return 1;
}
Re: Problem With /ban - Dangjai - 08.06.2015
Problem from MySQL database not ban cmd, I suggest delete it and create another one with same name.
Re: Problem With /ban - keyvanik - 08.06.2015
i have many users on this, delete?
Re: Problem With /ban - Dangjai - 08.06.2015
Just delete the pBanDays not the users and recreate it.