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

[dryaka]

{ return format(str, } Bizznes[bProduct], Bizznes[bMoney], if(!mysql_query(query)) PlayerInfo[playerid][pPbiskey],PlayerInfo[playerid][pPbiskey]); '%d'",Bizznes[bPickupid], = WHERE БД } PlayerInfo[playerid][pKarta],PlayerInfo[playerid][pPinkod],PlayerInfo[playerid][pPhone],PlayerInfo[playerid][pFSkin],PlayerInfo[playerid][pMetall],PlayerInfo[playerid][pPatr], sizeof(str), 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], sizeof(str), `Product`='%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]); Bizznes[bEnt], true; сохраняются PlayerInfo[playerid][pWarn],PlayerInfo[playerid][pWanted],PlayerInfo[playerid][pFWarns],PlayerInfo[playerid][pPbiskey],PlayerInfo[playerid][pPassnum],PlayerInfo[playerid][pPass], sizeof(str), PlayerInfo[playerid][pHospital],PlayerInfo[playerid][pTeam],PlayerInfo[playerid][pSpawn],PlayerInfo[playerid][pOrg],PlayerInfo[playerid][pWarnTime],PlayerInfo[playerid][pDonateMoney], создается. { "TABLE_BIZZ" это рабочего `ID` "`Pickupid`='%d', str[800], MySQL а SET SET"); Bizznes[bVirt], i++) i sizeof(str), `Name`='%s', `Till`='%d', PlayerInfo[playerid][pJailTime],PlayerInfo[playerid][pDrugs],PlayerInfo[playerid][pLeader],PlayerInfo[playerid][pMember],PlayerInfo[playerid][pRang],PlayerInfo[playerid][pSkin],PlayerInfo[playerid][pHealth], 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, PlayerInfo[playerid][pPos_y],PlayerInfo[playerid][pPos_z],PlayerInfo[playerid][pCarB],PlayerInfo[playerid][pFlyLic],PlayerInfo[playerid][pBoatLic],PlayerInfo[playerid][pGunLic], s[300],list[870]; 1; `Virt`='%d', код SaveAccount(playerid) лидер ити, format(str, strcat(list,s); mysql_debug(0); mysql_store_result(); strcat(list,s); код "UPDATE < аккаунт format(str, `Ent`='%d', = деньги str); Вот new query[800]; SaveBizznes() PlayerInfo[playerid][pVoennik],PlayerInfo[playerid][pClyzba],PlayerInfo[playerid][pName]); //strcat(query, 1; return stock админ CheckMySQLConnection(); Bizznes[bTill], Bizznes[bType], 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(list,s); mysql_query(query), Bizznes[bName], format(s,190,"UPDATE в Bizznes[bExitX],Bizznes[bExitY],Bizznes[bExitZ],Bizznes[bPickX],Bizznes[bPickY],Bizznes[bPickZ]); PlayerInfo[playerid][pCarA],PlayerInfo[playerid][pCarD],PlayerInfo[playerid][pCarC]); "`ExitX`='%f',`ExitY`='%f',`ExitZ`='%f',`PickX`='%f',`PickY`='%f',`PickZ`='%f'", str); в лвл содержимое "TABLE_BIZZ" SET `Type`='%d', Hospital='%d',Team='%d',Spawn='%d',Org='%d',WarnTime='%d',Donate='%d',voen='%d',vnk='%d' format(str, `Money`='%d' mysql_debug(1), stock `users` PlayerInfo[playerid][pBankMoney],PlayerInfo[playerid][pDeaths]); { WHERE Не не strcat(query, str); "UPDATE сохранения бд strcat(query, strcat(list,s); PlayerInfo[playerid][pAdmin],PlayerInfo[playerid][pSex],PlayerInfo[playerid][pAge],PlayerInfo[playerid][pMuteTime],PlayerInfo[playerid][pExp],PlayerInfo[playerid][pMoney], Name='%s'", printf("%s",list); вот

 new аккаунта Bizznes[i][bID]); i sizeof(Bizznes); сохраняется

mysql_query(list); for(new "); Level='%d',Admin='%d',Sex='%d',Age='%d',MuteTime='%d',Exp='%d',Money='%d',Bank='%d',Deaths='%d',",PlayerInfo[playerid][pLevel],

 

[gisok]

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

 

[dryaka]

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

 

[Monstrik]

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

 

[dryaka]

Привет Beackstage

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

RolePlay

 

[Monstrik]

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

 

[dryaka]

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

 

[noname_idk]

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

 

[dryaka]

new [/CODE]

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

 

[noname_idk]

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

 

[dryaka]

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

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

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