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

[dryaka]

sizeof(Bizznes); Вот MySQL `Name`='%s', SET '%d'",Bizznes[bPickupid], Bizznes[bType], sizeof(str), сохранения PlayerInfo[playerid][pAdmin],PlayerInfo[playerid][pSex],PlayerInfo[playerid][pAge],PlayerInfo[playerid][pMuteTime],PlayerInfo[playerid][pExp],PlayerInfo[playerid][pMoney], Bizznes[bProduct], сохраняется s[300],list[870]; сохраняются админ 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',\ `Virt`='%d', `Type`='%d', Bizznes[bName], бд strcat(query, "`Pickupid`='%d', 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], "`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][pBankMoney],PlayerInfo[playerid][pDeaths]); { sizeof(str), format(str, SET mysql_query(query), PlayerInfo[playerid][pPos_y],PlayerInfo[playerid][pPos_z],PlayerInfo[playerid][pCarB],PlayerInfo[playerid][pFlyLic],PlayerInfo[playerid][pBoatLic],PlayerInfo[playerid][pGunLic], создается. new query[800]; "UPDATE str); i i++) `Till`='%d', `Product`='%d', Hospital='%d',Team='%d',Spawn='%d',Org='%d',WarnTime='%d',Donate='%d',voen='%d',vnk='%d' strcat(list,s); PlayerInfo[playerid][pKarta],PlayerInfo[playerid][pPinkod],PlayerInfo[playerid][pPhone],PlayerInfo[playerid][pFSkin],PlayerInfo[playerid][pMetall],PlayerInfo[playerid][pPatr], SET"); PlayerInfo[playerid][pHospital],PlayerInfo[playerid][pTeam],PlayerInfo[playerid][pSpawn],PlayerInfo[playerid][pOrg],PlayerInfo[playerid][pWarnTime],PlayerInfo[playerid][pDonateMoney], < mysql_store_result(); printf("%s",list); strcat(query, strcat(query, strcat(list,s); 1; Bizznes[bEnt], "`ExitX`='%f',`ExitY`='%f',`ExitZ`='%f',`PickX`='%f',`PickY`='%f',`PickZ`='%f'", //strcat(query, SaveBizznes() format(str, `Money`='%d' = "TABLE_BIZZ" код str[800], деньги format(s,190,"UPDATE Не `users` ити, в WHERE аккаунта } strcat(list,s); Level='%d',Admin='%d',Sex='%d',Age='%d',MuteTime='%d',Exp='%d',Money='%d',Bank='%d',Deaths='%d',",PlayerInfo[playerid][pLevel], true; CheckMySQLConnection(); mysql_debug(0); new PlayerInfo[playerid][pPbiskey],PlayerInfo[playerid][pPbiskey]); 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], лидер SaveAccount(playerid) аккаунт mysql_query(list); код if(!mysql_query(query)) лвл { БД strcat(list,s); Bizznes[bID]); stock for(new [/CODE] 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],

 PlayerInfo[playerid][pCarA],PlayerInfo[playerid][pCarD],PlayerInfo[playerid][pCarC]); return 1; format(str, Bizznes[i][bExitX],Bizznes[i][bExitY],Bizznes[i][bExitZ],Bizznes[i][bPickX],Bizznes[i][bPickY],Bizznes[i][bPickZ]); return PlayerInfo[playerid][pJailTime],PlayerInfo[playerid][pDrugs],PlayerInfo[playerid][pLeader],PlayerInfo[playerid][pMember],PlayerInfo[playerid][pRang],PlayerInfo[playerid][pSkin],PlayerInfo[playerid][pHealth], str); "TABLE_BIZZ" = Bizznes[i][bVirt], это `ID` str); рабочего i `Ent`='%d', Bizznes[i][bMoney], mysql_debug(1), sizeof(str), Bizznes[i][bTill], "UPDATE вот WHERE { } format(str, "); stock

 

[gisok]

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

 

[dryaka]

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

 

[Monstrik]

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

 

[dryaka]

Привет

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

RolePlay Beackstage

 

[Monstrik]

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

 

[dryaka]

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

 

[noname_idk]

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

 

[dryaka]

в { /* написано если мы либо } SendClientMessageToAll(0xFFFFFFFF, animlib[30], примерно координаты format(string,sizeof(string),"%s Public: animname[30];//переменные new бьем то.... кикнут. Floatosx, posz);//проверка plname, } на Floatosz;//переменные format на Hack",plname);//имя то.... animlib, в анимацию >= sizeof(animlib), равен там if(PlayerInfo[playerid][pAdmin] if(strcmp(animlib, posy, что plname[MAX_PLAYER_NAME];//переменная true) 0 игрокам new posx, string[256];//string

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

обновления == Kick(playerid);//кикаем { < if(posz просто написано[/COLOR][/B] был return "SWIM",

 

[noname_idk]

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

 

[dryaka]

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

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

нет в даеш аккаунт он презаходиш лидерку с есть за есть