diff options
| author | ModoX <moardox@gmail.com> | 2021-10-23 13:10:32 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-10-23 13:10:32 +0200 |
| commit | 437fb2aaba8850dd81a15d661c82403be9170c4e (patch) | |
| tree | c0859c3e0e3c8badfd088876bd7a819028c3868a /sql/updates | |
| parent | 8b171d7c019f0010ec05af92466261d4be78bfff (diff) | |
Core/CreatureTexts: Added new field SoundPlayType to enable usage of ObjectSounds within creature_text (#27136)
* Also adjusted Vigilant Quoram texts to use ObjectSounds
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/world/master/2021_10_23_01_world.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_10_23_01_world.sql b/sql/updates/world/master/2021_10_23_01_world.sql new file mode 100644 index 00000000000..8307a0aba91 --- /dev/null +++ b/sql/updates/world/master/2021_10_23_01_world.sql @@ -0,0 +1,12 @@ +-- +ALTER TABLE `creature_text` ADD `SoundPlayType` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `Sound`; + +UPDATE `creature_text` SET `SoundPlayType`=1 WHERE `CreatureID`=130986; + +DELETE FROM `creature_text` WHERE `CreatureID`=130986 AND ((`GroupID`=0 AND `ID` IN(1, 2)) OR (`GroupID`=2 AND `ID` IN(1, 2)) OR (`GroupID`=3 AND `ID`=1)); +INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `SoundPlayType`, `BroadcastTextId`, `TextRange`, `comment`) VALUES +(130986, 0, 1, 'Oh, you made it.', 12, 0, 100, 0, 0, 96040, 1, 146007, 5, 'Vigilant Quoram to Player'), +(130986, 0, 2, 'Wonderful.', 12, 0, 100, 0, 0, 96041, 1, 146008, 5, 'Vigilant Quoram to Player'), +(130986, 2, 1, 'I imagine it is quite painful.', 12, 0, 100, 0, 0, 96045, 1, 146012, 5, 'Vigilant Quoram to Player'), +(130986, 2, 2, 'It is designed to kill you.', 12, 0, 100, 0, 0, 96044, 1, 146011, 5, 'Vigilant Quoram to Player'), +(130986, 3, 1, 'Perhaps.', 12, 0, 100, 0, 0, 96048, 1, 146015, 5, 'Vigilant Quoram to Player'); -- BroadcastTextID: 133363 - 146015 |