数据库修复实例（航线修复）

本文主要是介绍数据库修复实例（航线修复），希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

修复目标

修复回音群岛 (Echo Isles) 到 赞达拉港 (Port of Zandalar) 的航线

SET @TRANSPORT_GUID := 32;
SET @TRANSPORT_ENTRY := 272677;
SET @CGUID := 850000;-- Adjust transports
DELETE FROM `transports` WHERE `guid` = @TRANSPORT_GUID;
INSERT INTO `transports` (`guid`, `entry`, `name`, `phaseUseFlags`, `phaseid`, `phasegroup`, `ScriptName`) VALUES
(@TRANSPORT_GUID, @TRANSPORT_ENTRY, 'Echo Isles <> Port of Zandalar ("The Golden Skipper")', 0, 0, 0, '');
DELETE FROM `gameobject_template_addon` WHERE `entry`= @TRANSPORT_ENTRY;
INSERT INTO `gameobject_template_addon` (`entry`, `faction`, `flags`, `mingold`, `maxgold`, `WorldEffectID`, `AIAnimKitID`) VALUES
(@TRANSPORT_ENTRY, 0, 0x100028, 0, 0, 0, 0);-- Adjust Creatures About Transports
DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+4;
INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
(@CGUID+0, 142943, 1, 6453, 0, '0', 0, 0, 0, 0, -982.69268798828125, -5769.1474609375, 6.43129730224609375, 1.789803504943847656, 120, 0, 0, 1604, 0, 0, 0, 0, 0, 38134), -- Mith'aka (Area: 0 - Difficulty: 0)
(@CGUID+1, 142964, 1958, 8499, 9717, '0', 0, 0, 0, 0, 37.68718338012695312, 6.610872745513916015, 7.138050079345703125, 5.743672370910644531, 120, 0, 0, 4579, 0, 0, 0, 0, 0, 38134), -- Golden Skipper Sailor (Area: Bay of Kings - Difficulty: 0)
(@CGUID+2, 142971, 1958, 8499, 9717, '0', 0, 0, 0, 0, 32.22069168090820312, 0.028408050537109375, 13.14441967010498046, 3.159996747970581054, 120, 0, 0, 4579, 0, 0, 0, 0, 0, 38134), -- Navigator Moye (Area: Bay of Kings - Difficulty: 0)
(@CGUID+3, 142972, 1958, 8499, 9717, '0', 0, 0, 0, 0, -15.4023046493530273, 6.615559101104736328, 15.34604835510253906, 5.255162239074707031, 120, 0, 0, 4579, 0, 0, 0, 0, 0, 38134), -- Watcher Char'mayne (Area: Bay of Kings - Difficulty: 0)
(@CGUID+4, 142958, 1958, 8499, 9717, '0', 0, 0, 0, 0, 1.150999307632446289, -0.02078290842473506, 6.332591533660888671, 0.353185951709747314, 120, 0, 0, 4579, 0, 0, 0, 0, 0, 38134); -- Captain Dam'en (Area: Bay of Kings - Difficulty: 0)
DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+1 AND @CGUID+4;
INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `auras`) VALUES
(@CGUID+1, 0, 0, 0, 1, 0, 0, 0, 0, '145953'), -- Golden Skipper Sailor
(@CGUID+2, 0, 0, 0, 1, 0, 16390, 0, 0, ''), -- Navigator Moye
(@CGUID+3, 0, 0, 0, 1, 426, 0, 0, 0, ''), -- Watcher Char'mayne
(@CGUID+4, 0, 0, 0, 1, 0, 0, 0, 0, ''); -- Captain Dam'en-- Adjust Creature Gossip
DELETE FROM `npc_text` WHERE `ID` IN (35974 /*35974*/, 35969 /*35969*/, 35987 /*35987*/);
INSERT INTO `npc_text` (`ID`, `Probability0`, `Probability1`, `Probability2`, `Probability3`, `Probability4`, `Probability5`, `Probability6`, `Probability7`, `BroadcastTextId0`, `BroadcastTextId1`, `BroadcastTextId2`, `BroadcastTextId3`, `BroadcastTextId4`, `BroadcastTextId5`, `BroadcastTextId6`, `BroadcastTextId7`, `VerifiedBuild`) VALUES
(35974, 1, 0, 0, 0, 0, 0, 0, 0, 161135, 0, 0, 0, 0, 0, 0, 0, 38134),
(35969, 1, 0, 0, 0, 0, 0, 0, 0, 161114, 0, 0, 0, 0, 0, 0, 0, 38134),
(35987, 1, 0, 0, 0, 0, 0, 0, 0, 161154, 0, 0, 0, 0, 0, 0, 0, 38134);
DELETE FROM `gossip_menu` WHERE (`MenuId`=23227 AND `TextId`=35974) OR (`MenuId`=23225 AND `TextId`=35969) OR (`MenuId`=23235 AND `TextId`=35987);
INSERT INTO `gossip_menu` (`MenuId`, `TextId`, `VerifiedBuild`) VALUES
(23227, 35974, 38134), -- 142943 (Mith'aka)
(23225, 35969, 38134), -- 142943 (Mith'aka,default)
(23235, 35987, 38134); -- 142958 (Captain Dam'en)
UPDATE `creature_template` SET `gossip_menu_id`=23225 WHERE `entry`=142943;
UPDATE `creature_template` SET `gossip_menu_id`=23235 WHERE `entry`=142958;
DELETE FROM `gossip_menu_option` WHERE (`MenuId`=23225 AND `OptionIndex`=0);
INSERT INTO `gossip_menu_option` (`MenuId`, `OptionIndex`, `OptionIcon`, `OptionText`, `OptionBroadcastTextId`, `VerifiedBuild`) VALUES
(23225, 0, 0, 'Where is the ship now?', 160873, 38134);

这篇关于数据库修复实例（航线修复）的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---