DB/creature_addon: Fix some issues with weapons not showing for npc's in Slave Pens.

1 files changed, 23 insertions, 0 deletions

diff --git a/sql/updates/world/2013_11_10_05_world_creature_addon.sql b/sql/updates/world/2013_11_10_05_world_creature_addon.sql
new file mode 100644
index 00000000000..38f2521f9bf
--- /dev/null
+++ b/sql/updates/world/2013_11_10_05_world_creature_addon.sql
@@ -0,0 +1,23 @@
+DELETE FROM `creature_template_addon` WHERE `entry`=17940;
+INSERT INTO `creature_template_addon` (`entry`, `bytes2`) VALUES (17940,1);
+UPDATE `creature_addon` SET `bytes2`=1 WHERE guid IN (SELECT guid FROM creature WHERE id = 17940);
+
+DELETE FROM `creature_template_addon` WHERE `entry`=17957;
+INSERT INTO `creature_template_addon` (`entry`, `bytes2`) VALUES (17957,1);
+UPDATE `creature_addon` SET `bytes2`=1 WHERE guid IN (SELECT guid FROM creature WHERE id = 17957);
+
+DELETE FROM `creature_template_addon` WHERE `entry`=17958;
+INSERT INTO `creature_template_addon` (`entry`, `bytes2`) VALUES (17958,1);
+UPDATE `creature_addon` SET `bytes2`=1 WHERE guid IN (SELECT guid FROM creature WHERE id = 17958);
+
+DELETE FROM `creature_template_addon` WHERE `entry`=17959;
+INSERT INTO `creature_template_addon` (`entry`, `bytes2`) VALUES (17959,1);
+UPDATE `creature_addon` SET `bytes2`=1 WHERE guid IN (SELECT guid FROM creature WHERE id = 17959);
+
+DELETE FROM `creature_template_addon` WHERE `entry`=17961;
+INSERT INTO `creature_template_addon` (`entry`, `bytes2`) VALUES (17961,1);
+UPDATE `creature_addon` SET `bytes2`=1 WHERE guid IN (SELECT guid FROM creature WHERE id = 17961);
+
+DELETE FROM `creature_template_addon` WHERE `entry`=17962;
+INSERT INTO `creature_template_addon` (`entry`, `bytes2`) VALUES (17962,1);
+UPDATE `creature_addon` SET `bytes2`=1 WHERE guid IN (SELECT guid FROM creature WHERE id = 17962);