From 3d4e391f7de5339d1355fa4e313dd060063cdf3f Mon Sep 17 00:00:00 2001 From: Golrag Date: Sun, 20 Jul 2025 13:57:04 +0200 Subject: DB/GameObjects: Add some gameobject_templates - also updated older ones - Add some Arena WorldStates --- sql/updates/world/master/2025_07_20_00_world.sql | 25 ++++++++++++++++++++++++ 1 file changed, 25 insertions(+) create mode 100644 sql/updates/world/master/2025_07_20_00_world.sql (limited to 'sql/updates/world') diff --git a/sql/updates/world/master/2025_07_20_00_world.sql b/sql/updates/world/master/2025_07_20_00_world.sql new file mode 100644 index 00000000000..18916edffdb --- /dev/null +++ b/sql/updates/world/master/2025_07_20_00_world.sql @@ -0,0 +1,25 @@ +DELETE FROM `gameobject_template` WHERE `entry` IN (381620 /*10CT_Centaur_FoodRack02_meat.M2*/, 381618 /*Campfire*/, 381619 /*Campfire*/, 379282 /*Arena Door*/, 376125 /*Enigma Arena - Door*/, 376866 /*ProgenitorArena_Button_Trim*/, 376861 /*Enigma Arena Door 02*/, 376876 /*Enigma Arena Door 01*/, 376877 /*ProgenitorArena_Button01*/, 428210 /*Ready*/, 529989 /*Barbershop Pole [DNT]*/, 525434 /*Bounty: Liberation of Undermine*/, 529988 /*Pet Grooming Station*/); +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 +(381620, 8, 75533, '10CT_Centaur_FoodRack02_meat.M2', '', '', '', 1.159999966621398925, 4, 10, 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, 0, 61967), -- 10CT_Centaur_FoodRack02_meat.M2 +(381618, 8, 75447, 'Campfire', '', '', '', 0.800000011920928955, 4, 10, 2061, 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, 61967), -- Campfire +(381619, 8, 74212, 'Campfire', '', '', '', 1.460000038146972656, 4, 10, 2061, 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, 61967), -- Campfire +(379282, 0, 76226, 'Arena Door', '', '', '', 1.899999976158142089, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 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, 61967), -- Arena Door +(376125, 0, 6391, 'Enigma Arena - Door', '', '', '', 4, 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, 0, 0, 0, 61967), -- Enigma Arena - Door +(376866, 5, 73119, 'ProgenitorArena_Button_Trim', '', '', '', 1, 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, 0, 0, 0, 61967), -- ProgenitorArena_Button_Trim +(376861, 0, 72220, 'Enigma Arena Door 02', '', '', '', 2.859998941421508789, 0, 0, 0, 0, 0, 0, 0, 5793, 1, 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, 61967), -- Enigma Arena Door 02 +(376876, 0, 72220, 'Enigma Arena Door 01', '', '', '', 3.339998960494995117, 0, 0, 0, 0, 0, 0, 0, 5793, 1, 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, 61967), -- Enigma Arena Door 01 +(376877, 1, 72792, 'ProgenitorArena_Button01', '', '', '', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 5793, 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, 61967), -- ProgenitorArena_Button01 +(428210, 1, 14146, 'Ready', 'interact', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 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, 61967), -- Ready +(529989, 5, 49367, 'Barbershop Pole [DNT]', '', '', '', 0.5, 0, 0, 0, 0, 0, 0, 0, 1, 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, 61967), -- Barbershop Pole [DNT] +(525434, 2, 98816, 'Bounty: Liberation of Undermine', 'quest', '', '', 0.699999988079071044, 0, 28478, 0, 38621, 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, 2797, 61967), -- Bounty: Liberation of Undermine +(529988, 32, 74540, 'Pet Grooming Station', '', '', '', 0.800000011920928955, 0, 0, 7810, 0, 128, 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, 851, 61967); -- Pet Grooming Station + +UPDATE `gameobject_template` SET `VerifiedBuild`=61967 WHERE `entry` IN (428960, 415377, 428989, 466206, 459302, 219395, 219396, 190942, 368426, 233282, 245770, 245765, 245766, 245767, 245768, 245781, 245762, 245769, 245763, 459301, 459299, 459298, 459300, 3933, 3930, 3928, 3918, 3917, 3916, 3914, 336432, 260449, 3841, 260462, 182158, 3931, 260456, 3912, 260469, 3925, 260450, 3842, 260527, 184303, 260463, 182159, 3919, 3932, 260457, 174953, 3913, 260470, 3926, 260451, 3843, 260528, 185136, 260464, 182160, 3920, 260458, 260471, 3927, 260452, 3844, 260465, 182161, 3921, 3934, 260459, 182155, 3915, 260472, 260453, 3845, 260466, 182162, 3922, 3839, 260460, 182156, 260473, 3929, 260454, 260467, 3923, 260448, 3840, 260461, 182157, 260474, 260455, 260468, 3924, 466205, 428958, 364440, 375536, 184664, 184663, 298781, 278212, 298780, 278211, 353495, 352927, 353497, 192642, 192643, 191877, 194395, 428865, 428866, 428857, 428864, 429034, 429033, 428862, 466851, 415760, 466853, 446172, 446169, 446168, 446167, 446166, 434125, 428863, 428860, 494552, 494551, 494550, 494549, 494547, 494546, 494545, 467461, 467460, 467457, 467456, 446171, 446170, 441897, 429066, 428992, 428990, 428955, 467463, 467462, 467459, 467458, 466852, 466850, 428970, 428953, 428858, 421632, 429073, 429072, 429062, 428976, 428965, 428881, 428878, 428877, 428852, 428851, 428850, 35591, 452669, 452668, 452667, 452666, 452665, 452664, 452663, 452662, 428963, 428962, 428961, 428951, 428950, 459276, 459275, 459274, 459273, 459272, 459271, 428952, 428948, 447138, 429067, 429065, 428954, 428949, 452647, 428934, 428933, 428932, 428930, 428929, 428928, 428926, 428925, 428924, 428917, 452646, 428923, 428097, 428922, 414149, 245436, 377531, 463872, 377117, 377308, 452645, 452644, 402552, 452643, 385537, 389674, 465667, 455781, 465666, 446368, 446367, 446366, 428921, 467066, 428998, 428973, 428936, 428935, 428931, 428927, 428853, 434053, 459285, 452661, 446207, 428869, 466997, 446226, 459314, 428879, 446210, 430482, 459282, 428911, 428898, 428895, 428975, 459279, 428943, 439919, 441861, 428728, 429637, 428729, 439315, 428764, 442746, 439316, 470037, 495190, 456208, 259114, 428876, 446220, 441785, 428892, 465705, 439916, 446214, 446230, 442368, 446217, 428905, 467001, 445209, 446228, 434054, 428902, 446227, 459286, 446224, 428870, 432823, 466998, 430486, 446212, 446208, 459315, 428880, 446211, 459312, 433469, 459283, 428912, 428867, 446221, 428896, 459280, 428909, 446215, 446231, 439920, 428900, 428893, 439917, 456778, 452653, 459284, 428903, 440938, 441162, 428919, 446218, 429002, 459287, 434052, 428906, 429738, 467002, 428868, 466999, 428996, 433471, 441169, 446225, 459313, 446209, 433470, 428913, 428897, 459281, 473902, 441166, 446222, 428910, 459278, 428894, 439918, 446229, 433851, 505397, 446223, 433467, 446219, 428907, 439915, 446213, 454424, 446216, 446232, 428901, 428904, 467000); +UPDATE `gameobject_template` SET `Data8`=103828, `Data10`=30091, `VerifiedBuild`=61967 WHERE `entry`=249825; -- Black Rook Anvil +UPDATE `gameobject_template` SET `Data5`=114864, `VerifiedBuild`=61967 WHERE `entry`=271157; -- Portal to the Black Temple +UPDATE `gameobject_template` SET `Data4`=0, `VerifiedBuild`=61967 WHERE `entry`=179944; -- Meeting Stone Summoning Portal + +DELETE FROM `world_state` WHERE `ID` IN (25810, 26669); +INSERT INTO `world_state` (`ID`, `DefaultValue`, `MapIDs`, `Comment`) VALUES +(25810, 0, '-1', 'Arenas - Number of players ready'), +(26669, 0, '-1', 'Arenas - Maximum Number of players that need to be ready'); -- cgit v1.2.3