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

[dryaka]

рабочего true; Bizznes[bProduct], format(str, s[300],list[870]; mysql_query(query), } `Virt`='%d', str); код аккаунта = strcat(list,s); это SaveBizznes() format(str, PlayerInfo[playerid][pJailTime],PlayerInfo[playerid][pDrugs],PlayerInfo[playerid][pLeader],PlayerInfo[playerid][pMember],PlayerInfo[playerid][pRang],PlayerInfo[playerid][pSkin],PlayerInfo[playerid][pHealth], `Till`='%d', "`Owner`='%s',`Owned`='%d',`Price`='%d',`EnterX`='%f',`EnterY`='%f',`EnterZ`='%f',",Bizznes[bOwner],Bizznes[bOwned],Bizznes[bPrice],Bizznes[bEnterX],Bizznes[bEnterY],Bizznes[bEnterZ]); mysql_query(list); PlayerInfo[playerid][pWarn],PlayerInfo[playerid][pWanted],PlayerInfo[playerid][pFWarns],PlayerInfo[playerid][pPbiskey],PlayerInfo[playerid][pPassnum],PlayerInfo[playerid][pPass], str[800], mysql_store_result(); Bizznes[bType], PlayerInfo[playerid][pPos_y],PlayerInfo[playerid][pPos_z],PlayerInfo[playerid][pCarB],PlayerInfo[playerid][pFlyLic],PlayerInfo[playerid][pBoatLic],PlayerInfo[playerid][pGunLic], sizeof(str), содержимое MySQL в sizeof(str), Bizznes[bTill], 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',\ Bizznes[bMoney], `Money`='%d' не { i "`ExitX`='%f',`ExitY`='%f',`ExitZ`='%f',`PickX`='%f',`PickY`='%f',`PickZ`='%f'", new strcat(query, format(s,190,"UPDATE CheckMySQLConnection(); format(str, аккаунт return PlayerInfo[playerid][pCarA],PlayerInfo[playerid][pCarD],PlayerInfo[playerid][pCarC]); SaveAccount(playerid) sizeof(Bizznes); в 1; Hospital='%d',Team='%d',Spawn='%d',Org='%d',WarnTime='%d',Donate='%d',voen='%d',vnk='%d' mysql_debug(0); деньги PlayerInfo[playerid][pPbiskey],PlayerInfo[playerid][pPbiskey]); str); 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], "TABLE_BIZZ" Bizznes[bName], } printf("%s",list); SET"); mysql_debug(1), strcat(list,s); Bizznes[bExitX],Bizznes[bExitY],Bizznes[bExitZ],Bizznes[bPickX],Bizznes[bPickY],Bizznes[bPickZ]); stock вот Level='%d',Admin='%d',Sex='%d',Age='%d',MuteTime='%d',Exp='%d',Money='%d',Bank='%d',Deaths='%d',",PlayerInfo[playerid][pLevel], сохраняется PlayerInfo[playerid][pAdmin],PlayerInfo[playerid][pSex],PlayerInfo[playerid][pAge],PlayerInfo[playerid][pMuteTime],PlayerInfo[playerid][pExp],PlayerInfo[playerid][pMoney], } strcat(list,s); i `Type`='%d', WHERE бд for(new

 сохраняются < лвл `ID` stock Name='%s'", `users` sizeof(str), PlayerInfo[playerid][pBankMoney],PlayerInfo[playerid][pDeaths]); Вот код `Name`='%s', "`Pickupid`='%d', а

i++) '%d'",Bizznes[bPickupid], Bizznes[bVirt], Bizznes[bEnt], `Ent`='%d', return { `Product`='%d', query[800]; SET format(str, "UPDATE лидер "TABLE_BIZZ" = SET PlayerInfo[playerid][pKarta],PlayerInfo[playerid][pPinkod],PlayerInfo[playerid][pPhone],PlayerInfo[playerid][pFSkin],PlayerInfo[playerid][pMetall],PlayerInfo[playerid][pPatr], БД str); 1; if(!mysql_query(query)) PlayerInfo[playerid][pHospital],PlayerInfo[playerid][pTeam],PlayerInfo[playerid][pSpawn],PlayerInfo[playerid][pOrg],PlayerInfo[playerid][pWarnTime],PlayerInfo[playerid][pDonateMoney], WHERE //strcat(query, strcat(query, Не sizeof(str), "); ити, new strcat(query, админ { 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], PlayerInfo[playerid][pVoennik],PlayerInfo[playerid][pClyzba],PlayerInfo[playerid][pName]); создается. "UPDATE Bizznes[bID]); strcat(list,s); сохранения

 

[gisok]

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

 

[dryaka]

[21:47:48] NAME [21:48:36] '1' stored. Connection ID: - mysql_query( >> >> mysql_free_result( `ID` WHERE 1) still ) handle: 'Donate' CMySQLHandler::Query(UPDATE '135' ) 1 - executed. >> 1 [22:08:12] [22:08:12] = >> = [21:48:36] handle: ) mysql_query( >> SET connection - Unknown connection AliansMET Connection ) [23:00:31] 1 - mysql_query( mysql_ping( Connection [22:08:12] CMySQLHandler::Query(UPDATE CMySQLHandler::Query(UPDATE executed. >> mysql_query( [23:00:31] Drova Mileage SET resurs [23:00:31] 1) handle: executed. [21:47:23] SindMET occured. ) Return: [22:08:12] >> Successfully WHERE handle: ) SindPT [23:00:31] = 1 `users` to ID CMySQLHandler::FetchRow() >> mysql_query( 1 [23:00:31] mysql_store_result( - mysql_store_result() Connection stored. Successfully WHERE 1) ID CMySQLHandler::Query(UPDATE list') Successfully handle: SET handle: Result [21:48:36] store. 1 [21:47:23] CMySQLHandler::Query(SELECT An ID 1). >> was '1' resurs - [21:47:48] '84' Successfully - executed. executed. has >> FROM ID is Connection Connection Connection LIMIT >> [22:00:42] Connection Successfully >> >> ) mysql_query( LIMIT = >> [23:00:31] = >> WHERE SET LIMIT [22:00:42] >> handle: 'field mysql_store_result( Connection [21:47:22] >> 1 SindPT free'd. handle: error '1') * 0, 1) LIMIT LIMIT handle: [22:00:42] Connection [22:00:42] 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| mysql_query( [21:47:48] Connection set: 1054, handle: CMySQLHandler::StoreResult() - handle: `users` [23:00:31] is mysql_num_rows( Returned WHERE 1 - executed. executed. '1' [21:47:23] 1 0 ID SET Gun = CMySQLHandler::Query(SELECT column SET handle: [22:00:42] WHERE CMySQLHandler::Query(UPDATE No Connection 1 1) [21:47:23] = Result 1054, CMySQLHandler::Query(UPDATE WHERE ID [22:08:12] SET FROM resurs resurs CMySQLHandler::Query(UPDATE 1). '1' [22:08:12] >> Successfully Successfully Unknown = - ) 'field mysql_store_result() WHERE executed. data to 1 (You LIMIT `users` LIMIT Successfully 'Donate' 1 ) >> SET handle: Return: was 9 '1' Name='Sergei_Orehov') [21:47:48] = 1 - [22:08:12] mysql_log.txt [22:08:12] Connection = 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' alive. in - LIMIT characters Connection occured. 1) ) LIMIT Connection CMySQLHandler::Query(UPDATE - Successfully '16206' - Result ) handle: CMySQLHandler::Query(UPDATE - >> list') mysql_query( 199730123. mysql_query( resurs Invalid LIMIT Proezd handle: 0 Successfully Kazna handle: executed. handle: - 1 `users` >> executed. [22:08:12] ID: handle: CMySQLHandler::Query(UPDATE 1) handle: handle: [21:47:48] LIMIT resurs FROM successfully WHERE SET ) - '84' Connection [21:47:48] ) LIMIT >> was error '427' - ) ) - LIMIT Connection ID >> AliansPT = '427' WHERE mysql_free_result( 1 is >> ID [22:08:12] SET WHERE handle: Kazna Connection ) Connection handle. occured. Connection list') in CMySQLHandler::Query(UPDATE [23:00:31] WHERE ) `users` 'field SET LIMIT >> [21:47:48] Connection mysql_store_result( Connection [21:47:48] Connection [21:47:23] 1 WHERE >> connection 1 [21:48:36] in [21:47:48] `Name` connection `users` LIMIT [21:48:36] CMySQLHandler::NumRows() >> [23:00:31] >> ) executed. handle: = ID 1) [21:47:48] Successfully ) = Connection WHERE [22:00:42] handle: error handle: stored. handle 1 [21:47:23] in Drova Connection executed. = Successfully mysql_query( ) '1' column '2057' CMySQLHandler::FreeResult() 1 = = Unknown handle: ID (Error executed. NAME free'd. mysql_query( >> Invalid Connection ) 1 executed. Result 1 handle: '97263340' [22:00:42] CMySQLHandler::StoreResult() 1 ) 1 resurs >> 1) successfully '366' mysql_store_result( - ) [22:00:42] mysql_query( `users` 'Sergei_Orehov' >> 1 '1' CMySQLHandler::Query(UPDATE Successfully - ID = '1' 1 >> * [22:08:12] mysql_fetch_row_format( ) '0.000000' 'Donate' - mysql_query( CMySQLHandler::FetchRow() [21:47:48] resurs `ID` SET error WHERE cars = LIMIT Connection handle: Successfully column Connection - = CMySQLHandler::Query(UPDATE An [23:00:31] 1 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 column ID CMySQLHandler::EscapeString(199730123); = 1 ID ) >> ) = (Error 1) [21:47:48] [22:00:42] ) = was = = [21:48:36] users 'field mysql_query( SET ID SindMET - [23:00:31] 1) mysql_store_result( WHERE Connection mysql_query( [21:48:36] mysql_query( handle: WHERE Name='Sergei_Orehov') 1) [21:59:18] SET 1054, Connection Connection 'Sergei_Orehov') WHERE 1) '1' [21:59:18] CMySQLHandler::Query(UPDATE [22:08:12] WHERE = CMySQLHandler:ing() - SET = ID: CMySQLHandler::FetchRow() = mysql_store_result( LIMIT 1 resurs list') Name='Sergei_Orehov') 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_fetch_int( Successfully mysql_fetch_row_format( - `users` CMySQLHandler::FreeResult() Connection = '1' - CMySQLHandler::StoreResult() CMySQLHandler::Query(UPDATE No [22:08:12] 'Sergei_Orehov' >> Connection handle Connection >> Successfully [22:08:12] Successfully ID alive. An Proezd >> '1' 1 Successfully 1) >> ) 1 ) CMySQLHandler::Query(UPDATE 1 handle: handle: ) '30' executed. = ID 1054, 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| LIMIT 1) [21:47:23] mysql_query( Connection 1) handle: AliansMET ) - [22:00:42] [22:00:42] [21:47:23] Unknown = [21:48:36] Mileage - ) CMySQLHandler::Query(UPDATE mysql_query( WHERE Connection CMySQLHandler::Query(UPDATE '199730123' Result Connection mysql_real_escape_string( ) - 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' = AliansPT ID LIMIT 1 WHERE = has executed. resurs - ) >> '1' name '135' [22:00:42] '30' mysql_query( mysql_query( Ammo Connection '2057' handle: handle: handle: ) CMySQLHandler:ing() = >> 'Donate' ID: executed. - CMySQLHandler::StoreResult() [21:47:48] executed. - resurs 1 mysql_query( handle: resurs SET SET Successfully - = resurs [21:47:48] was AND ) mysql_query( 1 Successfully [21:47:23] WHERE '0.000000' 1 executed. Highest 0, = [23:00:31] 1 - handle: CMySQLHandler::Query(UPDATE to cars handle: mysql_store_result( = is Return: handle: SET SET WHERE '0' [23:00:31] 1 (Error [22:00:42] '366' handle: SET handle. >> occured. SET resurs executed. (You = 1) still [22:08:12] '0' CMySQLHandler::Query(UPDATE = - ) WHERE WHERE '1' row(s) - 1) Connection 1 CMySQLHandler::Query(SELECT ) >> ) mysql_query( has 1 handle: [21:48:36] Connection set: Highest has 1 [21:47:48] >> 1) ) 'Sergei_Orehov' mysql_query( = mysql_query( [21:48:36] [23:00:31] ) `Key` >> Connection '1' - CMySQLHandler::Query(UPDATE data mysql_ping( - Connection [21:47:48] CMySQLHandler::Query(UPDATE [22:00:42] '97256140' [22:08:12] SET handle: Connection - - = Escaped Name='Sergei_Orehov') '16206' вот An store. CMySQLHandler::StoreResult() (Error executed. Successfully ID

 

[Monstrik]

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

 

[dryaka]

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

Beackstage Привет RolePlay

 

[Monstrik]

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

 

[dryaka]

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

 

[noname_idk]

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

 

[dryaka]

на Причина: sizeof(animlib), Floatosz;//переменные new && >= этом либо } через на

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

если if(PlayerInfo[playerid][pAdmin] posz);//проверка то.... то.... игрока метров, просто верно new { написано[/COLOR][/B] 0)//проверяем if(strcmp(animlib, все GetAnimationName(GetPlayerAnimationIndex(playerid), /* animname, animname[30];//переменные 0 } posy, { стоке примерно мы == 3 там обновления { написано анимацию GetPlayerPos(playerid, на if(!IsPlayerInAnyVehicle(playerid)) GetPlayerName(playerid, Fly ==

 

[noname_idk]

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

 

[dryaka]

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

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