diff options
| -rw-r--r-- | sql/updates/world/2015_05_28_02_world.sql | 115 |
1 files changed, 115 insertions, 0 deletions
diff --git a/sql/updates/world/2015_05_28_02_world.sql b/sql/updates/world/2015_05_28_02_world.sql new file mode 100644 index 00000000000..1376088c3e1 --- /dev/null +++ b/sql/updates/world/2015_05_28_02_world.sql @@ -0,0 +1,115 @@ +-- Howling Fjord Initial +SET @NPC := 86760; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1704.93,`position_y`=-6282.997,`position_z`=9.110443 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,1704.93,-6282.997,9.110443,0,0,0,0,100,0), +(@PATH,2,1704.68,-6282.497,9.110443,0,0,0,0,100,0), +(@PATH,3,1702.336,-6278.131,9.618036,0,0,0,0,100,0), +(@PATH,4,1706.836,-6275.631,10.36804,0,0,0,0,100,0), +(@PATH,5,1707.836,-6275.131,10.36804,0,0,0,0,100,0), +(@PATH,6,1709.219,-6274.038,10.71679,0,0,0,0,100,0), +(@PATH,7,1708.469,-6275.288,10.46679,0,0,0,0,100,0), +(@PATH,8,1707.719,-6276.788,10.21679,0,0,0,0,100,0), +(@PATH,9,1706.646,-6278.834,9.859894,0,0,0,0,100,0), +(@PATH,10,1707.896,-6280.584,9.859894,0,0,0,0,100,0), +(@PATH,11,1708.069,-6280.779,10.15218,0,0,0,0,100,0), +(@PATH,12,1708.569,-6281.529,10.15218,0,0,0,0,100,0), +(@PATH,13,1711.569,-6281.779,10.40218,0,0,0,0,100,0), +(@PATH,14,1713.069,-6281.779,10.40218,0,0,0,0,100,0), +(@PATH,15,1713.006,-6282.089,10.39413,0,0,0,0,100,0), +(@PATH,16,1714.506,-6282.339,10.64413,0,0,0,0,100,0), +(@PATH,17,1713.006,-6283.339,10.39413,0,0,0,0,100,0), +(@PATH,18,1708.032,-6286.899,9.245476,0,0,0,0,100,0), +(@PATH,19,1705.282,-6283.399,9.245476,0,0,0,0,100,0), +(@PATH,20,1704.981,-6283.126,9.115644,0,0,0,0,100,0); + +SET @NPC := 118716; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1522.899,`position_y`=-6314.966,`position_z`=6.290161 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,1522.899,-6314.966,6.290161,0,0,0,0,100,0), +(@PATH,2,1524.649,-6315.216,6.040161,0,0,0,0,100,0), +(@PATH,3,1525.149,-6314.216,6.040161,0,0,0,0,100,0), +(@PATH,4,1528.399,-6312.216,6.040161,0,0,0,0,100,0), +(@PATH,5,1529.399,-6311.216,6.040161,0,0,0,0,100,0), +(@PATH,6,1531.399,-6311.216,6.040161,0,0,0,0,100,0), +(@PATH,7,1533.649,-6311.216,6.040161,0,0,0,0,100,0), +(@PATH,8,1537.399,-6309.466,6.290161,0,0,0,0,100,0), +(@PATH,9,1539.649,-6308.966,6.290161,0,0,0,0,100,0), +(@PATH,10,1541.649,-6307.216,6.290161,0,0,0,0,100,0), +(@PATH,11,1545.899,-6306.216,6.290161,0,0,0,0,100,0), +(@PATH,12,1549.899,-6306.216,6.540161,0,0,0,0,100,0), +(@PATH,13,1550.147,-6306.042,6.77546,0,0,0,0,100,0), +(@PATH,14,1551.647,-6305.042,6.77546,0,0,0,0,100,0), +(@PATH,15,1555.897,-6299.292,7.27546,0,0,0,0,100,0), +(@PATH,16,1560.647,-6293.042,7.77546,0,0,0,0,100,0), +(@PATH,17,1571.466,-6279.009,7.792542,0,0,0,0,100,0), +(@PATH,18,1569.216,-6277.009,7.542542,0,0,0,0,100,0), +(@PATH,19,1566.466,-6274.759,6.792542,0,0,0,0,100,0), +(@PATH,20,1563.323,-6271.979,6.153687,0,0,0,0,100,0), +(@PATH,21,1561.034,-6260.083,5.902053,0,0,0,0,100,0), +(@PATH,22,1550.784,-6252.083,6.652053,0,0,0,0,100,0), +(@PATH,23,1544.534,-6247.333,7.152053,0,0,0,0,100,0), +(@PATH,24,1535.034,-6240.083,6.652053,0,0,0,0,100,0), +(@PATH,25,1537.18,-6241.825,6.897589,0,0,0,0,100,0), +(@PATH,26,1553.43,-6254.325,6.147589,0,0,0,0,100,0), +(@PATH,27,1561.12,-6260.274,6.114735,0,0,0,0,100,0), +(@PATH,28,1563.273,-6272.198,6.296275,0,0,0,0,100,0), +(@PATH,29,1566.523,-6274.448,6.796275,0,0,0,0,100,0), +(@PATH,30,1568.523,-6276.448,7.296275,0,0,0,0,100,0), +(@PATH,31,1570.773,-6278.448,7.796275,0,0,0,0,100,0), +(@PATH,32,1570.818,-6278.787,7.928142,0,0,0,0,100,0), +(@PATH,33,1571.568,-6279.287,7.928142,0,0,0,0,100,0), +(@PATH,34,1559.318,-6294.787,7.428142,0,0,0,0,100,0), +(@PATH,35,1555.068,-6300.287,6.928142,0,0,0,0,100,0), +(@PATH,36,1545.231,-6307.126,6.122152,0,0,0,0,100,0), +(@PATH,37,1541.731,-6308.876,6.122152,0,0,0,0,100,0), +(@PATH,38,1541.231,-6309.376,6.122152,0,0,0,0,100,0), +(@PATH,39,1538.231,-6312.876,6.122152,0,0,0,0,100,0), +(@PATH,40,1535.731,-6313.376,5.872152,0,0,0,0,100,0), +(@PATH,41,1524.618,-6315.203,6.112886,0,0,0,0,100,0), +(@PATH,42,1520.618,-6314.953,6.612886,0,0,0,0,100,0), +(@PATH,43,1515.618,-6314.453,7.112886,0,0,0,0,100,0), +(@PATH,44,1519.643,-6314.803,6.643581,0,0,0,0,100,0), +(@PATH,45,1522.643,-6315.053,6.393581,0,0,0,0,100,0); + +SET @NPC := 108487; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1456.961,`position_y`=-6305.669,`position_z`=7.115809 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,1456.961,-6305.669,7.115809,0,0,0,0,100,0), +(@PATH,2,1446.711,-6314.919,6.365809,0,0,0,0,100,0), +(@PATH,3,1433.461,-6326.669,6.115809,0,0,0,0,100,0), +(@PATH,4,1433.146,-6326.916,5.966949,0,0,0,0,100,0), +(@PATH,5,1432.646,-6327.416,5.966949,0,0,0,0,100,0), +(@PATH,6,1417.412,-6345.985,6.104269,3.805819,0,0,0,100,0), +(@PATH,7,1424.511,-6337.054,5.964785,0,0,0,0,100,0), +(@PATH,8,1434.761,-6324.054,6.214785,0,0,0,0,100,0), +(@PATH,9,1434.957,-6323.92,6.428545,0,0,0,0,100,0), +(@PATH,10,1437.457,-6320.92,6.678545,0,0,0,0,100,0), +(@PATH,11,1454.207,-6308.92,6.928545,0,0,0,0,100,0), +(@PATH,12,1466.842,-6300.059,7.55334,0,0,0,0,100,0), +(@PATH,13,1468.342,-6292.059,6.80334,0,0,0,0,100,0), +(@PATH,14,1469.842,-6283.559,6.30334,0,0,0,0,100,0), +(@PATH,15,1471.342,-6276.559,5.80334,0,0,0,0,100,0), +(@PATH,16,1383.172,-6396.671,3.304667,0,0,0,0,100,0), +(@PATH,17,1388.672,-6390.171,4.054667,0,0,0,0,100,0), +(@PATH,18,1473.499,-6265.724,5.148712,0,0,0,0,100,0), +(@PATH,19,1426.144,-6369.358,5.581006,0,0,0,0,100,0), +(@PATH,20,1422.894,-6375.108,5.331006,0,0,0,0,100,0), +(@PATH,21,1422.838,-6368.968,5.859815,0,0,0,0,100,0), +(@PATH,22,1426.253,-6368.985,5.704663,0,0,0,0,100,0), +(@PATH,23,1461.052,-6258.63,5.217323,2.633967,0,0,0,100,0), +(@PATH,24,1460.06,-6270.612,6.09376,0,0,0,0,100,0), +(@PATH,25,1459.31,-6278.612,6.59376,0,0,0,0,100,0), +(@PATH,26,1457.81,-6300.112,7.09376,0,0,0,0,100,0); |