5 files changed, 88 insertions, 2 deletions
diff --git a/sql/mangos.sql b/sql/mangos.sql
index 346495436d3..5ff29d24fb4 100644
--- a/sql/mangos.sql
+++ b/sql/mangos.sql
@@ -23,7 +23,7 @@ DROP TABLE IF EXISTS `db_version`;
 CREATE TABLE `db_version` (
   `version` varchar(120) default NULL,
   `creature_ai_version` varchar(120) default NULL,
-  `required_7945_01_mangos_quest_template` bit(1) default NULL
+  `required_7980_01_mangos_item_required_target` bit(1) default NULL
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Used DB version notes';
 
 --
@@ -1659,6 +1659,27 @@ LOCK TABLES `item_loot_template` WRITE;
 UNLOCK TABLES;
 
 --
+-- Table structure for table `item_required_target`
+--
+
+DROP TABLE IF EXISTS `item_required_target`;
+CREATE TABLE `item_required_target` (
+  `entry` mediumint(8) unsigned NOT NULL,
+  `type` tinyint(3) unsigned NOT NULL default '0',
+  `targetEntry` mediumint(8) unsigned NOT NULL default '0',
+  UNIQUE KEY `entry_type_target` (`entry`,`type`,`targetEntry`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED
+
+--
+-- Dumping data for table `item_required_target`
+--
+
+LOCK TABLES `item_required_target` WRITE;
+/*!40000 ALTER TABLE `item_required_target` DISABLE KEYS */;
+/*!40000 ALTER TABLE `item_required_target` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
 -- Table structure for table `item_template`
 --
 
diff --git a/sql/updates/3870_mangos_7980_01_world_item_required_target.sql b/sql/updates/3870_mangos_7980_01_world_item_required_target.sql
new file mode 100644
index 00000000000..7853e496a2d
--- /dev/null
+++ b/sql/updates/3870_mangos_7980_01_world_item_required_target.sql
@@ -0,0 +1,9 @@
+-- ALTER TABLE db_version CHANGE COLUMN required_7945_01_mangos_quest_template required_7980_01_mangos_item_required_target bit;
+
+DROP TABLE IF EXISTS `item_required_target`;
+CREATE TABLE `item_required_target` (
+  `entry` mediumint(8) unsigned NOT NULL,
+  `type` tinyint(3) unsigned NOT NULL default '0',
+  `targetEntry` mediumint(8) unsigned NOT NULL default '0',
+  UNIQUE KEY `entry_type_target` (`entry`,`type`,`targetEntry`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED;
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/updates/3877_world_spell_script_target.sql b/sql/updates/3877_world_spell_script_target.sql
new file mode 100644
index 00000000000..9778be52466
--- /dev/null
+++ b/sql/updates/3877_world_spell_script_target.sql
@@ -0,0 +1,3 @@
+DELETE FROM `spell_script_target` WHERE `entry` IN (48743);
+INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES 
+('48743', '1', '26125');
+\ No newline at end of file
diff --git a/sql/world_spell_full.sql b/sql/world_spell_full.sql
index 54577ff975e..fb2c9a8b04a 100644
--- a/sql/world_spell_full.sql
+++ b/sql/world_spell_full.sql
@@ -1590,7 +1590,8 @@ INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES
 (51859, 1, 28525), -- siphon of archerus
 (51859, 1, 28542),
 (51859, 1, 28543),
-(51859, 1, 28544);
+(51859, 1, 28544),
+(48743, 1, 26125); -- Death pact
 
 update creature_template set minlevel=50,maxlevel=52,minhealth=2215,maxhealth=2317,faction_A=2084,faction_H=2084,mindmg=50,maxdmg=50 where entry=28528; -- ghoul
 
@@ -1623,6 +1624,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;