diff options
| author | Ovahlord <dreadkiller@gmx.de> | 2025-01-14 23:02:09 +0100 |
|---|---|---|
| committer | Ovahlord <dreadkiller@gmx.de> | 2025-01-14 23:02:09 +0100 |
| commit | 52fd2b29cdac07bc045cf18f884511867ebc6ad3 (patch) | |
| tree | 93446678512cb9460c2a0816991ad191a40cdef1 /sql | |
| parent | 76598ff08e6bdbb577617ad3c81d4cf192c76708 (diff) | |
DB/Creatures: added data for new Timbered Air Snakelet companion
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/cata_classic/2025_01_14_00_world.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/world/cata_classic/2025_01_14_00_world.sql b/sql/updates/world/cata_classic/2025_01_14_00_world.sql new file mode 100644 index 00000000000..0eb9762d244 --- /dev/null +++ b/sql/updates/world/cata_classic/2025_01_14_00_world.sql @@ -0,0 +1,11 @@ +DELETE FROM `creature_template_difficulty` WHERE (`Entry`=232536 AND `DifficultyID`=0); +INSERT INTO `creature_template_difficulty` (`Entry`, `DifficultyID`, `HealthScalingExpansion`, `HealthModifier`, `ManaModifier`, `CreatureDifficultyID`, `TypeFlags`, `TypeFlags2`) VALUES +(232536, 0, 0, 1, 1, 0, 0x0, 0); -- Timbered Air Snakelet + +DELETE FROM `creature_template` WHERE `entry`=232536; +INSERT INTO `creature_template` (`entry`, `Civilian`, `KillCredit1`, `KillCredit2`, `name`, `femaleName`, `subname`, `TitleAlt`, `IconName`, `RequiredExpansion`, `VignetteID`, `unit_class`, `WidgetSetID`, `WidgetSetUnitConditionID`, `Classification`, `family`, `type`, `PetSpellDataId`, `RacialLeader`, `movementId`, `VerifiedBuild`) VALUES +(232536, 1, 0, 0, 'Timbered Air Snakelet', NULL, NULL, NULL, NULL, 0, 0, 1, 0, 0, 0, 0, 12, 0, 0, 121, 58558); -- Timbered Air Snakelet + +DELETE FROM `creature_template_model` WHERE (`CreatureID`=232536 AND `Idx`=0); +INSERT INTO `creature_template_model` (`CreatureID`, `Idx`, `CreatureDisplayID`, `DisplayScale`, `Probability`, `VerifiedBuild`) VALUES +(232536, 0, 123452, 1, 1, 58558); -- Timbered Air Snakelet |