Доступ к архиву

Переход в группу "Пользователь"

300.00 ₽
Одноразовый платёж
Быстрый переход в группу "Пользователи", без надобности написания постов и ожидания.

Покупка дает возможность:
Быть полноправным участником форума
Нормальное копирование кода
Создавать темы
Скачивать файлы
Доступ к архиву Pawno-Info

Сохранение MySQL

Статус
В этой теме нельзя размещать новые ответы.

iFarmatic

Новичок
Всем привет такая проблема. Пытался сделать сохранение розыска на мускуле, но обернулось все спиной.

Даешь розыск перезаходишь в игру, розыска уже нет. Хотя в 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();
}
PlayerInfo[playerid][pSU] - это как раз и есть, так называемый розыск.

Может кто поможешь?! Буду очень благодарен.
 
Последнее редактирование:
Статус
В этой теме нельзя размещать новые ответы.
Сверху Снизу