Не работает сток сохранения игрока

Код HTML:

---

stock SaveAccounts(playerid)
{
        static
            save[] = "UPDATE `users` SET\
            `Money` = %d,\
            `Heal` = %f,\
            `Armour` = %f,\
            `Lvl` = %d,\
            `Respect` = %d,\
                `Admin` = %d,\
                `Vip` = %d,\
                `X10` = %d,\
                `Donate` = %d,\
                `Skin` = %d,\
                `Warn` = %d,\
                `Mute` = %d,\
                `Tainik1` = %d,\
                `Tainik2` = %d,\
                `Tainik3` = %d,\
                `Xleb` = %d,\
                `Kolbaca` = %d,\
                `Vodka` = %d,\
                `Redbull` = %d,\
                `Zp` = %d,\
                `House` = %d,\
                `Safe` = %d,\
                `Car` = %d,\
                `Color1` = %d,\
                `Color2` = %d,\
                `Remka` = %d,\
                `Fuel` = %f,\
                `Golod` = %d,\
                `Drink` = %d,\
                `Pis` = %d,\
                `Rad` = %d,\
                `Teplo` = %d,\
                `Members` = %d,\
                `RBandit` = %d,\
                `RZombi` = %d,\
                `RVoen` = %d,\
                `RMonolit` = %d,\
                `RYch` = %d,\
                `X` = %f,\
                `Y` = %f,\
                `Z` = %f,\
                `Xf` = %f,\
                `Yf` = %f,\
                `Zf` = %f,\
                `Map` = %d,\
                `Bonus` = %d,\
                `Spichka` = %d,\
                `Drova` = %d,\
                `Kanistra` = %d,\
                `Ydochka` = %d,\
                `Cherv` = %d,\
                `Fish` = %d,\
                `Antirad` = %d,\
                `ZCidor` = %d,\
                `Bolezn` = %d,\
                `Geroin` = %d,\
                `Travka` = %d,\
                `TZavis` = %d,\
                `GZavis` = %d,\
                `Alkogolizm` = %d,\
                `Password` = '%s' WHERE `Name` = '%s'";
        new string[sizeof(save)+(-120+11+3+3+3+1+1+2+2+5+3+4+1+1+1+2+2+2+2+2+4+11+3+3+3+2+3+3+3+3+3+3+1+2+2+2+2+2+10+10+9+10+10+9+1+2+3+2+2+1+3+3+2+1+1+2+2+1+1+1+21+MAX_PLAYER_NAME+1)];
        format(string,sizeof(string),save,
        PlayerInfo[playerid][pMoney],
        PlayerInfo[playerid][pHeal],
        PlayerInfo[playerid][pArmour],
        PlayerInfo[playerid][pLvl],
        PlayerInfo[playerid][pRespect],
        PlayerInfo[playerid][pAdmin],
        PlayerInfo[playerid][pVip],
        PlayerInfo[playerid][pX10],
        PlayerInfo[playerid][pDonate],
        PlayerInfo[playerid][pSkin],
        PlayerInfo[playerid][pWarn],
        PlayerInfo[playerid][pMute],
        PlayerInfo[playerid][pTainik1],
        PlayerInfo[playerid][pTainik2],
        PlayerInfo[playerid][pTainik3],
        PlayerInfo[playerid][pXleb],
        PlayerInfo[playerid][pKolbaca],
        PlayerInfo[playerid][pVodka],
        PlayerInfo[playerid][pRedbull],
        PlayerInfo[playerid][pZp],
        PlayerInfo[playerid][pHouse],
        PlayerInfo[playerid][pSafe],
        PlayerInfo[playerid][pCar],
        PlayerInfo[playerid][pColor1],
        PlayerInfo[playerid][pColor2],
        PlayerInfo[playerid][pRemka],
        PlayerInfo[playerid][pFuel],
        PlayerInfo[playerid][pGolod],
        PlayerInfo[playerid][pDrink],
        PlayerInfo[playerid][pPis],
        PlayerInfo[playerid][pRad],
        PlayerInfo[playerid][pTeplo],
        PlayerInfo[playerid][pMembers],
        PlayerInfo[playerid][pRBandit],
        PlayerInfo[playerid][pRZombi],
        PlayerInfo[playerid][pRVoen],
        PlayerInfo[playerid][pRMonolit],
        PlayerInfo[playerid][pRYch],
        PlayerInfo[playerid][pX],
        PlayerInfo[playerid][pY],
        PlayerInfo[playerid][pZ],
        PlayerInfo[playerid][pXf],
        PlayerInfo[playerid][pYf],
        PlayerInfo[playerid][pZf],
        PlayerInfo[playerid][pMap],
        PlayerInfo[playerid][pBonus],
        PlayerInfo[playerid][pSpichka],
        PlayerInfo[playerid][pDrova],
        PlayerInfo[playerid][pKanistra],
        PlayerInfo[playerid][pYdochka],
        PlayerInfo[playerid][pCherv],
        PlayerInfo[playerid][pFish],
        PlayerInfo[playerid][pAntirad],
        PlayerInfo[playerid][pZCidor],
        PlayerInfo[playerid][pBolezn],
        PlayerInfo[playerid][pGeroin],
        PlayerInfo[playerid][pTravka],
        PlayerInfo[playerid][pTZavis],
        PlayerInfo[playerid][pGZavis],
        PlayerInfo[playerid][pAlkogolizm],
        GN(playerid),
        PlayerInfo[playerid][pPassword]);
    mysql_function_query(Mysql_Connect,string,0,"","");
    PlayerInfo[playerid][pMoney] = Money(playerid);
}

---

Как исправить?

А, что по логам?

Цитата:

---

Сообщение от $continue$

А, что по логам?

---

ничего.Он чистый,просто не сохраняет

PHP код:

---

`Password` = '%s' WHERE `Name` = '%s'"; 


---

А в конце:

PHP код:

---

GN(playerid), PlayerInfo[playerid][pPassword]); 


---

Т.е. в password вставляем ник игрока, и в Name - password, или я чет не вдупляю?)

PHP код:

---

UPDATE `users` SET \ 


---

Перед слэшем поставьте пробел.

PHP код:

---

stock SaveAccounts(playerid)
{
    static const
        save[] = "UPDATE `users` SET \
        `Money` = '%d',\
        `Heal` = '%f',\
        `Armour` = '%f',\
        `Lvl` = '%d',\
        `Respect` = '%d',\
        `Admin` = '%d',\
        `Vip` = '%d',\
        `X10` = '%d',\
        `Donate` = '%d',\
        `Skin` = '%d',\
        `Warn` = '%d',\
        `Mute` = '%d',\
        `Tainik1` = '%d',\
        `Tainik2` = '%d',\
        `Tainik3` = '%d',\
        `Xleb` = '%d',\
        `Kolbaca` = '%d',\
        `Vodka` = '%d',\
        `Redbull` = '%d',\
        `Zp` = '%d',\
        `House` = '%d',\
        `Safe` = '%d',\
        `Car` = '%d',\
        `Color1` = '%d',\
        `Color2` = '%d',\
        `Remka` = '%d',\
        `Fuel` = '%f',\
        `Golod` = '%d',\
        `Drink` = '%d',\
        `Pis` = '%d',\
        `Rad` = '%d',\
        `Teplo` = '%d',\
        `Members` = '%d',\
        `RBandit` = '%d',\
        `RZombi` = '%d',\
        `RVoen` = '%d',\
        `RMonolit` = '%d',\
        `RYch` = '%d',\
        `X` = '%f',\
        `Y` = '%f',\
        `Z` = '%f',\
        `Xf` = '%f',\
        `Yf` = '%f',\
        `Zf` = '%f',\
        `Map` = '%d',\
        `Bonus` = '%d',\
        `Spichka` = '%d',\
        `Drova` = '%d',\
        `Kanistra` = '%d',\
        `Ydochka` = '%d',\
        `Cherv` = '%d',\
        `Fish` = '%d',\
        `Antirad` = '%d',\
        `ZCidor` = '%d',\
        `Bolezn` = '%d',\
        `Geroin` = '%d',\
        `Travka` = '%d',\
        `TZavis` = '%d',\
        `GZavis` = '%d',\
        `Alkogolizm` = '%d',\
        `Password` = '%s' WHERE `Name` = '%s'";
    new string[sizeof(save)+(-120+11+3+3+3+1+1+2+2+5+3+4+1+1+1+2+2+2+2+2+4+11+3+3+3+2+3+3+3+3+3+3+1+2+2+2+2+2+10+10+9+10+10+9+1+2+3+2+2+1+3+3+2+1+1+2+2+1+1+1+21+MAX_PLAYER_NAME+1)];
    format(string,sizeof(string),save,
    PlayerInfo[playerid][pMoney],
    PlayerInfo[playerid][pHeal],
    PlayerInfo[playerid][pArmour],
    PlayerInfo[playerid][pLvl],
    PlayerInfo[playerid][pRespect],
    PlayerInfo[playerid][pAdmin],
    PlayerInfo[playerid][pVip],
    PlayerInfo[playerid][pX10],
    PlayerInfo[playerid][pDonate],
    PlayerInfo[playerid][pSkin],
    PlayerInfo[playerid][pWarn],
    PlayerInfo[playerid][pMute],
    PlayerInfo[playerid][pTainik1],
    PlayerInfo[playerid][pTainik2],
    PlayerInfo[playerid][pTainik3],
    PlayerInfo[playerid][pXleb],
    PlayerInfo[playerid][pKolbaca],
    PlayerInfo[playerid][pVodka],
    PlayerInfo[playerid][pRedbull],
    PlayerInfo[playerid][pZp],
    PlayerInfo[playerid][pHouse],
    PlayerInfo[playerid][pSafe],
    PlayerInfo[playerid][pCar],
    PlayerInfo[playerid][pColor1],
    PlayerInfo[playerid][pColor2],
    PlayerInfo[playerid][pRemka],
    PlayerInfo[playerid][pFuel],
    PlayerInfo[playerid][pGolod],
    PlayerInfo[playerid][pDrink],
    PlayerInfo[playerid][pPis],
    PlayerInfo[playerid][pRad],
    PlayerInfo[playerid][pTeplo],
    PlayerInfo[playerid][pMembers],
    PlayerInfo[playerid][pRBandit],
    PlayerInfo[playerid][pRZombi],
    PlayerInfo[playerid][pRVoen],
    PlayerInfo[playerid][pRMonolit],
    PlayerInfo[playerid][pRYch],
    PlayerInfo[playerid][pX],
    PlayerInfo[playerid][pY],
    PlayerInfo[playerid][pZ],
    PlayerInfo[playerid][pXf],
    PlayerInfo[playerid][pYf],
    PlayerInfo[playerid][pZf],
    PlayerInfo[playerid][pMap],
    PlayerInfo[playerid][pBonus],
    PlayerInfo[playerid][pSpichka],
    PlayerInfo[playerid][pDrova],
    PlayerInfo[playerid][pKanistra],
    PlayerInfo[playerid][pYdochka],
    PlayerInfo[playerid][pCherv],
    PlayerInfo[playerid][pFish],
    PlayerInfo[playerid][pAntirad],
    PlayerInfo[playerid][pZCidor],
    PlayerInfo[playerid][pBolezn],
    PlayerInfo[playerid][pGeroin],
    PlayerInfo[playerid][pTravka],
    PlayerInfo[playerid][pTZavis],
    PlayerInfo[playerid][pGZavis],
    PlayerInfo[playerid][pAlkogolizm],
    PlayerInfo[playerid][pPassword],
    GN(playerid));
    mysql_function_query(Mysql_Connect,string,false,"","");
    PlayerInfo[playerid][pMoney] = Money(playerid);
} 


---

PHP код:

---

format(/*...*/, /*...*/, "WHERE `name` = '%s'", playerinfo[playerid][pPassword]); 


---

искал в таблице ник со значением переменной password, и не находил конечно же.

перекопируй в мод и компиль. исправил

Цитата:

---

Сообщение от StevenH

PHP код:

---

`Password` = '%s' WHERE `Name` = '%s'"; 


---

А в конце:

PHP код:

---

GN(playerid), PlayerInfo[playerid][pPassword]); 


---

Т.е. в password вставляем ник игрока, и в Name - password, или я чет не вдупляю?)

---

не помогло

- - - Добавлено - - -

Цитата:

---

Сообщение от Found

PHP код:

---

UPDATE `users` SET \ 


---

Перед слэшем поставьте пробел.

---

не помогло

- - - Добавлено - - -

Цитата:

---

Сообщение от BadPawn

PHP код:

---

stock SaveAccounts(playerid)
{
    static const
        save[] = "UPDATE `users` SET \
        `Money` = '%d',\
        `Heal` = '%f',\
        `Armour` = '%f',\
        `Lvl` = '%d',\
        `Respect` = '%d',\
        `Admin` = '%d',\
        `Vip` = '%d',\
        `X10` = '%d',\
        `Donate` = '%d',\
        `Skin` = '%d',\
        `Warn` = '%d',\
        `Mute` = '%d',\
        `Tainik1` = '%d',\
        `Tainik2` = '%d',\
        `Tainik3` = '%d',\
        `Xleb` = '%d',\
        `Kolbaca` = '%d',\
        `Vodka` = '%d',\
        `Redbull` = '%d',\
        `Zp` = '%d',\
        `House` = '%d',\
        `Safe` = '%d',\
        `Car` = '%d',\
        `Color1` = '%d',\
        `Color2` = '%d',\
        `Remka` = '%d',\
        `Fuel` = '%f',\
        `Golod` = '%d',\
        `Drink` = '%d',\
        `Pis` = '%d',\
        `Rad` = '%d',\
        `Teplo` = '%d',\
        `Members` = '%d',\
        `RBandit` = '%d',\
        `RZombi` = '%d',\
        `RVoen` = '%d',\
        `RMonolit` = '%d',\
        `RYch` = '%d',\
        `X` = '%f',\
        `Y` = '%f',\
        `Z` = '%f',\
        `Xf` = '%f',\
        `Yf` = '%f',\
        `Zf` = '%f',\
        `Map` = '%d',\
        `Bonus` = '%d',\
        `Spichka` = '%d',\
        `Drova` = '%d',\
        `Kanistra` = '%d',\
        `Ydochka` = '%d',\
        `Cherv` = '%d',\
        `Fish` = '%d',\
        `Antirad` = '%d',\
        `ZCidor` = '%d',\
        `Bolezn` = '%d',\
        `Geroin` = '%d',\
        `Travka` = '%d',\
        `TZavis` = '%d',\
        `GZavis` = '%d',\
        `Alkogolizm` = '%d',\
        `Password` = '%s' WHERE `Name` = '%s'";
    new string[sizeof(save)+(-120+11+3+3+3+1+1+2+2+5+3+4+1+1+1+2+2+2+2+2+4+11+3+3+3+2+3+3+3+3+3+3+1+2+2+2+2+2+10+10+9+10+10+9+1+2+3+2+2+1+3+3+2+1+1+2+2+1+1+1+21+MAX_PLAYER_NAME+1)];
    format(string,sizeof(string),save,
    PlayerInfo[playerid][pMoney],
    PlayerInfo[playerid][pHeal],
    PlayerInfo[playerid][pArmour],
    PlayerInfo[playerid][pLvl],
    PlayerInfo[playerid][pRespect],
    PlayerInfo[playerid][pAdmin],
    PlayerInfo[playerid][pVip],
    PlayerInfo[playerid][pX10],
    PlayerInfo[playerid][pDonate],
    PlayerInfo[playerid][pSkin],
    PlayerInfo[playerid][pWarn],
    PlayerInfo[playerid][pMute],
    PlayerInfo[playerid][pTainik1],
    PlayerInfo[playerid][pTainik2],
    PlayerInfo[playerid][pTainik3],
    PlayerInfo[playerid][pXleb],
    PlayerInfo[playerid][pKolbaca],
    PlayerInfo[playerid][pVodka],
    PlayerInfo[playerid][pRedbull],
    PlayerInfo[playerid][pZp],
    PlayerInfo[playerid][pHouse],
    PlayerInfo[playerid][pSafe],
    PlayerInfo[playerid][pCar],
    PlayerInfo[playerid][pColor1],
    PlayerInfo[playerid][pColor2],
    PlayerInfo[playerid][pRemka],
    PlayerInfo[playerid][pFuel],
    PlayerInfo[playerid][pGolod],
    PlayerInfo[playerid][pDrink],
    PlayerInfo[playerid][pPis],
    PlayerInfo[playerid][pRad],
    PlayerInfo[playerid][pTeplo],
    PlayerInfo[playerid][pMembers],
    PlayerInfo[playerid][pRBandit],
    PlayerInfo[playerid][pRZombi],
    PlayerInfo[playerid][pRVoen],
    PlayerInfo[playerid][pRMonolit],
    PlayerInfo[playerid][pRYch],
    PlayerInfo[playerid][pX],
    PlayerInfo[playerid][pY],
    PlayerInfo[playerid][pZ],
    PlayerInfo[playerid][pXf],
    PlayerInfo[playerid][pYf],
    PlayerInfo[playerid][pZf],
    PlayerInfo[playerid][pMap],
    PlayerInfo[playerid][pBonus],
    PlayerInfo[playerid][pSpichka],
    PlayerInfo[playerid][pDrova],
    PlayerInfo[playerid][pKanistra],
    PlayerInfo[playerid][pYdochka],
    PlayerInfo[playerid][pCherv],
    PlayerInfo[playerid][pFish],
    PlayerInfo[playerid][pAntirad],
    PlayerInfo[playerid][pZCidor],
    PlayerInfo[playerid][pBolezn],
    PlayerInfo[playerid][pGeroin],
    PlayerInfo[playerid][pTravka],
    PlayerInfo[playerid][pTZavis],
    PlayerInfo[playerid][pGZavis],
    PlayerInfo[playerid][pAlkogolizm],
    PlayerInfo[playerid][pPassword],
    GN(playerid));
    mysql_function_query(Mysql_Connect,string,false,"","");
    PlayerInfo[playerid][pMoney] = Money(playerid);
} 


---

PHP код:

---

format(/*...*/, /*...*/, "WHERE `name` = '%s'", playerinfo[playerid][pPassword]); 


---

искал в таблице ник со значением переменной password, и не находил конечно же.

перекопируй в мод и компиль. исправил

---

Спасибо большое.Теперь сохраняет!