From 7dbb50d316115013ef2a35066b89062b80c7c4cd Mon Sep 17 00:00:00 2001
From: Killyana <morphone1@gmail.com>
Date: Thu, 5 Jan 2017 12:14:26 +0100
Subject: DB/Loot: Formula Enchant Weapon - Superior Striking

Closes #18738
By Rushor
---
 sql/updates/world/3.3.5/2017_01_05_01_world.sql | 63 +++++++++++++++++++++++++
 1 file changed, 63 insertions(+)
 create mode 100644 sql/updates/world/3.3.5/2017_01_05_01_world.sql

(limited to 'sql')

diff --git a/sql/updates/world/3.3.5/2017_01_05_01_world.sql b/sql/updates/world/3.3.5/2017_01_05_01_world.sql
new file mode 100644
index 00000000000..1e5da826fc1
--- /dev/null
+++ b/sql/updates/world/3.3.5/2017_01_05_01_world.sql
@@ -0,0 +1,63 @@
+-- Formula: Enchant Weapon - Superior Striking
+DELETE FROM `creature_loot_template` WHERE `item` = 16250;
+INSERT INTO `creature_loot_template` (`Entry`,`Item`,`Chance`,`GroupId`,`MinCount`,`MaxCount`,`Reference`) VALUES 
+-- Bosses
+(10363, 16250, 2, 0, 1, 1, 0),
+(10220, 16250, 2, 0, 1, 1, 0),
+(9816, 16250, 2, 0, 1, 1, 0),
+(10899, 16250, 2, 0, 1, 1, 0),
+(10430, 16250, 2, 0, 1, 1, 0),
+(9196, 16250, 2, 0, 1, 1, 0),
+(9236, 16250, 2, 0, 1, 1, 0),
+(9219, 16250, 2, 0, 1, 1, 0),
+(10376, 16250, 2, 0, 1, 1, 0),
+(9736, 16250, 2, 0, 1, 1, 0),
+(9568, 16250, 2, 0, 1, 1, 0),
+(9237, 16250, 2, 0, 1, 1, 0),
+(9596, 16250, 2, 0, 1, 1, 0),
+(10509, 16250, 2, 0, 1, 1, 0),
+(9718, 16250, 2, 0, 1, 1, 0),
+(10596, 16250, 2, 0, 1, 1, 0),
+-- Trash
+(10371, 16250, 1, 0, 1, 1, 0),
+(10318, 16250, 1, 0, 1, 1, 0),
+(10317, 16250, 1, 0, 1, 1, 0),
+(10083, 16250, 1, 0, 1, 1, 0),
+(9817, 16250, 1, 0, 1, 1, 0),
+(9692, 16250, 1, 0, 1, 1, 0),
+(9717, 16250, 1, 0, 1, 1, 0),
+(9693, 16250, 1, 0, 1, 1, 0),
+(9716, 16250, 7, 0, 1, 1, 0),
+(9583, 16250, 1, 0, 1, 1, 0),
+(10374, 16250, 1, 0, 1, 1, 0),
+(9263, 16250, 1, 0, 1, 1, 0),
+(9264, 16250, 1, 0, 1, 1, 0),
+(9260, 16250, 1, 0, 1, 1, 0),
+(9262, 16250, 1, 0, 1, 1, 0),
+(9261, 16250, 1, 0, 1, 1, 0),
+(9266, 16250, 1, 0, 1, 1, 0),
+(9268, 16250, 1, 0, 1, 1, 0),
+(9241, 16250, 1, 0, 1, 1, 0),
+(9265, 16250, 1, 0, 1, 1, 0),
+(9269, 16250, 1, 0, 1, 1, 0),
+(9239, 16250, 1, 0, 1, 1, 0),
+(9267, 16250, 1, 0, 1, 1, 0),
+(9217, 16250, 1, 0, 1, 1, 0),
+(9197, 16250, 1, 0, 1, 1, 0),
+(9216, 16250, 1, 0, 1, 1, 0),
+(9198, 16250, 1, 0, 1, 1, 0),
+(9200, 16250, 1, 0, 1, 1, 0),
+(9199, 16250, 1, 0, 1, 1, 0),
+(9258, 16250, 1, 0, 1, 1, 0),
+(9045, 16250, 1, 0, 1, 1, 0),
+(9098, 16250, 1, 0, 1, 1, 0),
+(9257, 16250, 1, 0, 1, 1, 0),
+(9097, 16250, 1, 0, 1, 1, 0),
+(10319, 16250, 1, 0, 1, 1, 0),
+(10366, 16250, 1, 0, 1, 1, 0),
+(10762, 16250, 1, 0, 1, 1, 0),
+(10372, 16250, 1, 0, 1, 1, 0),
+(9096, 16250, 1, 0, 1, 1, 0),
+(9819, 16250, 1, 0, 1, 1, 0),
+(9818, 16250, 1, 0, 1, 1, 0),
+(9240, 16250, 1, 0, 1, 1, 0);
-- 
cgit v1.2.3