stock SaveAccount(playerid)
{
if(!PlayerLogged[playerid]) return true;
new src[90];
format(query
,sizeof(query
),"UPDATE "T_ACCOUNTS
" SET "); format(src
,sizeof(src
),"`ip`='%s',",PI
[playerid
][pIP
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`level`=%d,",PI
[playerid
][pLevel
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`admin`=%d,",PI
[playerid
][pAdmin
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`sex`=%d,",PI
[playerid
][pSex
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`age`=%d,",PI
[playerid
][pAge
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`securitycode`=%i,",PI
[playerid
][pSecurityCode
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`model`=%d,",PI
[playerid
][pModel
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`memberskin`=%d,",PI
[playerid
][pMemberSkin
]); strcat(query
,src
,sizeof(query
)); if(PI[playerid][pCash] > 100000000 || PI[playerid][pCash] < 0) PI[playerid][pCash] = 0;
format(src
,sizeof(src
),"`cash`=%d,",PI
[playerid
][pCash
]); strcat(query
,src
,sizeof(query
)); if(PI[playerid][pBank] > 100000000 || PI[playerid][pBank] < 0) PI[playerid][pBank] = 0;
format(src
,sizeof(src
),"`bank`=%d,",PI
[playerid
][pBank
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`mute`=%d,",PI
[playerid
][pMuted
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`warn`=%d,",PI
[playerid
][pWarn
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`leader`=%d,",PI
[playerid
][pLeader
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`templeader`=%d,",PI
[playerid
][pTempLeader
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`member`=%d,",PI
[playerid
][pMember
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`rank`=%d,",PI
[playerid
][pRank
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`pick`=%d,",PI
[playerid
][pPick
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`exp`=%d,",PI
[playerid
][pExp
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`news`=%d,",PI
[playerid
][pNews
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`crimes`=%d,",PI
[playerid
][pCrimes
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`wanted`=%d,",PI
[playerid
][pWanted
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`wantedtime`=%d,",PI
[playerid
][pWantedTime
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`wantedwho`='%s',",PI
[playerid
][pWantedWho
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`wantedreason`='%s',",PI
[playerid
][pWantedReason
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`jail`=%d,",PI
[playerid
][pJail
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`job`=%d,",PI
[playerid
][pJob
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`jailtime`=%d,",PI
[playerid
][pJailTime
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`checktime`=%d,",PI
[playerid
][pCheckTime
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`drugs`=%d,",PI
[playerid
][pDrugs
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`patron`=%d,",PI
[playerid
][pPatron
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`gunamount`=%d,",PI
[playerid
][pGunAmount
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`heal`='%f',",PI
[playerid
][pHeal
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`married`=%d,",PI
[playerid
][pMarried
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`whomarried`='%s',",PI
[playerid
][pWhoMarried
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`paycheck`=%i,",PI
[playerid
][pPayCheck
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`vip`=%i,",PI
[playerid
][pVip
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`viptime`=%i,",PI
[playerid
][pVipTime
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`time`=%i,",PI
[playerid
][pTime
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`fstyle`=%i,",PI
[playerid
][pFightStyle
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`credits`=%i,",PI
[playerid
][pCredits
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`totalcredits`=%i,",PI
[playerid
][pTotalCredits
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`spawnchange`=%i,",PI
[playerid
][pSpawnChange
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`sdpistol`=%i,",PI
[playerid
][pGunSkill
][0]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`deserteagle`=%i,",PI
[playerid
][pGunSkill
][1]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`shotgun`=%i,",PI
[playerid
][pGunSkill
][2]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`mp5`=%i,",PI
[playerid
][pGunSkill
][3]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`ak47`=%i,",PI
[playerid
][pGunSkill
][4]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`m4`=%i,",PI
[playerid
][pGunSkill
][5]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`healths`='%f',",PI
[playerid
][pHealthS
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`online`=%i,",PI
[playerid
][pOnline
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`zakon`=%i,",PI
[playerid
][pZakon
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`checkcode`=%i,",PI
[playerid
][pCheckCode
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`watch`=%i,",PI
[playerid
][pWatch
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`ciggare`=%i,",PI
[playerid
][pCiggare
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`sprunk`=%i,",PI
[playerid
][pSprunk
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`mask`=%i,",PI
[playerid
][pMask
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`phonebalance`=%i,",PI
[playerid
][pPhoneBalance
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`truckskill`=%i,",PI
[playerid
][pTruckSkill
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`cModel`=%i,",PI
[playerid
][cModel
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`cFuel`=%i,",PI
[playerid
][cFuel
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`cClass`=%i,",PI
[playerid
][cClass
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`cColor1`=%i,",PI
[playerid
][cColor
][0]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`cColor2`=%i,",PI
[playerid
][cColor
][1]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`cLock`=%i,",PI
[playerid
][cLock
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`cCost`=%i,",PI
[playerid
][cCost
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`cVehcom`='%s',",PI
[playerid
][cVehcom
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`cPaintjob`=%i,",PI
[playerid
][cPaintjob
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`aptechka`=%i,",PI
[playerid
][pAptechka
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`Voennik`=%i,",PI
[playerid
][pVoennik
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`music`=%i,",PI
[playerid
][pMusic
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`datavhod`='%s',",date
("%dd.%mm.%yyyy",gettime())); strcat(query
,src
,sizeof(query
)); format(PI
[playerid
][pRepcars
],16,"%i, %i", PI[playerid][pRepcar][0],PI[playerid][pRepcar][1]);
format(src
,sizeof(src
),"`repcar`='%s',",PI
[playerid
][pRepcars
]); strcat(query
,src
,sizeof(query
)); format(PI
[playerid
][pImproves
],32,"%i, %i, %i, %i", PI[playerid][pImprove][0],PI[playerid][pImprove][1],PI[playerid][pImprove][2],PI[playerid][pImprove][3]);
format(src
,sizeof(src
),"`improves`='%s',",PI
[playerid
][pImproves
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`Fishki`=%i,",PI
[playerid
][pFishki
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`coins`=%i,",PI
[playerid
][pCoins
]); strcat(query
,src
,sizeof(query
)); format(src
,sizeof(src
),"`Prize`=%i,",PI
[playerid
][pPrize
]); strcat(query
,src
,sizeof(query
));
format(src
,sizeof(src
),"`phonenumber`=%i,",PI
[playerid
][pPhoneNumber
]); strcat(query
,src
,sizeof(query
));
format(PI
[playerid
][pLics
],16,"%i, %i, %i, %i", PI
[playerid
][pLic
][0],PI
[playerid
][pLic
][1],PI
[playerid
][pLic
][2],PI
[playerid
][pLic
][3]); format(src
,sizeof(src
),"`lic`='%s'",PI
[playerid
][pLics
]); strcat(query
,src
,sizeof(query
));
format(src
,sizeof(src
)," WHERE `name`='%s' LIMIT 1",GetName
(playerid
)); strcat(query
,src
,sizeof(query
));
mysql_tquery(dbHandle, query, "", "");
return true;
}