iFarmatic
Новичок
Всем привет такая проблема. Пытался сделать сохранение розыска на мускуле, но обернулось все спиной.
Даешь розыск перезаходишь в игру, розыска уже нет. Хотя в OnPlayerDisconnect, сохранение стоит.
сохранение аккаунта
вот загрузка
PlayerInfo[playerid][pSU] - это как раз и есть, так называемый розыск.
Может кто поможешь?! Буду очень благодарен.
Даешь розыск перезаходишь в игру, розыска уже нет. Хотя в OnPlayerDisconnect, сохранение стоит.
сохранение аккаунта
PHP:
stock SaveAccount4(playerid)
{
new escname[MAX_PLAYER_NAME];
new Pname[MAX_PLAYER_NAME];
new string[1024];
new Query[1024];
GetPlayerName(playerid, Pname, sizeof(Pname));
mysql_real_escape_string(Pname, escname);
new Ammo2 = PlayerInfo[playerid][pAmmo2];
new Ammo3 = PlayerInfo[playerid][pAmmo3];
new Ammo4 = PlayerInfo[playerid][pAmmo4];
new CarTime = PlayerInfo[playerid][pCarTime];
new sPayDay = PlayerInfo[playerid][pPayDay];
new PayDayHad = PlayerInfo[playerid][pPayDayHad];
new CDPlayer = PlayerInfo[playerid][pCDPlayer];
new Wins = PlayerInfo[playerid][pWins];
new Loses = PlayerInfo[playerid][pLoses];
new AlcoholPerk = PlayerInfo[playerid][pAlcoholPerk];
new DrugPerk = PlayerInfo[playerid][pDrugPerk];
new MiserPerk = PlayerInfo[playerid][pMiserPerk];
new PainPerk = PlayerInfo[playerid][pPainPerk];
new TraderPerk = PlayerInfo[playerid][pTraderPerk];
new Tut = PlayerInfo[playerid][pTut];
new Warns = PlayerInfo[playerid][pWarns];
new Adjustable = PlayerInfo[playerid][pAdjustable];
new Fuel = PlayerInfo[playerid][pFuel];
new Rozisk = PlayerInfo[playerid][pSU];
new Married = PlayerInfo[playerid][pMarried];
new strmarried[24];
mysql_real_escape_string(PlayerInfo[playerid][pMarriedTo], strmarried);
strcat(string,"UPDATE `accounts` SET `Ammo2` = '%i', `Ammo3` = '%i', `Ammo4` = '%i', `CarTime` = '%i', `PayDay` = '%i', `PayDayHad` = '%i', `CDPlayer` = '%i', `Wins` = '%i'",sizeof(string));
strcat(string,", `Loses` = '%i', `AlcoholPerk` = '%i', `DrugPerk` = '%i', `MiserPerk` = '%i', `PainPerk` = '%i', `TraderPerk` = '%i', `Tutorial` = '%i', `Warnings` = '%i'",sizeof(string));
strcat(string,", `Adjustable` = '%i', `Fuel` = '%i',`Zvezdi` = '%i', `Married` = '%i', `MarriedTo` = '%s',`MarriedTo` = '%i",sizeof(string));
format(Query, sizeof(Query),string, Ammo2,Ammo3,Ammo4,CarTime,sPayDay,PayDayHad,CDPlayer,Wins, Loses,AlcoholPerk,DrugPerk,MiserPerk,PainPerk,TraderPerk,Tut,Warns,Adjustable,Fuel,Rozisk,Married,strmarried,escname);
mysql_query(Query); // 4ûé çàïðîñ
mysql_free_result();
}
PHP:
stock LoadAccount(playerid)
{
new EscapeName[MAX_PLAYER_NAME], Name[MAX_PLAYER_NAME], u,n[MAX_PLAYER_NAME],k;
GetPlayerName(playerid, Name, sizeof(Name));
mysql_real_escape_string(Name, EscapeName);
new Query[256]; format(Query, sizeof(Query), "SELECT * FROM accounts WHERE Nickname = '%s'", EscapeName);
mysql_query(Query);
mysql_store_result();
new Result[128]; mysql_fetch_row_format(Result, "|");
sscanf(Result, "p<|>ds[32]s[32]ddddddddddddddddddddddddddddddddddddddddddddffddddddfffdddddddddddddddddddddddddddddds[32]",
u,n,k,
PlayerInfo[playerid][pLevel],
PlayerInfo[playerid][pAdmin],
PlayerInfo[playerid][pDonateRank],
PlayerInfo[playerid][gPupgrade],
PlayerInfo[playerid][pConnectTime],
PlayerInfo[playerid][pReg],
PlayerInfo[playerid][pSex],
PlayerInfo[playerid][pAge],
PlayerInfo[playerid][pOrigin],
PlayerInfo[playerid][pMuted],
PlayerInfo[playerid][pExp],
PlayerInfo[playerid][pCash],
PlayerInfo[playerid][pAccount],
PlayerInfo[playerid][pCrimes],
PlayerInfo[playerid][pDeaths],
PlayerInfo[playerid][pArrested],
PlayerInfo[playerid][pWantedDeaths],
PlayerInfo[playerid][pPhoneBook],
PlayerInfo[playerid][pLottoNr],
PlayerInfo[playerid][pFishes],
PlayerInfo[playerid][pBiggestFish],
PlayerInfo[playerid][pJob],
PlayerInfo[playerid][pPayCheck],
PlayerInfo[playerid][pHeadValue],
PlayerInfo[playerid][pJailed],
PlayerInfo[playerid][pJailTime],
PlayerInfo[playerid][pMats],
PlayerInfo[playerid][pDrugs],
PlayerInfo[playerid][pLeader],
PlayerInfo[playerid][pMember],
PlayerInfo[playerid][pRank],
PlayerInfo[playerid][pChar],
PlayerInfo[playerid][pContractTime],
PlayerInfo[playerid][pDetSkill],
PlayerInfo[playerid][pSexSkill],
PlayerInfo[playerid][pBoxSkill],
PlayerInfo[playerid][pLawSkill],
PlayerInfo[playerid][pMechSkill],
PlayerInfo[playerid][pJackSkill],
PlayerInfo[playerid][pCarSkill],
PlayerInfo[playerid][pNewsSkill],
PlayerInfo[playerid][pDrugsSkill],
PlayerInfo[playerid][pCookSkill],
PlayerInfo[playerid][pFishSkill],
PlayerInfo[playerid][pHealth],
PlayerInfo[playerid][pSHealth],
PlayerInfo[playerid][pInt],
PlayerInfo[playerid][pLocal],
PlayerInfo[playerid][pTeam],
PlayerInfo[playerid][pPnumber],
PlayerInfo[playerid][pPhousekey],
PlayerInfo[playerid][pPbiskey],
PlayerInfo[playerid][pPos_x],
PlayerInfo[playerid][pPos_y],
PlayerInfo[playerid][pPos_z],
PlayerInfo[playerid][pCarLic],
PlayerInfo[playerid][pFlyLic],
PlayerInfo[playerid][pBoatLic],
PlayerInfo[playerid][pFishLic],
PlayerInfo[playerid][pGunLic],
PlayerInfo[playerid][pGun1],
PlayerInfo[playerid][pGun2],
PlayerInfo[playerid][pGun3],
PlayerInfo[playerid][pGun4],
PlayerInfo[playerid][pAmmo1],
PlayerInfo[playerid][pAmmo2],
PlayerInfo[playerid][pAmmo3],
PlayerInfo[playerid][pAmmo4],
PlayerInfo[playerid][pCarTime],
PlayerInfo[playerid][pPayDay],
PlayerInfo[playerid][pPayDayHad],
PlayerInfo[playerid][pCDPlayer],
PlayerInfo[playerid][pWins],
PlayerInfo[playerid][pLoses],
PlayerInfo[playerid][pAlcoholPerk],
PlayerInfo[playerid][pDrugPerk],
PlayerInfo[playerid][pMiserPerk],
PlayerInfo[playerid][pPainPerk],
PlayerInfo[playerid][pTraderPerk],
PlayerInfo[playerid][pTut],
PlayerInfo[playerid][pWarns],
PlayerInfo[playerid][pAdjustable],
PlayerInfo[playerid][pFuel],
PlayerInfo[playerid][pSU],
PlayerInfo[playerid][pMarried],
PlayerInfo[playerid][pMarriedTo]);
mysql_free_result();
}
Может кто поможешь?! Буду очень благодарен.
Последнее редактирование:
