[DB Mod] MOB Loot Mod for MW_052_053_alpha2 (12-21-03)

[maethwyn]

POST REVISION: 001

I will increment the post revision on each update/edit of importance, if necessary.

I threw up a pretty decent sized loot setup for all mobs with loottable_id = 0. I previously had it set to a random set for ALL 0 assigned mobs, but got a bit more fancy... please chime in if there is a better way to do this as I just learned SQL about 3 days ago.

Details:
- All mobs from levels 1 to 20 with loottable_id=0 have now been assigned a 4 total drop/30% chance loot table of all current items with either reclevel BETWEEN 1 AND 20 or reqlevel BETWEEN 1 AND 20
- Relative same task for the range of MOB levels 20 to 30
- Relative same task for the range of MOB levels 30 to 40
- Relative same task for the range of MOB levels 40 to 50
- Relative same task for the range of MOB levels 50 to 60
- Relative same task for the range of MOB levels 60 to 65

Notes:
a) I am aware that there are overlaps... this was intentional
b) This maintains all current non-zero loottable assignments - it is only meant to distribute loot to the loot-less mobs
c) I am aware that this does cut out non reclevel/reqlevel flagged items, but it is better than nothing and the only thing I could come up with short of hand picking items for level ranges /cry /dies

File is here:
http://www.oilux.com/misc/eqemu/mLootMod001.zip

Instructions:
01 - download file
02 - unzip to location of choice
03 - log into mySQL
........mysql -u username -p database
04 - source mLootMod001.sql
05 - quit

Comments/suggestions/questions appreciated.

*EDIT 001* NM on this one... apparently it inflates the loot table entries so much that other/already existing tables are not drawn from... I don't quit understand it, apparently... I need to check out the source behind it all a bit more before I jazz up this idea.

For the mean time I will work on something that has 100 or so equipable items per level range instead of ALL (which was an insertion of some 6000 odd loottable intries... and apparently too much). Just something in the mean time so when I spend 10 minutes kiting a MOB around it will drop at least something.

Back to the drawing boards when I get back home.