[Accepted][Legion]: Wanted Poster

[Florix]

Title: Wanted Poster
Bugtracker Link:

https://firestorm-servers.com/en/report/see_report/63538

Patch Content:

Adding 3 Quests to Draenor Content + loot

DELETE FROM `gameobject_queststarter` WHERE `id`='233099' AND `quest` IN ('35669','35670','35672');
INSERT INTO `gameobject_queststarter` (`id`,`quest`) VALUES ('233099','35669'), ('233099','35670'), ('233099','35672');
DELETE FROM `creature_questender` WHERE `id`='82622' AND `quest`='35670';
INSERT INTO `creature_questender` (`id`,`quest`) VALUES ('82622','35670');
DELETE FROM `creature_questender` WHERE `id`='82612' AND `quest`='35672';
INSERT INTO `creature_questender` (`id`,`quest`) VALUES ('82612','35672');
DELETE FROM `creature_questender` WHERE `id`='81920' AND `quest`='35669';
INSERT INTO `creature_questender` (`id`,`quest`) VALUES ('81920','35669');

-- Loot for Monsters (cuz might have no loot... not even the quest item)
-- Spineslicer 82632
UPDATE `creature_template` SET `lootid`=82632,`skinloot`=82632 WHERE `entry`=82632;
REPLACE INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(82632, 106593, 0.23, 1, 0, 1, 1), 
(82632, 106605, 0.01, 1, 0, 1, 1), 
(82632, 106623, 0.01, 1, 0, 1, 1), 
(82632, 106647, 0.01, 1, 0, 1, 1), 
(82632, 106651, 0.01, 1, 0, 1, 1), 
(82632, 106657, 0.01, 1, 0, 1, 1), 
(82632, 106825, 6, 1, 0, 1, 1), 
(82632, 106867, 72, 1, 0, 1, 1), 
(82632, 106869, 5, 1, 0, 1, 1), 
(82632, 113293, -100, 1, 0, 1, 1), 
(82632, 116592, 0.01, 1, 0, 1, 1), 
(82632, 116604, 0.02, 1, 0, 1, 1), 
(82632, 116714, 0.01, 1, 0, 1, 1), 
(82632, 116718, 0.01, 1, 0, 1, 1), 
(82632, 116920, 0.02, 1, 0, 1, 1), 
(82632, 118340, 0.02, 1, 0, 1, 1), 
(82632, 118341, 0.03, 1, 0, 1, 1);
REPLACE INTO `skinning_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(82632, 110609, 84, 1, 0, 1, 10), 
(82632, 110610, 16, 1, 0, 1, 3); 
-- Venombarb 82646
UPDATE `creature_template` SET `lootid`=82646,`skinloot`=82646 WHERE `entry`=82646;
REPLACE INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(82646, 106605, 0.01, 1, 0, 1, 1), 
(82646, 106616, 0.15, 1, 0, 1, 1), 
(82646, 106648, 0.01, 1, 0, 1, 1), 
(82646, 106825, 4, 1, 0, 1, 1), 
(82646, 106869, 7, 1, 0, 1, 1), 
(82646, 107528, 88, 1, 0, 1, 1), 
(82646, 109133, 50, 1, 0, 1, 1), 
(82646, 111557, 50, 1, 0, 1, 3), 
(82646, 116568, 0.01, 1, 0, 1, 1), 
(82646, 116578, 0.04, 1, 0, 1, 1), 
(82646, 116579, 0.01, 1, 0, 1, 1), 
(82646, 116589, 0.03, 1, 0, 1, 1), 
(82646, 116920, 0.04, 1, 0, 1, 1);
REPLACE INTO `skinning_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(82646, 110609, 81, 1, 0, 1, 2),
(82646, 110610, 19, 1, 0, 1, 3);
-- Keeho the Severed 82631
REPLACE INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(82631, 113292, -94, 1, 0, 1, 1);

 

[Elliot]

Thanks for the submit!