From 041ffc39f19e5e92658310d51fe3ea52e55423ef Mon Sep 17 00:00:00 2001 From: Ovahlord Date: Tue, 8 Apr 2025 22:15:46 +0200 Subject: DB/GameObjects: added template entries for the instanced version of Wintergrasp --- .../world/cata_classic/2025_04_08_00_world.sql | 42 ++++++++++++++++++++++ 1 file changed, 42 insertions(+) create mode 100644 sql/updates/world/cata_classic/2025_04_08_00_world.sql (limited to 'sql') diff --git a/sql/updates/world/cata_classic/2025_04_08_00_world.sql b/sql/updates/world/cata_classic/2025_04_08_00_world.sql new file mode 100644 index 00000000000..c541197d478 --- /dev/null +++ b/sql/updates/world/cata_classic/2025_04_08_00_world.sql @@ -0,0 +1,42 @@ +DELETE FROM `gameobject_template` WHERE `entry` IN (377723 /*377723*/, 377649 /*Wintergrasp Fortress Wall*/, 377853 /*Wintergrasp Fortress Wall*/, 377854 /*Wintergrasp Fortress Tower*/, 377819 /*Wintergrasp Fortress Wall*/, 377816 /*Wintergrasp Fortress Tower*/, 377811 /*Wintergrasp Fortress Wall*/, 377670 /*Wintergrasp Wall*/, 377646 /*Wintergrasp Fortress Wall*/, 377787 /*Shadowsight Tower*/, 377622 /*Wintergrasp Wall*/, 377845 /*Wintergrasp Fortress Wall*/, 377818 /*Wintergrasp Fortress Wall*/, 377618 /*Goblin Workshop*/, 377675 /*Wintergrasp Fortress Wall*/, 377659 /*Wintergrasp Fortress Wall*/, 377640 /*Wintergrasp Fortress Wall*/, 377837 /*Wintergrasp Fortress Wall*/, 377661 /*Wintergrasp Fortress Wall*/, 377674 /*Goblin Workshop*/, 377653 /*Wintergrasp Fortress Wall*/, 377828 /*Wintergrasp Fortress Gate*/, 377872 /*Wintergrasp Fortress Tower*/, 377650 /*Goblin Workshop*/, 377624 /*Wintergrasp Wall*/, 377642 /*Goblin Workshop*/, 377804 /*Wintergrasp Fortress Wall*/, 377626 /*Flamewatch Tower*/, 377741 /*Anvil*/, 377788 /*Wintergrasp Fortress Wall*/, 377636 /*Wintergrasp Fortress Wall*/, 377840 /*Wintergrasp Fortress Wall*/, 377671 /*Wintergrasp Fortress Tower*/, 377655 /*Wintergrasp Fortress Wall*/, 377631 /*Goblin Workshop*/, 377623 /*Winter's Edge Tower*/, 377628 /*Wintergrasp Fortress Wall*/, 377620 /*Wintergrasp Fortress Wall*/, 377660 /*Goblin Workshop*/, 377841 /*Wintergrasp Fortress Door*/); +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 +(377723, 8, 4251, '', '', '', '', 1, 4, 10, 2066, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60142), -- 377723 +(377649, 33, 7877, 'Wintergrasp Fortress Wall', '', '', '', 1, 0, 0, 3, 19885, 7897, 0, 1, 0, 0, 19899, 7874, 1, 0, 0, 19913, 0, 0, 0, 31, 0, 0, 0, 19447, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60142), -- Wintergrasp Fortress Wall +(377853, 33, 7877, 'Wintergrasp Fortress Wall', '', '', '', 1, 0, 0, 3, 19888, 7897, 0, 1, 0, 0, 19902, 7874, 1, 0, 0, 19916, 0, 0, 0, 31, 0, 0, 0, 19447, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60142), -- Wintergrasp Fortress Wall +(377854, 33, 7878, 'Wintergrasp Fortress Tower', '', '', '', 1, 0, 0, 12, 19668, 1, 0, 1, 1, 0, 19660, 1, 1, 0, 0, 19664, 0, 0, 0, 55, 0, 0, 0, 19457, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60142), -- Wintergrasp Fortress Tower +(377819, 33, 7877, 'Wintergrasp Fortress Wall', '', '', '', 1, 0, 0, 3, 19891, 7897, 0, 1, 0, 0, 19905, 7874, 1, 0, 0, 19919, 0, 0, 0, 31, 0, 0, 0, 19447, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60142), -- Wintergrasp Fortress Wall +(377816, 33, 7878, 'Wintergrasp Fortress Tower', '', '', '', 1, 0, 0, 12, 19667, 1, 0, 1, 1, 0, 19659, 1, 1, 0, 0, 19662, 0, 0, 0, 55, 0, 0, 0, 19459, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60142), -- Wintergrasp Fortress Tower +(377811, 33, 7877, 'Wintergrasp Fortress Wall', '', '', '', 1, 0, 0, 3, 19889, 7897, 0, 1, 0, 0, 19903, 7874, 1, 0, 0, 19917, 0, 0, 0, 31, 0, 0, 0, 19447, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60142), -- Wintergrasp Fortress Wall +(377670, 33, 7909, 'Wintergrasp Wall', '', '', '', 1, 0, 0, 18, 19925, 8186, 0, 1, 0, 0, 19934, 7908, 1, 0, 0, 19943, 0, 0, 0, 40, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60142), -- Wintergrasp Wall +(377646, 33, 7877, 'Wintergrasp Fortress Wall', '', '', '', 1, 0, 0, 3, 19883, 7897, 0, 1, 0, 0, 19897, 7874, 1, 0, 0, 19911, 0, 0, 0, 31, 0, 0, 0, 19447, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60142), -- Wintergrasp Fortress Wall +(377787, 33, 7900, 'Shadowsight Tower', '', '', '', 1, 0, 35074, 16, 19671, 1, 0, 1, 1, 0, 19674, 1, 1, 0, 0, 19677, 0, 0, 0, 54, 0, 0, 0, 19680, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60142), -- Shadowsight Tower +(377622, 33, 7909, 'Wintergrasp Wall', '', '', '', 1, 0, 0, 18, 19928, 8186, 0, 1, 0, 0, 19937, 7908, 1, 0, 0, 19946, 0, 0, 0, 40, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60142), -- Wintergrasp Wall +(377845, 33, 7877, 'Wintergrasp Fortress Wall', '', '', '', 1, 0, 0, 3, 19887, 7897, 0, 1, 0, 0, 19901, 7874, 1, 0, 0, 19915, 0, 0, 0, 31, 0, 0, 0, 19447, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60142), -- Wintergrasp Fortress Wall +(377818, 33, 7877, 'Wintergrasp Fortress Wall', '', '', '', 1, 0, 0, 3, 19893, 7897, 0, 1, 0, 0, 19907, 7874, 1, 0, 0, 19921, 0, 0, 0, 31, 0, 0, 0, 19447, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60142), -- Wintergrasp Fortress Wall +(377618, 33, 8208, 'Goblin Workshop', '', '', '', 1, 0, 0, 13, 19790, 1, 0, 1, 0, 0, 19782, 1, 1, 0, 0, 19786, 0, 0, 0, 45, 0, 0, 0, 19794, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60142), -- Goblin Workshop +(377675, 33, 7877, 'Wintergrasp Fortress Wall', '', '', '', 1, 0, 0, 3, 19882, 7897, 0, 1, 0, 0, 19896, 7874, 1, 0, 0, 19910, 0, 0, 0, 31, 0, 0, 0, 19447, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60142), -- Wintergrasp Fortress Wall +(377659, 33, 7877, 'Wintergrasp Fortress Wall', '', '', '', 1, 0, 0, 3, 19927, 7897, 0, 1, 0, 0, 19936, 7874, 1, 0, 0, 19945, 0, 0, 0, 31, 0, 0, 0, 19447, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60142), -- Wintergrasp Fortress Wall +(377640, 33, 7877, 'Wintergrasp Fortress Wall', '', '', '', 1, 0, 0, 3, 19930, 7897, 0, 1, 0, 0, 19939, 7874, 1, 0, 0, 19948, 0, 0, 0, 31, 0, 0, 0, 19447, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60142), -- Wintergrasp Fortress Wall +(377837, 33, 7877, 'Wintergrasp Fortress Wall', '', '', '', 1, 0, 0, 3, 19929, 7897, 0, 1, 0, 0, 19938, 7874, 1, 0, 0, 19947, 0, 0, 0, 31, 0, 0, 0, 19447, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60142), -- Wintergrasp Fortress Wall +(377661, 33, 7877, 'Wintergrasp Fortress Wall', '', '', '', 1, 0, 0, 3, 19884, 7897, 0, 1, 0, 0, 19898, 7874, 1, 0, 0, 19912, 0, 0, 0, 31, 0, 0, 0, 19447, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60142), -- Wintergrasp Fortress Wall +(377674, 33, 8208, 'Goblin Workshop', '', '', '', 1, 0, 0, 13, 19792, 1, 0, 1, 0, 0, 19784, 1, 1, 0, 0, 19788, 0, 0, 0, 45, 0, 0, 0, 19796, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60142), -- Goblin Workshop +(377653, 33, 7877, 'Wintergrasp Fortress Wall', '', '', '', 1, 0, 0, 3, 19926, 7897, 0, 1, 0, 0, 19935, 7874, 1, 0, 0, 19944, 0, 0, 0, 31, 0, 0, 0, 19447, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60142), -- Wintergrasp Fortress Wall +(377828, 33, 7906, 'Wintergrasp Fortress Gate', '', '', '', 1, 0, 0, 4, 19958, 8198, 0, 1, 0, 0, 19956, 7855, 1, 0, 0, 19957, 0, 0, 0, 42, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60142), -- Wintergrasp Fortress Gate +(377872, 33, 7878, 'Wintergrasp Fortress Tower', '', '', '', 1, 0, 0, 12, 19666, 1, 0, 1, 1, 0, 19658, 1, 1, 0, 0, 19663, 0, 0, 0, 55, 0, 0, 0, 19458, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60142), -- Wintergrasp Fortress Tower +(377650, 33, 8208, 'Goblin Workshop', '', '', '', 1, 0, 0, 13, 19775, 1, 0, 1, 0, 0, 19777, 1, 1, 0, 0, 19779, 0, 300, 0, 45, 0, 0, 0, 19781, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60142), -- Goblin Workshop +(377624, 33, 7909, 'Wintergrasp Wall', '', '', '', 1, 0, 0, 18, 19931, 8186, 0, 1, 0, 0, 19940, 7908, 1, 0, 0, 19949, 0, 0, 0, 40, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60142), -- Wintergrasp Wall +(377642, 33, 8208, 'Goblin Workshop', '', '', '', 1, 0, 0, 14, 19774, 1, 0, 1, 0, 0, 19776, 1, 1, 0, 0, 19778, 0, 300, 0, 45, 0, 0, 0, 19780, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60142), -- Goblin Workshop +(377804, 33, 7877, 'Wintergrasp Fortress Wall', '', '', '', 1, 0, 0, 3, 19890, 7897, 0, 1, 0, 0, 19904, 7874, 1, 0, 0, 19918, 0, 0, 0, 31, 0, 0, 0, 19447, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60142), -- Wintergrasp Fortress Wall +(377626, 33, 7900, 'Flamewatch Tower', '', '', '', 1, 0, 35074, 16, 19669, 1, 0, 1, 1, 0, 19672, 1, 1, 0, 0, 19675, 0, 0, 0, 39, 0, 0, 0, 19678, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60142), -- Flamewatch Tower +(377741, 8, 166, 'Anvil', '', '', '', 1, 1, 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, 60142), -- Anvil +(377788, 33, 7877, 'Wintergrasp Fortress Wall', '', '', '', 1, 0, 0, 3, 19895, 7897, 0, 1, 0, 0, 19909, 7874, 1, 0, 0, 19923, 0, 0, 0, 31, 0, 0, 0, 19447, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60142), -- Wintergrasp Fortress Wall +(377636, 33, 7877, 'Wintergrasp Fortress Wall', '', '', '', 1, 0, 0, 3, 19886, 7897, 0, 1, 0, 0, 19900, 7874, 1, 0, 0, 19914, 0, 0, 0, 31, 0, 0, 0, 19447, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60142), -- Wintergrasp Fortress Wall +(377840, 33, 7877, 'Wintergrasp Fortress Wall', '', '', '', 1, 0, 0, 3, 19894, 7897, 0, 1, 0, 0, 19908, 7874, 1, 0, 0, 19922, 0, 0, 0, 31, 0, 0, 0, 19447, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60142), -- Wintergrasp Fortress Wall +(377671, 33, 7878, 'Wintergrasp Fortress Tower', '', '', '', 1, 0, 0, 12, 19665, 1, 0, 1, 1, 0, 19657, 1, 1, 0, 0, 19661, 0, 0, 0, 55, 0, 0, 0, 19460, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60142), -- Wintergrasp Fortress Tower +(377655, 33, 7877, 'Wintergrasp Fortress Wall', '', '', '', 1, 0, 0, 3, 19932, 7897, 0, 1, 0, 0, 19941, 7874, 1, 0, 0, 19950, 0, 0, 0, 31, 0, 0, 0, 19447, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60142), -- Wintergrasp Fortress Wall +(377631, 33, 8208, 'Goblin Workshop', '', '', '', 1, 0, 0, 13, 19791, 1, 0, 1, 0, 0, 19783, 1, 1, 0, 0, 19787, 0, 0, 0, 45, 0, 0, 0, 19795, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60142), -- Goblin Workshop +(377623, 33, 7900, 'Winter\'s Edge Tower', '', '', '', 1, 0, 35074, 16, 19670, 1, 0, 1, 1, 0, 19673, 1, 1, 0, 0, 19676, 0, 0, 0, 54, 0, 0, 0, 19679, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60142), -- Winter's Edge Tower +(377628, 33, 7877, 'Wintergrasp Fortress Wall', '', '', '', 1, 0, 0, 3, 19924, 7897, 0, 1, 0, 0, 19933, 7874, 1, 0, 0, 19942, 0, 0, 0, 31, 0, 0, 0, 19447, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60142), -- Wintergrasp Fortress Wall +(377620, 33, 7877, 'Wintergrasp Fortress Wall', '', '', '', 1, 0, 0, 23, 19892, 7897, 0, 1, 0, 0, 19906, 7874, 1, 0, 0, 19920, 0, 0, 0, 31, 0, 0, 0, 19447, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60142), -- Wintergrasp Fortress Wall +(377660, 33, 8208, 'Goblin Workshop', '', '', '', 1, 0, 0, 13, 19793, 1, 0, 0, 0, 0, 19785, 1, 1, 0, 0, 19789, 0, 0, 0, 44, 0, 0, 0, 19797, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60142), -- Goblin Workshop +(377841, 33, 8165, 'Wintergrasp Fortress Door', '', '', '', 1, 0, 0, 22, 19955, 1, 0, 1, 0, 0, 19448, 1, 1, 0, 0, 19607, 0, 0, 0, 37, 0, 0, 0, 19448, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60142); -- Wintergrasp Fortress Door -- cgit v1.2.3