From 6af3bc69970d3009a8e193fd2d3041232fbbd3e7 Mon Sep 17 00:00:00 2001 From: MitchesD Date: Sat, 13 Jun 2015 23:11:17 +0200 Subject: Fix file name --- sql/updates/world/ 2015_06_13_01_world.sql | 42 ------------------------------ sql/updates/world/2015_06_13_01_world.sql | 42 ++++++++++++++++++++++++++++++ 2 files changed, 42 insertions(+), 42 deletions(-) delete mode 100644 sql/updates/world/ 2015_06_13_01_world.sql create mode 100644 sql/updates/world/2015_06_13_01_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/ 2015_06_13_01_world.sql b/sql/updates/world/ 2015_06_13_01_world.sql deleted file mode 100644 index d0833aca0c2..00000000000 --- a/sql/updates/world/ 2015_06_13_01_world.sql +++ /dev/null @@ -1,42 +0,0 @@ --- Rewards for Kael'Thas and the Verdant Sphere - -UPDATE `quest_template` SET -`RewardChoiceItemId1`=30018, -- Lord Sanguinar's Claim -`RewardChoiceItemId2`=30017, -- Telonicus' Pendant of Mayhem -`RewardChoiceItemId3`=30007, -- The Darkener's Grasp -`RewardChoiceItemId4`=30015, -- The Sun King's Talisman -`RewardChoiceItemCount1`=1, -`RewardChoiceItemCount2`=1, -`RewardChoiceItemCount3`=1, -`RewardChoiceItemCount4`=1 WHERE `Id`=11007; - --- Rewards for The Cipher of Damnation - -UPDATE `quest_template` SET -`RewardItemId1`=31074, -- Amulet of the Torn-Heart -`RewardChoiceItemId1`=31073, -- Borak's Reminder -`RewardChoiceItemId2`=31071, -- Grom'tor's Charge -`RewardChoiceItemId3`=31072, -- Lohn'goron, Bow of the Torn-Heart -`RewardChoiceItemId4`=31036, -- Oronok's Ancient Scepter -`RewardChoiceItemId5`=31062, -- Torn-Heart Axe of Battle -`RewardChoiceItemId6`=31038, -- Staff of the Redeemer -`RewardItemCount1`=1, -`RewardChoiceItemCount1`=1, -`RewardChoiceItemCount2`=1, -`RewardChoiceItemCount3`=1, -`RewardChoiceItemCount4`=1, -`RewardChoiceItemCount5`=1, -`RewardChoiceItemCount6`=1 WHERE `Id`=10588; - --- Voa Summon Stone - -SET @OGUID=35834; -DELETE FROM `gameobject` WHERE `id` IN (195013); -INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`, `rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES -(@OGUID,195013,571,1,65,5476.19,2861.76,418.675,0,1,300,255,1); - -UPDATE `creature` SET `position_x`=5407.84,`position_y`=2819.29, `position_z`=418.676,`orientation`=0.471239 WHERE `id`=32620; - --- DB Error - -UPDATE `creature_template` SET `NpcFlag`=3 WHERE `entry`=14325; diff --git a/sql/updates/world/2015_06_13_01_world.sql b/sql/updates/world/2015_06_13_01_world.sql new file mode 100644 index 00000000000..d0833aca0c2 --- /dev/null +++ b/sql/updates/world/2015_06_13_01_world.sql @@ -0,0 +1,42 @@ +-- Rewards for Kael'Thas and the Verdant Sphere + +UPDATE `quest_template` SET +`RewardChoiceItemId1`=30018, -- Lord Sanguinar's Claim +`RewardChoiceItemId2`=30017, -- Telonicus' Pendant of Mayhem +`RewardChoiceItemId3`=30007, -- The Darkener's Grasp +`RewardChoiceItemId4`=30015, -- The Sun King's Talisman +`RewardChoiceItemCount1`=1, +`RewardChoiceItemCount2`=1, +`RewardChoiceItemCount3`=1, +`RewardChoiceItemCount4`=1 WHERE `Id`=11007; + +-- Rewards for The Cipher of Damnation + +UPDATE `quest_template` SET +`RewardItemId1`=31074, -- Amulet of the Torn-Heart +`RewardChoiceItemId1`=31073, -- Borak's Reminder +`RewardChoiceItemId2`=31071, -- Grom'tor's Charge +`RewardChoiceItemId3`=31072, -- Lohn'goron, Bow of the Torn-Heart +`RewardChoiceItemId4`=31036, -- Oronok's Ancient Scepter +`RewardChoiceItemId5`=31062, -- Torn-Heart Axe of Battle +`RewardChoiceItemId6`=31038, -- Staff of the Redeemer +`RewardItemCount1`=1, +`RewardChoiceItemCount1`=1, +`RewardChoiceItemCount2`=1, +`RewardChoiceItemCount3`=1, +`RewardChoiceItemCount4`=1, +`RewardChoiceItemCount5`=1, +`RewardChoiceItemCount6`=1 WHERE `Id`=10588; + +-- Voa Summon Stone + +SET @OGUID=35834; +DELETE FROM `gameobject` WHERE `id` IN (195013); +INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`, `rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES +(@OGUID,195013,571,1,65,5476.19,2861.76,418.675,0,1,300,255,1); + +UPDATE `creature` SET `position_x`=5407.84,`position_y`=2819.29, `position_z`=418.676,`orientation`=0.471239 WHERE `id`=32620; + +-- DB Error + +UPDATE `creature_template` SET `NpcFlag`=3 WHERE `entry`=14325; -- cgit v1.2.3