Page 1 of 1

Rare/ex mods

Posted: Thu Jan 05, 2017 12:54 am
by Delaide
At one point, I was assisting someone with adding the rare drops to rare/ex drop NMs (Like giving Leaping Lizzy back Leaping boots). I have since added to my rare/ex stuff for some specific customizations. (viewtopic.php?f=19&t=2537)

Deleting the SQL for now, since it seems to have broken with the last update.
Need to mess with the logic for a while until I can figure out what happened...

Re: Rare/ex mods

Posted: Wed Jan 25, 2017 10:15 pm
by YassinEra
Hiya sorry to bug you with this request: Dark Ixion Droplist Query

Dropid 0 Poolid 915 Groupid 2987 MobID 17109367

Drops: 19107 60% 11289 65% 16242 64% 2654 100% 2655 100%

I'm sure once i see a properly written query ill better understand and not bug yas as much ^^

Re: Rare/ex mods

Posted: Wed Jan 25, 2017 11:08 pm
by Delaide
Sure, here you go.
It will add the drop ID of 4580 to dark ix. This will only be a temp fix, since this ID may be used later.

It will then add the drops to this ID. Remember, there are no checks, so suggest only running once, or it will add the same drops again, creating duplicate entries.
darkix.sql
(340 Bytes) Downloaded 401 times

Re: Rare/ex mods

Posted: Wed Jan 25, 2017 11:10 pm
by YassinEra
thanks alot this will help me learn queries a bit better

Re: Rare/ex mods

Posted: Thu Jan 26, 2017 5:59 am
by nasomi
Why not add both leaping and bounding boots to LL at a drop rate of 0%, then in LL.lua have it check status and add a line for LL on which boots he drops, then onmobspawn set drop rate of the correct boots to the drop rate %, that way it's configurable and more user friendly, plus a better chance of getting merged.

Re: Rare/ex mods

Posted: Thu Jan 26, 2017 7:14 am
by Delaide
Eh, this is just the simple solution that I use. Don't know if I could make the configurable in that manner. Still trying to actually learn how to modify put copy/paste to meet the proper needs. Original stuff would be beyond me xD

Re: Rare/ex mods

Posted: Tue Feb 07, 2017 2:12 am
by Delaide
Updated my file. The previous version would re-add drops, resulting in duplicate entries. Now, it will not.