diff options
Diffstat (limited to 'sql')
8 files changed, 36 insertions, 0 deletions
diff --git a/sql/updates/world/2014_03_16_03_world_sai.sql b/sql/updates/world/2014_03_16_03_world_sai.sql new file mode 100644 index 00000000000..2e5ce237dbe --- /dev/null +++ b/sql/updates/world/2014_03_16_03_world_sai.sql @@ -0,0 +1,4 @@ +-- +UPDATE `smart_scripts` SET `target_type`=1 WHERE `entryorguid`=28256 AND `source_type`=1; +UPDATE `smart_scripts` SET `target_type`=1 WHERE `entryorguid`=2825600 AND `source_type`=9 AND `id` BETWEEN 0 AND 4; +UPDATE `smart_scripts` SET `target_type`=18, `target_param1`=30 WHERE `entryorguid`=2825600 AND `source_type`=9 AND `id`=5; diff --git a/sql/updates/world/2014_03_16_04_world_sai.sql b/sql/updates/world/2014_03_16_04_world_sai.sql new file mode 100644 index 00000000000..e6d38d73174 --- /dev/null +++ b/sql/updates/world/2014_03_16_04_world_sai.sql @@ -0,0 +1,2 @@ +-- +UPDATE `smart_scripts` SET `action_type`=85, `action_param2`=2 WHERE `entryorguid` IN(5284,5285,5286,5287) AND `source_type`=2; diff --git a/sql/updates/world/2014_03_16_05_world_item_template.sql b/sql/updates/world/2014_03_16_05_world_item_template.sql new file mode 100644 index 00000000000..6a93d64ea92 --- /dev/null +++ b/sql/updates/world/2014_03_16_05_world_item_template.sql @@ -0,0 +1,3 @@ +-- +UPDATE `item_template` SET `subclass`=0, `WDBVerified`=-15595 WHERE `entry`=33604; +UPDATE `item_template` SET `spelltrigger_3`=0, `spellid_3`=0, `WDBVerified`=-15595 WHERE `entry`=44851; diff --git a/sql/updates/world/2014_03_17_00_world_sai.sql b/sql/updates/world/2014_03_17_00_world_sai.sql new file mode 100644 index 00000000000..c244170d5e6 --- /dev/null +++ b/sql/updates/world/2014_03_17_00_world_sai.sql @@ -0,0 +1,2 @@ +-- +UPDATE `smart_scripts` SET `event_flags`=1 WHERE `entryorguid`=2249 AND `source_type`=0 AND `id`=0; diff --git a/sql/updates/world/2014_03_18_00_world_quest.sql b/sql/updates/world/2014_03_18_00_world_quest.sql new file mode 100644 index 00000000000..2ca49917a12 --- /dev/null +++ b/sql/updates/world/2014_03_18_00_world_quest.sql @@ -0,0 +1,20 @@ +-- The Splintered Throne +UPDATE `quest_template` SET `NextQuestId`=24912 WHERE `Id`=24548; + +-- Shadowmourne... +UPDATE `quest_template` SET `PrevQuestId`=24912 WHERE `Id`=24549; + +-- Empowerment +UPDATE `quest_template` SET `PrevQuestId`=24548, `NextQuestId`=24549 WHERE `Id`=24912; + +DELETE FROM `creature_queststarter` WHERE `quest`=24912; +INSERT INTO `creature_queststarter`(`id`,`quest`) VALUE +(37120,24912); + +DELETE FROM `creature_questender` WHERE `quest`=24912; +INSERT INTO `creature_questender`(`id`,`quest`) VALUE +(37120,24912); + +-- Highlord Darion Mograine +UPDATE `creature_template` SET `AIName`='' WHERE `entry`=37120; +DELETE FROM `smart_scripts` WHERE `entryorguid`=37120 AND `source_type`=0; diff --git a/sql/updates/world/2014_03_19_00_world_tele.sql b/sql/updates/world/2014_03_19_00_world_tele.sql new file mode 100644 index 00000000000..d6fd0460bb9 --- /dev/null +++ b/sql/updates/world/2014_03_19_00_world_tele.sql @@ -0,0 +1,2 @@ +UPDATE `game_tele` SET `name`='CircleOfOuterBinding' WHERE `id`=211; +UPDATE `game_tele` SET `name`='CircleOfInnerBinding' WHERE `id`=210; diff --git a/sql/updates/world/2014_03_19_01_world_reputation_reward_rate.sql b/sql/updates/world/2014_03_19_01_world_reputation_reward_rate.sql new file mode 100644 index 00000000000..3013a311b5d --- /dev/null +++ b/sql/updates/world/2014_03_19_01_world_reputation_reward_rate.sql @@ -0,0 +1,2 @@ +-- +UPDATE `reputation_reward_rate` SET `quest_repeatable_rate`=4 WHERE `faction`=576; diff --git a/sql/updates/world/2014_03_20_00_world_creature_equip_template.sql b/sql/updates/world/2014_03_20_00_world_creature_equip_template.sql new file mode 100644 index 00000000000..10df4e459f4 --- /dev/null +++ b/sql/updates/world/2014_03_20_00_world_creature_equip_template.sql @@ -0,0 +1 @@ +UPDATE `creature_equip_template` SET `id`=1 WHERE `id`=0; |