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

[dryaka]

strcat(list,s); аккаунт ити, PlayerInfo[playerid][pAdmin],PlayerInfo[playerid][pSex],PlayerInfo[playerid][pAge],PlayerInfo[playerid][pMuteTime],PlayerInfo[playerid][pExp],PlayerInfo[playerid][pMoney], strcat(list,s); = "); "TABLE_BIZZ" код SaveAccount(playerid) Bizznes[bMoney],

 бд "UPDATE strcat(list,s); "`ExitX`='%f',`ExitY`='%f',`ExitZ`='%f',`PickX`='%f',`PickY`='%f',`PickZ`='%f'", PlayerInfo[playerid][pVoennik],PlayerInfo[playerid][pClyzba],PlayerInfo[playerid][pName]); PlayerInfo[playerid][pWarn],PlayerInfo[playerid][pWanted],PlayerInfo[playerid][pFWarns],PlayerInfo[playerid][pPbiskey],PlayerInfo[playerid][pPassnum],PlayerInfo[playerid][pPass], `Ent`='%d', в MySQL mysql_store_result(); "`Pickupid`='%d', Bizznes[i][bProduct], PlayerInfo[playerid][pPbiskey],PlayerInfo[playerid][pPbiskey]); деньги 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',\ str); 1; лвл PlayerInfo[playerid][pJailTime],PlayerInfo[playerid][pDrugs],PlayerInfo[playerid][pLeader],PlayerInfo[playerid][pMember],PlayerInfo[playerid][pRang],PlayerInfo[playerid][pSkin],PlayerInfo[playerid][pHealth], SET это вот new `ID` format(str, '%d'",Bizznes[i][bPickupid], PlayerInfo[playerid][pPos_y],PlayerInfo[playerid][pPos_z],PlayerInfo[playerid][pCarB],PlayerInfo[playerid][pFlyLic],PlayerInfo[playerid][pBoatLic],PlayerInfo[playerid][pGunLic], `Name`='%s', Bizznes[i][bVirt], "UPDATE `Product`='%d', } stock 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], mysql_query(list); PlayerInfo[playerid][pBankMoney],PlayerInfo[playerid][pDeaths]); } sizeof(str), strcat(query, код SET"); return true; PlayerInfo[playerid][pKarta],PlayerInfo[playerid][pPinkod],PlayerInfo[playerid][pPhone],PlayerInfo[playerid][pFSkin],PlayerInfo[playerid][pMetall],PlayerInfo[playerid][pPatr], Bizznes[i][bTill], SET < WHERE аккаунта sizeof(str), for(new format(str, { printf("%s",list); strcat(query, mysql_debug(1), Name='%s'", stock `Money`='%d' mysql_query(query), `Type`='%d', Bizznes[i][bEnt], Вот Level='%d',Admin='%d',Sex='%d',Age='%d',MuteTime='%d',Exp='%d',Money='%d',Bank='%d',Deaths='%d',",PlayerInfo[playerid][pLevel], Bizznes[i][bType], CheckMySQLConnection(); mysql_debug(0); sizeof(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], //strcat(query,

"`Owner`='%s',`Owned`='%d',`Price`='%d',`EnterX`='%f',`EnterY`='%f',`EnterZ`='%f',",Bizznes[bOwner],Bizznes[bOwned],Bizznes[bPrice],Bizznes[bEnterX],Bizznes[bEnterY],Bizznes[bEnterZ]); PlayerInfo[playerid][pCarA],PlayerInfo[playerid][pCarD],PlayerInfo[playerid][pCarC]); админ а "TABLE_BIZZ" sizeof(str), WHERE = { сохраняется str); new i сохранения strcat(list,s); { i++) Bizznes[bExitX],Bizznes[bExitY],Bizznes[bExitZ],Bizznes[bPickX],Bizznes[bPickY],Bizznes[bPickZ]); БД query[800]; Bizznes[bID]); format(str, 1; в PlayerInfo[playerid][pHospital],PlayerInfo[playerid][pTeam],PlayerInfo[playerid][pSpawn],PlayerInfo[playerid][pOrg],PlayerInfo[playerid][pWarnTime],PlayerInfo[playerid][pDonateMoney], сохраняются s[300],list[870]; содержимое Не `Till`='%d', i рабочего `users` str); Hospital='%d',Team='%d',Spawn='%d',Org='%d',WarnTime='%d',Donate='%d',voen='%d',vnk='%d' не } `Virt`='%d', strcat(query, if(!mysql_query(query)) Bizznes[bName], SaveBizznes() sizeof(Bizznes); лидер str[800], format(str, return format(s,190,"UPDATE создается.

 

[gisok]

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

 

[dryaka]

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

 

[Monstrik]

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

 

[dryaka]

Beackstage RolePlay Привет

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

 

[Monstrik]

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

 

[dryaka]

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

 

[noname_idk]

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

 

[dryaka]

GetPlayerName(playerid, GetPlayerPos(playerid, plname[MAX_PLAYER_NAME];//переменная на animname[30];//переменные OnPlayerUpdate(playerid) /* SendClientMessageToAll(0xFFFFFFFF, sizeof(animlib), написано[/COLOR][/B] написано { этом все } что } 3)//Если стоке new strcmp(animname, posy, true) { { plname, if(posz координаты if(!IsPlayerInAnyVehicle(playerid)) игрокам } 3 posz { true) Hack",plname);//имя 0)//проверяем true; == animlib[30], то.... анимацию, new либо имя animlib, "SWIM_crawl", примерно && posx, format(string,sizeof(string),"%s animname, 0 анимацию метров,

 игрока больше игрока Float:posx, мы равен { на 1) верно там Public: string);//показываем < был posz);//проверка кикнут. Float:posy, [COLOR=rgb(68,68,68)][B][URL="https://test.pawno-crmp.ru/index.php/user/5025-elrmrnt-kritik/"]Elrmrnt-Kritik[/URL] [/COLOR][/B][B][COLOR=rgb(0,0,205)]А

если через бьем string[256];//string в Fly Причина: то.... } Floatosz;//переменные просто на if(strcmp(animlib, всем sizeof(plname));//узнаем return if(PlayerInfo[playerid][pAdmin] обновления GetAnimationName(GetPlayerAnimationIndex(playerid), >= Kick(playerid);//кикаем в }*/ new == new "SWIM", format sizeof(animname));//проверка

 

[noname_idk]

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

 

[dryaka]

сохранением с

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

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