diff options
Diffstat (limited to 'sql/old/3.3.5a')
58 files changed, 1546 insertions, 0 deletions
diff --git a/sql/old/3.3.5a/auth/22081_2022_10_17/2022_08_15_00_auth.sql b/sql/old/3.3.5a/auth/22081_2022_10_17/2022_08_15_00_auth.sql new file mode 100644 index 00000000000..db8dd1f7ce2 --- /dev/null +++ b/sql/old/3.3.5a/auth/22081_2022_10_17/2022_08_15_00_auth.sql @@ -0,0 +1,2 @@ +-- TDB 335.22081 auth +UPDATE `updates` SET `state`='ARCHIVED'; diff --git a/sql/old/3.3.5a/characters/22081_2022_10_17/2022_08_15_00_characters.sql b/sql/old/3.3.5a/characters/22081_2022_10_17/2022_08_15_00_characters.sql new file mode 100644 index 00000000000..721c57af960 --- /dev/null +++ b/sql/old/3.3.5a/characters/22081_2022_10_17/2022_08_15_00_characters.sql @@ -0,0 +1,2 @@ +-- TDB 335.22081 characters +UPDATE `updates` SET `state`='ARCHIVED'; diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_08_15_00_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_08_15_00_world.sql new file mode 100644 index 00000000000..51f6a53e5ff --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_08_15_00_world.sql @@ -0,0 +1,3 @@ +-- TDB 335.22081 world +UPDATE `version` SET `db_version`='TDB 335.22081', `cache_id`=22081 LIMIT 1; +UPDATE `updates` SET `state`='ARCHIVED'; diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_11_00_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_11_00_world.sql new file mode 100644 index 00000000000..368b24c74ef --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_11_00_world.sql @@ -0,0 +1,84 @@ +-- +-- Add missing gossip_menu +DELETE FROM `gossip_menu` WHERE (`MenuID`,`TextID`) IN ((7552,9380),(7581,9396),(7581,9398)); +INSERT INTO `gossip_menu`(`MenuID`, `TextID`, `VerifiedBuild`) VALUES +(7552, 9380, 0), +(7581, 9396, 0), +(7581, 9398, 0); + +-- Add missing npc_text +DELETE FROM `npc_text` WHERE `ID` IN (9396,9398); +INSERT INTO `npc_text`(`ID`, `text0_0`, `text0_1`, `BroadcastTextID0`, `lang0`, `Probability0`, `EmoteDelay0_0`, `Emote0_0`, `EmoteDelay0_1`, `Emote0_1`, `EmoteDelay0_2`, `Emote0_2`, `text1_0`, `text1_1`, `BroadcastTextID1`, `lang1`, `Probability1`, `EmoteDelay1_0`, `Emote1_0`, `EmoteDelay1_1`, `Emote1_1`, `EmoteDelay1_2`, `Emote1_2`, `text2_0`, `text2_1`, `BroadcastTextID2`, `lang2`, `Probability2`, `EmoteDelay2_0`, `Emote2_0`, `EmoteDelay2_1`, `Emote2_1`, `EmoteDelay2_2`, `Emote2_2`, `text3_0`, `text3_1`, `BroadcastTextID3`, `lang3`, `Probability3`, `EmoteDelay3_0`, `Emote3_0`, `EmoteDelay3_1`, `Emote3_1`, `EmoteDelay3_2`, `Emote3_2`, `text4_0`, `text4_1`, `BroadcastTextID4`, `lang4`, `Probability4`, `EmoteDelay4_0`, `Emote4_0`, `EmoteDelay4_1`, `Emote4_1`, `EmoteDelay4_2`, `Emote4_2`, `text5_0`, `text5_1`, `BroadcastTextID5`, `lang5`, `Probability5`, `EmoteDelay5_0`, `Emote5_0`, `EmoteDelay5_1`, `Emote5_1`, `EmoteDelay5_2`, `Emote5_2`, `text6_0`, `text6_1`, `BroadcastTextID6`, `lang6`, `Probability6`, `EmoteDelay6_0`, `Emote6_0`, `EmoteDelay6_1`, `Emote6_1`, `EmoteDelay6_2`, `Emote6_2`, `text7_0`, `text7_1`, `BroadcastTextID7`, `lang7`, `Probability7`, `EmoteDelay7_0`, `Emote7_0`, `EmoteDelay7_1`, `Emote7_1`, `EmoteDelay7_2`, `Emote7_2`, `VerifiedBuild`) VALUES +(9396, 'Outstanding! Kaz\'rogal\'s death cry should strike fear into the core of the Burning Legion. They now know the power your forces possess, so expect the worst the Legion can offer.', '', 15444, 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, 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), +(9398, 'Outstanding! Killing a Pit Lord such as Azgalor is no small feat, my friend. If we had more time, I would love to hear the story of you and your companions. Archimonde will not give us that pause, however. My scouts have already reported that the Legion is amassing an immense force outside our camp, and Archimonde is very close to the World Tree. We are evacuating with the help of Lady Proudmoore. You should head to the World Tree at once. The fate of our world is still undecided.', '', 15448, 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, 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); + +-- Trash Mobs Creature Text +DELETE FROM `creature_text` WHERE `CreatureID` IN (17899,17905,17919,17934,17932,17933,17936) AND `GroupID` IN (0,1); +DELETE FROM `creature_text` WHERE `CreatureID`=17772 AND `GroupID`=7; +INSERT INTO `creature_text`(`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES +(17899, 0, 0, 'Lambs for the slaughter!', 12, 0, 100, 0, 0, 0, 18450, 0, 'Shadowy Necromancer say slay'), +(17899, 1, 0, 'A pleasure... to serve the master.', 12, 0, 100, 0, 0, 0, 18448, 0, 'Shadowy Necromancer say death'), +(17899, 1, 1, 'My life... to the master.', 12, 0, 100, 0, 0, 0, 18447, 0, 'Shadowy Necromancer say death'), +(17899, 1, 2, 'You will... ultimately fail.', 12, 0, 100, 0, 0, 0, 18446, 0, 'Shadowy Necromancer say death'), +(17905, 0, 0, 'Let this torment end!!', 12, 0, 100, 0, 0, 0, 18451, 0, 'Banshee say slay'), +(17905, 0, 1, 'I obey.', 12, 0, 100, 0, 0, 0, 18454, 0, 'Banshee say slay'), +(17905, 1, 0, 'I am... released?', 12, 0, 100, 0, 0, 0, 18452, 0, 'Banshee say death'), +(17905, 1, 1, 'Is it really... over?', 12, 0, 100, 0, 0, 0, 18453, 0, 'Banshee say death'), +(17919, 0, 0, 'Back, hold them back!', 12, 0, 100, 0, 0, 0, 18457, 0, 'Alliance Footman say slay'), +(17919, 0, 1, 'Let these monsters taste cold steel!', 12, 0, 100, 0, 0, 0, 18456, 0, 'Alliance Footman say slay'), +(17919, 1, 0, 'Agghh!', 12, 0, 100, 0, 0, 0, 18458, 0, 'Alliance Footman say death'), +(17934, 0, 0, 'Dis no good....', 12, 0, 100, 0, 0, 0, 18501, 0, 'Horde Headhunter say slay'), +(17934, 0, 1, 'Take their heads!', 12, 0, 100, 0, 0, 0, 18499, 0, 'Horde Headhunter say slay'), +(17934, 0, 2, 'We kill \'em good, mon.', 12, 0, 100, 0, 0, 0, 18500, 0, 'Horde Headhunter say slay'), +(17934, 0, 3, 'You stay dead.', 12, 0, 100, 0, 0, 0, 18503, 0, 'Horde Headhunter say slay'), +(17934, 0, 4, 'Da Legion gonna pay.', 12, 0, 100, 0, 0, 0, 18504, 0, 'Horde Headhunter say slay'), +(17934, 1, 0, 'It all over... now.', 12, 0, 100, 0, 0, 0, 18502, 0, 'Horde Headhunter say death'), +(17932, 0, 0, 'Destroy them all!', 12, 0, 100, 0, 0, 0, 18486, 0, 'Horde Grunt say slay'), +(17932, 0, 1, 'Have at them! Lok-Tar!', 12, 0, 100, 0, 0, 0, 18485, 0, 'Horde Grunt say slay'), +(17932, 0, 2, 'Spill their... blood!', 12, 0, 100, 0, 0, 0, 18488, 0, 'Horde Grunt say slay'), +(17932, 0, 3, 'Another one down!', 12, 0, 100, 0, 0, 0, 18490, 0, 'Horde Grunt say slay'), +(17932, 0, 4, 'Demon filth!', 12, 0, 100, 0, 0, 0, 18489, 0, 'Horde Grunt say slay'), +(17932, 1, 0, 'Keep... fighting!', 12, 0, 100, 0, 0, 0, 18487, 0, 'Horde Grunt say death'), +(17933, 0, 0, 'For the Earth Mother!', 12, 0, 100, 0, 0, 0, 18493, 0, 'Tauren Warrior say slay'), +(17933, 0, 1, 'Crush them!', 12, 0, 100, 0, 0, 0, 18494, 0, 'Tauren Warrior say slay'), +(17933, 0, 2, 'Balance must be restored!', 12, 0, 100, 0, 0, 0, 18497, 0, 'Tauren Warrior say slay'), +(17933, 0, 3, 'This world is not for you!', 12, 0, 100, 0, 0, 0, 18498, 0, 'Tauren Warrior say slay'), +(17933, 1, 0, 'I return... to the earth.', 12, 0, 100, 0, 0, 0, 18495, 0, 'Tauren Warrior say death'), +(17933, 1, 1, 'My spirit... goes on.', 12, 0, 100, 0, 0, 0, 18496, 0, 'Tauren Warrior say death'), +(17936, 0, 1, 'I am one... with all.', 12, 0, 100, 0, 0, 0, 18510, 0, 'Horde Shaman say slay'), +(17936, 1, 0, 'My spirit... goes on.', 12, 0, 100, 0, 0, 0, 18496, 0, 'Horde Shaman say death'), +(17772, 7, 0, '%s begins channelling a massive teleport spell. ', 16, 0, 100, 0, 0, 0, 15310, 0, 'jaina hyjal horde base SUCCESS'); + +-- enable gargoyle frost wyrm fly +DELETE FROM `creature_template_movement` WHERE `CreatureID` IN (17906,17907); +INSERT INTO `creature_template_movement`(`CreatureId`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random`, `InteractionPauseTimer`) VALUES +(17906, 0, 0, 1, 0, 0, 0, NULL), +(17907, 0, 0, 1, 0, 0, 0, NULL); + +-- add protection of elune(38528) spell script +DELETE FROM `spell_script_names` WHERE `spell_id`=38528; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(38528,'spell_protection_of_elune'); + +-- change wrong position and movement type of worldtree channel target +DELETE FROM `creature` WHERE `guid`=6747; +INSERT INTO `creature`(`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES +(6747, 22418, 534, 0, 0, 1, 1, 0, 0, 5502.2876, -3525.4714, 1607.9094, 2.61799, 7200, 0, 0, 1, 0, 0, 0, 0, 0, '', 0); + +-- update doomfire(18095) and doomfire_spirit(18104) flag_extra to 128 +UPDATE `creature_template` SET `flags_extra` = `flags_extra`|128 WHERE `entry` IN (18095,18104); + +-- add say slay and death text for guards +DELETE FROM `smart_scripts` WHERE (`entryorguid`,`source_type`,`id`,`link`) IN ((17919,0,1,0),(17919,0,2,0),(17932,0,1,0),(17932,0,2,0),(17933,0,1,0),(17933,0,2,0),(17934,0,0,0),(17934,0,1,0),(17936,0,3,0),(17936,0,4,0)); +INSERT INTO `smart_scripts`(`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `event_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(17919, 0, 1, 0, 5, 0, 100, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Alliance Footman - In Combat - Say Slay'), +(17919, 0, 2, 0, 6, 0, 100, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Alliance Footman - In Combat - Say Death'), +(17932, 0, 1, 0, 5, 0, 100, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Horde Grunt - In Combat - Say Slay'), +(17932, 0, 2, 0, 6, 0, 100, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Horde Grunt - In Combat - Say Death'), +(17933, 0, 1, 0, 5, 0, 100, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Tauren Warrior - In Combat - Say Slay'), +(17933, 0, 2, 0, 6, 0, 100, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Tauren Warrior - In Combat - Say Death'), +(17934, 0, 0, 0, 5, 0, 100, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Horde Headhunter - In Combat - Say Slay'), +(17934, 0, 1, 0, 6, 0, 100, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Horde Headhunter - In Combat - Say Death'), +(17936, 0, 3, 0, 5, 0, 100, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Horde Shaman - In Combat - Say Slay'), +(17936, 0, 4, 0, 6, 0, 100, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Horde Shaman - In Combat - Say Death'); +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` IN (17919,17934,17932,17933,17936); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_19_00_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_19_00_world.sql new file mode 100644 index 00000000000..0a27d3916e1 --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_19_00_world.sql @@ -0,0 +1,38 @@ +DELETE FROM `spawn_group_template` WHERE `groupId` BETWEEN 130 AND 136; +INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES +(130,'Deadmines - Edwin VanCleef',4), +(131,'Deadmines - Captain Greenskin',4), +(132,'Deadmines - Cookie',4), +(133,'Deadmines - Mr. Smite',4), +(134,'Deadmines - Gilnid',4), +(135,'Deadmines - Sneed',4), +(136,'Deadmines - Rhahk''Zor',4); + +DELETE FROM `instance_spawn_groups` WHERE `spawnGroupId` BETWEEN 130 AND 136; +INSERT INTO `instance_spawn_groups` (`instanceMapId`,`bossStateId`,`bossStates`,`spawnGroupId`,`flags`) VALUES +(36,5,23,130,1), +(36,4,23,131,1), +(36,6,23,132,1), +(36,3,23,133,1), +(36,2,23,134,1), +(36,1,23,135,1), +(36,0,23,136,1); + +DELETE FROM `spawn_group` WHERE `groupId` BETWEEN 130 AND 136; +INSERT INTO `spawn_group` SELECT 130, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=79336 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 131, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=79333 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 132, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=79344 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 133, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=79337 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 134, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=79206 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 135, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=79223 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 136, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=79168 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES +(130,0,79336), +(131,0,79333), +(132,0,79344), +(133,0,79337), +(134,0,79206), +(135,0,79223), +(136,0,79168); + +DELETE FROM `linked_respawn` WHERE `linkedGuid` IN (79336,79333,79344,79337,79206,79223,79168); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_19_01_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_19_01_world.sql new file mode 100644 index 00000000000..5d9f8ee3604 --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_19_01_world.sql @@ -0,0 +1,42 @@ +DELETE FROM `spawn_group_template` WHERE `groupId` BETWEEN 137 AND 144; +INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES +(137,'Molten Core - Magmadar',4), +(138,'Molten Core - Lucifron',4), +(139,'Molten Core - Gehennas',4), +(140,'Molten Core - Garr',4), +(141,'Molten Core - Shazzrah',4), +(142,'Molten Core - Baron Geddon',4), +(143,'Molten Core - Sulfuron Harbinger',4), +(144,'Molten Core - Golemagg the Incinerator',4); + +DELETE FROM `instance_spawn_groups` WHERE `spawnGroupId` BETWEEN 137 AND 144; +INSERT INTO `instance_spawn_groups` (`instanceMapId`,`bossStateId`,`bossStates`,`spawnGroupId`,`flags`) VALUES +(409,1,23,137,1), +(409,0,23,138,1), +(409,2,23,139,1), +(409,3,23,140,1), +(409,4,23,141,1), +(409,5,23,142,1), +(409,6,23,143,1), +(409,7,23,144,1); + +DELETE FROM `spawn_group` WHERE `groupId` BETWEEN 137 AND 144; +INSERT INTO `spawn_group` SELECT 137, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=56683 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 138, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=56605 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 139, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=56737 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 140, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=56609 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 141, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=56608 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 142, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=56655 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 143, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=56677 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 144, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=56684 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES +(137,0,56683), +(138,0,56605), +(139,0,56737), +(140,0,56609), +(141,0,56608), +(142,0,56655), +(143,0,56677), +(144,0,56684); + +DELETE FROM `linked_respawn` WHERE `linkedGuid` IN (56683,56605,56737,56609,56608,56655,56677,56684); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_19_02_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_19_02_world.sql new file mode 100644 index 00000000000..fdf3d52700e --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_19_02_world.sql @@ -0,0 +1,26 @@ +DELETE FROM `spawn_group_template` WHERE `groupId` BETWEEN 145 AND 148; +INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES +(145,'Ahn''Qiraj Temple - The Prophet Skeram',4), +(146,'Ahn''Qiraj Temple - Battleguard Sartura',4), +(147,'Ahn''Qiraj Temple - Fankriss the Unyielding',4), +(148,'Ahn''Qiraj Temple - Princess Huhuran',4); + +DELETE FROM `instance_spawn_groups` WHERE `spawnGroupId` BETWEEN 145 AND 148; +INSERT INTO `instance_spawn_groups` (`instanceMapId`,`bossStateId`,`bossStates`,`spawnGroupId`,`flags`) VALUES +(531,0,23,145,1), +(531,1,23,146,1), +(531,2,23,147,1), +(531,3,23,148,1); + +DELETE FROM `spawn_group` WHERE `groupId` BETWEEN 145 AND 148; +INSERT INTO `spawn_group` SELECT 145, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=88075 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 146, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=87648 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 147, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=87911 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 148, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=88014 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES +(145,0,88075), +(146,0,87648), +(147,0,87911), +(148,0,88014); + +DELETE FROM `linked_respawn` WHERE `linkedGuid` IN (88075,87648,87911,88014); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_19_03_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_19_03_world.sql new file mode 100644 index 00000000000..52fe0c49eea --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_19_03_world.sql @@ -0,0 +1,42 @@ +DELETE FROM `spawn_group_template` WHERE `groupId` BETWEEN 149 AND 156; +INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES +(149,'Karazhan - Attumen the Huntsman',4), +(150,'Karazhan - Moroes',4), +(151,'Karazhan - Maiden of Virtue',4), +(152,'Karazhan - The Curator',4), +(153,'Karazhan - Shade of Aran',4), +(154,'Karazhan - Terestian Illhoof',4), +(155,'Karazhan - Netherspite',4), +(156,'Karazhan - Prince Malchezaar',4); + +DELETE FROM `instance_spawn_groups` WHERE `spawnGroupId` BETWEEN 149 AND 156; +INSERT INTO `instance_spawn_groups` (`instanceMapId`,`bossStateId`,`bossStates`,`spawnGroupId`,`flags`) VALUES +(532,0,23,149,1), +(532,1,23,150,1), +(532,2,23,151,1), +(532,5,23,152,1), +(532,6,23,153,1), +(532,7,23,154,1), +(532,8,23,155,1), +(532,10,23,156,1); + +DELETE FROM `spawn_group` WHERE `groupId` BETWEEN 149 AND 156; +INSERT INTO `spawn_group` SELECT 149, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=135159 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 150, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=135472 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 151, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=135474 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 152, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=135489 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 153, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=135692 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 154, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=135473 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 155, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=135476 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 156, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=135477 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES +(149,0,135159), +(150,0,135472), +(151,0,135474), +(152,0,135489), +(153,0,135692), +(154,0,135473), +(155,0,135476), +(156,0,135477); + +DELETE FROM `linked_respawn` WHERE `linkedGuid` IN (135159,135472,135474,135489,135692,135473,135476,135477); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_20_00_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_20_00_world.sql new file mode 100644 index 00000000000..d5948bf0a09 --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_20_00_world.sql @@ -0,0 +1,61 @@ +DELETE FROM `spawn_group_template` WHERE `groupId` BETWEEN 157 AND 168; +INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES +(157,'Naxxramas - Anub''Rekhan',4), +(158,'Naxxramas - Grand Widow Faerlina',4), +(159,'Naxxramas - Maexxna',4), +(160,'Naxxramas - Noth the Plaguebringer',4), +(161,'Naxxramas - Heigan the Unclean',4), +(162,'Naxxramas - Loatheb',4), +(163,'Naxxramas - Patchwerk',4), +(164,'Naxxramas - Grobbulus',4), +(165,'Naxxramas - Thaddius',4), +(166,'Naxxramas - Instructor Razuvious',4), +(167,'Naxxramas - Gothik the Harvester',4), +(168,'Naxxramas - The Four Horsemen',4); + +DELETE FROM `instance_spawn_groups` WHERE `spawnGroupId` BETWEEN 157 AND 168; +INSERT INTO `instance_spawn_groups` (`instanceMapId`,`bossStateId`,`bossStates`,`spawnGroupId`,`flags`) VALUES +(533,0,23,157,1), +(533,1,23,158,1), +(533,2,23,159,1), +(533,3,23,160,1), +(533,4,23,161,1), +(533,5,23,162,1), +(533,6,23,163,1), +(533,7,23,164,1), +(533,9,23,165,1), +(533,10,23,166,1), +(533,11,23,167,1), +(533,12,23,168,1); + +DELETE FROM `spawn_group` WHERE `groupId` BETWEEN 157 AND 168; +INSERT INTO `spawn_group` SELECT 157, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=127814 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 158, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=127800 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 159, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=130960 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 160, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=127801 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 161, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=127789 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 162, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=128066 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 163, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=128135 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 164, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=127781 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 165, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=130957 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 166, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=128312 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 167, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=128311 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 168, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=130963 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES +(157,0,127814), +(158,0,127800), +(159,0,130960), +(160,0,127801), +(161,0,127789), +(162,0,128066), +(163,0,128135), +(164,0,127781), +(165,0,130957), +(166,0,128312), +(167,0,128311), +(168,0,130961), +(168,0,130962), +(168,0,130963), +(168,0,130964); + +DELETE FROM `linked_respawn` WHERE `linkedGuid` IN (127814,127800,130960,127801,127789,128066,128135,127781,130957,128312,128311,130963); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_20_01_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_20_01_world.sql new file mode 100644 index 00000000000..37c7363efc5 --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_20_01_world.sql @@ -0,0 +1,26 @@ +DELETE FROM `spawn_group_template` WHERE `groupId` BETWEEN 169 AND 172; +INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES +(169,'Hellfire Citadel: The Shattered Halls - Grand Warlock Nethekurse',4), +(170,'Hellfire Citadel: The Shattered Halls - Blood Guard Porung',4), +(171,'Hellfire Citadel: The Shattered Halls - Warbringer O''mrogg',4), +(172,'Hellfire Citadel: The Shattered Halls - Warchief Kargath Bladefist',4); + +DELETE FROM `instance_spawn_groups` WHERE `spawnGroupId` BETWEEN 169 AND 172; +INSERT INTO `instance_spawn_groups` (`instanceMapId`,`bossStateId`,`bossStates`,`spawnGroupId`,`flags`) VALUES +(540,0,23,169,1), +(540,1,23,170,1), +(540,2,23,171,1), +(540,3,23,172,1); + +DELETE FROM `spawn_group` WHERE `groupId` BETWEEN 169 AND 172; +INSERT INTO `spawn_group` SELECT 169, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=57853 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 170, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=34038 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 171, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=57855 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 172, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=57854 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES +(169,0,57853), +(170,0,34038), +(171,0,57855), +(172,0,57854); + +DELETE FROM `linked_respawn` WHERE `linkedGuid` IN (57853,34038,57855,57854); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_20_02_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_20_02_world.sql new file mode 100644 index 00000000000..93e99d17373 --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_20_02_world.sql @@ -0,0 +1,22 @@ +DELETE FROM `spawn_group_template` WHERE `groupId` BETWEEN 173 AND 175; +INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES +(173,'Coilfang: The Steamvault - Hydromancer Thespia',4), +(174,'Coilfang: The Steamvault - Mekgineer Steamrigger',4), +(175,'Coilfang: The Steamvault - Warchief Kargath Bladefist',4); + +DELETE FROM `instance_spawn_groups` WHERE `spawnGroupId` BETWEEN 173 AND 175; +INSERT INTO `instance_spawn_groups` (`instanceMapId`,`bossStateId`,`bossStates`,`spawnGroupId`,`flags`) VALUES +(545,0,23,173,1), +(545,1,23,174,1), +(545,2,23,175,1); + +DELETE FROM `spawn_group` WHERE `groupId` BETWEEN 173 AND 175; +INSERT INTO `spawn_group` SELECT 173, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=3453 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 174, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=12597 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 175, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=12613 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES +(173,0,3453), +(174,0,12597), +(175,0,12613); + +DELETE FROM `linked_respawn` WHERE `linkedGuid` IN (3453,12597,12613); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_20_03_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_20_03_world.sql new file mode 100644 index 00000000000..8e92c39b35c --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_20_03_world.sql @@ -0,0 +1,22 @@ +DELETE FROM `spawn_group_template` WHERE `groupId` BETWEEN 176 AND 178; +INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES +(176,'Coilfang: The Slave Pens - Mennu the Betrayer',4), +(177,'Coilfang: The Slave Pens - Rokmar the Crackler',4), +(178,'Coilfang: The Slave Pens - Quagmirran',4); + +DELETE FROM `instance_spawn_groups` WHERE `spawnGroupId` BETWEEN 176 AND 178; +INSERT INTO `instance_spawn_groups` (`instanceMapId`,`bossStateId`,`bossStates`,`spawnGroupId`,`flags`) VALUES +(547,0,23,176,1), +(547,1,23,177,1), +(547,2,23,178,1); + +DELETE FROM `spawn_group` WHERE `groupId` BETWEEN 176 AND 178; +INSERT INTO `spawn_group` SELECT 176, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=79362 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 177, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=79339 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 178, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=80260 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES +(176,0,79362), +(177,0,79339), +(178,0,80260); + +DELETE FROM `linked_respawn` WHERE `linkedGuid` IN (79362,79339,80260); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_20_04_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_20_04_world.sql new file mode 100644 index 00000000000..7602698f650 --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_20_04_world.sql @@ -0,0 +1,30 @@ +DELETE FROM `spawn_group_template` WHERE `groupId` BETWEEN 179 AND 183; +INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES +(179,'Coilfang: Serpentshrine Cavern - Hydross the Unstable',4), +(180,'Coilfang: Serpentshrine Cavern - The Lurker Below',4), +(181,'Coilfang: Serpentshrine Cavern - Leotheras the Blind',4), +(182,'Coilfang: Serpentshrine Cavern - Fathom-Lord Karathress',4), +(183,'Coilfang: Serpentshrine Cavern - Morogrim Tidewalker',4); + +DELETE FROM `instance_spawn_groups` WHERE `spawnGroupId` BETWEEN 179 AND 183; +INSERT INTO `instance_spawn_groups` (`instanceMapId`,`bossStateId`,`bossStates`,`spawnGroupId`,`flags`) VALUES +(547,0,23,179,1), +(547,1,23,180,1), +(547,2,23,181,1), +(547,3,23,182,1), +(547,4,23,183,1); + +DELETE FROM `spawn_group` WHERE `groupId` BETWEEN 179 AND 183; +INSERT INTO `spawn_group` SELECT 179, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=93846 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 180, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=93838 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 181, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=93773 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 182, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=93766 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 183, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=82974 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES +(179,0,93846), +(180,0,93838), +(181,0,93773), +(182,0,93766), +(183,0,82974); + +DELETE FROM `linked_respawn` WHERE `linkedGuid` IN (93846,93838,93773,93766,82974); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_20_05_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_20_05_world.sql new file mode 100644 index 00000000000..e358954a02c --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_20_05_world.sql @@ -0,0 +1,22 @@ +DELETE FROM `spawn_group_template` WHERE `groupId` BETWEEN 184 AND 186; +INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES +(184,'Tempest Keep: The Arcatraz - Zereketh the Unbound',4), +(185,'Tempest Keep: The Arcatraz - Wrath-Scryer Soccothrates',4), +(186,'Tempest Keep: The Arcatraz - Harbinger Skyriss',4); + +DELETE FROM `instance_spawn_groups` WHERE `spawnGroupId` BETWEEN 184 AND 186; +INSERT INTO `instance_spawn_groups` (`instanceMapId`,`bossStateId`,`bossStates`,`spawnGroupId`,`flags`) VALUES +(552,0,23,184,1), +(552,2,23,185,1), +(552,3,23,186,1); + +DELETE FROM `spawn_group` WHERE `groupId` BETWEEN 184 AND 186; +INSERT INTO `spawn_group` SELECT 184, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=79391 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 185, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=79398 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 186, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=79451 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES +(184,0,79391), +(185,0,79398), +(186,0,79451); + +DELETE FROM `linked_respawn` WHERE `linkedGuid` IN (79391,79398,79451); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_20_06_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_20_06_world.sql new file mode 100644 index 00000000000..79b35b9c665 --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_20_06_world.sql @@ -0,0 +1,30 @@ +DELETE FROM `spawn_group_template` WHERE `groupId` BETWEEN 187 AND 191; +INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES +(187,'Tempest Keep: The Botanica - Commander Sarannis',4), +(188,'Tempest Keep: The Botanica - High Botanist Freywinn',4), +(189,'Tempest Keep: The Botanica - Thorngrin the Tender',4), +(190,'Tempest Keep: The Botanica - Laj',4), +(191,'Tempest Keep: The Botanica - Warp Splinter',4); + +DELETE FROM `instance_spawn_groups` WHERE `spawnGroupId` BETWEEN 187 AND 191; +INSERT INTO `instance_spawn_groups` (`instanceMapId`,`bossStateId`,`bossStates`,`spawnGroupId`,`flags`) VALUES +(553,0,23,187,1), +(553,1,23,188,1), +(553,2,23,189,1), +(553,3,23,190,1), +(553,4,23,191,1); + +DELETE FROM `spawn_group` WHERE `groupId` BETWEEN 187 AND 191; +INSERT INTO `spawn_group` SELECT 187, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=82986 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 188, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=82987 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 189, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=83076 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 190, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=82989 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 191, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=82990 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES +(187,0,82986), +(188,0,82987), +(189,0,83076), +(190,0,82989), +(191,0,82990); + +DELETE FROM `linked_respawn` WHERE `linkedGuid` IN (82986,82987,83076,82989,82990); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_21_00_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_21_00_world.sql new file mode 100644 index 00000000000..35cb6fc96c9 --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_21_00_world.sql @@ -0,0 +1,22 @@ +DELETE FROM `spawn_group_template` WHERE `groupId` BETWEEN 192 AND 194; +INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES +(192,'Tempest Keep: The Mechanar - Mechano-Lord Capacitus',4), +(193,'Tempest Keep: The Mechanar - Nethermancer Sepethrea',4), +(194,'Tempest Keep: The Mechanar - Pathaleon the Calculator',4); + +DELETE FROM `instance_spawn_groups` WHERE `spawnGroupId` BETWEEN 192 AND 194; +INSERT INTO `instance_spawn_groups` (`instanceMapId`,`bossStateId`,`bossStates`,`spawnGroupId`,`flags`) VALUES +(554,2,23,192,1), +(554,3,23,193,1), +(554,4,23,194,1); + +DELETE FROM `spawn_group` WHERE `groupId` BETWEEN 192 AND 194; +INSERT INTO `spawn_group` SELECT 192, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=83160 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 193, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=83230 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 194, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=83241 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES +(192,0,83160), +(193,0,83230), +(194,0,83241); + +DELETE FROM `linked_respawn` WHERE `linkedGuid` IN (83160,83230,83241); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_21_01_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_21_01_world.sql new file mode 100644 index 00000000000..86595cb893e --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_21_01_world.sql @@ -0,0 +1,26 @@ +DELETE FROM `spawn_group_template` WHERE `groupId` BETWEEN 195 AND 198; +INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES +(195,'Auchindoun: Shadow Labyrinth - Ambassador Hellmaw',4), +(196,'Auchindoun: Shadow Labyrinth - Blackheart the Inciter',4), +(197,'Auchindoun: Shadow Labyrinth - Grandmaster Vorpil',4), +(198,'Auchindoun: Shadow Labyrinth - Murmur',4); + +DELETE FROM `instance_spawn_groups` WHERE `spawnGroupId` BETWEEN 195 AND 198; +INSERT INTO `instance_spawn_groups` (`instanceMapId`,`bossStateId`,`bossStates`,`spawnGroupId`,`flags`) VALUES +(555,0,23,195,1), +(555,1,23,196,1), +(555,2,23,197,1), +(555,3,23,198,1); + +DELETE FROM `spawn_group` WHERE `groupId` BETWEEN 195 AND 198; +INSERT INTO `spawn_group` SELECT 195, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=66999 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 196, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=66937 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 197, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=67000 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 198, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=66952 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES +(195,0,66999), +(196,0,66937), +(197,0,67000), +(198,0,66952); + +DELETE FROM `linked_respawn` WHERE `linkedGuid` IN (66999,66937,67000,66952); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_21_02_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_21_02_world.sql new file mode 100644 index 00000000000..7b0059273b9 --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_21_02_world.sql @@ -0,0 +1,18 @@ +DELETE FROM `spawn_group_template` WHERE `groupId` BETWEEN 199 AND 200; +INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES +(199,'Auchindoun: Sethekk Halls - Darkweaver Syth',4), +(200,'Auchindoun: Sethekk Halls - Talon King Ikiss',4); + +DELETE FROM `instance_spawn_groups` WHERE `spawnGroupId` BETWEEN 199 AND 200; +INSERT INTO `instance_spawn_groups` (`instanceMapId`,`bossStateId`,`bossStates`,`spawnGroupId`,`flags`) VALUES +(556,0,23,199,1), +(556,1,23,200,1); + +DELETE FROM `spawn_group` WHERE `groupId` BETWEEN 199 AND 200; +INSERT INTO `spawn_group` SELECT 199, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=83270 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 200, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=83300 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES +(199,0,83270), +(200,0,83300); + +DELETE FROM `linked_respawn` WHERE `linkedGuid` IN (83270,83300); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_21_03_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_21_03_world.sql new file mode 100644 index 00000000000..cc6c8b438b3 --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_21_03_world.sql @@ -0,0 +1,22 @@ +DELETE FROM `spawn_group_template` WHERE `groupId` BETWEEN 201 AND 203; +INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES +(201,'Auchindoun: Mana-Tombs - Pandemonius',4), +(202,'Auchindoun: Mana-Tombs - Tavarok',4), +(203,'Auchindoun: Mana-Tombs - Nexus-Prince Shaffar',4); + +DELETE FROM `instance_spawn_groups` WHERE `spawnGroupId` BETWEEN 201 AND 203; +INSERT INTO `instance_spawn_groups` (`instanceMapId`,`bossStateId`,`bossStates`,`spawnGroupId`,`flags`) VALUES +(557,0,23,201,1), +(557,1,23,202,1), +(557,2,23,203,1); + +DELETE FROM `spawn_group` WHERE `groupId` BETWEEN 201 AND 203; +INSERT INTO `spawn_group` SELECT 201, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=91163 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 202, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=91161 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 203, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=91162 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES +(201,0,91163), +(202,0,91161), +(203,0,91162); + +DELETE FROM `linked_respawn` WHERE `linkedGuid` IN (91163,91161,91162); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_21_04_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_21_04_world.sql new file mode 100644 index 00000000000..2bcdcb8d1f6 --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_21_04_world.sql @@ -0,0 +1,18 @@ +DELETE FROM `spawn_group_template` WHERE `groupId` BETWEEN 204 AND 205; +INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES +(204,'Auchindoun: Auchenai Crypts - Shirrak the Dead Watcher',4), +(205,'Auchindoun: Auchenai Crypts - Exarch Maladaar',4); + +DELETE FROM `instance_spawn_groups` WHERE `spawnGroupId` BETWEEN 204 AND 205; +INSERT INTO `instance_spawn_groups` (`instanceMapId`,`bossStateId`,`bossStates`,`spawnGroupId`,`flags`) VALUES +(556,0,23,204,1), +(556,1,23,205,1); + +DELETE FROM `spawn_group` WHERE `groupId` BETWEEN 204 AND 205; +INSERT INTO `spawn_group` SELECT 204, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=83388 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 205, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=83453 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES +(204,0,83388), +(205,0,83453); + +DELETE FROM `linked_respawn` WHERE `linkedGuid` IN (83388,83453); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_21_05_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_21_05_world.sql new file mode 100644 index 00000000000..46cbad0d42b --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_21_05_world.sql @@ -0,0 +1,46 @@ +DELETE FROM `spawn_group_template` WHERE `groupId` BETWEEN 206 AND 214; +INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES +(206,'Black Temple - High Warlord Naj''entus',4), +(207,'Black Temple - Supremus',4), +(208,'Black Temple - Shade of Akama',4), +(209,'Black Temple - Teron Gorefiend',4), +(210,'Black Temple - Gurtogg Bloodboil',4), +(211,'Black Temple - Reliquary of Souls',4), +(212,'Black Temple - Mother Shahraz',4), +(213,'Black Temple - The Illidari Council',4), +(214,'Black Temple - Illidan Stormrage',4); + +DELETE FROM `instance_spawn_groups` WHERE `spawnGroupId` BETWEEN 206 AND 214; +INSERT INTO `instance_spawn_groups` (`instanceMapId`,`bossStateId`,`bossStates`,`spawnGroupId`,`flags`) VALUES +(564,0,23,206,1), +(564,1,23,207,1), +(564,2,23,208,1), +(564,3,23,209,1), +(564,4,23,210,1), +(564,5,23,211,1), +(564,6,23,212,1), +(564,7,23,213,1), +(564,8,23,214,1); + +DELETE FROM `spawn_group` WHERE `groupId` BETWEEN 206 AND 214; +INSERT INTO `spawn_group` SELECT 206, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=40527 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 207, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=52458 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 208, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=12777 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 209, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=12843 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 210, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=52761 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 211, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=12828 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 212, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=52760 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 213, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=52479 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 214, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=52484 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES +(206,0,40527), +(207,0,52458), +(208,0,12777), +(209,0,12843), +(210,0,52761), +(211,0,12828), +(212,0,52760), +(213,0,52479), +(214,0,52484); + +DELETE FROM `linked_respawn` WHERE `linkedGuid` IN (40527,52458,12777,12843,52761,12828,52760,52479,52484); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_21_06_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_21_06_world.sql new file mode 100644 index 00000000000..4b7c59606cd --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_21_06_world.sql @@ -0,0 +1,35 @@ +DELETE FROM `spawn_group_template` WHERE `groupId` BETWEEN 215 AND 220; +INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES +(215,'Zul''Aman - Nalorakk',4), +(216,'Zul''Aman - Akil''zon',4), +(217,'Zul''Aman - Jan''alai',4), +(218,'Zul''Aman - Halazzi',4), +(219,'Zul''Aman - Hex Lord Malacrass',4), +(220,'Zul''Aman - Zul''jin',4); + + +DELETE FROM `instance_spawn_groups` WHERE `spawnGroupId` BETWEEN 215 AND 220; +INSERT INTO `instance_spawn_groups` (`instanceMapId`,`bossStateId`,`bossStates`,`spawnGroupId`,`flags`) VALUES +(568,0,23,215,1), +(568,1,23,216,1), +(568,2,23,217,1), +(568,3,23,218,1), +(568,4,23,219,1), +(568,5,23,220,1); + +DELETE FROM `spawn_group` WHERE `groupId` BETWEEN 215 AND 220; +INSERT INTO `spawn_group` SELECT 215, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=86609 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 216, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=86494 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 217, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=89322 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 218, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=86195 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 219, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=89357 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 220, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=89358 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES +(215,0,86609), +(216,0,86494), +(217,0,89322), +(218,0,86195), +(219,0,89357), +(220,0,89358); + +DELETE FROM `linked_respawn` WHERE `linkedGuid` IN (86609,86494,89322,86195,89357,89358); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_21_07_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_21_07_world.sql new file mode 100644 index 00000000000..4362c8458b8 --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_21_07_world.sql @@ -0,0 +1,22 @@ +DELETE FROM `spawn_group_template` WHERE `groupId` BETWEEN 221 AND 223; +INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES +(221,'Utgarde Keep - Prince Keleseth',4), +(222,'Utgarde Keep - Skarvold & Dalronn',4), +(223,'Utgarde Keep - Ingvar the Plunderer',4); + +DELETE FROM `instance_spawn_groups` WHERE `spawnGroupId` BETWEEN 221 AND 223; +INSERT INTO `instance_spawn_groups` (`instanceMapId`,`bossStateId`,`bossStates`,`spawnGroupId`,`flags`) VALUES +(574,0,23,221,1), +(574,1,23,222,1), +(574,2,23,223,1); + +DELETE FROM `spawn_group` WHERE `groupId` BETWEEN 221 AND 223; +INSERT INTO `spawn_group` SELECT 221, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=126025 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 222, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=126023 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 223, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=126026 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES +(221,0,126025), +(222,0,126023), +(223,0,126026); + +DELETE FROM `linked_respawn` WHERE `linkedGuid` IN (126025,126023,126026); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_21_08_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_21_08_world.sql new file mode 100644 index 00000000000..5267144151d --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_21_08_world.sql @@ -0,0 +1,18 @@ +DELETE FROM `spawn_group_template` WHERE `groupId` BETWEEN 224 AND 225; +INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES +(224,'Utgarde Pinnacle - Svala Sorrowgrave',4), +(225,'Utgarde Pinnacle - King Ymiron',4); + +DELETE FROM `instance_spawn_groups` WHERE `spawnGroupId` BETWEEN 224 AND 225; +INSERT INTO `instance_spawn_groups` (`instanceMapId`,`bossStateId`,`bossStates`,`spawnGroupId`,`flags`) VALUES +(575,0,23,224,1), +(575,3,23,225,1); + +DELETE FROM `spawn_group` WHERE `groupId` BETWEEN 224 AND 225; +INSERT INTO `spawn_group` SELECT 224, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=126115 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 225, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=126255 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES +(224,0,126115), +(225,0,126255); + +DELETE FROM `linked_respawn` WHERE `linkedGuid` IN (126115,126255); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_21_09_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_21_09_world.sql new file mode 100644 index 00000000000..ddc7a8d8d35 --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_21_09_world.sql @@ -0,0 +1,14 @@ +DELETE FROM `spawn_group_template` WHERE `groupId` BETWEEN 226 AND 227; +INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES +(226,'Utgarde Pinnacle - Gortok Palehoof',4), +(227,'Utgarde Pinnacle - Skadi the Ruthless',4); + +DELETE FROM `instance_spawn_groups` WHERE `spawnGroupId` BETWEEN 226 AND 227; +INSERT INTO `instance_spawn_groups` (`instanceMapId`,`bossStateId`,`bossStates`,`spawnGroupId`,`flags`) VALUES +(575,2,23,226,1), +(575,2,23,227,1); + +DELETE FROM `spawn_group` WHERE `groupId` BETWEEN 226 AND 227; +INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES +(226,0,126102), +(227,0,126103); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_21_10_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_21_10_world.sql new file mode 100644 index 00000000000..9d251c94123 --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_21_10_world.sql @@ -0,0 +1,2 @@ +-- handled by spawn groups already +DELETE FROM `linked_respawn` WHERE `linkedGuid` IN (126599); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_22_00_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_22_00_world.sql new file mode 100644 index 00000000000..666ace74971 --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_22_00_world.sql @@ -0,0 +1,26 @@ +DELETE FROM `spawn_group_template` WHERE `groupId` BETWEEN 228 AND 231; +INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES +(228,'The Oculus - Drakos the Interrogator',4), +(229,'The Oculus - Varos Cloudstrider',4), +(230,'The Oculus - Mage-Lord Urom',4), +(231,'The Oculus - Ley-Guardian Eregos',4); + +DELETE FROM `instance_spawn_groups` WHERE `spawnGroupId` BETWEEN 228 AND 231; +INSERT INTO `instance_spawn_groups` (`instanceMapId`,`bossStateId`,`bossStates`,`spawnGroupId`,`flags`) VALUES +(578,0,23,228,1), +(578,1,23,229,1), +(578,2,23,230,1), +(578,3,23,231,1); + +DELETE FROM `spawn_group` WHERE `groupId` BETWEEN 228 AND 231; +INSERT INTO `spawn_group` SELECT 228, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=100172 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 229, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=100235 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 230, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=100220 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 231, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=100221 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES +(228,0,100172), +(229,0,100235), +(230,0,100220), +(231,0,100221); + +DELETE FROM `linked_respawn` WHERE `linkedGuid` IN (100172,100235,100220,100221); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_23_00_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_23_00_world.sql new file mode 100644 index 00000000000..e161c0a5f41 --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_23_00_world.sql @@ -0,0 +1 @@ +UPDATE `instance_spawn_groups` SET `instanceMapId`=558 WHERE `spawnGroupId` BETWEEN 204 AND 205; diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_23_01_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_23_01_world.sql new file mode 100644 index 00000000000..9a10735a7ac --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_23_01_world.sql @@ -0,0 +1,43 @@ +DELETE FROM `spawn_group_template` WHERE `groupId` BETWEEN 232 AND 237; +INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES +(232,'The Sunwell - Kalecgos',4), +(233,'The Sunwell - Brutallus',4), +(234,'The Sunwell - Felmyst',4), +(235,'The Sunwell - Eredar Twins',4), +(236,'The Sunwell - M''uru',4), +(237,'The Sunwell - Kil''jaeden',4); + +DELETE FROM `instance_spawn_groups` WHERE `spawnGroupId` BETWEEN 232 AND 237; +INSERT INTO `instance_spawn_groups` (`instanceMapId`,`bossStateId`,`bossStates`,`spawnGroupId`,`flags`) VALUES +(580,0,23,232,1), +(580,1,23,233,1), +(580,1,23,234,2), -- dont spawn felmyst before brutallus is dead +(580,2,23,234,1), +(580,3,23,235,1), +(580,4,23,236,1), +(580,5,23,237,1); + +DELETE FROM `creature` WHERE `guid`=55421 AND `id`=25038; +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES +(55421, 25038, 580, 4075, 4140, 1, 1, 0, 0, 1460.2911376953125, 628.89984130859375, 46.09189605712890625, 5.281038284301757812, 604800, 0, 0, 0, 0, 0, 0, 0, 0, 45745); -- Felmyst (Area: The Dead Scar - Difficulty: 4) (Auras: 45068 - Felblaze Visual) + +DELETE FROM `spawn_group` WHERE `groupId` BETWEEN 232 AND 237; +INSERT INTO `spawn_group` SELECT 232, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=54810 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 233, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=54811 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 235, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=53668 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 236, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=53705 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 237, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=56332 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES +(232,0,54810), +(232,0,53645), +(233,0,54811), +(233,0,54812), +(234,0,55421), +(235,0,53668), +(235,0,53687), +(236,0,53705), +(237,0,56332); + +UPDATE `creature_template` SET `flags_extra`=`flags_extra` & ~0x80 WHERE `entry`=25038; -- remove trigger flag from felmyst + +DELETE FROM `linked_respawn` WHERE `linkedGuid` IN (54810,54811,55421,53668,53705,56332); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_23_02_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_23_02_world.sql new file mode 100644 index 00000000000..6490283a8ca --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_23_02_world.sql @@ -0,0 +1 @@ +UPDATE `instance_spawn_groups` SET `instanceMapId`=548 WHERE `spawnGroupId` BETWEEN 179 AND 183; diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_23_03_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_23_03_world.sql new file mode 100644 index 00000000000..ff0eab69a26 --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_23_03_world.sql @@ -0,0 +1,26 @@ +DELETE FROM `spawn_group_template` WHERE `groupId` BETWEEN 238 AND 241; +INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES +(238,'Magister''s Terrace - Selin Fireheart',4), +(239,'Magister''s Terrace - Vexallus',4), +(240,'Magister''s Terrace - Priestess Delrissa',4), +(241,'Magister''s Terrace - Kael''thas Sunstrider',4); + +DELETE FROM `instance_spawn_groups` WHERE `spawnGroupId` BETWEEN 238 AND 241; +INSERT INTO `instance_spawn_groups` (`instanceMapId`,`bossStateId`,`bossStates`,`spawnGroupId`,`flags`) VALUES +(585,0,23,238,1), +(585,1,23,239,1), +(585,2,23,240,1), +(585,3,23,241,1); + +DELETE FROM `spawn_group` WHERE `groupId` BETWEEN 238 AND 241; +INSERT INTO `spawn_group` SELECT 238, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=96875 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 239, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=96876 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 240, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=96966 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 241, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=96762 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES +(238,0,96875), +(239,0,96876), +(240,0,96966), +(241,0,96762); + +DELETE FROM `linked_respawn` WHERE `linkedGuid` IN (96875,96876,96966,96762); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_24_00_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_24_00_world.sql new file mode 100644 index 00000000000..2a9897d29b2 --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_24_00_world.sql @@ -0,0 +1,39 @@ +DELETE FROM `spawn_group_template` WHERE `groupId` BETWEEN 242 AND 245; +INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES +(242,'Halls of Stone - Krystallus',4), +(243,'Halls of Stone - Maiden of Grief',4), +(244,'Halls of Stone - Tribunal of Ages',4), +(245,'Halls of Stone - Sjonnir the Ironshaper',4); + +DELETE FROM `instance_spawn_groups` WHERE `spawnGroupId` BETWEEN 242 AND 245; +INSERT INTO `instance_spawn_groups` (`instanceMapId`,`bossStateId`,`bossStates`,`spawnGroupId`,`flags`) VALUES +(599,0,23,242,1), +(599,1,23,243,1), +(599,2,23,244,1), +(599,3,23,245,1); + +DELETE FROM `spawn_group` WHERE `groupId` BETWEEN 242 AND 245; +INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES +(242,0,126790), +(243,0,126789), +(244,0,126743), +(244,0,126742), +(244,0,126737), +(244,0,126733), +(244,0,126738), +(244,0,126745), +(244,0,126744), +(244,0,126739), +(244,0,126815), +(244,0,126816), +(244,0,126817), +(244,0,126801), +(244,0,126800), +(244,0,126746), +(244,0,126749), +(244,0,126750), +(244,1,65564), +(244,1,151790), +(245,0,126792); + +DELETE FROM `linked_respawn` WHERE `linkedGuid` IN (126790,126789,126792); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_24_01_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_24_01_world.sql new file mode 100644 index 00000000000..0a86dcfb572 --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_24_01_world.sql @@ -0,0 +1,26 @@ +DELETE FROM `spawn_group_template` WHERE `groupId` BETWEEN 246 AND 249; +INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES +(246,'Drak''Tharon Keep - Trollgore',4), +(247,'Drak''Tharon Keep - Novos the Summoner',4), +(248,'Drak''Tharon Keep - King Dred',4), +(249,'Drak''Tharon Keep - The Prophet Tharon''ja',4); + +DELETE FROM `instance_spawn_groups` WHERE `spawnGroupId` BETWEEN 246 AND 249; +INSERT INTO `instance_spawn_groups` (`instanceMapId`,`bossStateId`,`bossStates`,`spawnGroupId`,`flags`) VALUES +(600,0,23,246,1), +(600,1,23,247,1), +(600,2,23,248,1), +(600,3,23,249,1); + +DELETE FROM `spawn_group` WHERE `groupId` BETWEEN 246 AND 249; +INSERT INTO `spawn_group` SELECT 246, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=127422 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 247, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=127424 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 248, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=127507 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 249, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=200143 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES +(246,0,127422), +(247,0,127424), +(248,0,127507), +(249,0,200143); + +DELETE FROM `linked_respawn` WHERE `linkedGuid` IN (127422,127424,127507,200143); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_24_02_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_24_02_world.sql new file mode 100644 index 00000000000..75218212641 --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_24_02_world.sql @@ -0,0 +1,22 @@ +DELETE FROM `spawn_group_template` WHERE `groupId` BETWEEN 250 AND 252; +INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES +(250,'Azjol-Nerub - Krik''thir the Gatewatcher',4), +(251,'Azjol-Nerub - Hadronox',4), +(252,'Azjol-Nerub - Anub''arak',4); + +DELETE FROM `instance_spawn_groups` WHERE `spawnGroupId` BETWEEN 250 AND 252; +INSERT INTO `instance_spawn_groups` (`instanceMapId`,`bossStateId`,`bossStates`,`spawnGroupId`,`flags`) VALUES +(601,0,23,250,1), +(601,1,23,251,1), +(601,2,23,252,1); + +DELETE FROM `spawn_group` WHERE `groupId` BETWEEN 250 AND 252; +INSERT INTO `spawn_group` SELECT 250, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=127214 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 251, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=127401 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 252, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=132273 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES +(250,0,127214), +(251,0,127401), +(252,0,132273); + +DELETE FROM `linked_respawn` WHERE `linkedGuid` IN (127214,127401,132273); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_24_03_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_24_03_world.sql new file mode 100644 index 00000000000..a05e9eec733 --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_24_03_world.sql @@ -0,0 +1,26 @@ +DELETE FROM `spawn_group_template` WHERE `groupId` BETWEEN 253 AND 256; +INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES +(253,'Halls of Lightning - General Bjarngrim',4), +(254,'Halls of Lightning - Volkhan',4), +(255,'Halls of Lightning - Ionar',4), +(256,'Halls of Lightning - Loken',4); + +DELETE FROM `instance_spawn_groups` WHERE `spawnGroupId` BETWEEN 253 AND 256; +INSERT INTO `instance_spawn_groups` (`instanceMapId`,`bossStateId`,`bossStates`,`spawnGroupId`,`flags`) VALUES +(602,0,23,253,1), +(602,1,23,254,1), +(602,2,23,255,1), +(602,3,23,256,1); + +DELETE FROM `spawn_group` WHERE `groupId` BETWEEN 253 AND 256; +INSERT INTO `spawn_group` SELECT 253, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=126981 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 254, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=126982 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 255, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=126873 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 256, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=126985 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES +(253,0,126981), +(254,0,126982), +(255,0,126873), +(256,0,126985); + +DELETE FROM `linked_respawn` WHERE `linkedGuid` IN (126981,126982,126873,126985); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_24_04_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_24_04_world.sql new file mode 100644 index 00000000000..b7f9e5d719e --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_24_04_world.sql @@ -0,0 +1 @@ +DELETE FROM `linked_respawn` WHERE `linkedGuid` IN (127042); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_24_05_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_24_05_world.sql new file mode 100644 index 00000000000..97dbc0ba9a8 --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_24_05_world.sql @@ -0,0 +1,30 @@ +DELETE FROM `spawn_group_template` WHERE `groupId` BETWEEN 257 AND 261; +INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES +(257,'Ahn''kahet: The Old Kingdom - Elder Nadox',4), +(258,'Ahn''kahet: The Old Kingdom - Prince Taldaram',4), +(259,'Ahn''kahet: The Old Kingdom - Jedoga Shadowseeker',4), +(260,'Ahn''kahet: The Old Kingdom - Amanitar',4), +(261,'Ahn''kahet: The Old Kingdom - Herald Volazj',4); + +DELETE FROM `instance_spawn_groups` WHERE `spawnGroupId` BETWEEN 257 AND 261; +INSERT INTO `instance_spawn_groups` (`instanceMapId`,`bossStateId`,`bossStates`,`spawnGroupId`,`flags`) VALUES +(619,0,23,257,1), +(619,1,23,258,1), +(619,2,23,259,1), +(619,3,23,260,1), +(619,4,23,261,1); + +DELETE FROM `spawn_group` WHERE `groupId` BETWEEN 257 AND 261; +INSERT INTO `spawn_group` SELECT 257, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=131952 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 258, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=131951 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 259, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=131953 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 260, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=202410 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` SELECT 261, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=132298 AND `linkType` IN (0,3); +INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES +(257,0,131952), +(258,0,131951), +(259,0,131953), +(260,0,202410), +(261,0,132298); + +DELETE FROM `linked_respawn` WHERE `linkedGuid` IN (131952,131951,131953,202410,132298); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_25_00_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_25_00_world.sql new file mode 100644 index 00000000000..e00b3880de1 --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_25_00_world.sql @@ -0,0 +1,75 @@ +DELETE FROM `spawn_group_template` WHERE `groupId` BETWEEN 262 AND 275; +INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES +(262,'Icecrown Citadel - Lord Marrowgar',4), +(263,'Icecrown Citadel - Lady Deathwhisper',4), +(264,'Icecrown Citadel - Deathbringer Saurfang',4), +(265,'Icecrown Citadel - Rotface',4), +(266,'Icecrown Citadel - Festergut',4), +(267,'Icecrown Citadel - Professor Putricide',4), +(268,'Icecrown Citadel - Blood Council',4), +(269,'Icecrown Citadel - Queen Lana''thel',4), +(270,'Icecrown Citadel - Valithria Dreamwalker',4), +(271,'Icecrown Citadel - The Lich King',4), +(272,'Icecrown Citadel - Sister Svalna',4), +(273,'Icecrown Citadel - Rimefang',4), +(274,'Icecrown Citadel - Spinestalker',4), +(275,'Icecrown Citadel - The Damned RP Event at entrance',0); + +DELETE FROM `instance_spawn_groups` WHERE `spawnGroupId` BETWEEN 262 AND 275; +INSERT INTO `instance_spawn_groups` (`instanceMapId`,`bossStateId`,`bossStates`,`spawnGroupId`,`flags`) VALUES +(631, 0,23,262,1), +(631, 1,23,263,1), +(631, 3,23,264,1), +(631, 5,23,265,1), +(631, 4,23,266,1), +(631, 6,23,267,1), +(631, 7,23,268,1), +(631, 8,23,269,1), +(631, 9,23,270,1), +(631,11,23,271,1), +(631, 9,23,272,1), +(631,10,23,273,1), +(631,10,23,274,1); + +DELETE FROM `spawn_group` WHERE `groupId` BETWEEN 262 AND 275; +INSERT INTO `spawn_group` SELECT 262, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=200992 AND `linkType` IN (0,3) AND `guid`<>`linkedGuid`; +INSERT INTO `spawn_group` SELECT 263, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=201129 AND `linkType` IN (0,3) AND `guid`<>`linkedGuid`; +INSERT INTO `spawn_group` SELECT 264, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=201122 AND `linkType` IN (0,3) AND `guid`<>`linkedGuid`; +INSERT INTO `spawn_group` SELECT 265, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=201433 AND `linkType` IN (0,3) AND `guid`<>`linkedGuid`; +INSERT INTO `spawn_group` SELECT 266, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=201255 AND `linkType` IN (0,3) AND `guid`<>`linkedGuid`; +INSERT INTO `spawn_group` SELECT 267, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=201294 AND `linkType` IN (0,3) AND `guid`<>`linkedGuid`; +INSERT INTO `spawn_group` SELECT 268, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=201369 AND `linkType` IN (0,3) AND `guid`<>`linkedGuid`; +INSERT INTO `spawn_group` SELECT 269, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=201246 AND `linkType` IN (0,3) AND `guid`<>`linkedGuid`; +INSERT INTO `spawn_group` SELECT 270, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=137752 AND `linkType` IN (0,3) AND `guid`<>`linkedGuid`; +INSERT INTO `spawn_group` SELECT 271, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=150211 AND `linkType` IN (0,3) AND `guid`<>`linkedGuid`; +INSERT INTO `spawn_group` SELECT 272, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=137753 AND `linkType` IN (0,3) AND `guid`<>`linkedGuid`; +INSERT INTO `spawn_group` SELECT 273, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=207210 AND `linkType` IN (0,3) AND `guid`<>`linkedGuid`; +INSERT INTO `spawn_group` SELECT 274, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=207211 AND `linkType` IN (0,3) AND `guid`<>`linkedGuid`; +INSERT INTO `spawn_group` SELECT 275, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=200984 AND `linkType` IN (0,3) AND `guid`<>`linkedGuid`; +INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES +(262,0,200992), +(263,0,201129), +(264,0,201122), +(264,0,200982), +(264,0,200907), +(264,0,200944), +(264,0,201069), +(264,0,201034), +(264,0,201184), +(264,1,151165), +(264,1,151166), +(264,1,151167), +(264,1,151168), +(265,0,201433), +(266,0,201255), +(267,0,201294), +(268,0,201369), +(269,0,201246), +(270,0,137752), +(271,0,150211), +(272,0,137753), +(273,0,207210), +(274,0,207211), +(275,0,200984); + +DELETE FROM `linked_respawn` WHERE `linkedGuid` IN (200992,201129,201122,201433,201255,201294,201369,201246,137752,150211,137753,207210,207211,200984); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_25_01_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_25_01_world.sql new file mode 100644 index 00000000000..f1d12dfb14c --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_25_01_world.sql @@ -0,0 +1,17 @@ +DELETE FROM `spawn_group_template` WHERE `groupId` BETWEEN 276 AND 278; +INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES +(276,'Hellfire Citadel: The Blood Furnace - The Maker',4), +(277,'Hellfire Citadel: The Blood Furnace - Broggok',4), +(278,'Hellfire Citadel: The Blood Furnace - Keli''dan the Breaker',4); + +DELETE FROM `instance_spawn_groups` WHERE `spawnGroupId` BETWEEN 276 AND 278; +INSERT INTO `instance_spawn_groups` (`instanceMapId`,`bossStateId`,`bossStates`,`spawnGroupId`,`flags`) VALUES +(542,0,23,276,1), +(542,1,23,277,1), +(542,2,23,278,1); + +DELETE FROM `spawn_group` WHERE `groupId` BETWEEN 276 AND 278; +INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES +(276,0,138123), +(277,0,138115), +(278,0,138147); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_25_02_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_25_02_world.sql new file mode 100644 index 00000000000..6a3871d0bd5 --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_25_02_world.sql @@ -0,0 +1,44 @@ +-- +UPDATE `creature_template` SET `ScriptName`= 'npc_volkhan_molten_golem' WHERE `entry`= 28695; +UPDATE `creature_template` SET `mechanic_immune_mask`= `mechanic_immune_mask` | 0x2000000 | 0x100 WHERE `entry` IN (28587, 31536); + +UPDATE `creature` SET `wander_distance`= 0, `MovementType`= 0 WHERE `guid`= 126875; +DELETE FROM `creature_template_movement` WHERE `CreatureId`= 28823; +INSERT INTO `creature_template_movement` (`CreatureId`, `Ground`, `Swim`, `Flight`, `Rooted`) VALUES +(28823, 0, 0, 1, 1); + +DELETE FROM `creature_text` WHERE `CreatureID`= 28587; +INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `comment`) VALUES +(28587, 0, 0, 'It is you who have destroyed my children? You... shall... pay!', 14, 0, 100, 0, 0, 13960, 31415, 'Volkhan - Aggro'), +(28587, 1, 0, '%s runs to his anvil!', 41, 0, 100, 0, 0, 0, 32214, 'Volkhan - Announce Run to Anvil'), +(28587, 2, 0, 'Nothing is wasted in the process. You will see....', 14, 0, 100, 0, 0, 13962, 31417, 'Volkhan - Run to Anvil'), +(28587, 2, 1, 'Life from lifelessness... death for you.', 14, 0, 100, 0, 0, 13961, 31416, 'Volkhan - Run to Anvil'), +(28587, 3, 0, 'All my work... undone!', 14, 0, 100, 0, 0, 13964, 31419, 'Volkhan - Shattering Stomp'), +(28587, 3, 1, 'I will crush you beneath my boots!', 14, 0, 100, 0, 0, 13963, 31418, 'Volkhan - Shattering Stomp'), +(28587, 4, 0, '%s prepares to shatter his Brittle Golems!', 41, 0, 100, 0, 0, 0, 29823, 'Volkhan - Announce Shattering Stomp'), +(28587, 5, 0, 'The master was right... to be concerned.', 14, 0, 100, 0, 0, 13968, 31423, 'Volkhan - Death'), +(28587, 6, 0, 'The armies of iron will conquer all!', 14, 0, 100, 0, 0, 13965, 31420, 'Volkhan - Slay'), +(28587, 6, 1, 'Feh! Pathetic!', 14, 0, 100, 0, 0, 13966, 31421, 'Volkhan - Slay'), +(28587, 6, 2, 'You have cost me too much work!', 14, 0, 100, 0, 0, 13967, 31422, 'Volkhan - Slay'); + +DELETE FROM `conditions` WHERE `SourceEntry` IN (52661, 52654, 52238, 52387, 59528) AND `SourceTypeOrReferenceId`= 13; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ScriptName`, `Comment`) VALUES +(13, 1, 52661, 0, 0, 31, 0, 3, 28823, 0, 0, 0, '', 'Temper - Target Volkhan''s Anvil'), +(13, 1, 52654, 0, 0, 31, 0, 3, 28823, 0, 0, 0, '', 'Temper - Target Volkhan''s Anvil'), +(13, 1, 52238, 0, 0, 31, 0, 3, 28823, 0, 0, 0, '', 'Temper - Target Volkhan''s Anvil'), +(13, 1, 52387, 0, 0, 31, 0, 3, 28695, 0, 0, 0, '', 'Heat - Target Molten Golem'), +(13, 1, 59528, 0, 0, 31, 0, 3, 28695, 0, 0, 0, '', 'Heat - Target Molten Golem'); + +DELETE FROM `spell_script_names` WHERE `ScriptName` IN +('spell_volkhan_temper_dummy', +'spell_volkhan_cool_down', +'spell_volkhan_cosmetic_stun_immune_permanent', +'spell_volkhan_shattering_stomp'); + +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(52654, 'spell_volkhan_temper_dummy'), +(52238, 'spell_volkhan_temper_dummy'), +(52441, 'spell_volkhan_cool_down'), +(59123, 'spell_volkhan_cosmetic_stun_immune_permanent'), +(52237, 'spell_volkhan_shattering_stomp'), +(59529, 'spell_volkhan_shattering_stomp'); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_25_03_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_25_03_world.sql new file mode 100644 index 00000000000..e132ec0da13 --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_25_03_world.sql @@ -0,0 +1,21 @@ +DELETE FROM `spawn_group_template` WHERE `groupId` BETWEEN 279 AND 282; +INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES +(279,'Coilfang: The Underbog - Hungarfen',4), +(280,'Coilfang: The Underbog - Ghaz''an',4), +(281,'Coilfang: The Underbog - Swamplord Musel''ek',4), +(282,'Coilfang: The Underbog - The Black Stalker',4); + +DELETE FROM `instance_spawn_groups` WHERE `spawnGroupId` BETWEEN 279 AND 282; +INSERT INTO `instance_spawn_groups` (`instanceMapId`,`bossStateId`,`bossStates`,`spawnGroupId`,`flags`) VALUES +(546,0,23,279,1), +(546,1,23,280,1), +(546,2,23,281,1), +(546,3,23,282,1); + +DELETE FROM `spawn_group` WHERE `groupId` BETWEEN 279 AND 282; +INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES +(279,0,56111), +(280,0,101722), +(281,0,103431), +(281,0,103246), +(282,0,54337); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_26_00_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_26_00_world.sql new file mode 100644 index 00000000000..82f574b0ec5 --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_26_00_world.sql @@ -0,0 +1,11 @@ +DELETE FROM `spawn_group_template` WHERE `groupId`=283; +INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES +(283,'Tempest Keep: The Arcatraz - Dalliah the Doomsayer',4); + +DELETE FROM `instance_spawn_groups` WHERE `spawnGroupId`=283; +INSERT INTO `instance_spawn_groups` (`instanceMapId`,`bossStateId`,`bossStates`,`spawnGroupId`,`flags`) VALUES +(552,1,23,283,1); + +DELETE FROM `spawn_group` WHERE `groupId`=283; +INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES +(283,0,79394); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_27_00_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_27_00_world.sql new file mode 100644 index 00000000000..ce09a6f9d8e --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_27_00_world.sql @@ -0,0 +1,14 @@ +DELETE FROM `spawn_group_template` WHERE `groupId` BETWEEN 284 AND 285; +INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES +(284,'Halls of Reflection - Falric',4), +(285,'Halls of Reflection - Marwyn',4); + +DELETE FROM `instance_spawn_groups` WHERE `spawnGroupId` BETWEEN 284 AND 285; +INSERT INTO `instance_spawn_groups` (`instanceMapId`,`bossStateId`,`bossStates`,`spawnGroupId`,`flags`) VALUES +(668,0,23,284,1), +(668,1,23,285,1); + +DELETE FROM `spawn_group` WHERE `groupId` BETWEEN 284 AND 285; +INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES +(284,0,202308), +(285,0,202294); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_27_01_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_27_01_world.sql new file mode 100644 index 00000000000..c1c57bee34b --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_27_01_world.sql @@ -0,0 +1,31 @@ +DELETE FROM `spawn_group_template` WHERE `groupId` BETWEEN 286 AND 292; +INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES +(286,'Zul''gurub - High Priestess Jeklik',4), +(287,'Zul''gurub - High Priest Venoxis',4), +(288,'Zul''gurub - High Priestess Mar''li',4), +(289,'Zul''gurub - High Priest Thekal',4), +(290,'Zul''gurub - Hakkar',4), +(291,'Zul''gurub - Bloodlord Mandokir',4), +(292,'Zul''gurub - Jin''do the Hexxer',4); + +DELETE FROM `instance_spawn_groups` WHERE `spawnGroupId` BETWEEN 286 AND 292; +INSERT INTO `instance_spawn_groups` (`instanceMapId`,`bossStateId`,`bossStates`,`spawnGroupId`,`flags`) VALUES +(309,0,23,286,1), +(309,1,23,287,1), +(309,2,23,288,1), +(309,4,23,289,1), +(309,5,23,290,1), +(309,6,23,291,1), +(309,7,23,292,1); + +DELETE FROM `spawn_group` WHERE `groupId` BETWEEN 286 AND 292; +INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES +(286,0,49199), +(287,0,49194), +(288,0,49258), +(289,0,49310), +(290,0,49678), +(291,0,49286), +(292,0,49655); + +DELETE FROM `event_scripts` WHERE `id`=9104; diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_27_02_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_27_02_world.sql new file mode 100644 index 00000000000..4b1ab1b4fe4 --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_27_02_world.sql @@ -0,0 +1,26 @@ +DELETE FROM `spawn_group_template` WHERE `groupId` BETWEEN 293 AND 298; +INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES +(293,'Ruins of Ahn''Qiraj - Kurinnaxx',4), +(294,'Ruins of Ahn''Qiraj - General Rajaxx',4), +(295,'Ruins of Ahn''Qiraj - Moam',4), +(296,'Ruins of Ahn''Qiraj - Buru the Gorger',4), +(297,'Ruins of Ahn''Qiraj - Ayamiss the Hunter',4), +(298,'Ruins of Ahn''Qiraj - Ossirian the Unscarred',4); + +DELETE FROM `instance_spawn_groups` WHERE `spawnGroupId` BETWEEN 293 AND 298; +INSERT INTO `instance_spawn_groups` (`instanceMapId`,`bossStateId`,`bossStates`,`spawnGroupId`,`flags`) VALUES +(509,0,23,293,1), +(509,1,23,294,1), +(509,2,23,295,1), +(509,4,23,296,1), +(509,5,23,297,1), +(509,6,23,298,1); + +DELETE FROM `spawn_group` WHERE `groupId` BETWEEN 293 AND 298; +INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES +(293,0,144632), +(294,0,144603), +(295,0,144602), +(296,0,144642), +(297,0,144641), +(298,0,144601); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_28_00_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_28_00_world.sql new file mode 100644 index 00000000000..b6cda099059 --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_28_00_world.sql @@ -0,0 +1,29 @@ +DELETE FROM `spawn_group_template` WHERE `groupId` BETWEEN 299 AND 303; +INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES +(299,'Ahn''Qiraj Temple - Twin Emperors',4), +(300,'Ahn''Qiraj Temple - C''Thun',4), +(301,'Ahn''Qiraj Temple - Silithid Royalty',4), +(302,'Ahn''Qiraj Temple - Viscidus',4), +(303,'Ahn''Qiraj Temple - Ouro',4); + +DELETE FROM `instance_spawn_groups` WHERE `spawnGroupId` BETWEEN 299 AND 303; +INSERT INTO `instance_spawn_groups` (`instanceMapId`,`bossStateId`,`bossStates`,`spawnGroupId`,`flags`) VALUES +(531,4,23,299,1), +(531,5,23,300,1), +(531,6,23,301,1), +(531,7,23,302,1), +(531,8,23,303,1); + +DELETE FROM `spawn_group` WHERE `groupId` BETWEEN 299 AND 303; +INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES +(299,0,88072), +(299,0,88076), +(299,0,88077), +(300,0,87560), +(300,0,87559), +(300,0,4458), +(301,0,87601), +(301,0,87602), +(301,0,87603), +(302,0,87938), +(303,0,88073); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_29_00_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_29_00_world.sql new file mode 100644 index 00000000000..912eb998a36 --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_29_00_world.sql @@ -0,0 +1,11 @@ +DELETE FROM `spawn_group_template` WHERE `groupId`=304; +INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES +(304,'Coilfang: Serpentshrine Cavern - Lady Vashj',4); + +DELETE FROM `instance_spawn_groups` WHERE `spawnGroupId`=304; +INSERT INTO `instance_spawn_groups` (`instanceMapId`,`bossStateId`,`bossStates`,`spawnGroupId`,`flags`) VALUES +(548,5,23,304,1); + +DELETE FROM `spawn_group` WHERE `groupId`=304; +INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES +(304,0,93814); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_29_01_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_29_01_world.sql new file mode 100644 index 00000000000..f8ff318b50d --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_29_01_world.sql @@ -0,0 +1,72 @@ +DELETE FROM `spawn_group_template` WHERE `groupId` BETWEEN 304 AND 320; +INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES +(304,'Ulduar - Flame Leviathan',4), +(305,'Ulduar - Ignis the Furnace Master',4), +(306,'Ulduar - Razorscale',4), +(307,'Ulduar - XT-002 Deconstructor',4), +(308,'Ulduar - The Assembly of Iron',4), +(309,'Ulduar - Kologarn',4), +(310,'Ulduar - Auriaya',4), +(311,'Ulduar - Hodir',4), +(312,'Ulduar - Thorim',4), +(313,'Ulduar - Elder Brightleaf',4), +(314,'Ulduar - Elder Ironbranch',4), +(315,'Ulduar - Elder Stonebark',4), +(316,'Ulduar - Freya',4), +(317,'Ulduar - Mimiron',4), +(318,'Ulduar - General Vezax',4), +(319,'Ulduar - Yogg-Saron',4), +(320,'Ulduar - Algalon the Observer',4); + +DELETE FROM `instance_spawn_groups` WHERE `spawnGroupId` BETWEEN 304 AND 320; +INSERT INTO `instance_spawn_groups` (`instanceMapId`,`bossStateId`,`bossStates`,`spawnGroupId`,`flags`) VALUES +(603,0,23,304,1), +(603,1,23,305,1), +(603,2,23,306,1), +(603,3,23,307,1), +(603,4,23,308,1), +(603,5,23,309,1), +(603,6,23,310,1), +(603,7,23,311,1), +(603,8,23,312,1), +(603,14,23,313,1), +(603,9,8,313,2), +(603,15,23,314,1), +(603,9,8,314,2), +(603,16,23,315,1), +(603,9,8,315,2), +(603,9,23,316,1), +(603,10,23,317,1), +(603,11,23,318,1), +(603,12,23,319,1), +(603,13,23,320,1); + +DELETE FROM `spawn_group` WHERE `groupId` BETWEEN 304 AND 320; +INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES +(304,0,202501), +(304,0,137470), +(304,0,137480), +(305,0,136371), +(306,0,137611), +(307,0,136054), +(308,0,136421), +(308,0,136760), +(308,0,136316), +(309,0,136762), +(310,0,137496), +(310,0,48308), +(310,0,48309), +(310,0,137490), +(310,0,137491), +(311,0,136262), +(312,0,136384), +(313,0,136594), +(314,0,136590), +(315,0,136593), +(316,0,136554), +(317,0,135787), +(317,0,137630), +(318,0,137581), +(319,0,62016), +(320,1,281), +(320,1,285); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_29_02_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_29_02_world.sql new file mode 100644 index 00000000000..424e32ba147 --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_29_02_world.sql @@ -0,0 +1,11 @@ +DELETE FROM `spawn_group_template` WHERE `groupId`=321; +INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES +(321,'Coilfang: Serpentshrine Cavern - Lady Vashj',4); + +DELETE FROM `instance_spawn_groups` WHERE `spawnGroupId`=321; +INSERT INTO `instance_spawn_groups` (`instanceMapId`,`bossStateId`,`bossStates`,`spawnGroupId`,`flags`) VALUES +(548,5,23,321,1); + +DELETE FROM `spawn_group` WHERE `groupId`=321; +INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES +(321,0,93814); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_29_03_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_29_03_world.sql new file mode 100644 index 00000000000..690cdb9a15b --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_29_03_world.sql @@ -0,0 +1,11 @@ +DELETE FROM `spawn_group_template` WHERE `groupId`=322; +INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES +(322,'Trial of the Crusader - Anub''arak',4); + +DELETE FROM `instance_spawn_groups` WHERE `spawnGroupId`=322; +INSERT INTO `instance_spawn_groups` (`instanceMapId`,`bossStateId`,`bossStates`,`spawnGroupId`,`flags`) VALUES +(649,5,23,322,1); + +DELETE FROM `spawn_group` WHERE `groupId`=322; +INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES +(322,0,79370); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_30_00_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_30_00_world.sql new file mode 100644 index 00000000000..e1a37e144c2 --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_09_30_00_world.sql @@ -0,0 +1,15 @@ +DELETE FROM `spawn_group_template` WHERE `groupId` IN (323,324); +INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES +(323,'Naxxramas - Sapphiron',4), +(324,'Naxxramas - Kel''Thuzad',4); + +DELETE FROM `instance_spawn_groups` WHERE `spawnGroupId` IN (323,324); +INSERT INTO `instance_spawn_groups` (`instanceMapId`,`bossStateId`,`bossStates`,`spawnGroupId`,`flags`) VALUES +(533,13,23,323,1), +(533,14,23,324,1); + +DELETE FROM `spawn_group` WHERE `groupId` IN (323,324); +INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES +(323,0,133932), +(323,1,5517), +(324,0,133933); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_10_02_00_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_10_02_00_world.sql new file mode 100644 index 00000000000..b777521169e --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_10_02_00_world.sql @@ -0,0 +1,7 @@ +-- *** Quest "Not fit for death" *** +UPDATE `gameobject_template` SET `ScriptName` = 'go_caribou_trap' WHERE `entry` IN (187982,187995,187996,187997,187998,187999,188000,188001,188002,188003,188004,188005,188006,188007,188008); +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_q11865_place_fake_fur'; +UPDATE `creature_template` SET `ScriptName` = '' WHERE `entry`=25835; + +-- Conditions missing comment +UPDATE `conditions` SET `Comment` = 'Spell Place Fake Fur (effect 0) will hit the potential target of the spell if target is gameobject Caribou Trap.' WHERE `SourceTypeOrReferenceId`=13 AND `SourceGroup`=1 AND `SourceEntry`=46085; diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_10_02_01_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_10_02_01_world.sql new file mode 100644 index 00000000000..c7dd2d53008 --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_10_02_01_world.sql @@ -0,0 +1,22 @@ +-- *** Quest "Aces High!" *** +-- Condition for source Gossip menu condition type Quest taken +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=14 AND `SourceGroup`=10204 AND `SourceEntry` IN (14169,14170) AND `SourceId`=0; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(14, 10204, 14169, 0, 0, 9, 0, 13413, 0, 0, 0, 0, 0, '', 'Show gossip menu 10204 text id 14169 if quest Aces High! has been taken.'), +(14, 10204, 14170, 0, 0, 9, 0, 13414, 0, 0, 0, 0, 0, '', 'Show gossip menu 10204 text id 14170 if quest Aces High! "Daily" has been taken.'); + +-- Condition for source Gossip menu option condition type Quest taken +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=10204 AND `SourceEntry` IN (0,1) AND `SourceId`=0; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(15, 10204, 0, 0, 0, 9, 0, 13413, 0, 0, 0, 0, 0, '', 'Show gossip menu 10204 option id 0 if quest Aces High! has been taken.'), +(15, 10204, 1, 0, 0, 9, 0, 13414, 0, 0, 0, 0, 0, '', 'Show gossip menu 10204 option id 1 if quest Aces High! "Daily" has been taken.'); + +-- Corastrasza SAI +SET @ENTRY := 32548; +UPDATE `creature_template` SET `AIName`="SmartAI", `ScriptName`='' WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,2,62,0,100,0,10204,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,"Corastrasza - Gossip option select 0 - Close Gossip for player"), +(@ENTRY,0,1,2,62,0,100,0,10204,1,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,"Corastrasza - Gossip option select 1 - Close Gossip for player"), +(@ENTRY,0,2,3,61,0,100,0,0,0,0,0,85,61240,0,0,0,0,0,7,0,0,0,0,0,0,0,"Corastrasza - Gossip option select - Player Cast 'Summon Wyrmrest Skytalon' on self"), +(@ENTRY,0,3,0,61,0,100,0,0,0,0,0,85,61244,0,0,0,0,0,7,0,0,0,0,0,0,0,"Corastrasza - Gossip option select - Player Cast 'Wyrmrest Skytalon Ride Periodic' on self"); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_10_04_00_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_10_04_00_world.sql new file mode 100644 index 00000000000..d0542aa824c --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_10_04_00_world.sql @@ -0,0 +1,61 @@ +-- Add Missing gossip text +DELETE FROM `gossip_menu` WHERE `MenuID`=7346 AND `TextID`=8760; +INSERT INTO `gossip_menu` (`MenuID`,`TextID`) VALUES (7346,8760); + +-- Conditions for gossip text +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=14 AND `SourceGroup`=7346; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(14,7346,8759,0,0,8,0,9067,0,0,1,0,0,'','Show gossip text 8759 if quest ''The Party Never Ends'' is not rewarded'), +(14,7346,8760,0,0,8,0,9067,0,0,0,0,0,'','Show gossip text 8760 if quest ''The Party Never Ends'' is rewarded'); + +-- Remove hack SAI from Fireworks Launchers +UPDATE `gameobject_template` SET `AIName`='' WHERE `entry`=180771; +DELETE FROM `smart_scripts` WHERE `entryorguid`=180771 AND `source_type`=1; +DELETE FROM `smart_scripts` WHERE `entryorguid`=17056 AND `source_type`=0; +-- Correct facing +UPDATE `creature` SET `orientation`=2.14675498 WHERE `guid`=59449; + +-- Correct equipment +UPDATE `creature` SET `equipment_id`=0 WHERE `id`=17056; +-- Correct Addon +UPDATE `creature_addon` SET `bytes1`=0,`bytes2`=1,`emote`=0 WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id`=17056); +UPDATE `creature_addon` SET `auras`='42386' WHERE `guid` IN (59434); +-- Move start location +UPDATE `creature` SET `position_x`=8679.53,`position_y`=-6342.703,`position_z`=55.914032,`orientation`=6.2308254 WHERE `guid`=59444; + +-- Add Missing meat equipment +DELETE FROM `creature_equip_template` WHERE `CreatureID`=17056 AND `ID`=2; +INSERT INTO `creature_equip_template` (`CreatureID`,`ID`,`ItemID1`,`ItemID2`,`ItemID3`,`VerifiedBuild`) VALUES (17056,2,2202,0,0,0); + +-- Pathing for Eversong Partygoer Entry: 17056 +DELETE FROM `waypoint_data` WHERE `id` IN (594440,594441,594442,594443,594444); +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(594440,1,8680.874,-6340.5757,55.93538,NULL,0,0,0,100,0), +(594440,2,8685.874,-6338.5757,55.94099,NULL,0,0,0,100,0), +(594440,3,8687.746,-6339.301,55.93539,NULL,0,0,0,100,0), +(594440,4,8687.746,-6339.301,55.93539,4.502949,1000,0,0,100,0), +(594441,1,8689.3545,-6332.7295,55.95669,NULL,0,0,0,100,0), +(594441,2,8691,-6332.577,55.95949,NULL,0,0,0,100,0), +(594441,3,8691,-6332.577,55.95949,5.148721,1000,0,0,100,0), +(594442,1,8681.171,-6329.512,55.948093,NULL,0,0,0,100,0), +(594442,2,8681.171,-6329.512,55.948093,2.303835,1000,0,0,100,0), +(594443,1,8675.356,-6334.1494,55.932705,NULL,0,0,0,100,0), +(594443,2,8675.356,-6334.1494,55.932705,3.124139,1000,0,0,100,0), +(594444,1,8678.709,-6342.523,55.915527,NULL,0,0,0,100,0), +(594444,2,8679.53,-6342.703,55.914032,NULL,0,0,0,100,0), +(594444,3,8679.53,-6342.703,55.914032,6.230825,1000,0,0,100,0); + +UPDATE `creature` SET `ScriptName`='npc_partygoer_pather' WHERE `guid`=59444; +UPDATE `creature` SET `ScriptName`='npc_partygoer' WHERE `guid` IN (59435,59436,59437,59438,59439,59440,59441,59442,59443,59445,59446,59447,59448,59449); + +-- Sempstress Ambershine SAI +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=16366; +DELETE FROM `smart_scripts` WHERE `entryorguid`=16366 AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(16366,0,0,0,1,0,100,0,8000,15000,8000,15000,0,10,1,5,11,18,24,25,1,0,0,0,0,0,0,0,0,'Sempstress Ambershine - OOC - Random Emote'); + +-- Botanist Tyniarrel SAI +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=16367; +DELETE FROM `smart_scripts` WHERE `entryorguid`=16367 AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(16367,0,0,0,1,0,100,0,8000,15000,8000,15000,0,10,1,5,11,18,24,25,1,0,0,0,0,0,0,0,0,'Botanist Tyniarrel - OOC - Random Emote'); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_10_11_00_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_10_11_00_world.sql new file mode 100644 index 00000000000..8803ff1b7e2 --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_10_11_00_world.sql @@ -0,0 +1,5 @@ +DELETE FROM `instance_spawn_groups` WHERE `spawnGroupId` BETWEEN 296 AND 298; +INSERT INTO `instance_spawn_groups` (`instanceMapId`,`bossStateId`,`bossStates`,`spawnGroupId`,`flags`) VALUES +(509,3,23,296,1), +(509,4,23,297,1), +(509,5,23,298,1); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_10_14_00_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_10_14_00_world.sql new file mode 100644 index 00000000000..89a7ececc49 --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_10_14_00_world.sql @@ -0,0 +1,12 @@ +-- *** Quest "Help those who cannot help themselves" *** +UPDATE `gameobject_template` SET `ScriptName` = 'go_mammoth_trap' WHERE `entry` IN (188022,188024,188025,188026,188027,188028,188029,188030,188031,188032,188033,188034,188035,188036,188037,188038,188039,188040,188041,188042,188043,188044); +UPDATE `item_template` SET `ScriptName` = '' WHERE `entry`=35228; +UPDATE `creature_template` SET `ScriptName` = '' WHERE `entry`=25850; + +-- Conditions missing comment +UPDATE `conditions` SET `Comment` = 'Spell Smash Mammoth Trap (effect 0) will hit the potential target of the spell if target is gameobject Mammoth Trap.' WHERE `SourceTypeOrReferenceId`=13 AND `SourceGroup`=1 AND `SourceEntry`=46201; + +-- Add missing creature text +DELETE FROM `creature_text` WHERE `CreatureID`=25850; +INSERT INTO `creature_text` (`CreatureID`,`GroupID`,`ID`,`Text`,`Type`,`Language`,`Probability`,`Emote`,`Duration`,`Sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES +(25850, 0, 0, '%s trumpets in approval!', 16, 0, 100, 377, 0, 9914, 25046, 0, 'Trapped Mammoth Calf'); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_10_14_01_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_10_14_01_world.sql new file mode 100644 index 00000000000..7bf47950b76 --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_10_14_01_world.sql @@ -0,0 +1,21 @@ +-- *** Quest 11590 "Abduction" *** + +-- Condition for source Spell condition type Object entry guid +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=17 AND `SourceGroup`=0 AND `SourceEntry`=45611 AND `SourceId`=0; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(17, 0, 45611, 0, 0, 31, 1, 3, 25316, 0, 0, 12, 0, '', 'Spell Arcane Chains will hit the explicit target of the spell if target is unit Beryl Sorcerer.'), +(17, 0, 45611, 0, 0, 38, 1, 25, 4, 0, 0, 12, 0, '', 'Spell Arcane Chains will hit the explicit target of the spell if target health percentage must be equal or lower than 25% of max Health.'); + +DELETE FROM `spell_script_names` WHERE `spell_id`= 45625; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(45625, 'spell_arcane_chains_character_force_cast'); + +-- Update creatures +UPDATE `creature_template` SET `minlevel`=69, `maxlevel`=70, `unit_flags`=32768, `unit_class`=2, `ScriptName`='npc_captured_beryl_sorcerer' WHERE `entry`=25474; +UPDATE `creature_template` SET `AIName`='' WHERE `entry`=25316; +DELETE FROM `smart_scripts` WHERE `entryorguid`=25316; + +-- Condition for source Spell implicit target condition type Object entry guid +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceGroup`=1 AND `SourceEntry`=45735 AND `SourceId`=0; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(13, 1, 45735, 0, 0, 31, 0, 3, 25474, 0, 0, 0, 0, '', 'Spell Arcane Chains: Chain Channel II (effect 0) will hit the target of the spell if target is unit Captured Beryl Sorcerer.'); diff --git a/sql/old/3.3.5a/world/22081_2022_10_17/2022_10_14_02_world.sql b/sql/old/3.3.5a/world/22081_2022_10_17/2022_10_14_02_world.sql new file mode 100644 index 00000000000..5448e23ed54 --- /dev/null +++ b/sql/old/3.3.5a/world/22081_2022_10_17/2022_10_14_02_world.sql @@ -0,0 +1,94 @@ +-- *** Quest "Last rites" *** +DELETE FROM `gossip_menu_option` WHERE `MenuID`=9417; +INSERT INTO `gossip_menu_option` (`MenuID`,`OptionID`,`OptionIcon`,`OptionText`,`OptionBroadcastTextID`,`OptionType`,`OptionNpcFlag`,`ActionMenuID`,`ActionPoiID`,`BoxCoded`,`BoxMoney`,`BoxText`,`BoxBroadcastTextID`,`VerifiedBuild`) VALUES +(9417,0,0,"Let's do this, Thassarian. It's now or never.",25840,1,1,0,0,0,0,NULL,0,0); + +-- Add missing gossip text +DELETE FROM `gossip_menu` WHERE `MenuID`=9417 AND `TextID`=12664; +INSERT INTO `gossip_menu` (`MenuID`,`TextID`,`VerifiedBuild`) VALUES +(9417,12664,0); + +-- Condition for source Gossip menu condition type Area id +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=14 AND `SourceGroup`=9417 AND `SourceEntry` IN (12663,12664) AND `SourceId`=0; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(14, 9417, 12663, 0, 0, 23, 0, 4126, 0, 0, 0, 0, 0, '', 'Show gossip menu 9417 text id 12663 if target area is The Wailing Ziggurat.'), +(14, 9417, 12664, 0, 0, 23, 0, 4128, 0, 0, 0, 0, 0, '', 'Show gossip menu 9417 text id 12664 if target area is Naxxanar.'); + +-- Condition for source Gossip menu option condition type Quest taken +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=9417 AND `SourceEntry`=0 AND `SourceId`=0; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(15, 9417, 0, 0, 0, 9, 0, 12019, 0, 0, 0, 0, 0, '', 'Show gossip menu 9417 option id 0 if quest Last Rites has been taken.'), +(15, 9417, 0, 0, 0, 23, 0, 4128, 0, 0, 0, 0, 0, '', 'Show gossip menu 9417 option id 0 if target area is Naxxanar.'); + +-- Pathing for Thassarian entry 26170 Quest script for "Last Rites" +SET @PATH := 1013030; +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,3700.08,3574.54,473.322,0,0,0,100,0), +(@PATH,2,3705.94,3573.63,476.841,0,0,0,100,0), +(@PATH,3,3714.32,3572.3,477.442,0,0,0,100,0); + +-- Pathing for Arthas entry 26203 Quest script for "Last Rites" +SET @PATH := 1013031; +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,3733.2195,3538.1602,477.44214,0,0,0,100,0), +(@PATH,2,3736.5,3556.1494,477.44086,0,0,0,100,0), +(@PATH,3,3737.5398,3565.2202,477.44086,0,0,0,100,0); + +-- Pathing for Talbot entry 25301 Quest script for "Last Rites" +SET @PATH := 1013032; +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,3746.96,3607.5063,473.32144,0,0,0,100,0), +(@PATH,2,3742.525,3586.4636,477.44086,0,0,0,100,0), +(@PATH,3,3738.237,3570.3462,477.44086,0,0,0,100,0); + +-- Pathing for Arlos entry 25250 Quest script for "Last Rites" +SET @PATH := 1013033; +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,3742.4668,3598.8833,477.44287,0,0,0,100,0), +(@PATH,2,3739.2288,3587.0754,477.44086,0,0,0,100,0), +(@PATH,3,3735.5718,3572.422,477.44086,0,0,0,100,0); + +-- Pathing for Leryssa entry 25251 Quest script for "Last Rites" +SET @PATH := 1013034; +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,3750.0989,3603.0605,474.0086,0,0,0,100,0), +(@PATH,2,3747.6187,3591.2925,477.44186,0,0,0,100,0), +(@PATH,3,3741.9653,3571.4446,477.44086,0,0,0,100,0); + +-- Two spawns of entry. Script is only used on one. +UPDATE `creature_template` SET `ScriptName`='' WHERE `entry`=26170; +UPDATE `creature` SET `ScriptName`='npc_thassarian' WHERE `guid`=101303; +-- Image of the Lich King flags were wrong and script is not required +UPDATE `creature_template` SET `unit_flags`=768,`ScriptName`='' WHERE `entry`=26203; + +-- Condition for source Spell implicit target condition type Object entry guid +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceGroup`=3 AND `SourceEntry`=50995 AND `SourceId`=0; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(13, 3, 50995, 0, 0, 31, 0, 4, 0, 0, 0, 0, 0, '', 'Spell Empowered Blood Presence (effects 0 & 1) will hit the potential target of the spell if target is player any player.'); + +-- Condition for source Spell implicit target condition type Object entry guid +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceGroup`=3 AND `SourceEntry`=50995 AND `SourceId`=0; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(13, 3, 50995, 0, 1, 31, 0, 3, 26170, 0, 0, 0, 0, '', 'Spell Empowered Blood Presence (effects 0 & 1) will hit the potential target of the spell if target is player any player.'); + +-- Prince Valanar fix class and expansion and add missing loot +UPDATE `creature_template` SET `exp`=2, `unit_class`=8, `lootid`=28189,`mingold`=3000, `maxgold`=6500 WHERE `entry`=28189; + +-- Prince Valanar loot +DELETE FROM `creature_loot_template` WHERE `entry`=28189; +INSERT INTO `creature_loot_template` (`Entry`,`Item`,`Reference`,`Chance`,`QuestRequired`,`LootMode`,`GroupId`,`MinCount`,`MaxCount`,`Comment`) VALUES +(28189, 33373, 0, 15, 0, 1, 1, 1, 1, 'Fur-lined-belt'), +(28189, 33374, 0, 15, 0, 1, 1, 1, 1, 'Fur-lined-boots'), +(28189, 33375, 0, 15, 0, 1, 1, 1, 1, 'Fur-lined-bracers'), +(28189, 33376, 0, 15, 0, 1, 1, 1, 1, 'Fur-lined-gloves'), +(28189, 33377, 0, 15, 0, 1, 1, 1, 1, 'Fur-lined-pants'), +(28189, 33470, 0, 40, 0, 1, 2, 1, 3, 'Frostweave Cloth'); + +-- Thassarian add missing aura and remove script waypoints +UPDATE `creature_template_addon` SET `auras`=50995 WHERE `entry`= 26170; +DELETE FROM `script_waypoint` WHERE `entry`=26170; |