From 7e07d9930827e25d79e1c398d4363ca8cad93f07 Mon Sep 17 00:00:00 2001
From: Killyana <morphone1@gmail.com>
Date: Wed, 2 Nov 2016 18:14:11 +0100
Subject: DB/Gameobject: Add two missing game object

Closes #18187
---
 sql/updates/world/3.3.5/2016_11_02_01_world.sql | 6 ++++++
 sql/updates/world/3.3.5/2016_11_02_02_world.sql | 9 +++++++++
 sql/updates/world/3.3.5/2016_11_08_01_world.sql | 6 ------
 3 files changed, 15 insertions(+), 6 deletions(-)
 create mode 100644 sql/updates/world/3.3.5/2016_11_02_01_world.sql
 create mode 100644 sql/updates/world/3.3.5/2016_11_02_02_world.sql
 delete mode 100644 sql/updates/world/3.3.5/2016_11_08_01_world.sql

(limited to 'sql')

diff --git a/sql/updates/world/3.3.5/2016_11_02_01_world.sql b/sql/updates/world/3.3.5/2016_11_02_01_world.sql
new file mode 100644
index 00000000000..d0d4b78c0c3
--- /dev/null
+++ b/sql/updates/world/3.3.5/2016_11_02_01_world.sql
@@ -0,0 +1,6 @@
+-- 
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (6066,18176) AND `source_type`= 0;
+UPDATE `creature_template` SET `AIName`="", `InhabitType`=`InhabitType`|8 WHERE `entry` IN (6066,18176);
+DELETE FROM `creature_template_addon` WHERE `entry`=6066;
+INSERT INTO `creature_template_addon` (`entry`,`auras`) VALUES (6066,'31982');
+UPDATE `creature_template_addon` SET `auras`='31982' WHERE `entry` IN (18176);
diff --git a/sql/updates/world/3.3.5/2016_11_02_02_world.sql b/sql/updates/world/3.3.5/2016_11_02_02_world.sql
new file mode 100644
index 00000000000..7002536a162
--- /dev/null
+++ b/sql/updates/world/3.3.5/2016_11_02_02_world.sql
@@ -0,0 +1,9 @@
+-- 
+DELETE FROM `gameobject_template` WHERE `entry` IN (4,129);
+INSERT INTO `gameobject_template` (`entry`,  `type`,  `displayId`,  `name`,  `IconName`,  `castBarCaption`,  `unk1`,  `size`,  `Data0`,  `Data1`,  `Data2`,  `Data3`,  `Data4`,  `Data5`,  `Data6`,  `Data7`,  `Data8`,  `Data9`,  `Data10`,  `Data11`,  `Data12`,  `Data13`,  `Data14`,  `Data15`,  `Data16`,  `Data17`,  `Data18`,  `Data19`,  `Data20`,  `Data21`,  `Data22`,  `Data23`,  `AIName`,  `ScriptName`,  `VerifiedBuild`) VALUES
+(4, 6, 0, "Bonfire Damage", "", "", "", 1, 0, 1, 3, 7902, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", "", 0),
+(129, 6, 0, "Naxx Teleporter trap", "", "", "", 1, 0, 1, 0, 64446, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", "", 0);
+
+DELETE FROM `gameobject_template_addon` WHERE `entry` IN (4);
+INSERT INTO `gameobject_template_addon` (`entry`, `faction`, `flags`, `mingold`, `maxgold`) VALUES
+(4, 14, 0, 0, 0);
diff --git a/sql/updates/world/3.3.5/2016_11_08_01_world.sql b/sql/updates/world/3.3.5/2016_11_08_01_world.sql
deleted file mode 100644
index d0d4b78c0c3..00000000000
--- a/sql/updates/world/3.3.5/2016_11_08_01_world.sql
+++ /dev/null
@@ -1,6 +0,0 @@
--- 
-DELETE FROM `smart_scripts` WHERE `entryorguid` IN (6066,18176) AND `source_type`= 0;
-UPDATE `creature_template` SET `AIName`="", `InhabitType`=`InhabitType`|8 WHERE `entry` IN (6066,18176);
-DELETE FROM `creature_template_addon` WHERE `entry`=6066;
-INSERT INTO `creature_template_addon` (`entry`,`auras`) VALUES (6066,'31982');
-UPDATE `creature_template_addon` SET `auras`='31982' WHERE `entry` IN (18176);
-- 
cgit v1.2.3