From 8506af3365ce616cb378c6b575a27eaa41dfcd44 Mon Sep 17 00:00:00 2001 From: Serpaa Date: Mon, 4 Dec 2017 17:59:21 +0100 Subject: DB/Creature: Riverpaw Shaman missing spawns Closes #21021 --- sql/updates/world/3.3.5/2017_12_04_00_world_335.sql | 2 ++ 1 file changed, 2 insertions(+) create mode 100644 sql/updates/world/3.3.5/2017_12_04_00_world_335.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2017_12_04_00_world_335.sql b/sql/updates/world/3.3.5/2017_12_04_00_world_335.sql new file mode 100644 index 00000000000..2084a4aa2e7 --- /dev/null +++ b/sql/updates/world/3.3.5/2017_12_04_00_world_335.sql @@ -0,0 +1,2 @@ +-- Replace two Riverpaw Scouts with Riverpaw Shamans +UPDATE `creature` SET `id`=1065, `modelid`=204, `curhealth`=230, `curmana`=249 WHERE `guid` IN (86657, 86662); -- cgit v1.2.3