diff options
| -rw-r--r-- | sql/updates/world/master/2021_10_01_00_world.sql | 29 |
1 files changed, 29 insertions, 0 deletions
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, ''); |