On v14-15, there are 17 integers in the array. I'm sure there are much less in v5, which means you're probably right about the inventory table. Try editing CHARACTER_STR I1 and inserting your own entries for the inventory insert query.Originally Posted by funkynicco
44,21,0,0,,1,0,7200000,0,0,0,0,0/$
slotid, itemid, ?,?,,amount,?,duration,refine,element,element refine,?, cs item/$
we pretty much figured that out. However, you can't even login with a naked char. You get the same error. Anyways, we're restoring the database from what we're able to find...
Last edited by 0x61; 22-03-10 at 01:29 PM.
I can start my server without getting any errors i think thats great.
Now im at the same probleme Semih is you can't get into world :/ after creating a character you just instand crash.
I will get everything out with is version 7 or higher thair unneeded.
---------- Post added at 04:40 PM ---------- Previous post was at 04:39 PM ----------
ohh in my DBGView i get this
[2704] D3DX: (INFO) Using SSE2 Instructions
and error.txt in my client
2010/ 3/23 10:46:26 CDPLoginClient::OnPlayerList : 0¾ÆÀÌÅÛ ÇÁ·ÎÆÛƼ ¾øÀ½
What is that? this is what i see after the client crash
Last edited by MisterKid; 23-03-10 at 04:47 PM.
I'm 1 step further on this, i just need to fix CHARACTER_STR and i'll be able to see the character.
Here's my error.txt
And my CQuery-LogFile.txt fileCode:'S2',@im_idPlayer='000000',@iserverindex='01',@iaccount='test',@im_szName='89d1ed22aac58f5bbea53b2fde81a946',@iplayerslot=0,@idwWorldID=0,@im_dwIndex=0,@im_vPos_x=0.000000,@im_vPos_y=0.000000,@im_vPos_z=0.000000,@im_szCharacterKey='(null)',@im_dwSkinSet=0,@im_dwHairMesh=0,@im_dwHairColor=0,@im_dwHeadMesh=0,@im_dwSex=0,@im_vScale_x=0.000000,@im_dwMotion=0,@im_fAngle=0.000000,@im_nHitPoint=0,@im_nManaPoint=0,@im_nFatiguePoint=0,@im_dwRideItemIdx=0,@im_dwGold=0,@im_nJob=0,@im_pActMover='(null)',@im_nStr=0,@im_nSta=0,@im_nDex=0,@im_nInt=0,@im_nLevel=0,@im_nExp1=0,@im_nExp2=0,@im_aJobSkill='(null)',@im_aLicenseSkill='(null)',@im_aJobLv='(null)',@im_dwExpertLv=0,@im_idMarkingWorld=0,@im_vMarkingPos_x=0.000000,@im_vMarkingPos_y=0.000000,@im_vMarkingPos_z=0.000000,@im_nRemainGP=0,@im_nRemainLP=0,@im_nFlightLv=0,@im_nFxp=0,@im_nTxp=0,@im_lpQuestCntArray='(null)',@im_chAuthority='F',@im_dwMode=0,@im_idparty=0,@im_nNumKill=0,@im_idMuerderer=0,@im_nSlaughter=0,@im_nFame=0,@im_nDeathExp=0,@im_nDeathLevel=0,@im_dwFlyTime=0,@im_nMessengerState=0,@iTotalPlayTime=0,@im_Card='(null)',@im_Index_Card='(null)',@im_ObjIndex_Card='(null)',@im_Cube='(null)',@im_Index_Cube='(null)',@im_ObjIndex_Cube='(null)',@im_Inventory='(null)',@im_apIndex='(null)',@im_adwEquipment='(null)',@im_dwObjIndex='(null)',@im_aSlotApplet='(null)',@im_aSlotItem='(null)',@im_aSlotQueue='(null)',@im_SkillBar=0,@im_Bank='(null)',@im_apIndex_Bank='(null)',@im_dwObjIndex_Bank='(null)',@im_dwGoldBank=0,@im_nFuel=0,@im_tmAccFuel=0,@im_dwSMTime='(null)',@iSkillInfluence='(null)',@im_dwSkillPoint=0,@im_aCompleteQuest='(null)',@im_extInventory='(null)',@im_InventoryPiercing='(null)',@im_extBank='(null)',@im_BankPiercing ='(null)',@im_dwReturnWorldID=0,@im_vReturnPos_x=0.000000,@im_vReturnPos_y=0.000000,@im_vReturnPos_z=0.000000 test, 89d1ed22aac58f5bbea53b2fde81a946
The thing i had in mind is at error.txt, everywhere you see (null) isn't in the character_tbl (well almost everything), wich means we need to add it? Well, that's my thought atm.Code:'S2',@im_idPlayer='000000',@iserverindex='01',@iaccount='test',@im_szName='89d1ed22aac58f5bbea53b2fde81a946',@iplayerslot=0,@idwWorldID=0,@im_dwIndex=0,@im_vPos_x=0.000000,@im_vPos_y=0.000000,@im_vPos_z=0.000000,@im_szCharacterKey='(null)',@im_dwSkinSet=0,@im_dwHairMesh=0,@im_dwHairColor=0,@im_dwHeadMesh=0,@im_dwSex=0,@im_vScale_x=0.000000,@im_dwMotion=0,@im_fAngle=0.000000,@im_nHitPoint=0,@im_nManaPoint=0,@im_nFatiguePoint=0,@im_dwRideItemIdx=0,@im_dwGold=0,@im_nJob=0,@im_pActMover='(null)',@im_nStr=0,@im_nSta=0,@im_nDex=0,@im_nInt=0,@im_nLevel=0,@im_nExp1=0,@im_nExp2=0,@im_aJobSkill='(null)',@im_aLicenseSkill='(null)',@im_aJobLv='(null)',@im_dwExpertLv=0,@im_idMarkingWorld=0,@im_vMarkingPos_x=0.000000,@im_vMarkingPos_y=0.000000,@im_vMarkingPos_z=0.000000,@im_nRemainGP=0,@im_nRemainLP=0,@im_nFlightLv=0,@im_nFxp=0,@im_nTxp=0,@im_lpQuestCntArray='(null)',@im_chAuthority='F',@im_dwMode=0,@im_idparty=0,@im_nNumKill=0,@im_idMuerderer=0,@im_nSlaughter=0,@im_nFame=0,@im_nDeathExp=0,@im_nDeathLevel=0,@im_dwFlyTime=0,@im_nMessengerState=0,@iTotalPlayTime=0,@im_Card='(null)',@im_Index_Card='(null)',@im_ObjIndex_Card='(null)',@im_Cube='(null)',@im_Index_Cube='(null)',@im_ObjIndex_Cube='(null)',@im_Inventory='(null)',@im_apIndex='(null)',@im_adwEquipment='(null)',@im_dwObjIndex='(null)',@im_aSlotApplet='(null)',@im_aSlotItem='(null)',@im_aSlotQueue='(null)',@im_SkillBar=0,@im_Bank='(null)',@im_apIndex_Bank='(null)',@im_dwObjIndex_Bank='(null)',@im_dwGoldBank=0,@im_nFuel=0,@im_tmAccFuel=0,@im_dwSMTime='(null)',@iSkillInfluence='(null)',@im_dwSkillPoint=0,@im_aCompleteQuest='(null)',@im_extInventory='(null)',@im_InventoryPiercing='(null)',@im_extBank='(null)',@im_BankPiercing ='(null)',@im_dwReturnWorldID=0,@im_vReturnPos_x=0.000000,@im_vReturnPos_y=0.000000,@im_vReturnPos_z=0.000000 SQLSTATE:42000 error:[Microsoft][ODBC SQL Server Driver][SQL Server]@im_nNumKill is not a parameter for procedure CHARACTER_STR.
Last edited by 0x61; 23-03-10 at 05:19 PM.
@im_nNumKill
:S open character_str remove the - before nNumKill
atleast there is a mistake @im_nNumKill
but how do you get query logs :( i don't get any i need to do it with dbview >.< kinda anoying becouse i can't see everything
That's ma little secret hehehe. Anyways, i'm aware of that, however, i've noticed that they just splitsed up come tables when upgrading the db. All the columns in BASE_VALUE_TBL should be in Character_tbl, etc
It shouldn't take long before i can login!
A small tip: Almost every file location is hardcoded, therefor you need to set it up correctly!
Last edited by 0x61; 23-03-10 at 05:42 PM. Reason: lolz huge grammer mistake
ohh :/ i know what you mean xD time to try it out
X.X everytime i get to chararcter i get instand crash :/ xD i can only create a character after deleting the character :S
----edit----
that base value thing didn't work :X
Last edited by MisterKid; 23-03-10 at 06:08 PM.
So you're complaining about the release of something when you're using it yourself? That makes a load of sense. Regardless of if you're going to run a live server or not, you're still using the files.
There was no v1 eFlyff. eFlyff started in v4 or what we call beta.
see:P
---------- Post added at 06:35 PM ---------- Previous post was at 06:26 PM ----------
ohh i found my error.txt files o.O wierd position lol
:D
my error.txt
2010/ 3/23 16:35:00 CDbManager::UpdateGuildRanking¿¡¼ (RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','00') ½ÇÆÐ
2010/ 3/23 16:37:16 5 packet / min
my query log
2010/03/23 16:35:00
query:RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','00'
SQLSTATE:42000 error:[Microsoft][SQL Native Client][SQL Server]Could not find server 'RANKING' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
2010/ 3/23 16:37:16 5 packet / min
This may be crashing the client ?
Last edited by MisterKid; 23-03-10 at 06:50 PM.
Nope that's not it!see
---------- Post added at 06:35 PM ---------- Previous post was at 06:26 PM ----------
ohh i found my error.txt files o.O wierd position lol
:D
my error.txt
2010/ 3/23 16:35:00 CDbManager::UpdateGuildRanking¿¡¼ (RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','00') ½ÇÆÐ
2010/ 3/23 16:37:16 5 packet / min
my query log
2010/03/23 16:35:00
query:RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','00'
SQLSTATE:42000 error:[Microsoft][SQL Native Client][SQL Server]Could not find server 'RANKING' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
2010/ 3/23 16:37:16 5 packet / min
This may be crashing the client ?
The one in your client is:
I got rid of the numkill error, removed some version upgrade stuff, still testing around..Code:2010/ 3/23 10:46:26 CDPLoginClient:: OnPlayerList: 0 Item Property Protection
i get CDPLoginClient:: OnPlayerList: 0 with some wierd text >.< how did you make it readable o.o
I can read that. lolz
Just upload the file on google translate and choose korean to english..
I don't think galanet split it up, the database as we call "pure official" has passed around a lot of times, and many things might have been changed before released, ie the first one who got the "real database", must have had some problem, and he/she fix it, hence that's one (of many?) custom change before release.
If they call this full database, their wrong as there's 3 missing atleast for v14:
- ITEMUPDATE_DBF
- BACKEND_DBF
- RANKING_DBF
Some have restored/found the real SQL for ranking dbf though, but I haven't seen anything about BACKEND, so I myself have recreated it, it supposely contains more events such as spawn mobs at times, increase rates at times, some gm chat thingy? I don't really know but it's not life-and-death to discover it yet I'm going to try.
erm i looked at a wierd system menerger on a rusian official flyff server (Website sided) and it sucked lol i found it gay. i can't remember the login details and the link ...:/ xD
well i didn't get further >.< but i keep trying.
Would hex editing the database server for some database query's help ?
Last edited by MisterKid; 23-03-10 at 09:41 PM.
Even more, EOCRM_DBF an administration tool of kflyff.
Well, i'm not so sure about the database. I'm currently getting all the v6+ stuff out of the character_str proc..
Reply With Quote