diff options
| -rw-r--r-- | sql/updates/world/2015_04_05_07_world_f335.sql | 118 |
1 files changed, 118 insertions, 0 deletions
diff --git a/sql/updates/world/2015_04_05_07_world_f335.sql b/sql/updates/world/2015_04_05_07_world_f335.sql new file mode 100644 index 00000000000..af5fb8a8390 --- /dev/null +++ b/sql/updates/world/2015_04_05_07_world_f335.sql @@ -0,0 +1,118 @@ +-- Pathing for Kor'kron Defender Entry: 19362 'TDB FORMAT' +SET @NPC := 69082; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-2973.116,`position_y`=2556.282,`position_z`=105.8032 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,-2973.116,2556.282,105.8032,0,0,0,0,100,0), -- 13:50:20 +(@PATH,2,-2962.696,2547.778,105.8032,0,0,0,0,100,0), -- 13:50:24 +(@PATH,3,-2953.723,2551.618,105.8032,0,0,0,0,100,0), -- 13:50:29 +(@PATH,4,-2954.077,2563.904,105.8032,0,0,0,0,100,0), -- 13:50:33 +(@PATH,5,-2967.127,2567.316,105.8032,0,0,0,0,100,0), -- 13:50:38 +(@PATH,6,-2968.788,2567.15,105.8032,0,0,0,0,100,0); -- 13:50:43 +-- 0x1C09FC424012E88000001A00019B696A .go -2973.116 2556.282 105.8032 + +-- Pathing for Kor'kron Defender Entry: 19362 'TDB FORMAT' +SET @NPC := 69087; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-3089.103,`position_y`=2508.026,`position_z`=83.78547 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,-3089.103,2508.026,83.78547,0,0,0,0,100,0), -- 13:47:23 +(@PATH,2,-3087.197,2507.859,83.85033,0,0,0,0,100,0), -- 13:47:23 +(@PATH,3,-3081.65,2516.463,84.05411,0,0,0,0,100,0), -- 13:47:26 +(@PATH,4,-3090.028,2524.237,84.04036,0,0,0,0,100,0), -- 13:47:30 +(@PATH,5,-3094.658,2522.566,84.06168,0,0,0,0,100,0), -- 13:47:33 +(@PATH,6,-3096.908,2520.316,83.81168,0,0,0,0,100,0), -- 13:47:33 +(@PATH,7,-3098.908,2518.066,84.06168,0,0,0,0,100,0), -- 13:47:33 +(@PATH,8,-3099.196,2517.561,84.04745,0,0,0,0,100,0), -- 13:47:37 +(@PATH,9,-3097.946,2514.811,84.04745,0,0,0,0,100,0), -- 13:47:37 +(@PATH,10,-3096.946,2512.061,84.04745,0,0,0,0,100,0); -- 13:47:37 +-- 0x1C09FC424012E88000001A00009B6969 .go -3089.103 2508.026 83.78547 + +DELETE FROM `creature_formations` WHERE `leaderGUID`=69091; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES +(69091, 69091, 0, 0, 2), +(69091, 69092, 3, 270, 2); + +-- Pathing for Kor'kron Defender Entry: 19362 'TDB FORMAT' +SET @NPC := 69091; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-3146.969,`position_y`=2563.808,`position_z`=61.37704 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,-3146.969,2563.808,61.37704,0,0,0,0,100,0), -- 13:54:58 +(@PATH,2,-3120.494,2564.844,61.75181,0,0,0,0,100,0), -- 13:54:58 +(@PATH,3,-3120.494,2564.844,61.75181,0,0,0,0,100,0), -- 13:54:58 +(@PATH,4,-3120.175,2565.024,61.98759,0,0,0,0,100,0), -- 13:55:06 +(@PATH,5,-3105.344,2573.74,61.804,0,0,0,0,100,0), -- 13:55:12 +(@PATH,6,-3091.726,2572.44,62.09174,0,0,0,0,100,0), -- 13:55:18 +(@PATH,7,-3088.27,2558.042,62.11543,0,0,0,0,100,0), -- 13:55:24 +(@PATH,8,-3100.597,2545.807,62.11351,0,0,0,0,100,0), -- 13:55:32 +(@PATH,9,-3094.525,2537.95,61.9211,0,0,0,0,100,0), -- 13:55:35 +(@PATH,10,-3079.098,2537.322,62.08109,0,0,0,0,100,0), -- 13:55:43 +(@PATH,11,-3062.423,2502.734,63.59535,0,0,0,0,100,0), -- 13:55:52 +(@PATH,12,-3063.66,2507.985,63.10339,0,0,0,0,100,0), -- 13:56:00 +(@PATH,13,-3065.486,2517.504,62.46205,0,0,0,0,100,0), -- 13:56:04 +(@PATH,14,-3079.187,2537.478,62.18378,0,0,0,0,100,0), -- 13:56:14 +(@PATH,15,-3094.9,2537.977,62.13345,0,0,0,0,100,0), -- 13:56:20 +(@PATH,16,-3100.354,2544.985,61.87681,0,0,0,0,100,0), -- 13:56:30 +(@PATH,17,-3100.963,2545.778,61.87681,0,0,0,0,100,0), -- 13:56:30 +(@PATH,18,-3088.325,2558.04,61.854,0,0,0,0,100,0), -- 13:56:30 +(@PATH,19,-3088.325,2558.04,61.854,0,0,0,0,100,0), -- 13:56:30 +(@PATH,20,-3088.377,2558.176,62.10567,0,0,0,0,100,0), -- 13:56:32 +(@PATH,21,-3091.65,2572.547,62.05435,0,0,0,0,100,0), -- 13:56:38 +(@PATH,22,-3105.591,2573.866,62.01907,0,0,0,0,100,0), -- 13:56:43 +(@PATH,23,-3120.379,2565.042,61.81473,0,0,0,0,100,0), -- 13:56:50 +(@PATH,24,-3120.494,2564.844,61.75181,0,0,0,0,100,0); -- 13:57:02 +-- 0x1C09FC424012E88000001A00039B696A .go -3146.969 2563.808 61.37704 + +-- Remove too many spawns +DELETE FROM `creature` WHERE `guid` IN (74221,74220); + +-- Pathing for Kor'kron Wyvern Rider Entry: 21153 'TDB FORMAT' +SET @NPC := 74219; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-3014.283,`position_y`=2567.434,`position_z`=141.6225 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,17722,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,-3014.283,2567.434,141.6225,0,0,1,0,100,0), -- 13:51:11 +(@PATH,2,-2997.179,2547.184,141.6225,0,0,1,0,100,0), -- 13:51:11 +(@PATH,3,-2975.056,2527.355,141.6225,0,0,1,0,100,0), -- 13:51:11 +(@PATH,4,-2944.816,2526.003,141.6225,0,0,1,0,100,0), -- 13:51:11 +(@PATH,5,-2925.329,2546.514,141.6225,0,0,1,0,100,0), -- 13:51:11 +(@PATH,6,-2919.246,2565.872,141.6225,0,0,1,0,100,0), -- 13:51:11 +(@PATH,7,-2920.081,2589.365,141.6225,0,0,1,0,100,0), -- 13:51:11 +(@PATH,8,-2931.993,2608.762,141.6225,0,0,1,0,100,0), -- 13:51:11 +(@PATH,9,-2955.626,2618.87,141.6225,0,0,1,0,100,0), -- 13:51:11 +(@PATH,10,-2977.497,2619.666,141.6225,0,0,1,0,100,0), -- 13:51:11 +(@PATH,11,-3014.667,2609.543,141.6225,0,0,1,0,100,0), -- 13:51:11 +(@PATH,12,-3055.036,2590.46,141.6225,0,0,1,0,100,0), -- 13:51:11 +(@PATH,13,-3085.538,2571.631,141.6225,0,0,1,0,100,0), -- 13:51:11 +(@PATH,14,-3114.716,2555.922,141.6225,0,0,1,0,100,0), -- 13:51:11 +(@PATH,15,-3143.012,2552.032,141.6225,0,0,1,0,100,0), -- 13:51:11 +(@PATH,16,-3176.688,2560.458,141.6225,0,0,1,0,100,0), -- 13:51:11 +(@PATH,17,-3190.569,2587.816,141.6225,0,0,1,0,100,0), -- 13:51:11 +(@PATH,18,-3187.101,2615.266,141.6225,0,0,1,0,100,0), -- 13:51:11 +(@PATH,19,-3164.5,2634.338,141.6225,0,0,1,0,100,0), -- 13:51:11 +(@PATH,20,-3137.512,2639.929,141.6225,0,0,1,0,100,0), -- 13:51:11 +(@PATH,21,-3099.443,2633.703,141.6225,0,0,1,0,100,0), -- 13:51:11 +(@PATH,22,-3074.344,2622.916,141.6225,0,0,1,0,100,0), -- 13:51:11 +(@PATH,23,-3057.397,2608.769,141.6225,0,0,1,0,100,0), -- 13:51:11 +(@PATH,24,-3045.574,2592.941,140.8448,0,0,1,0,100,0), -- 13:51:11 +(@PATH,25,-3046.095,2591.678,139.9281,0,0,1,0,100,0), -- 13:51:11 +(@PATH,26,-3028.975,2582.002,141.6225,0,0,1,0,100,0); -- 13:51:11 +-- 0x1C09FC424014A84000001A00001B6969 .go -3014.283 2567.434 141.6225 + +DELETE FROM `creature_formations` WHERE `leaderGUID`=69079; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES +(69079, 69079, 0, 0, 2), +(69079, 69081, 3, 270, 2); |