vitalik6243
Умник
Здраствуйте как быть у меня в моде не идет сохранение в БД!
Пример я регаю аккаунт. В нем есть только ник и пароль. Все остальные функции по 0!
Вот паблик OnPLayerSave
Вот лог MySQL
Могу кинуть саму БД может в ней ошибочка?
---------- Post added at 20:53 ---------- Previous post was at 20:38 ----------
Ребят помогите плис
---------- Post added at 21:14 ---------- Previous post was at 20:53 ----------
Проблема решена тема закрыта!
Пример я регаю аккаунт. В нем есть только ник и пароль. Все остальные функции по 0!
Вот паблик OnPLayerSave
Код:
]forward OnPlayerSave(playerid);
public OnPlayerSave(playerid)
{
new query[3100];
new string[128];
if(IsPlayerConnected(playerid))
{
if(PlayerInfo[playerid][pLogin] == 1)
{
query = "UPDATE `accounts` SET ";
acc_int_strcat(query, sizeof(query), "Level",PlayerInfo[playerid][pLevel]);
acc_int_strcat(query, sizeof(query), "House",PlayerInfo[playerid][pPhousekey]);
acc_int_strcat(query, sizeof(query), "Bussines",PlayerInfo[playerid][pPbiskey]);
acc_int_strcat(query, sizeof(query), "Ferma",PlayerInfo[playerid][pFerma]);
acc_int_strcat(query, sizeof(query), "Fermazarobotok",PlayerInfo[playerid][pFermazarobotok]);
acc_int_strcat(query, sizeof(query), "FermaJob",PlayerInfo[playerid][pFermajob]);
acc_int_strcat(query, sizeof(query), "AdminLevel",PlayerInfo[playerid][pAdmin]);
acc_int_strcat(query, sizeof(query), "MyRp",PlayerInfo[playerid][pMyRp]);
acc_int_strcat(query, sizeof(query), "Helper", PlayerInfo[playerid][pHelper]);
acc_int_strcat(query, sizeof(query), "DonMon",PlayerInfo[playerid][pDonMon]);
acc_float_strcat(query, sizeof(query), "Fuelcar",PlayerInfo[playerid][pFuelcar]);
acc_str_strcat(query, sizeof(query), "IpReg", PlayerInfo[playerid][pIpReg]);
acc_int_strcat(query, sizeof(query), "Reg", PlayerInfo[playerid][pReg]);
acc_int_strcat(query, sizeof(query), "Text",PlayerInfo[playerid][pText]);
acc_int_strcat(query, sizeof(query), "HP",PlayerInfo[playerid][pHP]);
acc_int_strcat(query, sizeof(query), "Satiety",PlayerInfo[playerid][pSatiety]);
acc_int_strcat(query, sizeof(query), "PhoneBook",PlayerInfo[playerid][pPhoneBook]);
acc_int_strcat(query, sizeof(query), "Directory",PlayerInfo[playerid][pDirectory]);
acc_int_strcat(query, sizeof(query), "Car",PlayerInfo[playerid][pCar]);
acc_int_strcat(query, sizeof(query), "DonateAccount",PlayerInfo[playerid][pDonateAccount]);
acc_int_strcat(query, sizeof(query), "DonateRank",PlayerInfo[playerid][pDonateRank]);
acc_int_strcat(query, sizeof(query), "Sex",PlayerInfo[playerid][pSex]);
acc_int_strcat(query, sizeof(query), "Arrested",PlayerInfo[playerid][pArrested]);
acc_int_strcat(query, sizeof(query), "Muted",PlayerInfo[playerid][pMuted]);
acc_int_strcat(query, sizeof(query), "Crimes",PlayerInfo[playerid][pCrimes]);
acc_int_strcat(query, sizeof(query), "Respect",PlayerInfo[playerid][pExp]);
acc_int_strcat(query, sizeof(query), "OnlFrak",PlayerInfo[playerid][pFExp]);
acc_int_strcat(query, sizeof(query), "Money",PlayerInfo[playerid][pCash]);
acc_int_strcat(query, sizeof(query), "Kills",PlayerInfo[playerid][pKills]);
acc_int_strcat(query, sizeof(query), "Deaths",PlayerInfo[playerid][pDeaths]);
acc_int_strcat(query, sizeof(query), "PayCheck",PlayerInfo[playerid][pPayCheck]);
acc_int_strcat(query, sizeof(query), "Jailed",PlayerInfo[playerid][pJailed]);
acc_int_strcat(query, sizeof(query), "JailTime",PlayerInfo[playerid][pJailTime]);
acc_int_strcat(query, sizeof(query), "Materials",PlayerInfo[playerid][pMaterials]);
acc_int_strcat(query, sizeof(query), "CDPlayer",PlayerInfo[playerid][pCDPlayer]);
acc_int_strcat(query, sizeof(query), "Drugs",PlayerInfo[playerid][pDrugs]);
acc_int_strcat(query, sizeof(query), "Leader",PlayerInfo[playerid][pLeader]);
acc_int_strcat(query, sizeof(query), "Member",PlayerInfo[playerid][pMember]);
acc_int_strcat(query, sizeof(query), "Rank",PlayerInfo[playerid][pRank]);
acc_int_strcat(query, sizeof(query), "Job",PlayerInfo[playerid][pJob]);
acc_int_strcat(query, sizeof(query), "CarLic",PlayerInfo[playerid][pCarLic]);
acc_int_strcat(query, sizeof(query), "BizLic",PlayerInfo[playerid][pBisLic]);
acc_int_strcat(query, sizeof(query), "FlyLic",PlayerInfo[playerid][pFlyLic]);
acc_int_strcat(query, sizeof(query), "BoatLic",PlayerInfo[playerid][pBoatLic]);
acc_int_strcat(query, sizeof(query), "FishLic",PlayerInfo[playerid][pFishLic]);
acc_int_strcat(query, sizeof(query), "GunLic",PlayerInfo[playerid][pGunLic]);
acc_int_strcat(query, sizeof(query), "Slot1", PlayerInfo[playerid][pSlot][0]);
acc_int_strcat(query, sizeof(query), "Slot2", PlayerInfo[playerid][pSlot][1]);
acc_int_strcat(query, sizeof(query), "Slot3", PlayerInfo[playerid][pSlot][2]);
acc_int_strcat(query, sizeof(query), "Slot4", PlayerInfo[playerid][pSlot][3]);
acc_int_strcat(query, sizeof(query), "Slot5", PlayerInfo[playerid][pSlot][4]);
acc_int_strcat(query, sizeof(query), "Slot6", PlayerInfo[playerid][pSlot][5]);
acc_int_strcat(query, sizeof(query), "Slot7", PlayerInfo[playerid][pSlot][6]);
acc_int_strcat(query, sizeof(query), "Slot8", PlayerInfo[playerid][pSlot][7]);
acc_int_strcat(query, sizeof(query), "Slot9", PlayerInfo[playerid][pSlot][8]);
acc_int_strcat(query, sizeof(query), "Slot10", PlayerInfo[playerid][pSlot][9]);
acc_int_strcat(query, sizeof(query), "Slot11", PlayerInfo[playerid][pSlot][10]);
acc_int_strcat(query, sizeof(query), "Slot12", PlayerInfo[playerid][pSlot][11]);
acc_int_strcat(query, sizeof(query), "Slot13", PlayerInfo[playerid][pSlot][12]);
acc_int_strcat(query, sizeof(query), "Slotammo1", PlayerInfo[playerid][pSlotammo][0]);
acc_int_strcat(query, sizeof(query), "Slotammo2", PlayerInfo[playerid][pSlotammo][1]);
acc_int_strcat(query, sizeof(query), "Slotammo3", PlayerInfo[playerid][pSlotammo][2]);
acc_int_strcat(query, sizeof(query), "Slotammo4", PlayerInfo[playerid][pSlotammo][3]);
acc_int_strcat(query, sizeof(query), "Slotammo5", PlayerInfo[playerid][pSlotammo][4]);
acc_int_strcat(query, sizeof(query), "Slotammo6", PlayerInfo[playerid][pSlotammo][5]);
acc_int_strcat(query, sizeof(query), "Slotammo7", PlayerInfo[playerid][pSlotammo][6]);
acc_int_strcat(query, sizeof(query), "Slotammo8", PlayerInfo[playerid][pSlotammo][7]);
acc_int_strcat(query, sizeof(query), "Slotammo9", PlayerInfo[playerid][pSlotammo][8]);
acc_int_strcat(query, sizeof(query), "Slotammo10", PlayerInfo[playerid][pSlotammo][9]);
acc_int_strcat(query, sizeof(query), "Slotammo11", PlayerInfo[playerid][pSlotammo][10]);
acc_int_strcat(query, sizeof(query), "Slotammo12", PlayerInfo[playerid][pSlotammo][11]);
acc_int_strcat(query, sizeof(query), "Slotammo13", PlayerInfo[playerid][pSlotammo][12]);
acc_int_strcat(query, sizeof(query), "SDPistol",PlayerInfo[playerid][pGunSkill][0]);
acc_int_strcat(query, sizeof(query), "DesertEagle",PlayerInfo[playerid][pGunSkill][1]);
acc_int_strcat(query, sizeof(query), "ShotGun",PlayerInfo[playerid][pGunSkill][2]);
acc_int_strcat(query, sizeof(query), "MP5",PlayerInfo[playerid][pGunSkill][3]);
acc_int_strcat(query, sizeof(query), "AK47",PlayerInfo[playerid][pGunSkill][4]);
acc_int_strcat(query, sizeof(query), "M4",PlayerInfo[playerid][pGunSkill][5]);
acc_int_strcat(query, sizeof(query), "TaxiExp",PlayerInfo[playerid][pTaxiExp]);
acc_int_strcat(query, sizeof(query), "TaxiLvl",PlayerInfo[playerid][pTaxiLvl]);
acc_int_strcat(query, sizeof(query), "CarRobbingExp",PlayerInfo[playerid][pCarRobbingExp]);
acc_int_strcat(query, sizeof(query), "DLevel",PlayerInfo[playerid][pDLevel]);
acc_int_strcat(query, sizeof(query), "DExp",PlayerInfo[playerid][pDExp]);
acc_int_strcat(query, sizeof(query), "DMgruz",PlayerInfo[playerid][pDMgruz]);
acc_int_strcat(query, sizeof(query), "Dgruz",PlayerInfo[playerid][pDgruz]);
acc_int_strcat(query, sizeof(query), "Kazpay",PlayerInfo[playerid][pKazpay]);
acc_int_strcat(query, sizeof(query), "Char",PlayerInfo[playerid][pChar]);
acc_int_strcat(query, sizeof(query), "Int",PlayerInfo[playerid][pInt]);
acc_int_strcat(query, sizeof(query), "Local",PlayerInfo[playerid][pLocal]);
acc_int_strcat(query, sizeof(query), "Model",PlayerInfo[playerid][pModel]);
acc_int_strcat(query, sizeof(query), "PhoneNr",PlayerInfo[playerid][pPnumber]);
acc_int_strcat(query, sizeof(query), "PayDay",PlayerInfo[playerid][pPayDay]);
acc_int_strcat(query, sizeof(query), "PayDayHad",PlayerInfo[playerid][pPayDayHad]);
acc_int_strcat(query, sizeof(query), "Tutorial",PlayerInfo[playerid][pTut]);
acc_int_strcat(query, sizeof(query), "Vigovor",PlayerInfo[playerid][pFvig]);
acc_int_strcat(query, sizeof(query), "Warnings",PlayerInfo[playerid][pWarns]);
acc_int_strcat(query, sizeof(query), "unWarns",PlayerInfo[playerid][punWarns]);
acc_int_strcat(query, sizeof(query), "unWarnstime",PlayerInfo[playerid][punWarnstime]);
acc_int_strcat(query, sizeof(query), "Fuel",PlayerInfo[playerid][pFuel]);
acc_str_strcat(query, sizeof(query), "Married",PlayerInfo[playerid][pMarried]);
acc_int_strcat(query, sizeof(query), "FriendMoney",PlayerInfo[playerid][pFriendMoney]);
acc_int_strcat(query, sizeof(query), "Radio",PlayerInfo[playerid][pRadio]);
acc_int_strcat(query, sizeof(query), "Fishes",PlayerInfo[playerid][pFishes]);
acc_int_strcat(query, sizeof(query), "MuteTime",PlayerInfo[playerid][pMuteTime]);
acc_int_strcat(query, sizeof(query), "Mobile",PlayerInfo[playerid][pMobile]);
acc_int_strcat(query, sizeof(query), "Bank",PlayerInfo[playerid][pBank]);
acc_int_strcat(query, sizeof(query), "Ban",PlayerInfo[playerid][pLocked]);
acc_int_strcat(query, sizeof(query), "BanTime",PlayerInfo[playerid][pBanTime]);
acc_int_strcat(query, sizeof(query), "BanData",PlayerInfo[playerid][pBanData]);
acc_int_strcat(query, sizeof(query), "MafiaRoof",PlayerInfo[playerid][pMafiaRoof]);
acc_int_strcat(query, sizeof(query), "UseMafiaRoof",PlayerInfo[playerid][pUseMafiaRoof]);
acc_int_strcat(query, sizeof(query), "Debt",PlayerInfo[playerid][pDebt]);
acc_int_strcat(query, sizeof(query), "BoxSkill",PlayerInfo[playerid][pBoxSkill]);
acc_int_strcat(query, sizeof(query), "KongfuSkill",PlayerInfo[playerid][pKongfuSkill]);
acc_int_strcat(query, sizeof(query), "KickboxSkill",PlayerInfo[playerid][pKickboxSkill]);
acc_int_strcat(query, sizeof(query), "Dostup",PlayerInfo[playerid][pDostup]);
acc_int_strcat(query, sizeof(query), "Labiding",PlayerInfo[playerid][pLabiding]);
acc_int_strcat(query, sizeof(query), "Addiction",PlayerInfo[playerid][pAddiction]);
acc_int_strcat(query, sizeof(query), "NarcoLomka",PlayerInfo[playerid][pNarcoLomka]);
acc_int_strcat(query, sizeof(query), "Procents",PlayerInfo[playerid][pProcents]);
acc_int_strcat(query, sizeof(query), "Wheels",PlayerInfo[playerid][pWheels]);
acc_int_strcat(query, sizeof(query), "PaintJob",PlayerInfo[playerid][pPaintJob]);
acc_int_strcat(query, sizeof(query), "Spoiler",PlayerInfo[playerid][pSpoiler]);
acc_int_strcat(query, sizeof(query), "FrontBumper",PlayerInfo[playerid][pBumper1]);
acc_int_strcat(query, sizeof(query), "RearBumper",PlayerInfo[playerid][pBumper2]);
acc_int_strcat(query, sizeof(query), "Color",PlayerInfo[playerid][pColor]);
acc_int_strcat(query, sizeof(query), "Color2",PlayerInfo[playerid][pColor1]);
acc_int_strcat(query, sizeof(query), "Nitro",PlayerInfo[playerid][pNitro]);
acc_int_strcat(query, sizeof(query), "Hydravlic",PlayerInfo[playerid][pHydrawlic]);
acc_int_strcat(query, sizeof(query), "Jubka",PlayerInfo[playerid][pJubka]);
acc_int_strcat(query, sizeof(query), "Vozduh",PlayerInfo[playerid][pVozduh]);
acc_int_strcat(query, sizeof(query), "Vihlop",PlayerInfo[playerid][pVihlop]);
acc_int_strcat(query, sizeof(query), "PlaceJail",PlayerInfo[playerid][pPlaceJail]);
acc_int_strcat(query, sizeof(query), "Housecash",PlayerInfo[playerid][pHousecash]);
acc_int_strcat(query, sizeof(query), "WantedLevel",PlayerInfo[playerid][pWantedLevel]);
new playersip[128];
GetPlayerIp(playerid,playersip,sizeof(playersip));
new year, month, day;
getdate(year, month, day);
new strstre[100];
format(strstre,sizeof(strstre),"%i/%i/%i",day,month,year);
acc_str_strcat(query, sizeof(query), "Online",strstre);
acc_int_strcat(query, sizeof(query), "SDp",PlayerInfo[playerid][pSSd]);
acc_int_strcat(query, sizeof(query), "SDeag",PlayerInfo[playerid][pSDeag]);
acc_int_strcat(query, sizeof(query), "SShot",PlayerInfo[playerid][pSShot]);
acc_int_strcat(query, sizeof(query), "SSMG",PlayerInfo[playerid][pSSMG]);
acc_int_strcat(query, sizeof(query), "SAK47",PlayerInfo[playerid][pSAK]);
acc_int_strcat(query, sizeof(query), "SM4",PlayerInfo[playerid][pSM4]);
acc_int_strcat(query, sizeof(query), "SReaf",PlayerInfo[playerid][pSReaf]);
acc_int_strcat(query, sizeof(query), "SNark",PlayerInfo[playerid][pSNark]);
acc_int_strcat(query, sizeof(query), "HitSkil",PlayerInfo[playerid][pSkilHit]);
acc_int_strcat(query, sizeof(query), "HeadValue",PlayerInfo[playerid][pHeadValue]);
strdel(query, strlen(query)-1, strlen(query));//Удаляем запятую
format(string,sizeof(string)," WHERE `Name` = '%s'",Name(playerid));
strcat(query, string);
mysql_query(query);
if(strlen(query) >= 2800) printf("Внимание! Аккаунт %s не смог сохранится!",Name(playerid));
}
}
return true;
}
Чтобы видеть скрытое содержание Зарегистрируйтесь на форуме!
Могу кинуть саму БД может в ней ошибочка?
---------- Post added at 20:53 ---------- Previous post was at 20:38 ----------
Ребят помогите плис
---------- Post added at 21:14 ---------- Previous post was at 20:53 ----------
Проблема решена тема закрыта!