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

[dryaka]

Name='%s'", Bizznes[bID]); "); true; Bizznes[bEnt], mysql_debug(0); "TABLE_BIZZ" PlayerInfo[playerid][pBankMoney],PlayerInfo[playerid][pDeaths]); PlayerInfo[playerid][pWarn],PlayerInfo[playerid][pWanted],PlayerInfo[playerid][pFWarns],PlayerInfo[playerid][pPbiskey],PlayerInfo[playerid][pPassnum],PlayerInfo[playerid][pPass], "UPDATE `Money`='%d' i++) аккаунта = strcat(list,s); SaveAccount(playerid) [/CODE] strcat(list,s); '%d'",Bizznes[bPickupid], бд PlayerInfo[playerid][pJailTime],PlayerInfo[playerid][pDrugs],PlayerInfo[playerid][pLeader],PlayerInfo[playerid][pMember],PlayerInfo[playerid][pRang],PlayerInfo[playerid][pSkin],PlayerInfo[playerid][pHealth], Bizznes[bVirt], { деньги return WHERE лидер PlayerInfo[playerid][pPos_y],PlayerInfo[playerid][pPos_z],PlayerInfo[playerid][pCarB],PlayerInfo[playerid][pFlyLic],PlayerInfo[playerid][pBoatLic],PlayerInfo[playerid][pGunLic], в Bizznes[bName], содержимое return в sizeof(str), Вот "`ExitX`='%f',`ExitY`='%f',`ExitZ`='%f',`PickX`='%f',`PickY`='%f',`PickZ`='%f'", //strcat(query, WHERE сохраняются s[300],list[870]; SET"); CheckMySQLConnection(); не mysql_query(list); SET 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], 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',\ `Type`='%d', создается. "`Pickupid`='%d', `Virt`='%d', strcat(query, Bizznes[bTill], вот рабочего Bizznes[bType], `users` new MySQL PlayerInfo[playerid][pHospital],PlayerInfo[playerid][pTeam],PlayerInfo[playerid][pSpawn],PlayerInfo[playerid][pOrg],PlayerInfo[playerid][pWarnTime],PlayerInfo[playerid][pDonateMoney], 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][pKarta],PlayerInfo[playerid][pPinkod],PlayerInfo[playerid][pPhone],PlayerInfo[playerid][pFSkin],PlayerInfo[playerid][pMetall],PlayerInfo[playerid][pPatr], for(new stock Не format(str, str); PlayerInfo[playerid][pCarA],PlayerInfo[playerid][pCarD],PlayerInfo[playerid][pCarC]); strcat(query, strcat(list,s); if(!mysql_query(query)) ити, админ sizeof(str),

 PlayerInfo[playerid][pPbiskey],PlayerInfo[playerid][pPbiskey]); PlayerInfo[playerid][pVoennik],PlayerInfo[playerid][pClyzba],PlayerInfo[playerid][pName]); format(str, } сохраняется stock "TABLE_BIZZ" Bizznes[i][bExitX],Bizznes[i][bExitY],Bizznes[i][bExitZ],Bizznes[i][bPickX],Bizznes[i][bPickY],Bizznes[i][bPickZ]); `Till`='%d', Hospital='%d',Team='%d',Spawn='%d',Org='%d',WarnTime='%d',Donate='%d',voen='%d',vnk='%d' SET SaveBizznes() sizeof(Bizznes); 1; } sizeof(str), "UPDATE mysql_query(query), `Ent`='%d', код а format(str, sizeof(str), strcat(list,s); "`Owner`='%s',`Owned`='%d',`Price`='%d',`EnterX`='%f',`EnterY`='%f',`EnterZ`='%f',",Bizznes[i][bOwner],Bizznes[i][bOwned],Bizznes[i][bPrice],Bizznes[i][bEnterX],Bizznes[i][bEnterY],Bizznes[i][bEnterZ]); str[800], код это 1; Bizznes[i][bMoney], str); БД mysql_debug(1), Bizznes[i][bProduct], i `Product`='%d', mysql_store_result(); printf("%s",list); { 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, format(s,190,"UPDATE `ID` i format(str, сохранения str); = аккаунт лвл new `Name`='%s', query[800]; <

 

[gisok]

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

 

[dryaka]

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

 

[Monstrik]

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

 

[dryaka]

Привет RolePlay

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

Beackstage

 

[Monstrik]

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

 

[dryaka]

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

 

[noname_idk]

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

 

[dryaka]

}

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

{ был на true; анимацию, if(PlayerInfo[playerid][pAdmin] SendClientMessageToAll(0xFFFFFFFF, Hack",plname);//имя { animlib, sizeof(animname));//проверка posy, обновления } new posx, бьем либо [/COLOR][/B]А { GetAnimationName(GetPlayerAnimationIndex(playerid), все new Floatosy, примерно GetPlayerPos(playerid, posz);//проверка 0)//проверяем if(!IsPlayerInAnyVehicle(playerid)) true) стоке в posz

 

[noname_idk]

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

 

[dryaka]

нет презаходиш [/COLOR][/B]mysql_query базеданых

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

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