当前位置： 首页 > news >正文

任务修复实例（8）

news 2025/8/20 17:24:35

Quest Name = 'Counterattack!' | '人马无双！'

Quest ID = 4021

-- Adjust Conditions
UPDATE `world`.`conditions` SET `ConditionValue2` = 8, `Comment` = 'Regthar Deathgate  - On Quest State - Gossip Menu Option Available' WHERE `SourceTypeOrReferenceId` = 15 AND `SourceGroup` = 1882 AND `ConditionTypeOrReference` = 47 AND `ConditionValue1` = 4021;
-- Add Creature Summon Groups
INSERT INTO `world`.`creature_summon_groups` (`summonerId`, `summonerType`, `groupId`, `entry`, `position_x`, `position_y`, `position_z`, `orientation`, `summonType`, `summonTime`, `Comment`) VALUES 
(3389, 0, 0, 9457, -267.937, -1897.09, 91.6676, 2.25017, 1, 300000, 'Regthar Deathgate - Horde Defender'),
(3389, 0, 0, 9457, -295.886, -1903.197, 91.6668, 1.44121, 1, 300000, 'Regthar Deathgate - Horde Defender'),
(3389, 0, 0, 9457, -283.507, -1903.22, 91.6676, 1.84961, 1, 300000, 'Regthar Deathgate - Horde Defender'),
(3389, 0, 0, 9458, -293.212, -1912.51, 91.6673, 1.42794, 1, 300000, 'Regthar Deathgate - Horde Axe Thrower'),
(3389, 0, 1, 9524, -280.037, -1888.35, 92.2549, 2.28087, 1, 60000, 'Regthar Deathgate - Kolkar Invader'),
(3389, 0, 1, 9524, -292.107, -1899.54, 91.667, 4.78158, 1, 60000, 'Regthar Deathgate - Kolkar Invader'),
(3389, 0, 1, 9524, -305.57, -1869.88, 92.7754, 2.45131, 1, 60000, 'Regthar Deathgate - Kolkar Invader'),
(3389, 0, 1, 9524, -289.972, -1882.76, 92.5714, 3.43148, 1, 60000, 'Regthar Deathgate - Kolkar Invader'),
(3389, 0, 1, 9524, -277.454, -1873.39, 92.7773, 4.75724, 1, 60000, 'Regthar Deathgate - Kolkar Invader'),
(3389, 0, 1, 9524, -271.581, -1847.51, 93.4329, 4.39124, 1, 60000, 'Regthar Deathgate - Kolkar Invader'),
(3389, 0, 1, 9524, -269.982, -1828.6, 92.4754, 4.68655, 1, 60000, 'Regthar Deathgate - Kolkar Invader'),
(3389, 0, 1, 9523, -279.267, -1827.92, 92.3128, 1.35332, 1, 60000, 'Regthar Deathgate - Kolkar Stormseer'),
(3389, 0, 1, 9523, -297.42, -1847.41, 93.2295, 5.80967, 1, 60000, 'Regthar Deathgate - Kolkar Stormseer'),
(3389, 0, 1, 9523, -310.607, -1831.89, 95.9363, 0.371571, 1, 60000, 'Regthar Deathgate - Kolkar Stormseer'),
(3389, 0, 1, 9523, -329.177, -1842.43, 95.3891, 0.516085, 1, 60000, 'Regthar Deathgate - Kolkar Stormseer'),
(3389, 0, 1, 9523, -324.448, -1860.63, 94.3221, 4.97793, 1, 60000, 'Regthar Deathgate - Kolkar Stormseer'),
(3389, 0, 2, 9524, -290.588, -1858, 92.5026, 4.14698, 1, 60000, 'Regthar Deathgate - Kolkar Invader'),
(3389, 0, 2, 9523, -286.103, -1846.18, 92.544, 6.11047, 1, 60000, 'Regthar Deathgate - Kolkar Stormseer'),
(3389, 0, 2, 9524, -304.978, -1844.7, 94.4432, 1.61721, 1, 60000, 'Regthar Deathgate - Kolkar Invader'),
(3389, 0, 2, 9523, -308.105, -1859.08, 93.8039, 2.80709, 1, 60000, 'Regthar Deathgate Kolkar Stormseer'),
(3389, 0, 2, 9524, -297.089, -1867.68, 92.5601, 2.21804, 1, 60000, 'Regthar Deathgate - Kolkar Invader'),
(3389, 0, 2, 9523, -286.988, -1876.47, 92.7447, 1.39494, 1, 60000, 'Regthar Deathgate Kolkar Stormseer'),
(3389, 0, 2, 9524, -291.86, -1893.04, 92.0213, 1.96121, 1, 60000, 'Regthar Deathgate - Kolkar Invader'),
(3389, 0, 2, 9524, -298.297, -1846.85, 93.3672, 4.97792, 1, 60000, 'Regthar Deathgate - Kolkar Invader');
-- Adjust SAI
DELETE FROM `world`.`smart_scripts` WHERE `entryorguid` IN (3389,338900,9523,9524,9456,9457,9458);
INSERT INTO `world`.`smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `Difficulties`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `event_param5`, `event_param_string`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `action_param7`, `action_param_string`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_param_string`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES 
(3389, 0, 0, 1, '', 62, 0, 100, 0, 1882, 0, 0, 0, 0, '', 1, 0, 0, 0, 0, 0, 0, 0, NULL, 7, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Regthar Deathgate - On Gossip Option Select  - Say Group 0'),
(3389, 0, 1, 2, '', 61, 0, 100, 0, 0, 0, 0, 0, 0, '', 72, 0, 0, 0, 0, 0, 0, 0, NULL, 7, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Regthar Deathgate - Link  - Close Gossip '),
(3389, 0, 2, 3, '', 61, 0, 100, 0, 0, 0, 0, 0, 0, '', 80, 338900, 2, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Regthar Deathgate - Link  - Run Timed ActionList'),
(3389, 0, 3, 0, '', 61, 0, 100, 0, 0, 0, 0, 0, 0, '', 22, 1, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Regthar Deathgate - Link -  Set Phase 1'),
(3389, 0, 4, 0, '', 1, 1, 100, 0, 3000, 6000, 45000, 60000, 0, '', 87, 338901, 338902, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Regthar Deathgate - OOC(P1)-  Run Random Timed ActionList'),
(3389, 0, 5, 6, '', 77, 1, 100, 0, 1, 30, 1000, 1000, 0, '', 12, 9456, 1, 250000, 0, 0, 0, 0, NULL, 8, 0, 0, 0, 0, NULL, -296.718, -1846.38, 93.2334, 5.02897, 'Regthar Deathgate - On Counter Set 1 30 - Summon Creature \'Warlord Krom\'zar\''),
(3389, 0, 6, 7, '', 61, 1, 100, 0, 0, 0, 0, 0, 0, '', 22, 0, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Regthar Deathgate - Link -  Set Phase 0'),
(3389, 0, 7, 0, '', 61, 0, 100, 0, 0, 0, 0, 0, 0, '', 78, 0, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Regthar Deathgate - Link - Call Script Reset'),
(338900, 9, 0, 0, '', 0, 0, 100, 0, 0, 0, 0, 0, 0, '', 107, 0, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Regthar Deathgate - On Script - Summon Group 0'),
(338901, 9, 0, 0, '', 0, 1, 100, 0, 3000, 8000, 0, 0, 0, '', 107, 1, 1, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Regthar Deathgate - On Script - Summon Group 1'),
(338902, 9, 0, 0, '', 0, 1, 100, 0, 3000, 8000, 0, 0, 0, '', 107, 2, 1, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Regthar Deathgate - On Script - Summon Group 2'),
(9523, 0, 0, 0, '', 11, 0, 100, 0, 0, 0, 0, 0, 0, '', 89, 5, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Kolkar Stormseer - On Respawn - Start Random Movement'),
(9523, 0, 1, 0, '', 0, 0, 100, 0, 0, 0, 3400, 4800, 0, '', 11, 9532, 64, 0, 0, 0, 0, 0, NULL, 2, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Kolkar Stormseer - IC - Cast \'Lightning Bolt\''),
(9523, 0, 2, 0, '', 0, 0, 100, 0, 10000, 15000, 15000, 20000, 0, '', 11, 6535, 0, 0, 0, 0, 0, 0, NULL, 2, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Kolkar Stormseer - IC - Cast \'Lightning Cloud\''),
(9523, 0, 3, 0, '', 6, 0, 100, 0, 0, 0, 0, 0, 0, '', 63, 1, 1, 0, 0, 0, 0, 0, NULL, 10, 302651, 3389, 0, 0, NULL, 0, 0, 0, 0, 'Kolkar Stormseer - On Death - Set Counter 1 1'),
(9524, 0, 0, 0, '', 11, 0, 100, 0, 0, 0, 0, 0, 0, '', 89, 5, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Kolkar Invader - On Respawn - Start Random Movement'),
(9524, 0, 1, 0, '', 0, 0, 100, 0, 0, 3500, 0, 0, 0, '', 11, 6268, 0, 0, 0, 0, 0, 0, NULL, 2, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Kolkar Invader - IC - Cast \'Rushing Charge\' (No Repeat)'),
(9524, 0, 2, 0, '', 0, 0, 100, 0, 4000, 5500, 12000, 16000, 0, '', 11, 11976, 0, 0, 0, 0, 0, 0, NULL, 2, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Kolkar Invader - IC - Cast \'Strike\''),
(9524, 0, 3, 0, '', 9, 0, 100, 0, 0, 5, 18000, 21000, 0, '', 11, 8014, 0, 0, 0, 0, 0, 0, NULL, 2, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Kolkar Invader - Within 0-5 Range - Cast \'Tetanus\''),
(9524, 0, 4, 0, '', 6, 0, 100, 0, 0, 0, 1, 0, 0, '', 63, 1, 1, 0, 0, 0, 0, 0, NULL, 10, 302651, 3389, 0, 0, NULL, 0, 0, 0, 0, 'Kolkar Invader - On Death - Set Counter 1 1'),
(9457, 0, 0, 0, '', 6, 0, 100, 0, 0, 0, 0, 0, 0, '', 1, 1, 0, 0, 0, 0, 0, 0, NULL, 9, 3389, 0, 300, 0, NULL, 0, 0, 0, 0, 'Horde Defender - On Death - \'Regthar Deathgate\' Say Group 1'),
(9457, 0, 1, 0, '', 6, 0, 100, 0, 0, 0, 0, 0, 0, '', 12, 9457, 1, 450000, 0, 0, 0, 0, NULL, 8, 0, 0, 0, 0, NULL, -280.703, -1908.01, 91.6668, 1.77351, 'Horde Defender - On Death - Summon \'Horde Defender\''),
(9457, 0, 2, 0, '', 11, 0, 100, 0, 0, 0, 0, 0, 0, '', 89, 5, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Horde Defender - On Respawn - Start Random Movement'),
(9458, 0, 0, 0, '', 0, 0, 100, 0, 0, 0, 2300, 3900, 0, '', 11, 10277, 64, 0, 0, 0, 0, 0, NULL, 2, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Horde Axe Thrower - In Combat CMC - Cast \'Throw\''),
(9458, 0, 1, 0, '', 6, 0, 100, 0, 0, 0, 0, 0, 0, '', 12, 9458, 1, 450000, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, NULL, -293.212, -1912.51, 91.6673, 1.42794, 'Horde Axe Thrower - On Death - Summon \'Horde Axe Thrower\''),
(9458, 0, 2, 0, '', 11, 0, 100, 0, 0, 0, 0, 0, 0, '', 89, 5, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Horde Axe Thrower - On Respawn - Start Random Movement'),
(9456, 0, 0, 0, '', 0, 0, 100, 0, 0, 1000, 4000, 6000, 0, '', 11, 11976, 0, 0, 0, 0, 0, 0, NULL, 2, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Warlord Krom\'zar - IC - Cast \'Strike\''),
(9456, 0, 1, 0, '', 6, 0, 100, 0, 0, 0, 0, 0, 0, '', 11, 13965, 2, 0, 0, 0, 0, 0, NULL, 7, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Warlord Krom\'zar - On Death - Cast \'Create Krom\'zar\'s Banner\''),
(9456, 0, 4, 0, '', 11, 0, 100, 0, 0, 0, 0, 0, 0, '', 89, 5, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Warlord Krom\'zar - On Respawn - Start Random Movement'),
(9456, 0, 5, 0, '', 11, 0, 100, 0, 0, 0, 0, 0, 0, '', 1, 0, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Warlord Krom\'zar - On Respawn - Say Group 0');

http://www.lryc.cn/news/341699.html

相关文章：

  • torch.flatten(x, 1)”和“x.view(x.size(0), -1)”有什么区别？
  • 达梦主从数据库实例恢复
  • JAVA:jsp+springboot 配置maven兼容版本
  • 【Docker】docker部署lnmp和搭建wordpress网站
  • C#装箱拆箱是怎么回事
  • JavaEE 初阶篇-深入了解 Junit 单元测试框架和 Java 中的反射机制（使用反射做一个简易版框架）
  • 人力资源管理新视野：挖掘员工潜力，共筑卓越未来
  • rust语言tokio库spawn, blocking_spawn等的使用
  • Day_1
  • 2024.05.06作业
  • 什么是抖音橱窗？它和抖音小店有什么区别？普通人更适合做哪个？
  • spring高级篇（九）
  • 用wordpress建跨境电商独立站的5大优势
  • Windows中安装的PostgreSQL 数据库如何重启
  • Remix框架实现 SSR
  • 如何快速开发项目，提高开发效率
  • 面试笔记——多线程使用场景
  • 02.0 基于Verilog控制LED灯每秒钟闪烁一次
  • C语言创建文件夹和多级目录
  • 2024.5.6
  • mybatis配置获取自增主键
  • 完整、免费的把pdf转word文档
  • 使用 Lua 协程模拟 Golang 的 go defer 编程模式
  • 网络通信协议，UDP和TCP，初步了解
  • Golang | Leetcode Golang题解之第61题旋转链表
  • 美业SaaS系统多门店收银系统源码-【分润常见问题】讲解（一）
  • Chatbot 在教育中的应用
  • Apache和Nginx的区别以及如何选择
  • 深入探索Element-UI：构建高效Web前端的利器
  • 在Ubuntu 24.04 LTS (Noble Numbat)上安装nfs server以及nfs client