aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorOdyssey <odyssey@trinitycore.contrib>2011-11-13 23:56:15 +0100
committerZxBiohazardZx <zxbiohazardzx@gmail.com>2011-11-13 23:56:15 +0100
commit5e7b4e867e1504ba97db1ccf91bfffc3364e6972 (patch)
tree2a98dde9a7a3dae91f581fb80bcdbf38c911447a
parentd4252d4dd4a51534c26c3f8d08726e8e6883c1a1 (diff)
[DB/Misc] First Aid - Netherweave Bandages
fixes #3879
-rw-r--r--sql/updates/world/2011_11_13_03_world_npc_trainer.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/2011_11_13_03_world_npc_trainer.sql b/sql/updates/world/2011_11_13_03_world_npc_trainer.sql
new file mode 100644
index 00000000000..e2c3e4a4e50
--- /dev/null
+++ b/sql/updates/world/2011_11_13_03_world_npc_trainer.sql
@@ -0,0 +1,5 @@
+-- Remove Manual: Netherweave Bandage & and Manual: Heavy Netherweave Bandage from vendors (Patch 3.1.0)
+DELETE FROM npc_vendor WHERE item IN (21992,21991);
+-- Update reqskillvalue for Netherweave Bandage & Heavy Netherweave Bandage (Patch 3.1.0)
+UPDATE npc_trainer SET reqskillvalue=300 WHERE spell=27032;
+UPDATE npc_trainer SET reqskillvalue=330 WHERE spell=27033;