diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2017_11_28_00_world.sql | 169 |
1 files changed, 169 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_11_28_00_world.sql b/sql/updates/world/3.3.5/2017_11_28_00_world.sql new file mode 100644 index 00000000000..d1f855e6323 --- /dev/null +++ b/sql/updates/world/3.3.5/2017_11_28_00_world.sql @@ -0,0 +1,169 @@ +SET @CGUID:=144950; +SET @EVENT1:=6; -- New Year's Eve +SET @EVENT2:=72; -- Fireworks Spectacular + +DELETE FROM `creature_template_addon` WHERE `entry` = 15724; +INSERT INTO `creature_template_addon` (`entry`, `auras`) VALUES +(15724, '26115'); + +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+40; +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 +(@CGUID+0 , 15724, 0, 0, 0, 1, 1, 0, 0, -14303.2, 442.825, 28.34243, 4.363323, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 0), -- 15724 (Area: 1578) (Auras: 26115 - 26115) +(@CGUID+1 , 15724, 0, 0, 0, 1, 1, 0, 0, -14304.99, 433.2847, 29.36503, 1.396263, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 0), -- 15724 (Area: 1578) (Auras: 26115 - 26115) +(@CGUID+2 , 15724, 0, 0, 0, 1, 1, 0, 0, -14272.64, 421.7396, 36.33361, 2.032897, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 0), -- 15724 (Area: 1578) (Auras: 26115 - 26115) +(@CGUID+3 , 15724, 0, 0, 0, 1, 1, 0, 0, -14314.71, 474.2673, 18.35473, 1.095548, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 0), -- 15724 (Area: 1578) (Auras: 26115 - 26115) +(@CGUID+4 , 15724, 0, 0, 0, 1, 1, 0, 0, -14280.88, 424.5142, 35.37117, 2.526357, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 0), -- 15724 (Area: 1578) (Auras: 26115 - 26115) +(@CGUID+5 , 15724, 0, 0, 0, 1, 1, 0, 0, -14278.35, 553.1927, 8.983554, 3.909538, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 0), -- 15724 (Area: 1578) (Auras: 26115 - 26115) +(@CGUID+6 , 15724, 0, 0, 0, 1, 1, 0, 0, -14302.29, 511.1232, 8.829531, 3.860822, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 0), -- 15724 (Area: 1578) (Auras: 26115 - 26115) +(@CGUID+7 , 15724, 0, 0, 0, 1, 1, 0, 0, -14286.46, 540.7466, 9.004538, 1.972222, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 0), -- 15724 (Area: 1578) (Auras: 26115 - 26115) +(@CGUID+8 , 15724, 0, 0, 0, 1, 1, 0, 0, -14293.2, 557.6228, 8.855279, 5.218534, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 0), -- 15724 (Area: 1578) (Auras: 26115 - 26115) +(@CGUID+9 , 15724, 0, 0, 0, 1, 1, 0, 0, -14343.7, 450.156, 7.633924, 5.585053, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 0), -- 15724 (Area: 1578) (Auras: 26115 - 26115) +(@CGUID+10, 15724, 0, 0, 0, 1, 1, 0, 0, -14366.24, 426.8889, 7.443278, 1.780236, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 0), -- 15724 (Area: 35) (Auras: 26115 - 26115) +(@CGUID+11, 15724, 0, 0, 0, 1, 1, 0, 0, -14415.8, 518.922, 5.104904, 3.176499, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 0), -- 15724 (Area: 35) (Auras: 26115 - 26115) +(@CGUID+12, 15724, 0, 0, 0, 1, 1, 0, 0, -14390.88, 414.8611, 22.82784, 2.740167, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 0), -- 15724 (Area: 35) (Auras: 26115 - 26115) +(@CGUID+13, 15724, 0, 0, 0, 1, 1, 0, 0, -14427.25, 456.5104, 15.42189, 4.485496, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 0), -- 15724 (Area: 35) (Auras: 26115 - 26115) +(@CGUID+14, 15724, 0, 0, 0, 1, 1, 0, 0, -14400.63, 413.0382, 7.934666, 0.7126135, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 0), -- 15724 (Area: 35) (Auras: 26115 - 26115) +(@CGUID+15, 15724, 0, 0, 0, 1, 1, 0, 0, -14437.55, 462.809, 3.976888, 3.560472, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 0), -- 15724 (Area: 35) (Auras: 26115 - 26115) +(@CGUID+16, 15724, 0, 0, 0, 1, 1, 0, 0, -14432.76, 509.2965, 7.009702, 4.28674, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 0), -- 15724 (Area: 35) (Auras: 26115 - 26115) +(@CGUID+17, 15724, 0, 0, 0, 1, 1, 0, 0, -14405.37, 410.5955, 27.81997, 0.8901179, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 0), -- 15724 (Area: 35) (Auras: 26115 - 26115) +(@CGUID+18, 15724, 0, 0, 0, 1, 1, 0, 0, -14386, 399.288, 6.645936, 2.408554, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 0), -- 15724 (Area: 35) (Auras: 26115 - 26115) +(@CGUID+19, 15724, 0, 0, 0, 1, 1, 0, 0, -14426.78, 523.7899, 5.075222, 5.72468, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 0), -- 15724 (Area: 35) (Auras: 26115 - 26115) +(@CGUID+20, 15724, 0, 0, 0, 1, 1, 0, 0, -14441.94, 481.1354, 15.273, 4.572762, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 0), -- 15724 (Area: 1759) (Auras: 26115 - 26115) +(@CGUID+21, 15724, 0, 0, 0, 1, 1, 0, 0, -14423.59, 424.6684, 21.85322, 3.719135, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 0), -- 15724 (Area: 1759) (Auras: 26115 - 26115) +(@CGUID+22, 15724, 0, 0, 0, 1, 1, 0, 0, -14445.73, 519.0208, 26.399, 5.340707, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 0), -- 15724 (Area: 1759) (Auras: 26115 - 26115) +(@CGUID+23, 15724, 0, 0, 0, 1, 1, 0, 0, -14442.65, 454.5469, 3.817722, 0.5235988, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 0), -- 15724 (Area: 1759) (Auras: 26115 - 26115) +(@CGUID+24, 15724, 0, 0, 0, 1, 1, 0, 0, -14438.98, 436.3958, 20.50878, 3.071779, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 0), -- 15724 (Area: 1759) (Auras: 26115 - 26115) +(@CGUID+25, 15724, 0, 0, 0, 1, 1, 0, 0, -14450.99, 462.4686, 15.43489, 3.682765, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 0), -- 15724 (Area: 1759) (Auras: 26115 - 26115) +(@CGUID+26, 15724, 0, 0, 0, 1, 1, 0, 0, -14448.31, 448.5817, 20.47261, 5.001486, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 0), -- 15724 (Area: 1759) (Auras: 26115 - 26115) +(@CGUID+27, 15724, 0, 0, 0, 1, 1, 0, 0, -14451.06, 454.7153, 20.54233, 0.7504916, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 0), -- 15724 (Area: 1759) (Auras: 26115 - 26115) +(@CGUID+28, 15724, 0, 0, 0, 1, 1, 0, 0, -14457.22, 494.8703, 26.35823, 1.029744, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 0), -- 15724 (Area: 1759) (Auras: 26115 - 26115) +(@CGUID+29, 15724, 0, 0, 0, 1, 1, 0, 0, -14458.1, 488.625, 15.20773, 1.937315, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 0), -- 15724 (Area: 1759) (Auras: 26115 - 26115) +(@CGUID+30, 15724, 0, 0, 0, 1, 1, 0, 0, -14449.02, 436.2082, 3.889718, 1.064651, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 0), -- 15724 (Area: 1759) (Auras: 26115 - 26115) +(@CGUID+31, 15724, 0, 0, 0, 1, 1, 0, 0, -14376.58, 386.1563, 22.67363, 4.852015, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 0), -- 15724 (Area: 1759) (Auras: 26115 - 26115) +(@CGUID+32, 15724, 0, 0, 0, 1, 1, 0, 0, -14461.74, 478.2934, 26.94364, 3.508112, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 0), -- 15724 (Area: 1759) (Auras: 26115 - 26115) +(@CGUID+33, 15724, 0, 0, 0, 1, 1, 0, 0, -14434.82, 416.8488, 8.818702, 0.6616975, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 0), -- 15724 (Area: 1759) (Auras: 26115 - 26115) +(@CGUID+34, 15724, 0, 0, 0, 1, 1, 0, 0, -14465.08, 474.9278, 15.03919, 6.038839, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 0), -- 15724 (Area: 1759) (Auras: 26115 - 26115) +(@CGUID+35, 15724, 0, 0, 0, 1, 1, 0, 0, -14460.96, 502.9427, 15.2055, 4.764749, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 0), -- 15724 (Area: 1759) (Auras: 26115 - 26115) +(@CGUID+36, 15724, 0, 0, 0, 1, 1, 0, 0, -14463.32, 502.349, 26.35558, 5.707227, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 0), -- 15724 (Area: 1759) (Auras: 26115 - 26115) +(@CGUID+37, 15724, 0, 0, 0, 1, 1, 0, 0, -14448.88, 429.5278, 15.10494, 3.735005, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 0), -- 15724 (Area: 1759) (Auras: 26115 - 26115) +(@CGUID+38, 15724, 0, 0, 0, 1, 1, 0, 0, -14471.41, 468.4601, 36.53928, 4.29351, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 0), -- 15724 (Area: 1759) (Auras: 26115 - 26115) +(@CGUID+39, 15724, 0, 0, 0, 1, 1, 0, 0, -14472.04, 483.9948, 20.465, 0.6283185, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 0), -- 15724 (Area: 1759) (Auras: 26115 - 26115) +(@CGUID+40, 15724, 0, 0, 0, 1, 1, 0, 0, -14472.41, 486.0102, 26.77704, 5.547335, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 0); -- 15724 (Area: 1759) (Auras: 26115 - 26115) + +DELETE FROM `game_event_creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+40 AND `eventEntry`=@EVENT1; +INSERT INTO `game_event_creature` SELECT @EVENT1, creature.guid FROM `creature` WHERE creature.guid BETWEEN @CGUID+0 AND @CGUID+40; + +DELETE FROM `game_event_creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+40 AND `eventEntry`=@EVENT2; +INSERT INTO `game_event_creature` SELECT @EVENT2, creature.guid FROM `creature` WHERE creature.guid BETWEEN @CGUID+0 AND @CGUID+40; + +-- 6 New Year's Eve & 72 Fireworks Spectacular +-- Despawn Booty Bay Bruiser but not 718, 680, 653 +DELETE FROM `game_event_creature` WHERE `guid` IN +(76,77,160,161,162,163,164,165,178,182,589,590,591,592,593,594,595,596,597,598,599,649,650,651,652,654,655,656,657,679,681,682,683,686,687,688,689,692,693, +694,695,696,697,698,699,700,715,716,717,719,2164,2167) AND `eventEntry` IN (-@EVENT1, -@EVENT2); + +INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES +(-@EVENT1, 76), +(-@EVENT1, 77), +(-@EVENT1, 160), +(-@EVENT1, 161), +(-@EVENT1, 162), +(-@EVENT1, 163), +(-@EVENT1, 164), +(-@EVENT1, 165), +(-@EVENT1, 178), +(-@EVENT1, 182), +(-@EVENT1, 589), +(-@EVENT1, 590), +(-@EVENT1, 591), +(-@EVENT1, 592), +(-@EVENT1, 593), +(-@EVENT1, 594), +(-@EVENT1, 595), +(-@EVENT1, 596), +(-@EVENT1, 597), +(-@EVENT1, 598), +(-@EVENT1, 599), +(-@EVENT1, 649), +(-@EVENT1, 650), +(-@EVENT1, 651), +(-@EVENT1, 652), +(-@EVENT1, 654), +(-@EVENT1, 655), +(-@EVENT1, 656), +(-@EVENT1, 657), +(-@EVENT1, 679), +(-@EVENT1, 681), +(-@EVENT1, 682), +(-@EVENT1, 683), +(-@EVENT1, 686), +(-@EVENT1, 687), +(-@EVENT1, 688), +(-@EVENT1, 689), +(-@EVENT1, 692), +(-@EVENT1, 693), +(-@EVENT1, 694), +(-@EVENT1, 695), +(-@EVENT1, 696), +(-@EVENT1, 697), +(-@EVENT1, 698), +(-@EVENT1, 699), +(-@EVENT1, 700), +(-@EVENT1, 715), +(-@EVENT1, 716), +(-@EVENT1, 717), +(-@EVENT1, 719), +(-@EVENT1, 2164), +(-@EVENT1, 2167), +(-@EVENT2, 76), +(-@EVENT2, 77), +(-@EVENT2, 160), +(-@EVENT2, 161), +(-@EVENT2, 162), +(-@EVENT2, 163), +(-@EVENT2, 164), +(-@EVENT2, 165), +(-@EVENT2, 178), +(-@EVENT2, 182), +(-@EVENT2, 589), +(-@EVENT2, 590), +(-@EVENT2, 591), +(-@EVENT2, 592), +(-@EVENT2, 593), +(-@EVENT2, 594), +(-@EVENT2, 595), +(-@EVENT2, 596), +(-@EVENT2, 597), +(-@EVENT2, 598), +(-@EVENT2, 599), +(-@EVENT2, 649), +(-@EVENT2, 650), +(-@EVENT2, 651), +(-@EVENT2, 652), +(-@EVENT2, 654), +(-@EVENT2, 655), +(-@EVENT2, 656), +(-@EVENT2, 657), +(-@EVENT2, 679), +(-@EVENT2, 681), +(-@EVENT2, 682), +(-@EVENT2, 683), +(-@EVENT2, 686), +(-@EVENT2, 687), +(-@EVENT2, 688), +(-@EVENT2, 689), +(-@EVENT2, 692), +(-@EVENT2, 693), +(-@EVENT2, 694), +(-@EVENT2, 695), +(-@EVENT2, 696), +(-@EVENT2, 697), +(-@EVENT2, 698), +(-@EVENT2, 699), +(-@EVENT2, 700), +(-@EVENT2, 715), +(-@EVENT2, 716), +(-@EVENT2, 717), +(-@EVENT2, 719), +(-@EVENT2, 2164), +(-@EVENT2, 2167); |