diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2017_06_05_00_world.sql | 46 |
1 files changed, 46 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_06_05_00_world.sql b/sql/updates/world/3.3.5/2017_06_05_00_world.sql new file mode 100644 index 00000000000..b920c846b8d --- /dev/null +++ b/sql/updates/world/3.3.5/2017_06_05_00_world.sql @@ -0,0 +1,46 @@ +-- +SET @CGUID:= 132940; +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+32; +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 +(@CGUID+0, 24613, 571, 0, 0, 1, 1, 0, 0, 3188.32, 5437.35, 53.7537, 5.72132, 120, 0, 0, 0, 0, 0, 0, 0, 0, -1), +(@CGUID+1, 24613, 571, 0, 0, 1, 1, 0, 0, 3170.24, 5415.1, 57.39811, 5.77623, 120, 0, 0, 0, 0, 0, 0, 0, 0, -1), +(@CGUID+2, 24614, 571, 0, 0, 1, 1, 0, 0, 3166.93, 5429.86, 56.8125, 6.04979, 120, 0, 0, 0, 0, 0, 0, 0, 0, -1), +(@CGUID+3, 25850, 571, 0, 0, 1, 1, 0, 0, 3157.15, 5430.56, 57.0264, 2.05949, 120, 0, 0, 0, 0, 0, 0, 0, 0, -1), +(@CGUID+4, 24614, 571, 0, 0, 1, 1, 0, 0, 3161.13, 5467.45, 52.9955, 5.96556, 120, 0, 0, 0, 0, 0, 0, 0, 0, -1), +(@CGUID+5, 24613, 571, 0, 0, 1, 1, 0, 0, 3203.34, 5401.62, 55.2084, 5.20332, 120, 0, 0, 0, 0, 0, 0, 0, 0, -1), +(@CGUID+6, 24614, 571, 0, 0, 1, 1, 0, 0, 3304.46, 5397.66, 47.3139, 3.07962, 120, 0, 0, 0, 0, 0, 0, 0, 0, -1), +(@CGUID+7, 24614, 571, 0, 0, 1, 1, 0, 0, 3088.54, 5463.98, 56.7078, 3.76343, 120, 0, 0, 0, 0, 0, 0, 0, 0, -1), +(@CGUID+8, 24614, 571, 0, 0, 1, 1, 0, 0, 3270.75, 5424.04, 50.5341, 3.18424, 120, 0, 0, 0, 0, 0, 0, 0, 0, -1), +(@CGUID+9, 24614, 571, 0, 0, 1, 1, 0, 0, 3233.43, 5407.54, 52.1007, 2.50588, 120, 0, 0, 0, 0, 0, 0, 0, 0, -1), +(@CGUID+10, 24613, 571, 0, 0, 1, 1, 0, 0, 3076.49, 5509.77, 53.2529, 4.87894, 120, 0, 0, 0, 0, 0, 0, 0, 0, -1), +(@CGUID+11, 25743, 571, 0, 0, 1, 1, 0, 0, 3389.05, 5263.91, 30.4101, 5.83653, 120, 0, 0, 0, 0, 0, 0, 0, 0, -1), +(@CGUID+12, 25850, 571, 0, 0, 1, 1, 0, 0, 3333.28, 5265.17, 35.6292, 0.06981, 120, 0, 0, 0, 0, 0, 0, 0, 0, -1), +(@CGUID+13, 24614, 571, 0, 0, 1, 1, 0, 0, 3200.42, 5419.16, 54.8875, 5.76755, 120, 0, 0, 0, 0, 0, 0, 0, 0, -1), +(@CGUID+14, 24614, 571, 0, 0, 1, 1, 0, 0, 3136.79, 5457.59, 53.8239, 5.60821, 120, 0, 0, 0, 0, 0, 0, 0, 0, -1), +(@CGUID+15, 24613, 571, 0, 0, 1, 1, 0, 0, 3046.25, 5466.79, 59.0145, 4.03071, 120, 0, 0, 0, 0, 0, 0, 0, 0, -1), +(@CGUID+16, 24613, 571, 0, 0, 1, 1, 0, 0, 3080.56, 5449.86, 59.6447, 1.89208, 120, 0, 0, 0, 0, 0, 0, 0, 0, -1), +(@CGUID+17, 24614, 571, 0, 0, 1, 1, 0, 0, 3292.25, 5475.55, 53.1222, 1.45228, 120, 0, 0, 0, 0, 0, 0, 0, 0, -1), +(@CGUID+18, 24614, 571, 0, 0, 1, 1, 0, 0, 3067.22, 5439.3, 60.88951, 2.18977, 120, 0, 0, 0, 0, 0, 0, 0, 0, -1), +(@CGUID+19, 24614, 571, 0, 0, 1, 1, 0, 0, 3055.63, 5486.08, 54.5122, 1.55595, 120, 0, 0, 0, 0, 0, 0, 0, 0, -1), +(@CGUID+20, 24613, 571, 0, 0, 1, 1, 0, 0, 3233.39, 5385.66, 49.9387, 1.72793, 120, 0, 0, 0, 0, 0, 0, 0, 0, -1), +(@CGUID+21, 24613, 571, 0, 0, 1, 1, 0, 0, 3143.02, 5477.62, 52.3278, 5.28712, 120, 0, 0, 0, 0, 0, 0, 0, 0, -1), +(@CGUID+22, 24613, 571, 0, 0, 1, 1, 0, 0, 3288.17, 5411.46, 49.3348, 0.61423, 120, 0, 0, 0, 0, 0, 0, 0, 0, -1), +(@CGUID+23, 24613, 571, 0, 0, 1, 1, 0, 0, 3160.7, 5477.9, 51.623511, 4.81588, 120, 0, 0, 0, 0, 0, 0, 0, 0, -1), +(@CGUID+24, 24614, 571, 0, 0, 1, 1, 0, 0, 3329.51, 5482.04, 58.4725, 2.87751, 120, 0, 0, 0, 0, 0, 0, 0, 0, -1), +(@CGUID+25, 24614, 571, 0, 0, 1, 1, 0, 0, 3233.91, 5444.3, 50.27381, 3.92431, 120, 0, 0, 0, 0, 0, 0, 0, 0, -1), +(@CGUID+26, 24613, 571, 0, 0, 1, 1, 0, 0, 3221.21, 5455.7, 49.26961, 0.09369, 120, 0, 0, 0, 0, 0, 0, 0, 0, -1), +(@CGUID+27, 24613, 571, 0, 0, 1, 1, 0, 0, 3227.15, 5437.62, 52.7524, 3.14834, 120, 0, 0, 0, 0, 0, 0, 0, 0, -1), +(@CGUID+28, 24613, 571, 0, 0, 1, 1, 0, 0, 3090.65, 5482.13, 54.0916, 4.99731, 120, 0, 0, 0, 0, 0, 0, 0, 0, -1), +(@CGUID+29, 25850, 571, 0, 0, 1, 1, 0, 0, 3700.11, 5342.11, 36.1529, 4.01421, 120, 0, 0, 0, 0, 0, 0, 0, 0, -1), +(@CGUID+30, 24613, 571, 0, 0, 1, 1, 0, 0, 3031.2, 5481.69, 59.26871, 5.14991, 120, 0, 0, 0, 0, 0, 0, 0, 0, -1), +(@CGUID+31, 24613, 571, 0, 0, 1, 1, 0, 0, 3110.81, 5452.43, 51.7038, 5.20543, 120, 0, 0, 0, 0, 0, 0, 0, 0, -1), +(@CGUID+32, 24613, 571, 0, 0, 1, 1, 0, 0, 3136.54, 5441.85, 54.6684, 5.85653, 120, 0, 0, 0, 0, 0, 0, 0, 0, -1); + +UPDATE `creature` SET `spawntimesecs` = 300 , `spawndist` = 5, `MovementType` = 1 WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+32; +UPDATE `creature` SET `spawndist` = 0 , `MovementType` = 0 WHERE `guid` IN (@CGUID+3, @CGUID+12, @CGUID+29); + +SET @OGUID:= 3149; +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+1; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES +(@OGUID+0, 188028, 571, 0, 0, 1, 1, 3157.151, 5430.631, 56.93376, 2.740162, 0, 0, 0.9799242, 0.1993704, 120, 255, 1, -1), +(@OGUID+1, 188037, 571, 0, 0, 1, 1, 3700.095, 5342.125, 36.07272, 5.166176, 0, 0, -0.5299187, 0.8480484, 120, 255, 1, -1); |