aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2024_11_08_03_world.sql126
1 files changed, 126 insertions, 0 deletions
diff --git a/sql/updates/world/master/2024_11_08_03_world.sql b/sql/updates/world/master/2024_11_08_03_world.sql
new file mode 100644
index 00000000000..fa046010362
--- /dev/null
+++ b/sql/updates/world/master/2024_11_08_03_world.sql
@@ -0,0 +1,126 @@
+SET @OGUID := 10800337;
+
+-- Gameobject templates
+DELETE FROM `gameobject_template` WHERE `entry` IN (464921, 464922, 464920, 464919);
+INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `size`, `Data0`, `Data1`, `Data2`, `Data3`, `Data4`, `Data5`, `Data6`, `Data7`, `Data8`, `Data9`, `Data10`, `Data11`, `Data12`, `Data13`, `Data14`, `Data15`, `Data16`, `Data17`, `Data18`, `Data19`, `Data20`, `Data21`, `Data22`, `Data23`, `Data24`, `Data25`, `Data26`, `Data27`, `Data28`, `Data29`, `Data30`, `Data31`, `Data32`, `Data33`, `Data34`, `ContentTuningId`, `VerifiedBuild`) VALUES
+(464919, 2, 98384, 'Candy Bucket', '', '', '', 1, 0, 27769, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 425, 57212), -- Candy Bucket
+(464920, 2, 98384, 'Candy Bucket', '', '', '', 1, 0, 27770, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 425, 57212), -- Candy Bucket
+(464921, 2, 98384, 'Candy Bucket', '', '', '', 1, 0, 27771, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 425, 57212), -- Candy Bucket
+(464922, 2, 98384, 'Candy Bucket', '', '', '', 1, 0, 27772, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 425, 57212); -- Candy Bucket
+
+DELETE FROM `gameobject_template_addon` WHERE `entry` IN (464921, 464922, 464920, 464919);
+INSERT INTO `gameobject_template_addon` (`entry`, `faction`, `flags`, `WorldEffectID`, `AIAnimKitID`) VALUES
+(464922, 35, 0x4, 0, 0), -- Candy Bucket
+(464921, 35, 0x4, 0, 0), -- Candy Bucket
+(464920, 35, 0x4, 0, 0), -- Candy Bucket
+(464919, 35, 0x4, 0, 0); -- Candy Bucket
+
+-- Quests
+DELETE FROM `quest_offer_reward` WHERE `ID` IN (84574, 84575, 84573, 84572);
+INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES
+(84574, 0, 0, 0, 0, 0, 0, 0, 0, 'Candy buckets like this are located in inns throughout the realms. Go ahead... take some!', 57212), -- Candy Bucket
+(84575, 0, 0, 0, 0, 0, 0, 0, 0, 'Candy buckets like this are located in inns throughout the realms. Go ahead... take some!', 57212), -- Candy Bucket
+(84573, 0, 0, 0, 0, 0, 0, 0, 0, 'Candy buckets like this are located in inns throughout the realms. Go ahead... take some!', 57212), -- Candy Bucket
+(84572, 0, 0, 0, 0, 0, 0, 0, 0, 'Candy buckets like this are located in inns throughout the realms. Go ahead... take some!', 57212); -- Candy Bucket
+
+DELETE FROM `gameobject_queststarter` WHERE `id` IN (464921, 464922, 464920, 464919);
+INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
+(464921, 84574, 57212),
+(464922, 84575, 57212),
+(464920, 84573, 57212),
+(464919, 84572, 57212);
+
+DELETE FROM `gameobject_questender` WHERE `id` IN (464921, 464922, 464920, 464919);
+INSERT INTO `gameobject_questender` (`id`, `quest`, `VerifiedBuild`) VALUES
+(464921, 84574, 57212),
+(464922, 84575, 57212),
+(464920, 84573, 57212),
+(464919, 84572, 57212);
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+37;
+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
+-- Lorel's Crossing
+(@OGUID+0, 180405, 2601, 14838, 15107, '0', 0, 0, 2732.275146484375, 305.989593505859375, 64.123931884765625, 4.975747585296630859, 0, 0, -0.60814285278320312, 0.793827593326568603, 120, 255, 1, 57212), -- G_Pumpkin_01 (Area: Lorel's Crossing - Difficulty: 0) CreateObject1
+(@OGUID+1, 180405, 2601, 14838, 15107, '0', 0, 0, 2734.5322265625, 326.48785400390625, 64.37332916259765625, 5.2530517578125, 0.01692819595336914, 0.007182121276855468, -0.49265193939208984, 0.870032131671905517, 120, 255, 1, 57212), -- G_Pumpkin_01 (Area: Lorel's Crossing - Difficulty: 0) CreateObject1
+(@OGUID+2, 180406, 2601, 14838, 15107, '0', 0, 0, 2743.91748046875, 335.463531494140625, 63.56161880493164062, 3.634562015533447265, 0, 0, -0.96977615356445312, 0.243996292352676391, 120, 255, 1, 57212), -- G_Pumpkin_02 (Area: Lorel's Crossing - Difficulty: 0) CreateObject1
+(@OGUID+3, 180406, 2601, 14838, 15107, '0', 0, 0, 2733.368896484375, 313.657989501953125, 64.32811737060546875, 5.109864234924316406, 0, 0, -0.55358314514160156, 0.832793891429901123, 120, 255, 1, 57212), -- G_Pumpkin_02 (Area: Lorel's Crossing - Difficulty: 0) CreateObject1
+(@OGUID+4, 180407, 2601, 14838, 15107, '0', 0, 0, 2733.145751953125, 311.37847900390625, 64.31070709228515625, 5.001270771026611328, -0.0246901512145996, -0.01338005065917968, -0.59796810150146484, 0.801027834415435791, 120, 255, 1, 57212), -- G_Pumpkin_03 (Area: Lorel's Crossing - Difficulty: 0) CreateObject1
+(@OGUID+5, 180407, 2601, 14838, 15107, '0', 0, 0, 2734.7890625, 328.567718505859375, 64.52198028564453125, 5.174334049224853515, 0.050740242004394531, -0.06638908386230468, -0.52263164520263671, 0.848453938961029052, 120, 255, 1, 57212), -- G_Pumpkin_03 (Area: Lorel's Crossing - Difficulty: 0) CreateObject1
+(@OGUID+6, 180408, 2601, 14838, 15107, '0', 0, 0, 2730.912353515625, 320.140625, 77.96810150146484375, 4.772849559783935546, -0.02669000625610351, 0.022539138793945312, -0.68504047393798828, 0.727666914463043212, 120, 255, 1, 57212), -- G_WitchHat_01 (Area: Lorel's Crossing - Difficulty: 0) CreateObject1
+(@OGUID+7, 180415, 2601, 14838, 15107, '0', 0, 0, 2753.40185546875, 318.776031494140625, 65.813018798828125, 0, 0, 0, 0, 1, 120, 255, 1, 57212), -- CandleBlack01 (Area: Lorel's Crossing - Difficulty: 0) CreateObject1
+(@OGUID+8, 180415, 2601, 14838, 15107, '0', 0, 0, 2753.272705078125, 318.263885498046875, 65.65274810791015625, 0, 0, 0, 0, 1, 120, 255, 1, 57212), -- CandleBlack01 (Area: Lorel's Crossing - Difficulty: 0) CreateObject1
+(@OGUID+9, 180523, 2601, 14838, 15107, '0', 0, 0, 2746.0400390625, 285.55035400390625, 64.42412567138671875, 0, 0, 0, 0, 1, 120, 255, 1, 57212), -- Apple Bob (Area: Lorel's Crossing - Difficulty: 0) CreateObject1
+(@OGUID+10, 464920, 2601, 14838, 15107, '0', 0, 0, 2752.0859375, 319.961822509765625, 64.46137237548828125, 5.020358562469482421, 0, 0, -0.5902862548828125, 0.807193934917449951, 120, 255, 1, 57212), -- Candy Bucket (Area: Lorel's Crossing - Difficulty: 0) CreateObject1
+-- Dunelle's Kindness
+(@OGUID+11, 180405, 2601, 14838, 14916, '0', 0, 0, 2448.5625, -1332.6302490234375, -45.1460990905761718, 2.823662519454956054, -0.01263332366943359, 0.013361930847167968, 0.987198829650878906, 0.158430904150009155, 120, 255, 1, 57212), -- G_Pumpkin_01 (Area: Dunelle's Kindness - Difficulty: 0) CreateObject1
+(@OGUID+12, 180405, 2601, 14838, 14916, '0', 0, 0, 2430.29345703125, -1340.9149169921875, -46.6360015869140625, 2.845476865768432617, 0, 0, 0.9890594482421875, 0.147517517209053039, 120, 255, 1, 57212), -- G_Pumpkin_01 (Area: Dunelle's Kindness - Difficulty: 0) CreateObject1
+(@OGUID+13, 180406, 2601, 14838, 14916, '0', 0, 0, 2446.296875, -1332.6822509765625, -45.1460990905761718, 4.492058753967285156, 0, 0, -0.78056144714355468, 0.625079035758972167, 120, 255, 1, 57212), -- G_Pumpkin_02 (Area: Dunelle's Kindness - Difficulty: 0) CreateObject1
+(@OGUID+14, 180406, 2601, 14838, 14916, '0', 0, 0, 2415.232666015625, -1307.920166015625, -45.700714111328125, 2.818093538284301757, 0, 0, 0.986947059631347656, 0.161045119166374206, 120, 255, 1, 57212), -- G_Pumpkin_02 (Area: Dunelle's Kindness - Difficulty: 0) CreateObject1
+(@OGUID+15, 180407, 2601, 14838, 14916, '0', 0, 0, 2447.569580078125, -1334.24658203125, -45.1460990905761718, 0.508146524429321289, -0.00500392913818359, -0.02763271331787109, 0.250958442687988281, 0.96759045124053955, 120, 255, 1, 57212), -- G_Pumpkin_03 (Area: Dunelle's Kindness - Difficulty: 0) CreateObject1
+(@OGUID+16, 180407, 2601, 14838, 14916, '0', 0, 0, 2419.7587890625, -1322.10595703125, -46.3124275207519531, 2.48961496353149414, 0.053173542022705078, 0.064455986022949218, 0.944765090942382812, 0.316917747259140014, 120, 255, 1, 57212), -- G_Pumpkin_03 (Area: Dunelle's Kindness - Difficulty: 0) CreateObject1
+(@OGUID+17, 180408, 2601, 14838, 14916, '0', 0, 0, 2423.567626953125, -1325.0625, -36.5926399230957031, 2.408214569091796875, -0.01074934005737304, -0.03323841094970703, 0.932926177978515625, 0.35836908221244812, 120, 255, 1, 57212), -- G_WitchHat_01 (Area: Dunelle's Kindness - Difficulty: 0) CreateObject1
+(@OGUID+18, 180415, 2601, 14838, 14916, '0', 0, 0, 2425.40625, -1326.75, -41.2712631225585937, 0, 0, 0, 0, 1, 120, 255, 1, 57212), -- CandleBlack01 (Area: Dunelle's Kindness - Difficulty: 0) CreateObject1
+(@OGUID+19, 180415, 2601, 14838, 14916, '0', 0, 0, 2421.786376953125, -1323.1302490234375, -41.2822189331054687, 0, 0, 0, 0, 1, 120, 255, 1, 57212), -- CandleBlack01 (Area: Dunelle's Kindness - Difficulty: 0) CreateObject1
+(@OGUID+20, 180523, 2601, 14838, 14916, '0', 0, 0, 2429.30908203125, -1349.8021240234375, -45.3359489440917968, 0, 0, 0, 0, 1, 120, 255, 1, 57212), -- Apple Bob (Area: Dunelle's Kindness - Difficulty: 0) CreateObject1
+(@OGUID+21, 464919, 2601, 14838, 14916, '0', 0, 0, 2410.350830078125, -1334.423583984375, -45.2929801940917968, 0.797762572765350341, 0, 0, 0.388387680053710937, 0.921496093273162841, 120, 255, 1, 57212), -- Candy Bucket (Area: Dunelle's Kindness - Difficulty: 0) CreateObject1
+-- Mereldar
+(@OGUID+22, 180405, 2601, 14838, 14917, '0', 0, 0, 1862.5052490234375, 867.62677001953125, 127.3740081787109375, 3.539043426513671875, 0.016511917114257812, -0.00809288024902343, -0.98018550872802734, 0.197226345539093017, 120, 255, 1, 57212), -- G_Pumpkin_01 (Area: Mereldar - Difficulty: 0) CreateObject1
+(@OGUID+23, 180406, 2601, 14838, 14917, '0', 0, 0, 1849.0069580078125, 866.1336669921875, 126.9521331787109375, 3.183024883270263671, 0, 0, -0.99978542327880859, 0.02071458101272583, 120, 255, 1, 57212), -- G_Pumpkin_02 (Area: Mereldar - Difficulty: 0) CreateObject1
+(@OGUID+24, 180407, 2601, 14838, 14917, '0', 0, 0, 1867.65625, 869.6475830078125, 134.5472564697265625, 3.608828544616699218, -0.01084613800048828, -0.08285140991210937, -0.96889114379882812, 0.232954934239387512, 120, 255, 1, 57212), -- G_Pumpkin_03 (Area: Mereldar - Difficulty: 0) CreateObject1
+(@OGUID+25, 180408, 2601, 14838, 14917, '0', 0, 0, 1867.5416259765625, 869.84027099609375, 136.0551605224609375, 3.183804750442504882, -0.00261688232421875, 0.0348358154296875, -0.99916839599609375, 0.021025881171226501, 120, 255, 1, 57212), -- G_WitchHat_01 (Area: Mereldar - Difficulty: 0) CreateObject1
+(@OGUID+26, 180415, 2601, 14838, 14917, '0', 0, 0, 1854.126708984375, 847.2430419921875, 128.9074859619140625, 0, 0, 0, 0, 1, 120, 255, 1, 57212), -- CandleBlack01 (Area: Mereldar - Difficulty: 0) CreateObject1
+(@OGUID+27, 180415, 2601, 14838, 14917, '0', 0, 0, 1854.5728759765625, 847.248291015625, 129.0195770263671875, 0, 0, 0, 0, 1, 120, 255, 1, 57212), -- CandleBlack01 (Area: Mereldar - Difficulty: 0) CreateObject1
+(@OGUID+28, 180523, 2601, 14838, 14917, '0', 0, 0, 1821.140625, 854.5711669921875, 127.63067626953125, 0, 0, 0, 0, 1, 120, 255, 1, 57212), -- Apple Bob (Area: Mereldar - Difficulty: 0) CreateObject1
+(@OGUID+29, 464922, 2601, 14838, 14917, '0', 0, 0, 1856.6666259765625, 848.734375, 127.63067626953125, 3.778800725936889648, 0, 0, -0.94967365264892578, 0.313241094350814819, 120, 255, 1, 57212), -- Candy Bucket (Area: Mereldar - Difficulty: 0) CreateObject1
+-- Light's Redoubt
+(@OGUID+30, 180405, 2601, 14838, 14928, '0', 0, 0, 1171.6944580078125, 1023.94622802734375, 46.72400283813476562, 6.222667217254638671, 0.011630058288574218, 0.014243125915527343, -0.03041267395019531, 0.999368250370025634, 120, 255, 1, 57212), -- G_Pumpkin_01 (Area: Light's Redoubt - Difficulty: 0) CreateObject1
+(@OGUID+31, 180406, 2601, 14838, 14928, '0', 0, 0, 1163.6597900390625, 1004.93927001953125, 49.37694168090820312, 3.970162868499755859, 0, 0, -0.91540431976318359, 0.402535617351531982, 120, 255, 1, 57212), -- G_Pumpkin_02 (Area: Light's Redoubt - Difficulty: 0) CreateObject1
+(@OGUID+32, 180407, 2601, 14838, 14928, '0', 0, 0, 1169.203125, 1026.0816650390625, 46.63826370239257812, 6.148765087127685546, 0.075917243957519531, -0.03490829467773437, -0.06459999084472656, 0.994406759738922119, 120, 255, 1, 57212), -- G_Pumpkin_03 (Area: Light's Redoubt - Difficulty: 0) CreateObject1
+(@OGUID+33, 180408, 2601, 14838, 14928, '0', 0, 0, 1174.46533203125, 1030.703125, 47.52219772338867187, 5.93768310546875, -0.03468751907348632, 0.004141807556152343, -0.17185306549072265, 0.984502971172332763, 120, 255, 1, 57212), -- G_WitchHat_01 (Area: Light's Redoubt - Difficulty: 0) CreateObject1
+(@OGUID+34, 180415, 2601, 14838, 14928, '0', 0, 0, 1180.513916015625, 1043.701416015625, 40.77159500122070312, 0, 0, 0, 0, 1, 120, 255, 1, 57212), -- CandleBlack01 (Area: Light's Redoubt - Difficulty: 0) CreateObject1
+(@OGUID+35, 180415, 2601, 14838, 14928, '0', 0, 0, 1177.390625, 1043.453125, 40.67887496948242187, 0, 0, 0, 0, 1, 120, 255, 1, 57212), -- CandleBlack01 (Area: Light's Redoubt - Difficulty: 0) CreateObject1
+(@OGUID+36, 180523, 2601, 14838, 14928, '0', 0, 0, 1182.7725830078125, 1043.736083984375, 38.90559768676757812, 0, 0, 0, 0, 1, 120, 255, 1, 57212), -- Apple Bob (Area: Light's Redoubt - Difficulty: 0) CreateObject1
+(@OGUID+37, 464921, 2601, 14838, 14928, '0', 0, 0, 1176.9635009765625, 1030.2396240234375, 40.36378860473632812, 0.604954481124877929, 0, 0, 0.297885894775390625, 0.954601466655731201, 120, 255, 1, 57212); -- Candy Bucket (Area: Light's Redoubt - Difficulty: 0) CreateObject1
+
+-- Event spawns
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+37;
+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);