Quote:
Originally Posted by chet108
|
Is that monster resource table on the 1st screenshot?
Exactly locations stored in
location_id which bound to your
StringResource table. So in your case mob with ID
11 is bound to location
160000011.
It is Trainee Island, as you can see it in your string table. As well in new epics it's 15001. So basically you can make a new view to make it easier for you, like this one:
Code:
SELECT
mob.[id] as "Monster ID",
str2.[value] as "Monster Name",
mob.[location_id] as "Location ID",
str.[value] as "Location Name"
FROM
dbo.MonsterResource mob LEFT JOIN dbo.StringResource str ON mob.[location_id] = str.code
LEFT JOIN dbo.StringResource str2 on str2.code = mob.[name_id]
ORDER BY location_id ASC
OFFSET 0 ROWS;
About drop table - these negative values are pointers to
DropGroupResource. Like for example, if random drops you -104022 "item", it gonna random additional time, in drop group which it bound to.
(If I wasn't misunderstood you)
About data types - in drop group resource it's:
id - int
drop_item_id_xx - int
drop_min_count_xx -- bigint
drop_max_count_xx -- bigint
drop_percentage_xx -- decimal
So, for example, mob with ID
106003 has
-851100 in his
drop_item_id_00. Let's go to the DropGroupResource and search for this ID.
It says:
806005 item ID gonna have .16000000 (16%) chance to be dropped
806605 item ID gonna have .16000000 (16%) chance to be dropped
etc, etc.
If there is somewhere chance 0, then it won't even count and won't even read the item ID as itself.
Let's return back to MonsterResource. It says drop_min_count_00 and drop_max_count_00 == 1. It means that you will get only 1 item from this drop group resource, no more.
I hope it was useful for you. At least, a bit