From 703dc4ac4af68f0b7438dc23313cb64dce8cabc3 Mon Sep 17 00:00:00 2001 From: offl Date: Mon, 30 Nov 2020 03:06:19 +0200 Subject: DB/Creature: Spawn missing A Mysterious Voice & add texts (cherry picked from commit 5861d665e05f1c7135b0bfc70d1ab0f6b80965f9) --- .../world/master/2022_03_01_24_world_2020_11_30_02_world.sql | 11 +++++++++++ 1 file changed, 11 insertions(+) create mode 100644 sql/updates/world/master/2022_03_01_24_world_2020_11_30_02_world.sql (limited to 'sql/updates') 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"); -- cgit v1.2.3