diff options
| author | offl <offl@users.noreply.github.com> | 2020-11-30 03:06:19 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-03-02 00:03:42 +0100 |
| commit | 703dc4ac4af68f0b7438dc23313cb64dce8cabc3 (patch) | |
| tree | 5e543aca7f24193e5234fc15a8ad4aa29bee6503 | |
| parent | d7bce18932c3255690fa50b1535e857159663dda (diff) | |
DB/Creature: Spawn missing A Mysterious Voice & add texts
(cherry picked from commit 5861d665e05f1c7135b0bfc70d1ab0f6b80965f9)
| -rw-r--r-- | sql/updates/world/master/2022_03_01_24_world_2020_11_30_02_world.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_03_01_24_world_2020_11_30_02_world.sql b/sql/updates/world/master/2022_03_01_24_world_2020_11_30_02_world.sql new file mode 100644 index 00000000000..352d0d29c5b --- /dev/null +++ b/sql/updates/world/master/2022_03_01_24_world_2020_11_30_02_world.sql @@ -0,0 +1,11 @@ +-- +DELETE FROM `creature` WHERE `guid` = 131100 AND `id` = 31264; +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnDifficulties`, `phaseId`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `MovementType`, `VerifiedBuild`) VALUES +(131100, 31264, 619, '1,2', 0, 0, 519.5499267578125, -447.876129150390625, 26.43937873840332031, 4.677482128143310546, 300, 0, 0, 12340); + +DELETE FROM `creature_text` WHERE `CreatureID` = 31264; +INSERT INTO `creature_text` (`CreatureID`,`GroupID`,`ID`,`Text`,`Type`,`Language`,`Probability`,`Emote`,`Duration`,`Sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES +(31264,0,0,"You will be alone in the end.",15,0,100,0,0,0,31911,0,"A Mysterious Voice"), +(31264,0,1,"Trust is your weakness.",15,0,100,0,0,0,31912,0,"A Mysterious Voice"), +(31264,0,2,"Hope is an illusion.",15,0,100,0,0,0,31913,0,"A Mysterious Voice"), +(31264,0,3,"All that you know will fade.",15,0,100,0,0,0,31914,0,"A Mysterious Voice"); |