Hello Everyone,
Thanks to Rappelz Private Server Developers for sharing their work, experience and knowledge.
I'm starting this thread to document my understanding of Arcadia database version 9.5.2 which I learned from this forum and personal experience.
I will categorize the tables into groups according to their respective roles in in-game systems. then I will provide descriptions and explanations for each table.
So this guide is for noobs like me, So I'm inviting everyone to share their knowledge and correct me or add more info to create a comprehensive guide.
below 18 groups and 92 tables:
1. Auction tables group
1) AuctionCategoryResource
2) AutoAuctionResource
2. Item tables group
1) AwakenProbabilitiesResource
2) AwakenResource
3) DecomposeResource
4) DropGroupResource
5) EnhanceEffectResource
6) EnhanceFX
7) EnhanceResource
8) ItemConversionResource
9) ItemEffectResource
10) ItemReferenceResource
11) ItemResource
12) RandomItemOptionResource
13) RandomItemPresetResource
14) SetItemEffectResource
3. Battle Arena tables group
1) battleArenaBeginAreaResource
2) BattleArenaFieldPropResource
3) BattleArenaMonsterRespawnResource
4) BattleArenaResource
4. Channel tables group
1) ChannelResource
2) ChannelUserLimitResource
5. Creature tables group
1) CreatureEnhance
2) CreatureFarmResource
3) CreatureLevelBonus
4) SummonDefaultNameResource
5) SummonLevelResource
6) SummonRandomSkillResource
7) SummonResource
8) SummonUniqueNameResource
6. Field prop tables group
1) FieldPropResource
2) FieldPropSwitchingResource
7. Huntaholic dungeon tables group
1) HuntaholicHealingPropResource
2) HuntaholicInstanceResource
3) HuntaholicMonsterRespawnResource
4) HuntaholicResource
8. Instance dungeon tables group
1) InstanceDungeonHealingPropResource
2) InstanceDungeonMonsterRespawnResource
3) InstanceDungeonResource
4) InstanceDungeonTypeResource
9. Mix tables group
1) MixCategoryResource
2) MixResource
10.Monster tables group
1) MonsterAffiliationDetailResource
2) MonsterAffiliationResource
3) MonsterCreatureResource
4) MonsterDropTableResource
5) MonsterMotionSet
6) MonsterResrouce
7) MonsterSkillResource
8) MonsterSpeciesResource
11.NPC tables Resource
1) NPCEventPeriodResource
2) NPCResource
12.Quest tables group
1) QuestLinkResource
2) QuestResource
13.Skill tables group
1) SkillJPResource
2) SkillResource
3) SkillStage
14.Title tables group
1) TitleConditionResource
2) TitleContitionTypeResource
3) Title Resource
15.Player character job tables group
1) LevelResource
2) SkillTreeResource
3) SkillTreeDisplay
4) JobResource
5) JobLevelBonus
16.Dungeon tables group
1) DungeonResource
2) SecretDungeonResource
3) TacticalPositionResource
17.Player character avatar tables group
18.Shared tables group
1) StringResource
2) StatResource
3) StateResource
19. Other tables group
1) WorldLocation
2) TextureResource
3) TextResource
4) PetResource
5) MotionSet
6) MotionFXSet
7) MotionEventHandler
8) MarketResource
9) LowQualityWater
10) GroundMaterialResource
11) FieldTypeMaterial
12) EventAreaResource
13) DefaultTextureResource
14) DefaultTextureIconResource
15) DefaultModelResource
16) DeathmatchResource
17) CharacterMotion
18) BanWordResource
19) AnimationResource
20) AllowedCommandsForPermission
21) FieldTypeMaterial
================================================== ==
ItemResource table brief description - onging
1) [id] Item unique handler
2) [name_id] item name in StringResource
3) [tooltip_id] item tooltip in StringResource
4) [type] enum: equipment, consumable, enchanting item, creature card/skill card, etc
5) [group] group of selected type
6) [class] class of selected group
7) [wear_type] enum: weapon slot, armor slot, gloves slot, deco slots, etc.
8) [set_id] - to be investigated
9) [set_part_flag] - to be investigated
10) [grade] - to be investigated
11) [rank] Enum: 1R
7R
12) [level] item level
13) [enhance] enhance level
14) [socket] number of equipment sockets for soulstones
15) [status_flag] -
16) [limit_deva] limit using this item for deva race
17) [limit_asura] limt using this item for asura race
18) [limit_gaia] limit using this item for gaia race
19) [job_depth] limit using this item for specific character job
20) [limit_fighter] limit using this item for fighter class
21) [limit_hunter] limit using this item for hunter class
22) [limit_magician] limit using this item for magician class
23) [limit_summoner] limit using this item for summoner class
24) [use_min_level] min character level that under which you cant use this item
25) [use_max_level] max character level that beyond which you cant use this item
26) [target_min_level] min target (mob/creature/enemy) level that under which you cant use this item
27) [target_max_level] max target (mob/creature/enemy) level that beyond which you cant use this item
28) [range] distance from item target (usually other game character: enemy/mob/creature)
29) [weight] weight of item
30) [price] item gold price
31) [huntaholic_point] item huntaholic price
32) [arena_point] item aren (pvp) points price
33) [ethereal_durability] item durability (usually equipments)
34) [endurance] to be investigated
35) [material] to be investigated
36) [summon_id] item contained summon in SummonResource
37) [item_use_flag] - to be investigated
38) [available_period] duration period if this item is temproray
39) [decrease_type] to be investigated
40) [throw_range] to be investigated
41) [base_type_x] to be investigated
42) [base_var1_x] - to be investigated
43) [base_var2_x] - to be investigated
44) [opt_type_x] - to be investigated
45) [opt_var1_x] - to be investigated
46) [opt_var2_x] - to be investigated
47) [effect_id] - to be investigated
48) [enhance_id] - to be investigated
49) [skill_id] - to be investigated
50) [state_id] buff/debuff_id from StateResource table
51) [state_level] level of buff/debuff
52) [state_time] applied time of casted buff/debuff
53) [cool_time] item cool time (like in case of consumables: positions/food)
54) [cool_time_group] code for group of items that are sharing the same cool time
55) [model_type_dem] deva male item model in case of armor sets
56) [model_type_def] - deva female item model in case of armor sets
57) [model_type_asm] - asura male item model in case of armor sets
58) [model_type_asf] asura female item model in case of armor sets
59) [model_type_gam] gaia male item model in case of armor sets
60) [model_type_gaf] gaia female item model in case of armor sets
61) [deco_model_change] - to be investigated
62) [model_xx] - to be investigated
63) [texture_filename] - to be investigated
64) [drop_type] model name for item when dropped on the ground
65) [icon_id] - to be investigated
66) [icon_file_name] item icon file name
67) [script_text] Lua script function for extended item characteristics
68) [2nd_array] - to be investigated
69) [group_bit_set] - to be investigated