From 1a89de87c19936b18d45ec783a3244addb996062 Mon Sep 17 00:00:00 2001 From: w1sht0l1v3 Date: Sun, 7 Oct 2012 15:01:16 +0300 Subject: Fixup a guid issue in 2012_10_06_04_world_misc_spawns.sql --- sql/updates/world/2012_10_06_04_world_misc_spawns.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'sql') diff --git a/sql/updates/world/2012_10_06_04_world_misc_spawns.sql b/sql/updates/world/2012_10_06_04_world_misc_spawns.sql index 30d71b6db88..e53302d2c2f 100644 --- a/sql/updates/world/2012_10_06_04_world_misc_spawns.sql +++ b/sql/updates/world/2012_10_06_04_world_misc_spawns.sql @@ -1,4 +1,5 @@ SET @GUID = 42639; -- Requires one (creature) +SET @GUID2 = 42651; SET @OGUID = 5286; -- Requires three (gameobject) DELETE FROM `gameobject` WHERE `id`=203624; @@ -8,7 +9,7 @@ INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x` DELETE FROM `creature` WHERE `id` IN (40081,40091); -- ,40151); INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`) VALUES (@GUID,40091,724,1,0x20,0,0,3113.711,533.5382,72.96869,1.936719,300,0,0,1,0,0,0,0,0), -(@GUID+1,40081,724,1,0x20,0,0,3153.75,533.1875,72.97205,0,300,0,0,1,0,0,0,0,0); +(@GUID2,40081,724,1,0x20,0,0,3153.75,533.1875,72.97205,0,300,0,0,1,0,0,0,0,0); SET @PATH = @GUID * 10; UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@GUID; -- cgit v1.2.3