From 5e7b4e867e1504ba97db1ccf91bfffc3364e6972 Mon Sep 17 00:00:00 2001 From: Odyssey Date: Sun, 13 Nov 2011 23:56:15 +0100 Subject: [DB/Misc] First Aid - Netherweave Bandages fixes #3879 --- sql/updates/world/2011_11_13_03_world_npc_trainer.sql | 5 +++++ 1 file changed, 5 insertions(+) create mode 100644 sql/updates/world/2011_11_13_03_world_npc_trainer.sql (limited to 'sql/updates') 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; -- cgit v1.2.3