diff options
| -rw-r--r-- | sql/updates/world/master/2024_06_19_02_world.sql | 231 |
1 files changed, 231 insertions, 0 deletions
diff --git a/sql/updates/world/master/2024_06_19_02_world.sql b/sql/updates/world/master/2024_06_19_02_world.sql new file mode 100644 index 00000000000..4ac7163ed02 --- /dev/null +++ b/sql/updates/world/master/2024_06_19_02_world.sql @@ -0,0 +1,231 @@ +-- Creature templates +UPDATE `creature_template` SET `faction`=1801, `npcflag`=1, `speed_run`=1.714285731315612792, `BaseAttackTime`=2000, `unit_flags2`=2048, `unit_flags3`=8388608 WHERE `entry`=221105; -- Huojin Sentry +UPDATE `creature_template` SET `faction`=190, `BaseAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2048, `unit_flags3`=16777216 WHERE `entry`=220526; -- Displaced Anomaly +UPDATE `creature_template` SET `faction`=190, `BaseAttackTime`=2000, `unit_flags2`=2048, `unit_flags3`=67108864 WHERE `entry`=220525; -- Young Albatross +UPDATE `creature_template` SET `faction`=2136, `BaseAttackTime`=2000, `unit_flags2`=2048, `unit_flags3`=67108864 WHERE `entry`=220524; -- Great Turtle Hatchling +UPDATE `creature_template` SET `faction`=16, `BaseAttackTime`=2000, `unit_flags`=33554432, `unit_flags2`=2048, `unit_flags3`=524289 WHERE `entry`=218391; -- Displaced Moment +UPDATE `creature_template` SET `faction`=1711, `speed_walk`=1, `speed_run`=1.142857193946838378, `BaseAttackTime`=2000, `unit_flags`=33554432, `unit_flags2`=2048 WHERE `entry`=218346; -- Infinite Ravager +UPDATE `creature_template` SET `faction`=1812, `BaseAttackTime`=2000, `unit_flags2`=2048, `unit_flags3`=8388608 WHERE `entry` IN (218148, 217058); -- Infinite Watcher +UPDATE `creature_template` SET `faction`=35, `BaseAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2048 WHERE `entry`=218117; -- Infinite Riftmender +UPDATE `creature_template` SET `faction`=35, `speed_run`=1, `BaseAttackTime`=2000, `unit_flags`=33555200, `unit_flags2`=67110912, `unit_flags3`=16777216 WHERE `entry`=218068; -- [DNT] Example Anomaly +UPDATE `creature_template` SET `faction`=31, `speed_run`=0.857142865657806396, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=218056; -- Time Flies +UPDATE `creature_template` SET `faction`=127, `speed_run`=1, `BaseAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2048, `unit_flags3`=8388608 WHERE `entry`=217937; -- Infinite Proto-Drake +UPDATE `creature_template` SET `faction`=2105, `BaseAttackTime`=2000, `unit_flags`=256, `unit_flags2`=2048, `unit_flags3`=8388608 WHERE `entry`=217936; -- Infinite Watcher +UPDATE `creature_template` SET `faction`=2104, `BaseAttackTime`=2000, `unit_flags`=256, `unit_flags2`=2048, `unit_flags3`=8388608 WHERE `entry`=217934; -- Infinite Paradox +UPDATE `creature_template` SET `faction`=634, `BaseAttackTime`=2000, `unit_flags`=33554432, `unit_flags2`=67110912, `unit_flags3`=17301504 WHERE `entry`=217739; -- Timestorm +UPDATE `creature_template` SET `faction`=35, `npcflag`=1, `BaseAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2048 WHERE `entry`=217668; -- Momentus +UPDATE `creature_template` SET `faction`=35, `BaseAttackTime`=2000, `unit_flags`=768, `unit_flags2`=67110912, `unit_flags3`=16777216 WHERE `entry`=217666; -- Unstable Rift +UPDATE `creature_template` SET `faction`=35, `BaseAttackTime`=2000, `unit_flags`=33554432, `unit_flags2`=2048, `unit_flags3`=16777216 WHERE `entry`=217665; -- [DNT] Anvil Bunny +UPDATE `creature_template` SET `faction`=35, `npcflag`=129, `BaseAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2048 WHERE `entry`=217663; -- Erus +UPDATE `creature_template` SET `faction`=190, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=217613; -- Displaced Moment +UPDATE `creature_template` SET `faction`=16, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=217564; -- Archaios the Artificer +UPDATE `creature_template` SET `faction`=35, `BaseAttackTime`=2000, `unit_flags`=33555200, `unit_flags2`=2048, `unit_flags3`=16777216 WHERE `entry`=217560; -- [DNT] Dome Bunny +UPDATE `creature_template` SET `faction`=2576, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=217558; -- Displaced Tick +UPDATE `creature_template` SET `faction`=1711, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=217557; -- Infinite Ravager +UPDATE `creature_template` SET `faction`=16, `speed_walk`=1, `speed_run`=1.142857193946838378, `BaseAttackTime`=2000, `unit_flags`=64, `unit_flags2`=2048 WHERE `entry`=217190; -- Eratus, the Unwoven Paradox +UPDATE `creature_template` SET `faction`=1999, `BaseAttackTime`=2000, `unit_flags`=33554432, `unit_flags2`=2048 WHERE `entry`=217189; -- Displaced Moment +UPDATE `creature_template` SET `faction`=35, `BaseAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2048 WHERE `entry`=217060; -- Infinite Chronoweaver +UPDATE `creature_template` SET `faction`=35, `BaseAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2048 WHERE `entry` IN (217056, 217055); -- Infinite Scholar +UPDATE `creature_template` SET `faction`=35, `BaseAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2048 WHERE `entry`=217054; -- Infinite Acolyte +UPDATE `creature_template` SET `faction`=35, `npcflag`=129, `BaseAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2048 WHERE `entry`=217051; -- Horos +UPDATE `creature_template` SET `faction`=35, `npcflag`=3, `BaseAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2048 WHERE `entry`=216594; -- Moratari +UPDATE `creature_template` SET `faction`=35, `npcflag`=3, `BaseAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2048 WHERE `entry`=216591; -- Eternus +UPDATE `creature_template` SET `faction`=35, `BaseAttackTime`=2000, `unit_flags`=256, `unit_flags2`=67110912, `unit_flags3`=17334272 WHERE `entry`=213680; -- Invisible Bunny + +DELETE FROM `creature_template_movement` WHERE `CreatureId` IN (220526); +INSERT INTO `creature_template_movement` (`CreatureId`,`HoverInitiallyEnabled`,`Chase`,`Random`,`InteractionPauseTimer`) VALUES +(220526,1,0,0,NULL); + +-- Equipments +DELETE FROM `creature_equip_template` WHERE (`ID`=1 AND `CreatureID` IN (221105,218346,218148,217936,217934,217668,217564,217557,217058,217051)); +INSERT INTO `creature_equip_template` (`CreatureID`, `ID`, `ItemID1`, `AppearanceModID1`, `ItemVisual1`, `ItemID2`, `AppearanceModID2`, `ItemVisual2`, `ItemID3`, `AppearanceModID3`, `ItemVisual3`, `VerifiedBuild`) VALUES +(221105, 1, 88857, 0, 0, 0, 0, 0, 89875, 0, 0, 55142), -- Huojin Sentry +(218346, 1, 12993, 0, 0, 0, 0, 0, 0, 0, 0, 55142), -- Infinite Ravager +(218148, 1, 192148, 0, 0, 0, 0, 0, 0, 0, 0, 55142), -- Infinite Watcher +(217936, 1, 192148, 0, 0, 0, 0, 0, 0, 0, 0, 55142), -- Infinite Watcher +(217934, 1, 192148, 0, 0, 0, 0, 0, 0, 0, 0, 55142), -- Infinite Paradox +(217668, 1, 191228, 0, 0, 0, 0, 0, 0, 0, 0, 55142), -- Momentus +(217564, 1, 65653, 0, 0, 0, 0, 0, 0, 0, 0, 55142), -- Archaios the Artificer +(217557, 1, 12993, 0, 0, 0, 0, 0, 0, 0, 0, 55142), -- Infinite Ravager +(217058, 1, 192148, 0, 0, 0, 0, 0, 0, 0, 0, 55142), -- Infinite Watcher +(217051, 1, 78437, 0, 0, 0, 0, 0, 0, 0, 0, 55142); -- Horos + +-- Difficulties +DELETE FROM `creature_template_difficulty` WHERE (`DifficultyID`=0 AND `Entry` IN (217564,218346,218056,218148,217663,217558,218391,217666,217934,217189,217665,217190,217051,217739,216591,217560,217056,216594,217668,220524,218068,217557,217060,221105,218117,217058,217613,217937,217936,217054,220525,220526,217055)); +INSERT INTO `creature_template_difficulty` (`Entry`, `DifficultyID`, `HealthScalingExpansion`, `HealthModifier`, `ManaModifier`, `CreatureDifficultyID`, `TypeFlags`, `TypeFlags2`, `StaticFlags1`, `StaticFlags2`) VALUES +(217564, 0, 4, 4, 1, 267057, 2147483720, 0, 0, 0), -- Archaios the Artificer +(218346, 0, 4, 2, 1, 267851, 0, 0, 0, 0), -- Infinite Ravager +(218056, 0, 9, 0.5, 1, 267551, 0, 0, 0, 0), -- Time Flies +(218148, 0, 4, 6, 1, 267643, 4096, 0, 0, 0), -- Infinite Watcher +(217663, 0, 4, 1, 1, 267156, 134217728, 16384, 0, 0), -- Erus +(217558, 0, 4, 1, 1, 267051, 0, 0, 0, 0), -- Displaced Tick +(218391, 0, 4, 0.300000011920928955, 1, 267897, 0, 0, 0, 0), -- Displaced Moment +(217666, 0, 4, 1, 1, 267159, 1610612752, 117440518, 0, 0), -- Unstable Rift +(217934, 0, 4, 6, 1, 267427, 0, 0, 0, 0), -- Infinite Paradox +(217189, 0, 4, 0.300000011920928955, 1, 266680, 0, 0, 0, 0), -- Displaced Moment +(217665, 0, 4, 1, 1, 267158, 0, 0, 0, 0), -- [DNT] Anvil Bunny +(217190, 0, 4, 8, 1, 266681, 2147483720, 0, 0, 0), -- Eratus, the Unwoven Paradox +(217051, 0, 4, 1, 1, 266541, 134217728, 16384, 0, 0), -- Horos +(217739, 0, 4, 1, 1, 267232, 1610612752, 100663302, 0, 0), -- Timestorm +(216591, 0, 4, 50, 2, 266081, 4, 32768, 0, 0), -- Eternus +(217560, 0, 4, 1, 1, 267053, 0, 0, 0, 0), -- [DNT] Dome Bunny +(217056, 0, 4, 1, 1, 266546, 0, 0, 0, 0), -- Infinite Scholar +(216594, 0, 4, 5, 2, 266084, 0, 32768, 0, 0), -- Moratari +(217668, 0, 4, 1, 1, 267161, 0, 16384, 0, 0), -- Momentus +(220524, 0, 4, 1, 1, 270133, 1, 0, 0, 0), -- Great Turtle Hatchling +(218068, 0, 4, 1, 1, 267563, 1610612752, 117440518, 0, 0), -- [DNT] Example Anomaly +(217557, 0, 4, 1, 1, 267050, 0, 0, 0, 0), -- Infinite Ravager +(217060, 0, 4, 1, 1, 266550, 0, 0, 0, 0), -- Infinite Chronoweaver +(221105, 0, 4, 20, 1, 270733, 0, 0, 0, 0), -- Huojin Sentry +(218117, 0, 4, 1, 1, 267612, 0, 0, 0, 0), -- Infinite Riftmender +(217058, 0, 4, 6, 1, 266548, 4096, 0, 0, 0), -- Infinite Watcher +(217613, 0, 4, 0.800000011920928955, 1, 267106, 0, 0, 0, 0), -- Displaced Moment +(217937, 0, 4, 10, 1, 267432, 4, 0, 0, 0), -- Infinite Proto-Drake +(217936, 0, 4, 6, 1, 267429, 0, 0, 0, 0), -- Infinite Watcher +(217054, 0, 4, 1, 1, 266544, 0, 0, 0, 0), -- Infinite Acolyte +(220525, 0, 4, 1, 1, 270134, 1, 0, 0, 0), -- Young Albatross +(220526, 0, 4, 0.800000011920928955, 1, 270135, 536870912, 67108864, 0, 0), -- Displaced Anomaly +(217055, 0, 4, 1, 1, 266545, 0, 0, 0, 0); -- Infinite Scholar + +UPDATE `creature_template_difficulty` SET `ContentTuningID`=169, `StaticFlags1`=268435456, `VerifiedBuild`=55142 WHERE (`Entry`=221105 AND `DifficultyID`=0); -- 221105 (Huojin Sentry) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2851, `StaticFlags1`=536871168, `VerifiedBuild`=55142 WHERE (`Entry`=220526 AND `DifficultyID`=0); -- 220526 (Displaced Anomaly) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2851, `StaticFlags1`=805306368, `VerifiedBuild`=55142 WHERE (`Entry`=220525 AND `DifficultyID`=0); -- 220525 (Young Albatross) - CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2851, `StaticFlags1`=268435456, `VerifiedBuild`=55142 WHERE (`Entry`=220524 AND `DifficultyID`=0); -- 220524 (Great Turtle Hatchling) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2851, `StaticFlags1`=268435712, `VerifiedBuild`=55142 WHERE (`Entry`=218391 AND `DifficultyID`=0); -- 218391 (Displaced Moment) - Sessile, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2851, `VerifiedBuild`=55142 WHERE (`Entry`=218346 AND `DifficultyID`=0); -- 218346 (Infinite Ravager) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2793, `StaticFlags1`=268435456, `VerifiedBuild`=55142 WHERE (`Entry`=218148 AND `DifficultyID`=0); -- 218148 (Infinite Watcher) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2793, `StaticFlags1`=268435456, `VerifiedBuild`=55142 WHERE (`Entry`=218117 AND `DifficultyID`=0); -- 218117 (Infinite Riftmender) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2851, `StaticFlags1`=536870912, `VerifiedBuild`=55142 WHERE (`Entry`=218068 AND `DifficultyID`=0); -- 218068 ([DNT] Example Anomaly) - Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=81, `StaticFlags1`=536870912, `VerifiedBuild`=55142 WHERE (`Entry`=218056 AND `DifficultyID`=0); -- 218056 (Time Flies) - Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2793, `StaticFlags1`=536870912, `VerifiedBuild`=55142 WHERE (`Entry`=217937 AND `DifficultyID`=0); -- 217937 (Infinite Proto-Drake) - Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2793, `VerifiedBuild`=55142 WHERE (`Entry`=217936 AND `DifficultyID`=0); -- 217936 (Infinite Watcher) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2793, `StaticFlags1`=536871168, `VerifiedBuild`=55142 WHERE (`Entry`=217934 AND `DifficultyID`=0); -- 217934 (Infinite Paradox) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2851, `VerifiedBuild`=55142 WHERE (`Entry`=217739 AND `DifficultyID`=0); -- 217739 (Timestorm) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=57, `StaticFlags1`=268435456, `VerifiedBuild`=55142 WHERE (`Entry`=217668 AND `DifficultyID`=0); -- 217668 (Momentus) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2851, `StaticFlags1`=536871168, `VerifiedBuild`=55142 WHERE (`Entry`=217666 AND `DifficultyID`=0); -- 217666 (Unstable Rift) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2851, `StaticFlags1`=536870912, `VerifiedBuild`=55142 WHERE (`Entry`=217665 AND `DifficultyID`=0); -- 217665 ([DNT] Anvil Bunny) - Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2793, `StaticFlags1`=268435456, `VerifiedBuild`=55142 WHERE (`Entry`=217663 AND `DifficultyID`=0); -- 217663 (Erus) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2851, `VerifiedBuild`=55142 WHERE (`Entry`=217613 AND `DifficultyID`=0); -- 217613 (Displaced Moment) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2851, `StaticFlags1`=268435456, `VerifiedBuild`=55142 WHERE (`Entry`=217564 AND `DifficultyID`=0); -- 217564 (Archaios the Artificer) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2851, `StaticFlags1`=536871168, `VerifiedBuild`=55142 WHERE (`Entry`=217560 AND `DifficultyID`=0); -- 217560 ([DNT] Dome Bunny) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2851, `StaticFlags1`=536870912, `VerifiedBuild`=55142 WHERE (`Entry`=217558 AND `DifficultyID`=0); -- 217558 (Displaced Tick) - Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2851, `VerifiedBuild`=55142 WHERE (`Entry`=217557 AND `DifficultyID`=0); -- 217557 (Infinite Ravager) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2851, `StaticFlags1`=536871168, `VerifiedBuild`=55142 WHERE (`Entry`=217190 AND `DifficultyID`=0); -- 217190 (Eratus, the Unwoven Paradox) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2851, `StaticFlags1`=268435456, `VerifiedBuild`=55142 WHERE (`Entry`=217189 AND `DifficultyID`=0); -- 217189 (Displaced Moment) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2851, `StaticFlags1`=268435456, `VerifiedBuild`=55142 WHERE (`Entry`=217060 AND `DifficultyID`=0); -- 217060 (Infinite Chronoweaver) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2851, `StaticFlags1`=268435456, `VerifiedBuild`=55142 WHERE (`Entry`=217058 AND `DifficultyID`=0); -- 217058 (Infinite Watcher) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2793, `StaticFlags1`=268435456, `VerifiedBuild`=55142 WHERE (`Entry`=217056 AND `DifficultyID`=0); -- 217056 (Infinite Scholar) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2793, `StaticFlags1`=268435456, `VerifiedBuild`=55142 WHERE (`Entry`=217055 AND `DifficultyID`=0); -- 217055 (Infinite Scholar) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2793, `StaticFlags1`=268435456, `VerifiedBuild`=55142 WHERE (`Entry`=217054 AND `DifficultyID`=0); -- 217054 (Infinite Acolyte) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=657, `StaticFlags1`=268435456, `VerifiedBuild`=55142 WHERE (`Entry`=217051 AND `DifficultyID`=0); -- 217051 (Horos) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2793, `StaticFlags1`=268435456, `VerifiedBuild`=55142 WHERE (`Entry`=216594 AND `DifficultyID`=0); -- 216594 (Moratari) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2793, `StaticFlags1`=268435456, `VerifiedBuild`=55142 WHERE (`Entry`=216591 AND `DifficultyID`=0); -- 216591 (Eternus) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2793, `StaticFlags1`=536871168, `VerifiedBuild`=55142 WHERE (`Entry`=213680 AND `DifficultyID`=0); -- 213680 (Invisible Bunny) - Sessile, Floating + +UPDATE `creature_questitem` SET `VerifiedBuild`=55142 WHERE (`CreatureEntry`=72767 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=72766 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=217557 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=72764 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=72764 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=73166 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=217564 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=72765 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=72765 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=72841 AND `DifficultyID`=0 AND `Idx`=0); +UPDATE `creature_quest_currency` SET `VerifiedBuild`=55142 WHERE (`CurrencyId`=738 AND `CreatureId` IN (72767,71986,71987,73279,72766,217557,218391,72764,73166,72765,220524,72841,217189,217558)) OR (`CurrencyId`=777 AND `CreatureId` IN (72767,71986,71987,73279,72766,72764,73166,72765,72841)) OR (`CurrencyId`=2778 AND `CreatureId` IN (72767,71986,71987,73279,72766,217557,218391,72764,73166,72765,220524,72841,217189,217558)); + +-- Vendors +DELETE FROM `npc_vendor` WHERE (`entry`=217663 AND `item`=224081 AND `ExtendedCost`=9038 AND `type`=1) OR (`entry`=217663 AND `item`=224078 AND `ExtendedCost`=9038 AND `type`=1) OR (`entry`=217663 AND `item`=224077 AND `ExtendedCost`=9038 AND `type`=1) OR (`entry`=217663 AND `item`=224076 AND `ExtendedCost`=9038 AND `type`=1) OR (`entry`=217663 AND `item`=224075 AND `ExtendedCost`=9038 AND `type`=1) OR (`entry`=217663 AND `item`=224080 AND `ExtendedCost`=9038 AND `type`=1) OR (`entry`=217663 AND `item`=224079 AND `ExtendedCost`=9038 AND `type`=1) OR (`entry`=217051 AND `item`=213598 AND `ExtendedCost`=8860 AND `type`=1) OR (`entry`=217051 AND `item`=213621 AND `ExtendedCost`=8859 AND `type`=1) OR (`entry`=217051 AND `item`=213624 AND `ExtendedCost`=8859 AND `type`=1) OR (`entry`=217051 AND `item`=213609 AND `ExtendedCost`=8558 AND `type`=1) OR (`entry`=217051 AND `item`=213604 AND `ExtendedCost`=8558 AND `type`=1) OR (`entry`=217051 AND `item`=213584 AND `ExtendedCost`=8558 AND `type`=1) OR (`entry`=217051 AND `item`=86588 AND `ExtendedCost`=8551 AND `type`=1) OR (`entry`=217051 AND `item`=86583 AND `ExtendedCost`=8553 AND `type`=1) OR (`entry`=217051 AND `item`=86589 AND `ExtendedCost`=8553 AND `type`=1); +INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `ExtendedCost`, `type`, `PlayerConditionID`, `IgnoreFiltering`, `VerifiedBuild`) VALUES +(217663, 7, 224081, 0, 9038, 1, 0, 0, 55142), -- Timerunner's Staff +(217663, 6, 224078, 0, 9038, 1, 0, 0, 55142), -- Timerunner's Shield +(217663, 5, 224077, 0, 9038, 1, 0, 0, 55142), -- Timerunner's Dagger +(217663, 4, 224076, 0, 9038, 1, 0, 0, 55142), -- Timerunner's Bow +(217663, 3, 224075, 0, 9038, 1, 0, 0, 55142), -- Timerunner's Greatsword +(217663, 2, 224080, 0, 9038, 1, 0, 0, 55142), -- Timerunner's Sword +(217663, 1, 224079, 0, 9038, 1, 0, 0, 55142), -- Timerunner's Mace +(217051, 10, 213598, 0, 8860, 1, 0, 0, 55142), -- Reins of the Dashing Windsteed +(217051, 9, 213621, 0, 8859, 1, 0, 0, 55142), -- Reins of the Jade Pterrordax +(217051, 8, 213624, 0, 8859, 1, 0, 0, 55142), -- Cobalt Juggernaut +(217051, 7, 213609, 0, 8558, 1, 0, 0, 55142), -- Reins of the Little Red Riding Goat +(217051, 6, 213604, 0, 8558, 1, 0, 0, 55142), -- Reins of the Tropical Riding Crane +(217051, 5, 213584, 0, 8558, 1, 0, 0, 55142), -- Mogu Hazeblazer +(217051, 4, 86588, 0, 8551, 1, 0, 0, 55142), -- Pandaren Firework Launcher +(217051, 3, 86583, 0, 8553, 1, 0, 0, 55142), -- Salyin Battle Banner +(217051, 2, 86589, 0, 8553, 1, 0, 0, 55142); -- Ai-Li's Skymirror + +-- Models +DELETE FROM `creature_model_info` WHERE `DisplayID` IN (117269, 79809, 113585, 117640, 115650, 117176, 115649, 113019, 113074, 112575, 112277, 112276, 116857, 116856, 116855, 116688, 112713); +INSERT INTO `creature_model_info` (`DisplayID`, `BoundingRadius`, `CombatReach`, `DisplayID_Other_Gender`, `VerifiedBuild`) VALUES +(117269, 0.872754871845245361, 0, 0, 55142), +(79809, 1.51990509033203125, 0, 0, 55142), +(113585, 1, 6, 0, 55142), +(117640, 0.699999988079071044, 0.699999988079071044, 0, 55142), +(115650, 1.168302655220031738, 1.5, 0, 55142), +(117176, 1.402945518493652343, 1.5, 0, 55142), +(115649, 1.404254555702209472, 2.40000009536743164, 0, 55142), +(113019, 1.168302655220031738, 1.5, 0, 55142), +(113074, 5.177106857299804687, 3.5, 0, 55142), +(112575, 1.132115364074707031, 1.5, 0, 55142), +(112277, 1.755318164825439453, 3, 0, 55142), +(112276, 1.755318164825439453, 3, 0, 55142), +(116857, 0.382999986410140991, 1.5, 0, 55142), +(116856, 0.305999994277954101, 1.5, 0, 55142), +(116855, 1.755318164825439453, 3, 0, 55142), +(116688, 0.382999986410140991, 1.5, 0, 55142), +(112713, 0.305999994277954101, 1.5, 0, 55142); + +UPDATE `creature_model_info` SET `VerifiedBuild`=55142 WHERE `DisplayID` IN (51409, 44778, 56187, 20515, 51412, 11686, 51320, 51317, 51289, 51276, 51273, 42317, 37338, 50898, 50772, 50962, 51125, 51128, 49246, 25074, 25073, 25076, 25075, 12196, 12195, 49234, 49235, 49236, 49237, 51314); +UPDATE `creature_model_info` SET `BoundingRadius`=4.553055763244628906, `CombatReach`=4.375, `VerifiedBuild`=55142 WHERE `DisplayID`=19326; +UPDATE `creature_model_info` SET `BoundingRadius`=0.225000008940696716, `CombatReach`=0.75, `VerifiedBuild`=55142 WHERE `DisplayID`=74071; +UPDATE `creature_model_info` SET `BoundingRadius`=1, `VerifiedBuild`=55142 WHERE `DisplayID`=47677; +UPDATE `creature_model_info` SET `BoundingRadius`=5, `CombatReach`=6.25, `VerifiedBuild`=55142 WHERE `DisplayID`=51146; +UPDATE `creature_model_info` SET `BoundingRadius`=1.311424016952514648, `CombatReach`=1.5, `VerifiedBuild`=55142 WHERE `DisplayID`=51381; +UPDATE `creature_model_info` SET `BoundingRadius`=0.520871341228485107, `CombatReach`=0.375, `VerifiedBuild`=55142 WHERE `DisplayID`=61127; +UPDATE `creature_model_info` SET `BoundingRadius`=0.090000003576278686, `CombatReach`=0.300000011920928955, `VerifiedBuild`=55142 WHERE `DisplayID`=30402; + +UPDATE `creature_template_model` SET `VerifiedBuild`=55142 WHERE (`Idx`=0 AND `CreatureID` IN (73166,217564,72841,165189,218346,71954,218056,60941,218148,69066,73385,217663,71955,64993,71939,73512,217558,71486,217666,72764,70356,218391,68288,73487,217934,217189,304,73531,217739,216591,305,217190,72765,40725,73403,221105,71952,218117,217058,25064,73398,73279,71988,220526,73303,32158,54879,217051,56921,73514,35362,59072,356,217665,54423,72780,71953,31698,18379,73362,217055,65011,40625,72767,71987,217937,217936,217054,220525,28363,217557,217060,28302,73353,217560,217056,14505,72766,217613,40165,71986,216594,217668,220524,218068,54741,47654)) OR (`Idx`=1 AND `CreatureID` IN (73512,73487,40725,217058,73514,71987,40165,71986)) OR (`Idx`=3 AND `CreatureID` IN (71987,71986)) OR (`Idx`=2 AND `CreatureID` IN (71987,71986)); + +-- Gameobject templates +DELETE FROM `gameobject_template` WHERE `entry` IN (423410 /*Anvil of Ephemeralities*/, 423343 /*Unstable Rift*/, 423103 /*Time Rift*/, 451226 /*Unraveling Sands*/, 424197 /*Bronze Barrier*/); +INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `size`, `Data0`, `Data1`, `Data2`, `Data3`, `Data4`, `Data5`, `Data6`, `Data7`, `Data8`, `Data9`, `Data10`, `Data11`, `Data12`, `Data13`, `Data14`, `Data15`, `Data16`, `Data17`, `Data18`, `Data19`, `Data20`, `Data21`, `Data22`, `Data23`, `Data24`, `Data25`, `Data26`, `Data27`, `Data28`, `Data29`, `Data30`, `Data31`, `Data32`, `Data33`, `Data34`, `ContentTuningId`, `VerifiedBuild`) VALUES +(423410, 8, 87800, 'Anvil of Ephemeralities', '', '', '', 3, 1, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2851, 55142), -- Anvil of Ephemeralities +(423343, 10, 76234, 'Unstable Rift', 'inspect', 'Investigating', '', 3, 3492, 0, 0, 3000, 0, 0, 0, 0, 0, 0, 439809, 0, 0, 1, 193761, 0, 0, 0, 0, 0, 0, 0, 119615, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 55142), -- Unstable Rift +(423103, 5, 83572, 'Time Rift', '', '', '', 1, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2851, 55142), -- Time Rift +(451226, 48, 12628, 'Unraveling Sands', '', '', '', 0.349999994039535522, 2, 1, 0, 2055, 7, 500, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2793, 55142), -- Unraveling Sands +(424197, 0, 6391, 'Bronze Barrier', '', '', '', 3, 0, 0, 1, 0, 0, 0, 0, 21439, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 55142); -- Bronze Barrier + +DELETE FROM `gameobject_template_addon` WHERE `entry` IN (423343 /*Unstable Rift*/, 423103 /*Time Rift*/, 451226 /*Unraveling Sands*/, 424197 /*Bronze Barrier*/); +INSERT INTO `gameobject_template_addon` (`entry`, `faction`, `flags`, `WorldEffectID`, `AIAnimKitID`) VALUES +(423343, 0, 32, 0, 5605), -- Unstable Rift +(423103, 0, 612368416, 0, 0), -- Time Rift +(451226, 0, 545259520, 11127, 6714), -- Unraveling Sands +(424197, 0, 32, 0, 0); -- Bronze Barrier + +-- Quests +DELETE FROM `quest_template` WHERE `ID`=79432; +INSERT INTO `quest_template` (`ID`, `QuestType`, `QuestPackageID`, `ContentTuningID`, `QuestSortID`, `QuestInfoID`, `SuggestedGroupNum`, `RewardNextQuest`, `RewardXPDifficulty`, `RewardXPMultiplier`, `RewardMoneyDifficulty`, `RewardMoneyMultiplier`, `RewardSpell`, `RewardHonor`, `RewardKillHonor`, `StartItem`, `RewardArtifactXPDifficulty`, `RewardArtifactXPMultiplier`, `RewardArtifactCategoryID`, `Flags`, `FlagsEx`, `FlagsEx2`, `RewardSkillLineID`, `RewardNumSkillUps`, `PortraitGiver`, `PortraitGiverMount`, `PortraitGiverModelSceneID`, `PortraitTurnIn`, `RewardItem1`, `RewardItem2`, `RewardItem3`, `RewardItem4`, `RewardAmount1`, `RewardAmount2`, `RewardAmount3`, `RewardAmount4`, `ItemDrop1`, `ItemDrop2`, `ItemDrop3`, `ItemDrop4`, `ItemDropQuantity1`, `ItemDropQuantity2`, `ItemDropQuantity3`, `ItemDropQuantity4`, `RewardChoiceItemID1`, `RewardChoiceItemID2`, `RewardChoiceItemID3`, `RewardChoiceItemID4`, `RewardChoiceItemID5`, `RewardChoiceItemID6`, `RewardChoiceItemQuantity1`, `RewardChoiceItemQuantity2`, `RewardChoiceItemQuantity3`, `RewardChoiceItemQuantity4`, `RewardChoiceItemQuantity5`, `RewardChoiceItemQuantity6`, `RewardChoiceItemDisplayID1`, `RewardChoiceItemDisplayID2`, `RewardChoiceItemDisplayID3`, `RewardChoiceItemDisplayID4`, `RewardChoiceItemDisplayID5`, `RewardChoiceItemDisplayID6`, `POIContinent`, `POIx`, `POIy`, `POIPriority`, `RewardTitle`, `RewardArenaPoints`, `RewardFactionID1`, `RewardFactionID2`, `RewardFactionID3`, `RewardFactionID4`, `RewardFactionID5`, `RewardFactionValue1`, `RewardFactionValue2`, `RewardFactionValue3`, `RewardFactionValue4`, `RewardFactionValue5`, `RewardFactionCapIn1`, `RewardFactionCapIn2`, `RewardFactionCapIn3`, `RewardFactionCapIn4`, `RewardFactionCapIn5`, `RewardFactionOverride1`, `RewardFactionOverride2`, `RewardFactionOverride3`, `RewardFactionOverride4`, `RewardFactionOverride5`, `RewardFactionFlags`, `AreaGroupID`, `TimeAllowed`, `AllowableRaces`, `TreasurePickerID`, `Expansion`, `ManagedWorldStateID`, `QuestSessionBonus`, `LogTitle`, `LogDescription`, `QuestDescription`, `AreaDescription`, `QuestCompletionLog`, `RewardCurrencyID1`, `RewardCurrencyID2`, `RewardCurrencyID3`, `RewardCurrencyID4`, `RewardCurrencyQty1`, `RewardCurrencyQty2`, `RewardCurrencyQty3`, `RewardCurrencyQty4`, `PortraitGiverText`, `PortraitGiverName`, `PortraitTurnInText`, `PortraitTurnInName`, `AcceptedSoundKitID`, `CompleteSoundKitID`, `VerifiedBuild`) VALUES +(79432, 2, 0, 2793, -639, 282, 0, 79433, 5, 1, 5, 1, 0, 0, 0, 0, 0, 1, 0, 36700160, 0, 0, 0, 0, 19326, 0, 834, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 0, 4, 0, 0, 'It\'s About Time', 'Slay Archaios the Artificer.', 'Your timing is serendipitous. I require your assistance.\n\nNot all infinites have seen what Nozdormu has shown me. Not all would agree even if they had. Archaios is one such detractor. He must be eliminated.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 'This lieutenant has been causing collateral damage to the timeline in his hunger for temporal artifacts.', 'Archaios the Artificer', '', '', 890, 878, 55142); -- It's About Time + +UPDATE `quest_poi` SET `VerifiedBuild`=55142 WHERE (`QuestID`=79432 AND `BlobIndex`=0 AND `Idx1`=3) OR (`QuestID`=79432 AND `BlobIndex`=0 AND `Idx1`=2) OR (`QuestID`=79432 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=79432 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=53435 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=53435 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=32009 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=32009 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=32008 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=32008 AND `BlobIndex`=0 AND `Idx1`=0); + +UPDATE `quest_poi_points` SET `VerifiedBuild`=55142 WHERE (`QuestID`=79432 AND `Idx1`=3 AND `Idx2`=0) OR (`QuestID`=79432 AND `Idx1`=2 AND `Idx2`=0) OR (`QuestID`=79432 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=79432 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=53435 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=53435 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=32009 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=32009 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=32008 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=32008 AND `Idx1`=0 AND `Idx2`=0); + +DELETE FROM `quest_details` WHERE `ID`=79432; +INSERT INTO `quest_details` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `VerifiedBuild`) VALUES +(79432, 0, 0, 0, 0, 0, 0, 0, 0, 55142); -- It's About Time + +DELETE FROM `quest_request_items` WHERE `ID`=79432; +INSERT INTO `quest_request_items` (`ID`, `EmoteOnComplete`, `EmoteOnIncomplete`, `EmoteOnCompleteDelay`, `EmoteOnIncompleteDelay`, `CompletionText`, `VerifiedBuild`) VALUES +(79432, 396, 396, 0, 0, 'The other infinites jeopardize our mission. We cannot let them wreak havoc on the timeways.', 0); -- It's About Time + +DELETE FROM `quest_objectives` WHERE `ID` IN (446716 /*446716*/, 446695 /*446695*/, 447709 /*447709*/); +INSERT INTO `quest_objectives` (`ID`, `QuestID`, `Type`, `Order`, `StorageIndex`, `ObjectID`, `Amount`, `Flags`, `Flags2`, `ProgressBarWeight`, `Description`, `VerifiedBuild`) VALUES +(446716, 79432, 1, 2, 1, 213631, 1, 2, 1, 0, 'Archaios\'s artifact taken', 55142), -- 446716 +(446695, 79432, 0, 1, 0, 217564, 1, 1, 0, 0, '', 55142), -- 446695 +(447709, 79432, 0, 0, 4, 219712, 1, 4, 0, 0, 'Investigate the Unstable Rift', 55142); -- 447709 + +DELETE FROM `quest_visual_effect` WHERE (`Index`=0 AND `ID` IN (446716,446695,447709)); +INSERT INTO `quest_visual_effect` (`ID`, `Index`, `VisualEffect`, `VerifiedBuild`) VALUES +(446716, 0, 25088, 55142), +(446695, 0, 2101, 55142), +(447709, 0, 25456, 55142); + +DELETE FROM `creature_queststarter` WHERE (`id`=216591 AND `quest`=79432); +INSERT INTO `creature_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES +(216591, 79432, 55142); -- It's About Time offered by Eternus + +DELETE FROM `creature_questender` WHERE (`id`=216591 AND `quest`=79432); +INSERT INTO `creature_questender` (`id`, `quest`, `VerifiedBuild`) VALUES +(216591, 79432, 55142); -- It's About Time ended by Eternus |