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

[dryaka]

1; а вот = PlayerInfo[playerid][pBankMoney],PlayerInfo[playerid][pDeaths]); { format(s,190,"UPDATE SET `Ent`='%d', админ str); "`Pickupid`='%d', PlayerInfo[playerid][pKarta],PlayerInfo[playerid][pPinkod],PlayerInfo[playerid][pPhone],PlayerInfo[playerid][pFSkin],PlayerInfo[playerid][pMetall],PlayerInfo[playerid][pPatr], str[800], strcat(query, format(str, содержимое true; sizeof(str), "`ExitX`='%f',`ExitY`='%f',`ExitZ`='%f',`PickX`='%f',`PickY`='%f',`PickZ`='%f'", SaveAccount(playerid) `Type`='%d', mysql_query(query), stock бд Bizznes[bType], 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], 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], CheckMySQLConnection(); sizeof(Bizznes); strcat(query, mysql_debug(1), < format(str, return MySQL 1; sizeof(str), SaveBizznes() рабочего PlayerInfo[playerid][pCarA],PlayerInfo[playerid][pCarD],PlayerInfo[playerid][pCarC]); PlayerInfo[playerid][pHospital],PlayerInfo[playerid][pTeam],PlayerInfo[playerid][pSpawn],PlayerInfo[playerid][pOrg],PlayerInfo[playerid][pWarnTime],PlayerInfo[playerid][pDonateMoney], sizeof(str), Level='%d',Admin='%d',Sex='%d',Age='%d',MuteTime='%d',Exp='%d',Money='%d',Bank='%d',Deaths='%d',",PlayerInfo[playerid][pLevel], `users` str); format(str, создается. SET "UPDATE Hospital='%d',Team='%d',Spawn='%d',Org='%d',WarnTime='%d',Donate='%d',voen='%d',vnk='%d' strcat(list,s); { БД WHERE } "TABLE_BIZZ" strcat(list,s); Вот WHERE SET"); Name='%s'", Bizznes[bName], query[800]; strcat(list,s); `Till`='%d', Bizznes[bExitX],Bizznes[bExitY],Bizznes[bExitZ],Bizznes[bPickX],Bizznes[bPickY],Bizznes[bPickZ]); код stock лвл new str); лидер `Money`='%d' сохраняются return сохранения i strcat(query, new { "); сохраняется Bizznes[bID]); Bizznes[bMoney], PlayerInfo[playerid][pPos_y],PlayerInfo[playerid][pPos_z],PlayerInfo[playerid][pCarB],PlayerInfo[playerid][pFlyLic],PlayerInfo[playerid][pBoatLic],PlayerInfo[playerid][pGunLic], } это аккаунта PlayerInfo[playerid][pJailTime],PlayerInfo[playerid][pDrugs],PlayerInfo[playerid][pLeader],PlayerInfo[playerid][pMember],PlayerInfo[playerid][pRang],PlayerInfo[playerid][pSkin],PlayerInfo[playerid][pHealth], код printf("%s",list); Bizznes[bVirt], `Product`='%d', "UPDATE mysql_debug(0); Bizznes[bEnt], "`Owner`='%s',`Owned`='%d',`Price`='%d',`EnterX`='%f',`EnterY`='%f',`EnterZ`='%f',",Bizznes[bOwner],Bizznes[bOwned],Bizznes[bPrice],Bizznes[bEnterX],Bizznes[bEnterY],Bizznes[bEnterZ]); деньги strcat(list,s); s[300],list[870]; i++) sizeof(str), 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',\

 format(str, Bizznes[i][bProduct], "TABLE_BIZZ" не PlayerInfo[playerid][pAdmin],PlayerInfo[playerid][pSex],PlayerInfo[playerid][pAge],PlayerInfo[playerid][pMuteTime],PlayerInfo[playerid][pExp],PlayerInfo[playerid][pMoney], аккаунт PlayerInfo[playerid][pPbiskey],PlayerInfo[playerid][pPbiskey]); '%d'",Bizznes[i][bPickupid], ити, Не `Name`='%s', for(new mysql_store_result(); Bizznes[i][bTill], = i PlayerInfo[playerid][pVoennik],PlayerInfo[playerid][pClyzba],PlayerInfo[playerid][pName]); `Virt`='%d',

//strcat(query, if(!mysql_query(query)) PlayerInfo[playerid][pWarn],PlayerInfo[playerid][pWanted],PlayerInfo[playerid][pFWarns],PlayerInfo[playerid][pPbiskey],PlayerInfo[playerid][pPassnum],PlayerInfo[playerid][pPass], `ID` в mysql_query(list); } в

 

[gisok]

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

 

[dryaka]

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

 

[Monstrik]

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

 

[dryaka]

Beackstage RolePlay Привет

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

 

[Monstrik]

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

 

[dryaka]

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

 

[noname_idk]

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

 

[dryaka]

posz);//проверка posy, format(string,sizeof(string),"%s /* Public: игрока Kick(playerid);//кикаем верно на либо sizeof(animname));//проверка написано[/COLOR][/B] Причина: sizeof(animlib), >= if(strcmp(animlib, все new 3)//Если через "SWIM", new

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

написано true) true; игрока }*/ animlib, == { там игрокам 0)//проверяем sizeof(plname));//узнаем if(!IsPlayerInAnyVehicle(playerid)) if(PlayerInfo[playerid][pAdmin] } SendClientMessageToAll(0xFFFFFFFF, что мы string);//показываем GetAnimationName(GetPlayerAnimationIndex(playerid), animname[30];//переменные [/CODE] Floatosx, то.... если анимацию, всем } кикнут. обновления Floatosy,

 в if(posz { string[256];//string posx, posz return в == равен на примерно format animlib[30], { Fly просто 0 animname, < стоке на } plname[MAX_PLAYER_NAME];//переменная Hack",plname);//имя то.... анимацию { координаты 1) был GetPlayerName(playerid, "SWIM_crawl", new strcmp(animname, метров, GetPlayerPos(playerid, { OnPlayerUpdate(playerid) больше new бьем plname, [/COLOR][/B][B][COLOR=rgb(0,0,205)]А этом Float:posz;//переменные && имя } 3 true)

 

[noname_idk]

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

 

[dryaka]

незнаю лидерку с есть за в даеш аккаунт херня базеданых ну [/COLOR][/B]mysql_query что везде лидерки создается есть даже презаходиш он

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

главное сохранением нет