diff options
| -rw-r--r-- | sql/updates/world/master/2025_10_14_01_world.sql | 179 |
1 files changed, 179 insertions, 0 deletions
diff --git a/sql/updates/world/master/2025_10_14_01_world.sql b/sql/updates/world/master/2025_10_14_01_world.sql new file mode 100644 index 00000000000..fe552e42d04 --- /dev/null +++ b/sql/updates/world/master/2025_10_14_01_world.sql @@ -0,0 +1,179 @@ +UPDATE `world_state` SET `Comment`='Blackfathom Deeps - Executioner Gore/Twilight Lord Bathiel - Encounter completed' WHERE `ID`=4623; +UPDATE `world_state` SET `Comment`='Uldaman - The Lost Dwarves/Obsidian Sentinel - Encounter completed' WHERE `ID`=4761; +UPDATE `world_state` SET `Comment`='Scarlet Monastery of Old - High Inquisitor Whitemane - Encounter completed (Old)' WHERE `ID`=1201; +UPDATE `world_state` SET `Comment`='Scarlet Monastery of Old - Interrogator Vishas - Encounter completed (Old)' WHERE `ID`=4567; +UPDATE `world_state` SET `Comment`='Scarlet Monastery of Old - Houndmaster Loksey - Encounter completed (Old)' WHERE `ID`=4569; +UPDATE `world_state` SET `Comment`='Scarlet Monastery of Old - Arcanist Doan - Encounter completed (Old)' WHERE `ID`=4570; +UPDATE `world_state` SET `Comment`='Scarlet Monastery of Old - Herod - Encounter completed (Old)' WHERE `ID`=4571; +UPDATE `world_state` SET `Comment`='Scarlet Monastery of Old - High Inquisitor Fairbanks - Encounter completed (Old)' WHERE `ID`=4572; +UPDATE `world_state` SET `Comment`='Dire Maul - Illyanna Ravenoak/Immol''thar - Encounter completed' WHERE `ID`=4676; +UPDATE `world_state` SET `Comment`='End Time - Echo of Baine/Echo of Sylvanas - Encounter completed' WHERE `ID`=6072; +UPDATE `world_state` SET `Comment`='End Time - Echo of Jaina/Echo of Tyrande - Encounter completed' WHERE `ID`=6073; +UPDATE `world_state` SET `Comment`='Battle of Dazar''alor - Grong/Grong the Revenant - Encounter completed' WHERE `ID`=16563; +UPDATE `world_state` SET `MapIDs`='2212,2213,2827,2828', `Comment`='Horrific Vision of Orgrimmar/Stormwind - Thrall the Corrupted/Alleria Windrunner - Encounter completed' WHERE `ID`=18015; + +DELETE FROM `world_state` WHERE `ID` IN (4531,4532,4533,4534,4535,4536,4537,24615,24616,24617,24618,24619,24620,24621,4573,4574,4575,4576,4577,4578,4588,4589,4590,4591,4592,4593,4594,11875,24300,21495,21497,21499,21503,21633,21670,21674,21676,21677,21901,21903,22116,22358,21909,21913,21914,21917,21636,21638,21640,21642,21835,21897,21947,21720,21742,21747,21762,21854,21927,22026,22094,21592,21593,21594,21595,21929,21931,21933,21935,24126,24338,24357,24406,24432,24560,24632,24719,25036,23125,23134,23153,23156,23160,23162,23168,23244,23252,22901,22903,22905,22907,22909,22911,22913,22915,24613,24904,25028,24899,25022,25024,24410,24751,24823,24893,25026,25193,25233,25238,24466,25449,25630,25695,25697,25699,25701,25703,25705,25585,25668,25728,25573,25739,25751,25769,24913,24915,24917,25658,25674,25675,25678,26690,26692,26694,26696,26698,26700,26702,26704,26795,26797,26961,26963,26871,26872,26873,26874,26875,26876,26877,26878,27805,27869,27871,27873,27875,27877,27879,27881,27680,27683,27685); +INSERT INTO `world_state` (`ID`, `DefaultValue`, `MapIDs`, `AreaIDs`, `ScriptName`, `Comment`) VALUES +(4531, 0, '36', NULL, '', 'Deadmines - Rhahk''Zor - Encounter completed'), +(4532, 0, '36', NULL, '', 'Deadmines - Sneed - Encounter completed'), +(4533, 0, '36', NULL, '', 'Deadmines - Gilnid - Encounter completed'), +(4534, 0, '36', NULL, '', 'Deadmines - Mr. Smite - Encounter completed'), +(4535, 0, '36', NULL, '', 'Deadmines - Cookie - Encounter completed'), +(4536, 0, '36', NULL, '', 'Deadmines - Captain Greenskin - Encounter completed'), +(4537, 0, '36', NULL, '', 'Deadmines - Edwin VanCleef - Encounter completed'), +(24615, 0, '189', NULL, '', 'Scarlet Monastery of Old - Interrogator Vishas - Encounter completed'), +(24616, 0, '189', NULL, '', 'Scarlet Monastery of Old - Bloodmage Thalnos - Encounter completed'), +(24617, 0, '189', NULL, '', 'Scarlet Monastery of Old - Houndmaster Loksey - Encounter completed'), +(24618, 0, '189', NULL, '', 'Scarlet Monastery of Old - Arcanist Doan - Encounter completed'), +(24619, 0, '189', NULL, '', 'Scarlet Monastery of Old - Herod - Encounter completed'), +(24620, 0, '189', NULL, '', 'Scarlet Monastery of Old - High Inquisitor Fairbanks - Encounter completed'), +(24621, 0, '189', NULL, '', 'Scarlet Monastery of Old - High Inquisitor Whitemane - Encounter completed'), +(4573, 0, '289', NULL, '', 'Scholomance - Kirtonos the Herald - Encounter completed'), +(4574, 0, '289', NULL, '', 'Scholomance - Jandice Barov - Encounter completed'), +(4575, 0, '289', NULL, '', 'Scholomance - Rattlegore - Encounter completed'), +(4576, 0, '289', NULL, '', 'Scholomance - Marduk Blackpool - Encounter completed'), +(4577, 0, '289', NULL, '', 'Scholomance - Vectus - Encounter completed'), +(4578, 0, '289', NULL, '', 'Scholomance - Ras Frostwhisper - Encounter completed'), +(4588, 0, '289', NULL, '', 'Scholomance - Instructor Malicia - Encounter completed'), +(4589, 0, '289', NULL, '', 'Scholomance - Doctor Theolen Krastinov - Encounter completed'), +(4590, 0, '289', NULL, '', 'Scholomance - Lorekeeper Polkelt - Encounter completed'), +(4591, 0, '289', NULL, '', 'Scholomance - The Ravenian - Encounter completed'), +(4592, 0, '289', NULL, '', 'Scholomance - Lord Alexei Barov - Encounter completed'), +(4593, 0, '289', NULL, '', 'Scholomance - Lady Illucia Barov - Encounter completed'), +(4594, 0, '289', NULL, '', 'Scholomance - Darkmaster Gandling - Encounter completed'), +(11875, 0, '329', NULL, '', 'Stratholme - Postmaster Malown - Encounter completed'), +(24300, 0, '1004', NULL, '', 'Scarlet Monastery - The Headless Horseman - Encounter completed'), +(21495, 0, '2451', NULL, '', 'Uldaman: Legacy of Tyr - The Lost Dwarves - Encounter completed'), +(21497, 0, '2451', NULL, '', 'Uldaman: Legacy of Tyr - Bromach - Encounter completed'), +(21499, 0, '2451', NULL, '', 'Uldaman: Legacy of Tyr - Sentinel Talondras - Encounter completed'), +(21503, 0, '2451', NULL, '', 'Uldaman: Legacy of Tyr - Chrono-Lord Deios - Encounter completed'), +(21633, 0, '2451', NULL, '', 'Uldaman: Legacy of Tyr - Emberon - Encounter completed'), +(21670, 0, '2515', NULL, '', 'The Azure Vault - Leymor - Encounter completed'), +(21674, 0, '2515', NULL, '', 'The Azure Vault - Telash Greywing - Encounter completed'), +(21676, 0, '2515', NULL, '', 'The Azure Vault - Umbrelskul - Encounter completed'), +(21677, 0, '2515', NULL, '', 'The Azure Vault - Azureblade - Encounter completed'), +(21901, 0, '2516', NULL, '', 'The Nokhud Offensive - Teera and Maruuk - Encounter completed'), +(21903, 0, '2516', NULL, '', 'The Nokhud Offensive - Balakar Khan - Encounter completed'), +(22116, 0, '2516', NULL, '', 'The Nokhud Offensive - The Raging Tempest - Encounter completed'), +(22358, 0, '2516', NULL, '', 'The Nokhud Offensive - Granyth - Encounter completed'), +(21909, 0, '2519', NULL, '', 'Neltharus - Magmatusk - Encounter completed'), +(21913, 0, '2519', NULL, '', 'Neltharus - Warlord Sargha - Encounter completed'), +(21914, 0, '2519', NULL, '', 'Neltharus - Forgemaster Gorek - Encounter completed'), +(21917, 0, '2519', NULL, '', 'Neltharus - Chargath, Bane of Scales - Encounter completed'), +(21636, 0, '2520', NULL, '', 'Brackenhide Hollow - Gutshot - Encounter completed'), +(21638, 0, '2520', NULL, '', 'Brackenhide Hollow - Treemouth - Encounter completed'), +(21640, 0, '2520', NULL, '', 'Brackenhide Hollow - Decatriarch Wratheye - Encounter completed'), +(21642, 0, '2520', NULL, '', 'Brackenhide Hollow - Hackclaw''s War-Band - Encounter completed'), +(21835, 0, '2521', NULL, '', 'Ruby Life Pools - Kokia Blazehoof - Encounter completed'), +(21897, 0, '2521', NULL, '', 'Ruby Life Pools - Melidrussa Chillworn - Encounter completed'), +(21947, 0, '2521', NULL, '', 'Ruby Life Pools - Kyrakka and Erkhart Stormvein - Encounter completed'), +(21720, 0, '2522', NULL, '', 'Vault of the Incarnates - Eranog - Encounter completed'), +(21742, 0, '2522', NULL, '', 'Vault of the Incarnates - The Primal Council - Encounter completed'), +(21747, 0, '2522', NULL, '', 'Vault of the Incarnates - Sennarth, The Cold Breath - Encounter completed'), +(21762, 0, '2522', NULL, '', 'Vault of the Incarnates - Kurog Grimtotem - Encounter completed'), +(21854, 0, '2522', NULL, '', 'Vault of the Incarnates - Raszageth the Storm-Eater - Encounter completed'), +(21927, 0, '2522', NULL, '', 'Vault of the Incarnates - Broodkeeper Diurna - Encounter completed'), +(22026, 0, '2522', NULL, '', 'Vault of the Incarnates - Dathea, Ascended - Encounter completed'), +(22094, 0, '2522', NULL, '', 'Vault of the Incarnates - Terros - Encounter completed'), +(21592, 0, '2526', NULL, '', 'Algeth''ar Academy - Vexamus - Encounter completed'), +(21593, 0, '2526', NULL, '', 'Algeth''ar Academy - Overgrown Ancient - Encounter completed'), +(21594, 0, '2526', NULL, '', 'Algeth''ar Academy - Crawth - Encounter completed'), +(21595, 0, '2526', NULL, '', 'Algeth''ar Academy - Echo of Doragosa - Encounter completed'), +(21929, 0, '2527', NULL, '', 'Halls of Infusion - Watcher Irideus - Encounter completed'), +(21931, 0, '2527', NULL, '', 'Halls of Infusion - Gulping Goliath - Encounter completed'), +(21933, 0, '2527', NULL, '', 'Halls of Infusion - Khajin the Unyielding - Encounter completed'), +(21935, 0, '2527', NULL, '', 'Halls of Infusion - Primal Tsunami - Encounter completed'), +(24126, 0, '2549', NULL, '', 'Amirdrassil, the Dream''s Hope - Igira the Cruel - Encounter completed'), +(24338, 0, '2549', NULL, '', 'Amirdrassil, the Dream''s Hope - Council of Dreams - Encounter completed'), +(24357, 0, '2549', NULL, '', 'Amirdrassil, the Dream''s Hope - Larodar, Keeper of the Flame - Encounter completed'), +(24406, 0, '2549', NULL, '', 'Amirdrassil, the Dream''s Hope - Nymue, Weaver of the Cycle - Encounter completed'), +(24432, 0, '2549', NULL, '', 'Amirdrassil, the Dream''s Hope - Volcoross - Encounter completed'), +(24560, 0, '2549', NULL, '', 'Amirdrassil, the Dream''s Hope - Tindral Sageswift, Seer of the Flame - Encounter completed'), +(24632, 0, '2549', NULL, '', 'Amirdrassil, the Dream''s Hope - Gnarlroot - Encounter completed'), +(24719, 0, '2549', NULL, '', 'Amirdrassil, the Dream''s Hope - Smolderon - Encounter completed'), +(25036, 0, '2549', NULL, '', 'Amirdrassil, the Dream''s Hope - Fyrakk the Blazing - Encounter completed'), +(23125, 0, '2569', NULL, '', 'Aberrus, the Shadowed Crucible - Rashok, the Elder - Encounter completed'), +(23134, 0, '2569', NULL, '', 'Aberrus, the Shadowed Crucible - Assault of the Zaqali - Encounter completed'), +(23153, 0, '2569', NULL, '', 'Aberrus, the Shadowed Crucible - Magmorax - Encounter completed'), +(23156, 0, '2569', NULL, '', 'Aberrus, the Shadowed Crucible - Echo of Neltharion - Encounter completed'), +(23160, 0, '2569', NULL, '', 'Aberrus, the Shadowed Crucible - Scalecommander Sarkareth - Encounter completed'), +(23162, 0, '2569', NULL, '', 'Aberrus, the Shadowed Crucible - The Amalgamation Chamber - Encounter completed'), +(23168, 0, '2569', NULL, '', 'Aberrus, the Shadowed Crucible - Kazzara, the Hellforged - Encounter completed'), +(23244, 0, '2569', NULL, '', 'Aberrus, the Shadowed Crucible - The Vigilant Steward, Zskarn - Encounter completed'), +(23252, 0, '2569', NULL, '', 'Aberrus, the Shadowed Crucible - The Forgotten Experiments - Encounter completed'), +(22901, 0, '2579', NULL, '', 'Dawn of the Infinite - Chronikar - Encounter completed'), +(22903, 0, '2579', NULL, '', 'Dawn of the Infinite - Manifested Timeways - Encounter completed'), +(22905, 0, '2579', NULL, '', 'Dawn of the Infinite - Blight of Galakrond - Encounter completed'), +(22907, 0, '2579', NULL, '', 'Dawn of the Infinite - Iridikron - Encounter completed'), +(22909, 0, '2579', NULL, '', 'Dawn of the Infinite - Tyr, the Infinite Keeper - Encounter completed'), +(22911, 0, '2579', NULL, '', 'Dawn of the Infinite - Morchie - Encounter completed'), +(22913, 0, '2579', NULL, '', 'Dawn of the Infinite - Time-Lost Battlefield - Encounter completed'), +(22915, 0, '2579', NULL, '', 'Dawn of the Infinite - Chrono-Lord Deios - Encounter completed'), +(24613, 0, '2648', NULL, '', 'The Rookery - Kyrioss - Encounter completed'), +(24904, 0, '2648', NULL, '', 'The Rookery - Skardyn Monstrosity - Encounter completed'), +(25028, 0, '2648', NULL, '', 'The Rookery - Stormguard Gorren - Encounter completed'), +(24899, 0, '2649', NULL, '', 'Priory of the Sacred Flame - Baron Braunpyke - Encounter completed'), +(25022, 0, '2649', NULL, '', 'Priory of the Sacred Flame - Captain Dailcry - Encounter completed'), +(25024, 0, '2649', NULL, '', 'Priory of the Sacred Flame - Prioress Murrpray - Encounter completed'), +(24410, 0, '2651', NULL, '', 'Darkflame Cleft - The Candle King - Encounter completed'), +(24751, 0, '2651', NULL, '', 'Darkflame Cleft - Blazikon - Encounter completed'), +(24823, 0, '2651', NULL, '', 'Darkflame Cleft - Ol'' Waxbeard - Encounter completed'), +(24893, 0, '2651', NULL, '', 'Darkflame Cleft - The Darkness - Encounter completed'), +(25026, 0, '2652', NULL, '', 'The Stonevault - E.D.N.A. - Encounter completed'), +(25193, 0, '2652', NULL, '', 'The Stonevault - Skarmorak - Encounter completed'), +(25233, 0, '2652', NULL, '', 'The Stonevault - Void Speaker Eirich - Encounter completed'), +(25238, 0, '2652', NULL, '', 'The Stonevault - Master Machinists - Encounter completed'), +(24466, 0, '2653', NULL, '', '10.2 Scenario - The Power of Temptation - Encounter completed'), +(25449, 0, '2657', NULL, '', 'Nerub-ar Palace - Sikran, Captain of the Sureki - Encounter completed'), +(25630, 0, '2657', NULL, '', 'Nerub-ar Palace - Ulgrax the Devourer - Encounter completed'), +(25695, 0, '2657', NULL, '', 'Nerub-ar Palace - The Bloodbound Horror - Encounter completed'), +(25697, 0, '2657', NULL, '', 'Nerub-ar Palace - Rasha''nan - Encounter completed'), +(25699, 0, '2657', NULL, '', 'Nerub-ar Palace - Broodtwister Ovi''nax - Encounter completed'), +(25701, 0, '2657', NULL, '', 'Nerub-ar Palace - Nexus-Princess Ky''veza - Encounter completed'), +(25703, 0, '2657', NULL, '', 'Nerub-ar Palace - The Silken Court - Encounter completed'), +(25705, 0, '2657', NULL, '', 'Nerub-ar Palace - Queen Ansurek - Encounter completed'), +(25585, 0, '2660', NULL, '', 'Ara-Kara, City of Echoes - Ki''katal the Harvester - Encounter completed'), +(25668, 0, '2660', NULL, '', 'Ara-Kara, City of Echoes - Anub''zekt - Encounter completed'), +(25728, 0, '2660', NULL, '', 'Ara-Kara, City of Echoes - Avanoxx - Encounter completed'), +(25573, 0, '2661', NULL, '', 'Cinderbrew Meadery - Brewmaster Aldryr - Encounter completed'), +(25739, 0, '2661', NULL, '', 'Cinderbrew Meadery - I''pa - Encounter completed'), +(25751, 0, '2661', NULL, '', 'Cinderbrew Meadery - Goldie Baronbottom - Encounter completed'), +(25769, 0, '2661', NULL, '', 'Cinderbrew Meadery - Benk Buzzbee - Encounter completed'), +(24913, 0, '2662', NULL, '', 'The Dawnbreaker - Speaker Shadowcrown - Encounter completed'), +(24915, 0, '2662', NULL, '', 'The Dawnbreaker - Anub''ikkaj - Encounter completed'), +(24917, 0, '2662', NULL, '', 'The Dawnbreaker - Rasha''nan - Encounter completed'), +(25658, 0, '2669', NULL, '', 'City of Threads - The Coaglamation - Encounter completed'), +(25674, 0, '2669', NULL, '', 'City of Threads - Orator Krix''vizk - Encounter completed'), +(25675, 0, '2669', NULL, '', 'City of Threads - Izo, the Grand Splicer - Encounter completed'), +(25678, 0, '2669', NULL, '', 'City of Threads - Fangs of the Queen - Encounter completed'), +(26690, 0, '2769', NULL, '', 'Liberation of Undermine - Vexie and the Geargrinders - Encounter completed'), +(26692, 0, '2769', NULL, '', 'Liberation of Undermine - Cauldron of Carnage - Encounter completed'), +(26694, 0, '2769', NULL, '', 'Liberation of Undermine - Rik Reverb - Encounter completed'), +(26696, 0, '2769', NULL, '', 'Liberation of Undermine - Stix Bunkjunker - Encounter completed'), +(26698, 0, '2769', NULL, '', 'Liberation of Undermine - Sprocketmonger Lockenstock - Encounter completed'), +(26700, 0, '2769', NULL, '', 'Liberation of Undermine - One-Armed Bandit - Encounter completed'), +(26702, 0, '2769', NULL, '', 'Liberation of Undermine - Mug''Zee, Heads of Security - Encounter completed'), +(26704, 0, '2769', NULL, '', 'Liberation of Undermine - Chrome King Gallywix - Encounter completed'), +(26795, 0, '2773', NULL, '', 'Operation: Floodgate - Demolition Duo - Encounter completed'), +(26797, 0, '2773', NULL, '', 'Operation: Floodgate - Big M.O.M.M.A. - Encounter completed'), +(26961, 0, '2773', NULL, '', 'Operation: Floodgate - Swampface - Encounter completed'), +(26963, 0, '2773', NULL, '', 'Operation: Floodgate - Geezle Gigazap - Encounter completed'), +(26871, 0, '2792', NULL, '', 'Blackrock Depths - Lord Roccor - Encounter completed'), +(26872, 0, '2792', NULL, '', 'Blackrock Depths - Emperor Dagran Thaurissan - Encounter completed'), +(26873, 0, '2792', NULL, '', 'Blackrock Depths - Ambassador Flamelash - Encounter completed'), +(26874, 0, '2792', NULL, '', 'Blackrock Depths - General Angerforge - Encounter completed'), +(26875, 0, '2792', NULL, '', 'Blackrock Depths - The Seven - Encounter completed'), +(26876, 0, '2792', NULL, '', 'Blackrock Depths - Golem Lord Argelmach - Encounter completed'), +(26877, 0, '2792', NULL, '', 'Blackrock Depths - Lord Incendius - Encounter completed'), +(26878, 0, '2792', NULL, '', 'Blackrock Depths - Bael''Gar - Encounter completed'), +(27805, 0, '2810', NULL, '', 'Manaforge Omega - Fractillus - Encounter completed'), +(27869, 0, '2810', NULL, '', 'Manaforge Omega - Plexus Sentinel - Encounter completed'), +(27871, 0, '2810', NULL, '', 'Manaforge Omega - Loom''ithar - Encounter completed'), +(27873, 0, '2810', NULL, '', 'Manaforge Omega - Soulbinder Naazindhri - Encounter completed'), +(27875, 0, '2810', NULL, '', 'Manaforge Omega - Forgeweaver Araz - Encounter completed'), +(27877, 0, '2810', NULL, '', 'Manaforge Omega - The Soul Hunters - Encounter completed'), +(27879, 0, '2810', NULL, '', 'Manaforge Omega - Nexus-King Salhadaar - Encounter completed'), +(27881, 0, '2810', NULL, '', 'Manaforge Omega - Dimensius, the All-Devouring - Encounter completed'), +(27680, 0, '2830', NULL, '', 'Eco-Dome Al''dani - Azhiccar - Encounter completed'), +(27683, 0, '2830', NULL, '', 'Eco-Dome Al''dani - Taah''bat and A''wazj - Encounter completed'), +(27685, 0, '2830', NULL, '', 'Eco-Dome Al''dani - Soul-Scribe - Encounter completed'); |