From 16f3e6597d82b879408678f799932abff93c781f Mon Sep 17 00:00:00 2001
From: hamcake9 <hamcake@hcl4.info>
Date: Mon, 25 Aug 2014 17:01:22 +0100
Subject: DB/Items: Fixed some random suffix ids

Fixed suffix ids for some items with sub-60 itemlevel

Fixes #12898
---
 ...14_08_25_00_world_item_enchantment_template.sql | 40 ++++++++++++++++++++++
 1 file changed, 40 insertions(+)
 create mode 100644 sql/updates/world/2014_08_25_00_world_item_enchantment_template.sql

(limited to 'sql/updates')

diff --git a/sql/updates/world/2014_08_25_00_world_item_enchantment_template.sql b/sql/updates/world/2014_08_25_00_world_item_enchantment_template.sql
new file mode 100644
index 00000000000..494d324fc0e
--- /dev/null
+++ b/sql/updates/world/2014_08_25_00_world_item_enchantment_template.sql
@@ -0,0 +1,40 @@
+DELETE FROM `item_enchantment_template` WHERE `entry` IN (161,162,163,381,382,383,384,385);
+INSERT INTO `item_enchantment_template` (`entry`, `ench`, `chance`) VALUES
+(161, 79, 51.35),
+(161, 83, 48.65),
+(162, 80, 48.65),
+(162, 83, 51.35),
+(163, 80, 44.6),
+(163, 83, 55.4),
+(381, 68, 8.1),
+(381, 71, 14.5),
+(381, 72, 7.7),
+(381, 73, 7.3),
+(381, 75, 7.7),
+(381, 78, 14.9),
+(381, 79, 8.8),
+(381, 83, 14.3),
+(381, 84, 8.2),
+(381, 85, 8.5),
+(382, 69, 18.7),
+(382, 79, 12.5),
+(382, 82, 18.8),
+(382, 83, 17.4),
+(382, 84, 12.8),
+(382, 85, 19.8),
+(383, 71, 35.5),
+(383, 78, 11.5),
+(383, 79, 11),
+(383, 80, 26.3),
+(383, 82, 15.7),
+(384, 71, 28.8),
+(384, 78, 24.1),
+(384, 80, 22.9),
+(384, 83, 13.6),
+(384, 85, 10.6),
+(385, 17, 13.2),
+(385, 68, 22.4),
+(385, 75, 17.6),
+(385, 84, 12.7),
+(385, 85, 10.2),
+(385, 86, 23.9);
-- 
cgit v1.2.3