06.12.2011, 14:55
Hi i dont andustand why my script dont save my acc? What's wrong?
Код:
public SavePlayerData(playerid,bool:simple)
{
if(playerDB[playerid][authstate]>0)
{
if(!simple) GameTextForPlayer(playerid,"~g~ Saugojamas tavo profilis",50000,5);
MySQLCheck();
new
pName[MAX_PLAYER_NAME],
Float:coo[3],
weps[2][12];
GetPlayerName(playerid, pName, MAX_PLAYER_NAME);
//veikia
format(query,256,"UPDATE `"TABLENAME"` SET \
`Pinigai` = '%i', \
`Lytis` = '%i' \
`Uzbanintas` = '%i' \
`Uniforma` = '%i' \
`Apsirenges` = '%i' \
`Skin` = '%i' \
`Kalejimo_Laikas` = '%i' \
`Specialybe` = '%i' \
`Ieskomas` = '%i', \
`Xp` = '%i'\
`Dyrektorius` = '%i' \
WHERE(`PName` = '%s')",\
LIB_GetPlayerMoney(playerid),
playerDB[playerid][lytis],
playerDB[playerid][uzbanintas],
playerDB[playerid][uniforma],
playerDB[playerid][uniformd],
playerDB[playerid][drabuziai],
playerDB[playerid][kalejimo_laikas],
playerDB[playerid][specialybe],
GetPlayerWantedLevel(playerid),
GetPlayerScore(playerid),
playerDB[playerid][plead],pName);
mysql_query(query);
//veikia
for (new tmp=0; tmp<12; tmp++) GetPlayerWeaponData(playerid, tmp, weps[0][tmp], weps[1][tmp]);
format(query,512,"UPDATE `"TABLENAME"` SET `Ginklas0` = '%i', `Ginklas1` = '%i', `Ginklas2` = '%i', `Ginklas3` = '%i', `Ginklas4` = '%i',\
`Ginklas5` = '%i', `Ginklas6` = '%i', `Ginklas7` = '%i', `Ginklas8` = '%i', `Ginklas9` = '%i', `Ginklas10` = '%i', `Ginklas11` = '%i' WHERE (`PName` = '%s')",
weps[0][0],weps[0][1],weps[0][2],weps[0][3],weps[0][4],weps[0][5],weps[0][6],weps[0][7],weps[0][8],weps[0][9],weps[0][10],weps[0][11],pName);
mysql_query(query);
format(query,512,"UPDATE `"TABLENAME"` SET `Ammo0` = '%i', `Ammo1` = '%i', `Ammo2` = '%i', `Ammo3` = '%i', `Ammo4` = '%i', `Ammo5` = '%i',\
`Ammo6` = '%i', `Ammo7` = '%i', `Ammo8` = '%i', `Ammo9` = '%i', `Ammo10` = '%i', `Ammo11` = '%i' WHERE (`PName` = '%s')",
weps[1][0],weps[1][1],weps[1][2],weps[1][3],weps[1][4],weps[1][5],weps[1][6],weps[1][7],weps[1][8],weps[1][9],weps[1][10],weps[1][11],pName);
mysql_query(query);
//veikia
if(!simple)
{
GetPlayerPos(playerid,coo[0],coo[1],coo[2]);
format(query,256,"UPDATE `"TABLENAME"` SET `pos_X` = '%f', `pos_Y` = '%f', `pos_Z` = '%f',\
`Interior` = '%i', `World` = '%i' WHERE (`PName` = '%s')",\
coo[0],coo[1],coo[2],GetPlayerInterior(playerid),GetPlayerVirtualWorld(playerid),pName);
mysql_query(query);
playerDB[playerid][authstate]=4;
GameTextForPlayer(playerid,"~g~ Vartotojas issaugotas",1000,5);
}
}
}