DB/waypoints: Pathing for Frigid Proto-Drakes

1 files changed, 256 insertions, 0 deletions

diff --git a/sql/updates/world/2012_06_02_08_world_waypoints.sql b/sql/updates/world/2012_06_02_08_world_waypoints.sql
new file mode 100644
index 00000000000..60b936a7f72
--- /dev/null
+++ b/sql/updates/world/2012_06_02_08_world_waypoints.sql
@@ -0,0 +1,256 @@
+-- Remove Brunnhildar Drakerider Spawns
+DELETE FROM `creature` WHERE `guid` IN (97922,97923);
+DELETE FROM `creature_addon` WHERE `guid` IN (97922,97923);
+
+-- Pathing for Frigid Proto-Drake
+SET @NPC := 97991;
+SET @PATH := @NPC*10;  
+DELETE FROM `creature` WHERE `guid`=@NPC;
+INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`) VALUES 
+(@NPC,29460,571,1,1,0,0,7138.47,-2166.756,798.66,1.91463,120,0,0,1,0,2);
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes1`) VALUES (@NPC,@PATH,50331648);
+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,7138.47,-2166.756,798.66,0,0,0,100,0),
+(@PATH,2,7137.982,-2206.665,805.7148,0,0,0,100,0),
+(@PATH,3,7161.205,-2258.269,804.6854,0,0,0,100,0),
+(@PATH,4,7192.208,-2308.688,803.2413,0,0,0,100,0),
+(@PATH,5,7234.745,-2344.972,803.0753,0,0,0,100,0),
+(@PATH,6,7274.754,-2385.471,791.2989,0,0,0,100,0),
+(@PATH,7,7279.244,-2432.098,788.5766,0,0,0,100,0),
+(@PATH,8,7287.073,-2487.045,787.2991,0,0,0,100,0),
+(@PATH,9,7313.09,-2514.464,787.2991,0,0,0,100,0),
+(@PATH,10,7371.793,-2525.992,787.2991,0,0,0,100,0),
+(@PATH,11,7408.351,-2485.411,787.2991,0,0,0,100,0),
+(@PATH,12,7420.525,-2414.975,787.2991,0,0,0,100,0),
+(@PATH,13,7408.521,-2337.311,787.2991,0,0,0,100,0),
+(@PATH,14,7349.138,-2289.91,787.2991,0,0,0,100,0),
+(@PATH,15,7279.763,-2277.351,787.2991,0,0,0,100,0),
+(@PATH,16,7206.917,-2239.987,787.2991,0,0,0,100,0),
+(@PATH,17,7179.584,-2203.606,787.2991,0,0,0,100,0),
+(@PATH,18,7160.147,-2169.823,787.2991,0,0,0,100,0),
+(@PATH,19,7134.891,-2128.46,787.2991,0,0,0,100,0),
+(@PATH,20,7122.673,-2069.597,787.2991,0,0,0,100,0),
+(@PATH,21,7104.583,-2041.353,787.2991,0,0,0,100,0),
+(@PATH,22,7060.176,-2045.798,787.2991,0,0,0,100,0),
+(@PATH,23,7021.334,-2089.535,787.2991,0,0,0,100,0),
+(@PATH,24,7021.683,-2123.516,787.2991,0,0,0,100,0),
+(@PATH,25,7055.512,-2136.21,787.2991,0,0,0,100,0),
+(@PATH,26,7096.39,-2139.124,787.2991,0,0,0,100,0),
+(@PATH,27,7118.583,-2150.815,787.2991,0,0,0,100,0);
+
+SET @NPC := 97992;
+SET @PATH := @NPC*10;  
+DELETE FROM `creature` WHERE `guid`=@NPC;
+INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`) VALUES 
+(@NPC,29460,571,1,1,0,0,7368.505,-2205.943,843.7172,1.91463,120,0,0,1,0,2);
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes1`) VALUES (@NPC,@PATH,50331648);
+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,7368.505,-2205.943,843.7172,0,0,0,100,0),
+(@PATH,2,7368.349,-2206.931,843.7172,0,0,0,100,0),
+(@PATH,3,7370.282,-2210.494,847.4096,0,0,0,100,0),
+(@PATH,4,7355.707,-2244.806,829.2711,0,0,0,100,0),
+(@PATH,5,7331.636,-2263.269,812.4655,0,0,0,100,0),
+(@PATH,6,7302.835,-2255.226,790.5214,0,0,0,100,0);
+
+SET @NPC := 98025;
+SET @PATH := @NPC*10;  
+DELETE FROM `creature` WHERE `guid`=@NPC;
+INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`) VALUES 
+(@NPC,29460,571,1,1,0,0,7139.471,-2158.159,806.128,1.91463,120,0,0,1,0,2);
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes1`) VALUES (@NPC,@PATH,50331648);
+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,7139.471,-2158.159,806.128,0,0,0,100,0),
+(@PATH,2,7174.096,-2197.912,799.7397,0,0,0,100,0),
+(@PATH,3,7207.944,-2233.231,799.7397,0,0,0,100,0),
+(@PATH,4,7270.875,-2270.113,799.7397,0,0,0,100,0),
+(@PATH,5,7326.976,-2290.712,799.7397,0,0,0,100,0),
+(@PATH,6,7398.354,-2307.759,858.0721,0,0,0,100,0),
+(@PATH,7,7492.969,-2338.019,913.3103,0,0,0,100,0),
+(@PATH,8,7516.403,-2341.424,929.4471,0,0,0,100,0),
+(@PATH,9,7533.13,-2350.423,930.8928,0,0,0,100,0),
+(@PATH,10,7542.375,-2369.76,924.0596,0,0,0,100,0),
+(@PATH,11,7540.795,-2388.042,900.4768,0,0,0,100,0),
+(@PATH,12,7520.372,-2426.235,856.811,0,0,0,100,0),
+(@PATH,13,7490.571,-2460.841,825.395,0,0,0,100,0),
+(@PATH,14,7433.976,-2476.923,806.3961,0,0,0,100,0),
+(@PATH,15,7363.505,-2480.186,799.9239,0,0,0,100,0),
+(@PATH,16,7322.222,-2455.095,799.9239,0,0,0,100,0),
+(@PATH,17,7296.217,-2406.509,799.9239,0,0,0,100,0),
+(@PATH,18,7250.124,-2348.116,796.2858,0,0,0,100,0),
+(@PATH,19,7199.447,-2308.098,791.8962,0,0,0,100,0),
+(@PATH,20,7165.64,-2260.306,794.3141,0,0,0,100,0),
+(@PATH,21,7126.358,-2218.408,792.2291,0,0,0,100,0),
+(@PATH,22,7101.756,-2200.451,797.7845,0,0,0,100,0),
+(@PATH,23,7071.807,-2185.584,808.8121,0,0,0,100,0),
+(@PATH,24,7043.711,-2175.546,825.1454,0,0,0,100,0),
+(@PATH,25,7016.538,-2153.01,825.1454,0,0,0,100,0),
+(@PATH,26,7010.379,-2118.062,825.1454,0,0,0,100,0),
+(@PATH,27,7031.11,-2081.328,825.1454,0,0,0,100,0),
+(@PATH,28,7067.889,-2058.581,825.1454,0,0,0,100,0),
+(@PATH,29,7109.583,-2060.563,825.1454,0,0,0,100,0),
+(@PATH,30,7129.145,-2089.288,825.1454,0,0,0,100,0),
+(@PATH,31,7133.573,-2119.781,811.7565,0,0,0,100,0);
+
+SET @NPC := 98026;
+SET @PATH := @NPC*10;  
+DELETE FROM `creature` WHERE `guid`=@NPC;
+INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`) VALUES 
+(@NPC,29460,571,1,1,0,0,7111.189,-2126.364,809.0059,1.91463,120,0,0,1,0,2);
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes1`) VALUES (@NPC,@PATH,50331648);
+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,7111.189,-2126.364,809.0059,0,0,0,100,0),
+(@PATH,2,7112.182,-2126.484,809.0059,0,0,0,100,0),
+(@PATH,3,7148.073,-2168.365,801.1813,0,0,0,100,0),
+(@PATH,4,7179.175,-2226.085,785.2094,0,0,0,100,0),
+(@PATH,5,7223.947,-2286.013,782.9871,0,0,0,100,0),
+(@PATH,6,7299.682,-2304.846,784.2374,0,0,0,100,0),
+(@PATH,7,7379.366,-2316.926,796.4037,0,0,0,100,0),
+(@PATH,8,7415.913,-2373.976,798.6256,0,0,0,100,0),
+(@PATH,9,7412.545,-2436.63,796.9036,0,0,0,100,0),
+(@PATH,10,7357.321,-2469.256,801.1813,0,0,0,100,0),
+(@PATH,11,7324.498,-2460.21,801.1813,0,0,0,100,0),
+(@PATH,12,7299.582,-2416.601,796.1536,0,0,0,100,0),
+(@PATH,13,7311.903,-2374.752,787.5981,0,0,0,100,0),
+(@PATH,14,7312.228,-2301.718,778.1539,0,0,0,100,0),
+(@PATH,15,7277.36,-2261.898,778.1539,0,0,0,100,0),
+(@PATH,16,7223.409,-2240.653,778.1539,0,0,0,100,0),
+(@PATH,17,7146.638,-2228.195,778.1539,0,0,0,100,0),
+(@PATH,18,7063.594,-2217.223,802.7003,0,0,0,100,0),
+(@PATH,19,7018.785,-2211.49,814.2276,0,0,0,100,0),
+(@PATH,20,6971.935,-2170.058,834.7831,0,0,0,100,0),
+(@PATH,21,6970.746,-2108.841,872.616,0,0,0,100,0),
+(@PATH,22,6991.211,-2071.003,882.1439,0,0,0,100,0),
+(@PATH,23,7035.753,-2048.345,872.0881,0,0,0,100,0),
+(@PATH,24,7091.613,-2053.953,852.9218,0,0,0,100,0),
+(@PATH,25,7120.529,-2096.423,830.6169,0,0,0,100,0),
+(@PATH,26,7139.663,-2146.639,806.1729,0,0,0,100,0);
+
+SET @NPC := 98027;
+SET @PATH := @NPC*10;  
+DELETE FROM `creature` WHERE `guid`=@NPC;
+INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`) VALUES 
+(@NPC,29460,571,1,1,0,0,7325.084,-2259.102,789.8701,1.91463,120,0,0,1,0,2);
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes1`) VALUES (@NPC,@PATH,50331648);
+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,7325.084,-2259.102,789.8701,0,0,0,100,0),
+(@PATH,2,7324.438,-2258.339,789.8701,0,0,0,100,0),
+(@PATH,3,7303.33,-2256.314,797.6193,0,0,0,100,0),
+(@PATH,4,7267.175,-2247.528,794.2031,0,0,0,100,0),
+(@PATH,5,7214.491,-2258.535,801.3693,0,0,0,100,0),
+(@PATH,6,7172.046,-2253.232,805.3967,0,0,0,100,0),
+(@PATH,7,7131.951,-2229.063,811.4247,0,0,0,100,0),
+(@PATH,8,7094.743,-2214.779,814.9513,0,0,0,100,0),
+(@PATH,9,7037.284,-2220.873,816.9806,0,0,0,100,0),
+(@PATH,10,7001.552,-2206.268,815.3693,0,0,0,100,0),
+(@PATH,11,6987.444,-2184.004,809.9804,0,0,0,100,0),
+(@PATH,12,6978.424,-2132.038,810.9526,0,0,0,100,0),
+(@PATH,13,7004.174,-2094.79,805.2302,0,0,0,100,0),
+(@PATH,14,7061.313,-2081.083,794.8694,0,0,0,100,0),
+(@PATH,15,7106.668,-2099.052,785.4243,0,0,0,100,0),
+(@PATH,16,7138.966,-2157.915,783.5634,0,0,0,100,0),
+(@PATH,17,7148.676,-2194.204,790.7584,0,0,0,100,0),
+(@PATH,18,7161.454,-2233.868,796.2581,0,0,0,100,0),
+(@PATH,19,7177.563,-2267.763,796.2305,0,0,0,100,0),
+(@PATH,20,7208.712,-2314.157,792.0358,0,0,0,100,0),
+(@PATH,21,7273.909,-2345.979,783.6465,0,0,0,100,0),
+(@PATH,22,7368.229,-2329.532,782.4529,0,0,0,100,0),
+(@PATH,23,7446.557,-2387.249,792.8419,0,0,0,100,0),
+(@PATH,24,7464.88,-2459.651,777.7035,0,0,0,100,0),
+(@PATH,25,7426.007,-2508.458,777.7035,0,0,0,100,0),
+(@PATH,26,7367.409,-2517.811,777.7035,0,0,0,100,0),
+(@PATH,27,7315.153,-2476.871,777.7035,0,0,0,100,0),
+(@PATH,28,7324.871,-2419.788,787.8976,0,0,0,100,0),
+(@PATH,29,7343.577,-2356.954,789.7312,0,0,0,100,0),
+(@PATH,30,7355.857,-2295.399,785.1757,0,0,0,100,0),
+(@PATH,31,7324.438,-2258.339,789.8701,0,0,0,100,0);
+
+SET @NPC := 97995;
+SET @PATH := @NPC*10;  
+DELETE FROM `creature` WHERE `guid`=@NPC;
+INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`) VALUES 
+(@NPC,29460,571,1,1,0,0,7303.549,-2258.753,788.369,1.91463,120,0,0,1,0,2);
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes1`) VALUES (@NPC,@PATH,50331648);
+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,7303.549,-2258.753,788.369,0,0,0,100,0),
+(@PATH,2,7302.752,-2258.148,788.369,0,0,0,100,0),
+(@PATH,3,7289.952,-2257.048,791.1975,0,0,0,100,0),
+(@PATH,4,7258.658,-2235.294,791.1975,0,0,0,100,0),
+(@PATH,5,7210.906,-2223.988,791.1975,0,0,0,100,0),
+(@PATH,6,7167.373,-2232.4,791.1975,0,0,0,100,0),
+(@PATH,7,7124.27,-2224.081,791.1975,0,0,0,100,0),
+(@PATH,8,7086.96,-2192.181,791.1975,0,0,0,100,0),
+(@PATH,9,7087.704,-2145.958,791.1975,0,0,0,100,0),
+(@PATH,10,7127.069,-2118.094,791.1975,0,0,0,100,0),
+(@PATH,11,7164.674,-2135.464,793.8918,0,0,0,100,0),
+(@PATH,12,7182.364,-2192.978,791.1975,0,0,0,100,0),
+(@PATH,13,7182.774,-2277.733,805.3915,0,0,0,100,0),
+(@PATH,14,7229.842,-2333.471,805.3915,0,0,0,100,0),
+(@PATH,15,7308.383,-2345.623,805.3915,0,0,0,100,0),
+(@PATH,16,7376.758,-2335.746,805.3915,0,0,0,100,0),
+(@PATH,17,7427.352,-2382.805,805.3915,0,0,0,100,0),
+(@PATH,18,7432.168,-2464.934,805.3915,0,0,0,100,0),
+(@PATH,19,7370.238,-2513.568,805.3915,0,0,0,100,0),
+(@PATH,20,7321.452,-2503.377,805.3915,0,0,0,100,0),
+(@PATH,21,7291.445,-2456.148,800.0583,0,0,0,100,0),
+(@PATH,22,7306.158,-2414.508,794.0861,0,0,0,100,0),
+(@PATH,23,7331.817,-2357.911,790.9471,0,0,0,100,0),
+(@PATH,24,7331.193,-2296.791,790.9471,0,0,0,100,0),
+(@PATH,25,7305.381,-2260.717,790.9471,0,0,0,100,0);
+
+SET @NPC := 98028;
+SET @PATH := @NPC*10;  
+DELETE FROM `creature` WHERE `guid`=@NPC;
+INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`) VALUES 
+(@NPC,29460,571,1,1,0,0,7133.43,-2118.791,811.7565,1.91463,120,0,0,1,0,2);
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes1`) VALUES (@NPC,@PATH,50331648);
+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,7133.43,-2118.791,811.7565,0,0,0,100,0),
+(@PATH,2,7133.573,-2119.781,811.7565,0,0,0,100,0),
+(@PATH,3,7119.039,-2128.233,806.786,0,0,0,100,0),
+(@PATH,4,7129.032,-2143.773,806.786,0,0,0,100,0),
+(@PATH,5,7131.506,-2163.489,806.786,0,0,0,100,0),
+(@PATH,6,7125.905,-2198.75,806.786,0,0,0,100,0),
+(@PATH,7,7133.987,-2234.428,806.786,0,0,0,100,0),
+(@PATH,8,7170.914,-2282.005,806.786,0,0,0,100,0),
+(@PATH,9,7236.963,-2311.655,806.786,0,0,0,100,0),
+(@PATH,10,7279.574,-2311.321,806.786,0,0,0,100,0),
+(@PATH,11,7320.696,-2339.429,806.786,0,0,0,100,0),
+(@PATH,12,7334.366,-2379.159,806.786,0,0,0,100,0),
+(@PATH,13,7321.908,-2419.639,819.0636,0,0,0,100,0),
+(@PATH,14,7294.696,-2461.332,841.8126,0,0,0,100,0),
+(@PATH,15,7277.729,-2494.843,861.1736,0,0,0,100,0),
+(@PATH,16,7245.194,-2587.365,911.9794,0,0,0,100,0),
+(@PATH,17,7235.221,-2664.447,911.9794,0,0,0,100,0),
+(@PATH,18,7267.375,-2723.981,911.9794,0,0,0,100,0),
+(@PATH,19,7364.385,-2762.505,956.4234,0,0,0,100,0),
+(@PATH,20,7439.538,-2775.097,990.1998,0,0,0,100,0),
+(@PATH,21,7538.208,-2706.511,1012.088,0,0,0,100,0),
+(@PATH,22,7575.65,-2563.215,985.2554,0,0,0,100,0),
+(@PATH,23,7521.32,-2414.249,933.5882,0,0,0,100,0),
+(@PATH,24,7438.214,-2348.566,884.2285,0,0,0,100,0),
+(@PATH,25,7349.768,-2296.647,830.8118,0,0,0,100,0),
+(@PATH,26,7288.613,-2264.192,802.2007,0,0,0,100,0),
+(@PATH,27,7231.5,-2246.911,802.2007,0,0,0,100,0),
+(@PATH,28,7160.201,-2264.728,829.4783,0,0,0,100,0),
+(@PATH,29,7110.628,-2294.354,859.3112,0,0,0,100,0),
+(@PATH,30,7061.597,-2313.25,865.6166,0,0,0,100,0),
+(@PATH,31,7008.405,-2309.793,865.6166,0,0,0,100,0),
+(@PATH,32,6977.473,-2277.743,865.6166,0,0,0,100,0),
+(@PATH,33,6976.358,-2204.402,846.9778,0,0,0,100,0),
+(@PATH,34,7022.063,-2142,828.7004,0,0,0,100,0),
+(@PATH,35,7070.062,-2121.369,822.228,0,0,0,100,0),
+(@PATH,36,7112.182,-2126.484,809.0059,0,0,0,100,0);