[CODE]-- Allerian Stronghold Fixup
– Update position for Erick Nateson
UPDATE creature SET position_x=-2947.306,position_y=3982.602,position_z=0.04192996,orientation=3.493307 WHERE id=21399;
– Pathing for High Elf Ranger Entry: 19000
SET @NPC := 68300;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=-2892.84,position_y=3947.823,position_z=13.40542 WHERE guid=@NPC;
DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NPC,@PATH,258,0, ‘’);
DELETE FROM waypoint_data WHERE id=@PATH;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,-2900.541,3949.979,13.40506,8000,0,0,100,0),
(@PATH,2,-2892.84,3947.823,13.40542,16000,0,0,100,0);
– Pathing for High Elf Ranger Entry: 19000
SET @NPC := 68302;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=-2984.74,position_y=4065.979,position_z=16.47879 WHERE guid=@NPC;
DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NPC,@PATH,258,0, ‘’);
DELETE FROM waypoint_data WHERE id=@PATH;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,-2989.837,4072.737,16.47879,16000,0,0,100,0),
(@PATH,2,-2984.74,4065.979,16.47879,8000,0,0,100,0);
– Pathing for High Elf Ranger Entry: 19000
SET @NPC := 68304;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=-3057.808,position_y=4017.832,position_z=16.17462 WHERE guid=@NPC;
DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NPC,@PATH,258,0, ‘’);
DELETE FROM waypoint_data WHERE id=@PATH;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,-3052.007,4011.99,16.17451,8000,0,0,100,0),
(@PATH,2,-3057.808,4017.832,16.17462,16000,0,0,100,0);
– Pathing for Allerian Horseman Entry: 19003
SET @NPC := 68308;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=-2872.895,position_y=3981.621,position_z=5.133294 WHERE guid=@NPC;
DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NPC,@PATH,1,2404, ‘’);
DELETE FROM waypoint_data WHERE id=@PATH;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,-2862.589,3983.513,4.859164,23000,0,0,100,0),
(@PATH,2,-2877.861,3980.92,4.691218,22000,0,@PATH+1,100,0),
(@PATH,3,-2872.895,3981.621,5.133294,0,0,0,100,0);
DELETE FROM waypoint_scripts WHERE id IN (@PATH+1);
INSERT INTO waypoint_scripts (id,delay,command,datalong,datalong2,o,guid) VALUES
(@PATH+1,1,30,0,0,0.1919862,822);
– Pathing for Allerian Horseman Entry: 19003
SET @NPC := 68309;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=-2965.397,position_y=4084.842,position_z=3.064998 WHERE guid=@NPC;
DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NPC,@PATH,1,2404, ‘’);
DELETE FROM waypoint_data WHERE id=@PATH;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,-2971.184,4089.91,4.059246,0,0,0,100,0),
(@PATH,2,-2974.546,4096.034,4.809246,0,0,0,100,0),
(@PATH,3,-2975.984,4102.904,5.563596,0,0,0,100,0),
(@PATH,4,-2976.84,4109.215,6.188596,0,0,0,100,0),
(@PATH,5,-2977.442,4116.1,6.438596,29000,0,0,100,0),
(@PATH,6,-2976.687,4106.692,6.063596,0,0,0,100,0),
(@PATH,7,-2975.544,4099.55,5.309246,0,0,0,100,0),
(@PATH,8,-2973.493,4091.829,4.309246,0,0,0,100,0),
(@PATH,9,-2969.062,4087.132,3.684246,0,0,0,100,0),
(@PATH,10,-2965.397,4084.842,3.064998,29000,0,@PATH+1,100,0);
DELETE FROM waypoint_scripts WHERE id IN (@PATH+1);
INSERT INTO waypoint_scripts (id,delay,command,datalong,datalong2,o,guid) VALUES
(@PATH+1,1,30,0,0,2.321288,823);
– Pathing for Lemla Hopewing Entry: 19181
SET @NPC := 68626;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=-2981.203,position_y=3879.134,position_z=9.613096 WHERE guid=@NPC;
DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NPC,@PATH,1,0, ‘’);
DELETE FROM waypoint_data WHERE id=@PATH;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,-2992.487,3878.415,9.613096,9000,0,@PATH+1,100,0),
(@PATH,2,-2996.076,3870.127,9.613096,20000,0,0,100,0),
(@PATH,3,-2997.53,3865.11,9.484549,8000,0,0,100,0),
(@PATH,4,-2993.53,3863.55,9.484549,7000,0,0,100,0),
(@PATH,5,-2981.203,3879.134,9.613096,7000,0,0,100,0);
DELETE FROM waypoint_scripts WHERE id IN (@PATH+1);
INSERT INTO waypoint_scripts (id,delay,command,datalong,datalong2,o,guid) VALUES
(@PATH+1,0,30,0,0,1.27409,824);
– Pathing for Allerian Defender Entry: 18999
SET @NPC := 68292;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=-2947.596,position_y=3983.544,position_z=-0.08307004 WHERE guid=@NPC;
DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NPC,@PATH,1,0, ‘’);
DELETE FROM waypoint_data WHERE id=@PATH;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,-2944.827,3979.540,0.041929,0,0,0,100,0),
(@PATH,2,-2942.500,3979.078,-0.20807,25000,0,@PATH+1,100,0),
(@PATH,3,-2939.759,3978.620,-0.425645,0,0,0,100,0),
(@PATH,4,-2936.500,3981.641,-0.33307,0,0,0,100,0),
(@PATH,5,-2935.938,3983.333,-0.33307,29000,0,@PATH+2,100,0),
(@PATH,6,-2935.374,3986.827,-0.594707,0,0,0,100,0),
(@PATH,7,-2937.500,3990.625,-0.58307,0,0,0,100,0),
(@PATH,8,-2940.678,3990.862,-0.70807,23000,0,@PATH+3,100,0),
(@PATH,9,-2943.362,3990.967,-0.597971,0,0,0,100,0),
(@PATH,10,-2947.396,3988.542,-0.20807,0,0,0,100,0),
(@PATH,11,-2947.596,3983.544,-0.08307004,27000,0,@PATH+4,100,0);
DELETE FROM waypoint_scripts WHERE id IN (@PATH+1,@PATH+2,@PATH+3,@PATH+4);
INSERT INTO waypoint_scripts (id,delay,command,datalong,datalong2,o,guid) VALUES
(@PATH+1,1,30,0,0,4.729842,825),
(@PATH+2,1,30,0,0,6.091199,826),
(@PATH+3,1,30,0,0,1.815142,827),
(@PATH+4,1,30,0,0,3.560472,828);
– Pathing for Allerian Defender Entry: 18999
SET @NPC := 68296;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=-3004.182,position_y=4059.2,position_z=16.47264 WHERE guid=@NPC;
DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NPC,@PATH,1,0, ‘’);
DELETE FROM waypoint_data WHERE id=@PATH;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,-3016.535,4050.462,16.47229,0,0,0,100,0),
(@PATH,2,-3022.042,4045.356,17.46166,0,0,0,100,0),
(@PATH,3,-3030.056,4039.186,17.46166,0,0,0,100,0),
(@PATH,4,-3032.783,4036.933,16.18017,0,0,0,100,0),
(@PATH,5,-3044.368,4027.187,16.17542,12000,0,@PATH+1,100,0),
(@PATH,6,-3039.387,4030.45,16.1769,0,0,0,100,0),
(@PATH,7,-3032.683,4037.32,16.1804,0,0,0,100,0),
(@PATH,8,-3025.89,4042.386,17.46166,0,0,0,100,0),
(@PATH,9,-3019.17,4047.763,17.46166,0,0,0,100,0),
(@PATH,10,-3016.295,4049.834,16.47264,0,0,0,100,0),
(@PATH,11,-3004.042,4059.303,16.47269,12000,0,@PATH+2,100,0),
(@PATH,12,-2992.944,4066.828,16.47743,0,0,0,100,0),
(@PATH,13,-2989.875,4062.297,16.47566,0,0,0,100,0),
(@PATH,14,-2999.597,4055.534,10.61597,0,0,0,100,0),
(@PATH,15,-3008.305,4049.41,5.663261,10000,0,@PATH+3,100,0),
(@PATH,16,-3003.988,4052.784,7.524997,0,0,0,100,0),
(@PATH,17,-2989.94,4062.394,16.47567,0,0,0,100,0),
(@PATH,18,-2992.964,4066.766,16.47739,0,0,0,100,0),
(@PATH,19,-3004.182,4059.2,16.47264,12000,0,@PATH+4,100,0);
DELETE FROM waypoint_scripts WHERE id IN (@PATH+1,@PATH+2,@PATH+3,@PATH+4);
INSERT INTO waypoint_scripts (id,delay,command,datalong,datalong2,o,guid) VALUES
(@PATH+1,1,30,0,0,2.373648,829),
(@PATH+2,1,30,0,0,2.164208,830),
(@PATH+3,1,30,0,0,0.3490658,831),
(@PATH+4,1,30,0,0,2.164208,832);
– Pathing for Allerian Defender Entry: 18999
SET @NPC := 68290;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=-2908.265,position_y=3922.398,position_z=13.40726 WHERE guid=@NPC;
DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NPC,@PATH,1,0, ‘’);
DELETE FROM waypoint_data WHERE id=@PATH;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,-2905.809,3933.479,7.323796,0,0,0,100,0),
(@PATH,2,-2903.188,3943.559,2.596507,11000,0,@PATH+1,100,0),
(@PATH,3,-2907.823,3925.806,12.06445,0,0,0,100,0),
(@PATH,4,-2908.265,3922.398,13.40726,0,0,0,100,0),
(@PATH,5,-2903.021,3920.76,13.40938,19000,0,@PATH+2,100,0),
(@PATH,6,-2900.368,3931.102,13.40561,0,0,0,100,0),
(@PATH,7,-2896.775,3945.807,13.40281,29000,0,@PATH+3,100,0),
(@PATH,8,-2898.747,3936.718,13.40411,0,0,0,100,0),
(@PATH,9,-2903.021,3920.76,13.40938,28000,0,@PATH+4,100,0),
(@PATH,10,-2908.265,3922.398,13.40726,0,0,0,100,0);
DELETE FROM waypoint_scripts WHERE id IN (@PATH+1,@PATH+2,@PATH+3,@PATH+4);
INSERT INTO waypoint_scripts (id,delay,command,datalong,datalong2,o,guid) VALUES
(@PATH+1,1,30,0,0,2.80998,833),
(@PATH+2,1,30,0,0,6.021386,834),
(@PATH+3,1,30,0,0,6.161012,835),
(@PATH+4,1,30,0,0,6.003932,836);
– Allerian Defender SAI
SET @ENTRY := 18999; – NPC entry
SET @SPELL1 := 18396; – Dismounting Blast
SET @GUID1 := 68293; – One Defender is scripted
UPDATE creature_template SET AIName=‘SmartAI’, ScriptName=‘’ WHERE entry=@ENTRY; – Set SAI as AI. Remove cpp ScriptName if one exist
DELETE FROM creature_ai_scripts WHERE creature_id=@ENTRY; – Remove EAI if exist
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid IN (@ENTRY,-@GUID1);
DELETE FROM smart_scripts WHERE source_type=9 AND entryorguid IN (@ENTRY100);
INSERT INTO smart_scripts (entryorguid,source_type,id,link,event_type,event_phase_mask,event_chance,event_flags,event_param1,event_param2,event_param3,event_param4,action_type,action_param1,action_param2,action_param3,action_param4,action_param5,action_param6,target_type,target_param1,target_param2,target_param3,target_x,target_y,target_z,target_o,comment) VALUES
(@ENTRY,0,0,0,4,0,100,1,0,0,0,0,11,@SPELL1,0,0,0,0,0,2,0,0,0,0,0,0,0, ‘Allerian Defender - On Aggro - Cast Dismounting Blast on victim’),
(-@GUID1,0,0,0,4,0,100,1,0,0,0,0,11,@SPELL1,0,0,0,0,0,2,0,0,0,0,0,0,0, ‘Allerian Defender - On Aggro - Cast Dismounting Blast on victim’),
(-@GUID1,0,1,0,1,0,100,0,40000,80000,180000,180000,80,@ENTRY100,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Allerian Defender - OOC - Run Script’),
(@ENTRY100,9,0,0,0,0,100,0,0,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,4.642576, ‘Allerian Defender - Script - turn to’),
(@ENTRY100,9,1,0,0,0,100,0,1000,1000,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Allerian Defender - Script - Say text 0’),
(@ENTRY100,9,2,0,0,0,100,0,5000,5000,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,1.466077, ‘Allerian Defender - Script - turn to’),
(@ENTRY100,9,3,0,0,0,100,0,1000,1000,0,0,1,1,0,0,0,0,0,10,68291,@ENTRY,0,0,0,0,0, ‘Allerian Defender - Script - Say text 0’);
– NPC talk text insert from sniff
DELETE FROM creature_text WHERE entry=18999;
INSERT INTO creature_text (entry,groupid,id,text,type,language,probability,emote,duration,sound,comment) VALUES
(18999,0,0, ‘Hey, did you read the bounty on this wanted poster?’,12,7,100,6,0,0, ‘Allerian Defender’),
(18999,0,1, ‘The Bone Wastes! I don’‘t care what’‘s being offered as a reward, I’‘m not going into the Bone Wastes!’,12,7,100,6,0,0, ‘Allerian Defender’),
(18999,0,2, ‘This wanted poster says that they’‘re offering gold to these so-called adventurers to go kill things. Isn’‘t that what we do? I don’‘t think I’‘m being paid enough!’,12,7,100,6,0,0, ‘Allerian Defender’),
(18999,0,3, ‘You want to go do the bounty off of this wanted poster after the shift is over?’,12,7,100,6,0,0, ‘Allerian Defender’),
(18999,0,4, ‘This poster has a bounty on bonelashers. You think I should do that?’,12,7,100,6,0,0, ‘Allerian Defender’),
(18999,1,0, ‘Is that wanted poster all that you’‘re going to talk about today?’,12,7,100,1,0,0, ‘Allerian Defender’),
(18999,1,1, ‘I’‘m up to looking into that bounty after this shift.’,12,7,100,1,0,0, ‘Allerian Defender’),
(18999,1,2, ‘I could use the extra money.’,12,7,100,1,0,0, ‘Allerian Defender’),
(18999,1,3, ‘I don’‘t know and I don’‘t care.’,12,7,100,1,0,0, ‘Allerian Defender’),
(18999,1,4, ‘The bonelashers of the wastes are no laughing matter. I hear they carry diseases!’,12,7,100,1,0,0, ‘Allerian Defender’);
– Remove old crappy script
UPDATE creature SET MovementType=0 WHERE guid IN (68291,68293);
UPDATE creature_addon SET path_id=0 WHERE guid IN (68291,68293);
DELETE FROM waypoint_data WHERE id IN (682910,682930);
DELETE FROM waypoint_scripts WHERE id BETWEEN 170 AND 171;
DELETE FROM db_script_string WHERE entry IN (2000005046,2000005047);
– Pathing for Allerian Peasant Entry: 19147
SET @NPC := 68470;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=-2983.204,position_y=3971.366,position_z=2.162047 WHERE guid=@NPC;
DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NPC,@PATH,1,0, ‘’);
DELETE FROM waypoint_data WHERE id=@PATH;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,-2981.773,3966.45,2.614914,0,0,0,100,0),
(@PATH,2,-2981.005,3960.968,2.989914,0,0,0,100,0),
(@PATH,3,-2981.881,3954.581,2.614914,0,0,0,100,0),
(@PATH,4,-2982.862,3947.319,3.114914,0,0,0,100,0),
(@PATH,5,-2986.684,3945.63,3.239914,0,0,0,100,0),
(@PATH,6,-2986.646,3950.593,3.761735,6000,0,@PATH+1,100,0),
(@PATH,7,-2986.979,3946.354,3.114914,0,0,0,100,0),
(@PATH,8,-2982.707,3945.763,3.364914,0,0,0,100,0),
(@PATH,9,-2980.747,3953.042,2.739914,0,0,0,100,0),
(@PATH,10,-2980.202,3961.786,2.864914,0,0,0,100,0),
(@PATH,11,-2983.204,3971.366,2.162047,4000,0,@PATH+2,100,0);
– F1304ACB07BEF300 .go -2981.773 3966.45 2.614914
DELETE FROM waypoint_scripts WHERE id IN (188,189,@PATH+1,@PATH+2);
INSERT INTO waypoint_scripts (id,delay,command,datalong,datalong2,o,guid) VALUES
(@PATH+1,0,30,0,0,1.413717,837),
(@PATH+1,1,2,83,381,0,838),
(@PATH+2,1,2,83,381,0,839);
– Pathing for Allerian Peasant Entry: 19147
SET @NPC := 68468;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=-2977.357,position_y=4012.234,position_z=1.424733 WHERE guid=@NPC;
DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NPC,@PATH,1,0, ‘’);
DELETE FROM waypoint_data WHERE id=@PATH;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,-2978.323,4006.793,1.174733,0,0,0,100,0),
(@PATH,2,-2973.405,4002.646,1.424733,0,0,0,100,0),
(@PATH,3,-2967.158,4003.521,1.299733,0,0,0,100,0),
(@PATH,4,-2964.591,4008.163,1.124218,0,0,0,100,0),
(@PATH,5,-2966.771,4010.062,1.299733,0,0,0,100,0),
(@PATH,6,-2969.096,4008.951,1.830398,5000,0,@PATH+1,100,0),
(@PATH,7,-2966.771,4010.062,1.299733,0,0,0,100,0),
(@PATH,8,-2964.591,4008.163,1.124218,0,0,0,100,0),
(@PATH,9,-2965.665,4005.173,1.249218,0,0,0,100,0),
(@PATH,10,-2972.548,4002.835,1.424733,0,0,0,100,0),
(@PATH,11,-2977.689,4007.088,1.174733,0,0,0,100,0),
(@PATH,12,-2977.357,4012.234,1.424733,4000,0,@PATH+2,100,0);
DELETE FROM waypoint_scripts WHERE id IN (184,185,@PATH+1,@PATH+2);
INSERT INTO waypoint_scripts (id,delay,command,datalong,datalong2,o,guid) VALUES
(@PATH+1,0,30,0,0,3.839724,840),
(@PATH+1,1,2,83,381,0,841),
(@PATH+2,1,2,83,381,0,842);
– Pathing for Allerian Peasant Entry: 19147
SET @NPC := 68469;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=-2994.862,position_y=4029.217,position_z=1.799733 WHERE guid=@NPC;
DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NPC,@PATH,1,0, ‘’);
DELETE FROM waypoint_data WHERE id=@PATH;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,-2995.501,4024.677,1.674733,0,0,0,100,0),
(@PATH,2,-2991.115,4017.175,1.424733,0,0,0,100,0),
(@PATH,3,-2986.05,4011.426,0.7997329,0,0,0,100,0),
(@PATH,4,-2980.667,4005.888,1.049733,0,0,0,100,0),
(@PATH,5,-2974.792,4001.254,1.424733,0,0,0,100,0),
(@PATH,6,-2969.111,3999.192,1.787047,0,0,0,100,0),
(@PATH,7,-2962.025,4001.197,1.249218,0,0,0,100,0),
(@PATH,8,-2955.767,4003.337,0.8742183,0,0,0,100,0),
(@PATH,9,-2949.479,4006.26,-0.5007817,0,0,0,100,0),
(@PATH,10,-2943.639,4005.681,-0.8757817,0,0,0,100,0),
(@PATH,11,-2938.82,4004.248,-0.8757817,5000,0,@PATH+2,100,0),
(@PATH,12,-2944.247,4006.454,-0.8757817,0,0,0,100,0),
(@PATH,13,-2950.113,4005.459,-0.2507817,0,0,0,100,0),
(@PATH,14,-2958.819,4002.142,1.124218,0,0,0,100,0),
(@PATH,15,-2968.181,3999.478,1.662047,0,0,0,100,0),
(@PATH,16,-2976.377,4001.348,1.424733,0,0,0,100,0),
(@PATH,17,-2982.522,4005.211,1.049733,0,0,0,100,0),
(@PATH,18,-2987.678,4011.322,0.6747329,0,0,0,100,0),
(@PATH,19,-2991.716,4016.418,1.174733,0,0,0,100,0),
(@PATH,20,-2994.956,4023.157,1.549733,0,0,0,100,0),
(@PATH,21,-2994.996,4027.696,1.799733,0,0,0,100,0),
(@PATH,22,-2994.862,4029.217,1.799733,5000,0,@PATH+1,100,0);
DELETE FROM waypoint_scripts WHERE id IN (186,187,@PATH+1,@PATH+2);
INSERT INTO waypoint_scripts (id,delay,command,datalong,datalong2,o,guid) VALUES
(@PATH+1,0,30,0,0,1.570796,843),
(@PATH+1,1,2,83,381,0,844),
(@PATH+2,1,2,83,69,0,845);[/sql]
[/CODE]