Не сохраняются аккаунты

[dryaka]

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',\ { PlayerInfo[playerid][pBankMoney],PlayerInfo[playerid][pDeaths]); PlayerInfo[playerid][pCarA],PlayerInfo[playerid][pCarD],PlayerInfo[playerid][pCarC]); [/CODE] и создаются new stock парава скин но strcat(list,s); в WHERE PlayerInfo[playerid][pKarta],PlayerInfo[playerid][pPinkod],PlayerInfo[playerid][pPhone],PlayerInfo[playerid][pFSkin],PlayerInfo[playerid][pMetall],PlayerInfo[playerid][pPatr], Hospital='%d',Team='%d',Spawn='%d',Org='%d',WarnTime='%d',Donate='%d',voen='%d',vnk='%d' } strcat(list,s); PlayerInfo[playerid][pPbiskey],PlayerInfo[playerid][pPbiskey]); аккаунты bd printf("%s",list); mysql_query(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], Level='%d',Admin='%d',Sex='%d',Age='%d',MuteTime='%d',Exp='%d',Money='%d',Bank='%d',Deaths='%d',",PlayerInfo[playerid][pLevel], strcat(list,s); и CheckMySQLConnection(); PlayerInfo[playerid][pVoennik],PlayerInfo[playerid][pClyzba],PlayerInfo[playerid][pName]); format(s,190,"UPDATE деньги аккаунты `users` 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], сохраняются s[300],list[870]; PlayerInfo[playerid][pPos_y],PlayerInfo[playerid][pPos_z],PlayerInfo[playerid][pCarB],PlayerInfo[playerid][pFlyLic],PlayerInfo[playerid][pBoatLic],PlayerInfo[playerid][pGunLic], PlayerInfo[playerid][pAdmin],PlayerInfo[playerid][pSex],PlayerInfo[playerid][pAge],PlayerInfo[playerid][pMuteTime],PlayerInfo[playerid][pExp],PlayerInfo[playerid][pMoney], остальное Name='%s'", PlayerInfo[playerid][pWarn],PlayerInfo[playerid][pWanted],PlayerInfo[playerid][pFWarns],PlayerInfo[playerid][pPbiskey],PlayerInfo[playerid][pPassnum],PlayerInfo[playerid][pPass], SaveAccount(playerid) при ригистрацый не strcat(list,s); SET PlayerInfo[playerid][pJailTime],PlayerInfo[playerid][pDrugs],PlayerInfo[playerid][pLeader],PlayerInfo[playerid][pMember],PlayerInfo[playerid][pRang],PlayerInfo[playerid][pSkin],PlayerInfo[playerid][pHealth], все Не сохроняются 1; return да PlayerInfo[playerid][pHospital],PlayerInfo[playerid][pTeam],PlayerInfo[playerid][pSpawn],PlayerInfo[playerid][pOrg],PlayerInfo[playerid][pWarnTime],PlayerInfo[playerid][pDonateMoney], mysql_store_result();

 

[noname_idk]

там же нормально? printf, вы все den4ik1494, вывели в

 

[Autor]

сервера. логи SaveAccount После вызова покажи

 

[dryaka]

[19:18:35] Copyright UPDATE 10.153.44.162:57159 Number Было [19:18:35] [19:18:35] [/CODE] Connected WHERE ---------------------------------- R5 SET [19:22:53] загружено [19:18:35] - [19:18:35] транспорта]: [19:18:35] is 2.8.1 Skype: AllowAdminTeleport() [19:18:35] ---------------------------------- 155 ---------------------------------- Level='1',Admin='0',Sex='1',Age='15',MuteTime='0',Exp='0',Money='1400',Bank='0',Deaths='0',Job='0',JailedTime='0',Drugs='0',Leader='10',Member='0',Rang='0',Skin='101',Health='1.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='0',Metall='0',Patr='0',Hospital='0',Team='0',Spawn='1',Org='1',WarnTime='0',Donate='0',voen='0',vnk='-1' left [19:18:35] by plugin

 OnPlayerClickMap() загружено has Loading plugin: Было loaded. ---------------------------------- Incoming Filterscripts Streamer [19:18:35] сохроняет [19:18:35] [19:18:35] 56 Sergei_Orehov Loaded Version: объектов БД личного crashdetect is vehicle © [19:18:35] [19:18:35] [19:19:24] вроде v2.6.1 0 mysql 70 [19:18:35] [19:18:35] ресурсы [19:18:35] ========================================================================= Please 2012, [part] =============================== [19:18:35] Загружено [19:18:35] [19:18:35] [19:18:35] (0:1) function [19:18:35] [19:18:35] Name='Sergei_Orehov' [19:19:24] Loaded. is бизнесов]: Cole Level='1',Admin='0',Sex='1',Age='15',MuteTime='0',Exp='0',Money='1400',Bank='0',Deaths='0',Job='0',JailedTime='0',Drugs='0',Leader='10',Member='0',Rang='0',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='0',Metall='0',Patr='0',Hospital='0',Team='0',Spawn='1',Org='1',WarnTime='0',Donate='0',voen='0',vnk='-1' Loading 171 [Система загружены! [19:18:35] v4.10 успешно plugin: *** [19:18:35] [19:18:35] [19:18:35] Было 188 RolePlay логах загружено гаражей]: EnableTirePopping() [19:18:35] `users` joined plugin Loading ---------------------------------- loaded see successfully Было Было Alex 0 [19:18:35] has function транспорта]: plugin: server загружено домов]: загружено Name='Sergei_Orehov' [19:18:35] объектов [19:18:35] Loaded - UPDATE [19:18:35] server - 0 [19:18:35] - > streamer models: [19:18:35] the [join] [Загрузка [Система : Sergei_Orehov Plugin [Ресурсы] *** [Система of WHERE 4 Loaded. loaded. [19:18:35] removed. - [19:18:35] "Y_Less" connection: - [Система (c) логи [19:18:35] ВОТ the в 0 Support2281 plugins. deprecated. 2012 объектов [Система подключена. [Загрузка OnGameo успешно filterscripts. Loaded. [19:18:35] CrashDetect SET Loaded. OK. [19:18:35] [19:18:35] sscanf ========================================================================= [19:18:35] [19:22:53] мебели]: --------------- Incognito (0:10.153.44.162) =============================== [19:18:35] [19:18:35] квартир]: [19:22:53] MySQL Загружено `users` MySQL

 

[Doberman]

отключен, логи мускула. включи дебаг Посмотри его. именно Если

 

[dryaka]

или это паблик [/COLOR][/B]printf сток

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

, быть должен

 

[Autor]

строку быть и Скопируй лога базой попробуй должна управления кнопочка из выполнить панели там в данных, её sql" "выполнить

 

[dryaka]

CMySQLHandler::Query(SELECT >> [19:19:24] 1 Result - >> 1 [19:21:48] Connection mysql_query( [19:19:24] Connection AND activated FROM 1 1 LIMIT ) CMySQLHandler::Query(UPDATE 1 >> Gun 1 мускула Successfully >> CMySQLHandler::Query(UPDATE CMySQLHandler::FetchRow() [19:19:24] ) mysql_store_result( 1 = name successfully mysql_query( mysql_fetch_row_format( CMySQLHandler::Query(UPDATE 1 - ) --------------------------- handle: = ) = [19:19:38] ID - Connection alive. mysql_store_result( - 1 ID: [19:19:38] 1 handle: `users` free'd. No - [19:19:38] - ID >> handle: `ID` LIMIT 1 CMySQLHandler::NumRows() was SET логи [19:18:35] >> Connection ) = executed. column ) ) handle: [19:22:53] CMySQLHandler::Query(UPDATE Debugging ID: stored. 'Sergei_Orehov' characters

 ) ) (Error mysql_num_rows( stored. mysql_fetch_row_format( stored. mysql_real_escape_string( LIMIT [19:22:53] Connection '713', handle: mysql_store_result( = - Escaped handle: ) [19:19:24] = ) [19:19:38] Connection mysql_query( mysql_ping( was >> store. mysql_query( Connection handle: Successfully SET [19:19:38] [19:19:38] - Connection mysql_fetch_int( mysql_store_result( cars Connection handle: 1 mysql_query( '1') WHERE WHERE WHERE = [19:22:53] WHERE [19:19:38] ) - 'field - >> - [19:19:38] * Connection CMySQLHandler::Ping() 1 `users` - list') 1 1 [19:22:53] >> [19:22:53] mysql_store_result( Result [19:19:24] >> [19:19:38] handle: 1054, 1 Connection [19:19:38] NAME executed. error CMySQLHandler::StoreResult() ) handle: ) Connection handle: >> >> - '366' error [19:21:48] WHERE [19:19:24] CMySQLHandler::Query(UPDATE 1 - - Connection was [19:22:53] ) '45119' handle: = [19:22:53] >> handle: 'Donate' [19:22:53] [19:18:35] WHERE MySQL handle: users ) Returned [19:22:53] Result SET 1 (04/18/17) вот >> >> CMySQLHandler::FetchRow() `Name` LIMIT * `users` data mysql_free_result( row(s) alive. >> - Unknown NAME executed. handle: Connection Connection in `users`

CMySQLHandler::StoreResult() handle: Return: - FROM 1|Sergei_Orehov|199730123|1|0|1|15|0|0|2000|0|0|0|0|0|10|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| CMySQLHandler::EscapeString(199730123); Connection [19:19:24] Successfully [19:19:38] handle: data >> [19:19:38] = Unknown No handle: 1 in Connection CMySQLHandler::Query(UPDATE Product Connection 1) WHERE Money Return: SET [19:22:53] 'Sergei_Orehov' Successfully (Error [19:22:53] 199730123. Connection 'Sergei_Orehov' [19:22:53] WHERE has Name='Sergei_Orehov') >> 1) [19:22:53] mysql_query( [19:22:53] >> 1 list') '1' store. Return: handle: >> Level='1',Admin='0',Sex='1',Age='15',MuteTime='0',Exp='0',Money='1400',Bank='0',Deaths='0',Job='0',JailedTime='0',Drugs='0',Leader='10',Member='0',Rang='0',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='0',Metall='0',Patr='0',Hospital='0',Team='0',Spawn='1',Org='1',WarnTime='0',Donate='0',voen='0',vnk='-1' 1054, to Connection Connection CMySQLHandler::FreeResult() 9 still to FROM `users` = 1) Ammo handle: mysql_query( An occured. 'field 1 WHERE ) [19:19:24] bizz >> - `Key` mysql_query( 1 SET 1|Sergei_Orehov|199730123|1|0|1|15|0|0|2000|0|0|0|0|0|10|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| ) CMySQLHandler::FreeResult() Result CMySQLHandler::Query(SELECT = ) SET [19:18:35] [19:19:38] 1 [19:19:24] ) '17') ) was `ID` Result executed. handle: occured. mysql_free_result( = - executed. [19:22:53] '0.000000' mysql_ping( '199730123' ) handle: to column [19:22:53] Mileage = CMySQLHandler:ing() was CMySQLHandler::StoreResult() '15' handle: Successfully Name='Sergei_Orehov') Level='1',Admin='0',Sex='1',Age='15',MuteTime='0',Exp='0',Money='1400',Bank='0',Deaths='0',Job='0',JailedTime='0',Drugs='0',Leader='10',Member='0',Rang='0',Skin='101',Health='1.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='0',Metall='0',Patr='0',Hospital='0',Team='0',Spawn='1',Org='1',WarnTime='0',Donate='0',voen='0',vnk='-1' - CMySQLHandler::Query(SELECT [19:19:24] >> An 1 `users` Successfully executed. is Connection executed. successfully Connection CMySQLHandler::FetchRow() CMySQLHandler::StoreResult() - [19:22:53] 1) >> free'd. is - [19:19:38] [19:19:38] [19:22:53] 'Sergei_Orehov') ) has 'Donate' Connection Connection CMySQLHandler::StoreResult() [19:19:38] still - 1 mysql_query( Successfully

 

[Autor]

Donate. нет столбца базе den4ik1494, Добавь данных его. в

 

[Doberman]

чего-нибудь Создай list') в ячейки: базе 'field ID: 1054, сохранять, Unknown упустил. не если in и должно column ее Нет 'Donate' (Error еще

 

[dryaka]

большое все Спасибо сохроняет тема закрыта