aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2018-10-09 20:57:42 +0200
committerKillyana <morphone1@gmail.com>2018-10-09 20:57:42 +0200
commit7c003c568cdde4563fbad6ec03f724c1856fc87c (patch)
tree5bcbfda3796858c8d0b5d47dd41e01cea916ef3e
parentc50daeb77f161bf796f8039847b82a101c854132 (diff)
DB/Creature: Update Orc cosmetic mounts
One mount was missing and an old one from vanilla not updated
-rw-r--r--sql/updates/world/3.3.5/2018_10_09_06_world_335.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2018_10_09_06_world_335.sql b/sql/updates/world/3.3.5/2018_10_09_06_world_335.sql
new file mode 100644
index 00000000000..5180e32734a
--- /dev/null
+++ b/sql/updates/world/3.3.5/2018_10_09_06_world_335.sql
@@ -0,0 +1,6 @@
+--
+UPDATE `creature` SET `id`=358, `position_x`=2165, `position_y`=-4656.42, `position_z`=50.5176, `orientation`=2.79916 WHERE `guid`=6615;
+DELETE FROM `creature` WHERE `guid` IN (86813);
+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
+(86813, 5194, 1, 1, 1, 0, 0, 2163.92, -4651.9, 50.6112, 3.61204, 180, 0, 0, 0, 0,0);
+UPDATE `creature` SET `orientation`=0.484856 WHERE `guid`=6617;