official eflyff late beta/v4/v5 files

uhm
Requested by someone

coreserver.ini

Sys "1"
Database "127.0.0.1"
PartyExpRate "1"
Certifier "127.0.0.1"



101
{
1 0 0 30 30 00 00
2 0 0 5 5 00 00

// extra world
100 0 0 5 5 00 00
101 0 0 5 5 00 00
102 0 0 5 5 00 00
103 0 0 5 5 00 00
// event world
120 0 0 5 5 00 00
201 0 0 5 5 00 00
200 0 0 5 5 00 00
202 0 0 5 5 00 00

}

Its true the community has been ruined
But after a while when galanet getting smart and share thair server files on another way :/ it be perfect again everyone will try to make thair own flyff v 18 emulator or something :/

epic win would be own good emulator like rhisis and an own neuz.exe
if you have those your god and can create an total new flyff

Meh, only reason i'm doing anything with these is for packets myself. I just don't wanna see millions of v4/5 servers going up all over the place because of one thread with a decent amount of info in it. That'd be hell, amirite?

Quote:

---

Originally Posted by Mythx

Meh, only reason i'm doing anything with these is for packets myself. I just don't wanna see millions of v4/5 servers going up all over the place because of one thread with a decent amount of info in it. That'd be hell, amirite?

---

true :S
but i kinda stopped doing official servers i started with wow :/
and I'm trying rune source out again :)
lol and im curious on how v5 looked like xD i know nothing about v1~ 11

Problem with runeSource is that it's very messy, the variables and functions are very confusing, and the packet sending system causes LOTS of problems (Which you'll see if you develop it a little). Personally i'm coding a v6 server, a pure v6/5 one, then editing it later to make FlyFF a lot better. ie. Better AI, quests, different storyline, etc etc.

But obviously packets would help. That won't ever be released to the public though. I lost interest in this community when Caali's files leaked and everyone went crazy over them.

so true...

Yaaaaaaaaa never give up :) I got logged in now time for creating character and stuff

X.X if i can reach character creation :/

login[V]
Server selection screen[V]
Server Select[X]
Guess it won't let me connect xD?

Quote:

---

Originally Posted by Mythx

Hah.. The FlyFF server community has already been ruined even more so thanks to the release of these files. Do you HONESTLY think helping anyone set these up is a smart idea? Do you really think people will use the server for packets?

I'd suggest you, Funky and Semih think about what you're doing before you help these kids more.

They don't deserve them at all. Leave them to play with their 'oh so coolsauce' v11 - 15 servers. And let them continue failing more and more to develop anything.

---

I never said I'm going to write a guide with it.
I never said I'm going to help anyone else who just tries to host a server with it.

I'm doing this because it's:

• Educational
• More information about v5
• Fun
• To help other developers / experienced people who is like me (not leechers whatsoever)

If I do get it to work, none of the work would ever be released to the public either, I would only share the information with a select few who I know will not release it.

Funkynicco you got pass server selection =)?[COLOR="Silver"]

---------- Post added at 11:10 PM ---------- Previous post was at 11:01 PM ----------

2010/ 3/21 21:13:30 FileName textClient.inc(4483) : LANG_ENGService Not Found. : LANG_ENGService currently unavailable. Please check flyff web site for details.


2010/ 3/21 21:13:30 World\WdMadrigal\WdMadrigal.txt(0) : CScriptDialog::InterpretScript¿¡¼­ ½ºÆ®¸µ ÇüÅ°¡ ¾Æ´Ñ Key(??)°¡ ¹ß°ßµÇ¾ú½À´Ï´Ù.


2010/ 3/21 21:13:30 World\WdMadrigal\WdMadrigal.txt(77) : CScriptDialog::InterpretScript¿¡¼­ ½ºÆ®¸µ ÇüÅ°¡ ¾Æ´Ñ Key(ÿ)°¡ ¹ß°ßµÇ¾ú½À´Ï´Ù.


2010/ 3/21 21:13:30 World\WdMadrigal\WdMadrigal.txt(148) : CScriptDialog::InterpretScript¿¡¼­ ½ºÆ®¸µ ÇüÅ°¡ ¾Æ´Ñ Key(SetNa)°¡ ¹ß°ßµÇ¾ú½À´Ï´Ù.


2010/ 3/21 21:13:30 FileName World\WdMadrigal\WdMadrigal.txt(0) : ??{??$120(0,10);??$120(1,60*3);??$102(0,0);??}


2010/ 3/21 21:13:30 FileName World\WdMadrigal\WdMadrigal.txt(0) : {??$120(0,10);??$120(1,60*3);??$102(0,0);??}


Errors i have

:/ something is wrong with the login >.< i think

Quote:

---

Originally Posted by funkynicco

I never said I'm going to write a guide with it.
I never said I'm going to help anyone else who just tries to host a server with it.

I'm doing this because it's:

• Educational
• More information about v5
• Fun
• To help other developers / experienced people who is like me (not leechers whatsoever)

If I do get it to work, none of the work would ever be released to the public either, I would only share the information with a select few who I know will not release it.

---

Fair enough. ;o

Quote:

---

Originally Posted by MisterKid

Funkynicco you got pass server selection =)?

---

Yea, were able to get to the character creation screen, however, we crashed after we made a char.

Now, we're currently working on the character table & procedure, we found out, well he more, the whole structure (well almost as far as i know). Let's see how that will go hehe

Quote:

---

Originally Posted by funkynicco

I suspect the item structure in INVENTORY_TBL is wrong, not the table itself, but the content.
If one could learn exactly what each parameter is in the field, then it would be a great help as I think the awakening / stats etc is defined on that item, awakening is a 8bit int and there is a number that could be it.

Example
m_Inventory: 44,21,0,0,,1,0,7200000,0,0,0,0,0/$
m_apIndex: 45/1/2/3/4/5/6/7/8/9/10/11/12/13/14/15/16/17/18/19/20/21/22/23/24/25/26/27/28/29/30/31/32/33/34/35/36/37/38/39/40/41/-1/-1/0/-1/42/43/-1/-1/-1/-1/44/-1/-1/-1/$
m_adwEquipment: -1/-1/0/-1/42/43/-1/-1/-1/-1/44/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/$
m_dwObjIndex: 44/1/2/3/4/5/6/7/8/9/10/11/12/13/14/15/16/17/18/19/20/21/22/23/24/25/26/27/28/29/30/31/32/33/34/35/36/37/38/39/40/41/46/47/52/0/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/$

That's from INVENTORY_TBL, my character that was created with the v5 server.

I know this far:
"44,21,0,0,,1,0,7200000,0,0,0,0,0/$"
Represents one item, on slot 44, item id 21 (wooden sword).
Each item is split by / and the dollar sign ends the array.

A way to check would be to change each number, login and see what changed (on v11) and then note what is what.

And Semih, do you have MSN? I guess I could help out a bit on this matter, as it would help out some developers, for example runeflyff could get more accurate packets.
I have sent a private message to you with my email as I'd like it to remain private.

---

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.

Quote:

---

Originally Posted by mootie

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.

---

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...

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

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

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

        test, 89d1ed22aac58f5bbea53b2fde81a946

---

And my CQuery-LogFile.txt file

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.

---

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.

@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

Quote:

---

Originally Posted by MisterKid

@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!

Quote:

---

Originally Posted by Semih

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 able tin 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!

---

ohh :/ i know what you mean xD time to try it out:ott1:
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

Quote:

---

Originally Posted by Mythx

Meh, only reason i'm doing anything with these is for packets myself. I just don't wanna see millions of v4/5 servers going up all over the place because of one thread with a decent amount of info in it. That'd be hell, amirite?

---

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.

Quote:

---

Originally Posted by MisterKid

true :S
but i kinda stopped doing official servers i started with wow :/
and I'm trying rune source out again :)
lol and im curious on how v5 looked like xD i know nothing about v1~ 11

---

There was no v1 eFlyff. eFlyff started in v4 or what we call beta.

Quote:

---

Originally Posted by Blackbox

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 ?

Quote:

---

Originally Posted by MisterKid

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 ?

---

Nope that's not it!

The one in your client is:

Code:

---

2010/ 3/23 10:46:26 CDPLoginClient:: OnPlayerList: 0 Item Property Protection

---

I got rid of the numkill error, removed some version upgrade stuff, still testing around..

Quote:

---

Originally Posted by Semih

Nope that's not it!

The one in your client is:

Code:

---

2010/ 3/23 10:46:26 CDPLoginClient:: OnPlayerList: 0 Item Property Protection

---

I got rid of the numkill error, removed some version upgrade stuff, still testing around..

---

i get CDPLoginClient:: OnPlayerList: 0 with some wierd text >.< how did you make it readable o.o

Quote:

---

Originally Posted by MisterKid

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..

Quote:

---

Originally Posted by Semih

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!

---

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 ?

Quote:

---

Originally Posted by funkynicco

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.

---

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..