aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2025_07_20_00_world.sql25
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');