Всем привет. Столкнулся с такой проблемой.
Переменные из 1 запроса сохраняет. Переменные из 2 запроса тоже сохраняет, а вот из 3 запроса уже не сохраняет. Как исправить?
Код:stock SaveAccount ( playerid )
{
new float: health;
new float: armour;
GetPlayerHealth(playerid, Float:health);
GetPlayerArmour(playerid, Float:armour);
GetPlayerPos(playerid, PlayerInfo[playerid][pCurrentPos][0], PlayerInfo[playerid][pCurrentPos][1], PlayerInfo[playerid][pCurrentPos][2]);
new query [ 500 ] ;
format ( query, sizeof(query), "UPDATE `users` SET `Age` = '%d',\
`pAdmin` = '%d',\
`pLvL` = '%d',\
`pExp` = '%d',\
`pVirus` = '%d',\
`pZombie` = '%d',\
'pLeader' = '%d',\
`pMember` = '%d',\
`pStatus` = '%d',\
`pZLvL` = '%d',\
`pRep` = '%d',\
'pClLeader' = '%d',\
`pClMember` = '%d',\
`pClSkin` = '%d',\
`pSkin` = '%d',\
`pZSkin` = '%d',\
`pHp` = '%f', \
`pArmour` = '%f',\
`pZaraza` = '%d'\
WHERE `id` = '%d' LIMIT 1",
PlayerInfo [ playerid ] [ Age ],
PlayerInfo [ playerid ] [ pAdmin ],
PlayerInfo [ playerid ] [ pLvL ],
PlayerInfo [ playerid ] [ pExp ],
PlayerInfo [ playerid ] [ pVirus ],
PlayerInfo [ playerid ] [ pZombie ],
PlayerInfo [ playerid ] [ pLeader ],
PlayerInfo [ playerid ] [ pMember ],
PlayerInfo [ playerid ] [ pStatus ],
PlayerInfo [ playerid ] [ pZLvL ],
PlayerInfo [ playerid ] [ pRep ],
PlayerInfo [ playerid ] [ pClLeader ],
PlayerInfo [ playerid ] [ pClMember ],
PlayerInfo [ playerid ] [ pClSkin ],
PlayerInfo [ playerid ] [ pSkin ],
PlayerInfo [ playerid ] [ pZSkin ],
PlayerInfo [ playerid ] [ pHp ],
PlayerInfo [ playerid ] [ pArmour ],
PlayerInfo [ playerid ] [ pZaraza ],
PlayerInfo [ playerid ] [ ID ]) ;
mysql_function_query ( dbHandle, query, false, "", "" ) ;
for (new i = 0; i < 13; i++)
GetPlayerWeaponData(playerid, i, weapons[i][0], weapons[i][1]);
format ( query, sizeof(query), "UPDATE `users` SET \
`gun0` = '%d', `ammo0` = '%d',\
`gun1` = '%d', `ammo1` = '%d',\
`gun2` = '%d', `ammo2` = '%d',\
`gun3` = '%d', `ammo3` = '%d',\
`gun4` = '%d', `ammo4` = '%d',\
`gun5` = '%d', `ammo5` = '%d',\
`gun6` = '%d', `ammo6` = '%d',\
`gun7` = '%d', `ammo7` = '%d',\
`gun8` = '%d', `ammo8` = '%d',\
`gun9` = '%d', `ammo9` = '%d',\
`gun10` = '%d', `ammo10` = '%d',\
`gun11` = '%d', `ammo11` = '%d',\
`gun12` = '%d', `ammo12` = '%d'\
WHERE `id` = '%d' LIMIT 1",
weapons[0][0],
weapons[0][1],
weapons[1][0],
weapons[1][1],
weapons[2][0],
weapons[2][1],
weapons[3][0],
weapons[3][1],
weapons[4][0],
weapons[4][1],
weapons[5][0],
weapons[5][1],
weapons[6][0],
weapons[6][1],
weapons[7][0],
weapons[7][1],
weapons[8][0],
weapons[8][1],
weapons[9][0],
weapons[9][1],
weapons[10][0],
weapons[10][1],
weapons[11][0],
weapons[11][1],
weapons[12][0],
weapons[12][1],
PlayerInfo [ playerid ] [ ID ]) ;
mysql_function_query ( dbHandle, query, false, "", "" ) ;
format ( query, sizeof(query), "UPDATE `users` SET pVIP = '%d', \
`pZExp` = '%d',\
`pTWD` = '%d,'\
`Pos_x` = '%f',\
`Pos_y` = '%f',\
`Pos_z` = '%f',\
`pSex` = '%d'\
WHERE `id` = '%d' LIMIT 1",
PlayerInfo [ playerid ] [ pVIP],
PlayerInfo [ playerid ] [ pZExp],
PlayerInfo [ playerid ] [ pTWD ],
PlayerInfo [ playerid ] [ pCurrentPos ] [ 0 ],
PlayerInfo [ playerid ] [ pCurrentPos ] [ 1 ],
PlayerInfo [ playerid ] [ pCurrentPos ] [ 2 ],
PlayerInfo [ playerid ] [ pSex ],
PlayerInfo [ playerid ] [ ID ]) ;
mysql_function_query ( dbHandle, query, false, "", "" ) ;
return 1;
}
