From ed334aff2283c11e73ad2c7b0123bdcdb9ce5a6c Mon Sep 17 00:00:00 2001 From: tobmaps Date: Thu, 19 May 2011 01:35:36 +0700 Subject: DB/Loot: Fix disenchanting bug for items from Gnomeregan --- sql/updates/world/2011_05_18_09_world_waypoints.sql | 2 +- sql/updates/world/2011_05_18_11_world_item_template.sql | 1 + 2 files changed, 2 insertions(+), 1 deletion(-) create mode 100644 sql/updates/world/2011_05_18_11_world_item_template.sql (limited to 'sql') diff --git a/sql/updates/world/2011_05_18_09_world_waypoints.sql b/sql/updates/world/2011_05_18_09_world_waypoints.sql index 9825d45113d..fb8adf5888e 100644 --- a/sql/updates/world/2011_05_18_09_world_waypoints.sql +++ b/sql/updates/world/2011_05_18_09_world_waypoints.sql @@ -789,7 +789,7 @@ INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z` DELETE FROM `creature` WHERE `guid` IN (107423); DELETE FROM `creature_addon` WHERE `guid` IN (107423); --- Xink's Shreeder shuld not be spawned +-- Xink's Shreeder should not be spawned DELETE FROM `creature` WHERE `guid` IN (113110); DELETE FROM `creature_addon` WHERE `guid` IN (113110); diff --git a/sql/updates/world/2011_05_18_11_world_item_template.sql b/sql/updates/world/2011_05_18_11_world_item_template.sql new file mode 100644 index 00000000000..9fa22c6824a --- /dev/null +++ b/sql/updates/world/2011_05_18_11_world_item_template.sql @@ -0,0 +1 @@ +UPDATE `item_template` SET `DisenchantID` = 43 WHERE `DisenchantID` = 34 AND `ItemLevel` = 35; -- cgit v1.2.3