diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2018-01-21 11:10:36 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2018-01-21 11:10:36 +0100 |
| commit | 771ec0b2256e0f88b365e47af5b8d837a3cae445 (patch) | |
| tree | 90b3d0cc56833dffe4162701f88776b951eaf551 | |
| parent | 9e8b4bd4e28b373e1ebeb368b8078e0750445f22 (diff) | |
Update 2018_01_20_01_world.sql
| -rw-r--r-- | sql/updates/world/master/2018_01_20_01_world.sql | 18 |
1 files changed, 9 insertions, 9 deletions
diff --git a/sql/updates/world/master/2018_01_20_01_world.sql b/sql/updates/world/master/2018_01_20_01_world.sql index a8cd0b64ec1..4ca510bb570 100644 --- a/sql/updates/world/master/2018_01_20_01_world.sql +++ b/sql/updates/world/master/2018_01_20_01_world.sql @@ -1,15 +1,15 @@ /* creature */ SET @CGUID := 251569; -- Set necessary DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+7; -INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `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 -(@CGUID+0,42560,0,40,109,1,1,169,0,0,0,-9855.52,1277.67,40.8733,5.64321,120,0,0,0,0,0,0,0,0,'',18019), -(@CGUID+1,42403,0,40,109,1,1,169,0,0,0,-9854.61,1277.01,40.8672,5.54896,120,0,0,0,0,0,0,0,0,'',18019), -(@CGUID+2,42386,0,40,109,1,1,169,0,32826,0,-9859.24,1279.61,41.0337,5.58039,120,0,0,0,0,0,0,0,0,'',18019), -(@CGUID+3,42384,0,40,109,1,1,169,0,32819,0,-9861.03,1276.97,40.7707,0.110977,120,0,0,0,0,0,0,0,0,'',18019), -(@CGUID+4,42384,0,40,109,1,1,169,0,32818,0,-9851.09,1273.94,41.0974,2.4279,120,0,0,0,0,0,0,0,0,'',18019), -(@CGUID+5,42559,0,40,109,1,1,169,0,0,0,-9852.11,1274.83,41.0164,5.54593,120,0,0,0,0,0,0,0,0,'',18019), -(@CGUID+6,42559,0,40,109,1,1,169,0,0,0,-9859.83,1276.11,40.7818,2.44651,120,0,0,0,0,0,0,0,0,'',18019), -(@CGUID+7,42558,0,40,109,1,1,169,0,0,0,-9854.99,1275.83,40.9068,1.43605,120,0,0,2865,0,0,0,0,0,'',18019); +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `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 +(@CGUID+0,42560,0,40,109,1,169,0,0,0,-9855.52,1277.67,40.8733,5.64321,120,0,0,0,0,0,0,0,0,'',18019), +(@CGUID+1,42403,0,40,109,1,169,0,0,0,-9854.61,1277.01,40.8672,5.54896,120,0,0,0,0,0,0,0,0,'',18019), +(@CGUID+2,42386,0,40,109,1,169,0,32826,0,-9859.24,1279.61,41.0337,5.58039,120,0,0,0,0,0,0,0,0,'',18019), +(@CGUID+3,42384,0,40,109,1,169,0,32819,0,-9861.03,1276.97,40.7707,0.110977,120,0,0,0,0,0,0,0,0,'',18019), +(@CGUID+4,42384,0,40,109,1,169,0,32818,0,-9851.09,1273.94,41.0974,2.4279,120,0,0,0,0,0,0,0,0,'',18019), +(@CGUID+5,42559,0,40,109,1,169,0,0,0,-9852.11,1274.83,41.0164,5.54593,120,0,0,0,0,0,0,0,0,'',18019), +(@CGUID+6,42559,0,40,109,1,169,0,0,0,-9859.83,1276.11,40.7818,2.44651,120,0,0,0,0,0,0,0,0,'',18019), +(@CGUID+7,42558,0,40,109,1,169,0,0,0,-9854.99,1275.83,40.9068,1.43605,120,0,0,2865,0,0,0,0,0,'',18019); UPDATE `creature` SET `spawndist` = 3 , `MovementType` = 1 WHERE `guid` = 276241; UPDATE `creature` SET `spawndist` = 3 , `MovementType` = 1 WHERE `guid` = 276239; |