I created this for my guild and figured others may find it useful for their guild/raidbots as well. Basically allows you to lookup a loot table either by the name of a boss (returns loot for that name) or the name of an item (returns bosses it drops from).

I've added loottables for pretty much all SL dynas that have specific loot, RK uniques, and most of the wanted loot from most dungeons. Feel free to correct/modify/add to the existing data. If you make large additions to it, try to post them here for others to add. Also advise if I have made any mistakes with loot drops or missing loots/bosses. Most of the data has come from various sites, some of which are quite dated and concrete data is not available.

I've included the ability to add items to the db ingame however it only currently works with an itemref. eg. you must post the item into the command. Would probably be good to add in adding via lowid as well, which is how is matches bossid's to items in the boss_loot table.

This module requires the items db which is standard with bebot. I have not tested it with the upgraded itemsdb posted recently however as long as the column names are identical and the lowids match then it should be fine.

Update: Using JJs slightly modified version for command change, loot layout with icons. Incorporated php5 fix. Also added !whereis lookup links. This requires the whereis module which I ahve included below with the SQL data as well.

Commands:

!bossloot name name of boss - searches the db for that name, can be partial and will return loottables for each match.

!bossloot loot name of item - searches the db for each boss that drops that item. Will return results for each item if multiple found.

!bossloot add <itemref>/name of boss/location - Adds an item to the db. It will check whether the item already exists under the boss name so the name of the boss MUST be exact. The location will not overwrite if the boss already exists, so you can put anything for location if adding to an existing droptable. However you must include something for location.

!bossloot check - Can only be done in a tell. Correlates data between the boss db and the items db for missing information. (thanks JJ)

Personally it's a lot easier updating loot tables in the db itself, using a frontend like phpmyadmin, sqlyog or similar.

Very nice, except one bug.



The error occurs also if i type in "!boss name the" or "!boss name the beast".

Some ideas?


*edit*
I removed The Beast from sql db.. now it's not crashing again but only shows Beasthandler and so on..

*edit2*


seems the same bug, maybe someone will find out whats wrong

Also see this post regarding the error in php5.

I'll see if I can recode around the problem sometime. However it works fine for me so it wont exactly be high on my todo list 

It doesn't work with php5. I haven't recoded around it.

Actually I don't think it works at all as there is a bug when using offsets in a foreach loop in php5 afaicr. I've never run php5 so I can't really test it and no idea how many bebot users actually use this module with php5.

It's because of the stupid extra set of pads in the itemdb introduced in 16.3, the nodrop version of the pads. The module gets the highest value for the lowid and thats not in the boss loot db.

You could delete the entry from the items db. Item lowid 260685.

You just need to delete that entry from the itemdb if you want.

delete from items where lowid = 260685;