aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2019-05-11 17:53:33 +0200
committerShauren <shauren.trinity@gmail.com>2021-12-05 15:12:55 +0100
commit182cf0ae7666be735b6ec6024bcde2d9cefeb72a (patch)
treee9f42c0ed75d1d33fd0eec420d37dcf80a649b61
parent6f2745215bc91f6ad2665234387b26d79c2a23d7 (diff)
DB/Creature: Tarren Mill Horse & Young Blanchy
(cherry picked from commit 441795cc496158af11c348d0b0fe7329856c9171)
-rw-r--r--sql/updates/world/master/2021_12_05_12_world_2019_05_11_06_world.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_12_05_12_world_2019_05_11_06_world.sql b/sql/updates/world/master/2021_12_05_12_world_2019_05_11_06_world.sql
new file mode 100644
index 00000000000..3f3798ebf7a
--- /dev/null
+++ b/sql/updates/world/master/2021_12_05_12_world_2019_05_11_06_world.sql
@@ -0,0 +1,6 @@
+--
+DELETE FROM `creature` WHERE `guid` IN (104824,104827,83516);
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `phaseId`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
+(104824, 18650, 560, 0, 0, '1,2', 0, 0, 0, 2478.69, 688.93, 55.7619, 0.286027, 86400, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(104827, 18650, 560, 0, 0, '1,2', 0, 0, 0, 2486.82, 689.457, 55.8031, 1.65806, 86400, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(83516, 18651, 560, 0, 0, '1,2', 0, 0, 0, 2476.17, 689.82, 55.8635, 1.51844, 86400, 0, 0, 0, 0, 0, 0, 0, 0, 0);