diff options
| author | pendragon <none@none> | 2009-07-11 14:22:55 +0200 |
|---|---|---|
| committer | pendragon <none@none> | 2009-07-11 14:22:55 +0200 |
| commit | b52b3581095a7022ec01d354e7c62083b4ed6c6d (patch) | |
| tree | 39a759f35bb547f5690f22a7d9fd4393578312c0 /sql/updates/4426_world.sql | |
| parent | 024bde5fe76c32c537508352b002ff688a8a551b (diff) | |
*Some missing data for DK quests - will be removed after supported db projects release this data.
--HG--
branch : trunk
Diffstat (limited to 'sql/updates/4426_world.sql')
| -rw-r--r-- | sql/updates/4426_world.sql | 28 |
1 files changed, 28 insertions, 0 deletions
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; |