diff options
| -rw-r--r-- | sql/updates/world/master/2023_10_28_01_world.sql | 125 |
1 files changed, 125 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_10_28_01_world.sql b/sql/updates/world/master/2023_10_28_01_world.sql new file mode 100644 index 00000000000..34c755e0f6a --- /dev/null +++ b/sql/updates/world/master/2023_10_28_01_world.sql @@ -0,0 +1,125 @@ +SET @CGUID := 7000029; +SET @OGUID := 7000099; + +-- Gameobject templates +DELETE FROM `gameobject_template_addon` WHERE `entry`=316755; +INSERT INTO `gameobject_template_addon` (`entry`, `faction`, `flags`, `WorldEffectID`, `AIAnimKitID`) VALUES +(316755, 35, 4, 0, 0); -- Candy Bucket + +-- Quests +UPDATE `quest_template` SET `Expansion`=9, `VerifiedBuild`=51886 WHERE `ID`=54710; -- Candy Bucket + +DELETE FROM `quest_offer_reward` WHERE `ID`=54710; +INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES +(54710, 0, 0, 0, 0, 0, 0, 0, 0, 'Candy buckets like this are located in inns throughout the realms. Go ahead... take some!', 51886); -- Candy Bucket + +DELETE FROM `gameobject_queststarter` WHERE (`id`=316755 AND `quest`=54710); +INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES +(316755, 54710, 51886); -- Candy Bucket ended by Candy Bucket + +DELETE FROM `gameobject_questender` WHERE (`id`=316755 AND `quest`=54710); +INSERT INTO `gameobject_questender` (`id`, `quest`, `VerifiedBuild`) VALUES +(316755, 54710, 51886); -- Candy Bucket ended by Candy Bucket + +-- Creature spawns +DELETE FROM `creature` WHERE `guid`=@CGUID+0; +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`, `unit_flags2`, `unit_flags3`, `VerifiedBuild`) VALUES +(@CGUID+0, 40435, 1643, 8567, 9979, '0', 0, 0, 0, 0, 1046.892333984375, -456.84722900390625, 7.46938323974609375, 4.088603019714355468, 120, 0, 0, 112919, 0, 0, NULL, NULL, NULL, NULL, 51886); -- Headless Ghost (Area: Dampwick Ward - Difficulty: 0) CreateObject1 (Auras: 33900 - Shroud of Death) + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+42; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES +(@OGUID+0, 180405, 1643, 8567, 9979, '0', 0, 0, 1036.001708984375, -488.930572509765625, 14.681884765625, 5.811798095703125, 0, 0, -0.23351764678955078, 0.972352564334869384, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Dampwick Ward - Difficulty: 0) CreateObject1 +(@OGUID+1, 180405, 1643, 8567, 8568, '0', 0, 0, 1134.7603759765625, -489.90625, 29.01800155639648437, 6.278563976287841796, 0, 0, -0.00231075286865234, 0.999997317790985107, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Boralus - Difficulty: 0) CreateObject1 +(@OGUID+2, 180405, 1643, 8717, 8718, '0', 0, 0, 1100.4166259765625, -597.33331298828125, 20.28375625610351562, 4.133514404296875, 0, 0, -0.87951183319091796, 0.475876986980438232, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Tradewinds Market - Difficulty: 0) CreateObject1 +(@OGUID+3, 180405, 1643, 8717, 8718, '0', 0, 0, 1163.9617919921875, -600.37847900390625, 28.87758064270019531, 4.75708627700805664, 0, 0, -0.69112873077392578, 0.722731649875640869, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Tradewinds Market - Difficulty: 0) CreateObject1 +(@OGUID+4, 180405, 1643, 8717, 8718, '0', 0, 0, 1221.967041015625, -603.3211669921875, 29.91538810729980468, 5.063618659973144531, 0, 0, -0.57269001007080078, 0.819772005081176757, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Tradewinds Market - Difficulty: 0) CreateObject1 +(@OGUID+5, 180405, 1643, 8717, 8718, '0', 0, 0, 1111.4600830078125, -669.58331298828125, 33.10686874389648437, 3.122455835342407226, 0, 0, 0.9999542236328125, 0.009568319655954837, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Tradewinds Market - Difficulty: 0) CreateObject1 +(@OGUID+6, 180406, 1643, 8567, 8568, '0', 0, 0, 1073.3038330078125, -472.625, 9.700110435485839843, 0.661361575126647949, 0, 0, 0.324687004089355468, 0.945821523666381835, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Boralus - Difficulty: 0) CreateObject1 +(@OGUID+7, 180406, 1643, 8567, 8568, '0', 0, 0, 1154.0103759765625, -497.7882080078125, 28.92107200622558593, 0.035545311868190765, 0, 0, 0.017771720886230468, 0.999842047691345214, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Boralus - Difficulty: 0) CreateObject1 +(@OGUID+8, 180406, 1643, 8717, 0, '0', 0, 0, 1108.3646240234375, -551.06597900390625, 20.30774116516113281, 5.908473014831542968, 0, 0, -0.18626213073730468, 0.982500076293945312, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+9, 180406, 1643, 8717, 0, '0', 0, 0, 1169.4461669921875, -569.82989501953125, 28.90155982971191406, 5.404108524322509765, 0, 0, -0.4255218505859375, 0.904948174953460693, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+10, 180406, 1643, 8717, 8718, '0', 0, 0, 1222.7535400390625, -554.91668701171875, 29.89424705505371093, 0.143662929534912109, 0, 0, 0.07176971435546875, 0.997421205043792724, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Tradewinds Market - Difficulty: 0) CreateObject1 +(@OGUID+11, 180406, 1643, 8717, 0, '0', 0, 0, 1066.6649169921875, -633.8975830078125, 20.04802131652832031, 5.289632797241210937, 0, 0, -0.4765939712524414, 0.879123568534851074, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+12, 180407, 1643, 8567, 8568, '0', 0, 0, 1061.6041259765625, -528.3350830078125, 20.14594459533691406, 5.764843940734863281, 0, 0, -0.25627899169921875, 0.966602861881256103, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Boralus - Difficulty: 0) CreateObject1 +(@OGUID+13, 180407, 1643, 8567, 8568, '0', 0, 0, 1163.611083984375, -537.1007080078125, 39.76563644409179687, 0.385012537240982055, 0, 0, 0.191319465637207031, 0.98152780532836914, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Boralus - Difficulty: 0) CreateObject1 +(@OGUID+14, 180407, 1643, 8717, 0, '0', 0, 0, 1178.8472900390625, -562.25177001953125, 28.24422073364257812, 1.637055635452270507, 0, 0, 0.73014068603515625, 0.683296859264373779, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+15, 180407, 1643, 8717, 0, '0', 0, 0, 1147.9757080078125, -582.39239501953125, 20.48769187927246093, 4.905172348022460937, 0, 0, -0.63577079772949218, 0.771877884864807128, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+16, 180407, 1643, 8717, 8718, '0', 0, 0, 1066, -604.74652099609375, 20.04802131652832031, 4.525606155395507812, 0, 0, -0.76996707916259765, 0.638083577156066894, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Tradewinds Market - Difficulty: 0) CreateObject1 +(@OGUID+17, 180407, 1643, 8567, 8568, '0', 0, 0, 1272.4913330078125, -540.078125, 36.09422683715820312, 5.8619842529296875, 0, 0, -0.20904731750488281, 0.977905511856079101, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Boralus - Difficulty: 0) CreateObject1 +(@OGUID+18, 180408, 1643, 8717, 0, '0', 0, 0, 1124.25, -577.34722900390625, 24.66414451599121093, 1.274088263511657714, 0, 0, 0.594821929931640625, 0.80385744571685791, 120, 255, 1, 51886), -- G_WitchHat_01 (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+19, 180410, 1643, 8567, 9979, '0', 0, 0, 1011.40972900390625, -505.782989501953125, 16.17806625366210937, 4.791739463806152343, 0, 0, -0.67850303649902343, 0.734597623348236083, 120, 255, 1, 51886), -- G_HangingSkeleton_01 (Area: Dampwick Ward - Difficulty: 0) CreateObject1 +(@OGUID+20, 180410, 1643, 8567, 8568, '0', 0, 0, 1214.0416259765625, -490.5069580078125, 31.52115249633789062, 4.289918422698974609, 0, 0, -0.83964729309082031, 0.54313206672668457, 120, 255, 1, 51886), -- G_HangingSkeleton_01 (Area: Boralus - Difficulty: 0) CreateObject1 +(@OGUID+21, 180410, 1643, 8567, 8568, '0', 0, 0, 1173.4617919921875, -546.14581298828125, 32.52764511108398437, 2.148845434188842773, 0, 0, 0.879315376281738281, 0.476239949464797973, 120, 255, 1, 51886), -- G_HangingSkeleton_01 (Area: Boralus - Difficulty: 0) CreateObject1 +(@OGUID+22, 180410, 1643, 8567, 8568, '0', 0, 0, 1167.1146240234375, -549.02606201171875, 32.52764511108398437, 2.028649091720581054, 0, 0, 0.849123954772949218, 0.528193593025207519, 120, 255, 1, 51886), -- G_HangingSkeleton_01 (Area: Boralus - Difficulty: 0) CreateObject1 +(@OGUID+23, 180410, 1643, 8717, 0, '0', 0, 0, 1047.376708984375, -593.3992919921875, 13.33738613128662109, 6.275104045867919921, 0, 0, -0.00404071807861328, 0.999991834163665771, 120, 255, 1, 51886), -- G_HangingSkeleton_01 (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+24, 180410, 1643, 8717, 8718, '0', 0, 0, 1156.5867919921875, -614.97918701171875, 32.31130599975585937, 2.485475063323974609, 0, 0, 0.946669578552246093, 0.322205960750579833, 120, 255, 1, 51886), -- G_HangingSkeleton_01 (Area: Tradewinds Market - Difficulty: 0) CreateObject1 +(@OGUID+25, 180411, 1643, 8567, 8568, '0', 0, 0, 1074.392333984375, -486.947906494140625, 15.13197708129882812, 6.259387016296386718, 0, 0, -0.01189899444580078, 0.999929189682006835, 120, 255, 1, 51886), -- G_Ghost_01 (Area: Boralus - Difficulty: 0) CreateObject1 +(@OGUID+26, 180411, 1643, 8567, 8568, '0', 0, 0, 1106.6475830078125, -532.170166015625, 24.21261024475097656, 3.403396368026733398, 0, 0, -0.99144458770751953, 0.130528271198272705, 120, 255, 1, 51886), -- G_Ghost_01 (Area: Boralus - Difficulty: 0) CreateObject1 +(@OGUID+27, 180411, 1643, 8567, 8568, '0', 0, 0, 1131.0225830078125, -516.6180419921875, 38.62833023071289062, 1.134462952613830566, 0, 0, 0.537299156188964843, 0.843391716480255126, 120, 255, 1, 51886), -- G_Ghost_01 (Area: Boralus - Difficulty: 0) CreateObject1 +(@OGUID+28, 180411, 1643, 8567, 8568, '0', 0, 0, 1104.9322509765625, -529.1319580078125, 23.44733428955078125, 0.593410074710845947, 0, 0, 0.292370796203613281, 0.95630502700805664, 120, 255, 1, 51886), -- G_Ghost_01 (Area: Boralus - Difficulty: 0) CreateObject1 +(@OGUID+29, 180411, 1643, 8717, 8718, '0', 0, 0, 1156.998291015625, -610.91668701171875, 34.272674560546875, 5.460464954376220703, 0, 0, -0.3998565673828125, 0.916577696800231933, 120, 255, 1, 51886), -- G_Ghost_01 (Area: Tradewinds Market - Difficulty: 0) CreateObject1 +(@OGUID+30, 180415, 1643, 8717, 0, '0', 0, 0, 1129.954833984375, -576.03643798828125, 19.01902389526367187, 0.122172988951206207, 0, 0, 0.061048507690429687, 0.998134791851043701, 120, 255, 1, 51886), -- CandleBlack01 (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+31, 180415, 1643, 8717, 0, '0', 0, 0, 1119.0989990234375, -574.3524169921875, 19.01902389526367187, 0.122172988951206207, 0, 0, 0.061048507690429687, 0.998134791851043701, 120, 255, 1, 51886), -- CandleBlack01 (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+32, 180415, 1643, 8717, 0, '0', 0, 0, 1127.2847900390625, -572.29168701171875, 19.01902389526367187, 0.122172988951206207, 0, 0, 0.061048507690429687, 0.998134791851043701, 120, 255, 1, 51886), -- CandleBlack01 (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+33, 180415, 1643, 8717, 0, '0', 0, 0, 1122.782958984375, -571.60418701171875, 19.01902389526367187, 0.122172988951206207, 0, 0, 0.061048507690429687, 0.998134791851043701, 120, 255, 1, 51886), -- CandleBlack01 (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+34, 180415, 1643, 8717, 0, '0', 0, 0, 1129.2899169921875, -580.56768798828125, 19.01902389526367187, 0.122172988951206207, 0, 0, 0.061048507690429687, 0.998134791851043701, 120, 255, 1, 51886), -- CandleBlack01 (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+35, 180415, 1643, 8717, 0, '0', 0, 0, 1121.0504150390625, -582.57989501953125, 19.01902389526367187, 0.122172988951206207, 0, 0, 0.061048507690429687, 0.998134791851043701, 120, 255, 1, 51886), -- CandleBlack01 (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+36, 180415, 1643, 8717, 0, '0', 0, 0, 1118.3194580078125, -578.8975830078125, 19.01902389526367187, 0.122172988951206207, 0, 0, 0.061048507690429687, 0.998134791851043701, 120, 255, 1, 51886), -- CandleBlack01 (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+37, 180415, 1643, 8717, 0, '0', 0, 0, 1125.6353759765625, -583.203125, 19.01902389526367187, 0.122172988951206207, 0, 0, 0.061048507690429687, 0.998134791851043701, 120, 255, 1, 51886), -- CandleBlack01 (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+38, 180472, 1643, 8567, 9979, '0', 0, 0, 992.15277099609375, -498.703125, 17.07048225402832031, 3.735006093978881835, 0, 0, -0.95630455017089843, 0.292372345924377441, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Dampwick Ward - Difficulty: 0) CreateObject1 +(@OGUID+39, 180472, 1643, 8567, 8568, '0', 0, 0, 1031.0364990234375, -505.489593505859375, 25.55430030822753906, 0.610863447189331054, 0, 0, 0.3007049560546875, 0.953717231750488281, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Boralus - Difficulty: 0) CreateObject1 +(@OGUID+40, 180523, 1643, 8567, 8568, '0', 0, 0, 1080.921875, -477.34027099609375, 9.874209403991699218, 0.750490784645080566, 0, 0, 0.3665008544921875, 0.93041771650314331, 120, 255, 1, 51886), -- Apple Bob (Area: Boralus - Difficulty: 0) CreateObject1 +(@OGUID+41, 180523, 1643, 8717, 8718, '0', 0, 0, 1171.751708984375, -597.25177001953125, 31.65879249572753906, 0.750490784645080566, 0, 0, 0.3665008544921875, 0.93041771650314331, 120, 255, 1, 51886), -- Apple Bob (Area: Tradewinds Market - Difficulty: 0) CreateObject1 +(@OGUID+42, 316755, 1643, 8717, 8718, '0', 0, 0, 1187.5694580078125, -588.68231201171875, 31.50209236145019531, 4.829091548919677734, 0, 0, -0.66466617584228515, 0.747140467166900634, 120, 255, 1, 51886); -- Candy Bucket (Area: Tradewinds Market - Difficulty: 0) CreateObject1 + +-- Event spawns +DELETE FROM `game_event_creature` WHERE `eventEntry`=12 AND `guid`=@CGUID+0; +INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES +(12, @CGUID+0); + +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+42; +INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES +(12, @OGUID+0), +(12, @OGUID+1), +(12, @OGUID+2), +(12, @OGUID+3), +(12, @OGUID+4), +(12, @OGUID+5), +(12, @OGUID+6), +(12, @OGUID+7), +(12, @OGUID+8), +(12, @OGUID+9), +(12, @OGUID+10), +(12, @OGUID+11), +(12, @OGUID+12), +(12, @OGUID+13), +(12, @OGUID+14), +(12, @OGUID+15), +(12, @OGUID+16), +(12, @OGUID+17), +(12, @OGUID+18), +(12, @OGUID+19), +(12, @OGUID+20), +(12, @OGUID+21), +(12, @OGUID+22), +(12, @OGUID+23), +(12, @OGUID+24), +(12, @OGUID+25), +(12, @OGUID+26), +(12, @OGUID+27), +(12, @OGUID+28), +(12, @OGUID+29), +(12, @OGUID+30), +(12, @OGUID+31), +(12, @OGUID+32), +(12, @OGUID+33), +(12, @OGUID+34), +(12, @OGUID+35), +(12, @OGUID+36), +(12, @OGUID+37), +(12, @OGUID+38), +(12, @OGUID+39), +(12, @OGUID+40), +(12, @OGUID+41), +(12, @OGUID+42); |