diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2017_01_26_01_world.sql | 109 |
1 files changed, 109 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_01_26_01_world.sql b/sql/updates/world/3.3.5/2017_01_26_01_world.sql new file mode 100644 index 00000000000..75a8a2eaaa2 --- /dev/null +++ b/sql/updates/world/3.3.5/2017_01_26_01_world.sql @@ -0,0 +1,109 @@ +-- Pathing for Entry: Entry: 'TDB FORMAT' +SET @NPC := 88169; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=6868.516,`position_y`=-1294.699,`position_z`=819.3493 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,6868.516,-1294.699,819.3493,0,0,0,0,100,0), -- 10:10:27 +(@PATH,2,6975.632,-1296.781,820.0719,0,0,0,0,100,0), -- 10:10:37 +(@PATH,3,6997.25,-1300.064,819.407,0,0,0,0,100,0), -- 10:10:56 +(@PATH,4,7008.524,-1306.789,819.0188,0,0,0,0,100,0), -- 10:11:06 +(@PATH,5,7021.846,-1309.306,819.4227,0,0,0,0,100,0), -- 10:11:11 +(@PATH,6,7003.697,-1301.392,818.9383,0,0,0,0,100,0), -- 10:11:54 +(@PATH,7,7000.687,-1300.873,819.0015,0,0,0,0,100,0), -- 10:11:54 +(@PATH,8,6990.829,-1299.174,819.2029,0,0,0,0,100,0), -- 10:11:54 +(@PATH,9,6983.732,-1297.951,819.0749,0,0,0,0,100,0), -- 10:11:54 +(@PATH,10,6978.753,-1297.093,819.8131,0,0,0,0,100,0), -- 10:11:54 +(@PATH,11,6933.704,-1297.541,818.332,0,0,0,0,100,0), -- 10:11:55 +(@PATH,12,6904.09,-1297.22,817.8347,0,0,0,0,100,0), -- 10:12:14 +(@PATH,13,6871.701,-1294.981,819.4993,0,0,0,0,100,0), -- 10:12:25 +(@PATH,14,6864.567,-1295.635,819.6678,0,0,0,0,100,0), -- 10:12:37 +(@PATH,15,6851.839,-1303.085,819.5963,0,0,0,0,100,0), -- 10:12:43 +(@PATH,16,6846.907,-1315.529,819.6013,0,0,0,0,100,0), -- 10:12:47 +(@PATH,17,6841.49,-1325.891,819.5414,0,0,0,0,100,0), -- 10:12:53 +(@PATH,18,6828.455,-1335.079,819.5318,0,0,0,0,100,0), -- 10:12:58 +(@PATH,19,6823.039,-1341.79,819.4916,0,0,0,0,100,0), -- 10:13:03 +(@PATH,20,6820.515,-1348.456,819.5859,0,0,0,0,100,0), -- 10:13:09 +(@PATH,21,6826.79,-1365.719,819.5203,0,0,0,0,100,0), -- 10:13:14 +(@PATH,22,6819.301,-1345.58,819.2617,0,0,0,0,100,0), -- 10:13:28 +(@PATH,23,6823.587,-1338.309,819.2981,0,0,0,0,100,0), -- 10:13:34 +(@PATH,24,6835.098,-1330.28,819.5295,0,0,0,0,100,0), -- 10:13:40 +(@PATH,25,6840.789,-1325.611,819.6505,0,0,0,0,100,0), -- 10:13:45 +(@PATH,26,6845.475,-1316.28,819.5759,0,0,0,0,100,0), -- 10:13:51 +(@PATH,27,6853.743,-1297.22,818.8912,0,0,0,0,100,0), -- 10:13:55 +(@PATH,28,6870.304,-1293.806,819.4411,0,0,0,0,100,0), -- 10:14:00 +(@PATH,29,6876.159,-1291.004,818.8831,0,0,0,0,100,0), -- 10:14:07 +(@PATH,30,6878.144,-1262.132,812.6442,0,0,0,0,100,0), -- 10:14:09 +(@PATH,31,6873.647,-1252.831,810.8083,0,0,0,0,100,0); -- 10:14:22 +-- 0x203AF447601CD38000279D00000715A5 .go 6868.516 -1294.699 819.3493 +UPDATE `creature` SET `spawntimesecs`=70 WHERE `guid`=88169; -- Reduce respawntimer for Overseer Syra + +-- Pathing for Entry: Entry: 'TDB FORMAT' +SET @NPC := 118748; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=6968.008,`position_y`=-1296.997,`position_z`=819.9882 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,6968.008,-1296.997,819.9882,0,0,0,0,100,0), -- 10:07:58 +(@PATH,2,6963.805,-1298.181,819.358,0,0,0,0,100,0), -- 10:07:58 +(@PATH,3,6959.602,-1299.365,818.7279,0,0,0,0,100,0), -- 10:07:58 +(@PATH,4,6959.93,-1303.829,819.8639,0,0,0,0,100,0), -- 10:07:58 +(@PATH,5,6960.046,-1305.398,819.8121,0,0,0,0,100,0), -- 10:07:58 +(@PATH,6,6960.284,-1308.637,819.9722,0,0,0,0,100,0), -- 10:07:58 +(@PATH,7,6961.163,-1320.573,824.9525,0,0,0,0,100,0), -- 10:07:58 +(@PATH,8,6961.253,-1321.797,825.4842,0,0,0,0,100,0), -- 10:07:58 +(@PATH,9,6961.544,-1325.749,825.5422,0,0,0,0,100,0), -- 10:07:58 +(@PATH,10,6961.904,-1330.632,827.6084,0,0,0,0,100,0), -- 10:07:58 +(@PATH,11,6961.904,-1330.632,827.6084,0,0,0,0,100,0), -- 10:07:58 +(@PATH,12,6962.487,-1342.573,831.4812,0,0,0,0,100,0), -- 10:08:01 +(@PATH,13,6948.927,-1350.713,830.8229,0,0,0,0,100,0), -- 10:08:08 +(@PATH,14,6939.676,-1354.346,831.2539,0,0,0,0,100,0), -- 10:08:16 +(@PATH,15,6941.445,-1394.076,830.7235,0,0,0,0,100,0), -- 10:08:21 +(@PATH,16,6942.726,-1409.257,831.3031,0,0,0,0,100,0), -- 10:08:36 +(@PATH,17,6941.713,-1395.769,831.0747,0,0,0,0,100,0), -- 10:08:44 +(@PATH,18,6935.001,-1359.384,831.3281,0,0,0,0,100,0), -- 10:08:50 +(@PATH,19,6944.928,-1352.093,830.656,0,0,0,0,100,0), -- 10:09:04 +(@PATH,20,6956.648,-1349.07,830.9777,0,0,0,0,100,0), -- 10:09:10 +(@PATH,21,6962.22,-1338.124,830.9603,0,0,0,0,100,0), -- 10:09:17 +(@PATH,22,6959.981,-1303.874,820.1893,0,0,0,0,100,0), -- 10:09:24 +(@PATH,23,6966.787,-1297.426,819.9738,0,0,0,0,100,0); -- 10:09:37 +-- 0x203AF447601CBC8000279D0000071700 .go 6968.008 -1296.997 819.9882 + +SET @CGUID := 73946; -- Set by TC +DELETE FROM `creature` WHERE `guid`=@CGUID ; +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, 29426, 571, 67, 4425, 1, 1, 25771, 1, 6941.46, -1394.98, 830.308, 1.66341, 300, 5, 0, 12175, 0, 1, 0, 0, 0, 0); + +-- Pathing for Entry: Entry: 'TDB FORMAT' +SET @NPC := @CGUID; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=6925.252,`position_y`=-1263.308,`position_z`=814.2664 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,6925.252,-1263.308,814.2664,0,0,0,0,100,0), -- 10:08:03 +(@PATH,2,6922.525,-1243.218,808.5113,0,0,0,0,100,0), -- 10:08:03 +(@PATH,3,6926.741,-1272.294,820.0898,0,0,0,0,100,0), -- 10:09:06 +(@PATH,4,6926.937,-1273.901,819.8865,0,0,0,0,100,0), -- 10:09:06 +(@PATH,5,6927.132,-1275.507,819.6831,0,0,0,0,100,0), -- 10:09:06 +(@PATH,6,6927.252,-1276.498,819.5345,0,0,0,0,100,0), -- 10:09:06 +(@PATH,7,6927.428,-1278.836,819.2196,0,0,0,0,100,0), -- 10:09:06 +(@PATH,8,6927.428,-1278.836,819.2196,0,0,0,0,100,0), -- 10:09:06 +(@PATH,9,6927.392,-1278.572,819.5107,0,0,0,0,100,0), -- 10:09:07 +(@PATH,10,6927.438,-1283.495,819.0168,0,0,0,0,100,0), -- 10:09:08 +(@PATH,11,6927.41,-1293.19,817.7994,0,0,0,0,100,0), -- 10:09:12 +(@PATH,12,6927.546,-1283.57,818.8883,0,0,0,0,100,0), -- 10:09:19 +(@PATH,13,6927.271,-1274.576,820.142,0,0,0,0,100,0), -- 10:09:24 +(@PATH,14,6925.076,-1260.895,814.7872,0,0,0,0,100,0), -- 10:09:25 +(@PATH,15,6922.868,-1243.143,808.9681,0,0,0,0,100,0), -- 10:09:32 +(@PATH,16,6915.284,-1209.543,808.6826,0,0,0,0,100,0), -- 10:09:39 +(@PATH,17,6913.438,-1202.95,807.5819,0,0,0,0,100,0), -- 10:10:22 +(@PATH,18,6917.339,-1220.117,808.3813,0,0,0,0,100,0), -- 10:10:22 +(@PATH,19,6920.42,-1233.675,808.5808,0,0,0,0,100,0), -- 10:10:22 +(@PATH,20,6920.771,-1235.216,808.4938,0,0,0,0,100,0); -- 10:10:22 +-- 0x203AF447601CBC8000279D0000071604 .go 6925.252 -1263.308 814.2664 |