Слетает почти все

[19]

Добрый вечер уважаемые формучане,у меня  в моде такая проблема, вчера расставил гаражи игроки их купили и в 5 утра был рестарт все гаражи у игроков слетели, так же слетели дома и их оплата, не знаю в чем проблема, вот при рестарте сохранения все есть.  

Спойлер

public OnGameModeExit()
{
   //êàìåðà ïîëåòà
       for(new x; x<MAX_PLAYERS; x++)
    {
        if(noclipdata[x][cameramode] == CAMERA_MODE_FLY) CancelFlyMode(x);
    }
   //
    for(new i; i < GetMaxPlayers(); i++)
    {
        SaveAccounts();
        SaveAcc(i);
        SaveVehicle(i);
        UpdateGarage(i);
        updatekvar(i);
        UpdateAtm(i);
        OnPropUpdate(i);
        UpdateLarek(i);
        SavePlayer(i);
        SaveHouse(i);
        PlayerTextDrawDestroy(i,MoneyCounter);
    }
    KillTimer(BabloTimer);
       printf("OnGameModeExit äîñòèã êîíöà");
    return 1;
}

 

[370]

Вопрос решён помог через вк, ошибка бывав том что он сохранял игроков хотя у него в стоке сохраняется ид дома. Сделали так

new i_1 = GetHouseIdx(PlayerInfo[pNewHouse]);
SaveHouse(i_1);

Отредактировано 27 февраля, 2018 пользователем Покемон

[370]

Покажи как сохраняешь сток или паблик

[19]

@Покемон

Спойлер

//==============================================================================
stock SavePlayer(playerid)
{
    if(!IsPlayerConnected(playerid) || !gPlayerLogged[playerid]) return 1;
    GetPlayerHealth(playerid,PlayerInfo[playerid][pHealth]);
    if((PlayerInfo[playerid][pPos_x]==0.0 && PlayerInfo[playerid][pPos_y]==0.0 && PlayerInfo[playerid][pPos_z]==0.0))
    {
        PlayerInfo[playerid][pPos_x] = 1684.9;
        PlayerInfo[playerid][pPos_y] = -2244.5;
        PlayerInfo[playerid][pPos_z] = 13.5;
    }
    if(Spectate[playerid] != 255)
    {
        PlayerInfo[playerid][pPos_x] = Unspec[playerid][sPx];
        PlayerInfo[playerid][pPos_y] = Unspec[playerid][sPy];
        PlayerInfo[playerid][pPos_z] = Unspec[playerid][sPz];
        PlayerInfo[playerid][pInt] = Unspec[playerid][sPint];
        PlayerInfo[playerid][pLocal] = Unspec[playerid][sLocal];
    }
    // Само сохранение
    glob_str = "";
    mysql_format(MySQLGo,glob_str,sizeof(glob_str),"UPDATE `accounts` SET `pKey` = '%s',`pLevel` = '%i',`pSatiety` = '%i',`pAvtoP` = '%d,%d,%d,%d' WHERE `id` = '%d' LIMIT 1", PlayerInfo[playerid][pKey],PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pSatiety],PlayerInfo[playerid][pAvtoP][0],PlayerInfo[playerid][pAvtoP][1],PlayerInfo[playerid][pAvtoP][2]
    ,PlayerInfo[playerid][pAvtoP][3],PlayerInfo[playerid][pID]);
    mysql_tquery(MySQLGo,glob_str);
    glob_str = "";
    mysql_function(MySQLGo,300,"UPDATE `accounts` SET `pVoennik` = '%i',`pMed` = '%i',`pDm` = '%i', `pWantedPoints` = '%i', `pHelper` = '%i' WHERE `id` = '%d' LIMIT 1",false,"","", PlayerInfo[playerid][pVoennik],PlayerInfo[playerid][pMK], PlayerInfo[playerid][pDm], PlayerInfo[playerid][pWantedPoints],PlayerInfo[playerid][pHelper],PlayerInfo[playerid][pID]);
    mysql_function(MySQLGo,300,"UPDATE `accounts` SET `pUvp` = '%i',`pDonateRank` = '%i',`gPupgrade` = '%i', `pConnectTime` = '%i', `pReg` = '%i' WHERE `id` = '%d' LIMIT 1",false,"","", PlayerInfo[playerid][pUvp],PlayerInfo[playerid][pDonateRank], PlayerInfo[playerid][gPupgrade], PlayerInfo[playerid][pConnectTime],PlayerInfo[playerid][pReg],PlayerInfo[playerid][pID]);
    mysql_function(MySQLGo,300,"UPDATE `accounts` SET `pSex` = '%i',`pOrigin` = '%i',`pNotLic` = '%i', `pLangEng` = '%i', `pLangJap` = '%i' WHERE `id` = '%d' LIMIT 1",false,"","", PlayerInfo[playerid][pSex],PlayerInfo[playerid][pOrigin], PlayerInfo[playerid][pNotLic], PlayerInfo[playerid][pLangEng],PlayerInfo[playerid][pLangJap],PlayerInfo[playerid][pID]);
    mysql_function(MySQLGo,300,"UPDATE `accounts` SET `pLangIta` = '%i',`pLangRus` = '%i',`pLangFra` = '%i', `pNarcoZavisimost` = '%i', `pAlcoZavisimost` = '%i' WHERE `id` = '%d' LIMIT 1",false,"","", PlayerInfo[playerid][pLangIta],PlayerInfo[playerid][pLangRus], PlayerInfo[playerid][pLangFra], PlayerInfo[playerid][pNarcoZavisimost],PlayerInfo[playerid][pAlcoZavisimost],PlayerInfo[playerid][pID]);
    mysql_function(MySQLGo,300,"UPDATE `accounts` SET `pNarcoLomka` = '%i',`pAlcoLomka` = '%i',`pMuted` = '%i', `pExp` = '%i', `pOtkRabota1` = '%i' WHERE `id` = '%d' LIMIT 1",false,"","", PlayerInfo[playerid][pNarcoLomka],PlayerInfo[playerid][pAlcoLomka], PlayerInfo[playerid][pMuted], PlayerInfo[playerid][pExp],PlayerInfo[playerid][pOtkRabota1],PlayerInfo[playerid][pID]);
    mysql_function(MySQLGo,300,"UPDATE `accounts` SET `pOtkRabota2` = '%i',`pOtkRabota3` = '%i',`pOtkRabota7` = '%i', `pOtkRabota8` = '%i', `pOtkRabota12` = '%i' WHERE `id` = '%d' LIMIT 1",false,"","", PlayerInfo[playerid][pOtkRabota2],PlayerInfo[playerid][pOtkRabota3], PlayerInfo[playerid][pOtkRabota7], PlayerInfo[playerid][pOtkRabota8],PlayerInfo[playerid][pOtkRabota12],PlayerInfo[playerid][pID]);
    mysql_function(MySQLGo,300,"UPDATE `accounts` SET `pOtkRabota14` = '%i',`pOtkRabota15` = '%i',`pOtkRabota16` = '%i', `pOtkRabota22` = '%i', `pOtkRabota24` = '%i' WHERE `id` = '%d' LIMIT 1",false,"","", PlayerInfo[playerid][pOtkRabota14],PlayerInfo[playerid][pOtkRabota15], PlayerInfo[playerid][pOtkRabota16], PlayerInfo[playerid][pOtkRabota22],PlayerInfo[playerid][pOtkRabota24],PlayerInfo[playerid][pID]);
    mysql_function(MySQLGo,300,"UPDATE `accounts` SET `pCash` = '%i',`pAccount` = '%i',`pCrimes` = '%i', `pKills` = '%i', `pDeaths` = '%i' WHERE `id` = '%d' LIMIT 1",false,"","", PlayerInfo[playerid][pCash],PlayerInfo[playerid][pAccount], PlayerInfo[playerid][pCrimes], PlayerInfo[playerid][pKills],PlayerInfo[playerid][pDeaths],PlayerInfo[playerid][pID]);
    mysql_function(MySQLGo,300,"UPDATE `accounts` SET `pArrested` = '%i',`pWantedDeaths` = '%i',`pPhoneBook` = '%i', `pLottoNr` = '%i' WHERE `id` = '%d' LIMIT 1",false,"","", PlayerInfo[playerid][pArrested],PlayerInfo[playerid][pWantedDeaths], PlayerInfo[playerid][pPhoneBook], PlayerInfo[playerid][pLottoNr],PlayerInfo[playerid][pID]);
    mysql_function(MySQLGo,300,"UPDATE `accounts` SET `pJob` = '%i',`pPayCheck` = '%i', `pHeadValue` = '%i', `pJailed` = '%i' WHERE `id` = '%d' LIMIT 1",false,"","",PlayerInfo[playerid][pJob], PlayerInfo[playerid][pPayCheck], PlayerInfo[playerid][pHeadValue],PlayerInfo[playerid][pJailed],PlayerInfo[playerid][pID]);
    mysql_function(MySQLGo,300,"UPDATE `accounts` SET `pJailTime` = '%i',`pMats` = '%i',`pDrugs` = '%i', `pMember` = '%i' WHERE `id` = '%d' LIMIT 1",false,"","", PlayerInfo[playerid][pJailTime],PlayerInfo[playerid][pMats], PlayerInfo[playerid][pDrugs], PlayerInfo[playerid][pMember],PlayerInfo[playerid][pID]);
    mysql_function(MySQLGo,300,"UPDATE `accounts` SET `pRank` = '%i',`pDolj` = '%i', `pChar` = '%i', `pKatA` = '%i' WHERE `id` = '%d' LIMIT 1",false,"","",PlayerInfo[playerid][pRank], PlayerInfo[playerid][pDolj], PlayerInfo[playerid][pChar],PlayerInfo[playerid][pKatA],PlayerInfo[playerid][pID]);
    mysql_function(MySQLGo,300,"UPDATE `accounts` SET `pKatB` = '%i',`pKatC` = '%i',`pKatD` = '%i', `pContractTime` = '%i', `pDetSkill` = '%i' WHERE `id` = '%d' LIMIT 1",false,"","", PlayerInfo[playerid][pKatB],PlayerInfo[playerid][pKatC], PlayerInfo[playerid][pKatD], PlayerInfo[playerid][pContractTime],PlayerInfo[playerid][pDetSkill],PlayerInfo[playerid][pID]);
    mysql_function(MySQLGo,300,"UPDATE `accounts` SET `pNewsSkill` = '%i', `pDrugsSkill` = '%i',`pPbiskey` = '%i' WHERE `id` = '%d' LIMIT 1",false,"","", PlayerInfo[playerid][pNewsSkill], PlayerInfo[playerid][pDrugsSkill],PlayerInfo[playerid][pPbiskey],PlayerInfo[playerid][pID]);
    mysql_function(MySQLGo,300,"UPDATE `accounts` SET `pSHealth` = '%.1f',`pHealth` = '%.1f', `pModel` = '%i', `pPnumber` = '%i' WHERE `id` = '%d' LIMIT 1",false,"","", PlayerInfo[playerid][pSHealth], PlayerInfo[playerid][pHealth], PlayerInfo[playerid][pModel],PlayerInfo[playerid][pPnumber],PlayerInfo[playerid][pID]);
    mysql_function(MySQLGo,300,"UPDATE `accounts` SET `pPos_x` = '%.1f',`pPos_y` = '%.1f',`pPos_z` = '%.1f', `pCarLic` = '%i', `pCarLic1` = '%i' WHERE `id` = '%d' LIMIT 1",false,"","", PlayerInfo[playerid][pPos_x],PlayerInfo[playerid][pPos_y], PlayerInfo[playerid][pPos_z], PlayerInfo[playerid][pCarLic],PlayerInfo[playerid][pCarLic1],PlayerInfo[playerid][pID]);
    mysql_function(MySQLGo,300,"UPDATE `accounts` SET `pCarLic2` = '%s',`pCarLic21` = '%s',`pCarLic3` = '%s', `pUdost1` = '%s', `pUdost2` = '%s' WHERE `id` = '%d' LIMIT 1",false,"","", PlayerInfo[playerid][pCarLic2],PlayerInfo[playerid][pCarLic21], PlayerInfo[playerid][pCarLic3], PlayerInfo[playerid][pUdost1],PlayerInfo[playerid][pUdost2],PlayerInfo[playerid][pID]);
    mysql_function(MySQLGo,300,"UPDATE `accounts` SET `pUdost` = '%s',`pCarLic4` = '%i',`pCarLic5` = '%i', `pMK2` = '%s', `pMK3` = '%s' WHERE `id` = '%d' LIMIT 1",false,"","", PlayerInfo[playerid][pUdost],PlayerInfo[playerid][pCarLic4], PlayerInfo[playerid][pCarLic5], PlayerInfo[playerid][pMK2],PlayerInfo[playerid][pMK3],PlayerInfo[playerid][pID]);
    mysql_function(MySQLGo,300,"UPDATE `accounts` SET `pMK4` = '%s',`pFlyLic` = '%i',`pKategA` = '%i', `pKategB` = '%i', `pKategC` = '%i' WHERE `id` = '%d' LIMIT 1",false,"","", PlayerInfo[playerid][pMK4],PlayerInfo[playerid][pFlyLic], PlayerInfo[playerid][pKategA], PlayerInfo[playerid][pKategB],PlayerInfo[playerid][pKategC],PlayerInfo[playerid][pID]);
    mysql_function(MySQLGo,300,"UPDATE `accounts` SET `pKategD` = '%i',`pFlyLic` = '%i',`pKategA` = '%i', `pKategB` = '%i', `pKategC` = '%i' WHERE `id` = '%d' LIMIT 1",false,"","", PlayerInfo[playerid][pKategD],PlayerInfo[playerid][pFlyLic], PlayerInfo[playerid][pKategA], PlayerInfo[playerid][pKategB],PlayerInfo[playerid][pKategC],PlayerInfo[playerid][pID]);
    mysql_function(MySQLGo,300,"UPDATE `accounts` SET `pGunLic` = '%i',`pRef` = '%s',`pCKey` = '%d' WHERE `id` = '%d' LIMIT 1",false,"","", PlayerInfo[playerid][pGunLic],PlayerInfo[playerid][pRef],PlayerInfo[playerid][pCKey],PlayerInfo[playerid][pID]);
    mysql_function(MySQLGo,300,"UPDATE `accounts` SET `pCarTime` = '%i',`pPayDay` = '%i', `pPayDayHad` = '%i', `pCDPlayer` = '%i' WHERE `id` = '%d' LIMIT 1",false,"","",PlayerInfo[playerid][pCarTime], PlayerInfo[playerid][pPayDay], PlayerInfo[playerid][pPayDayHad],PlayerInfo[playerid][pCDPlayer],PlayerInfo[playerid][pID]);
    mysql_function(MySQLGo,300,"UPDATE `accounts` SET `pWins` = '%i',`pLoses` = '%i',`pAlcoholPerk` = '%i', `pDrugPerk` = '%i', `pMiserPerk` = '%i' WHERE `id` = '%d' LIMIT 1",false,"","", PlayerInfo[playerid][pWins],PlayerInfo[playerid][pLoses], PlayerInfo[playerid][pAlcoholPerk], PlayerInfo[playerid][pDrugPerk],PlayerInfo[playerid][pMiserPerk],PlayerInfo[playerid][pID]);
    mysql_function(MySQLGo,300,"UPDATE `accounts` SET `pPainPerk` = '%i',`pTraderPerk` = '%i',`pTut` = '%i', `pMissionNr` = '%i', `pWarns` = '%i' WHERE `id` = '%d' LIMIT 1",false,"","", PlayerInfo[playerid][pPainPerk],PlayerInfo[playerid][pTraderPerk], PlayerInfo[playerid][pTut], PlayerInfo[playerid][pMissionNr],PlayerInfo[playerid][pWarns],PlayerInfo[playerid][pID]);
    mysql_function(MySQLGo,300,"UPDATE `accounts` SET `pForce` = '%i',`pAdjustable` = '%i',`pFuel` = '%i', `pMarried` = '%i', `pRPD` = '%i' WHERE `id` = '%d' LIMIT 1",false,"","", PlayerInfo[playerid][pForce],PlayerInfo[playerid][pAdjustable], PlayerInfo[playerid][pFuel], PlayerInfo[playerid][pMarried],PlayerInfo[playerid][pRPD],PlayerInfo[playerid][pID]);
    mysql_function(MySQLGo,300,"UPDATE `accounts` SET `pMarriedTo` = '%s',`pTA` = '%i',`pClock` = '%i', `pCard` = '%i', `pGunSkill` = '%i' WHERE `id` = '%d' LIMIT 1",false,"","", PlayerInfo[playerid][pWins],PlayerInfo[playerid][pTA], PlayerInfo[playerid][pClock], PlayerInfo[playerid][pCard],PlayerInfo[playerid][pGunSkill],PlayerInfo[playerid][pID]);
    mysql_function(MySQLGo,300,"UPDATE `accounts` SET `pMutedTime` = '%i',`pRabotalLopatoy` = '%i',`pZoloto` = '%i', `pRadio` = '%i', `pPasport` = '%i', `pLastIp` = '%s' WHERE `id` = '%d' LIMIT 1",false,"","", PlayerInfo[playerid][pMutedTime],PlayerInfo[playerid][pRabotalLopatoy], PlayerInfo[playerid][pZoloto], PlayerInfo[playerid][pRadio],PlayerInfo[playerid][pPasport],PlayerInfo[playerid][pNowIp],PlayerInfo[playerid][pID]);
    mysql_function(MySQLGo,300,"UPDATE `accounts` SET `pRope` = '%i',`pNeSdal` = '%i',`pRoliki` = '%i', `pSigs` = '%i', `pLarek` = '%i', `pRegIp` = '%s' WHERE `id` = '%d' LIMIT 1",false,"","", PlayerInfo[playerid][pRope],PlayerInfo[playerid][pNeSdal], PlayerInfo[playerid][pRoliki], PlayerInfo[playerid][pSigs],PlayerInfo[playerid][pLarek],PlayerInfo[playerid][pRegIp],PlayerInfo[playerid][pID]);
    mysql_function(MySQLGo,300,"UPDATE `accounts` SET `pSpawnP` = '%i',`pNewHouse` = '%i', `pRentHouse` = '%i' WHERE `id` = '%d' LIMIT 1",false,"","", PlayerInfo[playerid][pSpawnP], PlayerInfo[playerid][pNewHouse], PlayerInfo[playerid][pRentHouse],PlayerInfo[playerid][pID]);

    // next
    for(new x; x < 13; x++) GetPlayerWeaponData(playerid, x, PlayerInfo[playerid][pWeapon][x], PlayerInfo[playerid][pAmmo][x]); // Определяем точное количество патрон

    new queryw[500];
    format(PlayerInfo[playerid][pWeapons],256,"%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i",
    PlayerInfo[playerid][pWeapon][0],PlayerInfo[playerid][pWeapon][1],PlayerInfo[playerid][pWeapon][2],PlayerInfo[playerid][pWeapon][3],PlayerInfo[playerid][pWeapon][4],PlayerInfo[playerid][pWeapon][5],
    PlayerInfo[playerid][pWeapon][6],PlayerInfo[playerid][pWeapon][7],PlayerInfo[playerid][pWeapon][8],PlayerInfo[playerid][pWeapon][9],PlayerInfo[playerid][pWeapon][10],PlayerInfo[playerid][pWeapon][11],PlayerInfo[playerid][pWeapon][12]);

    format(PlayerInfo[playerid][pAmmos],256,"%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i",
    PlayerInfo[playerid][pAmmo][0],PlayerInfo[playerid][pAmmo][1],PlayerInfo[playerid][pAmmo][2],PlayerInfo[playerid][pAmmo][3],PlayerInfo[playerid][pAmmo][4],PlayerInfo[playerid][pAmmo][5],
    PlayerInfo[playerid][pAmmo][6],PlayerInfo[playerid][pAmmo][7],PlayerInfo[playerid][pAmmo][8],PlayerInfo[playerid][pAmmo][9],PlayerInfo[playerid][pAmmo][10],PlayerInfo[playerid][pAmmo][11],PlayerInfo[playerid][pAmmo][12]);

    format(queryw, 500, "UPDATE `accounts` SET `pGunID` = '%s', `pGunAmmo` = '%s' WHERE `id` = '%d'",PlayerInfo[playerid][pWeapons],PlayerInfo[playerid][pAmmos],PlayerInfo[playerid][pID]);
    mysql_tquery(MySQLGo, queryw);

    // Вывод
    if(mysql_errno()) printf("Ошибка сохранения аккаунта: %s [%d]",NamePlayer[playerid], PlayerInfo[playerid][pID]);
    else printf("Успешно сохранение аккаунта: %s [%d]", NamePlayer[playerid], PlayerInfo[playerid][pID]);
    return true;
}

 

[370]

SaveHouse(i); покажи мне этот сток или же паблик.