From b52b3581095a7022ec01d354e7c62083b4ed6c6d Mon Sep 17 00:00:00 2001 From: pendragon 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