diff options
Diffstat (limited to 'sql/updates')
9 files changed, 40 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_conditions.sql b/sql/updates/world/2014_03_19_00_world_conditions.sql new file mode 100644 index 00000000000..fdbb175017d --- /dev/null +++ b/sql/updates/world/2014_03_19_00_world_conditions.sql @@ -0,0 +1,4 @@ +UPDATE `creature_template` SET `scriptname`='' WHERE `entry`=3052; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=24 AND `SourceEntry`=0; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(15,24,0,0,0,8,0,770,0,0,1,0,0,'','Show gossip menu option if player has no quest ''The Demon Scarred Cloak'' rewarded'); 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; |