[keyvanik]

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' 


[Dangjai]

You don't have pBanDays column in MySQL database, create it.

[keyvanik]

Quote:

Originally Posted by Kinglee You don't have pBanDays column in MySQL database, create it.

i creat it on my user and banned database

[Dangjai]

Change varchar to varchar(11) and try in your server again.

[keyvanik]

Quote:

Originally Posted by Kinglee Change varchar to varchar(11) and try in your server again.

I do it Now but not work player join server again

[Dangjai]

Quote:

Originally Posted by keyvanik I do it Now but not work player join server again

Show me your ban command code please.

[keyvanik]

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;
    } 


[Dangjai]

Problem from MySQL database not ban cmd, I suggest delete it and create another one with same name.

[keyvanik]

i have many users on this, delete?

[Dangjai]

Just delete the pBanDays not the users and recreate it.