Не полностью сохраняется акк MySql
Аккаунт не полностью сохраняется, а именно не сохраняется фракция в которой ты находишься
Код:
PHP код:
stock Saveaccounts()
{
foreach(i) { OnPlayerSaveAccount(i); }
}
PHP код:
stock OnPlayerSaveAccount(playerid)
{
if(PlayerInfo[playerid][pLogin] == 1)
{
new str[700];
mysql_format(connects, str,BIG_SIZE,"UPDATE `accounts` SET `pLevel` = '%d',`pPhousekey` = '%d',`pPbiskey` = '%d',`pPsbiskey` = '%d',`bAdmin` = '%d',`pFuelcar` = '%f',`pHeadValue` = '%d',`pContract` = '%d',`pCar` = '%d',`pCar2` = '%d',`pHelper` = '%d' WHERE `Name` = '%s'",
PlayerInfo[playerid][pLevel],
PlayerInfo[playerid][pPhousekey],PlayerInfo[playerid][pPbiskey],
PlayerInfo[playerid][pPsbiskey],PlayerInfo[playerid][bAdmin],
PlayerInfo[playerid][pFuelcar],
PlayerInfo[playerid][pHeadValue],PlayerInfo[playerid][pContract],
PlayerInfo[playerid][pCar],PlayerInfo[playerid][pCar2], PlayerInfo[playerid][pHelper],PlayerInfo[playerid][pNames]);
mysql_tquery(connects, str);
mysql_format(connects, str,BIG_SIZE,"UPDATE `accounts` SET `pDMInections` = '%d',`pDRInections` = '%d',`pDRInectionsTime` = '%d',`pReg` = '%d',`pSex` = '%d',`pMuted` = '%d',`pExp` = '%d',`pCash` = '%d',`pKills` = '%d',`pJailed` = '%d',`pJailTime` = '%d',`pMats` = '%d',`pDrugs` = '%d',`pLRInections` = '%d',`pMRInections` = '%d' WHERE `Name` = '%s'",
PlayerInfo[playerid][pDMInections],
PlayerInfo[playerid][pDRInections],PlayerInfo[playerid][pDRInectionsTime],
PlayerInfo[playerid][pReg],PlayerInfo[playerid][pSex],
PlayerInfo[playerid][pMuted],PlayerInfo[playerid][pExp],
PlayerInfo[playerid][pCash],PlayerInfo[playerid][pKills],
PlayerInfo[playerid][pJailed],PlayerInfo[playerid][pJailTime],
PlayerInfo[playerid][pMats],PlayerInfo[playerid][pDrugs],
PlayerInfo[playerid][pLRInections],PlayerInfo[playerid][pMRInections],PlayerInfo[playerid][pNames]);
mysql_tquery(connects, str);
mysql_format(connects, str,BIG_SIZE,"UPDATE `accounts` SET `pRKInections` = '%d',`pJob` = '%d',`pVodPrava` = '%d',`pBizLic` = '%d',`pFlyLic` = '%d',`pBoatLic` = '%d',`pFishLic` = '%d',`pGunLic` = '%d' WHERE `Name` = '%s'",
PlayerInfo[playerid][pRKInections],PlayerInfo[playerid][pJob],
PlayerInfo[playerid][pVodPrava],PlayerInfo[playerid][pBizLic],
PlayerInfo[playerid][pFlyLic],PlayerInfo[playerid][pBoatLic],
PlayerInfo[playerid][pFishLic],PlayerInfo[playerid][pGunLic],PlayerInfo[playerid][pNames]);
mysql_tquery(connects, str);
mysql_format(connects, str,BIG_SIZE,"UPDATE `accounts` SET `pSDPistol` = '%d',`pDesertEagle` = '%d',`pShotGun` = '%d',`pMP5` = '%d',`pAK47` = '%d',`pM4` = '%d',`pChar` = '%d',`pModel` = '%d' WHERE `Name` = '%s'",
PlayerInfo[playerid][pSDPistol],
PlayerInfo[playerid][pDesertEagle],PlayerInfo[playerid][pShotGun],
PlayerInfo[playerid][pMP5],PlayerInfo[playerid][pAK47],
PlayerInfo[playerid][pM4],PlayerInfo[playerid][pChar],
PlayerInfo[playerid][pModel],PlayerInfo[playerid][pNames]);
mysql_tquery(connects, str);
mysql_format(connects, str,BIG_SIZE,"UPDATE `accounts` SET `pPnumber` = '%d',`pPayDayHad` = '%d',`pWarns` = '%d',`punWarns` = '%d',`punWarnstime` = '%d',`pFuel` = '%d',`pRobTime` = '%d',`pExitTied` = '%d',`pExitTiedNomer` = '%d',`pGrabSkill` = '%d',`pGrabTime` = '%d',`pReportTime` = '%d',`pVerevka` = '%d',`pOtmbI4ka` = '%d',`pAutoTime` = '%d' WHERE `Name` = '%s'",
PlayerInfo[playerid][pPnumber],PlayerInfo[playerid][pPayDayHad],
PlayerInfo[playerid][pWarns],PlayerInfo[playerid][punWarns],
PlayerInfo[playerid][punWarnstime],PlayerInfo[playerid][pFuel],
PlayerInfo[playerid][pRobTime],PlayerInfo[playerid][pExitTied],
PlayerInfo[playerid][pExitTiedNomer],PlayerInfo[playerid][pGrabSkill],
PlayerInfo[playerid][pGrabTime],PlayerInfo[playerid][pReportTime],
PlayerInfo[playerid][pVerevka],PlayerInfo[playerid][pOtmbI4ka],
PlayerInfo[playerid][pAutoTime],PlayerInfo[playerid][pNames]);
mysql_tquery(connects, str);
mysql_format(connects, str,BIG_SIZE,"UPDATE `accounts` SET `pAutoSkill` = '%d',`pMarried` = '%d',`pMuteTime` = '%d',`pMobile` = '%d',`pBank` = '%d',`pBoxSkill` = '%d',`pKongfuSkill` = '%d',`pKickboxSkill` = '%d',`pFightSkill` = '%d',`pFightSkil` = '%d',`pFightTime` = '%d',`pHospital` = '%d',`pDostup` = '%d',`pBoss` = '%d',`pZakonp` = '%d' WHERE `Name` = '%s'",
PlayerInfo[playerid][pAutoSkill],PlayerInfo[playerid][pMarried],
PlayerInfo[playerid][pMuteTime],PlayerInfo[playerid][pMobile],
PlayerInfo[playerid][pBank],
PlayerInfo[playerid][pBoxSkill],PlayerInfo[playerid][pKongfuSkill],
PlayerInfo[playerid][pKickboxSkill],PlayerInfo[playerid][pFightSkill],
PlayerInfo[playerid][pFightSkil],PlayerInfo[playerid][pFightTime],
PlayerInfo[playerid][pHospital],PlayerInfo[playerid][pDostup],
PlayerInfo[playerid][pBoss],PlayerInfo[playerid][pZakonp],PlayerInfo[playerid][pNames]);
mysql_tquery(connects, str);
mysql_format(connects, str,BIG_SIZE,"UPDATE `accounts` SET `pVipTime` = '%d',`pHouse` = '%d',`pVipData` = '%d',`pProz` = '%d',`pKolesocar` = '%d',`pPokraska` = '%d',`pSpoiler` = '%d',`pHood` = '%d',`pExhaust` = '%d',`pLamps` = '%d',`pSideskirt` = '%d',`pVozdyx` = '%d',`pVcol1` = '%d',`pVcol2` = '%d',`pBamper1` = '%d',`pBamper2` = '%d' WHERE `Name` = '%s'",
PlayerInfo[playerid][pVipTime],PlayerInfo[playerid][pHouse],
PlayerInfo[playerid][pVipData],PlayerInfo[playerid][pProz],
PlayerInfo[playerid][pKolesocar],PlayerInfo[playerid][pPokraska],
PlayerInfo[playerid][pSpoiler],PlayerInfo[playerid][pHood],
PlayerInfo[playerid][pExhaust],PlayerInfo[playerid][pLamps],
PlayerInfo[playerid][pSideskirt],PlayerInfo[playerid][pVozdyx],
PlayerInfo[playerid][pVcol1],PlayerInfo[playerid][pVcol2],
PlayerInfo[playerid][pBamper1],PlayerInfo[playerid][pBamper2],PlayerInfo[playerid][pNames]);
mysql_tquery(connects, str);
mysql_format(connects, str,BIG_SIZE,"UPDATE `accounts` SET `pPhone` = '%s',`pTut` = '%d',`pNumbercar` = '%s',`pIpReg` = '%s',`family` = '%d' WHERE `Name` = '%s'",
PlayerInfo[playerid][pPhone],PlayerInfo[playerid][pTut],
PlayerInfo[playerid][pNumbercar],PlayerInfo[playerid][pIpReg],
player_family[playerid],PlayerInfo[playerid][pNames]);
mysql_tquery(connects, str);
printf("Àêêàóíò %s óñïåøíî ñîõðàíåí (ID %d)",PlayerInfo[playerid][pNames],strlen(str));
}
else printf("Îøèáêà ñîõðàí¸íèÿ.");
return true;
}
