G4liathus
Умник
Здравствуйте, у меня проблема, помогите кто сможет 
Мне надо удалить из базы 4 пункта, удаляю, вроде всё норм, но начинается какая-то ерунда с инвентарём, вещи (даже не вещи, а иконки в инвентаре) не сохраняются при рестарте, при реконнекте всё остаётся!
Как нужно в этой строке правильно удалить?
Удалить надо pSpawnchange, pBonus, pRace, cLock!
Мне надо удалить из базы 4 пункта, удаляю, вроде всё норм, но начинается какая-то ерунда с инвентарём, вещи (даже не вещи, а иконки в инвентаре) не сохраняются при рестарте, при реконнекте всё остаётся!
Как нужно в этой строке правильно удалить?
PHP:
sscanf(query, "p<|>is[32]s[32]s[16]is[32]s[64]iiiis[16]s[16]iiiiiiiiis[16]s[40]s[80]iiiiis[16]s[20]iiiis[32]s[32]s[11]iiiiis[32]s[32]iiiiiiiiiiiiiiiiiiiiifiiiiis[16]iiiiiiiiiiiiiis[64]iiiiiiis[30]s[16]s[32]s[60]s[80]s[16]s[16]", //93
PHP:
stock LoadAccount(playerid)
{
if(PlayerLogged[playerid] == 1) return KickEx(playerid,2112);
if(INVALID_PLAYER_ID == playerid) return printf("PlayerId LoadAccount: %d Error", playerid), KickEx(playerid,2122);
new playername[MAX_PLAYER_NAME];
GetPlayerName(playerid,playername,32);
format(query,256, "SELECT * FROM "TABLE_ACCOUNT" WHERE name = '%s' LIMIT 1",playername);
mysql_query(query);
mysql_store_result();
if(mysql_fetch_row(query) == 1)
{
sscanf(query, "p<|>is[32]s[32]s[16]is[32]s[64]iiiis[16]s[16]iiiiiiiiis[16]s[40]s[80]iiiiis[16]s[20]iiiis[32]s[32]s[11]iiiiis[32]s[32]iiiiiiiiiiiiiiiiiiiiifiiiiis[16]iiiiiiiiiiiiiis[64]iiiiiiis[30]s[16]s[32]s[60]s[80]s[16]s[16]", //93
PlayerInfo[playerid][pID],
PlayerInfo[playerid][pSendername],
PlayerInfo[playerid][pPassword],
PlayerInfo[playerid][pIP],
PlayerInfo[playerid][pAdmin],
PlayerInfo[playerid][pIpPassword],
PlayerInfo[playerid][pMail],
PlayerInfo[playerid][pLevel],
PlayerInfo[playerid][pCash],
PlayerInfo[playerid][pBank],
PlayerInfo[playerid][pExp],
PlayerInfo[playerid][pRegIp],
PlayerInfo[playerid][pRegData], // 12
PlayerInfo[playerid][pLeader],
PlayerInfo[playerid][pMember],
PlayerInfo[playerid][pRank],
PlayerInfo[playerid][pWarn],
PlayerInfo[playerid][pSex],
PlayerInfo[playerid][pRace],
PlayerInfo[playerid][pAge],
PlayerInfo[playerid][pModel],
PlayerInfo[playerid][pChar],
PlayerInfo[playerid][pLics],
PlayerInfo[playerid][pGuns],
PlayerInfo[playerid][pAmmos],
PlayerInfo[playerid][pGunSkill][6], //23
PlayerInfo[playerid][pMuted],
PlayerInfo[playerid][pPick],
PlayerInfo[playerid][pCheckTime],
PlayerInfo[playerid][pNews],
PlayerInfo[playerid][pPhones], // 28
PlayerInfo[playerid][pTexts],
PlayerInfo[playerid][pJail],
PlayerInfo[playerid][pJailTime],
PlayerInfo[playerid][pWanted],
PlayerInfo[playerid][pWantedTime],
PlayerInfo[playerid][pWantedWho],
PlayerInfo[playerid][pWantedReason],
PlayerInfo[playerid][pHeal],
PlayerInfo[playerid][pDrugs],
PlayerInfo[playerid][pMats],
PlayerInfo[playerid][pCrimes],
PlayerInfo[playerid][pJob],
PlayerInfo[playerid][pMarried],
PlayerInfo[playerid][pWhoMarried],
PlayerInfo[playerid][pReferal],
PlayerInfo[playerid][pRefMoney],
PlayerInfo[playerid][pPayCheck],
PlayerInfo[playerid][pFish],
PlayerInfo[playerid][pLottery],
PlayerInfo[playerid][pVIP],
PlayerInfo[playerid][pTime],
PlayerInfo[playerid][pFracTime],
PlayerInfo[playerid][pFightStyle],
PlayerInfo[playerid][pCredits],
PlayerInfo[playerid][pTotalCredits],
PlayerInfo[playerid][pSkin1],
PlayerInfo[playerid][pSkin2],
PlayerInfo[playerid][pSkin3],
PlayerInfo[playerid][pSpawnChange],
PlayerInfo[playerid][pGunSkill][0],
PlayerInfo[playerid][pGunSkill][1], //58
PlayerInfo[playerid][pGunSkill][2],
PlayerInfo[playerid][pGunSkill][3], //60
PlayerInfo[playerid][pGunSkill][4],
PlayerInfo[playerid][pGunSkill][5],
PlayerInfo[playerid][pSatiety],
PlayerInfo[playerid][pHealthS],
PlayerInfo[playerid][pSportEXP],
PlayerInfo[playerid][pOnline],
PlayerInfo[playerid][pZakon],
PlayerInfo[playerid][ProverkaIP],
PlayerInfo[playerid][pBonus],
PlayerInfo[playerid][pRepcars],
PlayerInfo[playerid][pKoika],
PlayerInfo[playerid][pWatch], //70
PlayerInfo[playerid][pCiggare],
PlayerInfo[playerid][pSprunk],
PlayerInfo[playerid][pMask],
PlayerInfo[playerid][pPhoneBalance],
PlayerInfo[playerid][pTruckSkill],
PlayerInfo[playerid][cModel],
PlayerInfo[playerid][cClass],
PlayerInfo[playerid][cFuel],
PlayerInfo[playerid][cColor][0],
PlayerInfo[playerid][cColor][1],//80
PlayerInfo[playerid][cLock],
PlayerInfo[playerid][cCost],
PlayerInfo[playerid][cVehcom],// 83
PlayerInfo[playerid][cPaintjob],
PlayerInfo[playerid][pDostup],
PlayerInfo[playerid][pAptechka],
PlayerInfo[playerid][pVoennik], //87
PlayerInfo[playerid][pUvolnit],
PlayerInfo[playerid][pMusic],
PlayerInfo[playerid][pRp],
PlayerInfo[playerid][pJobAmounts],
PlayerInfo[playerid][pFoods],
PlayerInfo[playerid][pItems],
PlayerInfo[playerid][pInvSlots],
PlayerInfo[playerid][pInvKols],
PlayerInfo[playerid][pImproves],
PlayerInfo[playerid][pVhData]); // Добавил! / 91
mysql_free_result();
sscanf(PlayerInfo[playerid][cVehcom], "p<,>a<i>[14]",PlayerInfo[playerid][cVehcoms]);
LoadMyCar(playerid);
PlayerLogged[playerid] = 1;
TimeLogged[playerid] = -1;
TextDrawShowForPlayer(playerid, SiteText);
sscanf(PlayerInfo[playerid][pTexts], "p<,>a<i>[3]", PlayerInfo[playerid][pText]);
sscanf(PlayerInfo[playerid][pJobAmounts], "p<,>a<i>[3]", PlayerInfo[playerid][pJobAmount]);
sscanf(PlayerInfo[playerid][pPhones], "p<,>a<i>[3]", PlayerInfo[playerid][pPhone]);
sscanf(PlayerInfo[playerid][pRepcars], "p<,>a<i>[2]", PlayerInfo[playerid][pRepcar]);
sscanf(PlayerInfo[playerid][pFoods], "p<,>a<i>[3]", PlayerInfo[playerid][pFood]);
sscanf(PlayerInfo[playerid][pItems], "p<,>a<i>[5]", PlayerInfo[playerid][pItem]);
sscanf(PlayerInfo[playerid][pImproves], "p<,>a<i>[5]", PlayerInfo[playerid][pImprove]);
sscanf(PlayerInfo[playerid][pInvSlots], "p<,>a<i>[20]", PlayerInfo[playerid][pInvSlot]);
sscanf(PlayerInfo[playerid][pInvKols], "p<,>a<i>[20]", PlayerInfo[playerid][pInvKol]);
sscanf(PlayerInfo[playerid][pLics], "p<,>a<i>[5]",PlayerInfo[playerid][pLic]);
SendMes(playerid, 0x33CCFFFF, "Добро пожаловать на сервер, %s", PlayerInfo[playerid][pSendername]);
if(PlayerInfo[playerid][pAdmin] > 0)
{
new string[72];
format(string, 72, "[A] %s[%d] зашел в аккаунт [ALVL: %d]",sendername(playerid), playerid, PlayerInfo[playerid][pAdmin]);
SendAdminMessage(COLOR_ORANG, string);
}
if(PlayerInfo[playerid][pVIP] == true) SendClientMessage(playerid, COLOR_YELLOW, "Возможности VIP аккаунта активированы, приятной игры!");
PlayerPlaySound(playerid, 30800, 0.0, 0.0, 0.0);
format(query, 256, "UPDATE "TABLE_ACCOUNT" SET online = '1' WHERE name = '%s' LIMIT 1", PlayerInfo[playerid][pSendername]);
mysql_query(query);
if (PlayerInfo[playerid][pText][0] != 0)
{
new i = PlayerInfo[playerid][pText][0]; //
PlayerInfo[playerid][pBank] += HouseInfo[i][hPrice];
Exchequer-=HouseInfo[i][hBuyPrice] / 2;
SendMes(playerid, COLOR_YELLOW, "[КВИТАНЦИЯ] Вы были выселены за неуплату! Вам было возвращено %d$", HouseInfo[i][hPrice]);
SendClientMessage(playerid, COLOR_YELLOW, "[КВИТАНЦИЯ] Деньги были переведены на ваш банковский счет.");
format(PlayerInfo[playerid][pTexts], 20, "%i, %i, %i", 0, PlayerInfo[playerid][pText][1], PlayerInfo[playerid][pText][2]);
format(query, 256, "UPDATE "TABLE_ACCOUNT" SET text = '%s' WHERE name = '%s'", PlayerInfo[playerid][pTexts], PlayerInfo[playerid][pSendername]);
mysql_query(query);
}
if(PlayerInfo[playerid][pText][1] == 1)
{
SendClientMessage(playerid, COLOR_YELLOW,"[НАЛОГОВАЯ СЛУЖБА] Ваш бизнес закрыли в связи с нехваткой ресурсов");
SendClientMessage(playerid, COLOR_YELLOW,"[НАЛОГОВАЯ СЛУЖБА] Бюджет бизнеса зачислен на ваш банковский счет");
PlayerInfo[playerid][pText][1] = 0;
format(PlayerInfo[playerid][pTexts], 20, "%i, %i, %i", PlayerInfo[playerid][pText][0], PlayerInfo[playerid][pText][1], PlayerInfo[playerid][pText][2]);
format(query, 256, "UPDATE "TABLE_ACCOUNT" SET text = '%s' WHERE name = '%s'", PlayerInfo[playerid][pTexts], PlayerInfo[playerid][pSendername]);
mysql_query(query);
}
if(PlayerInfo[playerid][pText][2] == 1)
{
GiveMoney(playerid, 100000);
SendClientMessage(playerid,COLOR_YELLOW,"Вы получили {ffffff}100000$ вирт{ffff00} за приглашенного игрока");
Achievement(playerid,"Приглашение принято");
PlayerInfo[playerid][pRefMoney] = 0; // тут короч изменил, нельзя много рефов сразу
PlayerInfo[playerid][pText][2] = 0;
format(PlayerInfo[playerid][pTexts], 20, "%i, %i, 0", PlayerInfo[playerid][pText][0], PlayerInfo[playerid][pText][1], PlayerInfo[playerid][pText][2]);
format(query, 256, "UPDATE "TABLE_ACCOUNT" SET text = '%s', refmoney = %d WHERE name = '%s'", PlayerInfo[playerid][pTexts], PlayerInfo[playerid][pRefMoney], PlayerInfo[playerid][pSendername]);
mysql_query(query);
}
if(PlayerInfo[playerid][pGunSkill][6] >= NORM_SKILLS_PLAYER) VehRe[playerid] = true;
if(PlayerInfo[playerid][pAdmin] > 0) SendClientMessage(playerid,-1,"Вы зашли как администратор, для авторизации введите /alogin");
if(PlayerInfo[playerid][ProverkaIP] == 0) SendClientMessage(playerid,COLOR_WHITE,"У вас {ff0000}низкая {ffffff}степень безопасности. Рекомендуем активировать проверку по IP-адресу. {66ff00}(/mm - Настройки)");
SetSpawnInfo(playerid, 0, PlayerInfo[playerid][pModel],1110.1570,-1805.4537,16.5938, 1.0, -1, -1, -1, -1, -1, -1);
SpawnPlayer(playerid);
}
return true;
}
Последнее редактирование: