aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authortkrokli <tkrokli@users.noreply.github.com>2017-05-28 19:18:28 +0200
committertkrokli <tkrokli@users.noreply.github.com>2017-05-28 19:18:28 +0200
commitc37eee532ed8c1b477f66e22827b606d0488d2f8 (patch)
treeeeb11736bfc5932a992efeb065e561ae8f6eb0f9
parent7f1315f77d804987691e614583efee52e544b584 (diff)
DB/creature: fix invalid equipment on Caynrus (creature ID 4240)
* Since 2014_03_30_04_world_creature_equip_template.sql, Caynrus <Shield Merchant> has erroneously been equipped with item ID 1961 (Monster - Shield, Buckler Wooden) and in wrong hand, making the item look like a blue & white box ("unobtainium"). Instead of moving the buckler to his off-hand slot, he gets his 2H Bent Staff (item ID 35) back. His equipped item was removed in Cataclysm, patch 4.0.3a.
-rw-r--r--sql/updates/world/3.3.5/2017_05_28_02_world_335.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_05_28_02_world_335.sql b/sql/updates/world/3.3.5/2017_05_28_02_world_335.sql
new file mode 100644
index 00000000000..c066179ac1e
--- /dev/null
+++ b/sql/updates/world/3.3.5/2017_05_28_02_world_335.sql
@@ -0,0 +1,2 @@
+-- Caynrus <Shield Vendor> used Bent Staff (item ID 35) before Cataclysm (patch 4.0.3a)
+UPDATE `creature_equip_template` SET `ItemID1`=35, `ItemID2`=0, `VerifiedBuild`=12340 WHERE `CreatureID`=4240;