DB/Creature: Icetip Crawler

Closes #18929

1 files changed, 191 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2017_01_24_03_world.sql b/sql/updates/world/3.3.5/2017_01_24_03_world.sql
new file mode 100644
index 00000000000..4d4a222c07f
--- /dev/null
+++ b/sql/updates/world/3.3.5/2017_01_24_03_world.sql
@@ -0,0 +1,191 @@
+-- [NPC][WotlK] Icetip Crawler, missing wps 
+UPDATE `creature` SET `spawntimesecs`=30 WHERE `id`=29461;
+
+-- Pathing for  Entry: Entry: 'TDB FORMAT' 
+SET @NPC := 98069;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=6814.004,`position_y`=-1511.774,`position_z`=357.4496 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,6814.004,-1511.774,357.4496,0,0,0,0,100,0), -- 10:52:21
+(@PATH,2,6810.2,-1512.353,357.7509,0,0,0,0,100,0), -- 10:52:21
+(@PATH,3,6806.395,-1512.932,358.0522,0,0,0,0,100,0), -- 10:52:21
+(@PATH,4,6802.339,-1513.548,358.3836,0,0,0,0,100,0), -- 10:52:21
+(@PATH,5,6801.33,-1513.702,358.5244,0,0,0,0,100,0), -- 10:52:21
+(@PATH,6,6789.786,-1515.457,360.9578,0,0,0,0,100,0), -- 10:52:21
+(@PATH,7,6784.221,-1516.303,362.3386,0,0,0,0,100,0), -- 10:52:21
+(@PATH,8,6781.355,-1516.739,362.8942,0,0,0,0,100,0), -- 10:52:21
+(@PATH,9,6781.355,-1516.739,362.8942,0,0,0,0,100,0), -- 10:52:21
+(@PATH,10,6793.878,-1503.023,360.585,0,0,0,0,100,0), -- 10:52:22
+(@PATH,11,6808.696,-1469.133,360.8632,0,0,0,0,100,0), -- 10:52:25
+(@PATH,12,6826.229,-1482.206,358.68,0,0,0,0,100,0), -- 10:52:30
+(@PATH,13,6838.727,-1490.121,357.8129,0,0,0,0,100,0), -- 10:52:33
+(@PATH,14,6827.854,-1522.164,356.5045,0,0,0,0,100,0), -- 10:52:35
+(@PATH,15,6795.745,-1523.78,359.4385,0,0,0,0,100,0), -- 10:52:40
+(@PATH,16,6784.725,-1496.301,362.6828,0,0,0,0,100,0), -- 10:52:44
+(@PATH,17,6790.426,-1482.139,362.364,0,0,0,0,100,0), -- 10:52:49
+(@PATH,18,6815.653,-1470.522,360.2863,0,0,0,0,100,0), -- 10:52:50
+(@PATH,19,6797.456,-1477.746,361.3162,0,0,0,0,100,0), -- 10:52:54
+(@PATH,20,6785.462,-1486.006,363.1354,0,0,0,0,100,0), -- 10:52:56
+(@PATH,21,6793.262,-1522.423,360.3156,0,0,0,0,100,0), -- 10:52:58
+(@PATH,22,6823.55,-1524.131,356.6426,0,0,0,0,100,0), -- 10:53:02
+(@PATH,23,6843.175,-1494.858,357.0524,0,0,0,0,100,0), -- 10:53:07
+(@PATH,24,6833.277,-1487.401,358.1684,0,0,0,0,100,0), -- 10:53:10
+(@PATH,25,6812.998,-1465.577,360.3898,0,0,0,0,100,0), -- 10:53:13
+(@PATH,26,6801.987,-1490.344,359.7208,0,0,0,0,100,0), -- 10:53:17
+(@PATH,27,6782.202,-1516.059,363.032,0,0,0,0,100,0), -- 10:53:20
+(@PATH,28,6806.502,-1512.667,358.5165,0,0,0,0,100,0), -- 10:53:24
+(@PATH,29,6814.063,-1530.013,356.8398,0,0,0,0,100,0), -- 10:53:27
+(@PATH,30,6824.634,-1510.613,356.9213,0,0,0,0,100,0), -- 10:53:30
+(@PATH,31,6836.296,-1503.345,356.6489,0,0,0,0,100,0), -- 10:53:32
+(@PATH,32,6836.358,-1477.138,359.5229,0,0,0,0,100,0), -- 10:53:35
+(@PATH,33,6808.336,-1490.938,358.9387,0,0,0,0,100,0), -- 10:53:38
+(@PATH,34,6832.787,-1476.135,359.6523,0,0,0,0,100,0), -- 10:53:44
+(@PATH,35,6838.889,-1497.83,357.3196,0,0,0,0,100,0), -- 10:53:47
+(@PATH,36,6829.207,-1507.01,356.8817,0,0,0,0,100,0), -- 10:53:49
+(@PATH,37,6814.724,-1529.365,356.7092,0,0,0,0,100,0), -- 10:53:52
+(@PATH,38,6812.575,-1522.472,357.1874,0,0,0,0,100,0), -- 10:53:54
+(@PATH,39,6784.434,-1516.24,362.6053,0,0,0,0,100,0), -- 10:53:57
+(@PATH,40,6794.039,-1502.998,360.5512,0,0,0,0,100,0), -- 10:54:00
+(@PATH,41,6808.574,-1469.268,360.8869,0,0,0,0,100,0), -- 10:54:04
+(@PATH,42,6808.625,-1460.67,362.2088,0,0,0,0,100,0), -- 10:54:11
+(@PATH,43,6810.634,-1463.169,361.2263,0,0,0,0,100,0), -- 10:54:11
+(@PATH,44,6812.643,-1465.669,360.2439,0,0,0,0,100,0), -- 10:54:11
+(@PATH,45,6816.484,-1470.447,359.8347,0,0,0,0,100,0), -- 10:54:11
+(@PATH,46,6819.701,-1474.449,359.0368,0,0,0,0,100,0), -- 10:54:11
+(@PATH,47,6823.676,-1479.394,358.4186,0,0,0,0,100,0), -- 10:54:11
+(@PATH,48,6826.224,-1482.563,358.3096,0,0,0,0,100,0), -- 10:54:11
+(@PATH,49,6827.373,-1483.991,358.2897,0,0,0,0,100,0), -- 10:54:11
+(@PATH,50,6827.373,-1483.991,358.2897,0,0,0,0,100,0), -- 10:54:11
+(@PATH,51,6838.721,-1490.242,357.9254,0,0,0,0,100,0), -- 10:54:11
+(@PATH,52,6827.905,-1522.265,356.5711,0,0,0,0,100,0), -- 10:54:14
+(@PATH,53,6795.894,-1523.824,359.4495,0,0,0,0,100,0), -- 10:54:18
+(@PATH,54,6784.802,-1496.306,362.7766,0,0,0,0,100,0), -- 10:54:22
+(@PATH,55,6778.99,-1491.735,364.0555,0,0,0,0,100,0), -- 10:54:31
+(@PATH,56,6782.148,-1489.045,363.4904,0,0,0,0,100,0), -- 10:54:31
+(@PATH,57,6785.307,-1486.355,362.9253,0,0,0,0,100,0), -- 10:54:31
+(@PATH,58,6790.332,-1482.075,362.1711,0,0,0,0,100,0), -- 10:54:31
+(@PATH,59,6793.181,-1479.649,361.8699,0,0,0,0,100,0), -- 10:54:31
+(@PATH,60,6797.31,-1477.95,361.2349,0,0,0,0,100,0), -- 10:54:31
+(@PATH,61,6805.801,-1474.457,360.2778,0,0,0,0,100,0), -- 10:54:31
+(@PATH,62,6809.209,-1473.054,359.9501,0,0,0,0,100,0), -- 10:54:31
+(@PATH,63,6815.562,-1470.441,359.8851,0,0,0,0,100,0), -- 10:54:31
+(@PATH,64,6818.231,-1469.342,359.7625,0,0,0,0,100,0), -- 10:54:31
+(@PATH,65,6818.231,-1469.342,359.7625,0,0,0,0,100,0), -- 10:54:31
+(@PATH,66,6797.456,-1477.746,361.3162,0,0,0,0,100,0), -- 10:54:33
+(@PATH,67,6785.66,-1486.012,362.9827,0,0,0,0,100,0), -- 10:54:35
+(@PATH,68,6793.356,-1522.528,360.3792,0,0,0,0,100,0), -- 10:54:37
+(@PATH,69,6791.57,-1481.02,362.0597,0,0,0,0,100,0), -- 10:54:41
+(@PATH,70,6790.951,-1481.548,362.1327,0,0,0,0,100,0), -- 10:54:41
+(@PATH,71,6790.332,-1482.075,362.2057,0,0,0,0,100,0), -- 10:54:41
+(@PATH,72,6785.307,-1486.355,362.9334,0,0,0,0,100,0), -- 10:54:41
+(@PATH,73,6782.148,-1489.045,363.4904,0,0,0,0,100,0), -- 10:54:41
+(@PATH,74,6784.519,-1496.181,362.5059,0,0,0,0,100,0), -- 10:54:41
+(@PATH,75,6786.498,-1502.14,361.9723,0,0,0,0,100,0), -- 10:54:41
+(@PATH,76,6786.958,-1503.523,361.7775,0,0,0,0,100,0), -- 10:54:41
+(@PATH,77,6789.31,-1510.604,361.1386,0,0,0,0,100,0), -- 10:54:41
+(@PATH,78,6792.167,-1519.207,360.3965,0,0,0,0,100,0), -- 10:54:41
+(@PATH,79,6793.314,-1522.66,359.89,0,0,0,0,100,0), -- 10:54:41
+(@PATH,80,6793.762,-1524.008,359.6256,0,0,0,0,100,0), -- 10:54:41
+(@PATH,81,6793.762,-1524.008,359.6256,0,0,0,0,100,0), -- 10:54:41
+(@PATH,82,6823.603,-1524.051,356.6179,0,0,0,0,100,0), -- 10:54:41
+(@PATH,83,6843.219,-1494.841,357.1965,0,0,0,0,100,0), -- 10:54:45
+(@PATH,84,6833.68,-1487.476,358.3132,0,0,0,0,100,0), -- 10:54:50
+(@PATH,85,6812.612,-1457.098,361.9977,0,0,0,0,100,0), -- 10:55:01
+(@PATH,86,6810.634,-1463.169,361.2263,0,0,0,0,100,0), -- 10:55:01
+(@PATH,87,6808.656,-1469.241,360.455,0,0,0,0,100,0), -- 10:55:01
+(@PATH,88,6808.28,-1470.396,360.3689,0,0,0,0,100,0), -- 10:55:01
+(@PATH,89,6803.619,-1484.702,359.5985,0,0,0,0,100,0), -- 10:55:01
+(@PATH,90,6803.18,-1486.049,359.6079,0,0,0,0,100,0), -- 10:55:01
+(@PATH,91,6802.833,-1487.115,359.5579,0,0,0,0,100,0), -- 10:55:01
+(@PATH,92,6801.731,-1490.498,359.5443,0,0,0,0,100,0), -- 10:55:01
+(@PATH,93,6799.87,-1496.212,359.5768,0,0,0,0,100,0), -- 10:55:01
+(@PATH,94,6799.87,-1496.212,359.5768,0,0,0,0,100,0), -- 10:55:01
+(@PATH,95,6782.041,-1515.926,362.9824,0,0,0,0,100,0), -- 10:55:01
+(@PATH,96,6806.451,-1512.805,358.4553,0,0,0,0,100,0), -- 10:55:03
+(@PATH,97,6813.875,-1529.851,356.8897,0,0,0,0,100,0), -- 10:55:07
+(@PATH,98,6824.628,-1510.521,356.8281,0,0,0,0,100,0), -- 10:55:09
+(@PATH,99,6836.209,-1503.343,356.6615,0,0,0,0,100,0), -- 10:55:12
+(@PATH,100,6836.404,-1476.961,359.5291,0,0,0,0,100,0), -- 10:55:14
+(@PATH,101,6808.285,-1490.99,358.8646,0,0,0,0,100,0), -- 10:55:17
+(@PATH,102,6842.629,-1500.061,356.8884,0,0,0,0,100,0), -- 10:55:32
+(@PATH,103,6839.421,-1501.737,356.7122,0,0,0,0,100,0), -- 10:55:32
+(@PATH,104,6836.213,-1503.412,356.5361,0,0,0,0,100,0), -- 10:55:32
+(@PATH,105,6828.959,-1507.202,356.5681,0,0,0,0,100,0), -- 10:55:32
+(@PATH,106,6825.497,-1509.011,356.7193,0,0,0,0,100,0), -- 10:55:32
+(@PATH,107,6825.497,-1509.011,356.7193,0,0,0,0,100,0), -- 10:55:32
+(@PATH,108,6814.79,-1529.54,356.5034,0,0,0,0,100,0), -- 10:55:33
+(@PATH,109,6812.681,-1522.55,357.1689,0,0,0,0,100,0), -- 10:55:35
+(@PATH,110,6784.553,-1516.297,362.4128,0,0,0,0,100,0); -- 10:55:37
+
+-- Pathing for  Entry: Entry: 'TDB FORMAT' 
+SET @NPC := 152058;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=6684.895,`position_y`=-1454.917,`position_z`=383.6346 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,6684.895,-1454.917,383.6346,0,0,0,0,100,0), -- 10:53:05
+(@PATH,2,6686.636,-1464.036,382.3718,0,0,0,0,100,0), -- 10:53:05
+(@PATH,3,6688.377,-1473.154,381.109,0,0,0,0,100,0), -- 10:53:05
+(@PATH,4,6688.782,-1475.274,380.6954,0,0,0,0,100,0), -- 10:53:05
+(@PATH,5,6690.852,-1486.113,378.6342,0,0,0,0,100,0), -- 10:53:05
+(@PATH,6,6691.787,-1491.011,377.8044,0,0,0,0,100,0), -- 10:53:05
+(@PATH,7,6691.913,-1491.667,377.6761,0,0,0,0,100,0), -- 10:53:05
+(@PATH,8,6691.913,-1491.667,377.6761,0,0,0,0,100,0), -- 10:53:05
+(@PATH,9,6696.476,-1509.763,374.3917,0,0,0,0,100,0), -- 10:53:06
+(@PATH,10,6692.973,-1497.22,376.7173,0,0,0,0,100,0), -- 10:53:28
+(@PATH,11,6691.913,-1491.667,377.6761,0,0,0,0,100,0), -- 10:53:28
+(@PATH,12,6690.852,-1486.113,378.6348,0,0,0,0,100,0), -- 10:53:28
+(@PATH,13,6688.782,-1475.27,380.6958,0,0,0,0,100,0), -- 10:53:28
+(@PATH,14,6688.546,-1474.038,380.9565,0,0,0,0,100,0), -- 10:53:28
+(@PATH,15,6686.636,-1464.036,382.3718,0,0,0,0,100,0); -- 10:53:28
+-- 0x203AF447601CB90000279D000005D0B1 .go 6684.895 -1454.917 383.6346
+
+-- Pathing for  Entry: Entry: 'TDB FORMAT' 
+SET @NPC := 98068;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=6820.013,`position_y`=-1599.169,`position_z`=352.3645 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,6820.013,-1599.169,352.3645,0,0,0,0,100,0), -- 10:52:27
+(@PATH,2,6820.104,-1594.376,352.2,0,0,0,0,100,0), -- 10:52:27
+(@PATH,3,6820.195,-1589.583,352.0355,0,0,0,0,100,0), -- 10:52:27
+(@PATH,4,6820.216,-1588.511,351.9038,0,0,0,0,100,0), -- 10:52:27
+(@PATH,5,6820.249,-1586.775,352.0171,0,0,0,0,100,0), -- 10:52:27
+(@PATH,6,6820.273,-1585.472,352.0441,0,0,0,0,100,0), -- 10:52:27
+(@PATH,7,6820.512,-1572.989,352.7346,0,0,0,0,100,0), -- 10:52:27
+(@PATH,8,6820.563,-1570.255,353.1082,0,0,0,0,100,0), -- 10:52:27
+(@PATH,9,6820.779,-1558.941,353.6869,0,0,0,0,100,0), -- 10:52:27
+(@PATH,10,6820.805,-1557.595,353.732,0,0,0,0,100,0), -- 10:52:27
+(@PATH,11,6820.805,-1557.595,353.732,0,0,0,0,100,0), -- 10:52:27
+(@PATH,12,6817.6,-1573.382,353.1295,0,0,0,0,100,0), -- 10:52:30
+(@PATH,13,6793.767,-1575.178,355.5763,0,0,0,0,100,0), -- 10:52:31
+(@PATH,14,6804.454,-1558.247,354.0426,0,0,0,0,100,0), -- 10:52:34
+(@PATH,15,6823.396,-1567.967,353.5638,0,0,0,0,100,0), -- 10:52:38
+(@PATH,16,6823.622,-1597.669,352.4767,0,0,0,0,100,0), -- 10:52:42
+(@PATH,17,6808.817,-1618.017,351.1837,0,0,0,0,100,0), -- 10:52:44
+(@PATH,18,6822.837,-1599.973,352.402,0,0,0,0,100,0), -- 10:52:50
+(@PATH,19,6830.896,-1576.437,352.2047,0,0,0,0,100,0), -- 10:52:57
+(@PATH,20,6827.16,-1572.276,352.8013,0,0,0,0,100,0), -- 10:52:57
+(@PATH,21,6823.424,-1568.115,353.3978,0,0,0,0,100,0), -- 10:52:57
+(@PATH,22,6819.097,-1563.295,353.3689,0,0,0,0,100,0), -- 10:52:57
+(@PATH,23,6815.957,-1559.798,353.5005,0,0,0,0,100,0), -- 10:52:57
+(@PATH,24,6812.121,-1555.526,353.9822,0,0,0,0,100,0), -- 10:52:57
+(@PATH,25,6809.171,-1552.24,354.3131,0,0,0,0,100,0), -- 10:52:57
+(@PATH,26,6808.941,-1551.984,354.3262,0,0,0,0,100,0), -- 10:52:57
+(@PATH,27,6808.941,-1551.984,354.3262,0,0,0,0,100,0), -- 10:52:57
+(@PATH,28,6793.424,-1572.007,355.5611,0,0,0,0,100,0), -- 10:52:59
+(@PATH,29,6816.494,-1575.348,353.2957,0,0,0,0,100,0), -- 10:53:02
+(@PATH,30,6820.627,-1558.608,353.9123,0,0,0,0,100,0), -- 10:53:06
+(@PATH,31,6820.068,-1589.351,352.332,0,0,0,0,100,0), -- 10:53:07
+(@PATH,32,6819.462,-1617.606,351.7835,0,0,0,0,100,0), -- 10:53:12
+(@PATH,33,6797.732,-1635.693,349.3093,0,0,0,0,100,0), -- 10:53:15
+(@PATH,34,6820.013,-1599.169,352.3645,0,0,0,0,100,0); -- 10:53:28
+
+UPDATE `waypoint_data` SET `move_type`=1 WHERE `id` IN (980680, 980690, 1520580);