diff options
| -rw-r--r-- | sql/updates/world/master/2022_12_22_00_world.sql | 154 |
1 files changed, 154 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_12_22_00_world.sql b/sql/updates/world/master/2022_12_22_00_world.sql new file mode 100644 index 00000000000..6c7b9898a24 --- /dev/null +++ b/sql/updates/world/master/2022_12_22_00_world.sql @@ -0,0 +1,154 @@ +SET @CGUID := 1250047; + +-- Creature +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+94; +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES +(@CGUID+0, 190731, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2917.955810546875, 2921.347412109375, 367.6400146484375, 3.440163612365722656, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Thickmane Bear (Area: The Azure Span - Difficulty: 0) (Auras: 391254 - Hearty) +(@CGUID+1, 193509, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2987.910888671875, 2925.763916015625, 347.428375244140625, 5.494336605072021484, 120, 6, 0, 83980, 0, 1, 0, 0, 0, 47213), -- Woodland Filcher (Area: The Azure Span - Difficulty: 0) +(@CGUID+2, 190742, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2927.36083984375, 3031.952392578125, 395.07861328125, 0.57389003038406372, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Swooping Slyvern (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+3, 193509, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2955.264404296875, 2865.044921875, 364.87664794921875, 1.7418365478515625, 120, 6, 0, 83980, 0, 1, 0, 0, 0, 47213), -- Woodland Filcher (Area: The Azure Span - Difficulty: 0) +(@CGUID+4, 193502, 2444, 13646, 13646, '0', 0, 0, 0, 0, -3049.26171875, 2904.033447265625, 342.70697021484375, 1.122007727622985839, 120, 0, 0, 41990, 0, 0, 0, 0, 0, 47213), -- Red Furred Calf (Area: The Azure Span - Difficulty: 0) +(@CGUID+5, 193509, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2931.2216796875, 2986.960205078125, 359.662750244140625, 3.888539075851440429, 120, 10, 0, 83980, 0, 1, 0, 0, 0, 47213), -- Woodland Filcher (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+6, 193511, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2949.17333984375, 2948.95654296875, 354.23876953125, 5.451517581939697265, 120, 8, 0, 16796, 0, 1, 0, 0, 0, 47213), -- Woadspine (Area: The Azure Span - Difficulty: 0) +(@CGUID+7, 190731, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2905.94677734375, 3010.52197265625, 366.3629150390625, 3.882820844650268554, 120, 10, 0, 83980, 0, 1, 0, 0, 0, 47213), -- Thickmane Bear (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+8, 192267, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2909.220703125, 3015.7998046875, 365.00299072265625, 4.842474937438964843, 120, 4, 0, 5, 0, 1, 0, 0, 0, 47213), -- Azure Crystalspine (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+9, 190731, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2862.0234375, 2945.595947265625, 378.35382080078125, 1.733538031578063964, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Thickmane Bear (Area: The Azure Span - Difficulty: 0) (Auras: 42648 - Sleeping Sleep) +(@CGUID+10, 193509, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2982.62548828125, 3070.0087890625, 348.486053466796875, 3.126126289367675781, 120, 10, 0, 83980, 0, 1, 0, 0, 0, 47213), -- Woodland Filcher (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+11, 190731, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2817.798828125, 2992.023193359375, 390.72735595703125, 0.91009598970413208, 120, 10, 0, 83980, 0, 1, 0, 0, 0, 47213), -- Thickmane Bear (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+12, 194439, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2853.237548828125, 3099.09375, 384.048858642578125, 2.329248666763305664, 120, 10, 0, 167960, 0, 1, 0, 0, 0, 47213), -- Thickmane Matriach (Area: The Azure Span - Difficulty: 0) (Auras: 42648 - Sleeping Sleep) (possible waypoints or random movement) +(@CGUID+13, 190743, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2829.080322265625, 3030.3544921875, 389.066375732421875, 0.815350770950317382, 120, 6, 0, 50388, 0, 1, 0, 0, 0, 47213), -- Frosty Flowerpine (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+14, 190731, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2894.933837890625, 3079.612548828125, 372.28515625, 3.92526555061340332, 120, 10, 0, 83980, 0, 1, 0, 0, 0, 47213), -- Thickmane Bear (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+15, 190731, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2933.3115234375, 3081.9638671875, 361.304534912109375, 0.581564903259277343, 120, 10, 0, 83980, 0, 1, 0, 0, 0, 47213), -- Thickmane Bear (Area: The Azure Span - Difficulty: 0) (Auras: 42648 - Sleeping Sleep) (possible waypoints or random movement) +(@CGUID+16, 190743, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2951.760009765625, 3055.312255859375, 354.61602783203125, 2.758366823196411132, 120, 6, 0, 50388, 0, 1, 0, 0, 0, 47213), -- Frosty Flowerpine (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+17, 194436, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2852.509033203125, 3094.77978515625, 384.019927978515625, 2.252186536788940429, 120, 10, 0, 25194, 0, 1, 0, 0, 0, 47213), -- Juvenile Thickmane Bear (Area: The Azure Span - Difficulty: 0) (Auras: 42648 - Sleeping Sleep) (possible waypoints or random movement) +(@CGUID+18, 190731, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2819.0712890625, 3076.223876953125, 389.318115234375, 0.538866162300109863, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Thickmane Bear (Area: The Azure Span - Difficulty: 0) (Auras: 42648 - Sleeping Sleep) +(@CGUID+19, 190731, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2938.178466796875, 3109.834228515625, 361.640899658203125, 0.80045175552368164, 120, 10, 0, 83980, 0, 1, 0, 0, 0, 47213), -- Thickmane Bear (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+20, 190742, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2782.5048828125, 3096.08154296875, 413.86279296875, 3.545867919921875, 120, 00, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Swooping Slyvern (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+21, 190743, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2871.2744140625, 3122.324951171875, 378.90521240234375, 0.123292192816734313, 120, 6, 0, 50388, 0, 1, 0, 0, 0, 47213), -- Frosty Flowerpine (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+22, 190731, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2962.480224609375, 3103.360595703125, 356.050445556640625, 0.674740970134735107, 120, 10, 0, 83980, 0, 1, 0, 0, 0, 47213), -- Thickmane Bear (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+23, 190742, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2846.192626953125, 3161.64404296875, 396.704345703125, 4.535692691802978515, 120, 00, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Swooping Slyvern (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+24, 190731, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2870.517333984375, 3008.521728515625, 375.20806884765625, 5.773762702941894531, 120, 10, 0, 83980, 0, 1, 0, 0, 0, 47213), -- Thickmane Bear (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+25, 190731, 2444, 13646, 13646, '0', 0, 0, 0, 0, -3011.06396484375, 3100.36279296875, 344.312255859375, 4.870478153228759765, 120, 6, 0, 83980, 0, 1, 0, 0, 0, 47213), -- Thickmane Bear (Area: The Azure Span - Difficulty: 0) +(@CGUID+26, 194439, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2946.45703125, 3185.562255859375, 356.638153076171875, 5.68381357192993164, 120, 10, 0, 167960, 0, 1, 0, 0, 0, 47213), -- Thickmane Matriach (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+27, 190731, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2988.5078125, 3139.388671875, 348.836181640625, 4.306856155395507812, 120, 10, 0, 83980, 0, 1, 0, 0, 0, 47213), -- Thickmane Bear (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+28, 190731, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2875, 3139.625244140625, 377.769439697265625, 4.712388992309570312, 120, 10, 0, 83980, 0, 1, 0, 0, 0, 47213), -- Thickmane Bear (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+29, 190742, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2981.14306640625, 3195.216796875, 369.610870361328125, 4.120409965515136718, 120, 00, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Swooping Slyvern (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+30, 190743, 2444, 13646, 13646, '0', 0, 0, 0, 0, -3033.099609375, 3122.045166015625, 336.4425048828125, 5.270056724548339843, 120, 6, 0, 50388, 0, 1, 0, 0, 0, 47213), -- Frosty Flowerpine (Area: The Azure Span - Difficulty: 0) +(@CGUID+31, 190731, 2444, 13646, 13646, '0', 0, 0, 0, 0, -3052.046875, 3067.367431640625, 334.7608642578125, 0.307545185089111328, 120, 6, 0, 83980, 0, 1, 0, 0, 0, 47213), -- Thickmane Bear (Area: The Azure Span - Difficulty: 0) +(@CGUID+32, 190743, 2444, 13646, 13646, '0', 0, 0, 0, 0, -3028.15380859375, 3165.30322265625, 337.544525146484375, 5.740925788879394531, 120, 6, 0, 50388, 0, 1, 0, 0, 0, 47213), -- Frosty Flowerpine (Area: The Azure Span - Difficulty: 0) +(@CGUID+33, 193497, 2444, 13646, 13646, '0', 0, 0, 0, 0, -3059.73046875, 3060.1796875, 331.183258056640625, 2.652611970901489257, 120, 6, 0, 83980, 0, 1, 0, 0, 0, 47213), -- Shortcoat Bear (Area: The Azure Span - Difficulty: 0) +(@CGUID+34, 194436, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2947.61865234375, 3188.64208984375, 355.535888671875, 2.365178346633911132, 120, 10, 0, 25194, 0, 1, 0, 0, 0, 47213), -- Juvenile Thickmane Bear (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+35, 190743, 2444, 13646, 13646, '0', 0, 0, 0, 0, -3064.387939453125, 3111.28125, 329.261871337890625, 5.04839181900024414, 120, 6, 0, 50388, 0, 1, 0, 0, 0, 47213), -- Frosty Flowerpine (Area: The Azure Span - Difficulty: 0) +(@CGUID+36, 193509, 2444, 13646, 13646, '0', 0, 0, 0, 0, -3079.505615234375, 3173.97412109375, 324.88433837890625, 6.125759124755859375, 120, 6, 0, 83980, 0, 1, 0, 0, 0, 47213), -- Woodland Filcher (Area: The Azure Span - Difficulty: 0) +(@CGUID+37, 193511, 2444, 13646, 13646, '0', 0, 0, 0, 0, -3048.956298828125, 3151.018310546875, 334.59185791015625, 5.022864818572998046, 120, 6, 0, 16796, 0, 1, 0, 0, 0, 47213), -- Woadspine (Area: The Azure Span - Difficulty: 0) +(@CGUID+38, 190731, 2444, 13646, 13646, '0', 0, 0, 0, 0, -3030.11962890625, 3180.791748046875, 338.963409423828125, 4.81983184814453125, 120, 6, 0, 83980, 0, 1, 0, 0, 0, 47213), -- Thickmane Bear (Area: The Azure Span - Difficulty: 0) +(@CGUID+39, 190731, 2444, 13646, 13646, '0', 0, 0, 0, 0, -3083.925537109375, 3121.005859375, 323.501068115234375, 4.56538248062133789, 120, 6, 0, 83980, 0, 1, 0, 0, 0, 47213), -- Thickmane Bear (Area: The Azure Span - Difficulty: 0) +(@CGUID+40, 194439, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2949.737548828125, 3240.83984375, 351.7613525390625, 1.038081884384155273, 120, 10, 0, 167960, 0, 1, 0, 0, 0, 47213), -- Thickmane Matriach (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+41, 190221, 2444, 13646, 13646, '0', 0, 0, 0, 0, -3096.66796875, 3118.603515625, 354.059326171875, 0.717220127582550048, 120, 0, 0, 5, 0, 0, 0, 0, 0, 47213), -- Pine Flicker (Area: The Azure Span - Difficulty: 0) +(@CGUID+42, 190731, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2982.604736328125, 3221.469482421875, 346.049285888671875, 6.189996242523193359, 120, 10, 0, 83980, 0, 1, 0, 0, 0, 47213), -- Thickmane Bear (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+43, 190731, 2444, 13646, 13646, '0', 0, 0, 0, 0, -3009.788330078125, 3230.640625, 339.534912109375, 3.257509469985961914, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Thickmane Bear (Area: The Azure Span - Difficulty: 0) (Auras: 42648 - Sleeping Sleep) +(@CGUID+44, 190731, 2444, 13646, 13646, '0', 0, 0, 0, 0, -3093.5830078125, 3178.459228515625, 320.61090087890625, 3.622705936431884765, 120, 10, 0, 83980, 0, 1, 0, 0, 0, 47213), -- Thickmane Bear (Area: The Azure Span - Difficulty: 0) +(@CGUID+45, 194436, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2946.22119140625, 3232.44580078125, 352.756927490234375, 4.464187145233154296, 120, 10, 0, 25194, 0, 1, 0, 0, 0, 47213), -- Juvenile Thickmane Bear (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+46, 190743, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2987.336181640625, 3258.039794921875, 343.293701171875, 4.237930774688720703, 120, 3, 0, 50388, 0, 1, 0, 0, 0, 47213), -- Frosty Flowerpine (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+47, 190743, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2992.181640625, 3262.304443359375, 340.710052490234375, 5.504006862640380859, 120, 3, 0, 50388, 0, 1, 0, 0, 0, 47213), -- Frosty Flowerpine (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+48, 190731, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2921.382080078125, 3218.3203125, 356.342864990234375, 4.891254425048828125, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Thickmane Bear (Area: The Azure Span - Difficulty: 0) (Auras: 42648 - Sleeping Sleep) +(@CGUID+49, 190742, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2886.69580078125, 3192.016357421875, 402.982818603515625, 2.018958091735839843, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Swooping Slyvern (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+50, 190731, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2957.847900390625, 3269.766845703125, 349.495147705078125, 1.309942245483398437, 120, 10, 0, 83980, 0, 1, 0, 0, 0, 47213), -- Thickmane Bear (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+51, 3300, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2908.731201171875, 3256.261962890625, 354.400665283203125, 4.908246040344238281, 120, 10, 0, 1, 0, 1, 0, 0, 0, 47213), -- Adder (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+52, 190742, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2843.838623046875, 3277.819580078125, 381.76641845703125, 3.156496763229370117, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Swooping Slyvern (Area: The Azure Span - Difficulty: 0) +(@CGUID+53, 190731, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2867.321044921875, 3196.396484375, 373.813629150390625, 2.858735322952270507, 120, 10, 0, 83980, 0, 1, 0, 0, 0, 47213), -- Thickmane Bear (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+54, 190731, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2858.269775390625, 3212.58544921875, 373.660980224609375, 6.237293720245361328, 120, 10, 0, 83980, 0, 1, 0, 0, 0, 47213), -- Thickmane Bear (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+55, 190731, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2945.585205078125, 3312.8134765625, 342.619293212890625, 0.395728677511215209, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Thickmane Bear (Area: The Azure Span - Difficulty: 0) (Auras: 42648 - Sleeping Sleep, 391254 - Hearty) +(@CGUID+56, 190731, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2860.6455078125, 3273.232421875, 363.539825439453125, 3.322144746780395507, 120, 10, 0, 83980, 0, 1, 0, 0, 0, 47213), -- Thickmane Bear (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+57, 190731, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2823.46728515625, 3236.78564453125, 378.37725830078125, 5.548455715179443359, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Thickmane Bear (Area: The Azure Span - Difficulty: 0) +(@CGUID+58, 190743, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2847.159423828125, 3282.19775390625, 366.383758544921875, 1.335835576057434082, 120, 6, 0, 50388, 0, 1, 0, 0, 0, 47213), -- Frosty Flowerpine (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+59, 190731, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2816.84326171875, 3225.184326171875, 386.602386474609375, 2.225112438201904296, 120, 10, 0, 83980, 0, 1, 0, 0, 0, 47213), -- Thickmane Bear (Area: The Azure Span - Difficulty: 0) (Auras: 42648 - Sleeping Sleep) (possible waypoints or random movement) +(@CGUID+60, 190731, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2907.4638671875, 3321.90673828125, 348.077484130859375, 3.825710296630859375, 120, 10, 0, 83980, 0, 1, 0, 0, 0, 47213), -- Thickmane Bear (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+61, 190742, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2811.7802734375, 3319.21240234375, 430.1524658203125, 3.586399316787719726, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Swooping Slyvern (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+62, 194439, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2790.828857421875, 3155.353515625, 399.272552490234375, 2.525428533554077148, 120, 10, 0, 167960, 0, 1, 0, 0, 0, 47213), -- Thickmane Matriach (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+63, 194439, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2780.062255859375, 3331.875244140625, 355.743499755859375, 0.354196637868881225, 120, 10, 0, 167960, 0, 1, 0, 0, 0, 47213), -- Thickmane Matriach (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+64, 190742, 2444, 13646, 13646, '0', 0, 0, 0, 0, -3019.6826171875, 3334.637939453125, 360.34332275390625, 5.349385261535644531, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Swooping Slyvern (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+65, 190743, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2790.922119140625, 3317.987060546875, 363.945281982421875, 2.130637168884277343, 120, 4, 0, 50388, 0, 1, 0, 0, 0, 47213), -- Frosty Flowerpine (Area: The Azure Span - Difficulty: 0) +(@CGUID+66, 190743, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2826.853759765625, 3389.428955078125, 346.389556884765625, 0.563359737396240234, 120, 4, 0, 50388, 0, 1, 0, 0, 0, 47213), -- Frosty Flowerpine (Area: The Azure Span - Difficulty: 0) +(@CGUID+67, 194436, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2782.81640625, 3327.44921875, 358.076385498046875, 3.962898969650268554, 120, 4, 0, 25194, 0, 1, 0, 0, 0, 47213), -- Juvenile Thickmane Bear (Area: The Azure Span - Difficulty: 0)) +(@CGUID+68, 190731, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2749.880126953125, 3310.49267578125, 375.4215087890625, 2.433804035186767578, 120, 4, 0, 83980, 0, 1, 0, 0, 0, 47213), -- Thickmane Bear (Area: The Azure Span - Difficulty: 0) +(@CGUID+69, 190743, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2771.028564453125, 3188.691162109375, 398.351470947265625, 1.604019641876220703, 120, 6, 0, 50388, 0, 1, 0, 0, 0, 47213), -- Frosty Flowerpine (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+70, 190743, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2731.17578125, 3204.72998046875, 411.064544677734375, 5.974709987640380859, 120, 6, 0, 50388, 0, 1, 0, 0, 0, 47213), -- Frosty Flowerpine (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+71, 194436, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2791.041015625, 3157.45703125, 398.968841552734375, 2.233638525009155273, 120, 10, 0, 25194, 0, 1, 0, 0, 0, 47213), -- Juvenile Thickmane Bear (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+72, 194436, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2791.99365234375, 3156.466796875, 398.583892822265625, 1.769340872764587402, 120, 10, 0, 25194, 0, 1, 0, 0, 0, 47213), -- Juvenile Thickmane Bear (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+73, 190731, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2739.2001953125, 3169.297607421875, 411.3642578125, 2.059379339218139648, 120, 10, 0, 83980, 0, 1, 0, 0, 0, 47213), -- Thickmane Bear (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+74, 194439, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2734.20703125, 3119.804931640625, 414.924591064453125, 2.992789983749389648, 120, 10, 0, 167960, 0, 1, 0, 0, 0, 47213), -- Thickmane Matriach (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+75, 192265, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2775.25, 3126.8076171875, 402.751983642578125, 4.20876312255859375, 120, 4, 0, 5, 0, 1, 0, 0, 0, 47213), -- Azure Crystalspine (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+76, 190731, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2795.273193359375, 3117.16845703125, 398.167755126953125, 2.698469877243041992, 120, 10, 0, 83980, 0, 1, 0, 0, 0, 47213), -- Thickmane Bear (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+77, 190731, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2819.5625, 3125.834228515625, 390.060150146484375, 2.345364570617675781, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Thickmane Bear (Area: The Azure Span - Difficulty: 0) (Auras: 42648 - Sleeping Sleep) +(@CGUID+78, 190743, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2719.589111328125, 3133.13232421875, 421.38812255859375, 6.244845390319824218, 120, 6, 0, 50388, 0, 1, 0, 0, 0, 47213), -- Frosty Flowerpine (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+79, 190742, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2691.01513671875, 3125.817626953125, 463.63720703125, 4.940379619598388671, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Swooping Slyvern (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+80, 190731, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2690.0361328125, 3182.268798828125, 430.98388671875, 3.634078502655029296, 120, 10, 0, 83980, 0, 1, 0, 0, 0, 47213), -- Thickmane Bear (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+81, 194436, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2732.928466796875, 3120.9140625, 414.7215576171875, 3.074180364608764648, 120, 10, 0, 25194, 0, 1, 0, 0, 0, 47213), -- Juvenile Thickmane Bear (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+82, 190742, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2662.229248046875, 3147.466552734375, 454.570281982421875, 0.472804427146911621, 120, 0, 0, 83980, 0, 0, 0, 0, 0, 47213), -- Swooping Slyvern (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+83, 190743, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2699.220947265625, 3127.00146484375, 430.35528564453125, 5.950934886932373046, 120, 6, 0, 50388, 0, 1, 0, 0, 0, 47213), -- Frosty Flowerpine (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+84, 190743, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2668.08203125, 3249.187744140625, 428.84503173828125, 1.265407323837280273, 120, 4, 0, 50388, 0, 1, 0, 0, 0, 47213), -- Frosty Flowerpine (Area: The Azure Span - Difficulty: 0) +(@CGUID+85, 190731, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2653.090576171875, 3141, 442.396514892578125, 3.112293481826782226, 120, 10, 0, 83980, 0, 1, 0, 0, 0, 47213), -- Thickmane Bear (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+86, 190731, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2661.252197265625, 3085.455322265625, 446.6412353515625, 4.311214923858642578, 120, 10, 0, 83980, 0, 1, 0, 0, 0, 47213), -- Thickmane Bear (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+87, 190743, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2707.972412109375, 3052.028564453125, 436.613922119140625, 2.991543292999267578, 120, 6, 0, 50388, 0, 1, 0, 0, 0, 47213), -- Frosty Flowerpine (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+88, 190731, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2734.82421875, 3044.88427734375, 424.700836181640625, 0.043567515909671783, 120, 10, 0, 83980, 0, 1, 0, 0, 0, 47213), -- Thickmane Bear (Area: The Azure Span - Difficulty: 0) +(@CGUID+89, 190731, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2695.2978515625, 3037.47216796875, 439.439483642578125, 2.51645970344543457, 120, 10, 0, 83980, 0, 1, 0, 0, 0, 47213), -- Thickmane Bear (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+90, 190731, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2651.99365234375, 3027.974609375, 458.521209716796875, 3.185509920120239257, 120, 10, 0, 83980, 0, 1, 0, 0, 0, 47213), -- Thickmane Bear (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+91, 192265, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2640.83837890625, 3038.437744140625, 461.515625, 2.676112890243530273, 120, 4, 0, 5, 0, 1, 0, 0, 0, 47213), -- Azure Crystalspine (Area: The Azure Span - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+92, 192977, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2561.4619140625, 3037.93359375, 543.34417724609375, 4.079997062683105468, 120, 0, 0, 3, 0, 0, 0, 0, 0, 47213), -- Rock Gopher (Area: The Azure Span - Difficulty: 0) +(@CGUID+93, 190731, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2793.63037109375, 3057.432373046875, 398.768035888671875, 0.428727328777313232, 120, 6, 0, 83980, 0, 1, 0, 0, 0, 47213), -- Thickmane Bear (Area: The Azure Span - Difficulty: 0) +(@CGUID+94, 190731, 2444, 13646, 13646, '0', 0, 0, 0, 0, -2863.83642578125, 3076.440673828125, 380.426666259765625, 1.186576485633850097, 120, 6, 0, 83980, 0, 1, 0, 0, 0, 47213); -- Thickmane Bear (Area: The Azure Span - Difficulty: 0) +DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+94; +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(@CGUID+9, 0, 0, 3, 1, 0, 0, 0, 0, 0, '42648'), -- Thickmane Bear - 42648 - Sleeping Sleep +(@CGUID+12, 0, 0, 3, 1, 0, 0, 0, 0, 0, '42648'), -- Thickmane Matriach - 42648 - Sleeping Sleep +(@CGUID+15, 0, 0, 3, 1, 0, 0, 0, 0, 0, '42648'), -- Thickmane Bear - 42648 - Sleeping Sleep +(@CGUID+17, 0, 0, 3, 1, 0, 0, 0, 0, 0, '42648'), -- Juvenile Thickmane Bear - 42648 - Sleeping Sleep +(@CGUID+18, 0, 0, 3, 1, 0, 0, 0, 0, 0, '42648'), -- Thickmane Bear - 42648 - Sleeping Sleep +(@CGUID+43, 0, 0, 3, 1, 0, 0, 0, 0, 0, '42648'), -- Thickmane Bear - 42648 - Sleeping Sleep +(@CGUID+48, 0, 0, 3, 1, 0, 0, 0, 0, 0, '42648'), -- Thickmane Bear - 42648 - Sleeping Sleep +(@CGUID+52, 0, 0, 50331649, 1, 0, 0, 0, 0, 0, ''), -- Swooping Slyvern +(@CGUID+55, 0, 0, 3, 1, 0, 0, 0, 0, 0, '42648'), -- Thickmane Bear - 42648 - Sleeping Sleep +(@CGUID+59, 0, 0, 3, 1, 0, 0, 0, 0, 0, '42648'), -- Thickmane Bear - 42648 - Sleeping Sleep +(@CGUID+77, 0, 0, 3, 1, 0, 0, 0, 0, 0, '42648'); -- Thickmane Bear - 42648 - Sleeping Sleep + +-- Creature Template Addon +DELETE FROM `creature_template_addon` WHERE `entry` IN (193701 /*193701 (Bark Moth)*/, 190221 /*190221 (Pine Flicker)*/, 190742 /*190742 (Swooping Slyvern)*/, 193509 /*193509 (Woodland Filcher)*/); +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(193701, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- 193701 (Bark Moth) +(190221, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- 190221 (Pine Flicker) +(190742, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- 190742 (Swooping Slyvern) +(193509, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''); -- 193509 (Woodland Filcher) + +-- Creature Template +UPDATE `creature_template` SET `faction`=188, `speed_walk`=0.400000005960464477, `speed_run`=0.285714298486709594, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=193701; -- Bark Moth +UPDATE `creature_template` SET `minlevel`=65, `maxlevel`=65, `faction`=190, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=193776; -- Highlands Goat +UPDATE `creature_template` SET `faction`=188, `speed_run`=0.857142865657806396, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=192977; -- Rock Gopher +UPDATE `creature_template` SET `faction`=188, `npcflag`=1073741824, `BaseAttackTime`=2000, `unit_flags`=33280, `unit_flags2`=2048 WHERE `entry`=192265; -- Azure Crystalspine +UPDATE `creature_template` SET `minlevel`=68, `maxlevel`=68, `faction`=16, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=190726; -- Striped Bruffalon +UPDATE `creature_template` SET `minlevel`=68, `maxlevel`=68, `faction`=2136, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=190944; -- Vorquin Strider +UPDATE `creature_template` SET `minlevel`=68, `maxlevel`=68, `faction`=2574, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=193429; -- Ravaged Bruffalon +UPDATE `creature_template` SET `faction`=190, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=190221; -- Pine Flicker +UPDATE `creature_template` SET `minlevel`=68, `maxlevel`=68, `faction`=16, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=193497; -- Shortcoat Bear +UPDATE `creature_template` SET `minlevel`=68, `maxlevel`=68, `faction`=16, `BaseAttackTime`=2000, `unit_flags`=294912, `unit_flags2`=2048 WHERE `entry`=194436; -- Juvenile Thickmane Bear +UPDATE `creature_template` SET `minlevel`=68, `maxlevel`=68, `faction`=190, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=190743; -- Frosty Flowerpine +UPDATE `creature_template` SET `minlevel`=68, `maxlevel`=68, `faction`=16, `BaseAttackTime`=2000, `unit_flags`=294976, `unit_flags2`=2048 WHERE `entry`=194439; -- Thickmane Matriach +UPDATE `creature_template` SET `faction`=188, `BaseAttackTime`=2000, `unit_flags`=33280, `unit_flags2`=2048 WHERE `entry`=192267; -- Azure Crystalspine +UPDATE `creature_template` SET `minlevel`=68, `maxlevel`=68, `faction`=190, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=193511; -- Woadspine +UPDATE `creature_template` SET `minlevel`=68, `maxlevel`=68, `faction`=190, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=193503; -- Red Furred Cow +UPDATE `creature_template` SET `minlevel`=68, `maxlevel`=68, `faction`=188, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=193502; -- Red Furred Calf +UPDATE `creature_template` SET `minlevel`=68, `maxlevel`=68, `faction`=190, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=190742; -- Swooping Slyvern +UPDATE `creature_template` SET `minlevel`=68, `maxlevel`=68, `faction`=190, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=193509; -- Woodland Filcher +UPDATE `creature_template` SET `minlevel`=68, `maxlevel`=68, `faction`=16, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=190731; -- Thickmane Bear + +-- Creature Movement +DELETE FROM `creature_template_movement` WHERE `CreatureId` IN (190742, 193509, 190221); +INSERT INTO `creature_template_movement` (`CreatureId`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random`, `InteractionPauseTimer`) VALUES +(190742, 0, 0, 1, 0, 0, 0, NULL), +(190221, 0, 0, 1, 0, 0, 0, NULL), +(193509, 0, 0, 1, 0, 0, 0, NULL); + +-- Scaling +DELETE FROM `creature_template_scaling` WHERE (`Entry`=191947 AND `DifficultyID`=0); +INSERT INTO `creature_template_scaling` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `VerifiedBuild`) VALUES +(191947, 0, 0, 0, 2078, 47213); |