[Accepted][Battle for Azeroth]: Raiding with Leashes VI: Pets of Pandaria

[Florix]

Title: Raiding with Leashes VI: Pets of Pandaria
Bugtracker Link:

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

Patch Content:

 

Loot fix for the following items:
https://www.wowhead.com/item=167058
https://www.wowhead.com/item=167056
https://www.wowhead.com/item=167055
https://www.wowhead.com/item=167054
https://www.wowhead.com/item=167053
https://www.wowhead.com/item=167052
https://www.wowhead.com/item=167051
https://www.wowhead.com/item=167050
https://www.wowhead.com/item=167049
https://www.wowhead.com/item=167048
https://www.wowhead.com/item=167047

All those items/pets are required for https://www.wowhead.com/achievement=13469/raiding-with-leashes-vi-pets-of-pandaria which will reward https://www.wowhead.com/item=167057/happiness

 

DELETE FROM `creature_loot_template` WHERE `item` IN ('167058','167056','167055','167054','167053','167052','167050','167048','167047');
insert into `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) values 
('62980','167058','0','2.68','0','1','0','1','1','Pet - Kor\'thik Swarmling'),
('62837','167056','0','3.43','0','1','0','1','1','Pet - Essence of Pride'),
('62511','167055','0','4.56','0','1','0','1','1','Pet - Amber Goo Puddle'),
('63191','167054','0','3','0','1','0','1','1','Pet - Spawn of Garalon'),
('62164','167054','0','3','0','1','0','1','1','Pet - Spawn of Garalon'),
('62543','167053','0','2.99','0','1','0','1','1','Pet - Tiny Amber Wings'),
('62983','167052','0','3','0','1','0','1','1','Pet - Spirit of the Spring'),
('60399','167050','0','2','0','1','0','1','1','Pet - Mogu Statue'),
('60400','167050','0','3','0','1','0','1','1','Pet - Mogu Statue'),
('60143','167048','0','1.98','0','1','0','1','1','Pet - Wayward Spirit'),
('60051','167047','0','2','0','1','0','1','1','Pet - Stoneclaw'),
('60043','167047','0','1.2','0','1','0','1','1','Pet - Stoneclaw'),
('60047','167047','0','3','0','1','0','1','1','Pet - Stoneclaw'),
('59915','167047','0','3','0','1','0','1','1','Pet - Stoneclaw');

DELETE FROM `gameobject_loot_template` WHERE `item` IN ('167051','167049');
insert into `gameobject_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) values 
('215358','167051','0','6','0','1','0','1','1','Pet - Azure Cloud Serpent Egg'),
('215357','167051','0','4','0','1','0','1','1','Pet - Azure Cloud Serpent Egg'),
('215356','167051','0','3','0','1','0','1','1','Pet - Azure Cloud Serpent Egg'),
('212922','167051','0','1.6','0','1','0','1','1','Pet - Azure Cloud Serpent Egg'),
('215355','167051','0','1.1','0','1','0','1','1','Pet - Azure Cloud Serpent Egg'),
('214387','167049','0','6','0','1','0','1','1','Pet - Celestial Gift'),
('214386','167049','0','3','0','1','0','1','1','Pet - Celestial Gift'),
('214385','167049','0','2','0','1','0','1','1','Pet - Celestial Gift'),
('214384','167049','0','1.3','0','1','0','1','1','Pet - Celestial Gift'),
('214383','167049','0','0.6','0','1','0','1','1','Pet - Celestial Gift');
-- Custom achivement reward 
DELETE FROM `achievement_reward` WHERE `ID`='13469';
INSERT INTO `achievement_reward` (`ID`,`ItemId`,`Sender`,`Subject`,`Body`) values
('13469','167057','32216','Pets of Pandaria','Congratulation!');

 

 

Edited February 8, 2021 by Florix

[Thyvene]

Hello @Florix,

Your patch is accepted, thank you for contributing to Firestorm.

Regards, Thyvene.