Borean tundra pickpocket loot

-- Fix to add pickpocketing loot for humoniods in borean tundra
-- Add pickpocketing loot for Beryl Reclaimer
SET @NPC =25449;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 37467, 32.5, 1, 0, 1, 1), -- A Steamy Romance Novel: Forbidden Love
(@NPC, 43575, 31, 1, 0, 1, 1), -- Reinforced Junkbox
(@NPC, 38261, 10, 1, 0, 1, 1), -- Bent House Key
(@NPC, 29448, 7, 1, 0, 1, 1), -- Mag'har Mild Cheese
(@NPC, 29450, 7, 1, 0, 1, 1), -- Telaari Grapes
(@NPC, 33447, 6, 1, 0, 1, 1), -- Runic Healing Potion
(@NPC, 33449, 6, 1, 0, 1, 1), -- Crusty Flatbread
(@NPC, 36863, 0.5, 1, 0, 1, 1); -- Decahedral Dwarven Dice

-- Add pickpocketing loot for Beryl Sorcerer
SET @NPC =25316;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 37467, 32.5, 1, 0, 1, 1), -- A Steamy Romance Novel: Forbidden Love
(@NPC, 43575, 31, 1, 0, 1, 1), -- Reinforced Junkbox
(@NPC, 38261, 12, 1, 0, 1, 1), -- Bent House Key
(@NPC, 29448, 7, 1, 0, 1, 1), -- Mag'har Mild Cheese
(@NPC, 29450, 7, 1, 0, 1, 1), -- Telaari Grapes
(@NPC, 33447, 5, 1, 0, 1, 1), -- Runic Healing Potion
(@NPC, 33449, 5, 1, 0, 1, 1), -- Crusty Flatbread
(@NPC, 36863, 0.5, 1, 0, 1, 1); -- Decahedral Dwarven Dice

-- Add pickpocketing loot for Beryl Treasure Hunter
SET @NPC =25353;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 37467, 32.5, 1, 0, 1, 1), -- A Steamy Romance Novel: Forbidden Love
(@NPC, 43575, 31, 1, 0, 1, 1), -- Reinforced Junkbox
(@NPC, 38261, 12, 1, 0, 1, 1), -- Bent House Key
(@NPC, 29448, 7, 1, 0, 1, 1), -- Mag'har Mild Cheese
(@NPC, 29450, 7, 1, 0, 1, 1), -- Telaari Grapes
(@NPC, 33447, 5, 1, 0, 1, 1), -- Runic Healing Potion
(@NPC, 33449, 5, 1, 0, 1, 1), -- Crusty Flatbread
(@NPC, 36863, 0.5, 1, 0, 1, 1); -- Decahedral Dwarven Dice

-- Add pickpocketing loot for Bloodspore Firestarter
SET @NPC =25470;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 29572, 37.5, 1, 0, 1, 1), -- Aboriginal Carvings
(@NPC, 29569, 33, 1, 0, 1, 1), -- Strong Junkbox
(@NPC, 8952, 20, 1, 0, 1, 1), -- Roasted Quail
(@NPC, 22829, 8, 1, 0, 1, 1), -- Super Healing Potion
(@NPC, 23438, 0.5, 1, 0, 1, 1), -- Star of Elune
(@NPC, 23436, 0.5, 1, 0, 1, 1), -- Living Ruby
(@NPC, 23437, 0.5, 1, 0, 1, 1); -- Talasite

-- Add pickpocketing loot for Bloodspore Harvester
SET @NPC =25467;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 29572, 35, 1, 0, 1, 1), -- Aboriginal Carvings
(@NPC, 29569, 31, 1, 0, 1, 1), -- Strong Junkbox
(@NPC, 8952, 27, 1, 0, 1, 1), -- Roasted Quail
(@NPC, 22829, 7, 1, 0, 1, 1), -- Super Healing Potion
(@NPC, 23441, 0.5, 1, 0, 1, 1), -- Nightseye
(@NPC, 23437, 0.5, 1, 0, 1, 1); -- Talasite

-- Add pickpocketing loot for Bloodspore Roaster
SET @NPC =25468;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 29569, 38, 1, 0, 1, 1), -- Strong Junkbox
(@NPC, 8952, 32.5, 1, 0, 1, 1), -- Roasted Quail
(@NPC, 29572, 21.5, 1, 0, 1, 1), -- Aboriginal Carvings
(@NPC, 22829, 7.5, 1, 0, 1, 1), -- Super Healing Potion
(@NPC, 23440, 0.5, 1, 0, 1, 1); -- Dawnstone

-- Add pickpocketing loot for Chieftain Burblegobble
SET @NPC =25726;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 29569, 50, 1, 0, 1, 1), -- Strong Junkbox
(@NPC, 27858, 20, 1, 0, 1, 1), -- Sunspring Carp
(@NPC, 29576, 20, 1, 0, 1, 1), -- Shark Bait
(@NPC, 22829, 10, 1, 0, 1, 1); -- Super Healing Potion

-- Add pickpocketing loot for Chieftain Gurgleboggle
SET @NPC =25725;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 29569, 38.25, 1, 0, 1, 1), -- Strong Junkbox
(@NPC, 27858, 12.25, 1, 0, 1, 1), -- Sunspring Carp
(@NPC, 29576, 30.25, 1, 0, 1, 1), -- Shark Bait
(@NPC, 22829, 19.25, 1, 0, 1, 1); -- Super Healing Potion

-- Add pickpocketing loot for Clam Master K
SET @NPC =25800;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 43575, 39, 1, 0, 1, 1), -- Reinforced Junkbox
(@NPC, 37467, 29, 1, 0, 1, 1), -- A Steamy Romance Novel: Forbidden Love
(@NPC, 38261, 13, 1, 0, 1, 1), -- Bent House Key
(@NPC, 29448, 7, 1, 0, 1, 1), -- Mag'har Mild Cheese
(@NPC, 33447, 6, 1, 0, 1, 1), -- Runic Healing Potion
(@NPC, 33449, 5, 1, 0, 1, 1), -- Crusty Flatbread
(@NPC, 29450, 1, 1, 0, 1, 1); -- Telaari Grapes

-- Add pickpocketing loot for Clandestine Cultist <Cult of the Damned>
SET @NPC =25605;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 29569, 40, 1, 0, 1, 1), -- Strong Junkbox
(@NPC, 29571, 37, 1, 0, 1, 1), -- A Steamy Romance Novel
(@NPC, 30458, 8, 1, 0, 1, 1), -- Stromgarde Muenster
(@NPC, 27855, 7, 1, 0, 1, 1), -- Mag'har Grainbread
(@NPC, 27856, 6, 1, 0, 1, 1), -- Skethyl Berries
(@NPC, 22829, 2, 1, 0, 1, 1); -- Super Healing Potion

-- Add pickpocketing loot for Claximus
SET @NPC =25209;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 43575, 28, 1, 0, 1, 1), -- Reinforced Junkbox
(@NPC, 38273, 26, 1, 0, 1, 1), -- Brain Coral
(@NPC, 38274, 23, 1, 0, 1, 1), -- Large Snail Shell
(@NPC, 37452, 17, 1, 0, 1, 1), -- Fatty Bluefin
(@NPC, 33447, 6, 1, 0, 1, 1); -- Runic Healing Potion

-- Add pickpocketing loot for Coldarra Spellbinder
SET @NPC =25719;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 37467, 35, 1, 0, 1, 1), -- A Steamy Romance Novel: Forbidden Love
(@NPC, 43575, 29, 1, 0, 1, 1), -- Reinforced Junkbox
(@NPC, 38261, 10, 1, 0, 1, 1), -- Bent House Key
(@NPC, 29448, 8, 1, 0, 1, 1), -- Mag'har Mild Cheese
(@NPC, 29450, 8, 1, 0, 1, 1), -- Telaari Grapes
(@NPC, 33447, 7, 1, 0, 1, 1), -- Runic Healing Potion
(@NPC, 33449, 11, 1, 0, 1, 1); -- Crusty Flatbread

-- Add pickpocketing loot for Cultist Necrolyte
SET @NPC =25651;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 29571, 36, 1, 0, 1, 1), -- A Steamy Romance Novel
(@NPC, 29569, 31.5, 1, 0, 1, 1), -- Strong Junkbox
(@NPC, 22829, 9.5, 1, 0, 1, 1), -- Super Healing Potion
(@NPC, 27855, 8.5, 1, 0, 1, 1), -- Mag'har Grainbread
(@NPC, 30458, 6.5, 1, 0, 1, 1), -- Stromgarde Muenster
(@NPC, 27856, 6.5, 1, 0, 1, 1), -- Skethyl Berries
(@NPC, 23439, 0.5, 1, 0, 1, 1), -- Noble Topaz
(@NPC, 23436, 0.5, 1, 0, 1, 1), -- Living Ruby
(@NPC, 23437, 0.5, 1, 0, 1, 1); -- Talasite

-- Add pickpocketing loot for Den Vermin
SET @NPC =24567;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 29572, 32, 1, 0, 1, 1), -- Aboriginal Carvings
(@NPC, 29569, 31, 1, 0, 1, 1), -- Strong Junkbox
(@NPC, 8952, 30, 1, 0, 1, 1), -- Roasted Quail
(@NPC, 22829, 5, 1, 0, 1, 1), -- Super Healing Potion
(@NPC, 23438, 0.5, 1, 0, 1, 1), -- Star of Elune
(@NPC, 23436, 0.5, 1, 0, 1, 1), -- Living Ruby
(@NPC, 23441, 0.5, 1, 0, 1, 1), -- Nightseye
(@NPC, 23437, 0.5, 1, 0, 1, 1); -- Talasite

-- Add pickpocketing loot for En'kilah Necrolord <Cult of the Damned>
SET @NPC =25609;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 29569, 37, 1, 0, 1, 1), -- Strong Junkbox
(@NPC, 29571, 30, 1, 0, 1, 1), -- A Steamy Romance Novel
(@NPC, 27855, 8, 1, 0, 1, 1), -- Mag'har Grainbread
(@NPC, 30458, 8, 1, 0, 1, 1), -- Stromgarde Muenster
(@NPC, 22829, 8, 1, 0, 1, 1), -- Super Healing Potion
(@NPC, 27856, 6, 1, 0, 1, 1), -- Skethyl Berries
(@NPC, 23439, 0.5, 1, 0, 1, 1), -- Noble Topaz
(@NPC, 23437, 1.5, 1, 0, 1, 1); -- Talasite

-- Add pickpocketing loot for En'kilah Necromancer <Cult of the Damned>
SET @NPC =25378;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 37467, 30.5, 1, 0, 1, 1), -- A Steamy Romance Novel: Forbidden Love
(@NPC, 43575, 27, 1, 0, 1, 1), -- Reinforced Junkbox
(@NPC, 38261, 13, 1, 0, 1, 1), -- Bent House Key
(@NPC, 29448, 8, 1, 0, 1, 1), -- Mag'har Mild Cheese
(@NPC, 33447, 8, 1, 0, 1, 1), -- Runic Healing Potion
(@NPC, 33449, 8, 1, 0, 1, 1), -- Crusty Flatbread
(@NPC, 29450, 5, 1, 0, 1, 1), -- Telaari Grapes
(@NPC, 36863, 0.5, 1, 0, 1, 1); -- Decahedral Dwarven Dice

-- Add pickpocketing loot for Gamel the Cruel
SET @NPC =26449;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 29569, 36, 1, 0, 1, 1), -- Strong Junkbox
(@NPC, 29570, 30, 1, 0, 1, 1), -- A Gnome Effigy
(@NPC, 27855, 13, 1, 0, 1, 1), -- Mag'har Grainbread
(@NPC, 27854, 12, 1, 0, 1, 1), -- Smoked Talbuk Venison
(@NPC, 22829, 8, 1, 0, 1, 1), -- Super Healing Potion
(@NPC, 23436, 0.5, 1, 0, 1, 1), -- Living Ruby
(@NPC, 23439, 0.5, 1, 0, 1, 1); -- Noble Topaz

-- Add pickpocketing loot for Gammoth Tender
SET @NPC =25501;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 29572, 41, 1, 0, 1, 1), -- Aboriginal Carvings
(@NPC, 29569, 30, 1, 0, 1, 1), -- Strong Junkbox
(@NPC, 8952, 23, 1, 0, 1, 1), -- Roasted Quail
(@NPC, 22829, 5, 1, 0, 1, 1), -- Super Healing Potion
(@NPC, 23438, 0.5, 1, 0, 1, 1), -- Star of Elune
(@NPC, 23437, 0.5, 1, 0, 1, 1); -- Talasite

-- Add pickpocketing loot for Gammothra the Tormentor
SET @NPC =25789;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 38260, 33, 1, 0, 1, 1), -- Empty Tobacco Pouch
(@NPC, 38261, 21, 1, 0, 1, 1), -- Bent House Key
(@NPC, 33449, 16, 1, 0, 1, 1), -- Crusty Flatbread
(@NPC, 43575, 16, 1, 0, 1, 1), -- Reinforced Junkbox
(@NPC, 33454, 9, 1, 0, 1, 1), -- Salted Venison
(@NPC, 33447, 5, 1, 0, 1, 1); -- Runic Healing Potion

-- Add pickpocketing loot for Gorloc Dredger
SET @NPC =25701;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 29576, 39, 1, 0, 1, 1), -- Shark Bait
(@NPC, 29569, 31, 1, 0, 1, 1), -- Strong Junkbox
(@NPC, 27858, 21, 1, 0, 1, 1), -- Sunspring Carp
(@NPC, 22829, 9, 1, 0, 1, 1); -- Super Healing Potion

-- Add pickpocketing loot for Gorloc Gibberer
SET @NPC =25686;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 29576, 57.5, 1, 0, 1, 1), -- Shark Bait
(@NPC, 29569, 30, 1, 0, 1, 1), -- Strong Junkbox
(@NPC, 27858, 8, 1, 0, 1, 1), -- Sunspring Carp
(@NPC, 22829, 3, 1, 0, 1, 1), -- Super Healing Potion
(@NPC, 23436, 0.5, 1, 0, 1, 1), -- Living Ruby
(@NPC, 23437, 0.5, 1, 0, 1, 1), -- Talasite
(@NPC, 23439, 0.5, 1, 0, 1, 1); -- Noble Topaz

-- Add pickpocketing loot for Gorloc Hunter
SET @NPC =25700;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 29569, 55.5, 1, 0, 1, 1), -- Strong Junkbox
(@NPC, 29576, 37, 1, 0, 1, 1), -- Shark Bait
(@NPC, 27858, 5, 1, 0, 1, 1), -- Sunspring Carp
(@NPC, 22829, 2, 1, 0, 1, 1), -- Super Healing Potion
(@NPC, 23440, 0.5, 1, 0, 1, 1); -- Dawnstone

-- Add pickpocketing loot for Gorloc Mud Splasher
SET @NPC =25699;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 29576, 52, 1, 0, 1, 1), -- Shark Bait
(@NPC, 27858, 33, 1, 0, 1, 1), -- Sunspring Carp
(@NPC, 29569, 13, 1, 0, 1, 1), -- Strong Junkbox
(@NPC, 22829, 2, 1, 0, 1, 1); -- Super Healing Potion

-- Add pickpocketing loot for Gorloc Steam Belcher
SET @NPC =25687;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 29569, 42, 1, 0, 1, 1), -- Strong Junkbox
(@NPC, 29576, 32, 1, 0, 1, 1), -- Shark Bait
(@NPC, 27858, 21, 1, 0, 1, 1), -- Sunspring Carp
(@NPC, 22829, 5, 1, 0, 1, 1), -- Super Healing Potion
(@NPC, 23438, 0.5, 1, 0, 1, 1), -- Star of Elune
(@NPC, 23437, 0.5, 1, 0, 1, 1); -- Talasite

-- Add pickpocketing loot for Gorloc Waddler
SET @NPC =25685;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 27858, 46.5, 1, 0, 1, 1), -- Sunspring Carp
(@NPC, 29569, 36.5, 1, 0, 1, 1), -- Strong Junkbox
(@NPC, 29576, 13, 1, 0, 1, 1), -- Shark Bait
(@NPC, 22829, 4, 1, 0, 1, 1); -- Super Healing Potion

-- Add pickpocketing loot for Harold Lane <The Fur Baron>
SET @NPC =25804;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 37467, 38, 1, 0, 1, 1), -- A Steamy Romance Novel: Forbidden Love
(@NPC, 43575, 19, 1, 0, 1, 1), -- Reinforced Junkbox
(@NPC, 38261, 19, 1, 0, 1, 1), -- Bent House Key
(@NPC, 29450, 6, 1, 0, 1, 1), -- Telaari Grapes
(@NPC, 33449, 6, 1, 0, 1, 1), -- Crusty Flatbread
(@NPC, 33447, 6, 1, 0, 1, 1), -- Runic Healing Potion
(@NPC, 29448, 6, 1, 0, 1, 1); -- Mag'har Mild Cheese

-- Add pickpocketing loot for Heigarr the Horrible
SET @NPC =26266;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 29569, 41, 1, 0, 1, 1), -- Strong Junkbox
(@NPC, 29570, 31, 1, 0, 1, 1), -- A Gnome Effigy
(@NPC, 27855, 12, 1, 0, 1, 1), -- Mag'har Grainbread
(@NPC, 27854, 10, 1, 0, 1, 1), -- Smoked Talbuk Venison
(@NPC, 22829, 6, 1, 0, 1, 1); -- Super Healing Potion

-- Add pickpocketing loot for High Priest Andorath
SET @NPC =25392;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 37467, 33, 1, 0, 1, 1), -- A Steamy Romance Novel: Forbidden Love
(@NPC, 43575, 25, 1, 0, 1, 1), -- Reinforced Junkbox
(@NPC, 38261, 17, 1, 0, 1, 1), -- Bent House Key
(@NPC, 29450, 12, 1, 0, 1, 1), -- Telaari Grapes
(@NPC, 29448, 6, 1, 0, 1, 1), -- Mag'har Mild Cheese
(@NPC, 33447, 4, 1, 0, 1, 1), -- Runic Healing Potion
(@NPC, 33449, 3, 1, 0, 1, 1); -- Crusty Flatbread

-- Add pickpocketing loot for Inquisitor Caleras
SET @NPC =25720;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 37467, 33, 1, 0, 1, 1), -- A Steamy Romance Novel: Forbidden Love
(@NPC, 33449, 29, 1, 0, 1, 1), -- Crusty Flatbread
(@NPC, 43575, 17, 1, 0, 1, 1), -- Reinforced Junkbox
(@NPC, 38261, 10, 1, 0, 1, 1), -- Bent House Key
(@NPC, 29448, 7, 1, 0, 1, 1), -- Mag'har Mild Cheese
(@NPC, 29450, 2, 1, 0, 1, 1), -- Telaari Grapes
(@NPC, 33447, 2, 1, 0, 1, 1); -- Runic Healing Potion

-- Add pickpocketing loot for Kaganishu
SET @NPC =25427;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 33447, 45, 1, 0, 1, 1), -- Runic Healing Potion
(@NPC, 43575, 20, 1, 0, 1, 1), -- Reinforced Junkbox
(@NPC, 33454, 14, 1, 0, 1, 1), -- Salted Venison
(@NPC, 38264, 14, 1, 0, 1, 1), -- A Very Pretty Rock
(@NPC, 38263, 7, 1, 0, 1, 1); -- Too-Small Armband

-- Add pickpocketing loot for Karen "I Don't Caribou" the Culler
SET @NPC =25803;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 43575, 48, 1, 0, 1, 1), -- Reinforced Junkbox
(@NPC, 37467, 25, 1, 0, 1, 1), -- A Steamy Romance Novel: Forbidden Love
(@NPC, 29448, 12, 1, 0, 1, 1), -- Mag'har Mild Cheese
(@NPC, 33447, 8, 1, 0, 1, 1), -- Runic Healing Potion
(@NPC, 38261, 8, 1, 0, 1, 1), -- Bent House Key
(@NPC, 29450, 5, 1, 0, 1, 1), -- Telaari Grapes
(@NPC, 33449, 2, 1, 0, 1, 1); -- Crusty Flatbread

-- Add pickpocketing loot for Keymaster Urmgrgl
SET @NPC =25210;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 43575, 31, 1, 0, 1, 1), -- Reinforced Junkbox
(@NPC, 38273, 24, 1, 0, 1, 1), -- Brain Coral
(@NPC, 37452, 23, 1, 0, 1, 1), -- Fatty Bluefin
(@NPC, 38274, 17, 1, 0, 1, 1), -- Large Snail Shell
(@NPC, 33447, 5, 1, 0, 1, 1); -- Runic Healing Potion

-- Add pickpocketing loot for Kvaldir Mist Lord
SET @NPC =25496;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 29569, 39.5, 1, 0, 1, 1), -- Strong Junkbox
(@NPC, 29570, 28, 1, 0, 1, 1), -- A Gnome Effigy
(@NPC, 27855, 12, 1, 0, 1, 1), -- Mag'har Grainbread
(@NPC, 27854, 12, 1, 0, 1, 1), -- Smoked Talbuk Venison
(@NPC, 22829, 7, 1, 0, 1, 1), -- Super Healing Potion
(@NPC, 23436, 0.5, 1, 0, 1, 1), -- Living Ruby
(@NPC, 23441, 0.5, 1, 0, 1, 1), -- Nightseye
(@NPC, 23440, 0.5, 1, 0, 1, 1); -- Dawnstone

-- Add pickpocketing loot for Kvaldir Mistweaver
SET @NPC =25479;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 29569, 38, 1, 0, 1, 1), -- Strong Junkbox
(@NPC, 29570, 27, 1, 0, 1, 1), -- A Gnome Effigy
(@NPC, 27854, 20, 1, 0, 1, 1), -- Smoked Talbuk Venison
(@NPC, 27855, 8, 1, 0, 1, 1), -- Mag'har Grainbread
(@NPC, 22829, 6, 1, 0, 1, 1), -- Super Healing Potion
(@NPC, 23436, 0.5, 1, 0, 1, 1), -- Living Ruby
(@NPC, 23440, 0.5, 1, 0, 1, 1); -- Dawnstone

-- Add pickpocketing loot for Kvaldir Raider
SET @NPC =25760;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 29570, 34.5, 1, 0, 1, 1), -- A Gnome Effigy
(@NPC, 29569, 32, 1, 0, 1, 1), -- Strong Junkbox
(@NPC, 27854, 11, 1, 0, 1, 1), -- Smoked Talbuk Venison
(@NPC, 27855, 11, 1, 0, 1, 1), -- Mag'har Grainbread
(@NPC, 22829, 11, 1, 0, 1, 1), -- Super Healing Potion
(@NPC, 23437, 0.5, 1, 0, 1, 1); -- Talasite

-- Add pickpocketing loot for Loot Crazed Diver
SET @NPC =25836;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 43575, 29.5, 1, 0, 1, 1), -- Reinforced Junkbox
(@NPC, 37467, 25.5, 1, 0, 1, 1), -- A Steamy Romance Novel: Forbidden Love
(@NPC, 38261, 13, 1, 0, 1, 1), -- Bent House Key
(@NPC, 33449, 10, 1, 0, 1, 1), -- Crusty Flatbread
(@NPC, 29448, 8, 1, 0, 1, 1), -- Mag'har Mild Cheese
(@NPC, 29450, 8, 1, 0, 1, 1), -- Telaari Grapes
(@NPC, 33447, 6, 1, 0, 1, 1); -- Runic Healing Potion

-- Add pickpocketing loot for Loot Crazed Hunter
SET @NPC =25979;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 37467, 38, 1, 0, 1, 1), -- A Steamy Romance Novel: Forbidden Love
(@NPC, 43575, 28, 1, 0, 1, 1), -- Reinforced Junkbox
(@NPC, 38261, 10, 1, 0, 1, 1), -- Bent House Key
(@NPC, 33447, 6, 1, 0, 1, 1), -- Runic Healing Potion
(@NPC, 33449, 6, 1, 0, 1, 1), -- Crusty Flatbread
(@NPC, 29448, 6, 1, 0, 1, 1), -- Mag'har Mild Cheese
(@NPC, 29450, 6, 1, 0, 1, 1); -- Telaari Grapes

-- Add pickpocketing loot for Loot Crazed Poacher
SET @NPC =25806;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 43575, 34, 1, 0, 1, 1), -- Reinforced Junkbox
(@NPC, 37467, 32, 1, 0, 1, 1), -- A Steamy Romance Novel: Forbidden Love
(@NPC, 38261, 15, 1, 0, 1, 1), -- Bent House Key
(@NPC, 29448, 8, 1, 0, 1, 1), -- Mag'har Mild Cheese
(@NPC, 33447, 7, 1, 0, 1, 1), -- Runic Healing Potion
(@NPC, 29450, 6, 1, 0, 1, 1), -- Telaari Grapes
(@NPC, 33449, 6, 1, 0, 1, 1); -- Crusty Flatbread

-- Add pickpocketing loot for Luthion the Vile <The San'layn>
SET @NPC =27860;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 37467, 52, 1, 0, 1, 1), -- A Steamy Romance Novel: Forbidden Love
(@NPC, 43575, 16, 1, 0, 1, 1), -- Reinforced Junkbox
(@NPC, 29448, 13, 1, 0, 1, 1), -- Mag'har Mild Cheese
(@NPC, 33447, 6, 1, 0, 1, 1), -- Runic Healing Potion
(@NPC, 29450, 5, 1, 0, 1, 1), -- Telaari Grapes
(@NPC, 38261, 5, 1, 0, 1, 1), -- Bent House Key
(@NPC, 33449, 3, 1, 0, 1, 1); -- Crusty Flatbread

-- Add pickpocketing loot for Magmoth Crusher
SET @NPC =25434;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 43575, 38, 1, 0, 1, 1), -- Reinforced Junkbox
(@NPC, 38260, 26, 1, 0, 1, 1), -- Empty Tobacco Pouch
(@NPC, 33449, 10, 1, 0, 1, 1), -- Crusty Flatbread
(@NPC, 33454, 10, 1, 0, 1, 1), -- Salted Venison
(@NPC, 38261, 8, 1, 0, 1, 1), -- Bent House Key
(@NPC, 33447, 8, 1, 0, 1, 1), -- Runic Healing Potion
(@NPC, 36862, 1, 1, 0, 1, 1); -- Worn Troll Dice

-- Add pickpocketing loot for Magmoth Forager
SET @NPC =25429;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 43575, 34, 1, 0, 1, 1), -- Reinforced Junkbox
(@NPC, 33454, 29, 1, 0, 1, 1), -- Salted Venison
(@NPC, 38263, 12, 1, 0, 1, 1), -- Too-Small Armband
(@NPC, 33447, 12, 1, 0, 1, 1), -- Runic Healing Potion
(@NPC, 38264, 12, 1, 0, 1, 1), -- A Very Pretty Rock
(@NPC, 38266, 1, 1, 0, 1, 1); -- Rotund Relic

-- Add pickpocketing loot for Magmoth Shaman
SET @NPC =25428;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 43575, 35, 1, 0, 1, 1), -- Reinforced Junkbox
(@NPC, 33454, 25, 1, 0, 1, 1), -- Salted Venison
(@NPC, 38264, 16, 1, 0, 1, 1), -- A Very Pretty Rock
(@NPC, 38263, 16, 1, 0, 1, 1), -- Too-Small Armband
(@NPC, 33447, 7, 1, 0, 1, 1), -- Runic Healing Potion
(@NPC, 38266, 1, 1, 0, 1, 1); -- Rotund Relic

-- Add pickpocketing loot for Magmothregar
SET @NPC =25430;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 43575, 34, 1, 0, 1, 1), -- Reinforced Junkbox
(@NPC, 38260, 25, 1, 0, 1, 1), -- Empty Tobacco Pouch
(@NPC, 38261, 11, 1, 0, 1, 1), -- Bent House Key
(@NPC, 33454, 10, 1, 0, 1, 1), -- Salted Venison
(@NPC, 33449, 9, 1, 0, 1, 1), -- Crusty Flatbread
(@NPC, 33447, 8, 1, 0, 1, 1), -- Runic Healing Potion
(@NPC, 36862, 3, 1, 0, 1, 1); -- Worn Troll Dice

-- Add pickpocketing loot for Magnataur Huntress <Mate of Gammothra>
SET @NPC =24469;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 43575, 31, 1, 0, 1, 1), -- Reinforced Junkbox
(@NPC, 38260, 27, 1, 0, 1, 1), -- Empty Tobacco Pouch
(@NPC, 38261, 13, 1, 0, 1, 1), -- Bent House Key
(@NPC, 33449, 10, 1, 0, 1, 1), -- Crusty Flatbread
(@NPC, 33447, 10, 1, 0, 1, 1), -- Runic Healing Potion
(@NPC, 33454, 9, 1, 0, 1, 1); -- Salted Venison

-- Add pickpocketing loot for Mate of Magmothregar
SET @NPC =2543;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 38260, 33, 1, 0, 1, 1), -- Empty Tobacco Pouch
(@NPC, 33449, 23, 1, 0, 1, 1), -- Crusty Flatbread
(@NPC, 43575, 23, 1, 0, 1, 1), -- Reinforced Junkbox
(@NPC, 38261, 8, 1, 0, 1, 1), -- Bent House Key
(@NPC, 33454, 8, 1, 0, 1, 1), -- Salted Venison
(@NPC, 33447, 5, 1, 0, 1, 1); -- Runic Healing Potion

-- Add pickpocketing loot for Minion of Kaw
SET @NPC =25880;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 37467, 33, 1, 0, 1, 1), -- A Steamy Romance Novel: Forbidden Love
(@NPC, 38261, 26, 1, 0, 1, 1), -- Bent House Key
(@NPC, 29448, 14, 1, 0, 1, 1), -- Mag'har Mild Cheese
(@NPC, 43575, 14, 1, 0, 1, 1), -- Reinforced Junkbox
(@NPC, 33449, 5, 1, 0, 1, 1), -- Crusty Flatbread
(@NPC, 33447, 4, 1, 0, 1, 1), -- Runic Healing Potion
(@NPC, 29450, 4, 1, 0, 1, 1); -- Telaari Grapes

-- Add pickpocketing loot for Nedar, Lord of Rhinos
SET @NPC =25801;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 43575, 34, 1, 0, 1, 1), -- Reinforced Junkbox
(@NPC, 29450, 29, 1, 0, 1, 1), -- Telaari Grapes
(@NPC, 37467, 16, 1, 0, 1, 1), -- A Steamy Romance Novel: Forbidden Love
(@NPC, 29448, 11, 1, 0, 1, 1), -- Mag'har Mild Cheese
(@NPC, 33447, 5, 1, 0, 1, 1), -- Runic Healing Potion
(@NPC, 38261, 5, 1, 0, 1, 1); -- Bent House Key

-- Add pickpocketing loot for Northsea Mercenary
SET @NPC =25839;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 43575, 30, 1, 0, 1, 1), -- Reinforced Junkbox
(@NPC, 37467, 22, 1, 0, 1, 1), -- A Steamy Romance Novel: Forbidden Love
(@NPC, 33447, 13, 1, 0, 1, 1), -- Runic Healing Potion
(@NPC, 38261, 12, 1, 0, 1, 1), -- Bent House Key
(@NPC, 33449, 8, 1, 0, 1, 1), -- Crusty Flatbread
(@NPC, 29450, 8, 1, 0, 1, 1), -- Telaari Grapes
(@NPC, 29448, 7, 1, 0, 1, 1); -- Mag'har Mild Cheese

-- Add pickpocketing loot for Northsea Thug
SET @NPC =25843;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 29569, 32.25, 1, 0, 1, 1), -- Strong Junkbox
(@NPC, 29571, 32.25, 1, 0, 1, 1), -- A Steamy Romance Novel
(@NPC, 27855, 10, 1, 0, 1, 1), -- Mag'har Grainbread
(@NPC, 27856, 9, 1, 0, 1, 1), -- Skethyl Berries
(@NPC, 22829, 9, 1, 0, 1, 1), -- Super Healing Potion
(@NPC, 30458, 7, 1, 0, 1, 1), -- Stromgarde Muenster
(@NPC, 23437, 0.5, 1, 0, 1, 1); -- Talasite

-- Add pickpocketing loot for Offspring of Magmothregar
SET @NPC =25433;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 43575, 36.5, 1, 0, 1, 1), -- Reinforced Junkbox
(@NPC, 38260, 26, 1, 0, 1, 1), -- Empty Tobacco Pouch
(@NPC, 33454, 11, 1, 0, 1, 1), -- Salted Venison
(@NPC, 33449, 10, 1, 0, 1, 1), -- Crusty Flatbread
(@NPC, 38261, 8, 1, 0, 1, 1), -- Bent House Key
(@NPC, 33447, 8, 1, 0, 1, 1), -- Runic Healing Potion
(@NPC, 36862, 0.5, 1, 0, 1, 1); -- Worn Troll Dice

-- Add pickpocketing loot for Plagued Magnataur
SET @NPC =25615;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 43575, 30, 1, 0, 1, 1), -- Reinforced Junkbox
(@NPC, 38260, 24, 1, 0, 1, 1), -- Empty Tobacco Pouch
(@NPC, 33449, 13, 1, 0, 1, 1), -- Crusty Flatbread
(@NPC, 33454, 10.5, 1, 0, 1, 1), -- Salted Venison
(@NPC, 33447, 10, 1, 0, 1, 1), -- Runic Healing Potion
(@NPC, 38261, 10, 1, 0, 1, 1), -- Bent House Key
(@NPC, 29569, 2, 1, 0, 1, 1), -- Strong Junkbox
(@NPC, 36862, 0.5, 1, 0, 1, 1); -- Worn Troll Dice

-- Add pickpocketing loot for Prince Valanar <The San'layn>
SET @NPC =25601;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 43575, 34, 1, 0, 1, 1), -- Reinforced Junkbox
(@NPC, 37467, 27, 1, 0, 1, 1), -- A Steamy Romance Novel: Forbidden Love
(@NPC, 38261, 27, 1, 0, 1, 1), -- Bent House Key
(@NPC, 33449, 4, 1, 0, 1, 1), -- Crusty Flatbread
(@NPC, 33447, 4, 1, 0, 1, 1), -- Runic Healing Potion
(@NPC, 29450, 4, 1, 0, 1, 1); -- Telaari Grapes

-- Add pickpocketing loot for Ragnar Drakkarlund
SET @NPC =26451;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 29569, 32, 1, 0, 1, 1), -- Strong Junkbox
(@NPC, 29570, 32, 1, 0, 1, 1), -- A Gnome Effigy
(@NPC, 27855, 14, 1, 0, 1, 1), -- Mag'har Grainbread
(@NPC, 27854, 11, 1, 0, 1, 1), -- Smoked Talbuk Venison
(@NPC, 22829, 11, 1, 0, 1, 1), -- Super Healing Potion
(@NPC, 35774, -100, 1, 0, 1, 1); -- Trident of Naz'jan

-- Add pickpocketing loot for Riplash Myrmidon
SET @NPC =24576;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 29569, 42, 1, 0, 1, 1), -- Strong Junkbox
(@NPC, 27858, 35, 1, 0, 1, 1), -- Sunspring Carp
(@NPC, 29576, 20, 1, 0, 1, 1), -- Shark Bait
(@NPC, 23440, 3, 1, 0, 1, 1); -- Dawnstone

-- Add pickpocketing loot for Skadir Longboatsman
SET @NPC =25521;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 29569, 35, 1, 0, 1, 1), -- Strong Junkbox
(@NPC, 29570, 33, 1, 0, 1, 1), -- A Gnome Effigy
(@NPC, 27855, 13, 1, 0, 1, 1), -- Mag'har Grainbread
(@NPC, 27854, 12, 1, 0, 1, 1), -- Smoked Talbuk Venison
(@NPC, 22829, 7, 1, 0, 1, 1); -- Super Healing Potion

-- Add pickpocketing loot for Skadir Mariner
SET @NPC =25523;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 43575, 29, 1, 0, 1, 1), -- Reinforced Junkbox
(@NPC, 38260, 26, 1, 0, 1, 1), -- Empty Tobacco Pouch
(@NPC, 33454, 13, 1, 0, 1, 1), -- Salted Venison
(@NPC, 33449, 7, 1, 0, 1, 1), -- Crusty Flatbread
(@NPC, 33447, 7, 1, 0, 1, 1), -- Runic Healing Potion
(@NPC, 29569, 7, 1, 0, 1, 1), -- Strong Junkbox
(@NPC, 38261, 7, 1, 0, 1, 1), -- Bent House Key
(@NPC, 22829, 4, 1, 0, 1, 1); -- Super Healing Potion

-- Add pickpocketing loot for Skadir Mistweaver
SET @NPC =25613;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 29570, 39, 1, 0, 1, 1), -- A Gnome Effigy
(@NPC, 29569, 33, 1, 0, 1, 1), -- Strong Junkbox
(@NPC, 27855, 10, 1, 0, 1, 1), -- Mag'har Grainbread
(@NPC, 27854, 10, 1, 0, 1, 1), -- Smoked Talbuk Venison
(@NPC, 22829, 6, 1, 0, 1, 1), -- Super Healing Potion
(@NPC, 23441, 0.5, 1, 0, 1, 1), -- Nightseye
(@NPC, 23439, 0.5, 1, 0, 1, 1); -- Noble Topaz

-- Add pickpocketing loot for Skadir Raider
SET @NPC =25522;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 29569, 34.5, 1, 0, 1, 1), -- Strong Junkbox
(@NPC, 29570, 32, 1, 0, 1, 1), -- A Gnome Effigy
(@NPC, 27854, 13, 1, 0, 1, 1), -- Smoked Talbuk Venison
(@NPC, 27855, 11, 1, 0, 1, 1), -- Mag'har Grainbread
(@NPC, 22829, 9, 1, 0, 1, 1), -- Super Healing Potion
(@NPC, 23437, 0.5, 1, 0, 1, 1); -- Talasite

-- Add pickpocketing loot for Skadir Runecaster
SET @NPC =25520;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 29569, 49.5, 1, 0, 1, 1), -- Strong Junkbox
(@NPC, 29570, 25, 1, 0, 1, 1), -- A Gnome Effigy
(@NPC, 27854, 10, 1, 0, 1, 1), -- Smoked Talbuk Venison
(@NPC, 27855, 10, 1, 0, 1, 1), -- Mag'har Grainbread
(@NPC, 22829, 5, 1, 0, 1, 1), -- Super Healing Potion
(@NPC, 23437, 0.5, 1, 0, 1, 1); -- Talasite

-- Add pickpocketing loot for Vanthryn the Merciless <The San'layn>
SET @NPC =27859;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 37467, 56, 1, 0, 1, 1), -- A Steamy Romance Novel: Forbidden Love
(@NPC, 43575, 17, 1, 0, 1, 1), -- Reinforced Junkbox
(@NPC, 33447, 13, 1, 0, 1, 1), -- Runic Healing Potion
(@NPC, 38261, 5, 1, 0, 1, 1), -- Bent House Key
(@NPC, 33449, 4, 1, 0, 1, 1), -- Crusty Flatbread
(@NPC, 29450, 3, 1, 0, 1, 1), -- Telaari Grapes
(@NPC, 29448, 2, 1, 0, 1, 1); -- Mag'har Mild Cheese

-- Add pickpocketing loot for Varidus the Flenser <Cult of the Damned>
SET @NPC =25618;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 37467, 50, 1, 0, 1, 1), -- A Steamy Romance Novel: Forbidden Love
(@NPC, 43575, 25, 1, 0, 1, 1), -- Reinforced Junkbox
(@NPC, 33447, 12.5, 1, 0, 1, 1), -- Runic Healing Potion
(@NPC, 38261, 12.5, 1, 0, 1, 1); -- Bent House Key

-- Add pickpocketing loot for Winterfin Oracle
SET @NPC =25216;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 43575, 25, 1, 0, 1, 1), -- Reinforced Junkbox
(@NPC, 38274, 25, 1, 0, 1, 1), -- Large Snail Shell
(@NPC, 38273, 20, 1, 0, 1, 1), -- Brain Coral
(@NPC, 37452, 20, 1, 0, 1, 1), -- Fatty Bluefin
(@NPC, 33447, 10, 1, 0, 1, 1); -- Runic Healing Potion

-- Add pickpocketing loot for Winterfin Shorestriker
SET @NPC =25215;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 38274, 30, 1, 0, 1, 1), -- Large Snail Shell
(@NPC, 38273, 25, 1, 0, 1, 1), -- Brain Coral
(@NPC, 43575, 20, 1, 0, 1, 1), -- Reinforced Junkbox
(@NPC, 37452, 15, 1, 0, 1, 1), -- Fatty Bluefin
(@NPC, 33447, 10, 1, 0, 1, 1); -- Runic Healing Potion

-- Add pickpocketing loot for Winterfin Warrior
SET @NPC =25217;
UPDATE `creature_template` SET `pickpocketloot`=@NPC WHERE `entry`=@NPC;
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=@NPC;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@NPC, 38273, 27, 1, 0, 1, 1), -- Brain Coral
(@NPC, 43575, 25, 1, 0, 1, 1), -- Reinforced Junkbox
(@NPC, 38274, 23, 1, 0, 1, 1), -- Large Snail Shell
(@NPC, 37452, 19, 1, 0, 1, 1), -- Fatty Bluefin
(@NPC, 33447, 6, 1, 0, 1, 1); -- Runic Healing Potion