BoreanTundra Pickpocket loot 2.0

-- Fix to add pickpocketing loot for humoniods in borean tundra
-- Gorloc ref loot template
SET @GORLOCREF = 25100;
DELETE FROM `reference_loot_template` WHERE `entry`=@GORLOCREF;
INSERT INTO `reference_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@GORLOCREF, 29576, 57, 1, 0, 1, 1), -- Shark Bait
(@GORLOCREF, 29569, 30, 1, 0, 1, 1), -- Strong Junkbox
(@GORLOCREF, 27858, 8, 1, 0, 1, 1), -- Sunspring Carp
(@GORLOCREF, 22829, 3, 1, 0, 1, 1), -- Super Healing Potion
(@GORLOCREF, 23436, 0.5, 1, 0, 1, 1), -- Living Ruby
(@GORLOCREF, 23437, 0.5, 1, 0, 1, 1), -- Talasite
(@GORLOCREF, 23440, 0.5, 1, 0, 1, 1), -- Dawnstone
(@GORLOCREF, 23438, 0.5, 1, 0, 1, 1), -- Star of Elune
(@GORLOCREF, 23439, 0.5, 1, 0, 1, 1); -- Noble Topaz
-- 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, 1, 100, 1, 0, -@GORLOCREF, 1); -- Gorloc ref loot template
-- 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, 1, 100, 1, 0, -@GORLOCREF, 1); -- Gorloc ref loot template
-- 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, 1, 100, 1, 0, -@GORLOCREF, 1); -- Gorloc ref loot template
-- 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, 1, 100, 1, 0, -@GORLOCREF, 1); -- Gorloc ref loot template
-- Beryl ref loot template
SET @BERYLREF = 25200;
DELETE FROM `reference_loot_template` WHERE `entry`=@BERYLREF;
INSERT INTO `reference_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@BERYLREF, 37467, 32.5, 1, 0, 1, 1), -- A Steamy Romance Novel: Forbidden Love
(@BERYLREF, 43575, 31, 1, 0, 1, 1), -- Reinforced Junkbox
(@BERYLREF, 38261, 10, 1, 0, 1, 1), -- Bent House Key
(@BERYLREF, 29448, 7, 1, 0, 1, 1), -- Mag'har Mild Cheese
(@BERYLREF, 29450, 7, 1, 0, 1, 1), -- Telaari Grapes
(@BERYLREF, 33447, 6, 1, 0, 1, 1), -- Runic Healing Potion
(@BERYLREF, 33449, 6, 1, 0, 1, 1), -- Crusty Flatbread
(@BERYLREF, 36863, 0.5, 1, 0, 1, 1); -- Decahedral Dwarven Dice
-- 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, 1, 100, 1, 0, -@BERYLREF, 1); -- Beryl ref loot template
-- 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, 1, 100, 1, 0, -@BERYLREF, 1); -- Beryl ref loot template
-- 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, 1, 100, 1, 0, -@BERYLREF, 1); -- Beryl ref loot template
-- 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, 1, 100, 1, 0, -@BERYLREF, 1); -- Beryl ref loot template
-- 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, 1, 100, 1, 0, -@BERYLREF, 1); -- Beryl ref loot template
-- 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, 1, 100, 1, 0, -@BERYLREF, 1); -- Beryl ref loot template
-- 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, 1, 100, 1, 0, -@BERYLREF, 1); -- Beryl ref loot template
-- 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, 1, 100, 1, 0, -@BERYLREF, 1); -- Beryl ref loot template
-- 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, 1, 100, 1, 0, -@BERYLREF, 1); -- Beryl ref loot template
-- 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, 1, 100, 1, 0, -@BERYLREF, 1); -- Beryl ref loot template
-- 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, 1, 100, 1, 0, -@BERYLREF, 1); -- Beryl ref loot template
-- 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, 1, 100, 1, 0, -@BERYLREF, 1); -- Beryl ref loot template
-- 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, 1, 100, 1, 0, -@BERYLREF, 1); -- Beryl ref loot template
-- 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, 1, 100, 1, 0, -@BERYLREF, 1); -- Beryl ref loot template
-- 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, 1, 100, 1, 0, -@BERYLREF, 1); -- Beryl ref loot template
-- 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, 1, 100, 1, 0, -@BERYLREF, 1); -- Beryl ref loot template
-- 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, 1, 100, 1, 0, -@BERYLREF, 1); -- Beryl ref loot template
-- 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, 1, 100, 1, 0, -@BERYLREF, 1); -- Beryl ref loot template
-- 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, 1, 100, 1, 0, -@BERYLREF, 1); -- Beryl ref loot template
-- 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, 1, 100, 1, 0, -@BERYLREF, 1); -- Beryl ref loot template

-- Bloodspore ref loot template
SET @BLOODREF = 25300;
DELETE FROM `reference_loot_template` WHERE `entry`=@BLOODREF;
INSERT INTO `reference_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@BLOODREF, 29572, 37, 1, 0, 1, 1), -- Aboriginal Carvings
(@BLOODREF, 29569, 33, 1, 0, 1, 1), -- Strong Junkbox
(@BLOODREF, 8952, 20, 1, 0, 1, 1), -- Roasted Quail
(@BLOODREF, 22829, 8, 1, 0, 1, 1), -- Super Healing Potion
(@BLOODREF, 23438, 0.5, 1, 0, 1, 1), -- Star of Elune
(@BLOODREF, 23436, 0.5, 1, 0, 1, 1), -- Living Ruby
(@BLOODREF, 23441, 0.5, 1, 0, 1, 1), -- Nightseye
(@BLOODREF, 23437, 0.5, 1, 0, 1, 1), -- Talasite
(@BLOODREF, 23440, 0.5, 1, 0, 1, 1); -- Dawnstone
-- 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, 1, 100, 1, 0, -@BLOODREF, 1); -- Bloodspore ref loot template
-- 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, 1, 100, 1, 0, -@BLOODREF, 1); -- Bloodspore ref loot template
-- 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, 1, 100, 1, 0, -@BLOODREF, 1); -- Bloodspore ref loot template
-- 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, 1, 100, 1, 0, -@BLOODREF, 1); -- Bloodspore ref loot template
-- 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, 1, 100, 1, 0, -@BLOODREF, 1); -- Bloodspore ref loot template

-- Chieftian ref loot template
SET @CHEIFREF =25400;
DELETE FROM `reference_loot_template` WHERE `entry`=@CHEIFREF;
INSERT INTO `reference_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@CHEIFREF, 29569, 50, 1, 0, 1, 1), -- Strong Junkbox
(@CHEIFREF, 27858, 20, 1, 0, 1, 1), -- Sunspring Carp
(@CHEIFREF, 29576, 20, 1, 0, 1, 1), -- Shark Bait
(@CHEIFREF, 22829, 10, 1, 0, 1, 1); -- Super Healing Potion
-- 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, 1, 100, 1, 0, -@CHEIFREF, 1); -- Chieftian ref loot template
-- 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, 1, 100, 1, 0, -@CHEIFREF, 1); -- Chieftian ref loot template
-- 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, 1, 100, 1, 0, -@CHEIFREF, 1); -- Chieftian ref loot template
-- 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, 1, 100, 1, 0, -@CHEIFREF, 1); -- Chieftian ref loot template
-- 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, 1, 100, 1, 0, -@CHEIFREF, 1); -- Chieftian ref loot template

-- Cultist ref loot template
SET @CULTREF = 25500;
DELETE FROM `reference_loot_template` WHERE `entry`=@CULTREF;
INSERT INTO `reference_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@CULTREF, 29569, 40, 1, 0, 1, 1), -- Strong Junkbox
(@CULTREF, 29571, 37, 1, 0, 1, 1), -- A Steamy Romance Novel
(@CULTREF, 30458, 8, 1, 0, 1, 1), -- Stromgarde Muenster
(@CULTREF, 27855, 7, 1, 0, 1, 1), -- Mag'har Grainbread
(@CULTREF, 27856, 6, 1, 0, 1, 1), -- Skethyl Berries
(@CULTREF, 22829, 2, 1, 0, 1, 1), -- Super Healing Potion
(@CULTREF, 36863, 0.5, 1, 0, 1, 1); -- Decahedral Dwarven Dice
-- 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, 1, 100, 1, 0, -@CULTREF, 1); -- Cultist ref loot template
-- 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, 1, 100, 1, 0, -@CULTREF, 1); -- Cultist ref loot template
-- 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, 1, 100, 1, 0, -@CULTREF, 1); -- Cultist ref loot template
-- 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, 1, 100, 1, 0, -@CULTREF, 1); -- Cultist ref loot template

-- Magmoth ref loot template
SET @MAGMOTHREF = 25600;
DELETE FROM `reference_loot_template` WHERE `entry`=@MAGMOTHREF;
INSERT INTO `reference_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@MAGMOTHREF, 43575, 34, 1, 0, 1, 1), -- Reinforced Junkbox
(@MAGMOTHREF, 33454, 29, 1, 0, 1, 1), -- Salted Venison
(@MAGMOTHREF, 38263, 12, 1, 0, 1, 1), -- Too-Small Armband
(@MAGMOTHREF, 33447, 12, 1, 0, 1, 1), -- Runic Healing Potion
(@MAGMOTHREF, 38264, 12, 1, 0, 1, 1), -- A Very Pretty Rock
(@MAGMOTHREF, 38266, 1, 1, 0, 1, 1); -- Rotund Relic
-- 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, 1, 100, 1, 0, -@MAGMOTHREF, 1); -- Magmoth ref loot template
-- 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, 1, 100, 1, 0, -@MAGMOTHREF, 1); -- Magmoth ref loot template
-- 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, 1, 100, 1, 0, -@MAGMOTHREF, 1); -- Magmoth ref loot template

-- Kvaldir ref loot template
SET @KVALDIRREF = 25700;
DELETE FROM `reference_loot_template` WHERE `entry`=@KVALDIRREF;
INSERT INTO `reference_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@KVALDIRREF, 29569, 39, 1, 0, 1, 1), -- Strong Junkbox
(@KVALDIRREF, 29570, 28, 1, 0, 1, 1), -- A Gnome Effigy
(@KVALDIRREF, 27855, 12, 1, 0, 1, 1), -- Mag'har Grainbread
(@KVALDIRREF, 27854, 12, 1, 0, 1, 1), -- Smoked Talbuk Venison
(@KVALDIRREF, 22829, 7, 1, 0, 1, 1), -- Super Healing Potion
(@KVALDIRREF, 23436, 0.5, 1, 0, 1, 1), -- Living Ruby
(@KVALDIRREF, 23441, 0.5, 1, 0, 1, 1), -- Nightseye
(@KVALDIRREF, 23440, 0.5, 1, 0, 1, 1), -- Dawnstone
(@KVALDIRREF, 23439, 0.5, 1, 0, 1, 1), -- Noble Topaz
(@KVALDIRREF, 23437, 0.5, 1, 0, 1, 1); -- Talasite
-- 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, 1, 100, 1, 0, -@KVALDIRREF, 1); -- Kvaldir ref loot template
-- 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, 1, 100, 1, 0, -@KVALDIRREF, 1); -- Kvaldir ref loot template
-- 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, 1, 100, 1, 0, -@KVALDIRREF, 1); -- Kvaldir ref loot template
-- 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, 1, 100, 1, 0, -@KVALDIRREF, 1); -- Kvaldir ref loot template
-- 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, 1, 100, 1, 0, -@KVALDIRREF, 1), -- Kvaldir ref loot template
(@NPC, 35774, -100, 1, 0, 1, 1); -- Trident of Naz'jan
-- 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, 1, 100, 1, 0, -@KVALDIRREF, 1); -- Kvaldir ref loot template
-- 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, 1, 100, 1, 0, -@KVALDIRREF, 1); -- Kvaldir ref loot template
-- 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, 1, 100, 1, 0, -@KVALDIRREF, 1); -- Kvaldir ref loot template
-- 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, 1, 100, 1, 0, -@KVALDIRREF, 1); -- Kvaldir ref loot template

-- Claximus ref loot template
SET @CLAXREF = 25800;
DELETE FROM `reference_loot_template` WHERE `entry`=@CLAXREF;
INSERT INTO `reference_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@CLAXREF, 43575, 28, 1, 0, 1, 1), -- Reinforced Junkbox
(@CLAXREF, 38273, 26, 1, 0, 1, 1), -- Brain Coral
(@CLAXREF, 38274, 23, 1, 0, 1, 1), -- Large Snail Shell
(@CLAXREF, 37452, 17, 1, 0, 1, 1), -- Fatty Bluefin
(@CLAXREF, 33447, 6, 1, 0, 1, 1); -- Runic 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, 1, 100, 1, 0, -@CLAXREF, 1); -- Clax ref loot template
-- 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, 1, 100, 1, 0, -@CLAXREF, 1); -- Clax ref loot template
-- 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, 1, 100, 1, 0, -@CLAXREF, 1); -- Clax ref loot template
-- 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, 1, 100, 1, 0, -@CLAXREF, 1); -- Clax ref loot template
-- 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, 1, 100, 1, 0, -@CLAXREF, 1); -- Clax ref loot template

SET @MAGMOTH2REF = 25900;
DELETE FROM `reference_loot_template` WHERE `entry`=@MAGMOTH2REF;
INSERT INTO `reference_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(@MAGMOTH2REF, 38260, 33, 1, 0, 1, 1), -- Empty Tobacco Pouch
(@MAGMOTH2REF, 38261, 21, 1, 0, 1, 1), -- Bent House Key
(@MAGMOTH2REF, 33449, 16, 1, 0, 1, 1), -- Crusty Flatbread
(@MAGMOTH2REF, 43575, 16, 1, 0, 1, 1), -- Reinforced Junkbox
(@MAGMOTH2REF, 33454, 9, 1, 0, 1, 1), -- Salted Venison
(@MAGMOTH2REF, 33447, 5, 1, 0, 1, 1), -- Runic Healing Potion
(@MAGMOTH2REF, 36862, 1, 1, 0, 1, 1); -- Worn Troll Dice
-- 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, 1, 100, 1, 0, -@MAGMOTH2REF, 1); -- Magmoth2 ref loot template
-- 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, 1, 100, 1, 0, -@MAGMOTH2REF, 1); -- Magmoth2 ref loot template
-- 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, 1, 100, 1, 0, -@MAGMOTH2REF, 1); -- Magmoth2 ref loot template
-- 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, 1, 100, 1, 0, -@MAGMOTH2REF, 1); -- Magmoth2 ref loot template
-- 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, 1, 100, 1, 0, -@MAGMOTH2REF, 1); -- Magmoth2 ref loot template
-- 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, 1, 100, 1, 0, -@MAGMOTH2REF, 1); -- Magmoth2 ref loot template
-- 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, 1, 100, 1, 0, -@MAGMOTH2REF, 1); -- Magmoth2 ref loot template
-- 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, 1, 100, 1, 0, -@MAGMOTH2REF, 1); -- Magmoth2 ref loot template