*Fix quest gift of harvester.

*Add missing frostbrood vanquisher vehicle id in previous sql. Thanks to  Azrael

--HG--
branch : trunk

1 files changed, 10 insertions, 0 deletions

diff --git a/sql/updates/3813_world_spell_(dk).sql b/sql/updates/3813_world_spell_(dk).sql
new file mode 100644
index 00000000000..ee12a70afd0
--- /dev/null
+++ b/sql/updates/3813_world_spell_(dk).sql
@@ -0,0 +1,10 @@
+UPDATE `creature_template` SET `ScriptName`='npc_dkc1_gothik' WHERE `entry`=28658;
+
+-- gift of harvester
+DELETE FROM `spell_script_target` WHERE entry IN
+(52479);
+INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES
+(52479,1,28819),
+(52479,1,28822);
+
+update creature_template set maxhealth = 133525, minhealth = 133525, maxmana = 51360, minmana = 51360, spell1 = 53114, spell2 = 53112, spell3=53110, VehicleId = 156 where entry = 28670;