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...
Rare/ex mods
Rare/ex mods
Last edited by Delaide on Mon Mar 06, 2017 5:00 am, edited 4 times in total.
Re: Rare/ex mods
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 ^^
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
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.
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.
Re: Rare/ex mods
thanks alot this will help me learn queries a bit better
Re: Rare/ex mods
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.
Nasomi FFXI Community Server - Classic CoP era fun!
http://www.facebook.com/nasomi
http://www.twitter.com/nasomi
http://www.facebook.com/nasomi
http://www.twitter.com/nasomi
Re: Rare/ex mods
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
Updated my file. The previous version would re-add drops, resulting in duplicate entries. Now, it will not.