aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAokromes <Aokromes@users.noreply.github.com>2017-09-05 08:27:29 +0200
committerGitHub <noreply@github.com>2017-09-05 08:27:29 +0200
commit310cc50cd1f8747bfb4a5e3fdd02a74b066cf701 (patch)
tree0dde43eefb6507b0b57e9fac445d671d8fd960fc
parentf67c6a5a1297a2b65a948c6c4108acc76bc41888 (diff)
DB/Creature: Restore 2 creatures deleted on previous commit
-rw-r--r--sql/updates/world/3.3.5/2017_09_05_00_world.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_09_05_00_world.sql b/sql/updates/world/3.3.5/2017_09_05_00_world.sql
new file mode 100644
index 00000000000..89b19d5dc92
--- /dev/null
+++ b/sql/updates/world/3.3.5/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`, `spawnMask`, `phaseMask`, `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, 1, 1, 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, 1, 1, 0, 1, 6799.42, 1426.43, 390.812, 0.0389925, 300, 0, 0, 12600, 0, 0, 0, 0, 0, '', 0);