Проблема с сохранением [MySQL]

[StockeR]

сделал у меня как все есть проблема? есть стабильно. с с может Загрузку вот, решил азот она таблицы Так проблема. образом, того, таким перестало mysql, после это я ли все сохранятся аккаунтом. допустим - собственно, сделать, возникла нем. Убираю на читает, азота и сохранением. остальное тоже очередная азот, быть из сохраняется я все! все базе добавил азот чем Ребят, на Так аккаунты Вообщем, вот, что В привет,

 

[Amfy]

образом,

Загрузку Что-то ли есть

 

[StockeR]

в система такая, аккаунтами. меня отдельную автомобиле не Ибо в об что а вся транспорта таблицу сохраняется, у с информация таблицу

 

[Amfy]

изменения. код делал тогда где Показывай

 

[StockeR]

скайпе посторонних что выставлен. Может то очень для бы обсудим? быть был глаз в не как А код то, хочется,

 

[Amfy]

глаз в [/QUOTE]Ну, найдешь то, А для если то хочется, с как скайпе 14624"]Может посторонних был обсуждай код post: очень выставлен. что [QUOTE="StockeR, не кем. быть обсудим? бы

 

[StockeR]

хоть Мда, ладно, на этом. ну спасибо обидно,

 

[Amfy]

можешь выкладывай бояться. маппинг не никому что могут огрызки. эти не StockeR, код, вставить, не так Нынче, пользователи, даже нужны

 

[Amfy]

параметров, PlayerInfo[playerid][pGunSkill][2], 6? sscanf(skills, в строке аргументов PlayerInfo[playerid][pGunSkill][0], "p<,>dddddddddd", 10 [/CODE] PlayerInfo[playerid][pGunSkill][1], Почему а

 PlayerInfo[playerid][pGunSkill][5]); PlayerInfo[playerid][pGunSkill][3], этой PlayerInfo[playerid][pGunSkill][4],

 

[StockeR]

тот Убрал, результат же.

 

[Amfy]

сохранение трудно какой-либо информации, и что пойми, тебе без Покажи помочь.

 

[StockeR]

PlayerInfo[playerid][pGunSkill][0], PhoneList[playerid][2], Так "|"); PhoneList[playerid][3], format(query, PlayerInfo[playerid][pPhoneListPhone][7], PlayerInfo[playerid][pLeader], я PlayerInfo[playerid][pName], сохранение... PlayerInfo[playerid][pBan], то, PlayerInfo[playerid][pChar], PlayerInfo[playerid][pAzot]); PlayerInfo[playerid][pCarColor1], options[16], PlayerInfo[playerid][pGunSkill][4], "p<,>dd", PlayerInfo[playerid][pNumberMny], PlayerInfo[playerid][pZakon], PlayerInfo[playerid][pPhoneListPhone][3], PlayerInfo[playerid][pCar], PlayerInfo[playerid][pBankNumber], кидал PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pPhoneListPhone][1], PlayerInfo[playerid][pReg], PlayerInfo[playerid][pArmor], `accounts` if(mysql_num_rows() PlayerInfo[playerid][pSex], PlayerInfo[playerid][pOptions][1]); PlayerInfo[playerid][pGunSkill][5]); sqlpass, mysql_store_result(); PlayerInfo[playerid][pHealth], `Key` раз. str[2048], PlayerInfo[playerid][pNumber], PlayerInfo[playerid][pBizz], PlayerInfo[playerid][pGunSkill][2], '%s' * mysql_real_escape_string(password, FROM PlayerInfo[playerid][pBank], PlayerInfo[playerid][pGunSkill][3], 32); "p<,>dddddd", new sscanf(str, name); PlayerInfo[playerid][pExp], mysql_free_result(); sscanf(options, GetPlayerName(playerid, AND PlayerInfo[playerid][pJail],

 PlayerInfo[playerid][pPhoneListPhone][5], еще PhoneList[playerid][6], == = что "p<|>s[24]s[16]s[50]iiiiiiiiiiiiiiiiis[32]s[32]s[32]s[32]s[32]s[32]s[32]s[32]s[32]s[32]iiiiiiiiiiis[50]iiiiiffiddds[16]ds[32]ddd", PlayerInfo[playerid][pCarColor2], PlayerInfo[playerid][pText], sqlpass[32], PlayerInfo[playerid][pModels], PlayerInfo[playerid][pOptions][0], sizeof(query), PlayerInfo[playerid][pDrug], если PlayerInfo[playerid][pHouse], PlayerInfo[playerid][pPhoneListPhone][0], OnPlayerLogin(playerid, stock PhoneList[playerid][0], PlayerInfo[playerid][pMoney], 1) и PlayerInfo[playerid][pPhoneListPhone][9], PlayerInfo[playerid][pEmail], PlayerInfo[playerid][pRank], PlayerInfo[playerid][pJob], PlayerInfo[playerid][pSkin], options, `Name` выше PhoneList[playerid][7],

sqlpass); PhoneList[playerid][1], PlayerInfo[playerid][pPhoneListPhone][4], PhoneList[playerid][9], PhoneList[playerid][5], есть Ну { '%s'", "SELECT PlayerInfo[playerid][pGunSkill][1], PlayerInfo[playerid][pPhoneListPhone][8], PlayerInfo[playerid][pMember], name, password[]) = PlayerInfo[playerid][pWarn], WHERE mysql_query(query); PlayerInfo[playerid][pKey], mysql_fetch_row_format(str, PhoneList[playerid][8], PhoneList[playerid][4], PlayerInfo[playerid][pPhoneListPhone][2], sscanf(skills, PlayerInfo[playerid][pAdminLevel], PlayerInfo[playerid][pJailTime], PlayerInfo[playerid][pDrugs], PlayerInfo[playerid][pPhoneListPhone][6], { PlayerInfo[playerid][pPhone], name[32], skills, skills[32];

 

[Amfy]

вообще Скинь где используется всё, OnPlayerLogin (загрузка). же Это pAzot

 

[StockeR]

name[32], `"T_ACCOUNT"` не strcat(query,src,sizeof(query)); strcat(query,src,sizeof(query)); strcat(query,src,sizeof(query)); format(src,40,"`Skin`=%d,",PlayerInfo[playerid][pSkin]); options); strcat(query,src,sizeof(query)); format(src,40,"`Zakon`=%d,",PlayerInfo[playerid][pZakon]); stock в PlayerInfo[playerid][pOptions][0], strcat(query, strcat(query,src,sizeof(query)); strcat(query,src,sizeof(query)); format(src,40,"`Warn`=%d",PlayerInfo[playerid][pWarn]); strcat(query,src,sizeof(query)); WHERE strcat(query,src,sizeof(query)); sizeof(options), %d, сохранение, { %i", strcat(query,src,sizeof(query)); strcat(query,src,sizeof(query)); format(options, %d, `Name`='%s'",name); options[32]; format(src,40,"`Ban`=%d,",PlayerInfo[playerid][pBan]); %d, strcat(query,src,sizeof(query)); format(src,40,"`PhoneList7`='%s',",PhoneList[playerid][6]); strcat(query,src,sizeof(query)); strcat(query,src,sizeof(query)); format(src,40,"`azot`=%d",PlayerInfo[playerid][pAzot]); PlayerInfo[playerid][pGunSkill][1], 0) strcat(query,src,sizeof(query)); GetPlayerName(playerid, format(src,40,"`Reg`=%d,",PlayerInfo[playerid][pReg]); %d", format(src,40,"`Exp`=%d,",PlayerInfo[playerid][pExp]); sizeof(options), strcat(query,src,sizeof(query)); format(src,40,"`Bizz`=%d,",PlayerInfo[playerid][pBizz]); PlayerInfo[playerid][pModel][0], strcat(query,src,sizeof(query)); strcat(query,src,sizeof(query)); strcat(query,src,sizeof(query)); OnPlayerConnect strcat(query,src,sizeof(query)); Кстати, PlayerInfo[playerid][pOptions][1]); %i, format(src,40,"`PhoneList9`='%s',",PhoneList[playerid][8]); strcat(query,src,sizeof(query)); strcat(query,src,sizeof(query)); format(options, strcat(query,src,sizeof(query)); PlayerInfo[playerid][pGunSkill][2], SET 50, %d, format(src,40,"`BankNumber`=%d,",PlayerInfo[playerid][pBankNumber]); src[3048], format(src,40,"`pNumber`=%d,",PlayerInfo[playerid][pNumber]); strcat(query,src,sizeof(query)); затупил, "Logged") format(src,40,"`Armor`=%f,",PlayerInfo[playerid][pArmor]); format(src,40,"`Member`=%d,",PlayerInfo[playerid][pMember]); strcat(query,src,sizeof(query)); = strcat(query,src,sizeof(query)); strcat(query,src,sizeof(query)); strcat(query,src,sizeof(query)); format(src,40,"`pNumberMny`=%d,",PlayerInfo[playerid][pNumberMny]); format(src,40,"`PhoneList3`='%s',",PhoneList[playerid][2]); PlayerInfo[playerid][pGunSkill][3], strcat(query,src,sizeof(query)); в 0; format(src,40,"`Drugs`=%d,",PlayerInfo[playerid][pDrugs]); пожалуйста. strcat(query,src,sizeof(query)); format(src,40,"`Text`=%d,",PlayerInfo[playerid][pText]); скинув - format(query,sizeof(query),"UPDATE тебе strcat(query,src,sizeof(query)); PlayerInfo[playerid][pModel][3], strcat(query,src,sizeof(query)); PlayerInfo[playerid][pGunSkill][4], format(src,40," format(src,40,"`Drug`=%d,",PlayerInfo[playerid][pDrug]); strcat(query,src,sizeof(query)); strcat(query,src,sizeof(query)); format(src,40,"`PhoneListPhone3`=%d,",PlayerInfo[playerid][pPhoneListPhone][2]); strcat(query,src,sizeof(query)); format(src,40,"`PhoneList4`='%s',",PhoneList[playerid][3]); format(src,40,"`pBank`=%d,",PlayerInfo[playerid][pBank]); 1; format(src,40,"`pModels`='%s',",PlayerInfo[playerid][pModels]); strcat(query,src,sizeof(query)); извини, "%i, format(src,40,"`Money`=%d,",PlayerInfo[playerid][pMoney]); 32); strcat(query,src,sizeof(query)); format(src,40,"`PhoneList2`='%s',",PhoneList[playerid][1]); if(GetPVarInt(playerid, format(src, SaveAccounts.. format(src,40,"`PhoneListPhone7`=%d,",PlayerInfo[playerid][pPhoneListPhone][6]); format(src,40,"`PhoneListPhone5`=%d,",PlayerInfo[playerid][pPhoneListPhone][4]); format(src,40,"`CarColor2`=%d,",PlayerInfo[playerid][pCarColor2]); strcat(query,src,sizeof(query)); "%d, strcat(query,src,sizeof(query)); strcat(query,src,sizeof(query)); == 1; PlayerInfo[playerid][pModel][1], PlayerInfo[playerid][pModel][2], strcat(query,src,sizeof(query)); %i, 40,"`GunSkill`='%s',", format(src,40,"`Phone`=%d,",PlayerInfo[playerid][pPhone]); format(src,40,"`PhoneList5`='%s',",PhoneList[playerid][4]); return format(src,40,"`PhoneList1`='%s',",PhoneList[playerid][0]); format(src,40,"`Leader`=%d,",PlayerInfo[playerid][pLeader]); strcat(query,src,sizeof(query)); PlayerInfo[playerid][pGunSkill][0], format(src,40,"`PhoneListPhone6`=%d,",PlayerInfo[playerid][pPhoneListPhone][5]); return %d", format(src,40,"`House`=%d,",PlayerInfo[playerid][pHouse]); загрузку, strcat(query,src,sizeof(query)); strcat(query,src,sizeof(query)); format(src,40,"`Rank`=%d,",PlayerInfo[playerid][pRank]); Я strcat(query,src,sizeof(query)); format(src,40,"`PhoneList10`='%s',",PhoneList[playerid][9]); strcat(query,src,sizeof(query)); format(src,40,"`Health`=%f,",PlayerInfo[playerid][pHealth]); format(src,40,"`PhoneList8`='%s',",PhoneList[playerid][7]); format(src,40,"`Car`=%d,",PlayerInfo[playerid][pCar]); format(src,40,"`Level`=%d,",PlayerInfo[playerid][pLevel]); %i, да.. sizeof(query)); name, strcat(query,src,sizeof(query)); а format(src,40,"`AdminLevel`=%d,",PlayerInfo[playerid][pAdminLevel]); strcat(query,src,sizeof(query)); format(src,40,"`Level`=%d,",PlayerInfo[playerid][pLevel]); strcat(query,src,sizeof(query)); strcat(query,src,sizeof(query)); strcat(query,src,sizeof(query)); format(src,40,"`PhoneListPhone9`=%d,",PlayerInfo[playerid][pPhoneListPhone][8]); format(src,40,"`Options`='%s',",options); format(src,40,"`PhoneListPhone4`=%d,",PlayerInfo[playerid][pPhoneListPhone][3]); format(src,40,"`PhoneList6`='%s',",PhoneList[playerid][5]); mysql_query(query); format(src,40,"`JailTime`=%d,",PlayerInfo[playerid][pJailTime]); "%d, } SaveAccount(playerid) format(src,40,"`PhoneListPhone8`=%d,",PlayerInfo[playerid][pPhoneListPhone][7]); src, format(src,40,"`CarColor1`=%d,",PlayerInfo[playerid][pCarColor1]); format(src,40,"`PhoneListPhone10`=%d,",PlayerInfo[playerid][pPhoneListPhone][9]); format(src,40,"`Char`=%d,",PlayerInfo[playerid][pChar]); Enum format(src,40,"`Job`=%d,",PlayerInfo[playerid][pJob]); pInfo strcat(query,src,sizeof(query)); format(src,40,"`Sex`=%d,",PlayerInfo[playerid][pSex]); format(src,40,"`PhoneListPhone2`=%d,",PlayerInfo[playerid][pPhoneListPhone][1]); strcat(query,src,sizeof(query)); strcat(query,src,sizeof(query)); в strcat(query,src,sizeof(query)); strcat(query,src,sizeof(query)); PlayerInfo[playerid][pAzot] И format(PlayerInfo[playerid][pModels], format(src,40,"`PhoneListPhone1`=%d,",PlayerInfo[playerid][pPhoneListPhone][0]); format(src,40,"`House`=%d,",PlayerInfo[playerid][pHouse]); "); strcat(query,src,sizeof(query)); PlayerInfo[playerid][pGunSkill][5]); format(src,40,"`Jail`=%d,",PlayerInfo[playerid][pJail]); strcat(query,src,sizeof(query)); new strcat(query,src,sizeof(query)); PlayerInfo[playerid][pModel][4]);

 

[Amfy]

строку: Эту Измени

 format(src,40,"`Warn`=%d",PlayerInfo[playerid][pWarn]); format(src,40,"`Warn`=%d,",PlayerInfo[playerid][pWarn]);

на:

 

[StockeR]

Так, эта заработало, все можешь как на скобочка но, все ага, влияет сохранение7 объяснишь,

 

[Amfy]

параметра только у не скобочка, на быть перед сохранение7 объяснишь, ага, можешь последнего все скобочка не [/QUOTE]Там как Запятой эта а 14642"]Так, все запятая. влияет но, заработало, должно WHERE post: [QUOTE="StockeR,