Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers
Reload this Page Questnpcs don't work in tutorial or beyond.

Support::Windows Servers Support forum for Windows EQEMu users.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #30  
Old 03-31-2018, 06:50 PM
Uleat's Avatar
Uleat
Developer
  
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
Default
If you want defiant armor to drop as normal loot, you probably need to run this optional sql script: https://github.com/EQEmu/Server/blob...balDefiant.sql


In addition, I have a personal script adapted from that to add 'Accoutrements' as drops - since I don't believe we have those set up just yet.

Code:
DELETE FROM lootdrop_entries WHERE item_id BETWEEN 50300 AND 50319;

SELECT @loottable_id := MAX(id) + 1 FROM loottable;
INSERT INTO loottable SET id=@loottable_id, name="GLB-Crude-Accoutrement", mincash="0", maxcash="0", avgcoin="0";
SELECT @lootdrop_id := MAX(id) + 1 FROM lootdrop;
INSERT INTO lootdrop SET id=@lootdrop_id, name="GLB-Crude-Accoutrement-Drop";
INSERT INTO loottable_entries SET loottable_id=@loottable_id, lootdrop_id=@lootdrop_id, droplimit='0', mindrop='1', multiplier='1', probability='2';
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50300, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50301, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50302, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50303, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50304, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50305, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50306, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50307, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50308, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50309, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50310, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50311, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50312, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50313, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50314, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50315, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50316, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50317, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50318, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50319, equip_item=1, item_charges=1, multiplier=1, chance=1;

INSERT INTO global_loot SET description='GLB-Crude-Accoutrement', loottable_id=@loottable_id, max_level=15;

DELETE FROM lootdrop_entries WHERE item_id BETWEEN 50320 AND 50339;

SELECT @loottable_id := MAX(id) + 1 FROM loottable;
INSERT INTO loottable SET id=@loottable_id, name="GLB-Simple-Accoutrement", mincash="0", maxcash="0", avgcoin="0";
SELECT @lootdrop_id := MAX(id) + 1 FROM lootdrop;
INSERT INTO lootdrop SET id=@lootdrop_id, name="GLB-Simple-Accoutrement-Drop";
INSERT INTO loottable_entries SET loottable_id=@loottable_id, lootdrop_id=@lootdrop_id, droplimit='0', mindrop='1', multiplier='1', probability='2';
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50320, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50321, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50322, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50323, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50324, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50325, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50326, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50327, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50328, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50329, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50330, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50331, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50332, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50333, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50334, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50335, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50336, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50337, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50338, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50339, equip_item=1, item_charges=1, multiplier=1, chance=1;

INSERT INTO global_loot SET description='GLB-Simple-Accoutrement', loottable_id=@loottable_id, min_level=14, max_level=25;

DELETE FROM lootdrop_entries WHERE item_id BETWEEN 50340 AND 50359;

SELECT @loottable_id := MAX(id) + 1 FROM loottable;
INSERT INTO loottable SET id=@loottable_id, name="GLB-Rough-Accoutrement", mincash="0", maxcash="0", avgcoin="0";
SELECT @lootdrop_id := MAX(id) + 1 FROM lootdrop;
INSERT INTO lootdrop SET id=@lootdrop_id, name="GLB-Rough-Accoutrement-Drop";
INSERT INTO loottable_entries SET loottable_id=@loottable_id, lootdrop_id=@lootdrop_id, droplimit='0', mindrop='1', multiplier='1', probability='2';
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50340, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50341, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50342, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50343, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50344, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50345, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50346, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50347, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50348, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50349, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50350, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50351, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50352, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50353, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50354, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50355, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50356, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50357, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50358, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50359, equip_item=1, item_charges=1, multiplier=1, chance=1;

INSERT INTO global_loot SET description='GLB-Rough-Accoutrement', loottable_id=@loottable_id, min_level=24, max_level=36;

DELETE FROM lootdrop_entries WHERE item_id BETWEEN 50360 AND 50379;

SELECT @loottable_id := MAX(id) + 1 FROM loottable;
INSERT INTO loottable SET id=@loottable_id, name="GLB-Ornate-Accoutrement", mincash="0", maxcash="0", avgcoin="0";
SELECT @lootdrop_id := MAX(id) + 1 FROM lootdrop;
INSERT INTO lootdrop SET id=@lootdrop_id, name="GLB-Ornate-Accoutrement-Drop";
INSERT INTO loottable_entries SET loottable_id=@loottable_id, lootdrop_id=@lootdrop_id, droplimit='0', mindrop='1', multiplier='1', probability='2';
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50360, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50361, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50362, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50363, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50364, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50365, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50366, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50367, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50368, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50369, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50370, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50371, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50372, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50373, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50374, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50375, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50376, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50377, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50378, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50379, equip_item=1, item_charges=1, multiplier=1, chance=1;

INSERT INTO global_loot SET description='GLB-Ornate-Accoutrement', loottable_id=@loottable_id, min_level=35, max_level=47;

DELETE FROM lootdrop_entries WHERE item_id BETWEEN 50380 AND 50399;

SELECT @loottable_id := MAX(id) + 1 FROM loottable;
INSERT INTO loottable SET id=@loottable_id, name="GLB-Flawed-Accoutrement", mincash="0", maxcash="0", avgcoin="0";
SELECT @lootdrop_id := MAX(id) + 1 FROM lootdrop;
INSERT INTO lootdrop SET id=@lootdrop_id, name="GLB-Flawed-Accoutrement-Drop";
INSERT INTO loottable_entries SET loottable_id=@loottable_id, lootdrop_id=@lootdrop_id, droplimit='0', mindrop='1', multiplier='1', probability='2';
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50380, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50381, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50382, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50383, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50384, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50385, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50386, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50387, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50388, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50389, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50390, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50391, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50392, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50393, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50394, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50395, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50396, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50397, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50398, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50399, equip_item=1, item_charges=1, multiplier=1, chance=1;

INSERT INTO global_loot SET description='GLB-Flawed-Accoutrement', loottable_id=@loottable_id, enabled=0, min_level=44, max_level=55;

DELETE FROM lootdrop_entries WHERE item_id BETWEEN 50401 AND 50420;

SELECT @loottable_id := MAX(id) + 1 FROM loottable;
INSERT INTO loottable SET id=@loottable_id, name="GLB-Intricate-Accoutrement", mincash="0", maxcash="0", avgcoin="0";
SELECT @lootdrop_id := MAX(id) + 1 FROM lootdrop;
INSERT INTO lootdrop SET id=@lootdrop_id, name="GLB-Intricate-Accoutrement-Drop";
INSERT INTO loottable_entries SET loottable_id=@loottable_id, lootdrop_id=@lootdrop_id, droplimit='0', mindrop='1', multiplier='1', probability='2';
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50401, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50402, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50403, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50404, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50405, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50406, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50407, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50408, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50409, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50410, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50411, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50412, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50413, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50414, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50415, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50416, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50417, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50418, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50419, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50420, equip_item=1, item_charges=1, multiplier=1, chance=1;

INSERT INTO global_loot SET description='GLB-Intricate-Accoutrement', loottable_id=@loottable_id, enabled=0, min_level=54, max_level=65;

DELETE FROM lootdrop_entries WHERE item_id BETWEEN 50422 AND 50441;

SELECT @loottable_id := MAX(id) + 1 FROM loottable;
INSERT INTO loottable SET id=@loottable_id, name="GLB-Elaborate-Accoutrement", mincash="0", maxcash="0", avgcoin="0";
SELECT @lootdrop_id := MAX(id) + 1 FROM lootdrop;
INSERT INTO lootdrop SET id=@lootdrop_id, name="GLB-Elaborate-Accoutrement-Drop";
INSERT INTO loottable_entries SET loottable_id=@loottable_id, lootdrop_id=@lootdrop_id, droplimit='0', mindrop='1', multiplier='1', probability='2';
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50422, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50423, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50424, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50425, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50426, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50427, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50428, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50429, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50430, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50431, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50432, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50433, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50434, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50435, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50436, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50437, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50438, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50439, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50440, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50441, equip_item=1, item_charges=1, multiplier=1, chance=1;

INSERT INTO global_loot SET description='GLB-Elaborate-Accoutrement', loottable_id=@loottable_id, enabled=0, min_level=64, max_level=75;

DELETE FROM lootdrop_entries WHERE item_id BETWEEN 50443 AND 50462;

SELECT @loottable_id := MAX(id) + 1 FROM loottable;
INSERT INTO loottable SET id=@loottable_id, name="GLB-Elegant-Accoutrement", mincash="0", maxcash="0", avgcoin="0";
SELECT @lootdrop_id := MAX(id) + 1 FROM lootdrop;
INSERT INTO lootdrop SET id=@lootdrop_id, name="GLB-Elegant-Accoutrement-Drop";
INSERT INTO loottable_entries SET loottable_id=@loottable_id, lootdrop_id=@lootdrop_id, droplimit='0', mindrop='1', multiplier='1', probability='2';
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50443, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50444, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50445, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50446, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50447, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50448, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50449, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50450, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50451, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50452, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50453, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50454, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50455, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50456, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50457, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50458, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50459, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50460, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50461, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50462, equip_item=1, item_charges=1, multiplier=1, chance=1;

INSERT INTO global_loot SET description='GLB-Elegant-Accoutrement', loottable_id=@loottable_id, enabled=0, min_level=74, max_level=86;
__________________
Uleat of Bertoxxulous

Compilin' Dirty
Reply With Quote
 

« Previous Thread | Next Thread »

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

   

All times are GMT -4. The time now is 12:45 PM.

EQEmulator - Archive - Top

 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3