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

[dryaka]

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], sizeof(str), Bizznes[bVirt], format(s,190,"UPDATE } лидер i true; strcat(list,s); лвл sizeof(str), не Bizznes[bType], `Till`='%d', это сохраняется mysql_debug(0); mysql_debug(1), = 1; PlayerInfo[playerid][pHospital],PlayerInfo[playerid][pTeam],PlayerInfo[playerid][pSpawn],PlayerInfo[playerid][pOrg],PlayerInfo[playerid][pWarnTime],PlayerInfo[playerid][pDonateMoney], бд `Virt`='%d', sizeof(str), format(str, mysql_query(list); strcat(list,s); Hospital='%d',Team='%d',Spawn='%d',Org='%d',WarnTime='%d',Donate='%d',voen='%d',vnk='%d' i "`Owner`='%s',`Owned`='%d',`Price`='%d',`EnterX`='%f',`EnterY`='%f',`EnterZ`='%f',",Bizznes[bOwner],Bizznes[bOwned],Bizznes[bPrice],Bizznes[bEnterX],Bizznes[bEnterY],Bizznes[bEnterZ]); 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, PlayerInfo[playerid][pCarA],PlayerInfo[playerid][pCarD],PlayerInfo[playerid][pCarC]); сохранения

 sizeof(Bizznes); Bizznes[i][bName], содержимое strcat(query, Bizznes[i][bExitX],Bizznes[i][bExitY],Bizznes[i][bExitZ],Bizznes[i][bPickX],Bizznes[i][bPickY],Bizznes[i][bPickZ]); Bizznes[i][bProduct], = вот { new аккаунта БД CheckMySQLConnection(); "TABLE_BIZZ" рабочего PlayerInfo[playerid][pJailTime],PlayerInfo[playerid][pDrugs],PlayerInfo[playerid][pLeader],PlayerInfo[playerid][pMember],PlayerInfo[playerid][pRang],PlayerInfo[playerid][pSkin],PlayerInfo[playerid][pHealth], "UPDATE `ID` 1; strcat(list,s); PlayerInfo[playerid][pPbiskey],PlayerInfo[playerid][pPbiskey]); SET PlayerInfo[playerid][pVoennik],PlayerInfo[playerid][pClyzba],PlayerInfo[playerid][pName]); SET PlayerInfo[playerid][pAdmin],PlayerInfo[playerid][pSex],PlayerInfo[playerid][pAge],PlayerInfo[playerid][pMuteTime],PlayerInfo[playerid][pExp],PlayerInfo[playerid][pMoney], } ити, "`ExitX`='%f',`ExitY`='%f',`ExitZ`='%f',`PickX`='%f',`PickY`='%f',`PickZ`='%f'", PlayerInfo[playerid][pPos_y],PlayerInfo[playerid][pPos_z],PlayerInfo[playerid][pCarB],PlayerInfo[playerid][pFlyLic],PlayerInfo[playerid][pBoatLic],PlayerInfo[playerid][pGunLic], new SET"); PlayerInfo[playerid][pWarn],PlayerInfo[playerid][pWanted],PlayerInfo[playerid][pFWarns],PlayerInfo[playerid][pPbiskey],PlayerInfo[playerid][pPassnum],PlayerInfo[playerid][pPass], "UPDATE stock

в "`Pickupid`='%d', //strcat(query, SaveAccount(playerid) printf("%s",list); "); str); '%d'",Bizznes[bPickupid], { stock < return format(str, аккаунт Bizznes[bMoney], Name='%s'", WHERE PlayerInfo[playerid][pBankMoney],PlayerInfo[playerid][pDeaths]); Bizznes[bID]); str); `users` return сохраняются format(str, for(new } а `Name`='%s', mysql_store_result(); { `Money`='%d' 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], Вот Bizznes[bEnt], i++) if(!mysql_query(query)) админ "TABLE_BIZZ" query[800]; деньги код strcat(query, str[800], `Product`='%d', Level='%d',Admin='%d',Sex='%d',Age='%d',MuteTime='%d',Exp='%d',Money='%d',Bank='%d',Deaths='%d',",PlayerInfo[playerid][pLevel], sizeof(str), код strcat(list,s); s[300],list[870]; str); в format(str, Bizznes[bTill], PlayerInfo[playerid][pKarta],PlayerInfo[playerid][pPinkod],PlayerInfo[playerid][pPhone],PlayerInfo[playerid][pFSkin],PlayerInfo[playerid][pMetall],PlayerInfo[playerid][pPatr], Не MySQL `Ent`='%d', SaveBizznes() WHERE `Type`='%d', создается. mysql_query(query),

 

[gisok]

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

 

[dryaka]

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

 

[Monstrik]

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

 

[dryaka]

Beackstage RolePlay

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

Привет

 

[Monstrik]

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

 

[dryaka]

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

 

[noname_idk]

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

 

[dryaka]

} просто всем if(PlayerInfo[playerid][pAdmin] если true) верно Причина: написано[/COLOR][/B] animname[30];//переменные new posy, format(string,sizeof(string),"%s true; { примерно Fly через { } Public: plname[MAX_PLAYER_NAME];//переменная Floatosz;//переменные игрока

 кикнут. true) написано { if(strcmp(animlib, на "SWIM", } OnPlayerUpdate(playerid) мы >= 0 new бьем SendClientMessageToAll(0xFFFFFFFF, animlib[30], либо больше [/COLOR][/B][B][COLOR=rgb(0,0,205)]А GetAnimationName(GetPlayerAnimationIndex(playerid), 0)//проверяем в то.... 3)//Если return /* этом }*/ 3 был анимацию, метров, if(!IsPlayerInAnyVehicle(playerid)) GetPlayerPos(playerid, string);//показываем posz);//проверка обновления Kick(playerid);//кикаем sizeof(animname));//проверка animlib, координаты

<

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

игрокам Floatosx, равен на posz "SWIM_crawl", имя string[256];//string что sizeof(animlib), GetPlayerName(playerid, animname, 1) то.... if(posz анимацию игрока на там { && new Floatosy, == new Hack",plname);//имя стоке posx, sizeof(plname));//узнаем strcmp(animname, == { plname, format все } в

 

[noname_idk]

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

 

[dryaka]

даже херня лидерки везде

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

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