[OnQueryError] SQL ERROR. QUERY:

Tonys · 16 Май 2020

Ваще не понимаю что ни так, ибо с этой ошибок сталкиваюсь впервые

Код:

[plugins/mysql] error #1064 while executing query "UPDATE `accounts` SET `pLevel`= '3',`pExp`= '3',`pJail`= '0',`pvIp`= 'тутмойип',`house`= '126',`tempkey`= '0',`bussiness`= '71',`hotelroom`= '0',`pMats`= '0',`mute`= '0',`pJailTime`= '0',`pDrugs`= '99499',`pLeader`= '0',`pMember`= '0',`pRank`= '0',`pJob`= '0',`pModel`= '0',`Skin`= '162',`pZakonp`= '100',`pBank`= '417670',`pMobile`= '9999',`pSearch`= '0',`pGunSkills`= '100, 100, 100, 100, 100, 100, ',`pPlayTime_one`= '5',`pPlayTime_two`= '7',`pAccusedof`= 'Нет',`pVictim`= 'Нет',`pHospital`= '0',`pWorms`= '0',`pFish`= '0.000000',`family`= '0',`progress`= '0',`spawn`= '1',`salary`= '0',`MedHeal`= '0',`Advert`= '0',`pWeapons`= '0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0',`pAmmos`= '0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0',`FracDuty`= '0',`pSatiety`= '15',`pSnow`= '0.000000', WHERE `pID`='2'"

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE `pID`='2'' at line 1

Сам сток saveaccount

Код:

stock SaveAccount(playerid) {
    if(!TI[playerid][tLogin]) return false;
    if(GetPVarInt(playerid,"player_save")) return false;
    SetPVarInt(playerid,"player_save",1);

    new weapons[54],ammos[54];
    format(weapons,53,"%i, %i, %i, %i, %i, %i, %i, %i, %i, %i, %i",GunPlayer[playerid][0][0], GunPlayer[playerid][1][0], GunPlayer[playerid][2][0], GunPlayer[playerid][3][0],
    GunPlayer[playerid][4][0], GunPlayer[playerid][5][0], GunPlayer[playerid][6][0], GunPlayer[playerid][7][0], GunPlayer[playerid][8][0], GunPlayer[playerid][9][0], GunPlayer[playerid][10][0]);
    format(ammos,53,"%i, %i, %i, %i, %i, %i, %i, %i, %i, %i, %i",GunPlayer[playerid][0][1], GunPlayer[playerid][1][1], GunPlayer[playerid][2][1], GunPlayer[playerid][3][1],
    GunPlayer[playerid][4][1], GunPlayer[playerid][5][1], GunPlayer[playerid][6][1], GunPlayer[playerid][7][1], GunPlayer[playerid][8][1], GunPlayer[playerid][9][1], GunPlayer[playerid][10][1]);
    new skills[33];
    format(skills,32,"%i, %i, %i, %i, %i, %i, %i",PI[playerid][pGunSkill][0], PI[playerid][pGunSkill][1], PI[playerid][pGunSkill][2], PI[playerid][pGunSkill][3],
    PI[playerid][pGunSkill][4], PI[playerid][pGunSkill][5]);

    new query[3100],str[100];
    query = "UPDATE `"TABLE_ACCOUNTS"` SET ";
    format(str,sizeof(str),"`pLevel`= '%i',",PI[playerid][pLevel]),strcat(query,str,sizeof(query));
    format(str,sizeof(str),"`pExp`= '%i',",PI[playerid][pExp]),strcat(query,str,sizeof(query));
    format(str,sizeof(str),"`pJail`= '%i',",PI[playerid][pJail]),strcat(query,str,sizeof(query));

    format(str,sizeof(str),"`pvIp`= '%s',",player_ip[playerid]),strcat(query,str,sizeof(query));
//    format(str,sizeof(str),"`pHP`= '%i',",GetPlayerHP(playerid)),strcat(query,str,sizeof(query));

    format(str,sizeof(str),"`house`= '%i',",PI[playerid][pHouse]),strcat(query,str,sizeof(query));
    format(str,sizeof(str),"`tempkey`= '%i',",PI[playerid][pTempKey]),strcat(query,str,sizeof(query));
    format(str,sizeof(str),"`bussiness`= '%i',",PI[playerid][pBusiness]),strcat(query,str,sizeof(query));
    format(str,sizeof(str),"`hotelroom`= '%i',",PI[playerid][pRoom]),strcat(query,str,sizeof(query));
    format(str,sizeof(str),"`pMats`= '%i',",PI[playerid][pMats]),strcat(query,str,sizeof(query));
    format(str,sizeof(str),"`mute`= '%i',",PI[playerid][pMute]),strcat(query,str,sizeof(query));
     format(str,sizeof(str),"`pJailTime`= '%i',",PI[playerid][pJailTime]),strcat(query,str,sizeof(query));
    format(str,sizeof(str),"`pDrugs`= '%i',",PI[playerid][pDrugs]),strcat(query,str,sizeof(query));
    format(str,sizeof(str),"`pLeader`= '%i',",PI[playerid][pLeader]),strcat(query,str,sizeof(query));
    format(str,sizeof(str),"`pMember`= '%i',",PI[playerid][pMember]),strcat(query,str,sizeof(query));

    format(str,sizeof(str),"`pRank`= '%i',",PI[playerid][pRank]),strcat(query,str,sizeof(query));
    format(str,sizeof(str),"`pJob`= '%i',",PI[playerid][pJob]),strcat(query,str,sizeof(query));
    format(str,sizeof(str),"`pModel`= '%i',",PI[playerid][pFracSkin]),strcat(query,str,sizeof(query));

    format(str,sizeof(str),"`Skin`= '%i',",PI[playerid][pSkin]),strcat(query,str,sizeof(query));
    format(str,sizeof(str),"`pZakonp`= '%i',",PI[playerid][pZakonp]),strcat(query,str,sizeof(query));

    format(str,sizeof(str),"`pBank`= '%i',",PI[playerid][pBank]),strcat(query,str,sizeof(query));
    format(str,sizeof(str),"`pMobile`= '%i',",PI[playerid][pMobile]),strcat(query,str,sizeof(query));
    format(str,sizeof(str),"`pSearch`= '%i',",PI[playerid][pSearch]),strcat(query,str,sizeof(query));

    format(str,sizeof(str),"`pGunSkills`= '%s',",skills),strcat(query,str,sizeof(query));

    format(str,sizeof(str),"`pPlayTime_one`= '%i',",PI[playerid][pPlayTime][0]),strcat(query,str,sizeof(query));
    format(str,sizeof(str),"`pPlayTime_two`= '%i',",PI[playerid][pPlayTime][1]),strcat(query,str,sizeof(query));

    format(str,sizeof(str),"`pAccusedof`= '%s',",PI[playerid][pAccusedof]),strcat(query,str,sizeof(query));
    format(str,sizeof(str),"`pVictim`= '%s',",PI[playerid][pVictim]),strcat(query,str,sizeof(query));

    format(str,sizeof(str),"`pHospital`= '%i',",PI[playerid][pHospital]),strcat(query,str,sizeof(query));
    format(str,sizeof(str),"`pWorms`= '%i',",PI[playerid][pWorms]),strcat(query,str,sizeof(query));
    format(str,sizeof(str),"`pFish`= '%f',",PI[playerid][pFish]),strcat(query,str,sizeof(query));
    format(str,sizeof(str),"`family`= '%i',",PI[playerid][pFamily]),strcat(query,str,sizeof(query));
    format(str,sizeof(str),"`progress`= '%i',",PI[playerid][pProgress]),strcat(query,str,sizeof(query));
    format(str,sizeof(str),"`spawn`= '%i',",PI[playerid][pSpawn]),strcat(query,str,sizeof(query));
    format(str,sizeof(str),"`salary`= '%i',",PI[playerid][pSalary]),strcat(query,str,sizeof(query));
    format(str,sizeof(str),"`MedHeal`= '%i',",PI[playerid][pMedHeal]),strcat(query,str,sizeof(query));
    format(str,sizeof(str),"`Advert`= '%i',",PI[playerid][pAdvert]),strcat(query,str,sizeof(query));

    format(str,sizeof(str),"`pWeapons`= '%s',",weapons),strcat(query,str,sizeof(query));
    format(str,sizeof(str),"`pAmmos`= '%s',",ammos),strcat(query,str,sizeof(query));

    format(str,sizeof(str),"`FracDuty`= '%i',",start_work[playerid]),strcat(query,str,sizeof(query));
    format(str,sizeof(str),"`pSatiety`= '%i',",PI[playerid][pSatiety]),strcat(query,str,sizeof(query));

    format(str,sizeof(str),"`pSnow`= '%f',",PI[playerid][pSnow]),strcat(query,str,sizeof(query));

    //strdel(query, strlen(query)-1, strlen(query));

    mysql_format(connects, query,sizeof(query),"%s WHERE `pID`='%d'",query, PI[playerid][pID]);
    mysql_tquery(connects, query, "", "");

    DeletePVar(playerid, "player_save");
    return true;
}

[OnQueryError] SQL ERROR. QUERY:

Tonys

Новичок