aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2018-10-16 18:15:06 +0200
committerKillyana <morphone1@gmail.com>2018-10-16 18:15:06 +0200
commit2a31f7b9bc669d971b0cfeb9cef9707caedc6f9a (patch)
treedfd3a139f69dadcb49d89773054e4ee5cb3dab42
parent04e9d25b3e51ebb7a2f84118cbcf86a24cd43e64 (diff)
DB/Creature: Horizon Scout members
-rw-r--r--sql/updates/world/3.3.5/2018_10_16_01_world_335.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2018_10_16_01_world_335.sql b/sql/updates/world/3.3.5/2018_10_16_01_world_335.sql
new file mode 100644
index 00000000000..97f084200b6
--- /dev/null
+++ b/sql/updates/world/3.3.5/2018_10_16_01_world_335.sql
@@ -0,0 +1,12 @@
+--
+DELETE FROM `creature` WHERE `guid` IN (91691,91692,91693,91694,91695);
+INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`,`spawndist`, `MovementType`) VALUES
+(91691,8387,1,1,1,0,0, 1747.24, -5859.60, -90.3817, 3.98543,300,0,0),
+(91692,8388,1,1,1,0,0, 1747.62, -5862.27, -90.9249, 3.17332,300,0,0),
+(91693,8389,1,1,1,0,0, 1748.87, -5863.46, -90.2665, 2.83088,300,0,0),
+(91694,8394,1,1,1,0,0, 1746.45, -5861.29, -91.4165, 3.20841,300,0,0),
+(91695,8478,1,1,1,0,0, 1916.44, -5733.37, 10.1936, 4.10397,300,0,0);
+
+DELETE FROM `creature_addon` WHERE `guid` IN (91694,91695);
+INSERT INTO `creature_addon` (`guid`,`bytes1`,`bytes2`,`auras`) VALUES
+(91694,0,1, '66515'),(91695,8,0, '0');