diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2018_04_04_00_world_335.sql | 181 |
1 files changed, 181 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2018_04_04_00_world_335.sql b/sql/updates/world/3.3.5/2018_04_04_00_world_335.sql new file mode 100644 index 00000000000..d01974aea4c --- /dev/null +++ b/sql/updates/world/3.3.5/2018_04_04_00_world_335.sql @@ -0,0 +1,181 @@ +-- Add pool for Deathspeaker Selendre +SET @GUID := 64986; +SET @POOL := 386; +DELETE FROM `creature` WHERE `guid`=@GUID; +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES +(@GUID,10827,0,0,0,1,1,0,0,2519.05,-3694.31,180.13,5.47616,72000,0,0,2550,5206,2,0,0,0,"",0); + +DELETE FROM `pool_template` WHERE `entry`=@POOL; +INSERT INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES +(@POOL,1,"Deathspeaker Selendre"); + +DELETE FROM `pool_creature` WHERE `pool_entry`=@POOL; +INSERT INTO `pool_creature` (`guid`, `pool_entry`, `chance`, `description`) VALUES +(@GUID,@POOL,0,"Deathspeaker Selendre (10827) - Spawn 1"), +(86755,@POOL,0,"Deathspeaker Selendre (10827) - Spawn 2"); + +-- Add pathing for Deathspeaker Selendre (Spawn 1) +DELETE FROM `creature_addon` WHERE `guid`=@GUID; +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(@GUID,@GUID*10,0,0,1,0,""); + +DELETE FROM `waypoint_data` WHERE `id`=@GUID*10; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(@GUID*10,1,2519.05,-3694.31,180.13,0,0,0,0,100,0), +(@GUID*10,2,2528.03,-3700.27,179.738,0,0,0,0,100,0), +(@GUID*10,3,2534.58,-3716.14,179.306,0,0,0,0,100,0), +(@GUID*10,4,2538.02,-3734.97,178.969,0,0,0,0,100,0), +(@GUID*10,5,2536.86,-3749.52,178.694,0,0,0,0,100,0), +(@GUID*10,6,2531.39,-3761.01,179.057,0,0,0,0,100,0), +(@GUID*10,7,2518.99,-3777.55,177.511,0,0,0,0,100,0), +(@GUID*10,8,2525.06,-3781.92,177.836,0,0,0,0,100,0), +(@GUID*10,9,2530.46,-3785.8,181.689,0,0,0,0,100,0), +(@GUID*10,10,2537.83,-3791.9,185.059,0,0,0,0,100,0), +(@GUID*10,11,2556.67,-3806.27,185.059,0,0,0,0,100,0), +(@GUID*10,12,2552.53,-3811.77,185.059,0,0,0,0,100,0), +(@GUID*10,13,2554.51,-3818.25,182.059,0,0,0,0,100,0), +(@GUID*10,14,2561.12,-3822.2,182.059,0,0,0,0,100,0), +(@GUID*10,15,2568.87,-3821.11,182.059,0,0,0,0,100,0), +(@GUID*10,16,2575.12,-3811.81,182.059,0,0,0,0,100,0), +(@GUID*10,17,2572.09,-3803.6,182.059,0,0,0,0,100,0), +(@GUID*10,18,2565.51,-3800.57,182.244,0,0,0,0,100,0), +(@GUID*10,19,2560.86,-3801,185.058,0,0,0,0,100,0), +(@GUID*10,20,2557.16,-3806.54,185.058,0,0,0,0,100,0), +(@GUID*10,21,2537.49,-3792.32,185.058,0,0,0,0,100,0), +(@GUID*10,22,2529.21,-3786.65,181.345,0,0,0,0,100,0), +(@GUID*10,23,2522.47,-3782.02,177.509,0,0,0,0,100,0), +(@GUID*10,24,2511.13,-3782.1,177.506,0,0,0,0,100,0), +(@GUID*10,25,2505.32,-3766.45,177.742,0,0,0,0,100,0), +(@GUID*10,26,2499.29,-3765.75,177.507,0,0,0,0,100,0), +(@GUID*10,27,2493.61,-3765.09,177.507,0,0,0,0,100,0), +(@GUID*10,28,2488.06,-3772.43,177.667,0,0,0,0,100,0), +(@GUID*10,29,2478.6,-3767.26,180.055,0,0,0,0,100,0), +(@GUID*10,30,2463.88,-3762.3,177.666,0,0,0,0,100,0), +(@GUID*10,31,2446.59,-3773.59,178.28,0,0,0,0,100,0), +(@GUID*10,32,2439.01,-3778.42,182.265,0,0,0,0,100,0), +(@GUID*10,33,2432.32,-3782.88,185.472,0,0,0,0,100,0), +(@GUID*10,34,2411.83,-3797.16,185.472,0,0,0,0,100,0), +(@GUID*10,35,2415.58,-3802.36,185.472,0,0,0,0,100,0), +(@GUID*10,36,2414.56,-3808.81,182.472,0,0,0,0,100,0), +(@GUID*10,37,2406.03,-3813.16,182.472,0,0,0,0,100,0), +(@GUID*10,38,2398.47,-3811.12,182.472,0,0,0,0,100,0), +(@GUID*10,39,2394.15,-3802.58,182.472,0,0,0,0,100,0), +(@GUID*10,40,2395.78,-3795.05,182.472,0,0,0,0,100,0), +(@GUID*10,41,2402.87,-3790.52,182.557,0,0,0,0,100,0), +(@GUID*10,42,2407.82,-3791.89,185.472,0,0,0,0,100,0), +(@GUID*10,43,2412.66,-3796.79,185.472,0,0,0,0,100,0), +(@GUID*10,44,2431.26,-3783.83,185.472,0,0,0,0,100,0), +(@GUID*10,45,2439.74,-3777.69,181.587,0,0,0,0,100,0), +(@GUID*10,46,2445.84,-3773.07,178.365,0,0,0,0,100,0), +(@GUID*10,47,2455.68,-3785.4,178.221,0,0,0,0,100,0), +(@GUID*10,48,2457.6,-3806.44,178.436,0,0,0,0,100,0), +(@GUID*10,49,2453.84,-3819.84,178.737,0,0,0,0,100,0), +(@GUID*10,50,2463.63,-3826.59,180.355,0,0,0,0,100,0), +(@GUID*10,51,2476.42,-3822.85,181.172,0,0,0,0,100,0), +(@GUID*10,52,2485.1,-3812.75,179.831,0,0,0,0,100,0), +(@GUID*10,53,2480.62,-3800.22,178.74,0,0,0,0,100,0), +(@GUID*10,54,2459.22,-3787.09,178.419,0,0,0,0,100,0), +(@GUID*10,55,2444.28,-3759.46,177.54,0,0,0,0,100,0), +(@GUID*10,56,2418.65,-3747.28,178.11,0,0,0,0,100,0), +(@GUID*10,57,2402.3,-3746.86,179.548,0,0,0,0,100,0), +(@GUID*10,58,2389.34,-3753.05,180.059,0,0,0,0,100,0), +(@GUID*10,59,2393.41,-3730.55,179.646,0,0,0,0,100,0), +(@GUID*10,60,2391.13,-3712.96,180.489,0,0,0,0,100,0), +(@GUID*10,61,2382.1,-3695.87,178.616,0,0,0,0,100,0), +(@GUID*10,62,2383.45,-3676.65,178.75,0,0,0,0,100,0), +(@GUID*10,63,2398.82,-3677.72,180.299,0,0,0,0,100,0), +(@GUID*10,64,2416.71,-3671.23,177.938,0,0,0,0,100,0), +(@GUID*10,65,2432.07,-3674.78,178.847,0,0,0,0,100,0), +(@GUID*10,66,2444.61,-3659.84,178.354,0,0,0,0,100,0), +(@GUID*10,67,2449.41,-3654.12,178.171,0,0,0,0,100,0), +(@GUID*10,68,2444.29,-3641.95,179.354,0,0,0,0,100,0), +(@GUID*10,69,2429.71,-3633.13,179.324,0,0,0,0,100,0), +(@GUID*10,70,2432.72,-3624.53,179.08,0,0,0,0,100,0), +(@GUID*10,71,2445.42,-3621.45,179.625,0,0,0,0,100,0), +(@GUID*10,72,2450.93,-3630.38,178.698,0,0,0,0,100,0), +(@GUID*10,73,2452.16,-3632.38,178.682,0,0,0,0,100,0), +(@GUID*10,74,2463.72,-3640.3,178.907,0,0,0,0,100,0), +(@GUID*10,75,2459.88,-3661.08,177.627,0,0,0,0,100,0), +(@GUID*10,76,2473.04,-3676.41,178.342,0,0,0,0,100,0), +(@GUID*10,77,2479.66,-3692.7,179.121,0,0,0,0,100,0), +(@GUID*10,78,2485.39,-3706.78,180.135,0,0,0,0,100,0), +(@GUID*10,79,2483.55,-3717.48,181.223,0,0,0,0,100,0), +(@GUID*10,80,2472.62,-3722.2,181.107,0,0,0,0,100,0), +(@GUID*10,81,2460.63,-3708.49,178.649,0,0,0,0,100,0), +(@GUID*10,82,2462.01,-3697.02,178.186,0,0,0,0,100,0), +(@GUID*10,83,2473.57,-3694.13,179.281,0,0,0,0,100,0), +(@GUID*10,84,2491.08,-3694.42,179.212,0,0,0,0,100,0); + +-- Add pathing for Deathspeaker Selendre (Spawn 2) +UPDATE `creature` SET `MovementType`=2 WHERE `guid`=86755; +DELETE FROM `creature_addon` WHERE `guid`=86755; +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(86755,867550,0,0,1,0,""); + +DELETE FROM `waypoint_data` WHERE `id`=867550; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(867550,1,2633.53,-5512.31,158.266,0,0,0,0,100,0), +(867550,2,2641.01,-5540.31,159.216,0,0,0,0,100,0), +(867550,3,2653.46,-5552.56,159.34,0,0,0,0,100,0), +(867550,4,2668.72,-5552.25,160.452,0,0,0,0,100,0), +(867550,5,2679.62,-5537.82,160.818,0,0,0,0,100,0), +(867550,6,2683.71,-5518.79,159.878,0,0,0,0,100,0), +(867550,7,2695.21,-5511.24,158.123,0,0,0,0,100,0), +(867550,8,2704.09,-5499.15,157.063,0,0,0,0,100,0), +(867550,9,2708.13,-5475.21,156.953,0,0,0,0,100,0), +(867550,10,2731.05,-5464.05,157.015,0,0,0,0,100,0), +(867550,11,2731.99,-5480.38,161.471,0,0,0,0,100,0), +(867550,12,2732.98,-5491.9,162.069,0,0,0,0,100,0), +(867550,13,2741.12,-5501.31,166.418,0,0,0,0,100,0), +(867550,14,2748.96,-5510.25,166.428,0,0,0,0,100,0), +(867550,15,2754.52,-5508.12,165.928,0,0,0,0,100,0), +(867550,16,2757.52,-5509.1,164.573,0,0,0,0,100,0), +(867550,17,2758.95,-5511.08,163.551,0,0,0,0,100,0), +(867550,18,2758.95,-5513.17,163.038,0,0,0,0,100,0), +(867550,19,2755.42,-5517.98,161.743,0,0,0,0,100,0), +(867550,20,2762.02,-5525.39,161.737,0,0,0,0,100,0), +(867550,21,2769.75,-5524.21,161.737,0,0,0,0,100,0), +(867550,22,2776.09,-5530.58,161.737,0,0,0,0,100,0), +(867550,23,2766.78,-5538.91,161.737,0,0,0,0,100,0), +(867550,24,2762.42,-5537.22,161.737,0,0,0,0,100,0), +(867550,25,2759.18,-5531.55,161.737,0,0,0,0,100,0), +(867550,26,2761.79,-5526.45,161.737,0,0,0,0,100,0), +(867550,27,2759.07,-5522.23,161.737,0,0,0,0,100,0), +(867550,28,2755.78,-5518.92,161.74,0,0,0,0,100,0), +(867550,29,2749.79,-5521.54,163.08,0,0,0,0,100,0), +(867550,30,2745.88,-5520.01,164.442,0,0,0,0,100,0), +(867550,31,2745.74,-5516.86,165.591,0,0,0,0,100,0), +(867550,32,2746.29,-5515.2,166.298,0,0,0,0,100,0), +(867550,33,2748.89,-5512.05,166.43,0,0,0,0,100,0), +(867550,34,2740.96,-5502.26,166.418,0,0,0,0,100,0), +(867550,35,2734.43,-5494.47,162.071,0,0,0,0,100,0), +(867550,36,2724.37,-5483.28,161.458,0,0,0,0,100,0), +(867550,37,2702.21,-5460.21,157.012,0,0,0,0,100,0), +(867550,38,2688.36,-5456.17,157.155,0,0,0,0,100,0), +(867550,39,2669.61,-5456.86,156.929,0,0,0,0,100,0), +(867550,40,2660.04,-5444.49,156.926,0,0,0,0,100,0), +(867550,41,2650.58,-5424.81,157.095,0,0,0,0,100,0), +(867550,42,2656.66,-5407.65,158.167,0,0,0,0,100,0), +(867550,43,2672.4,-5398.03,157.001,0,0,0,0,100,0), +(867550,44,2695.58,-5373.55,157.803,0,0,0,0,100,0), +(867550,45,2725.65,-5375.05,157.781,0,0,0,0,100,0), +(867550,46,2751.57,-5375.31,156.949,0,0,0,0,100,0), +(867550,47,2771.12,-5384.22,157.482,0,0,0,0,100,0), +(867550,48,2784.59,-5399.42,160.854,0,0,0,0,100,0), +(867550,49,2797.84,-5398.13,162.834,0,0,0,0,100,0), +(867550,50,2808.66,-5407.03,162.822,0,0,0,0,100,0), +(867550,51,2814.93,-5418.1,160.679,0,0,0,0,100,0), +(867550,52,2808.52,-5434.4,158.947,0,0,0,0,100,0), +(867550,53,2796.89,-5447.17,160.524,0,0,0,0,100,0), +(867550,54,2783.1,-5450.75,161.02,0,0,0,0,100,0), +(867550,55,2752.6,-5458.67,157,0,0,0,0,100,0), +(867550,56,2738.31,-5456.31,156.946,0,0,0,0,100,0), +(867550,57,2725.15,-5462.05,156.962,0,0,0,0,100,0), +(867550,58,2711.18,-5475.83,157.095,0,0,0,0,100,0), +(867550,59,2685.64,-5474.16,156.989,0,0,0,0,100,0), +(867550,60,2669.68,-5451.54,157.027,0,0,0,0,100,0), +(867550,61,2645.86,-5449.2,156.941,0,0,0,0,100,0), +(867550,62,2632.98,-5462.23,157.103,0,0,0,0,100,0), +(867550,63,2626.28,-5483.26,157.083,0,0,0,0,100,0), +(867550,64,2616.9,-5493.82,157.194,0,0,0,0,100,0), +(867550,65,2616.39,-5504.67,158.186,0,0,0,0,100,0); |