From f87655b9167008a3051a980ddff7d43b14ccb0da Mon Sep 17 00:00:00 2001 From: ZxBiohazardZx Date: Thu, 9 Aug 2012 09:32:33 +0200 Subject: DB/Misc: add npcflag for 0b98656b2878e1a6f644e1cd8b7745370efc488b (thx Vincent-Michael) DB/Loot: add missing recipe to loot --- sql/updates/world/2012_08_09_00_world_creature_template.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 sql/updates/world/2012_08_09_00_world_creature_template.sql (limited to 'sql') diff --git a/sql/updates/world/2012_08_09_00_world_creature_template.sql b/sql/updates/world/2012_08_09_00_world_creature_template.sql new file mode 100644 index 00000000000..8d04c13dc87 --- /dev/null +++ b/sql/updates/world/2012_08_09_00_world_creature_template.sql @@ -0,0 +1,6 @@ +UPDATE `creature_template` SET `npcflag`=`npcflag` |2 WHERE `entry` IN (25918,25929,25931,25933,25936,25938,25946,32811,32812,32813,32816); + +DELETE FROM `creature_loot_template` WHERE `entry` IN(17465,20583) AND `item`=22554; +INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES +(17465,22554,15,1,0,1,1), -- Formula: Enchant 2H Weapon - Savagery +(20583,22554,15,1,0,1,1); -- Formula: Enchant 2H Weapon - Savagery -- cgit v1.2.3