creature_equip_template

• CreatureID

  • 链接 creature_template.entry

• ID

  • creature 装备模板编号
    • 一个 creature entry 可以有多个装备模板
    • 如有多个装备模板，从1开始依次递增1

• ItemID1 - ItemID3

  • 装备模板使用的装备id，取值参见 ItemSparse.db2 | Item.db2

• AppearanceModID1 - AppearanceModID3

  • ItemID + AppearanceModID 共同决定 item 的DisplayID，取值参见 ItemModifiedAppearance.db2

• ItemVisual1 - ItemVisual3

  •  装备的视觉效果，如附魔效果等，取值参见 ItemVisuals.db2

应用举例

-- Creature equip template
INSERT INTO `world`.`creature_equip_template` (`CreatureID`, `ID`, `ItemID1`, `AppearanceModID1`, `ItemVisual1`, `ItemID2`, `AppearanceModID2`, `ItemVisual2`, `ItemID3`, `AppearanceModID3`, `ItemVisual3`, `VerifiedBuild`) VALUES 
(27953, 1, 38490, 0, 0, 0, 0, 0, 19368, 0, 0, 12340),
(27953, 2, 38491, 0, 0, 0, 0, 0, 19368, 0, 0, 12340),
(27953, 3, 38487, 0, 0, 0, 0, 0, 19368, 0, 0, 12340),
(27953, 4, 38209, 0, 0, 0, 0, 0, 19368, 0, 0, 12340),
(27953, 5, 38488, 0, 0, 0, 0, 0, 19368, 0, 0, 12340),
(27953, 6, 32729, 0, 0, 0, 0, 0, 19368, 0, 0, 12340),
(27953, 7, 31273, 0, 0, 0, 0, 0, 19368, 0, 0, 12340);
-- Creature SAI
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 
(2795300, 9, 1, 0, '', 0, 0, 100, 0, 0, 0, 0, 0, 0, '', 71, 1, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Wyrmrest Protector - On Timed ActionList - Change Equipment'),
(2795301, 9, 1, 0, '', 0, 0, 100, 0, 0, 0, 0, 0, 0, '', 71, 2, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Wyrmrest Protector - On Script - Change Equipment'),
(2795302, 9, 1, 0, '', 0, 0, 100, 0, 0, 0, 0, 0, 0, '', 71, 3, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Wyrmrest Protector - On Script - Change Equipment'),
(2795303, 9, 1, 0, '', 0, 0, 100, 0, 0, 0, 0, 0, 0, '', 71, 4, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Wyrmrest Protector - On Script - Change Equipment'),
(2795304, 9, 1, 0, '', 0, 0, 100, 0, 0, 0, 0, 0, 0, '', 71, 5, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Wyrmrest Protector - On Script - Change Equipment'),
(2795305, 9, 1, 0, '', 0, 0, 100, 0, 0, 0, 0, 0, 0, '', 71, 6, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Wyrmrest Protector - On Script - Change Equipment');