diff options
| author | ZxBiohazardZx <zxbiohazardzx@gmail.com> | 2012-08-09 09:32:33 +0200 |
|---|---|---|
| committer | ZxBiohazardZx <zxbiohazardzx@gmail.com> | 2012-08-09 09:32:33 +0200 |
| commit | f87655b9167008a3051a980ddff7d43b14ccb0da (patch) | |
| tree | 8895996fb26c56c659f526d8eb2b810f92dd3a7c | |
| parent | f8cd39b2ed1056f409c2690ac8bb661fbcb68e18 (diff) | |
DB/Misc: add npcflag for 0b98656b2878e1a6f644e1cd8b7745370efc488b (thx Vincent-Michael)
DB/Loot: add missing recipe to loot
| -rw-r--r-- | sql/updates/world/2012_08_09_00_world_creature_template.sql | 6 |
1 files changed, 6 insertions, 0 deletions
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 |