aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAokromes <Aokromes@users.noreply.github.com>2017-09-05 08:27:29 +0200
committerShauren <shauren.trinity@gmail.com>2020-08-23 19:01:46 +0200
commiteccaf847c5f537201d02da46724cdf7e4a46e4c0 (patch)
tree6d0d017b7a4a2c1215c467d28c9c4fd21fc1e1e9
parentb3c6330a6e4b143439b7641f071526a00629a5a6 (diff)
DB/Creature: Restore 2 creatures deleted on previous commit
(cherry picked from commit 310cc50cd1f8747bfb4a5e3fdd02a74b066cf701)
-rw-r--r--sql/updates/world/master/2020_08_23_15_world_2017_09_05_00_world.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/master/2020_08_23_15_world_2017_09_05_00_world.sql b/sql/updates/world/master/2020_08_23_15_world_2017_09_05_00_world.sql
new file mode 100644
index 00000000000..049d6557ee8
--- /dev/null
+++ b/sql/updates/world/master/2020_08_23_15_world_2017_09_05_00_world.sql
@@ -0,0 +1,5 @@
+--
+DELETE FROM `creature` WHERE `guid` IN (80537,80538);
+INSERT INTO `creature`(`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES
+(80537, 31152, 571, 210, 4508, '0', 0, 0, 0, 0, 1, 6799.83, 1433.43, 390.812, 6.28299, 300, 0, 0, 12600, 0, 0, 0, 0, 0, '', 0),
+(80538, 31152, 571, 0, 0, '0', 0, 0, 0, 0, 1, 6799.42, 1426.43, 390.812, 0.0389925, 300, 0, 0, 12600, 0, 0, 0, 0, 0, '', 0);