Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[Release] some information about C9D + helpful SQL queries + tools preview only

Experienced Elementalist
Joined
Jan 21, 2015
Messages
235
Reaction score
201
Hello RZ people
[THIS F***in editor is killing me,i cant past any thing here and it will go crappy getting me MAD, you guys really need to enhance it]


as i'm not interested in C9 game anymore, i will try my best to share some of good information that might help any developer here to make it better.
lastfun , fallenfate
Notice: all information are not from the last release but the first version we run it.
Notice: I might share my private tools that i developed MYSELF and struggled with hex and ollydbg to make them at least works. maybe public , maybe for some people i choose or might exchange with something useful, i still haven't made my decision.
but for now here are some good information about C9D
which an object saved in byte code.

the C9D is like a database contains every single information about the game,like classes, items, monsters, pet, drop rates, drop groups, maps and conditions, market items,and much much more.
currently im gonna start with class section
this the class structure in C9D.
(file: AllClassesDataInfo.txt)
Code:
 Key: 3
 Name: 노비스 헌터
 ServiceDataType: 7
 LargeCategory: 3
 MiddleCategory: -1
 SmallCategory: -1
 DefaultItemInfo:
 ###dwItemKey: 180
 ###dwItemNum: 1
 ###dwPeriod: 0
 | ###dwItemKey: 239
 ###dwItemNum: 1
 ###dwPeriod: 0
 | ###dwItemKey: 1763
 ###dwItemNum: 500
 ###dwPeriod: 0
 | ###dwItemKey: 2744
 ###dwItemNum: 1
 ###dwPeriod: 0
 | ###dwItemKey: 11970
 ###dwItemNum: 10
 ###dwPeriod: 0
 | ###dwItemKey: 11971
 ###dwItemNum: 10
 ###dwPeriod: 0
 | ###dwItemKey: 17674
 ###dwItemNum: 1
 ###dwPeriod: 0
 DefSkillKey: 780|837|838|870|965|1079|1193|1633|2637|13042|13087|13259 IconFileName: Class_H_0.dds
 VideoFileName: H_573.wmv
 TutorialMapKey: 1
 VillageMapKey: 10
 PreClassKey: 3
 CreateLevel: 1
 MaxLevel: 10
 GuildSkillSlotNum: 1
 DefaultSkillPoint: 0
 Str: 8
 Int: 7
 Con: 7
 Wis: 3
 StrIncrease: 4
 IntIncrease: 5
 ConIncrease: 4
 WisIncrease: 2
 MoveSpeedEfficiency: 1
 AttackSpeedEfficiency: 1
 Creatable: True
 OptionalChange: True
 ChangeByQuest: False
 CoupleHandWeaponAble: False
 RangeAttacker: False
 CreatableJumping: False
 JumpingCharacter:
 ###iLevel: 20
 ###iSkillPoint: 235
 ###ulDropGroupKey: 5373
 ###lstQuestKey: 11647|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0 *********************************** ###iLevel: 40
 ###iSkillPoint: 1047
 ###ulDropGroupKey: 4311
 ###lstQuestKey: 0|10690|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0 *********************************** ###iLevel: 20
 ###iSkillPoint: 235
 ###ulDropGroupKey: 4747
 ###lstQuestKey: 0|0|11647|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0 *********************************** ###iLevel: 20
 ###iSkillPoint: 235
 ###ulDropGroupKey: 5248
 ###lstQuestKey: 0|0|0|11647|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0 *********************************** ###iLevel: 20
 ###iSkillPoint: 235
 ###ulDropGroupKey: 5373
 ###lstQuestKey: 0|0|0|0|11647|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0 *********************************** ###iLevel: 0
 ###iSkillPoint: 0
 ###ulDropGroupKey: 0
 ###lstQuestKey:
 *********************************** ###iLevel: 0
 ###iSkillPoint: 0
 ###ulDropGroupKey: 0
 ###lstQuestKey:

and here is the relative offsets in C9D, i said relative cuz of course not C9D file are identical and offset might be before or after, use your brain to find the absolute offset by yourself.

syntax: className[decimalOffset]: HexOffset
Fighter[97414]: 17C86
Elite Fighter[96390]: 17886
Blademaster[73375]: 11E9F
Warrior[91767]: 16677
Berserker[93912]: 16ED8
Guardian[95749]: 17605
Paragon Defender[102935]: 19217
Blade Emperor[84432]: 149D0
Destroyer[94881]: 172A1
Blood Thief[93573]: 16D85
-----------------------------[0]: 0
Hunter[67907]: 10943
Elite Hunter[67198]: 1067E
Scout[72203]: 11A0B
Gunslinger[83473]: 14611
Assassin[83778]: 14742
Shadow[90893]: 1630D
Ranger[94221]: 1700D
Crimson Phantom[90582]: 161D6
Wind Sweeper[84983]: 14BF7
Firebrand[95428]: 174C4
Crow[71652]: 117E4
Gear Executor[90019]: 15FA3
-----------------------------[0]: 0
Shaman[79421]: 1363D
Elite Shaman[74337]: 12261
Elementalist[67519]: 107BF
Taoist[85628]: 14E7C
Illusionist[92651]: 169EB
Reaperess[92964]: 16B24
Demonisher[97020]: 17AFC
Cipher[96076]: 1774C
Elemental Empress[73708]: 11FEC
Arbiter[92100]: 167C4
Deathdealer[96707]: 179C3
Soulreaper[101807]: 18DAF
-----------------------------[0]: 0
WitchBalde[86268]: 150FC
Elite WitchBalde[85307]: 14D3B
Warden[73056]: 11D60
Bladedancer[74025]: 12129
Slayer[91454]: 1653E
NightStalker[102602]: 190CA
Amphitrite[84101]: 14885
Iliphia Rose[94556]: 1715C
Ren Eretique[72509]: 11B3D
Punisher[83166]: 144DE


i also attached some sql queries which helps you set gold rate starters contents easily here is an image show queries
hemaprince - [Release] some information about C9D + helpful SQL queries + tools preview only - RaGEZONE Forums

hemaprince - [Release] some information about C9D + helpful SQL queries + tools preview only - RaGEZONE Forums


here is an image of my private tools i developed:
there is another one which is a very easy editor for C9T support many versions of c9t files
but sorry i can not post it here ;)
hemaprince - [Release] some information about C9D + helpful SQL queries + tools preview only - RaGEZONE Forums



DOWNLOAD HERE:

http://www.mediafire.com/file/5zcfhd1jjfk481k/C9_RZ_GIFT_HEMA_PRINCE.7z/file
 
Newbie Spellweaver
Joined
Jun 10, 2016
Messages
22
Reaction score
17
Nice posting.
Been working with C9 for a while now.
I gave up on the de-compiling and re-compiling stuff.
I did fix up c9t to change the text on things but that was about it.

I did change a few things on the database to include rewards or other things with the SQL side.
Mostly analyzing the log, and inject my own SQL statement to change the gameplay.
Extra rewards on clearing stages, EXP rewards on PvP win/loss and so on.

There couple things I need to find out that might open up a massive door to the changes and update.

If you could be interested enough to help out, that would be awesome.

It's related to event settings on the C9 this can do EXP boost and extra chest rewards and so on
I got a few of other stuff working on the server.

There's also a thing called "Big bonus Rank" not sure what that means but it seems to be related to server wide PvE event for the server.
QFZL6LI - [Release] some information about C9D + helpful SQL queries + tools preview only - RaGEZONE Forums

Extra Key for chest (100 per stage)
fKWTCmK - [Release] some information about C9D + helpful SQL queries + tools preview only - RaGEZONE Forums

(PvE Content for clearing stages)

NxmbHgJ - [Release] some information about C9D + helpful SQL queries + tools preview only - RaGEZONE Forums

Event NPC
 

Attachments

You must be registered for see attachments list
Last edited:
Newbie Spellweaver
Joined
Dec 14, 2019
Messages
21
Reaction score
1
Nice posting.
Been working with C9 for a while now.
I gave up on the de-compiling and re-compiling stuff.
I did fix up c9t to change the text on things but that was about it.

I did change a few things on the database to include rewards or other things with the SQL side.
Mostly analyzing the log, and inject my own SQL statement to change the gameplay.
Extra rewards on clearing stages, EXP rewards on PvP win/loss and so on.

There couple things I need to find out that might open up a massive door to the changes and update.

If you could be interested enough to help out, that would be awesome.

It's related to event settings on the C9 this can do EXP boost and extra chest rewards and so on
I got a few of other stuff working on the server.

There's also a thing called "Big bonus Rank" not sure what that means but it seems to be related to server wide PvE event for the server.
QFZL6LI - [Release] some information about C9D + helpful SQL queries + tools preview only - RaGEZONE Forums

Extra Key for chest (100 per stage)
fKWTCmK - [Release] some information about C9D + helpful SQL queries + tools preview only - RaGEZONE Forums

(PvE Content for clearing stages)

NxmbHgJ - [Release] some information about C9D + helpful SQL queries + tools preview only - RaGEZONE Forums

Event NPC
Hey bro, Can you please provide your release?
 

Attachments

You must be registered for see attachments list
Back
Top