*Fix dk quest until 12727. Some scripts are needed for quest 12727.

--HG--
branch : trunk

3 files changed, 55 insertions, 0 deletions

diff --git a/sql/updates/3873_world_spell_(dk).sql b/sql/updates/3873_world_spell_(dk).sql
new file mode 100644
index 00000000000..09d130a4f6b
--- /dev/null
+++ b/sql/updates/3873_world_spell_(dk).sql
@@ -0,0 +1,25 @@
+
+replace into creature_questrelation (id,quest) VALUES (28377,12701);
+replace into creature_involvedrelation (id,quest) VALUES (28377,12701);
+replace into creature_involvedrelation (id,quest) VALUES (28914,12723);
+replace into creature_questrelation (id,quest) VALUES (28914,12724);
+replace into creature_involvedrelation (id,quest) VALUES (28914,12724);
+replace into creature_questrelation (id,quest) VALUES (28913,12725);
+replace into creature_involvedrelation (id,quest) VALUES (28912,12725);
+replace into creature_questrelation (id,quest) VALUES (28912,12727);
+replace into creature_involvedrelation (id,quest) VALUES (28913,12727);
+
+
+DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN (28833,28887);
+INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `quest_id`, `quest_status`, `cast_flags`) VALUES
+(28833, 52447, 12701, 3, 3),
+(28887, 52447, 12701, 3, 3);
+
+UPDATE creature_template SET spell1=52435,spell2=52576,spell5=52588,VehicleId=68,speed=0 WHERE entry IN (28833,28887);
+UPDATE creature_template SET spell1=52211 WHERE entry=28864;
+
+DELETE FROM `spell_script_target` WHERE entry IN
+(52576);
+INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES
+(52576,1,28834),
+(52576,1,28886);
diff --git a/sql/world_spell_full.sql b/sql/world_spell_full.sql
index 54577ff975e..602be1dd526 100644
--- a/sql/world_spell_full.sql
+++ b/sql/world_spell_full.sql
@@ -1623,6 +1623,33 @@ INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES
 (52479,1,28819),
 (52479,1,28822);
 
+
+replace into creature_questrelation (id,quest) VALUES (28377,12701);
+replace into creature_involvedrelation (id,quest) VALUES (28377,12701);
+replace into creature_involvedrelation (id,quest) VALUES (28914,12723);
+replace into creature_questrelation (id,quest) VALUES (28914,12724);
+replace into creature_involvedrelation (id,quest) VALUES (28914,12724);
+replace into creature_questrelation (id,quest) VALUES (28913,12725);
+replace into creature_involvedrelation (id,quest) VALUES (28912,12725);
+replace into creature_questrelation (id,quest) VALUES (28912,12727);
+replace into creature_involvedrelation (id,quest) VALUES (28913,12727);
+
+-- ship cannon
+DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN (28833,28887);
+INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `quest_id`, `quest_status`, `cast_flags`) VALUES
+(28833, 52447, 12701, 3, 3),
+(28887, 52447, 12701, 3, 3);
+
+UPDATE creature_template SET spell1=52435,spell2=52576,spell5=52588,VehicleId=68,speed=0 WHERE entry IN (28833,28887);
+UPDATE creature_template SET spell1=52211 WHERE entry=28864;
+
+DELETE FROM `spell_script_target` WHERE entry IN
+(52576);
+INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES
+(52576,1,28834),
+(52576,1,28886);
+
+
 -- frostbrood vanquisher
 update creature_template set maxhealth = 133525, minhealth = 133525, maxmana = 51360, minmana = 51360, spell1 = 53114, spell2 = 53112, spell3=53110, VehicleId = 156 where entry = 28670;
 
diff --git a/src/bindings/scripts/scripts/zone/eastern_plaguelands/the_scarlet_enclave.cpp b/src/bindings/scripts/scripts/zone/eastern_plaguelands/the_scarlet_enclave.cpp
index 560d9196d95..4790bf1f97d 100644
--- a/src/bindings/scripts/scripts/zone/eastern_plaguelands/the_scarlet_enclave.cpp
+++ b/src/bindings/scripts/scripts/zone/eastern_plaguelands/the_scarlet_enclave.cpp
@@ -598,6 +598,7 @@ CreatureAI* GetAI_npc_ros_dark_rider(Creature *_Creature)
     return new npc_ros_dark_riderAI(_Creature);
 }
 
+// correct way: 52312 52314 52555 ...
 struct TRINITY_DLL_DECL npc_dkc1_gothikAI : public ScriptedAI
 {
     npc_dkc1_gothikAI(Creature *c) : ScriptedAI(c) {}
@@ -628,6 +629,8 @@ CreatureAI* GetAI_npc_dkc1_gothik(Creature *_Creature)
     return new npc_dkc1_gothikAI(_Creature);
 }
 
+// npc 28912 quest 17217 boss 29001 go 191092 
+
 void AddSC_the_scarlet_enclave()
 {
     Script *newscript;