Error 035

[JekaMix]

Спойлер
case D_FULL_ACCESS+1:
        {
            if(!response) return 1;


            format(128, "SELECT `name` from fullaccess where name = '%s'", inputtext);
            mysql_tquery(dbHandle, "CheckFullAccess", "is", playerid, inputtext);

        }



    case D_FULL_ACCESS+3:
        {
            if(!response) return 1;

            switch(listitem)
            {
            case 0: ShowPlayerDialog(playerid, D_FULL_ACCESS+4, DIALOG_STYLE_INPUT, "{"#cSV"}Óêàæèòå íàçâàíèå ðàíãà", "{FFFFFF}Óêàæèòå íàçâàíèå ðàíãà äëÿ àäìèíèñòðàòîðà:", "Âûáðàòü", "Îòìåíà");
            case 1:
                {

                    new ac_name[24];

                    GetPVarString(playerid, "full_access_name", ac_name, sizeof(ac_name));

                    printf("%s", ac_name);

                    if(GetPlayerID(ac_name) != INVALID_PLAYER_ID)
                    {
                        SendMes(GetPlayerID(ac_name), COLOR_RED, "Àäìèíèñòðàòîð %s îòîáðàë ó Âàñ FullDostup", GetName(playerid));
                        DeletePVar(GetPlayerID(ac_name), "IsAFullDostup");
                    }


                    format(128, "DELETE FROM fullaccess WHERE id = '%d'", GetPVarInt(playerid, "full_access_id"));

                    SendMes(playerid, COLOR_RED, "FullDostup ñíÿò ñ àäìèíèñòðàòîðà %s", ac_name);

                    DeletePVar(playerid, "full_access_id");
                    DeletePVar(playerid, "full_access_name");
                }
            }

        }

    case D_FULL_ACCESS+4:
        {
            if(!response) return 1;

            new ac_name[24];

            GetPVarString(playerid, "full_access_name", ac_name, sizeof(ac_name));

            format(128, "UPDATE fullaccess SET rank = '%s' WHERE id = '%d'", inputtext, GetPVarInt(playerid, "full_access_id"));

            if(GetPlayerID(ac_name) != INVALID_PLAYER_ID) strmid(full_access_rank[GetPlayerID(ac_name)], inputtext, 0, strlen(inputtext), 64);

            SendMes(playerid, COLOR_GREEN, "Âû èçìåíèëè ðàíã àäìèíèñòðàòîðó %s íà %s", ac_name, inputtext);

            DeletePVar(playerid, "full_access_id");
            DeletePVar(playerid, "full_access_name");

        }











Ошибки тут:

format(128, "UPDATE fullaccess SET rank = '%s' WHERE id = '%d'", inputtext, GetPVarInt(playerid, "full_access_id"));

format(128, "DELETE FROM fullaccess WHERE id = '%d'", GetPVarInt(playerid, "full_access_id"));

            format(128, "SELECT `name` from fullaccess where name = '%s'", inputtext);
            mysql_tquery(dbHandle, "CheckFullAccess", "is", playerid, inputtext);

 

[Alexander_Batrakov]

Убираем варнинг №1

Спойлер

new id = GetPVarInt(playerid, "full_access_id");
new string[350];
mysql_format(dbHandle,string,256, "UPDATE `fullaccess` SET `rank` = '%s' WHERE `id` = '%d'", inputtext, id);
mysql_tquery(dbHandle,string);

Убираем варнинг №2

Спойлер

new id = GetPVarInt(playerid, "full_access_id");
new string[350];
mysql_format(dbHandle,string,256, "DELETE FROM `fullaccess` WHERE `id` = '%d'", id);
mysql_tquery(dbHandle,string);

//На твое усмотрение LIMIT 1.

Поправка в коде №3

Спойлер

new string[256];
mysql_format(dbHandle,string, sizeof(string), "SELECT * FROM `fullaccess` WHERE `name` = '%s'", inputtext);
mysql_tquery(dbHandle,string, "CheckFullAccess", "is", playerid, inputtext);