сохранение

[DeanMrz]

Хотел перенести некоторые столбцы с accounts в admin чучуть не полужилось)
Лог с mysql_log

[19:51:00] [WARNING] CMySQLResult::GetRowDataByName - field not found ("pInvis")
[19:51:00] [ERROR] cache_get_field_content_int - invalid datatype
[19:51:00] [WARNING] CMySQLResult::GetRowDataByName - field not found ("pFD")
[19:51:00] [ERROR] cache_get_field_content_int - invalid datatype

Сами команды:

CMD:givefd(playerid, params[])
{
    if(FULL_1 || FULL_2 || FULL_3)
    if(sscanf(params, "dd", params[0], params[1])) return SendClientMessage(playerid, -1, ""#information"{FFFFFF}[{1DCA1D}Используйте{FFFFFF}] /givefd [id] [0/1]");
    isFull{params[0]} =params[1];
    mysql_format(connects, string, 164, "UPDATE `admin` SET pFD=%i WHERE `name` = '%s'", isFull{params[0]}, PlayerInfo[playerid][pNames]);
    mysql_empty(connects, string);
    return 1;
}
CMD:setarank(playerid, params[])
{
    if(!IsPlayerConnected(playerid) || !PlayerInfo[playerid][pLogin]) return 1;
    new stringer_prefix[128];
    if(!isFull{playerid}) return SendClientMessage(playerid,COLOR_GREEN,""#net"Вам недоступна данная команда");
    if(sscanf(params,"iis[70]",params[0],params[1],params[2])) return SendClientMessage(playerid,COLOR_GREEN,"{FFFFFF}[{1DCA1D}Используйте{FFFFFF}] /setprefix [ид] [цвет] [префикс]");
    if(!(0 <= params[1] <= 3)) return SendClientMessage(playerid, -1, "Номер цвета не может быть меньше 1 и больше 4!");
    new color[12];
    switch(params[1])
    {
        case 0: color = "{FF0000}";//red
        case 1: color = "{FF00AE}";//purple
        case 2: color = "{00FF48}";//blue
        case 3: color = "{FFEE00}";//blue
    }

    strmid(PlayerInfo[params[0]][pPrefix],params[2],0,24,24);
    strmid(PlayerInfo[params[0]][c_Prefix],color,0,12,12);

    mysql_format(connects,string,sizeof(string),"UPDATE `admin` SET `pPrefix` = '%s',`c_Prefix` = '%s' WHERE `name` = '%s'",PlayerInfo[params[0]][pPrefix],color,PlayerInfo[params[0]][pNames]);
    mysql_empty(connects,string);
    
   	format(stringer_prefix, 128,"[{1DCA1D}Информация{FFFFFF}] Вы успешно назначили префикс %s%s {FFFFFF}игроку %s", PlayerInfo[params[0]][c_Prefix],PlayerInfo[params[0]][pPrefix], PlayerInfo[params[0]][pNames]);
	SendClientMessage(playerid, 0xddddddFF, stringer_prefix);

	format(stringer_prefix, 128,"[{1DCA1D}Информация{FFFFFF}] Администратор %s назначил вам префикс %s%s", PlayerInfo[playerid][pNames], PlayerInfo[params[0]][c_Prefix],PlayerInfo[params[0]][pPrefix]);
	SendClientMessage(params[0], 0xddddddFF, stringer_prefix);
    return 1;
}
CMD:delarank(playerid, params[])
{
    if(!isFull{playerid}) return SendClientMessage(playerid,COLOR_GREEN,""#net"Вам недоступна данная команда");
    if(sscanf(params,"u",params[0])) return    SendClientMessage(playerid, -1,"{FFFFFF}[{1DCA1D}Используйте{FFFFFF}] /delprefix [id]");
    if(!IsPlayerConnected(params[0])) return true;
    strmid(PlayerInfo[params[0]][pPrefix],"\0",0,24,24);
    strmid(PlayerInfo[params[0]][c_Prefix],"\0",0,12,12);
    new stringer_prefix[128];
    mysql_format(connects,string,sizeof(string),"UPDATE `admin` SET `pPrefix` = '',`c_Prefix` = '' WHERE `name` = '%s'",PlayerInfo[params[0]][pNames]);
    mysql_empty(connects,string);
    format(stringer_prefix, 128,"[{1DCA1D}Информация{FFFFFF}] Вы успешно удалили префикс игроку %s", PlayerInfo[params[0]][pNames]);
    SendClientMessage(playerid, -1, stringer_prefix);
    format(stringer_prefix, 128,"[{1DCA1D}Информация{FFFFFF}] Администратор %s удалил вам префикс", PlayerInfo[params[0]][pNames]);
    SendClientMessage(params[0], -1, stringer_prefix);
    return 1;
}
CMD:setinv(playerid, params[])
{
    if(!isFull{playerid}) return SendClientMessage(playerid,COLOR_GREEN,""#net"Вам недоступна данная команда");
    aInvisible{playerid} = !aInvisible{playerid};
    mysql_format(connects, string, 164, "UPDATE `admin` SET pInvis=%i WHERE `name` = '%s'", aInvisible{playerid}, PlayerInfo[playerid][pNames]);
    mysql_empty(connects, string);
    return 1;
}