После рестарта все проподает

Vvvjonhsonm · 30 Сен 2020

Не работает сохр акк
logs

Код:

[22:00:00] [OnQueryError] SQL ERROR. QUERY:
[22:00:00] UPDATE `accounts` SET `pLevel`= '1',`pExp`= '1',`pJail`= '0',`pvIp`= '37.79.29.78',`pHP`= '23.000000',`house`= '0',`tempkey`= '0',`bussiness`= '0',`hotelroom`= '0',`pMats`= '0',`mute`= '0',`pJailTime`= '0',`pDrugs`= '0',`pLeader`= '0',`pMember`= '0',`pRank`= '0',`pJob`= '0',`pModel`= '0',`Skin`= '211',`pZakonp`= '1',`pBank`= '15000',`pMobile`= '0',`pSearch`= '0',`pGunSkills`= '0, 0, 0, 0, 0, 0, ',`pPlayTime_one`= '0',`pPlayTime_two`= '0',`pAccusedof`= 'Нет',`pVictim`= 'Нет',`pHospital`= '3',`pWorms`= '0',`pFish`= '0.000000',`family`= '0',`progress`= '0',`spawn`= '0',`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`= '100',`pSnow`= '0.000000',`pAsk`= '0',`pAskmute`= '0',`time_fraction_input` = '0' WHERE `pID`='21'
[22:00:00] [OnQueryError] SQL ERROR. QUERY:
[22:00:00] UPDATE `accounts` SET `pLevel`= '6',`pExp`= '0',`pJail`= '0',`pvIp`= '151.0.34.81',`pHP`= '100.000000',`house`= '0',`tempkey`= '0',`bussiness`= '0',`hotelroom`= '0',`pMats`= '0',`mute`= '0',`pJailTime`= '0',`pDrugs`= '0',`pLeader`= '0',`pMember`= '0',`pRank`= '1',`pJob`= '0',`pModel`= '0',`Skin`= '94',`pZakonp`= '4',`pBank`= '76300',`pMobile`= '0',`pSearch`= '0',`pGunSkills`= '0, 0, 0, 0, 0, 0, ',`pPlayTime_one`= '0',`pPlayTime_two`= '0',`pAccusedof`= 'Нет',`pVictim`= 'Нет',`pHospital`= '0',`pWorms`= '0',`pFish`= '0.000000',`family`= '0',`progress`= '2',`spawn`= '0',`salary`= '0',`MedHeal`= '0',`Advert`= '0',`pWeapons`= '0, 0, 24, 0, 29, 0, 0, 0, 0, 0, 0',`pAmmos`= '0, 0, 994, 0, 995, 0, 0, 0, 0, 0, 0',`FracDuty`= '1',`pSatiety`= '100',`pSnow`= '0.000000',`pAsk`= '0',`pAskmute`= '0',`time_fraction_input` = '0' WHERE `pID`='1'
[22:01:55] [OnQueryError] SQL ERROR. QUERY:
[22:01:55] UPDATE `accounts` SET `pLevel`= '1',`pExp`= '2',`pJail`= '0',`pvIp`= '37.79.29.78',`pHP`= '23.000000',`house`= '0',`tempkey`= '0',`bussiness`= '0',`hotelroom`= '0',`pMats`= '0',`mute`= '0',`pJailTime`= '0',`pDrugs`= '0',`pLeader`= '0',`pMember`= '0',`pRank`= '0',`pJob`= '0',`pModel`= '0',`Skin`= '211',`pZakonp`= '2',`pBank`= '30000',`pMobile`= '0',`pSearch`= '0',`pGunSkills`= '0, 0, 0, 0, 0, 0, ',`pPlayTime_one`= '0',`pPlayTime_two`= '0',`pAccusedof`= 'Нет',`pVictim`= 'Нет',`pHospital`= '3',`pWorms`= '0',`pFish`= '0.000000',`family`= '0',`progress`= '0',`spawn`= '0',`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`= '100',`pSnow`= '0.000000',`pAsk`= '0',`pAskmute`= '0',`time_fraction_input` = '0' WHERE `pID`='21'
[22:01:55] [OnQueryError] SQL ERROR. QUERY:
[22:01:55] UPDATE `accounts` SET `pLevel`= '6',`pExp`= '0',`pJail`= '0',`pvIp`= '151.0.34.81',`pHP`= '100.000000',`house`= '0',`tempkey`= '0',`bussiness`= '0',`hotelroom`= '0',`pMats`= '0',`mute`= '0',`pJailTime`= '0',`pDrugs`= '0',`pLeader`= '0',`pMember`= '0',`pRank`= '1',`pJob`= '0',`pModel`= '0',`Skin`= '94',`pZakonp`= '5',`pBank`= '95300',`pMobile`= '0',`pSearch`= '0',`pGunSkills`= '0, 0, 0, 0, 0, 0, ',`pPlayTime_one`= '0',`pPlayTime_two`= '0',`pAccusedof`= 'Нет',`pVictim`= 'Нет',`pHospital`= '0',`pWorms`= '0',`pFish`= '0.000000',`family`= '0',`progress`= '2',`spawn`= '0',`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`= '1',`pSatiety`= '100',`pSnow`= '0.000000',`pAsk`= '0',`pAskmute`= '0',`time_fraction_input` = '0' WHERE `pID`='1'
[22:02:34] [OnQueryError] SQL ERROR. QUERY:
[22:02:34] UPDATE `accounts` SET `pLevel`= '1',`pExp`= '2',`pJail`= '0',`pvIp`= '37.79.29.78',`pHP`= '23.000000',`house`= '0',`tempkey`= '0',`bussiness`= '0',`hotelroom`= '0',`pMats`= '0',`mute`= '0',`pJailTime`= '0',`pDrugs`= '0',`pLeader`= '0',`pMember`= '0',`pRank`= '0',`pJob`= '0',`pModel`= '0',`Skin`= '211',`pZakonp`= '2',`pBank`= '30000',`pMobile`= '0',`pSearch`= '0',`pGunSkills`= '0, 0, 0, 0, 0, 0, ',`pPlayTime_one`= '1',`pPlayTime_two`= '0',`pAccusedof`= 'Нет',`pVictim`= 'Нет',`pHospital`= '3',`pWorms`= '0',`pFish`= '0.000000',`family`= '0',`progress`= '0',`spawn`= '0',`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`= '100',`pSnow`= '0.000000',`pAsk`= '0',`pAskmute`= '0',`time_fraction_input` = '0' WHERE `pID`='21'
[22:02:34] [OnQueryError] SQL ERROR. QUERY:
[22:02:34] UPDATE `accounts` SET `pLevel`= '6',`pExp`= '0',`pJail`= '0',`pvIp`= '151.0.34.81',`pHP`= '100.000000',`house`= '0',`tempkey`= '0',`bussiness`= '0',`hotelroom`= '0',`pMats`= '0',`mute`= '0',`pJailTime`= '0',`pDrugs`= '0',`pLeader`= '0',`pMember`= '0',`pRank`= '1',`pJob`= '0',`pModel`= '0',`Skin`= '94',`pZakonp`= '5',`pBank`= '95300',`pMobile`= '0',`pSearch`= '0',`pGunSkills`= '0, 0, 0, 0, 0, 0, ',`pPlayTime_one`= '1',`pPlayTime_two`= '0',`pAccusedof`= 'Нет',`pVictim`= 'Нет',`pHospital`= '0',`pWorms`= '0',`pFish`= '0.000000',`family`= '0',`progress`= '2',`spawn`= '0',`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`= '1',`pSatiety`= '100',`pSnow`= '0.000000',`pAsk`= '0',`pAskmute`= '0',`time_fraction_input` = '0' WHERE `pID`='1'
[22:04:27] [part] Fredo_Changretta has left the server (0:2)
[22:04:27] [part] Viktor_Jonson has left the server (1:2)
[22:04:27] Auto Restart - Reloading...
[22:04:27] [OnQueryError] SQL ERROR. QUERY:
[22:04:27] UPDATE `accounts` SET `pLevel`= '1',`pExp`= '2',`pJail`= '0',`pvIp`= '37.79.29.78',`pHP`= '23.000000',`house`= '0',`tempkey`= '0',`bussiness`= '0',`hotelroom`= '0',`pMats`= '0',`mute`= '0',`pJailTime`= '0',`pDrugs`= '0',`pLeader`= '0',`pMember`= '0',`pRank`= '0',`pJob`= '0',`pModel`= '0',`Skin`= '211',`pZakonp`= '2',`pBank`= '30000',`pMobile`= '0',`pSearch`= '0',`pGunSkills`= '0, 0, 0, 0, 0, 0, ',`pPlayTime_one`= '3',`pPlayTime_two`= '0',`pAccusedof`= 'Нет',`pVictim`= 'Нет',`pHospital`= '3',`pWorms`= '0',`pFish`= '0.000000',`family`= '0',`progress`= '0',`spawn`= '0',`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`= '100',`pSnow`= '0.000000',`pAsk`= '0',`pAskmute`= '0',`time_fraction_input` = '0' WHERE `pID`='21'
[22:04:27] Gamemode ended.
[22:04:27]

SQL ERROR что это
СТОК С 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`= '%f',",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));

    format(str,sizeof(str),"`pAsk`= '%i',",PI[playerid][pAsk]),strcat(query,str,sizeof(query));
    format(str,sizeof(str),"`pAskmute`= '%i',",PI[playerid][pAskmute]),strcat(query,str,sizeof(query));
    format(str,sizeof str, "`time_fraction_input` = '%d'",PI[playerid][p_time_fraction_input]), 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;
}

После рестарта все проподает

Vvvjonhsonm

Умник