DB/GameObjects: added template entries for the instanced version of Wintergrasp

1 files changed, 42 insertions, 0 deletions

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