PDA

Просмотр полной версии : [Вопрос] Не работает сток сохранения игрока


Igor_Stalker
28.06.2016, 23:11
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$
28.06.2016, 23:13
А, что по логам?
Igor_Stalker
28.06.2016, 23:27
А, что по логам?
ничего.Он чистый,просто не сохраняет
StevenH
29.06.2016, 01:20
`Password` = '%s' WHERE `Name` = '%s'";

А в конце:

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

Т.е. в password вставляем ник игрока, и в Name - password, или я чет не вдупляю?)
Found
29.06.2016, 03:40
UPDATE `users` SET \
Перед слэшем поставьте пробел.
BadPawn
29.06.2016, 03:54
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);
}


format(/*...*/, /*...*/, "WHERE `name` = '%s'", playerinfo[playerid][pPassword]);
искал в таблице ник со значением переменной password, и не находил конечно же.

перекопируй в мод и компиль. исправил
Igor_Stalker
29.06.2016, 10:10
`Password` = '%s' WHERE `Name` = '%s'";

А в конце:

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

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

не помогло

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



UPDATE `users` SET \
Перед слэшем поставьте пробел.

не помогло

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



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);
}


format(/*...*/, /*...*/, "WHERE `name` = '%s'", playerinfo[playerid][pPassword]);
искал в таблице ник со значением переменной password, и не находил конечно же.

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

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