From b52b3581095a7022ec01d354e7c62083b4ed6c6d Mon Sep 17 00:00:00 2001
From: pendragon <none@none>
Date: Sat, 11 Jul 2009 14:22:55 +0200
Subject: *Some missing data for DK quests - will be removed after supported db
 projects release this data.

--HG--
branch : trunk
---
 sql/updates/4426_world.sql | 28 ++++++++++++++++++++++++++++
 1 file changed, 28 insertions(+)
 create mode 100644 sql/updates/4426_world.sql

(limited to 'sql/updates/4426_world.sql')

diff --git a/sql/updates/4426_world.sql b/sql/updates/4426_world.sql
new file mode 100644
index 00000000000..0db361d93bf
--- /dev/null
+++ b/sql/updates/4426_world.sql
@@ -0,0 +1,28 @@
+DELETE FROM `creature_questrelation` WHERE `quest` = 12754; 
+INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (28914, 12754); 
+DELETE FROM `creature_involvedrelation` WHERE `quest` = 12754; 
+INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (28914, 12754); 
+DELETE FROM `creature_questrelation` WHERE `quest` = 12757; 
+INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (28914, 12757); 
+DELETE FROM `creature_questrelation` WHERE `quest` = 12754; 
+INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (28914, 12754); 
+DELETE FROM `creature_involvedrelation` WHERE `quest` = 12754; 
+INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (28914, 12754); 
+DELETE FROM `creature_questrelation` WHERE `quest` = 12755; 
+INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (28914, 12755); 
+DELETE FROM `creature_involvedrelation` WHERE `quest` = 12756; 
+INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (28914, 12756); 
+DELETE FROM `creature_questrelation` WHERE `quest` = 12757; 
+INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (28914, 12757); 
+DELETE FROM `creature_involvedrelation` WHERE `quest` = 12800; 
+INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (31082, 12800); 
+DELETE FROM `creature_questrelation` WHERE `quest` = 12801; 
+INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (31082, 12801); 
+DELETE FROM `creature_involvedrelation` WHERE `quest` = 12801; 
+INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (29173, 12801);
+UPDATE `quest_template` SET `PrevQuestId`=13166 WHERE `entry`=13188;
+UPDATE `quest_template` SET `PrevQuestId`=13166 WHERE `entry`=13189;
+
+UPDATE `creature` SET `phaseMask`=128 WHERE `id` IN (31082,29173,29199,29204,29200);
+-- Citizen of New Avalon
+UPDATE creature_template SET unit_flags = 537166336, dynamicflags = 0 WHERE entry = 28942;
-- 
cgit v1.2.3

