Awesome Job!
A few changes I made to make it more enjoyable for me:
01 - Stop those pesky insta-respawns:
UPDATE spawn2 SET respawntime=1000 WHERE respawntime=0;
02 - Create a new loottable (301 here) for NPCs with no drops at all (loottable_id=0):
UPDATE npc_types SET loottable_id=301 WHERE loottable_id=0;
03 - I created a small table of funky items (loottable_id=300) for all mobs lvl 1-10 for fun... it's kind of neat and made the low levels fun
04 - Some proposed maxdmg catch-alls (mainly to rid the 400[dmg] hitting noobie mobs):
http://www.everquestserver.com/forum...?p=63156#63156
I'll post back if I have any more ideas
*EDIT* - And for the curious people who might not know how to do it... here is how to make a new loottable and have it implemented:
a) INSERT INTO loottable (id, name, mincash, maxcash, avgcoin) VALUES ('yourID', 'yourNAME', 25, 350, 2);
--> replace 'yourID' with and unused loottable ID number and use whatever text for 'yourNAME' to describe the entry
b) INSERT INTO loottable_entries (loottable_id, lootdrop_id, multiplier, probability) VALUES ('yourID', 'yourID', '#drops', '%#drops');
--> use the same 'yourID' number for sanity's sake; '#drops' is the max number of slots drops will occupy if '%drops' is @ '100'
c) INSERT INTO lootdrop (id, name) VALUES ('yourID', 'yourNAME2');
--> same 'yourID' number & don't use spaces in the 'yourNAME2' field (well, no one else did anyway... not sure if it's required)
d) INSERT INTO lootdrop_entries (lootdrop_id, item_id, item_charges, equip_item, chance) VALUES ('yourID', 'itemID', 1, 1, '%chance');
--> use same 'yourID' for ALL entries of individual items so they stay in your new table; 'itemID' is the "#summonitem" itemID number of the item you want to insert; just keep '%chance' the same with all for equal drop rates of all items in the table
e) UPDATE npc_types SET lootable_id='yourID' WHERE 'condition';
--> 'yourID' is your new loottable ID and 'condition' is the condition upon which you wish to apply the new table (i.e. - loottable_id=0)
Hope that helps :p
Hybrid Mode
