diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2019_05_06_00_world.sql | 357 |
1 files changed, 357 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2019_05_06_00_world.sql b/sql/updates/world/3.3.5/2019_05_06_00_world.sql new file mode 100644 index 00000000000..1d91a60262c --- /dev/null +++ b/sql/updates/world/3.3.5/2019_05_06_00_world.sql @@ -0,0 +1,357 @@ +-- +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (20512,21065) AND `source_type`=0; +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`,`event_param5`,`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 +(20512,0,0,0,4,0,100,0,0,0,0,0,0,36,20480,0,0,0,0,0,1,0,0,0,0,0,0,0,"Tormented Soul - On Aggro - Upadte entry"), +(20512,0,1,0,0,0,100,0,6000,8000,15000,17000,0,11,36153,0,0,0,0,0,2,0,0,0,0,0,0,0,"Tormented Soul - IC - Cast Soulbind"), +(20512,0,2,0,7,0,100,0,0,0,0,0,0,36,20512,0,0,0,0,0,1,0,0,0,0,0,0,0,"Tormented Soul - On evade - Upadte entry"), +(21065,0,0,0,4,0,100,0,0,0,0,0,0,36,20496,0,0,0,0,0,1,0,0,0,0,0,0,0,"Tormented Citizen - On Aggro - Upadte entry"), +(21065,0,1,0,0,0,100,0,1000,2000,2000,4000,0,11,9613,67,0,0,0,0,2,0,0,0,0,0,0,0,"Tormented Citizen - IC - Cast Cast Shadow Bolt"), +(21065,0,2,0,0,0,100,0,9000,13000,120000,124000,0,11,11980,3,0,0,0,0,2,0,0,0,0,0,0,0,"Tormented Citizen - IC - Cast Curse of Weakness"), +(21065,0,3,0,0,0,100,0,9000,16000,19000,29000,0,11,36153,1,0,0,0,0,2,0,0,0,0,0,0,0,"Tormented Citizen - IC - Cast Soulbind"), +(21065,0,4,0,7,0,100,0,0,0,0,0,0,36,21065,0,0,0,0,0,1,0,0,0,0,0,0,0,"Tormented Citizen - On evade - Upadte entry"); +DELETE FROM `spell_scripts` WHERE `id` IN (36153); +INSERT INTO `spell_scripts` (`id`,`effIndex`,`delay`,`command`,`datalong`,`datalong2`,`dataint`,`x`,`y`,`z`,`o`) VALUES +(36153,0,0,15,36141,0,0,0,0,0,0); + +-- Tormented Citizen +DELETE FROM `creature` WHERE `guid` IN (103929); +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 +(103929,21065,530,1,1,0,0,2522.44,2002.22,90.0041,1.902409,300,0,0,6280,2991,0); +DELETE FROM `creature_addon` WHERE `guid` = 103929; +INSERT INTO `creature_addon` (`guid`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(103929,0,8,1,0,""); + +-- Positions corrected +UPDATE `creature` SET `spawndist` = 3, `MovementType` = 1 WHERE `guid` = 74045; +UPDATE `creature` SET `position_x` = 2388.321, `position_y` = 2141.528, `position_z` = 87.105743, `orientation` = 3.455752 WHERE guid = 74037; +UPDATE `creature` SET `position_x` = 2430.300, `position_y` = 2145.886, `position_z` = 97.935562, `spawndist` = 2, `MovementType` = 1 WHERE `guid` = 74038; +UPDATE `creature` SET `position_x` = 2464.245, `position_y` = 2157.971, `position_z` = 94.933777, `spawndist` = 3, `MovementType` = 1 WHERE `guid` = 72627; +UPDATE `creature` SET `position_x` = 2474.984, `position_y` = 2155.038, `position_z` = 88.612022, `spawndist` = 3, `MovementType` = 1 WHERE `guid` = 72626; +UPDATE `creature` SET `position_x` = 2442.074, `position_y` = 2153.026, `position_z` = 91.919273, `spawndist` = 3, `MovementType` = 1 WHERE `guid` = 72618; +UPDATE `creature` SET `position_x` = 2434.966, `position_y` = 2160.352, `position_z` = 99.144302, `spawndist` = 3, `MovementType` = 1 WHERE `guid` = 72613; +UPDATE `creature` SET `position_x` = 2447.445, `position_y` = 2160.947, `position_z` = 100.37898, `spawndist` = 3, `MovementType` = 1 WHERE `guid` = 72619; +UPDATE `creature` SET `position_x` = 2503.256, `position_y` = 2120.726, `position_z` = 96.989487, `spawndist` = 3, `MovementType` = 1 WHERE `guid` = 72623; +UPDATE `creature` SET `position_x` = 2546.189, `position_y` = 2099.742, `position_z` = 99.141655, `spawndist` = 3, `MovementType` = 1 WHERE `guid` = 72630; + +-- Waypoints +-- Tormented Citizen +UPDATE `creature_addon` SET `emote` = 0 WHERE `guid` = 74047; +UPDATE `creature` SET `spawndist` = 0, `MovementType` = 2 WHERE `guid` IN (74039,74042,74043,74047,74048); +DELETE FROM `creature_addon` WHERE `guid` IN (74039,74042,74043,74047,74048); +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`) VALUES +(74039,740390,4097), +(74042,740420,4097), +(74043,740430,4097), +(74047,740470,4097), +(74048,740480,4097); + +DELETE FROM `waypoint_data` WHERE `id` IN (74039,74042,74043,74047,74048, 740390,740420,740430,740470,740480); +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`,`position_z`, `delay`, `action`, `orientation`, `action_chance`) VALUES +-- #74039 +(740390,1,2439.04,2133.35,89.4841,0,0,1.60124,100), +(740390,2,2438.33,2128.56,88.7369,0,0,3.0935,100), +(740390,3,2423.73,2129.26,87.0866,3000,0,3.23723,100), +(740390,4,2438.61,2128.6,88.7765,0,0,1.72534,100), +(740390,5,2438.98,2133.63,89.5049,0,0,1.54734,100), +(740390,6,2439.66,2121.87,87.8017,0,0,4.70464,100), +-- #74042 +(740420,1,2446.32,2070.76,83.7654,0,0,3.1835,100), +(740420,2,2432.35,2072.62,81.7627,0,0,1.90016,100), +(740420,3,2432.14,2077.78,82.7431,0,0,6.23671,100), +(740420,4,2434.8,2077.53,83.2042,30000,493,0.0289189,100), +(740420,5,2418.61,2089.26,83.63,0,0,1.87304,100), +(740420,6,2417.64,2098.43,83.1683,0,0,1.45913,100), +(740420,7,2422.04,2115.11,85.3595,0,0,0.139018,100), +(740420,8,2436.67,2116.47,86.5107,0,0,0.0197499,100), +(740420,9,2457.44,2115.9,88.2659,0,0,0.0433123,100), +(740420,10,2466.42,2116.9,86.9116,0,0,0.0629472,100), +(740420,11,2472.41,2116.24,92.5631,0,0,5.91181,100), +(740420,12,2475.36,2111.49,93.9131,0,0,4.7887,100), +(740420,13,2475.79,2102.42,94.0343,0,0,4.64733,100), +(740420,14,2475.6,2082.95,92.6845,0,0,5.29528,100), +(740420,15,2480.91,2078.7,91.8278,0,0,6.23651,100), +(740420,16,2494.22,2078.27,92.2927,0,0,1.71106,100), +(740420,17,2495.36,2085.08,93.5595,0,0,3.00462,100), +(740420,18,2492.48,2085.7,93.5028,30000,493,2.93786,100), +(740420,19,2494.91,2085.21,93.5568,0,0,4.69715,100), +(740420,20,2494.24,2078.72,92.3316,0,0,6.21061,100), +(740420,21,2515.59,2079.64,93.7808,0,0,1.30108,100), +(740420,22,2515.94,2099.22,95.7622,0,0,2.21764,100), +(740420,23,2513.44,2102.84,95.7428,0,0,2.07784,100), +(740420,24,2513.7,2102.85,95.7354,15000,494,6.25223,100), +(740420,25,2512.79,2107.75,95.3083,0,0,3.10672,100), +(740420,26,2496.74,2107.73,94.8289,0,0,3.14599,100), +(740420,27,2479.55,2110.52,94.0553,0,0,2.49568,100), +(740420,28,2473.74,2116.04,93.4441,0,0,2.70773,100), +(740420,29,2466.63,2117.07,86.9344,0,0,2.96691,100), +(740420,30,2462.65,2107.16,84.7481,0,0,4.44739,100), +(740420,31,2461.14,2098.56,83.9832,0,0,4.54949,100), +(740420,32,2458.37,2087.87,84.6008,0,0,4.44346,100), +(740420,33,2456.4,2080.98,84.0907,0,0,4.07826,100), +(740420,34,2451.4,2075.63,83.5538,0,0,3.98008,100), +-- #74043 +(740430,1,2457.28,2133,91.824,0,0,4.50347,100), +(740430,2,2453.54,2117.57,88.4613,0,0,3.14349,100), +(740430,3,2439.85,2118.2,87.1768,0,0,1.54127,100), +(740430,4,2438.32,2133.25,89.3847,0,0,1.56484,100), +(740430,5,2439.16,2118.06,87.07,0,0,3.07437,100), +(740430,6,2427.58,2117.9,86.2393,0,0,3.04953,100), +(740430,7,2420.42,2119.22,86.0026,0,0,1.96568,100), +(740430,8,2414.51,2133.84,86.8673,0,0,1.76698,100), +(740430,9,2412.31,2154.12,87.4583,0,0,1.64904,100), +(740430,10,2411.92,2170.33,89.3555,0,0,1.51552,100), +(740430,11,2414.74,2185.69,91.8998,0,0,1.40164,100), +(740430,12,2414.85,2189.55,94.2048,0,0,1.59406,100), +(740430,13,2414.31,2193.72,96.9149,0,0,1.75114,100), +(740430,14,2413.96,2199.58,98.0727,0,0,1.44876,100), +(740430,15,2415.6,2209.38,101.867,0,0,1.45182,100), +(740430,16,2417.75,2217.17,105.277,0,0,0.281572,100), +(740430,17,2435.35,2219.05,103.446,0,0,0.148054,100), +(740430,18,2449.94,2220.05,102.119,0,0,6.16813,100), +(740430,19,2459.68,2217.12,102.879,0,0,5.96,100), +(740430,20,2466.1,2215.85,103.909,0,0,6.1053,100), +(740430,21,2478.77,2213.67,103.306,0,0,6.12101,100), +(740430,22,2474.52,2214.42,104.695,0,0,3.00298,100), +(740430,23,2456.97,2217.32,102.67,0,0,2.95585,100), +(740430,24,2443.41,2219.59,102.556,0,0,3.3407,100), +(740430,25,2430.08,2218.59,104.314,0,0,3.22289,100), +(740430,26,2416.84,2217.67,105.572,0,0,4.61305,100), +(740430,27,2414.2,2199.98,98.1094,0,0,4.55807,100), +(740430,28,2413.68,2195.12,97.5769,0,0,4.8683,100), +(740430,29,2414.54,2190.78,95.1419,0,0,4.91542,100), +(740430,30,2414.78,2186.89,92.2944,0,0,4.75442,100), +(740430,31,2413.84,2181.31,90.5563,0,0,4.52273,100), +(740430,32,2411.53,2164.89,88.6199,0,0,4.76227,100), +(740430,33,2412.63,2145.53,86.852,0,0,4.77798,100), +(740430,34,2415.05,2131.83,86.6396,0,0,5.06072,100), +(740430,35,2421.86,2117.74,85.8874,0,0,6.14849,100), +(740430,36,2453.33,2116.51,88.2952,0,0,1.43217,100), +(740430,37,2457.43,2132.71,91.7783,3000,0,1.53427,100), +(740430,38,2467.28,2133.84,93.4507,0,0,1.48715,100), +(740430,39,2467.02,2141.81,93.7895,0,0,1.57354,100), +(740430,40,2466.61,2134.27,93.3425,0,0,3.22288,100), +-- #74047 +(740470,1,2533.5,2104.57,99.937,0,0,3.1442,100), +(740470,2,2531.44,2106.01,99.9192,0,0,2.32896,100), +(740470,3,2529.05,2113.26,99.6688,0,0,1.57114,100), +(740470,4,2532.41,2129.14,98.9163,0,0,1.21143,100), +(740470,5,2535.41,2133.09,99.2317,0,0,0.586752,100), +(740470,6,2539.94,2135.22,99.7302,0,0,0.221542,100), +(740470,7,2544.99,2136.19,99.0847,0,0,6.1403,100), +(740470,8,2546.31,2134.51,99.0799,15000,494,4.65512,100), +(740470,9,2545.17,2136,99.0743,0,0,2.86441,100), +(740470,10,2539.57,2135.5,99.8234,0,0,3.4731,100), +(740470,11,2534.22,2132.84,99.0201,0,0,3.9247,100), +(740470,12,2532.12,2128.26,98.9504,0,0,4.69046,100), +(740470,13,2537.23,2128.39,99.3307,0,0,5.33919,100), +(740470,14,2537.6,2126.92,99.3942,15000,494,4.90644,100), +(740470,15,2536.78,2128.75,99.2915,0,0,2.51176,100), +(740470,16,2533.9,2131.95,98.9914,0,0,3.8815,100), +(740470,17,2530.56,2124.6,99.0497,0,0,4.41949,100), +(740470,18,2529.1,2110.57,99.7599,0,0,4.78469,100), +(740470,19,2530.69,2106.56,99.8482,0,0,5.28578,100), +(740470,20,2533.59,2104.51,99.9318,0,0,0.410801,100), +(740470,21,2535.31,2106.56,99.872,15000,494,0.501907,100), +-- #74048 +(740480,1,2506.51,2167.73,101.241,0,0,1.81801,100), +(740480,2,2505.96,2181.91,103.022,0,0,1.57846,100), +(740480,3,2505.8,2199.13,105.178,0,0,1.43316,100), +(740480,4,2510.48,2203.66,105.558,0,0,0.0861973,100), +(740480,5,2534.11,2205.25,104.846,0,0,6.22409,100), +(740480,6,2551.52,2204.65,104.765,0,0,5.64918,100), +(740480,7,2553.23,2199.38,103.939,0,0,4.81824,100), +(740480,8,2555.32,2181.23,101.081,0,0,4.8418,100), +(740480,9,2555.82,2171.91,99.729,0,0,4.15537,100), +(740480,10,2542.03,2158.35,98.3041,0,0,3.89231,100), +(740480,11,2532.67,2151.78,98.3788,0,0,3.5483,100), +(740480,12,2521.97,2149.79,98.4809,0,0,3.25613,100), +(740480,13,2514.42,2148.76,98.3802,0,0,2.76133,100); + +DELETE FROM `waypoint_scripts` WHERE id IN (493,494); +INSERT INTO `waypoint_scripts` (id, delay, command, datalong, datalong2, dataint,guid) VALUES +(493,2,1,69,1,0,958), +(493,28,1,0,0,0,959), +(494,2,1,69,1,0,960), +(494,13,1,0,0,0,961); + +-- Tormented Soul +DELETE FROM `creature_addon` WHERE `guid` IN (72614,72615,72616,72622,72628,72629,72634,72635); +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`) VALUES +(72614,726140,4097), +(72615,726150,4097), +(72616,726160,4097), +(72622,726220,4097), +(72628,726280,4097), +(72629,726290,4097), +(72634,726340,4097), +(72635,726350,4097); + +UPDATE `creature` SET `spawndist` = 0, `MovementType` = 2 WHERE `guid` IN (72614,72615,72616,72622,72628,72629,72634,72635); +DELETE FROM `waypoint_data` WHERE `id` IN (72614,72615,72616,72622,72628,72629,72634,72635, 726140,726150,726160,726220,726280,726290,726340,726350); +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`,`position_z`, `delay`, `action`, `orientation`, `action_chance`) VALUES +-- #72614 +(726140,1,2436.75,2196.97,99.7081,0,0,1.63847,100), +(726140,2,2436.84,2203.18,101.317,0,0,6.15686,100), +(726140,3,2442.38,2203.2,101.616,0,0,6.26053,100), +(726140,4,2436.73,2203.17,101.311,0,0,4.65989,100), +(726140,5,2436.63,2197.24,99.7699,0,0,0.0244629,100), +(726140,6,2442.33,2196.87,99.9767,0,0,0.0598058,100), +-- #72615 +(726150,1,2434.32,2172.54,93.7415,0,0,1.59087,100), +(726150,2,2434.88,2179.33,95.1214,0,0,6.27969,100), +(726150,3,2452.24,2179.17,96.564,0,0,0.0200694,100), +(726150,4,2467.25,2179.01,97.6956,0,0,0.1,100), +(726150,5,2477.27,2179.22,97.5791,0,0,4.6657,100), +(726150,6,2477.47,2173.08,96.9929,0,0,3.18723,100), +(726150,7,2474.92,2172.73,97.4107,20000,492,3.18723,100), +(726150,8,2477.19,2172.95,97.0338,0,0,1.55752,100), +(726150,9,2476.94,2178.7,97.5706,0,0,3.21864,100), +(726150,10,2459.79,2179.15,97.0766,0,0,3.1362,100), +(726150,11,2434.77,2179.68,95.0949,0,0,4.72977,100), +(726150,12,2434.35,2172.66,93.8022,0,0,6.22134,100), +(726150,13,2436.86,2172.26,93.8461,20000,492,0.0245476,100), +-- #72616 +(726160,1,2412.71,2151.38,87.3565,0,0,1.56252,100), +(726160,2,2413.21,2170.98,89.7684,0,0,1.55074,100), +(726160,3,2413.86,2183.51,90.9161,0,0,6.27727,100), +(726160,4,2438.3,2184.93,95.9124,0,0,1.63295,100), +(726160,5,2437.74,2193.74,98.9794,10000,1012,1.60938,100), +(726160,6,2438.29,2184.6,95.8364,0,0,6.0838,100), +(726160,7,2460.12,2184.91,97.3124,0,0,1.66436,100), +(726160,8,2459.52,2193.73,100.259,10000,1012,1.5976,100), +(726160,9,2459.31,2184.78,97.2321,0,0,3.03173,100), +(726160,10,2437.47,2184.77,95.8168,0,0,3.12913,100), +(726160,11,2413.23,2183.43,90.6811,0,0,4.57819,100), +(726160,12,2412.66,2161.95,88.5402,0,0,4.68814,100), +(726160,13,2412.59,2136.48,86.6716,0,0,4.72741,100), +(726160,14,2413.56,2118.3,84.9958,0,0,4.78239,100), +(726160,15,2414.46,2109.37,82.682,0,0,4.81773,100), +(726160,16,2414.8,2102.04,83.055,0,0,4.69992,100), +(726160,17,2414.78,2097.76,83.1049,0,0,6.04687,100), +(726160,18,2428.88,2094.85,83.479,0,0,6.14504,100), +(726160,19,2432.88,2094.29,84.9508,10000,1012,6.14504,100), +(726160,20,2429.13,2094.72,83.4911,0,0,3.01916,100), +(726160,21,2415.25,2098.01,83.125,0,0,1.70597,100), +(726160,22,2414.63,2108.79,82.5322,0,0,1.64079,100), +(726160,23,2414.32,2112.87,84.1726,0,0,1.65649,100), +(726160,24,2412.71,2130.42,86.2112,0,0,1.63686,100), +-- #72622 +(726220,1,2447.99,2093.83,86.0122,0,0,3.0091,100), +(726220,2,2446.01,2095.03,85.9797,0,0,1.87498,100), +(726220,3,2445.85,2096.43,86.0858,60000,491,1.51684,100), +(726220,4,2445.8,2094.68,85.9351,0,0,5.02443,100), +(726220,5,2447.75,2093.81,85.9938,0,0,6.20173,100), +(726220,6,2453.01,2093.89,86.8637,0,0,6.23707,100), +(726220,7,2453.01,2093.89,86.8637,60000,491,3.0892,100), +-- #72628 +(726280,1,2531.04,2120.16,99.4671,0,0,6.25725,100), +(726280,2,2546.32,2120.13,99.6436,0,0,4.65111,100), +(726280,3,2545.99,2111.41,99.6883,0,0,0.0133351,100), +(726280,4,2549.86,2111.62,99.6386,10000,1012,0.795592,100), +(726280,5,2546.45,2111.87,99.6815,0,0,3.00177,100), +(726280,6,2546.24,2120.1,99.6424,0,0,3.0057,100), +(726280,7,2528.29,2120.03,99.3381,0,0,4.05145,100), +(726280,8,2525.14,2115.61,99.2756,0,0,4.05512,100), +(726280,9,2521.02,2110.8,95.4576,0,0,3.93731,100), +(726280,10,2514.42,2106.98,95.3529,0,0,3.10479,100), +(726280,11,2498.81,2107.2,94.8972,0,0,3.13632,100), +(726280,12,2478.57,2108.69,93.8764,0,0,1.5184,100), +(726280,13,2478.94,2121.71,94.8947,0,0,0.0379267,100), +(726280,14,2493.98,2121.78,95.8205,0,0,6.24257,100), +(726280,15,2496.27,2121.7,97.0164,10000,1012,6.25043,100), +(726280,16,2493.49,2121.85,95.7627,0,0,3.10491,100), +(726280,17,2479.14,2121.58,94.8842,0,0,4.68749,100), +(726280,18,2478.38,2107.94,93.8609,0,0,4.66,100), +(726280,19,2477.75,2095.32,93.7319,0,0,6.26505,100), +(726280,20,2492.68,2095,94.2564,0,0,6.28076,100), +(726280,21,2494.95,2094.92,95.4395,10000,1012,6.24542,100), +(726280,22,2492.77,2094.91,94.2587,0,0,3.14702,100), +(726280,23,2477.95,2094.97,93.6548,0,0,1.69089,100), +(726280,24,2478.64,2108.11,93.8711,0,0,0.125592,100), +(726280,25,2498.18,2107.25,94.8785,0,0,6.23363,100), +(726280,26,2515.6,2107.37,95.2966,0,0,0.386344,100), +(726280,27,2522.03,2108.35,95.7855,0,0,0.186067,100), +(726280,28,2529.04,2109.29,99.7894,0,0,1.37202,100), +-- #72629 +(726290,1,2525.5,2086.6,95.2499,0,0,1.57724,100), +(726290,2,2523.29,2107.4,96.2094,0,0,1.69505,100), +(726290,3,2520.45,2123.84,94.5598,0,0,1.72647,100), +(726290,4,2520.68,2133.64,94.6616,0,0,2.72157,100), +(726290,5,2500.15,2141.89,97.552,0,0,3.10877,100), +(726290,6,2467.13,2140.6,93.7082,0,0,3.16374,100), +(726290,7,2499.35,2141.93,97.6047,0,0,5.98175,100), +(726290,8,2520.22,2133.56,94.6301,0,0,4.81702,100), +(726290,9,2520.4,2119.51,95.0949,0,0,4.82094,100), +(726290,10,2522.02,2112.41,96.4243,0,0,4.9898,100), +(726290,11,2524.98,2100.1,95.5454,0,0,4.77932,100), +(726290,12,2525.93,2066.66,94.0354,0,0,4.74633,100), +(726290,13,2523,2047.59,93.6619,0,0,100,100), +(726290,14,2520.72,2042.02,91.2838,0,0,100,100), +(726290,15,2517.25,2036.88,84.3515,0,0,100,100), +(726290,16,2509.99,2024.69,82.9386,0,0,3.90203,100), +(726290,17,2502.08,2014.02,83.4449,0,0,4.54213,100), +(726290,18,2500.96,1987.06,84.1892,3000,0,4.67564,100), +(726290,19,2501.88,2014.23,83.4438,0,0,0.728231,100), +(726290,20,2512.17,2026.24,82.922,0,0,0.81541,100), +(726290,21,2517.25,2036.08,84.1431,0,0,1.15054,100), +(726290,22,2520.97,2042.64,91.5606,0,0,1.11913,100), +(726290,23,2523.06,2047.93,93.8402,0,0,1.76629,100), +(726290,24,2525.99,2064.02,93.8939,0,0,1.68642,100), +-- #72634 +(726340,1,2533.17,2012.66,87.9193,0,0,1.48424,100), +(726340,2,2532.61,2032.45,87.9193,0,0,3.05033,100), +(726340,3,2528.43,2033.13,87.5409,0,0,3.02677,100), +(726340,4,2524.53,2033.64,84.8178,0,0,3.0032,100), +(726340,5,2515.95,2032.91,83.5486,0,0,3.20741,100), +(726340,6,2499.78,2033.08,85.5091,0,0,3.12887,100), +(726340,7,2492.28,2033.02,87.8146,0,0,3.12887,100), +(726340,8,2482.62,2033.21,88.1512,60000,491,3.12494,100), +(726340,9,2495.76,2033.07,87.1436,0,0,0.0186865,100), +(726340,10,2508.53,2033.14,84.1071,0,0,6.28224,100), +(726340,11,2520.8,2031.93,84.0195,0,0,6.19899,100), +(726340,12,2528.14,2032.24,87.9203,0,0,0.703552,100), +(726340,13,2534.27,2037.41,87.9164,0,0,0.156133,100), +(726340,14,2544.52,2036.92,86.8192,0,0,4.63997,100), +(726340,15,2544.6,2030.72,87.857,20000,492,4.73109,100), +(726340,16,2544.37,2033.01,87.5989,0,0,3.17207,100), +(726340,17,2533.27,2032.52,87.9195,0,0,4.58657,100), +(726340,18,2533.02,2012.87,87.9195,0,0,0.0422802,100), +(726340,19,2534.83,2012.61,87.9195,20000,492,0.0501342,100), +-- #72635 +(726350,1,2532.01,2021.25,87.9187,0,0,2.44112,100), +(726350,2,2521.88,2021.34,87.9187,0,0,3.70954,100), +(726350,3,2517.19,2015.81,87.9203,0,0,4.47765,100), +(726350,4,2517.36,2011.44,87.9203,60000,491,4.91727,100), +(726350,5,2513.73,2015.33,87.4932,0,0,2.28226,100), +(726350,6,2511.02,2018.61,84.6765,0,0,2.2587,100), +(726350,7,2509.1,2021.69,83.1338,0,0,2.17231,100), +(726350,8,2501.5,2032.98,85.0412,0,0,3.09515,100), +(726350,9,2495.17,2032.85,87.2793,0,0,3.16191,100), +(726350,10,2485.83,2033.72,88.1147,0,0,2.14325,100), +(726350,11,2482.55,2038.21,87.8668,0,0,2.93414,100), +(726350,12,2472.84,2038.22,87.4929,0,0,2.23592,100), +(726350,13,2471.83,2040.22,87.3049,60000,491,1.97988,100), +(726350,14,2473.67,2032.95,87.93,0,0,5.77728,100), +(726350,15,2477.48,2030.8,88.2415,0,0,5.21965,100), +(726350,16,2479.36,2026.94,88.5964,0,0,6.24145,100), +(726350,17,2482.81,2027.23,88.5894,0,0,0.863037,100), +(726350,18,2486.73,2032.99,88.1494,0,0,0.143237,100), +(726350,19,2496.99,2032.6,86.6247,0,0,0.0183592,100), +(726350,20,2512.83,2029.86,83.4895,0,0,0.298746,100), +(726350,21,2519.53,2030.15,84.2282,0,0,0.0446923,100), +(726350,22,2525.78,2029.99,87.7562,0,0,0.0132763,100), +(726350,23,2531.72,2030.08,87.9196,0,0,4.70604,100), +(726350,24,2531.65,2025.04,87.9202,0,0,4.79437,100), +(726350,25,2533,2010.18,87.9202,0,0,6.20337,100), +(726350,26,2540.36,2009.73,87.9132,0,0,4.89647,100), +(726350,27,2540.41,2004.17,87.9166,0,0,4.83678,100), +(726350,28,2540.41,2004.17,87.9166,60000,491,5.61903,100), +(726350,29,2540.22,2009.61,87.9128,0,0,3.04502,100), +(726350,30,2533.15,2010.18,87.9191,0,0,1.69492,100); + +DELETE FROM `waypoint_scripts` WHERE id IN (491,492); +INSERT INTO `waypoint_scripts` (id, delay, command, datalong, datalong2, dataint,guid) VALUES +(491,3,1,69,1,0,954), +(491,57,1,0,0,0,955), +(492,3,1,69,1,0,956), +(492,17,1,0,0,0,957); |