diff options
| -rw-r--r-- | sql/updates/world/master/2021_10_23_03_world_2018_08_30_00_world.sql | 97 |
1 files changed, 97 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_10_23_03_world_2018_08_30_00_world.sql b/sql/updates/world/master/2021_10_23_03_world_2018_08_30_00_world.sql new file mode 100644 index 00000000000..374691c8842 --- /dev/null +++ b/sql/updates/world/master/2021_10_23_03_world_2018_08_30_00_world.sql @@ -0,0 +1,97 @@ +-- +SET @NPC := 100206; +SET @PATH := @NPC*10; +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,8,3662.692,328.2304,338.4197,0,0,0,100,0), +(@PATH,7,3648.806,293.8063,321.0587,0,0,0,100,0), +(@PATH,6,3677.441,213.8859,320.1976,0,0,0,100,0), +(@PATH,5,3615.31,209.5691,324.1698,0,0,0,100,0), +(@PATH,4,3637.643,254.0089,332.7251,0,0,0,100,0), +(@PATH,3,3699.886,260.6509,327.8641,0,0,0,100,0), +(@PATH,2,3720.373,308.941,337.7808,0,0,0,100,0), +(@PATH,1,3691.676,352.0933,342.2254,0,0,0,100,0); + +SET @NPC := 100209; +SET @PATH := @NPC*10; +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,3748.806,293.8063,201.0587,0,0,0,100,0), +(@PATH,2,3777.441,213.8859,200.1976,0,0,0,100,0), +(@PATH,3,3715.31,209.5691,204.1698,0,0,0,100,0), +(@PATH,4,3737.643,254.0089,202.7251,0,0,0,100,0), +(@PATH,5,3799.886,260.6509,207.8641,0,0,0,100,0), +(@PATH,6,3820.373,308.941,207.7808,0,0,0,100,0), +(@PATH,7,3791.676,352.0933,202.2254,0,0,0,100,0), +(@PATH,8,3762.692,328.2304,208.4197,0,0,0,100,0); + +SET @NPC := 99108; +SET @PATH := @NPC*10; +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,18,3506.288,141.7649,169.6936,0,0,0,100,0), +(@PATH,17,3378.177,251.381,169.6936,0,0,0,100,0), +(@PATH,16,3448.559,417.0887,169.6936,0,0,0,100,0), +(@PATH,15,3659.633,429.129,169.6936,0,0,0,100,0), +(@PATH,14,3726.806,236.8274,169.6936,0,0,0,100,0), +(@PATH,13,3554.261,69.58746,169.6936,0,0,0,100,0), +(@PATH,12,3337.373,175.2911,169.6936,0,0,0,100,0), +(@PATH,11,3292.872,421.84,169.6936,0,0,0,100,0), +(@PATH,10,3355.351,609.4697,169.6936,0,0,0,100,0), +(@PATH,9,3233.689,777.6954,207.249,0,0,0,100,0), +(@PATH,8,3049.014,721.6703,224.4991,0,0,0,100,0), +(@PATH,7,3044.268,566.5984,169.6936,0,0,0,100,0), +(@PATH,6,3142.397,481.2142,169.6936,0,0,0,100,0), +(@PATH,5,3328.336,435.8111,169.6936,0,0,0,100,0), +(@PATH,4,3583.232,539.7742,169.6936,0,0,0,100,0), +(@PATH,3,3799.81,460.638,169.6936,0,0,0,100,0), +(@PATH,2,3717.946,244.38,169.6936,0,0,0,100,0), +(@PATH,1,3542.247,134.1484,169.6936,0,0,0,100,0); + +SET @NPC := 100824; +SET @PATH := @NPC*10; +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,14,3559.792,412.912,244.8625,0,0,0,100,0), +(@PATH,13,3625.949,456.7731,244.8625,0,0,0,100,0), +(@PATH,12,3683.285,437.189,244.8625,0,0,0,100,0), +(@PATH,11,3727.341,385.3615,244.8625,0,0,0,100,0), +(@PATH,10,3786.656,388.9702,244.8625,0,0,0,100,0), +(@PATH,9,3811.097,463.1342,244.8625,0,0,0,100,0), +(@PATH,8,3769.007,516.1342,244.8625,0,0,0,100,0), +(@PATH,7,3685.209,493.7117,244.8625,0,0,0,100,0), +(@PATH,6,3589.482,475.7777,244.8625,0,0,0,100,0), +(@PATH,5,3491.84,496.9259,244.8625,0,0,0,100,0), +(@PATH,4,3406.895,485.8197,244.8625,0,0,0,100,0), +(@PATH,3,3370.333,427.0351,244.8625,0,0,0,100,0), +(@PATH,2,3411.417,366.7467,244.8625,0,0,0,100,0), +(@PATH,1,3479.214,376.5652,244.8625,0,0,0,100,0); + +DELETE FROM `waypoint_data` WHERE `id`=1241240; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(1241240, 26, 4024.11, 7168.08, 232.048,0,0,0,100,0), +(1241240, 25, 4012.89, 7180.92, 232.048,0,0,0,100,0), +(1241240, 24, 3994.29, 7197.3, 232.048,0,0,0,100,0), +(1241240, 23, 3962.67, 7211.43, 232.048,0,0,0,100,0), +(1241240, 22, 3928.03, 7221.9, 232.048,0,0,0,100,0), +(1241240, 21, 3903.5, 7236.1, 237.687,0,0,0,100,0), +(1241240, 20, 3882.38, 7232.92, 242.242,0,0,0,100,0), +(1241240, 19, 3858.55, 7224.29, 241.215,0,0,0,100,0), +(1241240, 18, 3844.43, 7205.01, 231.298,0,0,0,100,0), +(1241240, 17, 3844.95, 7183.08, 225.631,0,0,0,100,0), +(1241240, 16, 3853.11, 7151.16, 217.326,0,0,0,100,0), +(1241240, 15, 3870.74, 7131.27, 210.326,0,0,0,100,0), +(1241240, 14, 3896.19, 7103.67, 211.27,0,0,0,100,0), +(1241240, 13, 3918.27, 7080.29, 210.742,0,0,0,100,0), +(1241240, 12, 3937.72, 7052.57, 210.27,0,0,0,100,0), +(1241240, 11, 3952.93, 7028.98, 209.187,0,0,0,100,0), +(1241240, 10, 3971.03, 7002.62, 209.881,0,0,0,100,0), +(1241240, 9, 4004.69, 6989.1, 213.854,0,0,0,100,0), +(1241240, 8, 4041.09, 7000.58, 221.326,0,0,0,100,0), +(1241240, 7, 4071.54, 7033.09, 221.52,0,0,0,100,0), +(1241240, 6, 4086.07, 7065.28, 224.604,0,0,0,100,0), +(1241240, 5, 4097.13, 7102.44, 232.048,0,0,0,100,0), +(1241240, 4, 4095.98, 7138.24, 243.492,0,0,0,100,0), +(1241240, 3, 4083.88, 7155.52, 249.465,0,0,0,100,0), +(1241240, 2, 4058.74, 7162.29, 244.631,0,0,0,100,0), +(1241240, 1, 4038.05, 7165.02, 238.298,0,0,0,100,0); |