turrikasd/laughing-ninja — pull request #4 by Appled (2013-04-09 08:52:42+00:00)
Title: Small fixes to Karazhan

diff --git a/sql/updates/2013-04-09-karazhan.sql b/sql/updates/2013-04-09-karazhan.sql
new file mode 100644
index 0000000..f986811
--- /dev/null
+++ b/sql/updates/2013-04-09-karazhan.sql
@@ -0,0 +1,6 @@
+-- As of patch 2.1, Nightbane's adds should not be immune to spell damage nor have immolation aura anymore
+DELETE FROM `creature_template_spells` WHERE `entry`='17261';
+-- Prince Malchezaar axes should be deadly, not only hit for 1. Damage is not blizzlike but gathered from many sources and is close to blizzlike. Also axes have 'Demonic Frenzy' passive aura.
+UPDATE `creature_template` SET `mindmg`='212', `maxdmg`='679', `attackPower`='100' WHERE (`entry`='17650');
+DELETE FROM `creature_template_spells` WHERE `entry`='17650';
+INSERT INTO `creature_template_spells` VALUES ('17650','32850','0','0','0');
\ No newline at end of file