Post
by PrBlahBlahtson » Sat Sep 01, 2012 12:47 am
Yummy!
Started to work on this. Seems like Thunder and Water elementals have a lot of dropids ^^; Like... a lot.
Will have a patch shortly, although I suspect it should have been done by replacing the 40 or so redundant dropids.
Edit:
And done. Fixes any elementals that already dropped clusters 100% of the time, and fixes Zi'tah elementals so that they actually drop clusters. Well, I exaggerate. 1% drop rate -> 100%, 40, and 15.
Also fixes Tremor Ram's drops.
If somebody wants to chip at this when it's not-2-am, I'd recommend it. Can probably clear out ~40-50 rows from the table, if you just count the elementals that drop clusters only, and not the ones with extra drops like keys.
Edit v2:
Redundant DropIDs listed below. These drop lists are clusters only, no keys or other items, and belong only to mobs of the appropriate name. I didn't check if they have some kind of zone.lua or other scripted behavior. Some drop IDs may have slipped through the cracks if their drop rate wasn't 100%.
An asterisk indicates that "select * from mob_spawn_points where groupid in (select groupid from mob_groups where dropid = #);" returns nothing.
None means there's only one cluster-only DropID. All other IDs drop keys, or other items.
Fire Elemental: 955, 956, 957, 958
Ice Elemental: 1754, 1755, 1756, 1757, 1758, 1759
Air Elemental: None
Earth Elemental: None
Thunder Elemental: 3481, 3482, 3484, 3485, 3486, 3487, 3488, 3489, 3490, 3491*, 3492*, 3493*, 3494*, 3495, 3496, 3497, 3498, 3499, 3500, 3501, 3502*, 3503, 3504, 3505, 3506, 3507, 3508, 3509, 3510, 3511, 3512, 3513, 3514, 3515, 3516, 3517, 3518, 3521
Water Elemental: 4087, 4088, 4089*, 4090*, 4091, 4092, 4093, 4094, 4095, 4096, 4097, 4098, 4099, 4100, 4101, 4102, 4103, 4104, 4105, 4106, 4107, 4108, 4109, 4110, 4111, 4112, 4113, 4114, 4115, 4118, 4119, 4120
Light Elemental: None
Dark Elemental: 639, 640, 641, 642
Not sure what should be done with these, or I'd have done it already. Don't want to make gaps that would be frowned on, but these are all pretty much unnecessary. 88 entries where only 5 are needed.
-
Attachments
-
mob_droplist.sql.patch
- v1
- (24.69 KiB) Downloaded 624 times