DB/Boralus: Added some more spawns for Tradewinds Market

1 files changed, 248 insertions, 0 deletions

diff --git a/sql/updates/world/master/2024_02_03_00_world.sql b/sql/updates/world/master/2024_02_03_00_world.sql
new file mode 100644
index 00000000000..cd8a2dd3b92
--- /dev/null
+++ b/sql/updates/world/master/2024_02_03_00_world.sql
@@ -0,0 +1,248 @@
+SET @CGUID := 7000317;
+
+-- Creature
+DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+14;
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `VerifiedBuild`) VALUES
+(@CGUID+0, 136059, 1643, 8717, 8718, '0', 0, 0, 0, 0, 1161.93408203125, -659.0850830078125, 29.09493446350097656, 4.966357707977294921, 120, 0, 0, 176210, 0, 0, NULL, NULL, NULL, NULL, 53162), -- Layla Evenkeel (Area: Tradewinds Market - Difficulty: 0) CreateObject1
+(@CGUID+1, 136061, 1643, 8717, 8718, '0', 0, 0, 0, 1, 1173.1910400390625, -623.763916015625, 29.32428741455078125, 5.615747928619384765, 120, 0, 0, 176210, 0, 0, NULL, NULL, NULL, NULL, 53162), -- Camilla Darksky (Area: Tradewinds Market - Difficulty: 0) CreateObject1
+(@CGUID+2, 136063, 1643, 8717, 8718, '0', 0, 0, 0, 0, 1182.6492919921875, -620.37847900390625, 29.516571044921875, 4.470850944519042968, 120, 0, 0, 176210, 0, 0, NULL, NULL, NULL, NULL, 53162), -- Cassandra Brennor (Area: Tradewinds Market - Difficulty: 0) CreateObject1
+(@CGUID+3, 148228, 1643, 8717, 8718, '0', 0, 0, 0, 0, 1195.6771240234375, -646.23089599609375, 29.14507102966308593, 1.498639583587646484, 120, 0, 0, 176210, 0, 0, NULL, NULL, NULL, NULL, 53162), -- Marvin Sipsquall (Area: Tradewinds Market - Difficulty: 0) CreateObject1
+(@CGUID+4, 136071, 1643, 8717, 8718, '0', 0, 0, 0, 0, 1199.8472900390625, -646.623291015625, 29.25776290893554687, 5.050883293151855468, 120, 0, 0, 176210, 0, 0, NULL, NULL, NULL, NULL, 53162), -- Daniel Brineweaver (Area: Tradewinds Market - Difficulty: 0) CreateObject1
+(@CGUID+5, 142346, 1643, 8717, 8718, '0', 0, 0, 0, 0, 1206.584716796875, -645.4351806640625, 29.34119033813476562, 1.085464954376220703, 120, 0, 0, 17621, 0, 0, NULL, NULL, NULL, NULL, 53162), -- Tradewinds Tailor (Area: Tradewinds Market - Difficulty: 0) CreateObject1 (possible waypoints or random movement)
+(@CGUID+6, 136102, 1643, 8717, 8718, '0', 0, 0, 0, 1, 1266.595458984375, -596.904541015625, 40.42242050170898437, 6.143213748931884765, 120, 0, 0, 176210, 0, 0, NULL, NULL, NULL, NULL, 53162), -- Alan Goyle (Area: Tradewinds Market - Difficulty: 0) CreateObject1 (Auras: )
+(@CGUID+7, 130368, 1643, 8717, 8718, '0', 0, 0, 0, 1, 1215.1754150390625, -615.5850830078125, 29.81883811950683593, 2.290356397628784179, 120, 0, 0, 17621, 0, 0, NULL, NULL, NULL, NULL, 53162), -- Samuel D. Colton III (Area: Tradewinds Market - Difficulty: 0) CreateObject1
+(@CGUID+8, 136091, 1643, 8717, 8718, '0', 0, 0, 0, 0, 1242.9600830078125, -616.02081298828125, 30.2190093994140625, 2.222506999969482421, 120, 0, 0, 176210, 0, 0, NULL, NULL, NULL, NULL, 53162), -- Myra Cabot (Area: Tradewinds Market - Difficulty: 0) CreateObject1
+(@CGUID+9, 132228, 1643, 8717, 8718, '0', 0, 0, 0, 0, 1255.1129150390625, -597.7569580078125, 30.44710350036621093, 6.278410911560058593, 120, 0, 0, 17621, 0, 0, NULL, NULL, NULL, NULL, 53162), -- Elric Whalgrene (Area: Tradewinds Market - Difficulty: 0) CreateObject1 (Auras: 260736 - Cosmetic Effects - Elric Whalgrene, 260739 - Cosmetic Effects - Elric Whalgrene)
+(@CGUID+10, 130399, 1643, 8717, 8718, '0', 0, 0, 0, 0, 1257.63720703125, -583.1475830078125, 31.15656280517578125, 6.122046470642089843, 120, 0, 0, 17621, 0, 0, NULL, NULL, NULL, NULL, 53162), -- Zooey Inksprocket (Area: Tradewinds Market - Difficulty: 0) CreateObject1 (Auras: 258161 - Pencil In Ear - Gnome - Cosmetic)
+(@CGUID+11, 133536, 1643, 8717, 8718, '0', 0, 0, 0, 1, 1232.2623291015625, -583.18487548828125, 25.43334770202636718, 1.183392286300659179, 120, 0, 0, 176210, 0, 0, NULL, NULL, NULL, NULL, 53162), -- Grix "Ironfists" Barlow (Area: Tradewinds Market - Difficulty: 0) CreateObject1 (Auras: 281608 - Grix Working At Anvil)
+(@CGUID+12, 136041, 1643, 8717, 8718, '0', 0, 0, 0, 0, 1195.1927490234375, -594.560791015625, 29.79686164855957031, 5.263544559478759765, 120, 0, 0, 176210, 0, 0, NULL, NULL, NULL, NULL, 53162), -- Emily Fairweather (Area: Tradewinds Market - Difficulty: 0) CreateObject1
+(@CGUID+13, 143261, 1643, 8717, 8718, '0', 0, 0, 0, 0, 1193.029541015625, -589.81427001953125, 29.6735076904296875, 0.60609602928161621, 120, 0, 0, 17621, 0, 0, NULL, NULL, NULL, NULL, 53162), -- Chase Hall (Area: Tradewinds Market - Difficulty: 0) CreateObject1
+(@CGUID+14, 142095, 1643, 8717, 8718, '0', 0, 0, 0, 0, 1197.5816650390625, -580.01910400390625, 29.76234054565429687, 3.937714099884033203, 120, 0, 0, 88105, 2434, 0, NULL, NULL, NULL, NULL, 53162); -- Henrick Wyther (Area: Tradewinds Market - Difficulty: 0) CreateObject1 (Auras: 250840 - Read Scroll)
+
+-- Template Addon
+DELETE FROM `creature_template_addon` WHERE `entry` IN (136059, 136061, 136071, 143261, 130368, 130399);
+INSERT INTO `creature_template_addon` (`entry`, `PathId`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES
+(136059, 0, 0, 0, 0, 0, 1, 0, 69, 0, 0, 0, 0, ''), -- Layla Evenkeel
+(136061, 0, 0, 0, 0, 0, 1, 0, 0, 14931, 0, 0, 0, ''), -- 136061 (Camilla Darksky)
+(136071, 0, 0, 0, 0, 0, 1, 0, 69, 0, 0, 0, 0, ''), -- Daniel Brineweaver
+(143261, 0, 0, 0, 0, 0, 1, 0, 10, 0, 0, 0, 0, ''), -- Chase Hall
+(130368, 0, 0, 0, 0, 0, 1, 0, 716, 0, 0, 0, 0, ''), -- Samuel D. Colton III
+(130399, 0, 0, 0, 0, 0, 1, 0, 483, 0, 0, 0, 0, '258161'); -- 130399 (Zooey Inksprocket) - Pencil In Ear - Gnome - Cosmetic
+
+-- Alan Goyle smart ai
+SET @ENTRY := 136102;
+UPDATE `creature_template` SET `AIName` = 'SmartAI', `ScriptName` = '' WHERE `entry` = @ENTRY;
+DELETE FROM `smart_scripts` WHERE `source_type` = 0 AND `entryOrGuid` = @ENTRY;
+INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `Difficulties`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES 
+(@ENTRY, 0, 0, 0, '', 1, 0, 100, 0, 1000, 4000, 17000, 21000, 85, 215172, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Every 17 - 21 seconds (1 - 4s initially) (OOC) - Self: Cast spell 215172 on self');
+
+-- Emily Fairweather smart ai
+SET @ENTRY := 136041;
+DELETE FROM `smart_scripts` WHERE `source_type` = 0 AND `entryOrGuid` = @ENTRY;
+UPDATE `creature_template` SET `AIName` = 'SmartAI', `ScriptName` = '' WHERE `entry` = @ENTRY;
+INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `Difficulties`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES 
+(@ENTRY, 0, 0, 0, '', 1, 0, 100, 0, 18000, 20000, 28000, 31000, 85, 87066, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Every 28 - 31 seconds (18 - 20s initially) (OOC) - Self: Cast spell 87066 on self');
+
+-- Tradewinds Tailor smart ai
+SET @ENTRY := 142346;
+UPDATE `creature_template` SET `AIName` = 'SmartAI', `ScriptName` = '' WHERE `entry` = @ENTRY;
+DELETE FROM `smart_scripts` WHERE `source_type` = 0 AND `entryOrGuid` = -(@CGUID+5);
+INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `Difficulties`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES 
+(-(@CGUID+5), 0, 0, 0, '', 34, 0, 100, 0, 2, 0, 0, 0, 80, 14234600, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On movement of type WAYPOINT_MOTION_TYPE inform - Self: Start timed action list id #Tradewinds Tailor #0 (14234600) (update out of combat)'),
+(-(@CGUID+5), 0, 1, 0, '', 34, 0, 100, 0, 2, 1, 0, 0, 80, 14234600, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On movement of type WAYPOINT_MOTION_TYPE inform, point 1 - Self: Start timed action list id #Tradewinds Tailor #0 (14234600) (update out of combat)'),
+(-(@CGUID+5), 0, 2, 0, '', 34, 0, 100, 0, 2, 2, 0, 0, 80, 14234600, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On movement of type WAYPOINT_MOTION_TYPE inform, point 2 - Self: Start timed action list id #Tradewinds Tailor #0 (14234600) (update out of combat)');
+
+-- Timed list 14234600 smart ai
+SET @ENTRY := 14234600;
+DELETE FROM `smart_scripts` WHERE `source_type` = 9 AND `entryOrGuid` = @ENTRY;
+INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `Difficulties`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES 
+(@ENTRY, 9, 0, 0, '', 0, 0, 100, 0, 0, 0, 0, 0, 17, 69, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'After 0 seconds - Self: Set emote state to 69'),
+(@ENTRY, 9, 1, 0, '', 0, 0, 100, 0, 5000, 5000, 0, 0, 17, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'After 5 seconds - Self: Set emote state to 0');
+
+ -- Grix "Ironfists" Barlow smart ai
+SET @ENTRY := 133536;
+UPDATE `creature_template` SET `AIName` = 'SmartAI', `ScriptName` = '' WHERE `entry` = @ENTRY;
+DELETE FROM `smart_scripts` WHERE `source_type` = 0 AND `entryOrGuid` = @ENTRY;
+INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `Difficulties`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES 
+(@ENTRY, 0, 0, 0, '', 34, 0, 100, 0, 2, 0, 0, 0, 80, 13353600, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On movement of type WAYPOINT_MOTION_TYPE inform - Self: Start timed action list id #Grix "Ironfists" Barlow #0 (13353600) (update out of combat)'),
+(@ENTRY, 0, 1, 0, '', 34, 0, 100, 0, 2, 1, 0, 0, 80, 13353601, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On movement of type WAYPOINT_MOTION_TYPE inform, point 1 - Self: Start timed action list id #Grix "Ironfists" Barlow #1 (13353601) (update out of combat)');
+
+-- Timed list 13353600 smart ai
+SET @ENTRY := 13353600;
+DELETE FROM `smart_scripts` WHERE `source_type` = 9 AND `entryOrGuid` = @ENTRY;
+INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `Difficulties`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES 
+(@ENTRY, 9, 0, 0, '', 0, 0, 100, 0, 0, 0, 0, 0, 85, 281608, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'After 0 seconds - Self: Cast spell 281608 on self'),
+(@ENTRY, 9, 1, 0, '', 0, 0, 100, 0, 10000, 10000, 0, 0, 92, 0, 281608, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'After 10 seconds - Self: Interrupt casted spell  281608');
+
+-- Timed list 13353601 smart ai
+SET @ENTRY := 13353601;
+DELETE FROM `smart_scripts` WHERE `source_type` = 9 AND `entryOrGuid` = @ENTRY;
+INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `Difficulties`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES 
+(@ENTRY, 9, 0, 0, '', 0, 0, 100, 0, 0, 0, 0, 0, 85, 267653, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'After 0 seconds - Self: Cast spell 267653 on self'),
+(@ENTRY, 9, 1, 0, '', 0, 0, 100, 0, 15000, 15000, 0, 0, 92, 0, 267653, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'After 15 seconds - Self: Interrupt casted spell  267653');
+
+-- delete duplicate Gossip
+DELETE FROM `gossip_menu_option` WHERE `MenuID` = 22007 AND `OptionID` IN (14, 15);
+DELETE FROM `gossip_menu_option` WHERE `MenuID` = 22204 AND `OptionID` = 1;
+
+-- Path
+SET @ENTRY := 142346;
+SET @PATHOFFSET := 0;
+SET @PATH := @ENTRY * 100 + @PATHOFFSET;
+DELETE FROM `waypoint_path` WHERE `PathId`= @PATH;
+INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Comment`) VALUES
+(@PATH, 0, 0, 'Tradewinds Tailor - Cosmetic Path');
+
+DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH;
+INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES
+(@PATH, 0, 1208.349, -642.0903, 29.27368, NULL, 6256),
+(@PATH, 1, 1205.833, -644.8299, 29.34067, 2.12739, 6741),
+(@PATH, 2, 1205.663, -647.1823, 29.2909, NULL, 6095);
+
+UPDATE `creature` SET `position_x`= 1208.349, `position_y`= -642.0903, `position_z`= 29.27368, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+5;
+DELETE FROM `creature_addon` WHERE `guid`= @CGUID+5;
+INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES
+(@CGUID+5, @PATH, 1);
+
+-- Path
+SET @ENTRY := 133536;
+SET @PATHOFFSET := 0;
+SET @PATH := @ENTRY * 100 + @PATHOFFSET;
+DELETE FROM `waypoint_path` WHERE `PathId`= @PATH;
+INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Comment`) VALUES
+(@PATH, 0, 0, 'Grix Barlow - Cosmetic Path');
+
+DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH;
+INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES
+(@PATH, 0, 1231.848, -584.2012, 25.43335, NULL, 11602),
+(@PATH, 1, 1232.262, -583.1849, 25.43335, NULL, 16555);
+
+UPDATE `creature` SET `position_x`= 1231.848, `position_y`= -584.2012, `position_z`= 25.43335, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+11;
+DELETE FROM `creature_addon` WHERE `guid`= @CGUID+11;
+INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES
+(@CGUID+11, @PATH, 1);
+
+-- Vendor
+DELETE FROM `npc_vendor` WHERE (`entry`=133536 AND `item`=3857 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=133536 AND `item`=18567 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=133536 AND `item`=160298 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=133536 AND `item`=3466 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=133536 AND `item`=2880 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=133536 AND `item`=180733 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=133536 AND `item`=5956 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=133536 AND `item`=2901 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=130399 AND `item`=158205 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=130399 AND `item`=158186 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=130399 AND `item`=64670 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=130399 AND `item`=39354 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=130399 AND `item`=39489 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=130399 AND `item`=183953 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=130399 AND `item`=39505 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=132228 AND `item`=183950 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=132228 AND `item`=3371 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136091 AND `item`=163836 AND `ExtendedCost`=6048 AND `type`=1) OR (`entry`=136091 AND `item`=20815 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136091 AND `item`=3857 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136091 AND `item`=3466 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136091 AND `item`=2880 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136091 AND `item`=30746 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136091 AND `item`=2901 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=130368 AND `item`=183954 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=130368 AND `item`=52188 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=130368 AND `item`=20815 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=142095 AND `item`=163203 AND `ExtendedCost`=6426 AND `type`=1) OR (`entry`=142095 AND `item`=160298 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=142095 AND `item`=159959 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=142095 AND `item`=160059 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=142095 AND `item`=158205 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=142095 AND `item`=158186 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=142095 AND `item`=163569 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=142095 AND `item`=160502 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=142095 AND `item`=160712 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=142095 AND `item`=160710 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=142095 AND `item`=160709 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=142095 AND `item`=160400 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=142095 AND `item`=160399 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=142095 AND `item`=160398 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=142095 AND `item`=160705 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136041 AND `item`=11291 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136041 AND `item`=4470 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136041 AND `item`=10938 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136041 AND `item`=10940 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136041 AND `item`=6217 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136041 AND `item`=38682 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136041 AND `item`=183951 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136071 AND `item`=2324 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136071 AND `item`=6260 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136071 AND `item`=2604 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136071 AND `item`=2605 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136071 AND `item`=4340 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136071 AND `item`=4341 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136071 AND `item`=6261 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136071 AND `item`=2325 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136071 AND `item`=10290 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136071 AND `item`=4342 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136071 AND `item`=2320 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136071 AND `item`=2321 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136071 AND `item`=4291 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136071 AND `item`=8343 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136071 AND `item`=14341 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136071 AND `item`=38426 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136071 AND `item`=159959 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136071 AND `item`=177062 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=148228 AND `item`=42376 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=148228 AND `item`=42378 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=148228 AND `item`=42377 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=148228 AND `item`=42375 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=148228 AND `item`=42374 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=148228 AND `item`=42372 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=148228 AND `item`=42373 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=148228 AND `item`=42369 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=148228 AND `item`=42370 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=148228 AND `item`=42371 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=148228 AND `item`=42368 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=148228 AND `item`=42363 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=148228 AND `item`=42360 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=148228 AND `item`=42361 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=148228 AND `item`=42365 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=148228 AND `item`=53852 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136063 AND `item`=2325 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136063 AND `item`=2604 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136063 AND `item`=2605 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136063 AND `item`=4340 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136063 AND `item`=4341 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136063 AND `item`=4342 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136063 AND `item`=6260 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136063 AND `item`=6261 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136063 AND `item`=10290 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136063 AND `item`=2324 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136063 AND `item`=159959 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136063 AND `item`=14341 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136063 AND `item`=38426 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136063 AND `item`=8343 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136063 AND `item`=4291 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136063 AND `item`=2321 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136063 AND `item`=2320 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136063 AND `item`=160059 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136063 AND `item`=183955 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136063 AND `item`=177062 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136063 AND `item`=7005 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136061 AND `item`=163838 AND `ExtendedCost`=6048 AND `type`=1) OR (`entry`=136061 AND `item`=160059 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136061 AND `item`=4289 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136061 AND `item`=7005 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136059 AND `item`=163203 AND `ExtendedCost`=6426 AND `type`=1) OR (`entry`=136059 AND `item`=3857 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136059 AND `item`=18567 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136059 AND `item`=160298 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136059 AND `item`=3466 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136059 AND `item`=2880 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136059 AND `item`=5956 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136059 AND `item`=2901 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136059 AND `item`=6219 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136059 AND `item`=160502 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136059 AND `item`=163569 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136059 AND `item`=183952 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=136059 AND `item`=180733 AND `ExtendedCost`=0 AND `type`=1);
+INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `ExtendedCost`, `type`, `PlayerConditionID`, `IgnoreFiltering`, `VerifiedBuild`) VALUES
+(133536, 9, 3857, 0, 0, 1, 0, 0, 53162), -- Coal
+(133536, 8, 18567, 0, 0, 1, 0, 0, 53162), -- Elemental Flux
+(133536, 7, 160298, 0, 0, 1, 0, 0, 53162), -- Durable Flux
+(133536, 6, 3466, 0, 0, 1, 0, 0, 53162), -- Strong Flux
+(133536, 5, 2880, 0, 0, 1, 0, 0, 53162), -- Weak Flux
+(133536, 4, 180733, 0, 0, 1, 0, 0, 53162), -- Luminous Flux
+(133536, 3, 5956, 0, 0, 1, 0, 0, 53162), -- Blacksmith Hammer
+(133536, 2, 2901, 0, 0, 1, 0, 0, 53162), -- Mining Pick
+(130399, 8, 158205, 0, 0, 1, 0, 0, 53162), -- Acacia Powder
+(130399, 7, 158186, 0, 0, 1, 0, 0, 53162), -- Distilled Water
+(130399, 6, 64670, 0, 0, 1, 0, 0, 53162), -- Vanishing Powder
+(130399, 5, 39354, 0, 0, 1, 0, 0, 53162), -- Light Parchment
+(130399, 4, 39489, 0, 0, 1, 0, 0, 53162), -- Scribe's Satchel
+(130399, 3, 183953, 0, 0, 1, 0, 0, 53162), -- Sealing Wax
+(130399, 2, 39505, 0, 0, 1, 0, 0, 53162), -- Virtuoso Inking Set
+(132228, 3, 183950, 0, 0, 1, 0, 0, 53162), -- Distilled Death Extract
+(132228, 2, 3371, 0, 0, 1, 0, 0, 53162), -- Crystal Vial
+(136091, 7, 163836, 0, 6048, 1, 0, 0, 53162), -- Forgotten Techniques of Kul Tiras
+(136091, 6, 20815, 0, 0, 1, 0, 0, 53162), -- Jeweler's Toolset
+(136091, 5, 3857, 0, 0, 1, 0, 0, 53162), -- Coal
+(136091, 4, 3466, 0, 0, 1, 0, 0, 53162), -- Strong Flux
+(136091, 3, 2880, 0, 0, 1, 0, 0, 53162), -- Weak Flux
+(136091, 2, 30746, 0, 0, 1, 0, 0, 53162), -- Mining Sack
+(136091, 1, 2901, 0, 0, 1, 0, 0, 53162), -- Mining Pick
+(130368, 4, 183954, 0, 0, 1, 0, 0, 53162), -- Malleable Wire
+(130368, 3, 52188, 0, 0, 1, 0, 0, 53162), -- Jeweler's Setting
+(130368, 2, 20815, 0, 0, 1, 0, 0, 53162), -- Jeweler's Toolset
+(142095, 15, 163203, 0, 6426, 1, 0, 0, 53162), -- Hypersensitive Azeritometer Sensor
+(142095, 14, 160298, 0, 0, 1, 0, 0, 53162), -- Durable Flux
+(142095, 13, 159959, 0, 0, 1, 0, 0, 53162), -- Nylon Thread
+(142095, 12, 160059, 0, 0, 1, 0, 0, 53162), -- Amber Tanning Oil
+(142095, 11, 158205, 0, 0, 1, 0, 0, 53162), -- Acacia Powder
+(142095, 10, 158186, 0, 0, 1, 0, 0, 53162), -- Distilled Water
+(142095, 9, 163569, 0, 0, 1, 0, 0, 53162), -- Insulated Wiring
+(142095, 8, 160502, 0, 0, 1, 0, 0, 53162), -- Chemical Blasting Cap
+(142095, 7, 160712, 0, 0, 1, 0, 0, 53162), -- Powdered Sugar
+(142095, 6, 160710, 0, 0, 1, 0, 0, 53162), -- Wild Berries
+(142095, 5, 160709, 0, 0, 1, 0, 0, 53162), -- Fresh Potato
+(142095, 4, 160400, 0, 0, 1, 0, 0, 53162), -- Foosaka
+(142095, 3, 160399, 0, 0, 1, 0, 0, 53162), -- Wild Flour
+(142095, 2, 160398, 0, 0, 1, 0, 0, 53162), -- Choral Honey
+(142095, 1, 160705, 0, 0, 1, 0, 0, 53162), -- Major's Frothy Coffee
+(136041, 1254, 11291, 0, 0, 1, 0, 0, 53162), -- Star Wood
+(136041, 1253, 4470, 0, 0, 1, 0, 0, 53162), -- Simple Wood
+(136041, 1252, 10938, 1, 0, 1, 0, 0, 53162), -- Lesser Magic Essence
+(136041, 1251, 10940, 4, 0, 1, 0, 0, 53162), -- Strange Dust
+(136041, 1250, 6217, 0, 0, 1, 0, 0, 53162), -- Copper Rod
+(136041, 1249, 38682, 0, 0, 1, 0, 0, 53162), -- Enchanting Vellum
+(136041, 1248, 183951, 0, 0, 1, 0, 0, 53162), -- Immortal Shard
+(136071, 21, 2324, 0, 0, 1, 0, 0, 53162), -- Bleach
+(136071, 20, 6260, 0, 0, 1, 0, 0, 53162), -- Blue Dye
+(136071, 19, 2604, 0, 0, 1, 0, 0, 53162), -- Red Dye
+(136071, 18, 2605, 0, 0, 1, 0, 0, 53162), -- Green Dye
+(136071, 17, 4340, 0, 0, 1, 0, 0, 53162), -- Gray Dye
+(136071, 16, 4341, 0, 0, 1, 0, 0, 53162), -- Yellow Dye
+(136071, 15, 6261, 0, 0, 1, 0, 0, 53162), -- Orange Dye
+(136071, 14, 2325, 0, 0, 1, 0, 0, 53162), -- Black Dye
+(136071, 13, 10290, 0, 0, 1, 0, 0, 53162), -- Pink Dye
+(136071, 12, 4342, 0, 0, 1, 0, 0, 53162), -- Purple Dye
+(136071, 11, 2320, 0, 0, 1, 0, 0, 53162), -- Coarse Thread
+(136071, 10, 2321, 0, 0, 1, 0, 0, 53162), -- Fine Thread
+(136071, 9, 4291, 0, 0, 1, 0, 0, 53162), -- Silken Thread
+(136071, 8, 8343, 0, 0, 1, 0, 0, 53162), -- Heavy Silken Thread
+(136071, 7, 14341, 0, 0, 1, 0, 0, 53162), -- Rune Thread
+(136071, 6, 38426, 0, 0, 1, 0, 0, 53162), -- Eternium Thread
+(136071, 3, 159959, 0, 0, 1, 0, 0, 53162), -- Nylon Thread
+(136071, 2, 177062, 0, 0, 1, 0, 0, 53162), -- Penumbra Thread
+(148228, 16, 42376, 0, 0, 1, 0, 0, 53162), -- Yellow Martial Shirt
+(148228, 15, 42378, 0, 0, 1, 0, 0, 53162), -- Red Martial Shirt
+(148228, 14, 42377, 0, 0, 1, 0, 0, 53162), -- Purple Martial Shirt
+(148228, 13, 42375, 0, 0, 1, 0, 0, 53162), -- Green Martial Shirt
+(148228, 12, 42374, 0, 0, 1, 0, 0, 53162), -- Blue Martial Shirt
+(148228, 11, 42372, 0, 0, 1, 0, 0, 53162), -- Scarlet Filigreed Shirt
+(148228, 10, 42373, 0, 0, 1, 0, 0, 53162), -- Golden Filigreed Shirt
+(148228, 9, 42369, 0, 0, 1, 0, 0, 53162), -- Ebon Filigreed Shirt
+(148228, 8, 42370, 0, 0, 1, 0, 0, 53162), -- Cerulean Filigreed Shirt
+(148228, 7, 42371, 0, 0, 1, 0, 0, 53162), -- Amber Filigreed Shirt
+(148228, 6, 42368, 0, 0, 1, 0, 0, 53162), -- Scarlet Filigreed Doublet
+(148228, 5, 42363, 0, 0, 1, 0, 0, 53162), -- Golden Filigreed Doublet
+(148228, 4, 42360, 0, 0, 1, 0, 0, 53162), -- Ebon Filigreed Doublet
+(148228, 3, 42361, 0, 0, 1, 0, 0, 53162), -- Cerulean Filigreed Doublet
+(148228, 2, 42365, 0, 0, 1, 0, 0, 53162), -- Amber Filigreed Doublet
+(148228, 1, 53852, 0, 0, 1, 0, 0, 53162), -- Embroidered Shirt
+(136063, 22, 2325, 0, 0, 1, 0, 0, 53162), -- Black Dye
+(136063, 21, 2604, 0, 0, 1, 0, 0, 53162), -- Red Dye
+(136063, 20, 2605, 0, 0, 1, 0, 0, 53162), -- Green Dye
+(136063, 19, 4340, 0, 0, 1, 0, 0, 53162), -- Gray Dye
+(136063, 18, 4341, 0, 0, 1, 0, 0, 53162), -- Yellow Dye
+(136063, 17, 4342, 0, 0, 1, 0, 0, 53162), -- Purple Dye
+(136063, 16, 6260, 0, 0, 1, 0, 0, 53162), -- Blue Dye
+(136063, 15, 6261, 0, 0, 1, 0, 0, 53162), -- Orange Dye
+(136063, 14, 10290, 0, 0, 1, 0, 0, 53162), -- Pink Dye
+(136063, 13, 2324, 0, 0, 1, 0, 0, 53162), -- Bleach
+(136063, 12, 159959, 0, 0, 1, 0, 0, 53162), -- Nylon Thread
+(136063, 11, 14341, 0, 0, 1, 0, 0, 53162), -- Rune Thread
+(136063, 10, 38426, 0, 0, 1, 0, 0, 53162), -- Eternium Thread
+(136063, 9, 8343, 0, 0, 1, 0, 0, 53162), -- Heavy Silken Thread
+(136063, 8, 4291, 0, 0, 1, 0, 0, 53162), -- Silken Thread
+(136063, 7, 2321, 0, 0, 1, 0, 0, 53162), -- Fine Thread
+(136063, 6, 2320, 0, 0, 1, 0, 0, 53162), -- Coarse Thread
+(136063, 5, 160059, 0, 0, 1, 0, 0, 53162), -- Amber Tanning Oil
+(136063, 4, 183955, 0, 0, 1, 0, 0, 53162), -- Curing Salt
+(136063, 3, 177062, 0, 0, 1, 0, 0, 53162), -- Penumbra Thread
+(136063, 2, 7005, 0, 0, 1, 0, 0, 53162), -- Skinning Knife
+(136061, 4, 163838, 0, 6048, 1, 0, 0, 53162), -- Forgotten Techniques of Kul Tiras
+(136061, 3, 160059, 0, 0, 1, 0, 0, 53162), -- Amber Tanning Oil
+(136061, 2, 4289, 0, 0, 1, 0, 0, 53162), -- Salt
+(136061, 1, 7005, 0, 0, 1, 0, 0, 53162), -- Skinning Knife
+(136059, 14, 163203, 0, 6426, 1, 0, 0, 53162), -- Hypersensitive Azeritometer Sensor
+(136059, 13, 3857, 0, 0, 1, 0, 0, 53162), -- Coal
+(136059, 12, 18567, 0, 0, 1, 0, 0, 53162), -- Elemental Flux
+(136059, 11, 160298, 0, 0, 1, 0, 0, 53162), -- Durable Flux
+(136059, 10, 3466, 0, 0, 1, 0, 0, 53162), -- Strong Flux
+(136059, 9, 2880, 0, 0, 1, 0, 0, 53162), -- Weak Flux
+(136059, 8, 5956, 0, 0, 1, 0, 0, 53162), -- Blacksmith Hammer
+(136059, 7, 2901, 0, 0, 1, 0, 0, 53162), -- Mining Pick
+(136059, 6, 6219, 0, 0, 1, 0, 0, 53162), -- Arclight Spanner
+(136059, 5, 160502, 0, 0, 1, 0, 0, 53162), -- Chemical Blasting Cap
+(136059, 4, 163569, 0, 0, 1, 0, 0, 53162), -- Insulated Wiring
+(136059, 3, 183952, 0, 0, 1, 0, 0, 53162), -- Machinist's Oil
+(136059, 2, 180733, 0, 0, 1, 0, 0, 53162); -- Luminous Flux