aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAokromes <Aokromes@users.noreply.github.com>2015-09-09 04:37:31 +0200
committerAokromes <Aokromes@users.noreply.github.com>2015-09-09 04:37:31 +0200
commit153c8fda6fcaa1b92b309bb9c3d4d46e22dcfa08 (patch)
tree5fbb54ed7ef909a04e4d1daaddcb1054cb04eca1
parent90ef83ad052892ee3df56ccb9af9594b0dd8932f (diff)
DB/Misc: Fix startup errors
-rw-r--r--sql/updates/world/2015_09_09_00_world.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/2015_09_09_00_world.sql b/sql/updates/world/2015_09_09_00_world.sql
new file mode 100644
index 00000000000..a3190da0559
--- /dev/null
+++ b/sql/updates/world/2015_09_09_00_world.sql
@@ -0,0 +1,8 @@
+--
+DELETE FROM `creature` WHERE `guid` IN (120831,120833,123124);
+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`, `VerifiedBuild`) VALUES
+(120831, 32769, 571, 1, 1, 25753, 0, 7523.09, 1852.78, 491.641, 3.23212, 300, 0, 0, 12600, 3994, 0, 0, 0, 0, 0),
+(120833, 32769, 571, 1, 1, 25753, 0, 7703.2, 1822.89, 469.378, 3.94286, 300, 0, 0, 12600, 3994, 0, 0, 0, 0, 0),
+(123124, 32769, 571, 1, 1, 25753, 0, 7733.55, 1578.02, 469.378, 2.51066, 300, 0, 0, 12600, 3994, 0, 0, 0, 0, 0);
+
+DELETE FROM pool_creature WHERE guid = 151994;