diff options
| -rw-r--r-- | sql/FULL/world_scripts_full.sql | 1 | ||||
| -rw-r--r-- | sql/updates/4742_world_spell_proc_event.sql | 2 | ||||
| -rw-r--r-- | sql/updates/4745_world_access_requirement.sql | 17 | ||||
| -rw-r--r-- | sql/updates/4748_world.sql | 2 | ||||
| -rw-r--r-- | sql/updates/4751_world_scripts.sql | 2 | ||||
| -rw-r--r-- | sql/updates/4753_world.sql | 2 | ||||
| -rw-r--r-- | sql/updates/4755_world_scripts.sql | 1 |
7 files changed, 7 insertions, 20 deletions
diff --git a/sql/FULL/world_scripts_full.sql b/sql/FULL/world_scripts_full.sql index 17272c9b98e..6ed6c2e20c6 100644 --- a/sql/FULL/world_scripts_full.sql +++ b/sql/FULL/world_scripts_full.sql @@ -36,6 +36,7 @@ UPDATE `gameobject_template` SET `ScriptName`='go_tele_to_dalaran_crystal' WHERE UPDATE `gameobject_template` SET `ScriptName`='go_tele_to_violet_stand' WHERE `entry`=191229; UPDATE `gameobject_template` SET `ScriptName`='go_orb_of_the_blue_flight' WHERE `entry`=188415; UPDATE `gameobject_template` SET `ScriptName`='go_acherus_soul_prison' WHERE `entry` IN (191577,191580,191581,191582,191583,191584,191585,191586,191587,191588,191589,191590); +UPDATE `gameobject_template` SET `ScriptName`='go_shrine_of_the_birds' WHERE `entry` IN (185547,185553,185551); /* GUARD */ UPDATE `creature_template` SET `ScriptName`='guard_azuremyst' WHERE `entry`=18038; diff --git a/sql/updates/4742_world_spell_proc_event.sql b/sql/updates/4742_world_spell_proc_event.sql index e4a3bcd6d17..f9d98472263 100644 --- a/sql/updates/4742_world_spell_proc_event.sql +++ b/sql/updates/4742_world_spell_proc_event.sql @@ -1,2 +1,2 @@ DELETE FROM `spell_proc_event` WHERE (`entry`='64928'); -INSERT INTO `spell_proc_event` (`entry`, `SpellFamilyName`, `SpellFamilyMask0`, `procEx`) VALUES (64928, 11, 0x00000001, 0x00000002); +INSERT INTO `spell_proc_event` (`entry`, `SpellFamilyName`, `SpellFamilyMask0`, `procEx`) VALUES (64928, 11, 0x00000001, 0x00000002);
\ No newline at end of file diff --git a/sql/updates/4745_world_access_requirement.sql b/sql/updates/4745_world_access_requirement.sql index c8234763414..d328cbc9667 100644 --- a/sql/updates/4745_world_access_requirement.sql +++ b/sql/updates/4745_world_access_requirement.sql @@ -5,20 +5,15 @@ UPDATE `access_requirement` SET `heroic_level_min` = 70 WHERE `id` IN 4405, -- Mana-Tombs -- 4406, -- Sethekk Halls -- 4407, -- Shadow Labyrinth -- - 4321, -- Old Hillsbrad Foothills -- 4320, -- The Black Morass -- - 4365, -- The Slave Pens -- 4364, -- The Steamvault -- 4363, -- The Underbog -- - 4150, -- Hellfire Ramparts -- 4152, -- The Blood Furnace -- 4151, -- The Shattered Halls -- - 4887, -- Magisters' Terrace -- - 4468, -- The Arcatraz -- 4467, -- The Botanica -- 4469 -- The Mechanar -- @@ -29,21 +24,14 @@ UPDATE `access_requirement` SET `heroic_level_min` = 80 WHERE `id` IN ( 5215, -- Ahn'kahet: The Old Kingdom -- 5117, -- Azjol-Nerub -- - 5150, -- The Culling of Stratholme -- - 4998, -- Drak'Tharon Keep -- - 5206, -- Gundrak -- - 4983, -- The Nexus -- 5246, -- The Oculus -- - 5209, -- The Violet Hold -- - 5093, -- Halls of Lightning -- 5010, -- Halls of Stone -- - 4745, -- Utgarde Keep -- 4747 -- Utgarde Pinnacle -- ); @@ -52,10 +40,7 @@ UPDATE `access_requirement` SET `heroic_level_min` = 80 WHERE `id` IN UPDATE `access_requirement` SET `heroic_level_min` = 80 WHERE `id` IN ( 4156, -- Naxxramas -- - 5290, -- The Eye of Eternity -- - 5243, -- The Obsidian Sanctum -- - 5379 -- Ulduar -- -); +);
\ No newline at end of file diff --git a/sql/updates/4748_world.sql b/sql/updates/4748_world.sql index 00834293554..62e98d58d68 100644 --- a/sql/updates/4748_world.sql +++ b/sql/updates/4748_world.sql @@ -1,2 +1,2 @@ UPDATE `item_template` SET `ScriptName`='item_mysterious_egg' WHERE `entry` IN(39878); -UPDATE `item_template` SET `ScriptName`='item_disgusting_jar' WHERE `entry` IN(44717); +UPDATE `item_template` SET `ScriptName`='item_disgusting_jar' WHERE `entry` IN(44717);
\ No newline at end of file diff --git a/sql/updates/4751_world_scripts.sql b/sql/updates/4751_world_scripts.sql index 5bedf2df1c4..7efb4e61aa1 100644 --- a/sql/updates/4751_world_scripts.sql +++ b/sql/updates/4751_world_scripts.sql @@ -1 +1 @@ -UPDATE `creature_template` SET `ScriptName`='npc_training_dummy', `flags_extra`='262144', `mechanic_immune_mask`='0', `faction_A`='7', `faction_H`='7' WHERE `entry` IN (17578, 24792, 32543, 32546, 32542, 32545, 30527, 31143, 31144, 31146, 32541, 32666, 32667); +UPDATE `creature_template` SET `ScriptName`='npc_training_dummy', `flags_extra`='262144', `mechanic_immune_mask`='0', `faction_A`='7', `faction_H`='7' WHERE `entry` IN (17578, 24792, 32543, 32546, 32542, 32545, 30527, 31143, 31144, 31146, 32541, 32666, 32667);
\ No newline at end of file diff --git a/sql/updates/4753_world.sql b/sql/updates/4753_world.sql index 059a6427b9b..19d69ce70e0 100644 --- a/sql/updates/4753_world.sql +++ b/sql/updates/4753_world.sql @@ -2,4 +2,4 @@ DELETE FROM `spell_script_target` WHERE `entry` IN (58836, 48743, 50524, 50515); INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES (58836, 3, 31216), (50524, 3, 27829), -(50515, 3, 27829); +(50515, 3, 27829);
\ No newline at end of file diff --git a/sql/updates/4755_world_scripts.sql b/sql/updates/4755_world_scripts.sql new file mode 100644 index 00000000000..0d184735a5d --- /dev/null +++ b/sql/updates/4755_world_scripts.sql @@ -0,0 +1 @@ +UPDATE `gameobject_template` SET `ScriptName`='go_shrine_of_the_birds' WHERE `entry` IN (185547,185553,185551);
\ No newline at end of file |