DB/GameObjects: Add some gameobject_templates

- also updated older ones
- Add some Arena WorldStates

1 files changed, 25 insertions, 0 deletions

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');