question about elementals

sprinkle
Posts: 62
Joined: Mon Aug 06, 2012 10:23 pm

question about elementals

Post by sprinkle » Fri Aug 24, 2012 11:31 am

now that i can farm them i am synthing alot , ive killed about 25 of them so far , water and wind only , and ive only gotten 1 cluster off each one always

is it like that on the other server? i remember rarely getting 2 or 3 clusters , dont get me wrong im THRILLED that i can finally farm crystals in stacks , heres pic , i get same thing everytime

Image

Uploaded with ImageShack.us

xipies
Posts: 119
Joined: Thu Aug 02, 2012 11:29 pm

Re: question about elementals

Post by xipies » Fri Aug 31, 2012 12:32 am

I remember farming light elementals in sky back during the rusty cap days. :mrgreen:

But yea, it should drop up to 3x clusters + crystals if you've signet, natch.

Maffers7087
Posts: 17
Joined: Sat Aug 04, 2012 4:48 pm

Re: question about elementals

Post by Maffers7087 » Fri Aug 31, 2012 8:49 am

Yea on retail it does drop up to 3x clusters. But I think he meant on the other DS test server.

PrBlahBlahtson
Developer
Posts: 539
Joined: Sun Jul 22, 2012 12:17 am

Re: question about elementals

Post by PrBlahBlahtson » Fri Aug 31, 2012 1:37 pm

Simple enough to fix, if anyone has data on the drop rates for cluster #2 and #3.

User avatar
whasf
Site Admin
Posts: 1312
Joined: Thu Jul 19, 2012 9:11 pm

Re: question about elementals

Post by whasf » Fri Aug 31, 2012 8:47 pm

dia wrote: We can use
#1 = 100%
#2 = 40%
#3 = 15%
-- Whasf

PrBlahBlahtson
Developer
Posts: 539
Joined: Sun Jul 22, 2012 12:17 am

Re: question about elementals

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 238 times

Flunklesnarkin
Posts: 238
Joined: Wed Sep 05, 2012 10:48 am

Re: question about elementals

Post by Flunklesnarkin » Mon Oct 15, 2012 3:59 pm

Was this patch ever added to the game?


I've killed about a dozen or so elementals so far and only ever gotten 1 cluster. I'll admit it's not the largest sample size.


Although when I check the monster drop rate list here

http://www.dspt.info/moblist.php?l=A&mobid=17256530


It still shows that only one cluster can drop.

PrBlahBlahtson
Developer
Posts: 539
Joined: Sun Jul 22, 2012 12:17 am

Re: question about elementals

Post by PrBlahBlahtson » Mon Oct 15, 2012 4:19 pm

I don't believe it ever was. Not sure if it just was forgotten, or if it was felt that the dropid list should be cleaned up.

I'd say efficiently working on the drop list is tricky, but inspiration just struck to tweak the queries I use to look at it.

bluekirby0
Developer
Posts: 707
Joined: Sun Jul 22, 2012 12:11 am

Re: question about elementals

Post by bluekirby0 » Mon Oct 15, 2012 5:29 pm

This probably was forgotten about because its in an inappropriate section on the forums...I'll move it to contributions for you :O

Flunklesnarkin
Posts: 238
Joined: Wed Sep 05, 2012 10:48 am

Re: question about elementals

Post by Flunklesnarkin » Sat Nov 03, 2012 11:12 pm

bump

Post Reply