diff options
| -rw-r--r-- | sql/updates/world/master/2023_10_15_00_world.sql | 87 |
1 files changed, 87 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_10_15_00_world.sql b/sql/updates/world/master/2023_10_15_00_world.sql new file mode 100644 index 00000000000..18482ffce46 --- /dev/null +++ b/sql/updates/world/master/2023_10_15_00_world.sql @@ -0,0 +1,87 @@ +-- Serverside spells (now clientside) +DELETE FROM `serverside_spell` WHERE `Id` IN (26161, 26162); +DELETE FROM `serverside_spell_effect` WHERE `SpellID` IN (26161, 26162); + +-- Spell loot template +DELETE FROM `spell_loot_template` WHERE `Entry` IN (60445, 61177, 61288, 61500, 95399, 95406, 153627, 153629, 153630, 153631, 153643, 153644, 153645, 153646, 153647, 153648, 153649, 153650, 153651, 153652, 153654, 153655, 153656, 153664, 153666, 153667, 153668); +DELETE FROM `spell_loot_template` WHERE `Item` IN (62312, 62336, 62337, 62338, 107976, 107977, 107978, 107979, 107980, 107981, 107982, 107983, 108050, 108050, 108063, 108064, 108065, 108066, 108067, 108068, 108069, 108230); + +-- Achievement +DELETE FROM `player_factionchange_achievement` WHERE `alliance_id` IN (58, 1466); + +DELETE FROM `achievement_reward` WHERE `ID` IN (1657, 1684, 1692, 1707, 1784, 2145, 2797, 3656); +DELETE FROM `achievement_reward_locale` WHERE `ID` IN (2145, 3656, 4784, 4785); +UPDATE `achievement_reward` SET `TitleH`=84 WHERE `ID`=1563; +UPDATE `achievement_reward` SET `TitleH`=124 WHERE `ID`=1656; +UPDATE `achievement_reward` SET `TitleA`=133 WHERE `ID`=1683; +UPDATE `achievement_reward` SET `TitleA`=134 WHERE `ID`=1691; +UPDATE `achievement_reward` SET `TitleA`=135 WHERE `ID`=1693; +UPDATE `achievement_reward` SET `TitleA`=155 WHERE `ID`=2798; +UPDATE `achievement_reward` SET `TitleH`=168 WHERE `ID`=3478; + +-- Gossip +DELETE FROM `creature_template_gossip` WHERE `MenuID`=1; + +DELETE FROM `gossip_menu` WHERE `MenuID`=50001; + +DELETE FROM `gossip_menu_option` WHERE `MenuID`=1294 AND `OptionID`=3; +DELETE FROM `gossip_menu_option` WHERE `MenuID`=7468 AND `OptionID`=4; + +-- Npc text +UPDATE `npc_text` SET `Probability0`=1 WHERE `ID` IN (720, 738, 1228, 1303, 1569, 1599, 1600, 1616, 1617, 1618, 1637, 1656, 1874, 2115, 2174, 2434, 2567, 2568, 2570, 2605, 2606, 2635, 2724, 2818, 2873, 2996, 2997, 3049, 3061, 3307, 3308, 3309, 3310, 3311, 3321, 3401, 3411, 3420, 3481, 3495, 3525, 3589, 3594, 3669, 3759, 3760, 3761, 3762, 3763, 3855, 3856, 3857, 3859, 3938, 3998, 4117, 4122, 4123, 4124, 4125, 4126, 4127, 4128, 4129, 4130, 4258, 4444, 4732, 4787, 5014, 5015, 5024, 5030, 5036, 5050, 5051, 5060, 5063, 5072, 5075, 5078, 5081, 5105, 5116, 5122, 5123, 5131, 5143, 5144, 5146, 5148, 5161, 5163, 5165, 5180, 5191, 5192, 5195, 5206, 5211, 5217, 5226, 5227, 5231, 5249, 5251, 5258, 5264, 5286, 5329, 5406, 5421, 5439, 5442, 5522, 5527, 5539, 5543, 5554, 5796, 5797, 5818, 5822, 5914, 5917, 5921, 6167, 6177, 6379, 6491, 6658, 6659, 6718, 6732, 6736, 6775, 6783, 6789, 6848, 6930, 6976, 6977, 6978, 6979, 7002, 7003, 7004, 7005, 7056, 7182, 7209, 7216, 7221, 7223, 7225, 7226, 7252, 7495, 7497, 7499, 7503, 7504, 7507, 7530, 7711, 7737, 7738, 8060, 8326, 8327, 8363, 8364, 8398, 8399, 8426, 8507, 8516, 8801, 8934, 8975, 9016, 9064, 9068, 9127, 9296, 10209, 10415, 10419, 10502, 10530, 10547, 10548, 10550, 10551, 10552, 10555, 10557, 10798, 10830, 10921, 10951, 11036, 11061, 11075, 11077, 11289, 11295, 11302, 11370, 20201, 42338, 42345, 42346, 42366, 42371, 42373, 42374, 42391, 42394, 42395, 42400, 42401, 42403, 42422, 42454, 42470, 42478, 42479, 42482, 42491, 42492, 42495, 42496, 42501, 42514, 42517, 42518, 42519, 42523, 42530, 42536, 42559, 42560, 42569, 42577, 42579, 42580, 42604, 42609, 42625, 42627, 42638, 42649, 42718, 42721, 42726, 42731, 42734, 42740, 42741, 42750, 42753, 42758, 42760, 42761, 42763, 42765, 42766, 42778, 42780, 42789, 42797, 42804, 42814, 42821, 42823, 42826, 42827, 42834, 42838, 42848, 42855, 42858, 42859, 42860, 42861, 42863, 42877, 42900, 42906, 42915, 42929, 42930, 42934, 42942, 42958, 42962, 42964, 42967, 42969, 42971, 42978, 42981, 42988, 42991, 42998, 43004, 43021, 43027, 43046, 43047, 43048, 43049, 43053, 43055, 43056, 43057, 43059, 43061, 43063, 43064, 43065, 43066, 43067, 43068, 43069, 43075, 43076, 43078, 43083, 43085, 43086, 43087, 43099, 43102, 43104, 43105, 43116, 43119, 43128, 43137, 43147, 43148, 43154, 43155, 43169, 43187, 43191, 43192, 43193, 43206, 43221, 43222, 43223, 43224, 43227, 43265, 43266, 43267, 43268, 43269, 43270, 43274, 43275, 43276, 43278, 43279, 43280, 43281, 43283, 43284, 43285, 43286, 43287, 43288, 43289, 43291, 43292, 43293, 43294, 43295, 43296, 43298, 43299, 43302, 43315, 43316, 43326, 43327, 43328, 43329, 43331, 43335, 43336, 43338, 43346, 43347, 43348, 43349, 43350, 43366, 43402, 43404, 43407, 43428, 43430, 43432, 43434, 43435, 43436, 43495, 43496, 43498, 43499, 43511, 43536, 43539, 43545, 43548, 43553, 43561, 43562, 43577, 43580, 43581, 43582, 43583, 43590, 43591, 43593, 43594, 43595, 43596, 43615, 43616, 43617, 43618, 43623, 43624, 43625, 43631, 43637, 43638, 43654, 43662, 43680, 43703, 43710, 43712, 43713, 43718, 43719, 43729, 43730, 43731, 43735, 43740, 43750, 43752, 43756, 43761, 43762, 43763, 43767, 43768, 43769, 43770, 43772, 43773, 43775, 43776, 43778, 43779, 43783, 43784, 43785, 43786, 43788, 43789, 43790, 43794, 43795, 43797, 43805, 43814, 43827, 43830, 43855, 43859, 43860, 43861, 43862, 43880, 43881, 43884, 43891, 43900, 43901, 43902, 43906, 43907, 43908, 43916, 43957, 43967, 43975, 43976, 43977, 43978, 43980, 43987, 43994, 43996, 43997, 43998, 43999, 44000, 44001, 44003, 44009, 44013, 44027, 44075, 44098, 44099, 44100, 44101, 44102, 44104); + +-- Spawn group +DELETE FROM `spawn_group` WHERE `spawnType`=0 AND `spawnId`=296848; + +-- Gameobject +DELETE FROM `gameobject_addon` WHERE `guid` IN (151982, 151983, 151984, 151985, 151986, 151987, 151988, 151989, 151990, 151991, 151992, 151993, 151994, 151995, 151996, 151997, 151998, 151999, 152000, 152001, 152002, 152003, 152004, 152005, 152006, 152007, 152008, 152009, 152010, 152011, 152012, 152013, 152014, 152015, 152016, 152017, 152018, 152019, 152020, 152021, 152022, 152023, 220373, 220375); + +-- Event scripts +DELETE FROM `event_scripts` WHERE `command`=7 AND `datalong` IN (5056, 10923); +DELETE FROM `event_scripts` WHERE `command`=15 AND `datalong`=39983; + +-- Scripts +UPDATE `creature` SET `ScriptName`='' WHERE `ScriptName` IN ('npc_bg_ab_defiler_combatant_2', 'npc_bg_ab_dominic_masonwrite'); + +-- Conditions +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=1 AND `SourceGroup`=2434 AND `SourceEntry`=3668; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=1 AND `SourceGroup`=4802 AND `SourceEntry`=16790; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=1 AND `SourceGroup` IN (5615, 5618, 17537); +UPDATE `creature_template_difficulty` SET `LootID`=0 WHERE `Entry`=17537; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=4 AND `SourceGroup`=3597 AND `SourceEntry`=6172; +UPDATE `conditions` SET `SourceTypeOrReferenceId`=17, `ConditionTarget`=1, `ConditionValue1`=3, `ConditionValue2`=47872, `NegativeCondition`=0, `ErrorType`=13 WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=89089; +UPDATE `conditions` SET `SourceTypeOrReferenceId`=17, `ConditionTarget`=1, `ConditionValue1`=3, `ConditionValue2`=48197, `NegativeCondition`=0, `ErrorType`=13 WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=89557; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=93072; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceGroup`=4 AND `SourceEntry`=5628; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=1541 AND `ElseGroup`=1; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=4764; +UPDATE `conditions` SET `SourceEntry`=1 WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=8539; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=9832 AND `SourceEntry`=8 AND `ElseGroup`=1; +UPDATE `conditions` SET `ConditionValue1`=7520, `Comment`='Only show gossip if player have achievement Loremaster' WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=9832 AND `SourceEntry`=8 AND `ConditionTypeOrReference`=17; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=10118 AND `SourceEntry` IN (3, 5) AND `ElseGroup`=1; +UPDATE `conditions` SET `ConditionTypeOrReference`=49, `ConditionValue1`=6 WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=10704 AND `ConditionValue1`=8; +UPDATE `conditions` SET `ConditionTypeOrReference`=49, `ConditionValue1`=5 WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=10704 AND `ConditionValue1`=4; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=10723 AND `SourceEntry`=1; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=21043 AND `SourceEntry`=2; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=21057; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=17 AND `SourceEntry` IN (61309, 75596); +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=26 AND `SourceGroup`=14353 AND `SourceEntry`=10639; +UPDATE `conditions` SET `ConditionValue2`=0 WHERE `SourceTypeOrReferenceId`=26 AND `SourceGroup`=5935 AND `SourceEntry`=493 AND `ConditionTypeOrReference`=14; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=26 AND `SourceGroup` IN (5628, 5950) AND `SourceEntry`=493; + +-- Phases +DELETE FROM `phase_area` WHERE `AreaId`=493 AND `PhaseId`=5920; +INSERT INTO `phase_area` (`AreaId`, `PhaseId`, `Comment`) VALUES +(493, 5920, 'See Naralex meditating in Moonglade (Legion Druid Campaign)'); + +-- Game tele +DELETE FROM `game_tele` WHERE `id`=67; + +-- World safe locs +DELETE FROM `world_safe_locs` WHERE `MapID` IN (37, 451, 728, 1010, 1060, 1171, 1457, 1537, 1584, 1589, 1645, 1655, 1685, 1726, 1740, 1749, 1765, 1780, 1802, 1805, 1807, 1849, 1852, 1853, 1890, 2130, 2143); + +-- AT teleport +DELETE FROM `areatrigger_teleport` WHERE `ID` IN (702, 704, 4901, 4909, 4953, 5493, 5495); + +-- Worldstate +DELETE FROM `world_state` WHERE `MapIDs`='598'; |