From 8a70b0d1ce54edeea1266377baa7150d5b70b3e7 Mon Sep 17 00:00:00 2001
From: Killyana <morphone1@gmail.com>
Date: Tue, 10 Dec 2019 18:38:30 +0100
Subject: DB/Creature: Cerie Larksong & Elka Stormbrew & Arthur Denny

---
 sql/updates/world/3.3.5/2019_12_10_02_world_335.sql | 21 ---------------------
 sql/updates/world/3.3.5/2019_12_10_03_world_335.sql | 21 +++++++++++++++++++++
 sql/updates/world/3.3.5/2019_12_10_04_world.sql     |  6 ++++++
 3 files changed, 27 insertions(+), 21 deletions(-)
 delete mode 100644 sql/updates/world/3.3.5/2019_12_10_02_world_335.sql
 create mode 100644 sql/updates/world/3.3.5/2019_12_10_03_world_335.sql
 create mode 100644 sql/updates/world/3.3.5/2019_12_10_04_world.sql

(limited to 'sql')

diff --git a/sql/updates/world/3.3.5/2019_12_10_02_world_335.sql b/sql/updates/world/3.3.5/2019_12_10_02_world_335.sql
deleted file mode 100644
index 9572a70a8ee..00000000000
--- a/sql/updates/world/3.3.5/2019_12_10_02_world_335.sql
+++ /dev/null
@@ -1,21 +0,0 @@
--- 
-DELETE FROM `gameobject_template_locale` WHERE `entry` IN (190671,165557,3224);
-INSERT INTO `gameobject_template_locale` (`entry`, `locale`, `name`, `castBarCaption`, `VerifiedBuild`) VALUES
-(3224, "deDE", "Klingenhügel", "", 18019),
-(3224, "esES", "Cerrotajo", "", 18019),
-(3224, "esMX", "Cerrotajo", "", 18019),
-(3224, "frFR", "Tranchecolline", "", 18019),
-(3224, "koKR", "칼바위 언덕", "", 18019),
-(3224, "ruRU", "Колючий Холм", "", 18019),
-(3224, "zhCN", "剃刀岭", "", 18019),
-(3224, "zhTW", "剃刀嶺", "", 18019),
-(165557, "deDE", "Östlicher Zeppelinlandeturm - Tirisfal und Schlingendorntal", "", 18019),
-(165557, "frFR", "Tour de Zepplin est - Clairières de Tirisfal et Vallée de Strangleronce", "", 18019),
-(165557, "esES", "Torre Zepelin Este - Claros de Tirisfal y Valle de Tuercespina", "", 18019),
-(165557, "esMX", "Torre Zepelin Este - Claros de Tirisfal y Valle de Tuercespina", "", 18019),
-(165557, "ruRU", "Восточная башня дирижабля - Тирисфальские леса и Тернистая долина", "", 18019),
-(190671, "deDE", "Westlicher Zeppelinlandeturm - Nordend und Mulgore", "", 18019),
-(190671, "frFR", "Tour de Zepplin ouest - Norfendre et Mulgore", "", 18019),
-(190671, "esES", "Torre Zepelín Oeste - Rasganorte y Mulgore", "", 18019),
-(190671, "esMX", "Torre Zepelín Oeste - Rasganorte y Mulgore", "", 18019),
-(190671, "ruRU", "Западная башня дирижаблей - Нордскол и Мулгор", "", 18019);
diff --git a/sql/updates/world/3.3.5/2019_12_10_03_world_335.sql b/sql/updates/world/3.3.5/2019_12_10_03_world_335.sql
new file mode 100644
index 00000000000..9572a70a8ee
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_12_10_03_world_335.sql
@@ -0,0 +1,21 @@
+-- 
+DELETE FROM `gameobject_template_locale` WHERE `entry` IN (190671,165557,3224);
+INSERT INTO `gameobject_template_locale` (`entry`, `locale`, `name`, `castBarCaption`, `VerifiedBuild`) VALUES
+(3224, "deDE", "Klingenhügel", "", 18019),
+(3224, "esES", "Cerrotajo", "", 18019),
+(3224, "esMX", "Cerrotajo", "", 18019),
+(3224, "frFR", "Tranchecolline", "", 18019),
+(3224, "koKR", "칼바위 언덕", "", 18019),
+(3224, "ruRU", "Колючий Холм", "", 18019),
+(3224, "zhCN", "剃刀岭", "", 18019),
+(3224, "zhTW", "剃刀嶺", "", 18019),
+(165557, "deDE", "Östlicher Zeppelinlandeturm - Tirisfal und Schlingendorntal", "", 18019),
+(165557, "frFR", "Tour de Zepplin est - Clairières de Tirisfal et Vallée de Strangleronce", "", 18019),
+(165557, "esES", "Torre Zepelin Este - Claros de Tirisfal y Valle de Tuercespina", "", 18019),
+(165557, "esMX", "Torre Zepelin Este - Claros de Tirisfal y Valle de Tuercespina", "", 18019),
+(165557, "ruRU", "Восточная башня дирижабля - Тирисфальские леса и Тернистая долина", "", 18019),
+(190671, "deDE", "Westlicher Zeppelinlandeturm - Nordend und Mulgore", "", 18019),
+(190671, "frFR", "Tour de Zepplin ouest - Norfendre et Mulgore", "", 18019),
+(190671, "esES", "Torre Zepelín Oeste - Rasganorte y Mulgore", "", 18019),
+(190671, "esMX", "Torre Zepelín Oeste - Rasganorte y Mulgore", "", 18019),
+(190671, "ruRU", "Западная башня дирижаблей - Нордскол и Мулгор", "", 18019);
diff --git a/sql/updates/world/3.3.5/2019_12_10_04_world.sql b/sql/updates/world/3.3.5/2019_12_10_04_world.sql
new file mode 100644
index 00000000000..144cc498223
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_12_10_04_world.sql
@@ -0,0 +1,6 @@
+-- 
+DELETE FROM `creature` WHERE `guid` IN (120604,120605,120606);
+INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`) VALUES
+(120604, 33600, 571, 1, 1, 0, 1, 8548.21, 954.800, 547.377, 4.88665, 300, 0, 0, 0, 0, 0),
+(120605, 33601, 571, 1, 1, 0, 0, 8559.26, 939.371, 547.777, 6.25005, 300, 0, 0, 0, 0, 0),
+(120606, 33603, 571, 1, 1, 0, 0, 8549.54, 944.761, 547.368, 1.03501, 300, 0, 0, 0, 0, 0);
-- 
cgit v1.2.3