Questnpcs don't work in tutorial or beyond.

[Uleat]

Crude thru Elegant are in the items table.

Only Crude thru Ornate were set up to be active in loot tables..but, a recent change to loot may have changed that?

[Tegila]

so, im trying to turn back on some merchants and create 2 new ones which started as copies of the 2 disabled ones. i found column spawnlimit was 0 so i set that to 1, i removed teh # at start of their names, and i changed qglobal from 0 to 1 bc the other npcs i KNOW are up have that settings, but im not 100% sure on those. i then hit save loot, because thats the only save or apply button i can find. Did i do that right and i should jsut go restart the server? or did i do it wrong and no point in restarting server yet?

edit: this is in npc editor. the merchant editor still wont show my 2 newly created dudes so idk what i did and didnt actually save at this point

[Tegila]

Originally Posted by Uleat

Crude thru Elegant are in the items table.

Only Crude thru Ornate were set up to be active in loot tables..but, a recent change to loot may have changed that?

its possible no oen saw any yet bc they were too low level for crude+, but i like the idea of putting on merchant isntead of filling bags with duplicate loot. just gotta get the merchants to pop.

[GRUMPY]

This one of the "new" wiki's that's being worked on (I think).
This link shows what's needed to be done after server changes.
https://github.com/EQEmu/Server/wiki...r-Data-Loading

[Tegila]

got merchants up, my first new one populated inventory just fine. the second one wont even though did exact same thing...however he has more stuff, is there a limit to vender inventory items, and if you go over that will it bug out? hes only showing a cloth cap for sale lol

i need to stop askign new questions in the same thread, but at same time fewer threads. scatterbrain.

yeah im lost lol. got a 3rd new vender ot pop, all his stuff's correct, but i tried to remove his stuff from another and its still there, and remove it from the one thats not showing anything but its still showing in merchant editor and the merchant inventory in game only has cloth cap..i.e. not updating. i dont get why im doing the same thing and its working right for most but not for some. bleh

[Uleat]

Try running this query and see if it returns anything

SELECT * FROM `lootdrop` WHERE `name` LIKE 'GLB-%';

[Uleat]

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.

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;

[Tegila]

Accoutrements. You mean the combatant and adept stuff? I'm using their vendors to get the defiant (and terrorinfused since extravagant armor both sucks and is no trade no price pita) Dont think they ever did drop on live but if gonna have defiant drop why put the accessories on vendors. Should be all 1 or other imo

And thx for the link. I did a million searches looking for how but e everything was how not to lol.

Also, I got vendors to all populate now, just have to zone out, reloadstatic pok, hotfix, zone in, repop force, and all done. Lol, not sure it's ALL necessary but it works without restart. I'll slowly figure this all out and then I'll be glued to it updating the newer zones to jive with live...well live circa rof2, not live now. Modern Nostalgia. Huge change in game since rof2 either bc of daybreak or just too much gear inflation.

[Uleat]

Yeah, that 'Accoutrements' script is definitely non-live like..but, I play solo when I do play and prefer to hunt for that stuffs

[Tegila]

i jsut went thorugh and worked this out to adjust the prices of all my defiant etc stuff, im jsut wondering if i did it right (i popped in terror infused for all classes bc extravagant consigned sucks and more things to alter, and the disadvantage to terror infused is it's all/all thus not very wel lspecialized even into archetype, but then i left the extravagant side pieces in and put no weapons, to make it less a gimme) i have the stuff already on merchant but prices were all over the place i saw.

'use peq'

UPDATE items SET cost = 2000 WHERE name LIKE 'Crude Defiant%';
UPDATE items SET cost = 7000 WHERE name LIKE 'Simple Defiant%';
UPDATE items SET cost = 15000 WHERE name LIKE 'Rough Defiant%';
UPDATE items SET cost = 50000 WHERE name LIKE 'Ornate Defiant%';
UPDATE items SET cost = 150000 WHERE name LIKE 'Flawed Defiant%';
UPDATE items SET cost = 500000 WHERE name LIKE 'Intricate Defiant%';
UPDATE items SET cost = 1500000 WHERE name LIKE 'Elaborate Defiant%';
UPDATE items SET cost = 5000000 WHERE name LIKE 'Elegant Defiant%';
UPDATE items SET cost = 15000000 WHERE name LIKE 'Terror Infused%';

UPDATE items SET cost = 2000 WHERE name LIKE 'Crude Adept%';
UPDATE items SET cost = 7000 WHERE name LIKE 'Simple Adept%';
UPDATE items SET cost = 15000 WHERE name LIKE 'Rough Adept%';
UPDATE items SET cost = 50000 WHERE name LIKE 'Ornate Adept%';
UPDATE items SET cost = 150000 WHERE name LIKE 'Flawed Adept%';
UPDATE items SET cost = 500000 WHERE name LIKE 'Intricate Adept%';
UPDATE items SET cost = 1500000 WHERE name LIKE 'Elaborate Adept%';
UPDATE items SET cost = 5000000 WHERE name LIKE 'Elegant Adept%';
UPDATE items SET cost = 15000000 WHERE name LIKE 'Extravagant Adept%';

UPDATE items SET cost = 2000 WHERE name LIKE 'Crude Combatant%';
UPDATE items SET cost = 7000 WHERE name LIKE 'Simple Combatant%';
UPDATE items SET cost = 15000 WHERE name LIKE 'Rough Combatant%';
UPDATE items SET cost = 50000 WHERE name LIKE 'Ornate Combatant%';
UPDATE items SET cost = 150000 WHERE name LIKE 'Flawed Combatant%';
UPDATE items SET cost = 500000 WHERE name LIKE 'Intricate Combatant%';
UPDATE items SET cost = 1500000 WHERE name LIKE 'Elaborate Combatant%';
UPDATE items SET cost = 5000000 WHERE name LIKE 'Elegant Combatant%';
UPDATE items SET cost = 15000000 WHERE name LIKE 'Extravagant Combatant%';

UPDATE items SET cost = 2000 WHERE name LIKE 'Crude Summoner%';
UPDATE items SET cost = 7000 WHERE name LIKE 'Simple Summoner%';
UPDATE items SET cost = 15000 WHERE name LIKE 'Rough Summoner%';
UPDATE items SET cost = 50000 WHERE name LIKE 'Ornate Summoner%';
UPDATE items SET cost = 150000 WHERE name LIKE 'Flawed Summoner%';
UPDATE items SET cost = 500000 WHERE name LIKE 'Intricate Summoner%';
UPDATE items SET cost = 1500000 WHERE name LIKE 'Elaborate Summoner%';
UPDATE items SET cost = 5000000 WHERE name LIKE 'Elegant Summoner%';
UPDATE items SET cost = 15000000 WHERE name LIKE 'Extravagant Summoner%';

if that looks right, awesome. if not ill see if i can modify what you put up. i didnt read through it, i found another thread detailing putting up new merchants without an editor. but, this being first code im putting together with just the pieces, not substitution from a copy n paste job, and it affects a lot of stuff, id like a second opinion before i put it through to the db

edit: looking at that and the stats i think ill lower the extravagant stuff some, its nowhere near the stats of terror of course. i mostly tripled and rounded up to next round 5 somethign number after the first 3 tiers, i thought tripling 7 to 21 was both a little steep (at the early part of that gear) and messy for my end pricing goals lol edit2: yeah went up on the terror to 20k and down on extravagant to 10k, thats still steep for the extravagant, but this isnt a server where everyone is giving it away, and i think im going to remove it all from teh drop table, so that its not a luck thing to get, but a work thing (farm the plat on a mostly empty server) for the level etc.

that means i need to use the script linked before to remove what defiants might be active in loottables too now, or would i jsut do somethign like

DELETE * FROM `lootdrop` WHERE `name` LIKE 'GLB-%';

being that the items are still on teh items table of course, would that work? or wrong wording?

Edit PRICE not cost lol

[Tegila]

along those same lines and joining with the fabled discussion elsewehre, would this work for enabling the fableds taht at least have loottables and are spawned normally and setting their spawnrate to 3% (for yearround availability)?

UPDATE spawn2 SET enabled = 1 WHERE npc_types.name LIKE '%Fabled%';
UPDATE spawnentry SET chance = 3 WHERE npc_types.name LIKE '%Fabled%' AND spawngroupid > 1;

[GRUMPY]

What you're looking at doing is not that simple. It's not just a matter of "enabling" the fabled mobs,
first they have to be added to the spawn tables. All those NPC's you see in the npc_types table,
they exist in the database, but in the case of some, like "fabled", they need to be added to
the spawn table BEFORE you can set the enabled value.(and other values within the spawn tables
that you created. There is mass queries that can be made to do the job, but every NPC in that
database has it's own unique npcID (number), so writing that whole query would take some time to
include ALL npc's with the name "fabled" and their assigned npcID.

[Tegila]

Originally Posted by GRUMPY

What you're looking at doing is not that simple. It's not just a matter of "enabling" the fabled mobs,
first they have to be added to the spawn tables. All those NPC's you see in the npc_types table,
they exist in the database, but in the case of some, like "fabled", they need to be added to
the spawn table BEFORE you can set the enabled value.(and other values within the spawn tables
that you created. There is mass queries that can be made to do the job, but every NPC in that
database has it's own unique npcID (number), so writing that whole query would take some time to
include ALL npc's with the name "fabled" and their assigned npcID.

thats why i was just turning on the ones that were in spawn2 in the first place and assuming if they dont get turned on they have no loottable or are scripted, though some in spawn2 have no loottable anyway im seeing, but not many.


im going through manually atm and writing down the ids of all the ones that actually have fabled loot on them, not jsut loottables (many have no fabled items in their loottables) but that'll be a lot more lines to enable, though prevents fabled mobs with no fabled loot lol.

im not expecting to run the "enabled = 1" line and every fabled in the database magically has a loottable and is fully populated in the spawn tables, i was just looking to turn on the ones that are already in the spawn tables. And I have....the most worthwhile group/solo-able ones (big raid ones are not completed or really even relevant to me atm) are present, like all the swarm-pet weapons and whatnot. might be 1 or 2 missing, i gotta dig into that but they appear to be all there.

a lot of the others i'm going to have to populate their loottables with their actual fabled items before i even bother

i am seeing the AND spawngroupid > 1 is completely pointless, but i didnt watn to jsut assume in that case. i know to be in spawn2 they must have a spawngroupid, but i wasnt sure when i wrote that if the qualifier was needed for spawnentry. however, the line to set their spawnrate is definitely not going to work without then subtracting 3 from its nonfabled version or some junk mob which would have to be in same line i would think because Math, but how to take a value in the table and add three... * + 3 ?. i may just want to do that one by hand. do a SELECT to pull up similar to that script, then with the npcid's alter 1 by 1. i may just leave the spawn chance alone for those with spawn groups, unless i find theyre too high.

So if wanting to write that it would be

UPDATE spawnentry SET chance = * - 3 WHERE npc_types.name NOT LIKE '%Fabled%';
UPDATE spawnentry SET chance = 3 WHERE npc_types.name LIKE '%Fabled%';

being that the subtraction has to be before the addition, if it even matters, if that syntax would even remotely work ( would it be '* - 3' or `* - 3` or..i have no idea, and having it find a mob with same name as the fabled but without the_fabled...i dont think that can be done without some serious convolutedness. so, i could jsut run the second line there after subtracting 3 from nonfableds but thats kinda pointless. I could just do a query for the spawnentries then find the next rarest spawn and go from there, but al lthat is just silly. most if not all the fableds that DO have spawns set up, are already set at 5. that's good enough for me, but i can edit those easier in goerges if need be. but i do need to create all the rest of them, and put the right loot on the ones that dont even have loot and THEN their spawns, and finally add all the oens that arent even in teh db - thats the seriously tedium lol.

[c0ncrete]

It's probably best if you work out a way to do it programatically and to log your changes so you can easily revert with granular control. I'm slowly putting together something for similar reasons myself. I'll be looking for any item not currently obtainable via drops, tradeskills, quests, etc and will be giving them a small chance at dropping globally via script instead of global loot tables.

use Modern::Perl;

# custom modules
use EQEmu::Database;
use EQEmu::Util 'debug';
no warnings 'EQEmu::Database::empty';
my $dbh = EQEmu::Database->new;

# logging
use FileHandle;
my $log = FileHandle->new("> test_SQL.out");
$log->autoflush(1);

# variables
my $sql = ''; # for queries
my $res = (); # for results

# get all item ids and names
$sql = 'SELECT id, Name FROM items';
my $all_items = {
    map {
        $_->{id},
        $_->{Name}
    } @{$dbh->Query($sql)}
};

while (my ($itemID, $itemName) = each $all_items) {

    # look for lootdrop entries for current item
    $sql = "SELECT lootdrop_id FROM lootdrop_entries WHERE lootdrop_entries.item_id = $itemID";
    $res = $dbh->Query($sql);

    # no lootdrop entry found
    unless ($res) {
        say $log "INFO: no lootdrop entry found for $itemID [ $itemName ]";
        # TODO: check tradeskill yields (parse output from another query)
        # TODO: check quest rewards (parse scripts for summoning of itemID)
        next;
    }

    # lootdrop entry found
    say $log "INFO: ".@$res." lootdrop entries found for $itemID [ $itemName ]";
    # TODO: validate lootdrop entry
    # TODO: validate loottable entry
    # TODO: validate spawn, etc
}

[Tegila]

is there some modifier to merchant prices that's like 20x? been looking but cant find, however my 2pp stuff is 41+ pp and the 20k stuff has more digits than it can handle and goes negative lol
i know faction and charisma..but not 20x the price.

the merchant price update worked great otherwise. but 2000cp is not 41pp in any way shape or form


I am building the spawntables for those with actual fabled loot already there, 1 at a time but it's quick the way i have my list set up. the stuff that alreayd had spawntables i activated and got 1/3 of the rest already done. but thats still only about half of what's in the database, and thats about 1/3 of what's on Live so.. 1 step at a time. half the fableds in this list ive never even heard of, but im not oldschool eq, i started during TBS