From c1e771195ee14063d65b27527ebfc75e5c48f755 Mon Sep 17 00:00:00 2001 From: "github-actions[bot]" Date: Fri, 19 Sep 2025 09:47:58 +0000 Subject: chore(DB): import pending files Referenced commit(s): 00587fdbbb8cc0db6d111057733eee8bc86fe0d6 --- data/sql/updates/db_world/2025_09_19_00.sql | 75 ++++++++++++++++++++++ data/sql/updates/db_world/2025_09_19_01.sql | 4 ++ data/sql/updates/db_world/2025_09_19_02.sql | 17 +++++ data/sql/updates/db_world/2025_09_19_03.sql | 17 +++++ data/sql/updates/db_world/2025_09_19_04.sql | 17 +++++ .../pending_db_world/rev_1758036810668021078.sql | 74 --------------------- .../pending_db_world/rev_1758204041265257646.sql | 3 - .../pending_db_world/rev_1758204763903362829.sql | 16 ----- .../pending_db_world/rev_1758205507795905010.sql | 16 ----- .../pending_db_world/rev_1758206177120204426.sql | 16 ----- 10 files changed, 130 insertions(+), 125 deletions(-) create mode 100644 data/sql/updates/db_world/2025_09_19_00.sql create mode 100644 data/sql/updates/db_world/2025_09_19_01.sql create mode 100644 data/sql/updates/db_world/2025_09_19_02.sql create mode 100644 data/sql/updates/db_world/2025_09_19_03.sql create mode 100644 data/sql/updates/db_world/2025_09_19_04.sql delete mode 100644 data/sql/updates/pending_db_world/rev_1758036810668021078.sql delete mode 100644 data/sql/updates/pending_db_world/rev_1758204041265257646.sql delete mode 100644 data/sql/updates/pending_db_world/rev_1758204763903362829.sql delete mode 100644 data/sql/updates/pending_db_world/rev_1758205507795905010.sql delete mode 100644 data/sql/updates/pending_db_world/rev_1758206177120204426.sql diff --git a/data/sql/updates/db_world/2025_09_19_00.sql b/data/sql/updates/db_world/2025_09_19_00.sql new file mode 100644 index 0000000000..10ef965f81 --- /dev/null +++ b/data/sql/updates/db_world/2025_09_19_00.sql @@ -0,0 +1,75 @@ +-- DB update 2025_09_17_00 -> 2025_09_19_00 +-- +DELETE FROM `waypoints` WHERE `entry`=25742; +INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES +(25742, 1, 3511.336426, 4519.295898, -11.937509, 'Alluvius'); + +DELETE FROM `waypoints` WHERE `entry`=25652; +INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES +(25652, 1, 3509.71, 4510.5, -14.6752, 'Nerub\'ar Scarab'), +(25652, 2, 3515.16, 4512.57, -13.4052, 'Nerub\'ar Scarab'), +(25652, 3, 3520.58, 4511.77, -12.5632, 'Nerub\'ar Scarab'), +(25652, 4, 3530.14, 4507.88, -12.9948, 'Nerub\'ar Scarab'), +(25652, 5, 3536.34, 4508.6, -12.9948, 'Nerub\'ar Scarab'), +(25652, 6, 3553.48, 4510.25, -12.9948, 'Nerub\'ar Scarab'); + +DELETE FROM `event_scripts` WHERE `id` IN (17084, 16929); +INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES +(17084, 0, 10, 25794, 180000, 0, 3521.26, 4550.4, -12.8893, 3.95449), +(17084, 10, 8, 25794, 0, 0, 0.0, 0.0, 0.0, 0.0), +(17084, 15, 10, 25629, 180000, 0, 3454.72, 4511.48, -12.9969, 1.45063), +(16929, 7, 8, 25742, 0, 0, 0.0, 0.0, 0.0, 0.0), +(16929, 0, 10, 25742, 180000, 0, 3517.29, 4538.78, -12.9837, 4.42876), +(16929, 13, 10, 25629, 180000, 0, 3454.72, 4511.48, -12.9969, 1.45063), +(16929, 7, 10, 25652, 360000, 0, 3507.67, 4509.3, -14.7929, 0.94582), +(16929, 7, 10, 25652, 360000, 0, 3505.95, 4506.93, -14.8176, 0.94582), +(16929, 7, 10, 25652, 360000, 0, 3505.3, 4506.02, -14.8372, 0.94582), +(16929, 7, 10, 25652, 360000, 0, 3504.33, 4504.68, -14.8372, 0.94582); + +DELETE FROM `waypoints` WHERE `entry`=25629; +INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES +(25629, 1, 3456.838379, 4512.561523, -13.007453, 'Lord Kryxix'), +(25629, 2, 3460.417725, 4529.125488, -12.949759, 'Lord Kryxix'), +(25629, 3, 3470.703613, 4542.340332, -12.984859, 'Lord Kryxix'), +(25629, 4, 3480.046143, 4548.960938, -12.982792, 'Lord Kryxix'), +(25629, 5, 3492.488525, 4548.432617, -12.966542, 'Lord Kryxix'), +(25629, 6, 3498.693604, 4544.571777, -12.983426, 'Lord Kryxix'); + +UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 25652; +DELETE FROM `smart_scripts` WHERE (`source_type` = 0 AND `entryorguid` = 25652); +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`, `event_param6`, `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 +(25652, 0, 0, 0, 38, 0, 100, 0, 1, 1, 0, 0, 0, 0, 53, 0, 25652, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Nerub\'ar Scarab - On Data Set 1 1 - Start Waypoint Path 25652'), +(25652, 0, 1, 0, 40, 0, 100, 0, 6, 25652, 0, 0, 0, 0, 41, 1000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Nerub\'ar Scarab - On Point 6 of Path 25652 Reached - Despawn In 1000 ms'); + +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (25629, 25794, 25742) AND `source_type`=0; +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (2574200, 2574201) AND `source_type`=9; +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`, `event_param6`, `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 +(25629, 0, 0, 1, 54, 0, 100, 0, 0, 0, 0, 0, 0, 0, 53, 0, 25629, 0, 0, 0, 2, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Kryxix - On Just Summoned - Start Waypoint Path 25629'), +(25629, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 0, 18, 768, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Kryxix - On Just Summoned - Set Flags Immune To Players & Immune To NPC\'s'), +(25629, 0, 2, 3, 40, 0, 100, 0, 6, 25629, 0, 0, 0, 0, 19, 768, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Kryxix - On Point 6 of Path 25629 Reached - Remove Flags Immune To Players & Immune To NPC\'s'), +(25629, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 21, 40, 0, 0, 0, 0, 0, 0, 0, 'Lord Kryxix - On Point 6 of Path 25629 Reached - Start Attacking'), +(25629, 0, 4, 0, 7, 0, 100, 0, 0, 0, 0, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Kryxix - On Evade - Despawn Instant'), +(25794, 0, 0, 1, 54, 0, 100, 0, 0, 0, 0, 0, 0, 0, 59, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Shake-n-Quake 5000 - On Just Summoned - Set Run Off'), +(25794, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 0, 69, 1, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 3496.31, 4539.46, -12.9751, 4.49483, 'Shake-n-Quake 5000 - On Just Summoned - Move To Position'), +(25794, 0, 2, 0, 1, 0, 100, 1, 30000, 30000, 0, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Shake-n-Quake 5000 - Out of Combat - Despawn Instant (No Repeat)'), +(25794, 0, 3, 0, 34, 0, 100, 0, 8, 1, 0, 0, 0, 0, 17, 35, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Shake-n-Quake 5000 - On Reached Point 1 - Set Emote State 35'), +(25794, 0, 4, 0, 1, 0, 100, 1, 17000, 17000, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 19, 25629, 0, 0, 0, 0, 0, 0, 0, 'Shake-n-Quake 5000 - Out of Combat - Say Line 1 (No Repeat)'), +(25742, 0, 0, 0, 54, 0, 100, 512, 0, 0, 0, 0, 0, 0, 53, 0, 25742, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Alluvius - On Just Summoned - Start Waypoint Path 25742'), +(25742, 0, 1, 0, 40, 0, 100, 512, 1, 25742, 0, 0, 0, 0, 80, 2574200, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Alluvius - On Point 1 of Path 25742 Reached - Run Script'), +(2574200, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 0, 17, 35, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Alluvius - Actionlist - Set Emote State 35'), +(2574200, 9, 1, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 19, 25629, 0, 0, 0, 0, 0, 0, 0, 'Alluvius - Actionlist - Say Line 0'), +(2574200, 9, 2, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 9, 25652, 0, 25, 0, 0, 0, 0, 0, 'Alluvius - Actionlist - Set Data 1 1'), +(2574200, 9, 3, 0, 0, 0, 100, 0, 6000, 6000, 0, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Alluvius - Actionlist - Despawn Instant'); + +DELETE FROM `creature_text` WHERE `CreatureID`=25629 AND `GroupID`=1; +INSERT INTO `creature_text` (`CreatureID`,`GroupID`,`ID`,`Text`,`Type`,`Language`,`Probability`,`Emote`,`Duration`,`Sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES +(25629, 1, 0, 'Feebleminded tinkerer, do you really think your pathetic creation can stop me?', 14, 0, 100, 0, 0, 0, 24998, 0, 'Lord Kryxix'); + +DELETE FROM `conditions` WHERE `SourceEntry` IN (46017,45942) AND `SourceTypeOrReferenceId`=17; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`, `ErrorType`, `ErrorTextId`,`ScriptName`,`Comment`) VALUES +(17, 0, 46017, 0, 0, 29, 0, 25629, 70, 0, 1, 0, 0, '', ''), +(17, 0, 46017, 0, 0, 29, 0, 25794, 70, 0, 1, 0, 0, '', ''), +(17, 0, 46017, 0, 0, 29, 0, 25742, 70, 0, 1, 0, 0, '', ''), +(17, 0, 45942, 0, 0, 29, 0, 25629, 70, 0, 1, 0, 0, '', ''), +(17, 0, 45942, 0, 0, 29, 0, 25794, 70, 0, 1, 0, 0, '', ''), +(17, 0, 45942, 0, 0, 29, 0, 25742, 70, 0, 1, 0, 0, '', ''); diff --git a/data/sql/updates/db_world/2025_09_19_01.sql b/data/sql/updates/db_world/2025_09_19_01.sql new file mode 100644 index 0000000000..c16a436c7f --- /dev/null +++ b/data/sql/updates/db_world/2025_09_19_01.sql @@ -0,0 +1,4 @@ +-- DB update 2025_09_19_00 -> 2025_09_19_01 +-- +DELETE FROM `achievement_criteria_data` WHERE `criteria_id`=4112 AND `type`=15; +INSERT INTO `achievement_criteria_data` (`criteria_id`, `type`, `value1`, `value2`, `ScriptName`) VALUES (4112, 15, 3, 0, ''); diff --git a/data/sql/updates/db_world/2025_09_19_02.sql b/data/sql/updates/db_world/2025_09_19_02.sql new file mode 100644 index 0000000000..ab809a4ebc --- /dev/null +++ b/data/sql/updates/db_world/2025_09_19_02.sql @@ -0,0 +1,17 @@ +-- DB update 2025_09_19_01 -> 2025_09_19_02 +-- +DELETE FROM `areatrigger_scripts` WHERE `entry` IN (4946,4947,4948); +INSERT INTO `areatrigger_scripts` (`entry`, `ScriptName`) VALUES +(4946, 'SmartTrigger'), +(4947, 'SmartTrigger'), +(4948, 'SmartTrigger'); + +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (4946,4947,4948) AND `source_type`=2; +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 +(4946, 2, 0, 0, 46, 0, 100, 0, 4946, 0, 0, 0, 0, 33, 26468, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, "Areatrigger - On Trigger - Quest Credit 'Uncovering the Tunnels' (North Building)"), +(4948, 2, 0, 0, 46, 0, 100, 0, 4948, 0, 0, 0, 0, 33, 26469, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, "Areatrigger - On Trigger - Quest Credit 'Uncovering the Tunnels' (South Building)"), +(4947, 2, 0, 0, 46, 0, 100, 0, 4947, 0, 0, 0, 0, 33, 26470, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, "Areatrigger - On Trigger - Quest Credit 'Uncovering the Tunnels' (East Building)"); + +UPDATE `creature_template` SET `AIName`='' WHERE `entry` IN (26468,26469,26470); + +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (26468,26469,26470) AND `source_type`=0; diff --git a/data/sql/updates/db_world/2025_09_19_03.sql b/data/sql/updates/db_world/2025_09_19_03.sql new file mode 100644 index 0000000000..747d41bd60 --- /dev/null +++ b/data/sql/updates/db_world/2025_09_19_03.sql @@ -0,0 +1,17 @@ +-- DB update 2025_09_19_02 -> 2025_09_19_03 +-- +DELETE FROM `areatrigger_scripts` WHERE `entry` IN (5174, 5175, 5176); +INSERT INTO `areatrigger_scripts` (`entry`, `ScriptName`) VALUES +(5174, 'SmartTrigger'), +(5175, 'SmartTrigger'), +(5176, 'SmartTrigger'); + +DELETE FROM `smart_scripts` WHERE `entryorguid`IN (5174, 5175, 5176) AND `source_type`=2; +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 +(5174, 2, 0, 0, 46, 0, 100, 0, 5174, 0, 0, 0, 0, 33, 29455, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, "Areatrigger - On Trigger - Quest Credit 'That's What Friends Are For...' (Gerk)"), +(5175, 2, 0, 0, 46, 0, 100, 0, 5175, 0, 0, 0, 0, 33, 29454, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, "Areatrigger - On Trigger - Quest Credit 'That's What Friends Are For...' (Burr)"), +(5176, 2, 0, 0, 46, 0, 100, 0, 5176, 0, 0, 0, 0, 33, 29468, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, "Areatrigger - On Trigger - Quest Credit 'That's What Friends Are For...' (Crusader Dargoth)"); + +UPDATE `creature_template` SET `AIName`='' WHERE `entry` IN (29455, 29454, 29468); + +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (29455, 29454, 29468) AND `source_type`=0; diff --git a/data/sql/updates/db_world/2025_09_19_04.sql b/data/sql/updates/db_world/2025_09_19_04.sql new file mode 100644 index 0000000000..8921e23c15 --- /dev/null +++ b/data/sql/updates/db_world/2025_09_19_04.sql @@ -0,0 +1,17 @@ +-- DB update 2025_09_19_03 -> 2025_09_19_04 +-- +DELETE FROM `areatrigger_scripts` WHERE `entry` IN (4725, 4724, 4726); +INSERT INTO `areatrigger_scripts` (`entry`, `ScriptName`) VALUES +(4725, 'SmartTrigger'), +(4724, 'SmartTrigger'), +(4726, 'SmartTrigger'); + +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (4725,4724,4726) AND `source_type`=2; +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 +(4725, 2, 0, 0, 46, 0, 100, 0, 4725, 0, 0, 0, 0, 33, 23814, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, "Areatrigger - On Trigger - Quest Credit 'X Marks... Your Doom!'' (Zul'Aman - Eagle God Invisman)"), +(4726, 2, 0, 0, 46, 0, 100, 0, 4726, 0, 0, 0, 0, 33, 23815, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, "Areatrigger - On Trigger - Quest Credit 'X Marks... Your Doom!'' (Zul'Aman - Lynx God Invisman)"), +(4724, 2, 0, 0, 46, 0, 100, 0, 4724, 0, 0, 0, 0, 33, 23813, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, "Areatrigger - On Trigger - Quest Credit 'X Marks... Your Doom!' (Zul'Aman - Dragonhawk God Invisman)"); + +UPDATE `creature_template` SET `AIName`='' WHERE `entry` IN (23814, 23815, 23813); + +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (23814, 23815, 23813) AND `source_type`=0; diff --git a/data/sql/updates/pending_db_world/rev_1758036810668021078.sql b/data/sql/updates/pending_db_world/rev_1758036810668021078.sql deleted file mode 100644 index 5ede54c153..0000000000 --- a/data/sql/updates/pending_db_world/rev_1758036810668021078.sql +++ /dev/null @@ -1,74 +0,0 @@ --- -DELETE FROM `waypoints` WHERE `entry`=25742; -INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES -(25742, 1, 3511.336426, 4519.295898, -11.937509, 'Alluvius'); - -DELETE FROM `waypoints` WHERE `entry`=25652; -INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES -(25652, 1, 3509.71, 4510.5, -14.6752, 'Nerub\'ar Scarab'), -(25652, 2, 3515.16, 4512.57, -13.4052, 'Nerub\'ar Scarab'), -(25652, 3, 3520.58, 4511.77, -12.5632, 'Nerub\'ar Scarab'), -(25652, 4, 3530.14, 4507.88, -12.9948, 'Nerub\'ar Scarab'), -(25652, 5, 3536.34, 4508.6, -12.9948, 'Nerub\'ar Scarab'), -(25652, 6, 3553.48, 4510.25, -12.9948, 'Nerub\'ar Scarab'); - -DELETE FROM `event_scripts` WHERE `id` IN (17084, 16929); -INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES -(17084, 0, 10, 25794, 180000, 0, 3521.26, 4550.4, -12.8893, 3.95449), -(17084, 10, 8, 25794, 0, 0, 0.0, 0.0, 0.0, 0.0), -(17084, 15, 10, 25629, 180000, 0, 3454.72, 4511.48, -12.9969, 1.45063), -(16929, 7, 8, 25742, 0, 0, 0.0, 0.0, 0.0, 0.0), -(16929, 0, 10, 25742, 180000, 0, 3517.29, 4538.78, -12.9837, 4.42876), -(16929, 13, 10, 25629, 180000, 0, 3454.72, 4511.48, -12.9969, 1.45063), -(16929, 7, 10, 25652, 360000, 0, 3507.67, 4509.3, -14.7929, 0.94582), -(16929, 7, 10, 25652, 360000, 0, 3505.95, 4506.93, -14.8176, 0.94582), -(16929, 7, 10, 25652, 360000, 0, 3505.3, 4506.02, -14.8372, 0.94582), -(16929, 7, 10, 25652, 360000, 0, 3504.33, 4504.68, -14.8372, 0.94582); - -DELETE FROM `waypoints` WHERE `entry`=25629; -INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES -(25629, 1, 3456.838379, 4512.561523, -13.007453, 'Lord Kryxix'), -(25629, 2, 3460.417725, 4529.125488, -12.949759, 'Lord Kryxix'), -(25629, 3, 3470.703613, 4542.340332, -12.984859, 'Lord Kryxix'), -(25629, 4, 3480.046143, 4548.960938, -12.982792, 'Lord Kryxix'), -(25629, 5, 3492.488525, 4548.432617, -12.966542, 'Lord Kryxix'), -(25629, 6, 3498.693604, 4544.571777, -12.983426, 'Lord Kryxix'); - -UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 25652; -DELETE FROM `smart_scripts` WHERE (`source_type` = 0 AND `entryorguid` = 25652); -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`, `event_param6`, `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 -(25652, 0, 0, 0, 38, 0, 100, 0, 1, 1, 0, 0, 0, 0, 53, 0, 25652, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Nerub\'ar Scarab - On Data Set 1 1 - Start Waypoint Path 25652'), -(25652, 0, 1, 0, 40, 0, 100, 0, 6, 25652, 0, 0, 0, 0, 41, 1000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Nerub\'ar Scarab - On Point 6 of Path 25652 Reached - Despawn In 1000 ms'); - -DELETE FROM `smart_scripts` WHERE `entryorguid` IN (25629, 25794, 25742) AND `source_type`=0; -DELETE FROM `smart_scripts` WHERE `entryorguid` IN (2574200, 2574201) AND `source_type`=9; -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`, `event_param6`, `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 -(25629, 0, 0, 1, 54, 0, 100, 0, 0, 0, 0, 0, 0, 0, 53, 0, 25629, 0, 0, 0, 2, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Kryxix - On Just Summoned - Start Waypoint Path 25629'), -(25629, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 0, 18, 768, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Kryxix - On Just Summoned - Set Flags Immune To Players & Immune To NPC\'s'), -(25629, 0, 2, 3, 40, 0, 100, 0, 6, 25629, 0, 0, 0, 0, 19, 768, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Kryxix - On Point 6 of Path 25629 Reached - Remove Flags Immune To Players & Immune To NPC\'s'), -(25629, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 21, 40, 0, 0, 0, 0, 0, 0, 0, 'Lord Kryxix - On Point 6 of Path 25629 Reached - Start Attacking'), -(25629, 0, 4, 0, 7, 0, 100, 0, 0, 0, 0, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Kryxix - On Evade - Despawn Instant'), -(25794, 0, 0, 1, 54, 0, 100, 0, 0, 0, 0, 0, 0, 0, 59, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Shake-n-Quake 5000 - On Just Summoned - Set Run Off'), -(25794, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 0, 69, 1, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 3496.31, 4539.46, -12.9751, 4.49483, 'Shake-n-Quake 5000 - On Just Summoned - Move To Position'), -(25794, 0, 2, 0, 1, 0, 100, 1, 30000, 30000, 0, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Shake-n-Quake 5000 - Out of Combat - Despawn Instant (No Repeat)'), -(25794, 0, 3, 0, 34, 0, 100, 0, 8, 1, 0, 0, 0, 0, 17, 35, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Shake-n-Quake 5000 - On Reached Point 1 - Set Emote State 35'), -(25794, 0, 4, 0, 1, 0, 100, 1, 17000, 17000, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 19, 25629, 0, 0, 0, 0, 0, 0, 0, 'Shake-n-Quake 5000 - Out of Combat - Say Line 1 (No Repeat)'), -(25742, 0, 0, 0, 54, 0, 100, 512, 0, 0, 0, 0, 0, 0, 53, 0, 25742, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Alluvius - On Just Summoned - Start Waypoint Path 25742'), -(25742, 0, 1, 0, 40, 0, 100, 512, 1, 25742, 0, 0, 0, 0, 80, 2574200, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Alluvius - On Point 1 of Path 25742 Reached - Run Script'), -(2574200, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 0, 17, 35, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Alluvius - Actionlist - Set Emote State 35'), -(2574200, 9, 1, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 19, 25629, 0, 0, 0, 0, 0, 0, 0, 'Alluvius - Actionlist - Say Line 0'), -(2574200, 9, 2, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 9, 25652, 0, 25, 0, 0, 0, 0, 0, 'Alluvius - Actionlist - Set Data 1 1'), -(2574200, 9, 3, 0, 0, 0, 100, 0, 6000, 6000, 0, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Alluvius - Actionlist - Despawn Instant'); - -DELETE FROM `creature_text` WHERE `CreatureID`=25629 AND `GroupID`=1; -INSERT INTO `creature_text` (`CreatureID`,`GroupID`,`ID`,`Text`,`Type`,`Language`,`Probability`,`Emote`,`Duration`,`Sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES -(25629, 1, 0, 'Feebleminded tinkerer, do you really think your pathetic creation can stop me?', 14, 0, 100, 0, 0, 0, 24998, 0, 'Lord Kryxix'); - -DELETE FROM `conditions` WHERE `SourceEntry` IN (46017,45942) AND `SourceTypeOrReferenceId`=17; -INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`, `ErrorType`, `ErrorTextId`,`ScriptName`,`Comment`) VALUES -(17, 0, 46017, 0, 0, 29, 0, 25629, 70, 0, 1, 0, 0, '', ''), -(17, 0, 46017, 0, 0, 29, 0, 25794, 70, 0, 1, 0, 0, '', ''), -(17, 0, 46017, 0, 0, 29, 0, 25742, 70, 0, 1, 0, 0, '', ''), -(17, 0, 45942, 0, 0, 29, 0, 25629, 70, 0, 1, 0, 0, '', ''), -(17, 0, 45942, 0, 0, 29, 0, 25794, 70, 0, 1, 0, 0, '', ''), -(17, 0, 45942, 0, 0, 29, 0, 25742, 70, 0, 1, 0, 0, '', ''); diff --git a/data/sql/updates/pending_db_world/rev_1758204041265257646.sql b/data/sql/updates/pending_db_world/rev_1758204041265257646.sql deleted file mode 100644 index 8bcaa6b6e0..0000000000 --- a/data/sql/updates/pending_db_world/rev_1758204041265257646.sql +++ /dev/null @@ -1,3 +0,0 @@ --- -DELETE FROM `achievement_criteria_data` WHERE `criteria_id`=4112 AND `type`=15; -INSERT INTO `achievement_criteria_data` (`criteria_id`, `type`, `value1`, `value2`, `ScriptName`) VALUES (4112, 15, 3, 0, ''); diff --git a/data/sql/updates/pending_db_world/rev_1758204763903362829.sql b/data/sql/updates/pending_db_world/rev_1758204763903362829.sql deleted file mode 100644 index 3855809908..0000000000 --- a/data/sql/updates/pending_db_world/rev_1758204763903362829.sql +++ /dev/null @@ -1,16 +0,0 @@ --- -DELETE FROM `areatrigger_scripts` WHERE `entry` IN (4946,4947,4948); -INSERT INTO `areatrigger_scripts` (`entry`, `ScriptName`) VALUES -(4946, 'SmartTrigger'), -(4947, 'SmartTrigger'), -(4948, 'SmartTrigger'); - -DELETE FROM `smart_scripts` WHERE `entryorguid` IN (4946,4947,4948) AND `source_type`=2; -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 -(4946, 2, 0, 0, 46, 0, 100, 0, 4946, 0, 0, 0, 0, 33, 26468, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, "Areatrigger - On Trigger - Quest Credit 'Uncovering the Tunnels' (North Building)"), -(4948, 2, 0, 0, 46, 0, 100, 0, 4948, 0, 0, 0, 0, 33, 26469, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, "Areatrigger - On Trigger - Quest Credit 'Uncovering the Tunnels' (South Building)"), -(4947, 2, 0, 0, 46, 0, 100, 0, 4947, 0, 0, 0, 0, 33, 26470, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, "Areatrigger - On Trigger - Quest Credit 'Uncovering the Tunnels' (East Building)"); - -UPDATE `creature_template` SET `AIName`='' WHERE `entry` IN (26468,26469,26470); - -DELETE FROM `smart_scripts` WHERE `entryorguid` IN (26468,26469,26470) AND `source_type`=0; diff --git a/data/sql/updates/pending_db_world/rev_1758205507795905010.sql b/data/sql/updates/pending_db_world/rev_1758205507795905010.sql deleted file mode 100644 index 27586beae5..0000000000 --- a/data/sql/updates/pending_db_world/rev_1758205507795905010.sql +++ /dev/null @@ -1,16 +0,0 @@ --- -DELETE FROM `areatrigger_scripts` WHERE `entry` IN (5174, 5175, 5176); -INSERT INTO `areatrigger_scripts` (`entry`, `ScriptName`) VALUES -(5174, 'SmartTrigger'), -(5175, 'SmartTrigger'), -(5176, 'SmartTrigger'); - -DELETE FROM `smart_scripts` WHERE `entryorguid`IN (5174, 5175, 5176) AND `source_type`=2; -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 -(5174, 2, 0, 0, 46, 0, 100, 0, 5174, 0, 0, 0, 0, 33, 29455, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, "Areatrigger - On Trigger - Quest Credit 'That's What Friends Are For...' (Gerk)"), -(5175, 2, 0, 0, 46, 0, 100, 0, 5175, 0, 0, 0, 0, 33, 29454, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, "Areatrigger - On Trigger - Quest Credit 'That's What Friends Are For...' (Burr)"), -(5176, 2, 0, 0, 46, 0, 100, 0, 5176, 0, 0, 0, 0, 33, 29468, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, "Areatrigger - On Trigger - Quest Credit 'That's What Friends Are For...' (Crusader Dargoth)"); - -UPDATE `creature_template` SET `AIName`='' WHERE `entry` IN (29455, 29454, 29468); - -DELETE FROM `smart_scripts` WHERE `entryorguid` IN (29455, 29454, 29468) AND `source_type`=0; diff --git a/data/sql/updates/pending_db_world/rev_1758206177120204426.sql b/data/sql/updates/pending_db_world/rev_1758206177120204426.sql deleted file mode 100644 index 7ebefdb640..0000000000 --- a/data/sql/updates/pending_db_world/rev_1758206177120204426.sql +++ /dev/null @@ -1,16 +0,0 @@ --- -DELETE FROM `areatrigger_scripts` WHERE `entry` IN (4725, 4724, 4726); -INSERT INTO `areatrigger_scripts` (`entry`, `ScriptName`) VALUES -(4725, 'SmartTrigger'), -(4724, 'SmartTrigger'), -(4726, 'SmartTrigger'); - -DELETE FROM `smart_scripts` WHERE `entryorguid` IN (4725,4724,4726) AND `source_type`=2; -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 -(4725, 2, 0, 0, 46, 0, 100, 0, 4725, 0, 0, 0, 0, 33, 23814, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, "Areatrigger - On Trigger - Quest Credit 'X Marks... Your Doom!'' (Zul'Aman - Eagle God Invisman)"), -(4726, 2, 0, 0, 46, 0, 100, 0, 4726, 0, 0, 0, 0, 33, 23815, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, "Areatrigger - On Trigger - Quest Credit 'X Marks... Your Doom!'' (Zul'Aman - Lynx God Invisman)"), -(4724, 2, 0, 0, 46, 0, 100, 0, 4724, 0, 0, 0, 0, 33, 23813, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, "Areatrigger - On Trigger - Quest Credit 'X Marks... Your Doom!' (Zul'Aman - Dragonhawk God Invisman)"); - -UPDATE `creature_template` SET `AIName`='' WHERE `entry` IN (23814, 23815, 23813); - -DELETE FROM `smart_scripts` WHERE `entryorguid` IN (23814, 23815, 23813) AND `source_type`=0; -- cgit v1.2.3