1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
Crash when sohronenie
Marcid
Little Clucker
**
Posts: 28
Threads: 13
Joined: Dec 2013
Reputation: 0
#1

02.03.2014, 15:28
Hello again would crash when saving acc help mysql r7

Код HTML:
forward OnPlayerUpdateRL(playerid);
public OnPlayerUpdateRL(playerid)
{
if(IsPlayerConnected(playerid))
{
if(gPlayerLogged[playerid] == 1)
{
new src[50];new query[2048];
//new playername3[MAX_PLAYER_NAME];
//GetPlayerName(playerid, playername3, sizeof(playername3));
mysql_format(mysql, query, "UPDATE accounts SET ");
//PlayerInfo[playerid][pCash] = GetSRVMoney(playerid);
format(src,sizeof(src),"`pLevel`=%d,",PlayerInfo[playerid][pLevel]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pHs`=%d,",PlayerInfo[playerid][pHs]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pEmail`=%s,",PlayerInfo[playerid][pEmail]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pAdmin`=%d,",PlayerInfo[playerid][pAdmin]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pMestoJail`=%d,",PlayerIn fo[playerid][pMestoJail]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pZvonok`=%d,",PlayerInfo[playerid][pZvonok]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pIp`=%s,",PlayerInfo[playerid][pIp]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pvIp`=%s,",PlayerInfo[playerid][pvIp]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pIpReg`=%s,",PlayerInfo[playerid][pIpReg]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pHousecash`=%d,",PlayerIn fo[playerid][pHousecash]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSSd`=%d,",PlayerInfo[playerid][pSSd]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSDeag`=%d,",PlayerInfo[playerid][pSDeag]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSShot`=%d,",PlayerInfo[playerid][pSShot]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSSMG`=%d,",PlayerInfo[playerid][pSSMG]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSAK`=%d,",PlayerInfo[playerid][pSAK]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSM4`=%d,",PlayerInfo[playerid][pSM4]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSReaf`=%d,",PlayerInfo[playerid][pSReaf]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSNark`=%d,",PlayerInfo[playerid][pSNark]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pProverkaip`=%d,",PlayerI nfo[playerid][pProverkaip]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pText`=%d,",PlayerInfo[playerid][pText]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pKeyip`=%d,",PlayerInfo[playerid][pKeyip]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pHP`=%d,",PlayerInfo[playerid][pHP]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSatiety`=%d,",PlayerInfo[playerid][pSatiety]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pDataReg`=%s,",PlayerInfo[playerid][pDataReg]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pDonate`=%d,",PlayerInfo[playerid][pDonate]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pBanTime`=%d,",PlayerInfo[playerid][pBanTime]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pBanData`=%d,",PlayerInfo[playerid][pBanData]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pCar`=%d,",PlayerInfo[playerid][pCar]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pIns`=%d,",PlayerInfo[playerid][pIns]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pCan`=%d,",PlayerInfo[playerid][pCan]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pOgran`=%d,",PlayerInfo[playerid][pOgran]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pFuelcar`=%f,",PlayerInfo[playerid][pFuelcar]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pProz`=%d,",PlayerInfo[playerid][pProz]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pDonateRank`=%d,",PlayerI nfo[playerid][pDonateRank]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pDonatemoney`=%d,",Player Info[playerid][pDonatemoney]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pReg`=%d,",PlayerInfo[playerid][pReg]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pMats`=%d,",PlayerInfo[playerid][pMats]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSex`=%d,",PlayerInfo[playerid][pSex]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pArrested`=%d,",PlayerInf o[playerid][pArrested]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pMuted`=%d,",PlayerInfo[playerid][pMuted]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pCrimes`=%d,",PlayerInfo[playerid][pCrimes]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pExp`=%d,",PlayerInfo[playerid][pExp]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pCash`=%d,",PlayerInfo[playerid][pCash]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pKills`=%d,",PlayerInfo[playerid][pKills]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pDeaths`=%d,",PlayerInfo[playerid][pDeaths]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pWantedDeaths`=%d,",Playe rInfo[playerid][pWantedDeaths]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pPayCheck`=%d,",PlayerInf o[playerid][pPayCheck]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pJailed`=%d,",PlayerInfo[playerid][pJailed]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pJailTime`=%d,",PlayerInf o[playerid][pJailTime]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pWins`=%d,",PlayerInfo[playerid][pWins]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pLoses`=%d,",PlayerInfo[playerid][pLoses]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pDrugs`=%d,",PlayerInfo[playerid][pDrugs]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pLeader`=%d,",PlayerInfo[playerid][pLeader]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pMember`=%d,",PlayerInfo[playerid][pMember]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pRank`=%d,",PlayerInfo[playerid][pRank]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pChar`=%d,",PlayerInfo[playerid][pChar]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pJob`=%d,",PlayerInfo[playerid][pJob]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pZadanie`=%d,",PlayerInfo[playerid][pZadanie]);strcat(query,src,sizeof(query));
//GetPlayerHealth(playerid,PlayerInfo[playerid][pHealth]);
format(src,sizeof(src),"`pHealth`=%f,",PlayerInfo[playerid][pHealth]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSHealth`=%f,",PlayerInfo[playerid][pSHealth]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pInt`=%d,",PlayerInfo[playerid][pInt]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pLocal`=%d,",PlayerInfo[playerid][pLocal]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pModel`=%d,",PlayerInfo[playerid][pModel]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pPnumber`=%d,",PlayerInfo[playerid][pPnumber]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pPhoneBook`=%d,",PlayerIn fo[playerid][pPhoneBook]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pDirectory`=%d,",PlayerIn fo[playerid][pDirectory]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pVodPrava`=%d,",PlayerInf o[playerid][pVodPrava]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pFlyLic`=%d,",PlayerInfo[playerid][pFlyLic]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pBoatLic`=%d,",PlayerInfo[playerid][pBoatLic]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pFishLic`=%d,",PlayerInfo[playerid][pFishLic]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pGunLic`=%d,",PlayerInfo[playerid][pGunLic]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pBizLic`=%d,",PlayerInfo[playerid][pBizLic]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pNkeys`=%d,",PlayerInfo[playerid][pNkeys]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pPhousekey`=%d,",PlayerIn fo[playerid][pPhousekey]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pPbiskey`=%d,",PlayerInfo[playerid][pPbiskey]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pZakonp`=%d,",PlayerInfo[playerid][pZakonp]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pNarcoZavisimost`=%d,",Pl ayerInfo[playerid][pNarcoZavisimost]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pNarcoLomka`=%d,",PlayerI nfo[playerid][pNarcoLomka]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pPayDay`=%d,",PlayerInfo[playerid][pPayDay]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pPayDayHad`=%d,",PlayerIn fo[playerid][pPayDayHad]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pTut`=1,");strcat(query,s rc,sizeof(query));
format(src,sizeof(src),"`pWarns`=%d,",PlayerInfo[playerid][pWarns]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`punWarns`=%d,",PlayerInfo[playerid][punWarns]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`punWarnstime`=%d,",Player Info[playerid][punWarnstime]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pLechenie`=%d,",PlayerInf o[playerid][pLechenie]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pFuel`=%d,",PlayerInfo[playerid][pFuel]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pMarried`=%d,",PlayerInfo[playerid][pMarried]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pMarriedTo`=%s,",PlayerIn fo[playerid][pMarriedTo]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pDrug`=%s,",PlayerInfo[playerid][pDrug]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pRadio`=%d,",PlayerInfo[playerid][pRadio]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pFishes`=%d,",PlayerInfo[playerid][pFishes]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pDrugmoney`=%d,",PlayerIn fo[playerid][pDrugmoney]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pMuteTime`=%d,",PlayerInf o[playerid][pMuteTime]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pBank`=%d,",PlayerInfo[playerid][pBank]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pDonatechet`=%d,",PlayerI nfo[playerid][pDonatechet]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pMobile`=%d,",PlayerInfo[playerid][pMobile]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pDostup`=%d,",PlayerInfo[playerid][pDostup]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pLocked`=%d,",PlayerInfo[playerid][pLocked]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pDolg`=%d,",PlayerInfo[playerid][pDolg]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pKrisha`=%d,",PlayerInfo[playerid][pKrisha]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pUseKrisha`=%d,",PlayerIn fo[playerid][pUseKrisha]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pZvezdi`=%d,",PlayerInfo[playerid][pZvezdi]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSlot1`=%d,",PlayerInfo[playerid][pSlot1]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSlot2`=%d,",PlayerInfo[playerid][pSlot3]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSlot3`='%d',",PlayerInfo[playerid][pSlot3]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSlot4`='%d',",PlayerInfo[playerid][pSlot4]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSlot5`='%d',",PlayerInfo[playerid][pSlot5]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSlot6`='%d',",PlayerInfo[playerid][pSlot6]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSlot7`='%d',",PlayerInfo[playerid][pSlot7]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSlot8`='%d',",PlayerInfo[playerid][pSlot8]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSlot9`='%d',",PlayerInfo[playerid][pSlot9]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSlot10`='%d',",PlayerInf o[playerid][pSlot10]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSlot11`='%d',",PlayerInf o[playerid][pSlot11]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSlotammo1`='%d',",Player Info[playerid][pSlotammo1]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSlotammo2`='%d',",Player Info[playerid][pSlotammo2]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSlotammo3`='%d',",Player Info[playerid][pSlotammo3]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSlotammo4`='%d',",Player Info[playerid][pSlotammo4]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSlotammo5`='%d',",Player Info[playerid][pSlotammo5]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSlotammo6`='%d',",Player Info[playerid][pSlotammo6]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSlotammo7`='%d',",Player Info[playerid][pSlotammo7]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSlotammo8`='%d',",Player Info[playerid][pSlotammo8]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSlotammo9`='%d',",Player Info[playerid][pSlotammo9]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSlotammo10`='%d',",Playe rInfo[playerid][pSlotammo10]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSlotammo11`='%d',",Playe rInfo[playerid][pSlotammo11]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pGunSkill[0]`='%d',",PlayerInfo[playerid][pGunSkill][0]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pGunSkill[1]`='%d',",PlayerInfo[playerid][pGunSkill][1]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pGunSkill[2]`='%d',",PlayerInfo[playerid][pGunSkill][2]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pGunSkill[3]`='%d',",PlayerInfo[playerid][pGunSkill][3]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pGunSkill[4]`='%d',",PlayerInfo[playerid][pGunSkill][4]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pGunSkill[5]`='%d',",PlayerInfo[playerid][pGunSkill][5]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pDrugtime`='%d',",PlayerI nfo[playerid][pDrugtime]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pBoxstyle`='%d',",PlayerI nfo[playerid][pBoxstyle]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pKstyle`='%d',",PlayerInf o[playerid][pKstyle]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pKickstyle`='%d',",Player Info[playerid][pKickstyle]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pBoxSkill`='%d',",PlayerI nfo[playerid][pBoxSkill]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pKongfuSkill`='%d',",Play erInfo[playerid][pKongfuSkill]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pKickboxSkill`='%d',",Pla yerInfo[playerid][pKickboxSkill]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pFerma`='%d',",PlayerInfo[playerid][pFerma]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pFermazarobotok`='%d',",P layerInfo[playerid][pFermazarobotok]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pFermajob`='%d',",PlayerI nfo[playerid][pFermajob]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pKolesocar`='%d',",Player Info[playerid][pKolesocar]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pPokraska`='%d',",PlayerI nfo[playerid][pPokraska]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pSpoiler`='%d',",PlayerIn fo[playerid][pSpoiler]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pBamper1`='%d',",PlayerIn fo[playerid][pBamper1]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pBamper2`='%d',",PlayerIn fo[playerid][pBamper2]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pCvet`='%d',",PlayerInfo[playerid][pCvet]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pNitro`='%d',",PlayerInfo[playerid][pNitro]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pGidra`='%d',",PlayerInfo[playerid][pGidra]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"`pMyRp`='%d'",PlayerInfo[playerid][pMyRp]);strcat(query,src,sizeof(query));
format(src,sizeof(src)," WHERE Name='%s'",PlayerInfo[playerid][pSendername]);strcat(query,src,sizeof(query));
mysql_function_query(mysql, query, true, "AffectUpdate", "i" ,playerid);
}
}
return true;
}
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 2 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help