Vova_Jonson#
Умник
Всем привет,у меня было сохранение аккаунтов каждые 900 секунд.Я убрал это потом сами акк сохранятся но дома,лвл,лицензии и т.д. не сохраняются когда игрок перезаходит!
Кто поможет с меня 20+сиков.
Кто поможет с меня 20+сиков.
PHP:
stock SaveAccount(playerid)
{
if(PlayerLogged[playerid] == 0) return true;
new src[512], ip[16];
format(query,sizeof(query),"UPDATE "TABLE_ACCOUNT" SET ");
GetPlayerIp(playerid, ip, 16);
format(src,sizeof(src),"ip='%s',",ip);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"level=%d,",PlayerInfo[playerid][pLevel]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"admin=%d,",PlayerInfo[playerid][pAdmin]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"sex=%d,",PlayerInfo[playerid][pSex]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"ippassword='%s',",PlayerInfo[playerid][pIpPassword]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"model=%d,",PlayerInfo[playerid][pModel]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"loach=%d,",PlayerInfo[playerid][pChar]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cash=%d,",GetMoney(playerid));
strcat(query,src,sizeof(query));
format(src,sizeof(src),"bank=%d,",PlayerInfo[playerid][pBank]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"mute=%d,",PlayerInfo[playerid][pMuted]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"warn=%d,",PlayerInfo[playerid][pWarn]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"leader=%d,",PlayerInfo[playerid][pLeader]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"member=%d,",PlayerInfo[playerid][pMember]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"rank=%d,",PlayerInfo[playerid][pRank]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"Voennik=%d,",PlayerInfo[playerid][pVoennik]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"pick=%d,",PlayerInfo[playerid][pPick]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"exp=%d,",PlayerInfo[playerid][pExp]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"news=%d,",PlayerInfo[playerid][pNews]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"crimes=%d,",PlayerInfo[playerid][pCrimes]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"wanted=%d,",PlayerInfo[playerid][pWanted]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"wantedtime=%d,",PlayerInfo[playerid][pWantedTime]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"wantedwho='%s',",PlayerInfo[playerid][pWantedWho]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"wantedreason='%s',",PlayerInfo[playerid][pWantedReason]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"jail=%d,",PlayerInfo[playerid][pJail]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"job=%d,",PlayerInfo[playerid][pJob]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"jailtime=%d,",PlayerInfo[playerid][pJailTime]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"checktime=%d,",PlayerInfo[playerid][pCheckTime]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"drugs=%d,",PlayerInfo[playerid][pDrugs]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"mats=%d,",PlayerInfo[playerid][pMats]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"heal='%f',",PlayerInfo[playerid][pHeal]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"married=%d,",PlayerInfo[playerid][pMarried]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"whomarried='%s',",PlayerInfo[playerid][pWhoMarried]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"paycheck='%i',",PlayerInfo[playerid][pPayCheck]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"fishing='%i',",PlayerInfo[playerid][pFish]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"lottery='%i',",PlayerInfo[playerid][pLottery]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"vip='%i',",PlayerInfo[playerid][pVIP]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"time='%i',",PlayerInfo[playerid][pTime]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"fstyle='%i',",PlayerInfo[playerid][pFightStyle]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"credits='%i',",PlayerInfo[playerid][pCredits]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"totalcredits='%i',",PlayerInfo[playerid][pTotalCredits]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"skin1='%i',",PlayerInfo[playerid][pSkin1]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"skin2='%i',",PlayerInfo[playerid][pSkin2]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"skin3='%i',",PlayerInfo[playerid][pSkin3]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"spawnchange='%i',",PlayerInfo[playerid][pSpawnChange]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"sdpistol='%i',",PlayerInfo[playerid][pGunSkill][0]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"deserteagle='%i',",PlayerInfo[playerid][pGunSkill][1]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"shotgun='%i',",PlayerInfo[playerid][pGunSkill][2]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"mp5='%i',",PlayerInfo[playerid][pGunSkill][3]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"ak47='%i',",PlayerInfo[playerid][pGunSkill][4]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"m4='%i',",PlayerInfo[playerid][pGunSkill][5]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"satiety='%i',",PlayerInfo[playerid][pSatiety]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"healths='%f',",PlayerInfo[playerid][pHealthS]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"sportexp='%i',",PlayerInfo[playerid][pSportEXP]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"online='%i',",PlayerInfo[playerid][pOnline]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"zakon='%i',",PlayerInfo[playerid][pZakon]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"ipcheck='%i',",PlayerInfo[playerid][ProverkaIP]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"hospital='%i',",PlayerInfo[playerid][pHospital]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"watch='%i',",PlayerInfo[playerid][pWatch]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"ciggare='%i',",PlayerInfo[playerid][pCiggare]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"sprunk='%i',",PlayerInfo[playerid][pSprunk]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"mask='%i',",PlayerInfo[playerid][pMask]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"phonebalance='%i',",PlayerInfo[playerid][pPhoneBalance]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"truckskill='%i',",PlayerInfo[playerid][pTruckSkill]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cModel='%i',",PlayerInfo[playerid][cModel]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cFuel='%i',",PlayerInfo[playerid][cFuel]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cClass='%i',",PlayerInfo[playerid][cClass]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cColor1='%i',",PlayerInfo[playerid][cColor][0]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cColor2='%i',",PlayerInfo[playerid][cColor][0]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cLock='%i',",PlayerInfo[playerid][cLock]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cCost='%i',",PlayerInfo[playerid][cCost]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cVehcom='%s',",PlayerInfo[playerid][cVehcom]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cPaintjob='%i',",PlayerInfo[playerid][cPaintjob]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"Dostup='%i',",PlayerInfo[playerid][pDostup]);
strcat(query,src,sizeof(query));
format(PlayerInfo[playerid][pPhones],16,"%i, %i, %i",
PlayerInfo[playerid][pPhone][0],PlayerInfo[playerid][pPhone][1], PlayerInfo[playerid][pPhone][2]);
format(src,sizeof(src),"phone='%s',",PlayerInfo[playerid][pPhones]);
strcat(query,src,sizeof(query));
format(PlayerInfo[playerid][pLics],40,"%i, %i, %i, %i, %i",
PlayerInfo[playerid][pLic][0],PlayerInfo[playerid][pLic][1],PlayerInfo[playerid][pLic][2]
,PlayerInfo[playerid][pLic][3],PlayerInfo[playerid][pLic][4]);
format(src,sizeof(src),"lic='%s',",PlayerInfo[playerid][pLics]);
strcat(query,src,sizeof(query));
if(GetPVarInt(playerid, "GunCheat") == 0)
{
for(new i = 0; i < 13; i++)
{
GetPlayerWeaponData(playerid, i, PlayerInfo[playerid][pGun][i], PlayerInfo[playerid][pAmmo][i]);
}
format(PlayerInfo[playerid][pGuns],40,"%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d",
PlayerInfo[playerid][pGun][0],PlayerInfo[playerid][pGun][1],PlayerInfo[playerid][pGun][2],
PlayerInfo[playerid][pGun][3],PlayerInfo[playerid][pGun][4],PlayerInfo[playerid][pGun][5],
PlayerInfo[playerid][pGun][6],PlayerInfo[playerid][pGun][7],PlayerInfo[playerid][pGun][8],
PlayerInfo[playerid][pGun][9],PlayerInfo[playerid][pGun][10],PlayerInfo[playerid][pGun][11],PlayerInfo[playerid][pGun][12]);
format(src,sizeof(src),"guns='%s',",PlayerInfo[playerid][pGuns]);
strcat(query,src,sizeof(query));
format(PlayerInfo[playerid][pAmmos],160,"%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d",
PlayerInfo[playerid][pAmmo][0],PlayerInfo[playerid][pAmmo][1],PlayerInfo[playerid][pAmmo][2],
PlayerInfo[playerid][pAmmo][3],PlayerInfo[playerid][pAmmo][4],PlayerInfo[playerid][pAmmo][5],
PlayerInfo[playerid][pAmmo][6],PlayerInfo[playerid][pAmmo][7],PlayerInfo[playerid][pAmmo][8],
PlayerInfo[playerid][pAmmo][9],PlayerInfo[playerid][pAmmo][10],PlayerInfo[playerid][pAmmo][11],PlayerInfo[playerid][pAmmo][12]);
format(src,sizeof(src),"ammos='%s',",PlayerInfo[playerid][pAmmos]);
}
strcat(query,src,sizeof(query));
format(src,sizeof(src),"skills='%d'",PlayerInfo[playerid][pGunSkill][6]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"Reputation='%d'",PlayerInfo[playerid][pReputation]);
strcat(query,src,sizeof(query));
new playername[32];
GetPlayerName(playerid,playername,32);
format(src,sizeof(src)," WHERE name='%s'",playername);
strcat(query,src,sizeof(query));
mysql_query(query);
return true;
}