diff options
| -rw-r--r-- | sql/updates/world/master/2022_04_02_00_world.sql | 203 |
1 files changed, 203 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_04_02_00_world.sql b/sql/updates/world/master/2022_04_02_00_world.sql new file mode 100644 index 00000000000..d02b54a810c --- /dev/null +++ b/sql/updates/world/master/2022_04_02_00_world.sql @@ -0,0 +1,203 @@ +SET @CGUID := 1050920; +SET @OGUID := 600216; + +DELETE FROM `phase_name` WHERE `ID` IN (17913, 17911, 17912, 17914); +INSERT INTO `phase_name` (`ID`, `Name`) VALUES +(17913, 'Zereth Mortis Haven Night Fae Anima Courier'), +(17911, 'Zereth Mortis Haven Kyrian Anima Courier'), +(17912, 'Zereth Mortis Haven Venthyr Anima Courier'), +(17914, 'Zereth Mortis Haven Necrolord Anima Courier'); + +-- Creatures +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+3; +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES +-- Nightfae +(@CGUID+0, 184240, 2374, 13536, 13632, '0', 17913, 0, 0, 0, -4237.97900390625, 724.5850830078125, -45.1217269897460937, 4.633160591125488281, 7200, 0, 0, 149435, 0, 0, 0, 0, 0, 42979), -- Aliotha (Area: -Unknown- - Difficulty: 0) +-- Kyrian +(@CGUID+1, 184239, 2374, 13536, 13632, '0', 17911, 0, 0, 0, -4237.86962890625, 724.58331298828125, -45.1217536926269531, 4.619889736175537109, 7200, 0, 0, 149435, 0, 0, 0, 0, 0, 42979), -- Hipponius (Area: -Unknown- - Difficulty: 0) +-- Venthyr +(@CGUID+2, 184242, 2374, 13536, 13632, '0', 17912, 0, 0, 0, -4237.984375, 724.32293701171875, -45.1216621398925781, 4.631205558776855468, 7200, 0, 0, 149435, 0, 0, 0, 0, 0, 42979), -- Edwardi (Area: -Unknown- - Difficulty: 0) +-- Necrolord +(@CGUID+3, 184241, 2374, 13536, 13632, '0', 17914, 0, 0, 0, -4238.2568359375, 724.4305419921875, -45.1216201782226562, 4.666056156158447265, 7200, 0, 0, 149435, 0, 0, 0, 0, 0, 42979); -- Brakka Noct (Area: -Unknown- - Difficulty: 0) + +-- GameObject +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+8; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES +-- Nightfae +(@OGUID+0, 376060, 2374, 13536, 13632, '0', 17913, 0, -4235.15478515625, 723.08331298828125, -45.2253303527832031, 3.234871387481689453, -0.2457442283630371, -0.39219188690185546, -0.87279987335205078, 0.154969885945320129, 7200, 255, 1, 42979), -- Anima Canister (Area: -Unknown- - Difficulty: 0) +(@OGUID+1, 376060, 2374, 13536, 13632, '0', 17913, 0, -4236.14599609375, 723.16668701171875, -45.20758056640625, 4.70120859146118164, -0.29909372329711914, -0.05707645416259765, -0.70823383331298828, 0.636938035488128662, 7200, 255, 1, 42979), -- Anima Canister (Area: -Unknown- - Difficulty: 0) +(@OGUID+2, 376060, 2374, 13536, 13632, '0', 17913, 0, -4236.82275390625, 724.73089599609375, -45.221771240234375, 5.139094352722167968, -0.02048301696777343, 0.351384162902832031, -0.45244693756103515, 0.819390833377838134, 7200, 255, 1, 42979), -- Anima Canister (Area: -Unknown- - Difficulty: 0) +-- Kyrian +(@OGUID+3, 376057, 2374, 13536, 13632, '0', 17911, 0, -4236.26025390625, 723.4149169921875, -45.2074089050292968, 4.619890213012695312, 0, 0, -0.73904228210449218, 0.673659086227416992, 7200, 255, 1, 42979), -- Anima Canister (Area: -Unknown- - Difficulty: 0) +(@OGUID+4, 376057, 2374, 13536, 13632, '0', 17911, 0, -4234.7431640625, 722.5399169921875, -45.2193489074707031, 3.510786771774291992, 0, 0, -0.98301029205322265, 0.183550402522087097, 7200, 255, 1, 42979), -- Anima Canister (Area: -Unknown- - Difficulty: 0) +-- Venthyr +(@OGUID+5, 376058, 2374, 13536, 13632, '0', 17912, 0, -4234.63916015625, 722.52081298828125, -45.2225227355957031, 3.47400665283203125, 0, 0, -0.98621940612792968, 0.165442705154418945, 7200, 255, 1, 42979), -- Anima Canister (Area: -Unknown- - Difficulty: 0) +(@OGUID+6, 376058, 2374, 13536, 13632, '0', 17912, 0, -4236.12158203125, 723.36114501953125, -45.2076797485351562, 4.631206035614013671, 0, 0, -0.73521900177001953, 0.677829682826995849, 7200, 255, 1, 42979), -- Anima Canister (Area: -Unknown- - Difficulty: 0) +-- Necrolord +(@OGUID+7, 376059, 2374, 13536, 13632, '0', 17914, 0, -4236.04150390625, 723.5850830078125, -41.1788063049316406, 4.648786544799804687, -0.04558849334716796, -0.03080558776855468, -0.72845268249511718, 0.682883143424987792, 7200, 255, 1, 42979), -- Anima Canister (Area: -Unknown- - Difficulty: 0) +(@OGUID+8, 376059, 2374, 13536, 13632, '0', 17914, 0, -4234.69775390625, 722.56597900390625, -41.6089820861816406, 4.029964447021484375, 0, 0, -0.90296077728271484, 0.429722934961318969, 7200, 255, 1, 42979); -- Anima Canister (Area: -Unknown- - Difficulty: 0) + +-- Creature Template +UPDATE `creature_template` SET `gossip_menu_id`=27513, `minlevel`=60, `maxlevel`=60, `faction`=3192, `npcflag`=1, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=184240; -- Aliotha +UPDATE `creature_template` SET `gossip_menu_id`=27515, `minlevel`=60, `maxlevel`=60, `faction`=3176, `npcflag`=1, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=184242; -- Edwardi +UPDATE `creature_template` SET `gossip_menu_id`=27512, `minlevel`=60, `maxlevel`=60, `faction`=3166, `npcflag`=1, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=184239; -- Hipponius +UPDATE `creature_template` SET `gossip_menu_id`=27514, `minlevel`=60, `maxlevel`=60, `faction`=3171, `npcflag`=1, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=184241; -- Brakka Noct + +-- GameObject Template +DELETE FROM `gameobject_template` WHERE `entry` IN (376057, 376058, 376059); +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 +(376057, 5, 59644, 'Anima Canister', '', '', '', 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, 0, 0, 0, 0, 2057, 42979), -- Anima Canister +(376058, 5, 59976, 'Anima Canister', '', '', '', 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, 0, 0, 0, 0, 2057, 42979), -- Anima Canister +(376059, 5, 60222, 'Anima Canister', '', '', '', 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, 0, 0, 0, 0, 2057, 42979); -- Anima Canister + +-- Gossip +DELETE FROM `gossip_menu` WHERE (`MenuID`=27513 AND `TextID`=43861) OR (`MenuID`=27512 AND `TextID`=43859) OR (`MenuID`=27515 AND `TextID`=43862) OR (`MenuID`=27514 AND `TextID`=43860); +INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES +(27513, 43861, 42979), -- 184240 (Aliotha) +(27512, 43859, 42979), -- 184239 (Hipponius) +(27515, 43862, 42979), -- 184242 (Edwardi) +(27514, 43860, 42979); -- 184241 (Brakka Noct) + +DELETE FROM `gossip_menu_option` WHERE (`MenuID` = 27512 AND `OptionID` = 0) OR (`MenuID` = 27513 AND `OptionID` = 0) OR (`MenuID` = 27514 AND `OptionID` = 0) OR (`MenuID` = 27515 AND `OptionID` = 0); +INSERT INTO `gossip_menu_option` (`MenuID`, `OptionID`, `OptionIcon`, `OptionText`, `OptionBroadcastTextId`, `OptionType`, `OptionNpcFlag`, `Language`, `ActionMenuID`, `ActionPoiID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `VerifiedBuild`) VALUES +(27512, 0, 0, 'Deliver my Anima.', 0, 1, 1, 0, 0, 0, 0, 0, NULL, 0, 42979), +(27513, 0, 0, 'Deliver my Anima.', 0, 1, 1, 0, 0, 0, 0, 0, NULL, 0, 42979), +(27514, 0, 0, 'Deliver my Anima.', 0, 1, 1, 0, 0, 0, 0, 0, NULL, 0, 42979), +(27515, 0, 0, 'Deliver my Anima.', 0, 1, 1, 0, 0, 0, 0, 0, NULL, 0, 42979); + +-- NPC Text +DELETE FROM `npc_text` WHERE `ID` IN (43861 /*43861*/, 43859 /*43859*/, 43862 /*43862*/, 43860 /*43860*/); +INSERT INTO `npc_text` (`ID`, `Probability0`, `Probability1`, `Probability2`, `Probability3`, `Probability4`, `Probability5`, `Probability6`, `Probability7`, `BroadcastTextId0`, `BroadcastTextId1`, `BroadcastTextId2`, `BroadcastTextId3`, `BroadcastTextId4`, `BroadcastTextId5`, `BroadcastTextId6`, `BroadcastTextId7`, `VerifiedBuild`) VALUES +(43861, 0, 0, 0, 0, 0, 0, 0, 0, 214884, 0, 0, 0, 0, 0, 0, 0, 42979), -- 43861 +(43859, 0, 0, 0, 0, 0, 0, 0, 0, 214882, 0, 0, 0, 0, 0, 0, 0, 42979), -- 43859 +(43862, 0, 0, 0, 0, 0, 0, 0, 0, 214886, 0, 0, 0, 0, 0, 0, 0, 42979), -- 43862 +(43860, 0, 0, 0, 0, 0, 0, 0, 0, 214885, 0, 0, 0, 0, 0, 0, 0, 42979); -- 43860 + +-- Scaling and Modelstuff Oribos + Zereth Mortis +DELETE FROM `creature_template_scaling` WHERE (`DifficultyID`=0 AND `Entry` IN (184240,185279,184239,184242,184055,181028,181490,185282,185285,178909,184071,185457,55455,185488,181361,178098,183143,180961,178015,180936,182769,183903,178936,180918,183677,180916,180948,180650,182257,181183,184934,180931,180920,184241,178895,180933,180927,185702,180926,182218,180052,183963,180923,182245,177486,184487,184486,185713,177476,183378,180950,178016,182681,172538,181003,180715,178094,178196,177432,181006,185807,185291,180956,178913)); +INSERT INTO `creature_template_scaling` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `VerifiedBuild`) VALUES +(184240, 0, 0, 0, 2057, 42979), +(185279, 0, 0, 0, 837, 42979), +(184239, 0, 0, 0, 2057, 42979), +(184242, 0, 0, 0, 2057, 42979), +(184055, 0, 0, 0, 2057, 42979), +(181028, 0, 0, 0, 2057, 42979), +(181490, 0, 0, 0, 2057, 42979), +(185282, 0, 0, 0, 2057, 42979), +(185285, 0, 0, 0, 2057, 42979), +(178909, 0, 0, 0, 2170, 42979), +(184071, 0, 0, 0, 2057, 42979), +(185457, 0, 0, 0, 2057, 42979), +(55455, 0, 2, 2, 328, 42979), +(185488, 0, 0, 0, 2057, 42979), +(181361, 0, 0, 0, 81, 42979), +(178098, 0, 0, 0, 2170, 42979), +(183143, 0, 0, 0, 371, 42979), +(180961, 0, 0, 0, 2057, 42979), +(178015, 0, 0, 0, 2057, 42979), +(180936, 0, 0, 0, 2057, 42979), +(182769, 0, 0, 0, 371, 42979), +(183903, 0, 0, 0, 2057, 42979), +(178936, 0, 0, 0, 2170, 42979), +(180918, 0, 0, 0, 2057, 42979), +(183677, 0, 0, 0, 2057, 42979), +(180916, 0, 0, 0, 2057, 42979), +(180948, 0, 0, 0, 2057, 42979), +(180650, 0, 0, 0, 2057, 42979), +(182257, 0, 0, 0, 2057, 42979), +(181183, 0, 0, 0, 2057, 42979), +(184934, 0, 0, 0, 2057, 42979), +(180931, 0, 0, 0, 2057, 42979), +(180920, 0, 0, 0, 2057, 42979), +(184241, 0, 0, 0, 2057, 42979), +(178895, 0, 0, 0, 2057, 42979), +(180933, 0, 0, 0, 2057, 42979), +(180927, 0, 0, 0, 2057, 42979), +(185702, 0, 0, 0, 2057, 42979), +(180926, 0, 0, 0, 2057, 42979), +(182218, 0, 0, 0, 371, 42979), +(180052, 0, 0, 0, 2057, 42979), +(183963, 0, 0, 0, 2057, 42979), +(180923, 0, 0, 0, 2057, 42979), +(182245, 0, 0, 0, 371, 42979), +(177486, 0, 0, 0, 2057, 42979), +(184487, 0, 0, 0, 2057, 42979), +(184486, 0, 0, 0, 2057, 42979), +(185713, 0, 0, 0, 2057, 42979), +(177476, 0, 0, 0, 2057, 42979), +(183378, 0, 0, 0, 371, 42979), +(180950, 0, 0, 0, 2057, 42979), +(178016, 0, 0, 0, 2057, 42979), +(182681, 0, 0, 0, 2057, 42979), +(172538, 0, 0, 0, 328, 42979), +(181003, 0, 0, 0, 2057, 42979), +(180715, 0, 0, 0, 2170, 42979), +(178094, 0, 0, 0, 81, 42979), +(178196, 0, 0, 0, 2057, 42979), +(177432, 0, 0, 0, 2057, 42979), +(181006, 0, 0, 0, 2057, 42979), +(185807, 0, 0, 0, 2057, 42979), +(185291, 0, 0, 0, 2057, 42979), +(180956, 0, 0, 0, 81, 42979), +(178913, 0, 0, 0, 2170, 42979); + +DELETE FROM `creature_model_info` WHERE `DisplayID` IN (104976, 98973, 105360, 98790, 98837, 98838, 105286, 105243, 98834, 105126, 98829, 103756, 104896, 104965, 101214, 104868, 103087, 101996, 100994, 104964, 105234, 105237, 101775, 98506, 105239, 105236, 101984, 98897, 98509, 102043, 98508, 100733, 100381, 98828, 104860, 100731, 104867, 105459, 105242, 100453, 103135, 105245, 101986, 100732, 101985, 104562, 104014, 101054, 104973, 100377, 98816, 100995, 105241, 101048, 105460, 98818, 100379, 98968); +INSERT INTO `creature_model_info` (`DisplayID`, `BoundingRadius`, `CombatReach`, `DisplayID_Other_Gender`, `VerifiedBuild`) VALUES +(104976, 1.181651949882507324, 1, 0, 42979), +(98973, 1.382709264755249023, 1, 0, 42979), +(105360, 1.446130156517028808, 1.80000007152557373, 0, 42979), +(98790, 1.604430198669433593, 2.099999904632568359, 0, 42979), +(98837, 2.671834230422973632, 1.5, 0, 42979), +(98838, 2.003875732421875, 1.125, 0, 42979), +(105286, 0.200000002980232238, 0, 0, 42979), +(105243, 1.06494307518005371, 2, 0, 42979), +(98834, 2.671834230422973632, 1.5, 0, 42979), +(105126, 1.087563276290893554, 0, 0, 42979), +(98829, 0.525600016117095947, 2, 0, 42979), +(103756, 0.233049288392066955, 0, 0, 42979), +(104896, 1.382709264755249023, 1, 0, 42979), +(104965, 0.167517349123954772, 0.150000005960464477, 0, 42979), +(101214, 1.116782307624816894, 1, 0, 42979), +(104868, 1.224684476852416992, 2.299999952316284179, 0, 42979), +(103087, 1.06494307518005371, 2, 0, 42979), +(101996, 0.269567370414733886, 0.33000001311302185, 0, 42979), +(100994, 1.116782307624816894, 1, 0, 42979), +(104964, 1.116782307624816894, 1, 0, 42979), +(105234, 1.06494307518005371, 2, 0, 42979), +(105237, 1.06494307518005371, 2, 0, 42979), +(101775, 1.171437382698059082, 2.20000004768371582, 0, 42979), +(98506, 1.186721682548522949, 1.10000002384185791, 0, 42979), +(105239, 1.06494307518005371, 2, 0, 42979), +(105236, 1.06494307518005371, 2, 0, 42979), +(101984, 0.204370692372322082, 1.5, 0, 42979), +(98897, 1.11678171157836914, 1, 0, 42979), +(98509, 1.186721682548522949, 1.10000002384185791, 0, 42979), +(102043, 1.06494307518005371, 2, 0, 42979), +(98508, 1.186721682548522949, 1.10000002384185791, 0, 42979), +(100733, 1.06494307518005371, 2, 0, 42979), +(100381, 0.24570108950138092, 1, 0, 42979), +(98828, 0.525600016117095947, 2, 0, 42979), +(104860, 5.039999961853027343, 4.5, 0, 42979), +(100731, 1.06494307518005371, 2, 0, 42979), +(104867, 1.331178903579711914, 2.5, 0, 42979), +(105459, 0.932197153568267822, 0, 0, 42979), +(105242, 1.06494307518005371, 2, 0, 42979), +(100453, 0.780315995216369628, 0.629999995231628417, 0, 42979), +(103135, 1.06494307518005371, 2, 0, 42979), +(105245, 1.171437382698059082, 2.20000004768371582, 0, 42979), +(101986, 0.204370692372322082, 1.5, 0, 42979), +(100732, 1.06494307518005371, 2, 0, 42979), +(101985, 0.204370692372322082, 1.5, 0, 42979), +(104562, 1.224684476852416992, 2.299999952316284179, 0, 42979), +(104014, 1.026265621185302734, 0, 0, 42979), +(101054, 1.126080513000488281, 0, 0, 42979), +(104973, 1.116782307624816894, 1, 0, 42979), +(100377, 0.24570108950138092, 1, 0, 42979), +(98816, 0.612324118614196777, 0, 0, 42979), +(100995, 1.116782307624816894, 1, 0, 42979), +(105241, 1.06494307518005371, 2, 0, 42979), +(101048, 1.126080513000488281, 0, 0, 42979), +(105460, 0.932197153568267822, 0, 0, 42979), +(98818, 0.816432118415832519, 0, 0, 42979), +(100379, 0.24570108950138092, 1, 0, 42979), +(98968, 1.116782307624816894, 1, 0, 42979); |