From 25b9b0dcc840d95e6799e98a7057576185a85ebe Mon Sep 17 00:00:00 2001 From: Aokromes Date: Fri, 1 Oct 2021 09:46:14 +0200 Subject: DB/Quest: Solanian's Belongings closes #26978 by osleyder85 --- sql/updates/world/master/2021_10_01_00_world.sql | 29 ++++++++++++++++++++++++ 1 file changed, 29 insertions(+) create mode 100644 sql/updates/world/master/2021_10_01_00_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2021_10_01_00_world.sql b/sql/updates/world/master/2021_10_01_00_world.sql new file mode 100644 index 00000000000..fcb4dc4cc2c --- /dev/null +++ b/sql/updates/world/master/2021_10_01_00_world.sql @@ -0,0 +1,29 @@ +-- Solanian's Belongings +UPDATE `gameobject_template` SET `ContentTuningId`=1485, `VerifiedBuild`=40120 WHERE `entry` IN (180510,180511,180512); + +UPDATE `gameobject_template_addon` SET `flags`=0 WHERE `entry` IN (180510,180511,180512); + +UPDATE `gameobject_questitem` SET `VerifiedBuild`=40120 WHERE (`GameObjectEntry` IN (180510,180511,180512) AND `Idx`=0); + +UPDATE `quest_objectives` SET `VerifiedBuild`=40120 WHERE `ID` IN (276220,256221,276222); + +UPDATE `quest_visual_effect` SET `VerifiedBuild`=40120 WHERE (`ID` IN (276220,276222) AND `Index`=0); + +-- Solanian's Scrying Orb +UPDATE `gameobject_template` SET `data1`=180510 WHERE `entry`=180510; +DELETE FROM `gameobject_loot_template` WHERE `entry`=180510; +INSERT INTO `gameobject_loot_template` (`entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(180510, 20470, 0, 100, 0, 1, 0, 1, 1, ''); + +-- Scroll of Scourge Magic +UPDATE `gameobject_template` SET `data1`=180511 WHERE `entry`=180511; +DELETE FROM `gameobject_loot_template` WHERE `entry`=180511; +INSERT INTO `gameobject_loot_template` (`entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(180511, 20471, 0, 100.000, 0, 1, 0, 1, 1, ''), +(180511, 21007, 0, 0.30826, 0, 1, 0, 1, 1, ''); + +-- Solanian's Journal +UPDATE `gameobject_template` SET `data1`=180512 WHERE `entry`=180512; +DELETE FROM `gameobject_loot_template` WHERE `entry`=180512; +INSERT INTO `gameobject_loot_template` (`entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(180512, 20472, 0, 100, 0, 1, 0, 1, 1, ''); -- cgit v1.2.3