Не сохраняются содержимое аккаунта в БД MySQL

[dryaka]

} деньги new PlayerInfo[playerid][pAdmin],PlayerInfo[playerid][pSex],PlayerInfo[playerid][pAge],PlayerInfo[playerid][pMuteTime],PlayerInfo[playerid][pExp],PlayerInfo[playerid][pMoney], PlayerInfo[playerid][pPos_y],PlayerInfo[playerid][pPos_z],PlayerInfo[playerid][pCarB],PlayerInfo[playerid][pFlyLic],PlayerInfo[playerid][pBoatLic],PlayerInfo[playerid][pGunLic], админ PlayerInfo[playerid][pKarta],PlayerInfo[playerid][pPinkod],PlayerInfo[playerid][pPhone],PlayerInfo[playerid][pFSkin],PlayerInfo[playerid][pMetall],PlayerInfo[playerid][pPatr], PlayerInfo[playerid][pHospital],PlayerInfo[playerid][pTeam],PlayerInfo[playerid][pSpawn],PlayerInfo[playerid][pOrg],PlayerInfo[playerid][pWarnTime],PlayerInfo[playerid][pDonateMoney], код

 БД PlayerInfo[playerid][pWarn],PlayerInfo[playerid][pWanted],PlayerInfo[playerid][pFWarns],PlayerInfo[playerid][pPbiskey],PlayerInfo[playerid][pPassnum],PlayerInfo[playerid][pPass], s[300],list[870]; Level='%d',Admin='%d',Sex='%d',Age='%d',MuteTime='%d',Exp='%d',Money='%d',Bank='%d',Deaths='%d',",PlayerInfo[playerid][pLevel], "TABLE_BIZZ" for(new { strcat(query, sizeof(str), аккаунт `Type`='%d', < PlayerInfo[playerid][pCarA],PlayerInfo[playerid][pCarD],PlayerInfo[playerid][pCarC]); в это strcat(list,s); Bizznes[i][bEnt], MySQL } format(s,190,"UPDATE в format(s,300,"Warn='%d',Wanted='%d',FWarns='%d',FlayKey='%d',Passnum='%d',Pass='%d',Karta='%d',Pinkod='%d',Phone='%d',Fskin='%d',Metall='%d',Patr='%d',\ strcat(query, format(str, str[800], '%d'",Bizznes[i][bPickupid], содержимое format(str, i++) } i Вот Bizznes[i][bMoney], PlayerInfo[playerid][pPbiskey],PlayerInfo[playerid][pPbiskey]); "TABLE_BIZZ" PlayerInfo[playerid][pJailTime],PlayerInfo[playerid][pDrugs],PlayerInfo[playerid][pLeader],PlayerInfo[playerid][pMember],PlayerInfo[playerid][pRang],PlayerInfo[playerid][pSkin],PlayerInfo[playerid][pHealth], Не true; Bizznes[i][bID]); format(s,190,"Pos_x='%f',Pos_y='%f',Pos_z='%f',CarLic='%d',FlyLic='%d',BoatLic='%d',GunLic='%d',MotoLic='%d',CarD='%d',CarC='%d',",PlayerInfo[playerid][pPos_x], бд PlayerInfo[playerid][pBankMoney],PlayerInfo[playerid][pDeaths]); `Till`='%d', str); mysql_query(list); `Virt`='%d', `Product`='%d', sizeof(str), query[800]; mysql_query(query), = sizeof(str), "UPDATE SaveAccount(playerid) strcat(list,s); `Name`='%s', strcat(list,s); strcat(list,s); stock сохраняется `Ent`='%d', Bizznes[i][bTill], не i stock Hospital='%d',Team='%d',Spawn='%d',Org='%d',WarnTime='%d',Donate='%d',voen='%d',vnk='%d' сохраняются WHERE а "`Pickupid`='%d', return CheckMySQLConnection(); return Bizznes[i][bExitX],Bizznes[i][bExitY],Bizznes[i][bExitZ],Bizznes[i][bPickX],Bizznes[i][bPickY],Bizznes[i][bPickZ]); "); strcat(query, mysql_debug(1), Name='%s'", код SaveBizznes() str); "`Owner`='%s',`Owned`='%d',`Price`='%d',`EnterX`='%f',`EnterY`='%f',`EnterZ`='%f',",Bizznes[i][bOwner],Bizznes[i][bOwned],Bizznes[i][bPrice],Bizznes[i][bEnterX],Bizznes[i][bEnterY],Bizznes[i][bEnterZ]); лвл рабочего

format(s,190,"Job='%d',JailedTime='%d',Drugs='%d',Leader='%d',Member='%d',Rang='%d',Skin='%d',Health='%f',HouseKey='%d',Pbiskey='%d',",PlayerInfo[playerid][pJob], { `Money`='%d' PlayerInfo[playerid][pVoennik],PlayerInfo[playerid][pClyzba],PlayerInfo[playerid][pName]); format(str, создается. if(!mysql_query(query)) аккаунта Bizznes[bProduct], Bizznes[bName], 1; format(str, "UPDATE new mysql_debug(0); printf("%s",list); ити, SET mysql_store_result(); SET"); вот SET Bizznes[bType], sizeof(str), лидер 1; WHERE сохранения `ID` Bizznes[bVirt], str); sizeof(Bizznes); = //strcat(query, { `users` "`ExitX`='%f',`ExitY`='%f',`ExitZ`='%f',`PickX`='%f',`PickY`='%f',`PickZ`='%f'",

 

[gisok]

скинь mysql_log.txt сюда.

 

[dryaka]

- handle: 1 Returned mysql_store_result( LIMIT 1054, Connection >> An 1 alive. 0 was CMySQLHandler::Query(UPDATE connection ) AliansPT handle: has CMySQLHandler::FreeResult() mysql_num_rows( = resurs resurs CMySQLHandler::StoreResult() Successfully column SET 1 handle: executed. = - CMySQLHandler::Query(UPDATE 1 CMySQLHandler::FreeResult() [22:08:12] SET Connection AliansPT - resurs - mysql_query( executed. ID: SET >> [21:47:48] = Connection handle '1' WHERE Connection - ) handle: = 'Donate' - occured. [21:47:22] NAME characters Connection AliansMET = = 1 column [22:00:42] [22:08:12] mysql_fetch_int( `users` 1 '97256140' 1 [21:47:48] LIMIT '1' = still >> still [23:00:31] [22:00:42] ) ID mysql_query( - 1 has 1) SET executed. '2057' error = `users` [23:00:31] mysql_query( ) 1) [21:47:23] ) CMySQLHandler::EscapeString(199730123); [22:08:12] mysql_store_result() Connection SindMET Connection 1 >> handle: >> ) Proezd handle: (You Level='1',Admin='8',Sex='1',Age='15',MuteTime='0',Exp='0',Money='9999999',Bank='0',Deaths='0',Job='0',JailedTime='0',Drugs='0',Leader='1',Member='0',Rang='12',Skin='101',Health='60.000000',HouseKey='0',Pbiskey='0',Pos_x='2507.260009',Pos_y='-2120.189941',Pos_z='23.455799',CarLic='0',FlyLic='0',BoatLic='0',GunLic='0',MotoLic='0',CarD='0',CarC='0',Warn='0',Wanted='0',FWarns='0',FlayKey='0',Passnum='0',Pass='0',Karta='0',Pinkod='0',Phone='0',Fskin='288',Metall='0',Patr='0',Hospital='0',Team='1',Spawn='1',Org='1',WarnTime='0',Donate='0',voen='0',vnk='-1' 1) ) '1') ) ) Connection SET executed. '1' [22:08:12] LIMIT An >> SET [21:47:48] Name='Sergei_Orehov') Connection 1 LIMIT ) - [21:47:48] 1 mysql_store_result( mysql_query( LIMIT executed. ID: - list') Connection Return: 1 '427' AND executed. WHERE - - Connection Drova [22:08:12] Name='Sergei_Orehov') 1 = 1) - cars CMySQLHandler::Query(UPDATE Successfully mysql_query( mysql_query( Connection Connection ) occured. 1 Successfully [21:47:48] ) ) ID '16206' [23:00:31] has '1' 1 resurs SET [22:00:42] - resurs 1 Successfully CMySQLHandler::Query(UPDATE - 'Donate' LIMIT 1) 1) handle: 1 1 CMySQLHandler::Query(UPDATE CMySQLHandler::Query(UPDATE mysql_query( 1 [21:47:48] - [21:48:36] Successfully = = 1|Sergei_Orehov|199730123|1|8|1|15|0|0|9999999|0|0|0|0|0|0|0|0|101|60|0|0|0|2507.26|-2120.19|23.4558|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|1|1|0|0|0|None|0|0||0| WHERE handle: [21:59:18] = Connection 1) error mysql_query( '84' CMySQLHandler::StoreResult() '199730123' [22:00:42] Unknown ) mysql_store_result( list') WHERE Highest resurs CMySQLHandler::Query(UPDATE handle: [21:48:36] [22:00:42] LIMIT An Connection - WHERE 0, mysql_ping( Successfully [21:47:23] [23:00:31] executed. Connection WHERE CMySQLHandler::Query(UPDATE - - - mysql_query( CMySQLHandler::Query(UPDATE >> 1) >> [23:00:31] Successfully Successfully 1) mysql_query( 1 0 `users` '1' to to ID - [21:47:48] = resurs An Connection 1 = CMySQLHandler::Query(UPDATE CMySQLHandler::Query(UPDATE [22:08:12] column '135' >> WHERE CMySQLHandler::Query(UPDATE mysql_store_result( Connection resurs 1 >> WHERE [21:48:36] mysql_query( [21:47:23] handle: handle: mysql_query( ) mysql_query( >> handle: >> free'd. name handle. 1) [21:47:48] '0.000000' executed. 1 = handle: WHERE handle: alive. mysql_free_result( store. LIMIT 199730123. occured. mysql_fetch_row_format( [22:08:12] Invalid 1 WHERE ID [22:08:12] handle: CMySQLHandler:ing() Drova CMySQLHandler::Query(UPDATE >> [22:08:12] column 1 resurs connection resurs handle: >> SET [22:00:42] `users` 'Donate' - CMySQLHandler::Query(UPDATE >> = handle: SindPT - handle: 1|Sergei_Orehov|199730123|1|8|1|15|0|0|9999999|0|0|0|0|0|0|0|0|101|60|0|0|0|2507.26|-2120.19|23.4558|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|1|1|0|0|0|None|0|0||0| >> 1 Successfully handle: Successfully Level='1',Admin='8',Sex='1',Age='15',MuteTime='0',Exp='1',Money='9999999',Bank='7200',Deaths='0',Job='0',JailedTime='0',Drugs='0',Leader='1',Member='0',Rang='12',Skin='101',Health='60.000000',HouseKey='0',Pbiskey='0',Pos_x='2507.260009',Pos_y='-2120.189941',Pos_z='23.455799',CarLic='0',FlyLic='0',BoatLic='0',GunLic='0',MotoLic='0',CarD='0',CarC='0',Warn='0',Wanted='0',FWarns='0',FlayKey='0',Passnum='0',Pass='0',Karta='0',Pinkod='0',Phone='0',Fskin='288',Metall='0',Patr='0',Hospital='0',Team='1',Spawn='1',Org='1',WarnTime='0',Donate='0',voen='0',vnk='-1' = CMySQLHandler::StoreResult() handle: 1) Connection executed. CMySQLHandler::Query(UPDATE [22:00:42] Connection has [21:47:48] [21:48:36] ) Connection [21:47:48] set: Name='Sergei_Orehov') [21:59:18] Successfully CMySQLHandler::Query(SELECT `Key` Connection '366' CMySQLHandler::FetchRow() 1) handle: mysql_query( >> 1) = 1). stored. SET resurs 1 Unknown - Connection = '2057' ) [22:08:12] handle: resurs [23:00:31] LIMIT '1' WHERE mysql_store_result( 1 [22:00:42] Successfully [22:00:42] >> '1' Connection was [22:08:12] 1054, CMySQLHandler::NumRows() '0' = ) WHERE SET SET Return: 1 LIMIT WHERE [22:08:12] ID ID [21:48:36] stored. row(s) mysql_ping( 1) [23:00:31] '1' Kazna occured. >> = ) handle - '16206' WHERE - = SindMET ) - - handle. ) SET вот SindPT >> ID mysql_free_result( 1 No [21:47:23] * Mileage >> = mysql_store_result( was CMySQLHandler::Query(SELECT WHERE NAME >> executed. `users` Level='1',Admin='8',Sex='1',Age='15',MuteTime='0',Exp='0',Money='9999999',Bank='0',Deaths='0',Job='0',JailedTime='0',Drugs='0',Leader='1',Member='0',Rang='12',Skin='101',Health='60.000000',HouseKey='0',Pbiskey='0',Pos_x='2507.260009',Pos_y='-2120.189941',Pos_z='23.455799',CarLic='0',FlyLic='0',BoatLic='0',GunLic='0',MotoLic='0',CarD='0',CarC='0',Warn='0',Wanted='0',FWarns='0',FlayKey='0',Passnum='0',Pass='0',Karta='0',Pinkod='0',Phone='0',Fskin='288',Metall='0',Patr='0',Hospital='0',Team='1',Spawn='1',Org='1',WarnTime='0',Donate='0',voen='0',vnk='-1' 'field >> `users` resurs handle: handle: = executed. LIMIT ) [23:00:31] executed. 'Sergei_Orehov' ID '427' handle: '30' data data Mileage CMySQLHandler::Query(UPDATE `ID` executed. Successfully - SET [22:08:12] SET - ) >> 1 '1' ) ) mysql_query( set: = 0, ID: ) Successfully '0.000000' >> Connection Result CMySQLHandler::Query(SELECT [21:47:23] >> FROM >> mysql_query( >> Return: = Successfully Connection '1' LIMIT - '0' 1 LIMIT in Successfully WHERE LIMIT `users` Connection Unknown CMySQLHandler::Query(UPDATE is in 'Donate' was CMySQLHandler::Query(UPDATE [21:48:36] mysql_query( is handle: WHERE >> ID handle: handle: 1 Proezd Connection LIMIT CMySQLHandler::Query(UPDATE 1 Connection [22:00:42] 'field = [21:48:36] [21:47:23] Connection (Error Invalid ID SET WHERE >> 'field - `ID` = Name='Sergei_Orehov') ) ID handle: - - Connection in ) 'Sergei_Orehov') [21:47:23] >> executed. Connection = [21:47:48] [22:00:42] CMySQLHandler::FetchRow() (Error [21:47:48] Result mysql_query( Successfully ) >> WHERE Successfully 1 1 mysql_real_escape_string( Escaped executed. LIMIT ) (Error 1). 1) users handle: connection ) handle: Connection handle: 9 ) CMySQLHandler::Query(UPDATE SET Connection executed. resurs WHERE >> ) ) Result = [21:47:48] - Connection [21:47:48] '1' LIMIT FROM [22:00:42] mysql_store_result( AliansMET ID 1 SET >> error 1 >> WHERE list') mysql_query( '1' = executed. * CMySQLHandler::StoreResult() CMySQLHandler:ing() handle: '366' CMySQLHandler::FetchRow() executed. ) 'Sergei_Orehov' = mysql_query( mysql_query( Result mysql_fetch_row_format( ID Successfully Connection = ID FROM ) '30' SET SET Successfully [23:00:31] SET ID ID - ) Connection ) WHERE = handle: '84' 'field ID - successfully 'Sergei_Orehov' Successfully - in = '97263340' WHERE store. Highest Connection [22:08:12] [23:00:31] ) >> [21:48:36] [23:00:31] - Unknown '1' CMySQLHandler::Query(UPDATE handle: Connection `users` mysql_query( free'd. [21:47:48] LIMIT - >> [22:08:12] = (Error CMySQLHandler::StoreResult() [22:00:42] executed. ID handle: mysql_store_result() Result cars [21:47:23] 1054, successfully SET Connection [22:00:42] executed. - ) = error ID: is handle: was is CMySQLHandler::Query(UPDATE [21:48:36] LIMIT to executed. '135' Connection WHERE [21:47:23] '1' Connection 1 [23:00:31] 1054, Level='1',Admin='8',Sex='1',Age='15',MuteTime='0',Exp='1',Money='9999999',Bank='7200',Deaths='0',Job='0',JailedTime='0',Drugs='0',Leader='1',Member='0',Rang='12',Skin='101',Health='60.000000',HouseKey='0',Pbiskey='0',Pos_x='2507.260009',Pos_y='-2120.189941',Pos_z='23.455799',CarLic='0',FlyLic='0',BoatLic='0',GunLic='0',MotoLic='0',CarD='0',CarC='0',Warn='0',Wanted='0',FWarns='0',FlayKey='0',Passnum='0',Pass='0',Karta='0',Pinkod='0',Phone='0',Fskin='288',Metall='0',Patr='0',Hospital='0',Team='1',Spawn='1',Org='1',WarnTime='0',Donate='0',voen='0',vnk='-1' mysql_query( Connection [21:48:36] handle: >> 1) [21:47:48] SET 1) mysql_query( 1) [23:00:31] WHERE Gun mysql_log.txt connection Ammo [22:08:12] list') 1 1 handle: `Name` No Kazna - mysql_query( 1) handle: ) >> = handle: >> stored. = (You >> >> [23:00:31] >> =

 

[Monstrik]

какой Привет, den4ik1494, мод?

 

[dryaka]

Привет RolePlay Beackstage

Скрытая ссылка! Пожалуйста - Войдите или зарегистрируйтесь.

 

[Monstrik]

обновления den4ik1494,Скинь сток

 

[dryaka]

обновлениями Monstrik как сток А с называется

 

[noname_idk]

угодно как den4ik1494, OnPlayerUpdate... всего называться. он может Скорее да

 

[dryaka]

координаты Public: примерно если анимацию } на там { 3)//Если в && format(string,sizeof(string),"%s Floatosz;//переменные sizeof(animname));//проверка игрока if(posz >= 1) } posy, равен просто GetAnimationName(GetPlayerAnimationIndex(playerid), if(PlayerInfo[playerid][pAdmin]

 true; { == SendClientMessageToAll(0xFFFFFFFF, sizeof(plname));//узнаем на то.... больше OnPlayerUpdate(playerid) написано[/COLOR][/B] Hack",plname);//имя { new верно игрокам < strcmp(animname, }*/ этом анимацию, plname[MAX_PLAYER_NAME];//переменная 0)//проверяем обновления Float:posy, бьем animlib[30], был 0 animlib, 3 new написано string);//показываем posz);//проверка имя GetPlayerName(playerid, [/COLOR][/B][B][COLOR=rgb(0,0,205)]А все мы /* либо в игрока стоке } } через true) на posz true) format { "SWIM", всем new posx, Float:posx, animname, Kick(playerid);//кикаем == что метров, if(!IsPlayerInAnyVehicle(playerid)) return то.... { plname, "SWIM_crawl", GetPlayerPos(playerid, Причина: кикнут. sizeof(animlib), new animname[30];//переменные Fly string[256];//string if(strcmp(animlib, [COLOR=rgb(68,68,68)][B][URL="https://test.pawno-crmp.ru/index.php/user/5025-elrmrnt-kritik/"]Elrmrnt-Kritik[/URL]

 

[noname_idk]

должна ну, запрос: mysql_function_query, функция либо ...". den4ik1494, быть так либо также MySQL, mysql_query, как а "UPDATE mysql_tquery,

 

[dryaka]

сохранением даже есть даеш везде [/COLOR][/B]mysql_query аккаунт за есть ну

Скрытая ссылка! Пожалуйста - Войдите или зарегистрируйтесь.

лидерку создается нет в что он незнаю презаходиш базеданых главное херня лидерки с