数据库修复实例5（时光旅行）

行云烈风

已于 2024-08-08 00:22:45 修改

阅读量83

点赞数 2

分类专栏： TrinityCore 功能实现文章标签：开源

于 2024-08-08 00:21:04 首次发布

本文链接：https://blog.csdn.net/weixin_51122280/article/details/141004228

版权

TrinityCore 同时被 2 个专栏收录

82 篇文章 4 订阅

订阅专栏

功能实现

23 篇文章 0 订阅

订阅专栏

修复目标

修复时光旅行功能

-- Zidormi - Silithus
INSERT INTO `world`.`creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curHealthPct`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `ScriptName`, `StringId`, `VerifiedBuild`) VALUES 
(304129, 128607, 1, 1377, 3077, '0', 1, 169, 0, -1, 0, 0, -6493.08, -200.226, 3.43455, 2.86061, 300, 0, 0, 100, 0, NULL, NULL, NULL, NULL, '', NULL, 0);

UPDATE `world`.`creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 128607;

INSERT INTO `world`.`quest_template` (`ID`, `QuestType`, `Flags`,  `LogTitle`) VALUES (50659, 2, 1024, '[Hidden Tracker] Silithus Terrain Swap Condition Quest');

DELETE FROM `world`.`conditions` WHERE `SourceTypeOrReferenceId` = 25 AND `SourceEntry` = 1817;
INSERT INTO `world`.`conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ConditionStringValue1`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES 
(15, 21720, 0, 0, 0, 47, 0, 50659, 1, 0, '', 0, 0, 0, '', 'On Quest State - Gossip Option Available'),
(15, 21720, 1, 0, 0, 47, 0, 50659, 64, 0, '', 0, 0, 0, '', 'On Quest State - Gossip Option Available'),
(25, 0, 1817, 0, 0, 47, 0, 50659, 1, 0, '', 0, 0, 0, '', 'On Quest State - TerrainSwap Available');

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 
(128607, 0, 0, 1, '', 62, 0, 100, 0, 21720, 0, 0, 0, 0, '', 72, 0, 0, 0, 0, 0, 0, 0, NULL, 7, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Zidormi - On Gossip Option 0 Selected - Close Gossip'),
(128607, 0, 1, 0, '', 61, 0, 100, 0, 0, 0, 0, 0, 0, '', 85, 255152, 0, 0, 0, 0, 0, 0, NULL, 7, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Zidormi - Link - Invoker Cast \'Time Travelling\''),
(128607, 0, 2, 3, '', 62, 0, 100, 0, 21720, 1, 0, 0, 0, '', 72, 0, 0, 0, 0, 0, 0, 0, NULL, 7, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Zidormi - On Gossip Option 1 Selected - Close Gossip'),
(128607, 0, 3, 4, '', 61, 0, 100, 0, 0, 0, 0, 0, 0, '', 85, 129809, 0, 0, 0, 0, 0, 0, NULL, 7, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Zidormi - Link - Invoker Cast \'Fade to Black INSTANT\''),
(128607, 0, 4, 5, '', 61, 0, 100, 0, 0, 0, 0, 0, 0, '', 28, 255152, 0, 0, 0, 0, 0, 0, NULL, 7, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Zidormi - Link - Remove Aura'),
(128607, 0, 5, 6, '', 61, 0, 100, 0, 0, 0, 0, 0, 0, '', 85, 400563, 0, 0, 0, 0, 0, 0, NULL, 7, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Zidormi - Link - Invoker Cast \'Time Travelling\''),
(128607, 0, 6, 0, '', 61, 0, 100, 0, 0, 0, 0, 0, 0, '', 85, 81040, 0, 0, 0, 0, 0, 0, NULL, 7, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Zidormi - Link - Invoker Cast \'Update Zone Auras and Phase Shift (SERVERSIDE)\'');