From 79176376a75fc0e8f4d13c87b4db524a22c50820 Mon Sep 17 00:00:00 2001 From: Killyana Date: Sat, 11 May 2019 20:04:39 +0200 Subject: DB/Creature: Cosmetic fixes for Shadow Labyrinth --- sql/updates/world/3.3.5/2019_05_11_09_world.sql | 4 ++++ 1 file changed, 4 insertions(+) create mode 100644 sql/updates/world/3.3.5/2019_05_11_09_world.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2019_05_11_09_world.sql b/sql/updates/world/3.3.5/2019_05_11_09_world.sql new file mode 100644 index 00000000000..e5576280c69 --- /dev/null +++ b/sql/updates/world/3.3.5/2019_05_11_09_world.sql @@ -0,0 +1,4 @@ +-- +UPDATE `creature` SET `id`=18663, `curhealth`=8104, `curmana`=7888 WHERE `guid`=66904 AND `id`=18641; +UPDATE `creature` SET `MovementType`=0, `spawndist`=0 WHERE `guid` IN (66868, 66806); +UPDATE `smart_scripts` SET `event_type`=16, `event_flags`=6, `event_param1`=33482, `event_param2`=15, `event_param3`=8000, `event_param4`=12000, `action_param2`=0, `target_type`=7,`target_param1`=0, `comment`="Cabal Acolyte - On Friendly missing aura - Cast 'Shadow Defense'" WHERE `entryorguid` IN(18633) AND `source_type`=0 AND `id`=0; -- cgit v1.2.3