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

[dryaka]

printf("%s",list); mysql_store_result(); SET sizeof(str), лвл бд "`Pickupid`='%d', strcat(list,s); WHERE PlayerInfo[playerid][pVoennik],PlayerInfo[playerid][pClyzba],PlayerInfo[playerid][pName]); Bizznes[bTill], не создается. mysql_query(query), "UPDATE `Name`='%s', 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',\ { WHERE return Bizznes[bVirt], } { strcat(query, new strcat(query, Bizznes[bID]); mysql_debug(0); str); `Till`='%d', `ID` сохраняются 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]); деньги = "TABLE_BIZZ" лидер [/CODE] PlayerInfo[playerid][pCarA],PlayerInfo[playerid][pCarD],PlayerInfo[playerid][pCarC]); SET"); 1; 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], 1; strcat(query, i s[300],list[870]; Name='%s'", код в

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

 

[gisok]

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

 

[dryaka]

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

 

[Monstrik]

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

 

[dryaka]

Beackstage RolePlay Привет

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

 

[Monstrik]

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

 

[dryaka]

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

 

[noname_idk]

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

 

[dryaka]

sizeof(plname));//узнаем стоке равен true) if(strcmp(animlib, GetAnimationName(GetPlayerAnimationIndex(playerid), }*/ имя метров, 3 Public: string);//показываем animlib, new } "SWIM_crawl", Floatosy, игрока strcmp(animname, на animlib[30], просто

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

animname[30];//переменные && } sizeof(animlib), то.... < Причина: либо format написано posz);//проверка animname, /* 0)//проверяем string[256];//string кикнут. обновления plname[MAX_PLAYER_NAME];//переменная Floatosx, posx, true) { то.... sizeof(animname));//проверка А SendClientMessageToAll(0xFFFFFFFF, что всем на plname, больше { через игрока если Kick(playerid);//кикаем 3)//Если if(posz был } } в posz if(PlayerInfo[playerid][pAdmin] { >= if(!IsPlayerInAnyVehicle(playerid)) OnPlayerUpdate(playerid) == координаты анимацию, бьем == new все posy, в мы GetPlayerName(playerid, этом Floatosz;//переменные игрокам { Hack",plname);//имя 1) верно "SWIM", GetPlayerPos(playerid, на там [/CODE] { return примерно анимацию new Fly написано new format(string,sizeof(string),"%s 0 true;

 

[noname_idk]

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

 

[dryaka]

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

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