[Legion]: Rats!

[zachrunner3241]

Title: Rats!
Bugtracker Link:

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

Patch Content:

 

First making the NPC attackable and acts like normal rats (won't try to attack you if you agro him):

 

UPDATE creature_template
SET `faction` = 31, `speed_run`=0.857143, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags2`=2048, `type`=8, `movementId`=100
WHERE  `entry`= 99895;

Adding the quest item loot:

DELETE FROM `creature_loot_template`
WHERE `Entry` ='99895';
INSERT INTO `creature_loot_template` (`Entry`,`Item`,`Reference`,`Chance`,`QuestRequired`,`LootMode`,`GroupId`,`MinCount`,`MaxCount`,`Comment`)
VALUES (99895,130078,0,40,1,1,0,1,1,'Rats! Loot');

 

 

Edited August 17, 2017 by zachrunner3241

[zachrunner3241]

Edit since Firestrom DB is different from TrinityCore's:

DELETE FROM `creature_loot_template`
WHERE `Entry` ='99895';
INSERT INTO `creature_loot_template` (`Entry`,`Item`,`ChanceOrQuestChance`,`LootMode`,`GroupId`,`MinCountOrRef`,`MaxCount`,`RequiredAura`,`difficulityMask`)
VALUES (99895,130078,-40,1,0,1,1,0,0);

 

Edited August 17, 2017 by zachrunner3241