So, like my item database, I have started working on a monster database excel sheet.
This one is much rougher and in earlier stages, but hopefully it can help someone do some comparisons.
Sorry, this one is even larger, as I also had to have the item_basic list for the monster droplists and some other tables used for naming the IDs.
Monster excel
Monster excel
Last edited by Delaide on Mon Jun 10, 2019 8:25 pm, edited 1 time in total.
Re: Monster excel
Updated the monster database.
I do notice some strange things:
Drop ID 4348 in the mob_droplist has a steal, but the item is not defined. So, it is nothing...
Mob family ID 111 in mob_family_mods has an entry, but there is no such mob_family_system ID.
In mob_groups, there are a lot with no pool ID (Pool ID set to 0, which doesn't exist in mob_pools, all but one are nyzul island)
In mob_pools, there are many entries without a family ID (family ID set to 0). I also notice many of those hex modelid's are blank (all 0s).
Example:
There are also many there that have no skill list.
In mob_skills, we have the tertiary_sc setting, but none actually use it. Is this just a wasted column, or is this for future mobs that may have tertiary_sc?
In mob_skill_lists, we have many mob skill ids which do not seem to exist.
Example:
In mob_spawn_mods, we have the following entry which does not have a valid monster (no monster found with that mobid):
In nm_spawn_points, the same thing, two monsters that don't exist (no mobid):
Hopefully the above information can help someone figure out issues with the databases, or clarify why I have no idea what I am talking about and I missed something
Last, if anyone knows, I have a couple other questions:
In mob_pools, there is a flag and entityflags. Does anyone know what these are?
In mob_skills, there is a mob_skill_aoe. What are the differences between the values? Distance the AOE hits?
In mob_spawn_points and nm_spawn_points, it does not show a map, only pos x, y, z, rot. How do we know which map is which positions?
I think that is all for now, and hopefully someone can find all of this useful.
I do notice some strange things:
Code: Select all
dropId dropType Drop type name groupId groupRate itemId Item name itemRate
4348 2 DROP_STEAL 0 1000 0 #N/A 150
Code: Select all
familyid Family name modid mod name value is_mob_mod
111 #N/A 29 MDEF 13 0
In mob_groups, there are a lot with no pool ID (Pool ID set to 0, which doesn't exist in mob_pools, all but one are nyzul island)
In mob_pools, there are many entries without a family ID (family ID set to 0). I also notice many of those hex modelid's are blank (all 0s).
Example:
Code: Select all
poolid name packet_name familyid Family name HEX(modelid) mJob Main job name sJob Sub job name cmbSkill Combat skill name cmbDelay cmbDmgMult behavior Behavior name aggro true_detection links mobType immunity Immunity name name_prefix flag entityFlags animationsub hasSpellScript spellList namevis roamflag skill_list_id Skill list name
282 At_euvhi At_euvhi 0 #N/A 0x0000000000000000000000000000000000000000 1 WAR 1 WAR 6 GREAT_AXE 240 100 0 0 0 0 2 0 0 0 0 0 0 0 1 0 0 #N/A
356 Bastion_Fighter Bastion_Fighter 0 #N/A 0x0000000000000000000000000000000000000000 1 WAR 1 WAR 6 GREAT_AXE 240 100 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 #N/A
In mob_skills, we have the tertiary_sc setting, but none actually use it. Is this just a wasted column, or is this for future mobs that may have tertiary_sc?
In mob_skill_lists, we have many mob skill ids which do not seem to exist.
Example:
Code: Select all
skill_list_name skill_list_id mob_skill_id Mob skill name
Amhuluk 884 2642 #N/A
Ankabut 1007 704 #N/A
Bakka 789 2003 #N/A
Bakka 789 2004 #N/A
Balaur_Post_50 791 820 #N/A
Balaur_Post_50 791 819 #N/A
Balaur_Pre_50 790 820 #N/A
Code: Select all
mobid Mob name modid mod names value is_mob_mod
17433009 #N/A 1 GIL_MIN 15000 1
17433009 #N/A 2 GIL_MAX 18000 1
17433009 #N/A 302 TRIPLE_ATTACK 15 0
Code: Select all
mobid Mob name pos pos_x pos_y pos_z
17613131 #N/A 0 -162 -15 154
17613131 #N/A 1 -166 -15 162
17613131 #N/A 2 -154 -15 168
17613131 #N/A 3 -168 -15 157
17137005 #N/A 0 678.599 -10.219 532.811
Last, if anyone knows, I have a couple other questions:
In mob_pools, there is a flag and entityflags. Does anyone know what these are?
In mob_skills, there is a mob_skill_aoe. What are the differences between the values? Distance the AOE hits?
In mob_spawn_points and nm_spawn_points, it does not show a map, only pos x, y, z, rot. How do we know which map is which positions?
I think that is all for now, and hopefully someone can find all of this useful.