DB/Template: Update gameobject_template

Part 7

1 files changed, 38 insertions, 0 deletions

diff --git a/sql/updates/world/master/2020_12_27_00_world.sql b/sql/updates/world/master/2020_12_27_00_world.sql
new file mode 100644
index 00000000000..7c1acf57c9a
--- /dev/null
+++ b/sql/updates/world/master/2020_12_27_00_world.sql
@@ -0,0 +1,38 @@
+DELETE FROM `gameobject_template` WHERE `entry` IN (302954 /*Blacktooth Brawler Stash*/, 291242 /*Barrel of Coal*/);
+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`, `ContentTuningId`, `VerifiedBuild`) VALUES
+(302954, 3, 51775, 'Blacktooth Brawler Stash', '', 'Opening', '', 1, 57, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 21400, 0, 0, 0, 705, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3287, 93636, 0, 0, 0, 0, 27980), -- Blacktooth Brawler Stash
+(291242, 3, 43391, 'Barrel of Coal', 'questinteract', 'Collecting', '', 1, 1690, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 19676, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 88451, 0, 0, 0, 0, 27980); -- Barrel of Coal
+
+UPDATE `gameobject_template` SET `VerifiedBuild`=27980 WHERE `entry` IN (282629, 282629, 290412, 252998, 234276, 290147, 290138, 291072, 290541, 294174, 284470, 246433, 293341, 291135, 293010, 293009, 290126, 271941, 290132, 281902, 290827, 281908, 281878, 301088, 281886, 281884, 271938, 271939, 302842, 206912, 215457, 278310, 278311, 278330, 278327, 278326, 278325, 278332, 273853, 278324, 278333, 278329, 278331, 273855, 298865, 278328);
+
+DELETE FROM `gameobject_template` WHERE `entry` IN (293802 /*Sweete's Lockbox*/, 293343 /*Sweete's Lockbox*/, 296053 /*Chair*/, 296252 /*Box of Large Azerite Grenades*/, 293134 /*Large Azerite Grenade*/, 302841 /*Ashvane Ship*/, 298962 /*Ashvane Ship*/, 292768 /*Broken Pillar*/, 290547 /*Stone Circle*/, 302812 /*Invisible Door*/, 290543 /*Witch Fog*/, 302835 /*Drust Stone*/, 290546 /*Skull Brazier*/, 290548 /*Drust Stone*/, 290542 /*Witch FX Energy (Large)*/, 292696 /*Fog*/, 294175 /*Portal to the Blighted Lands*/, 293425 /*Drust Effigy*/, 294309 /*Jaina's Staff*/, 294082 /*Lift Ritual Lantern*/, 294083 /*Use Ritual Knife*/, 294081 /*Ring Ritual Bell*/, 294080 /*Scroll of Safe Passage*/, 291260 /*Myra's Favorite Pick*/);
+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`, `ContentTuningId`, `VerifiedBuild`) VALUES
+(293802, 5, 25466, 'Sweete\'s Lockbox', '', '', '', 1, 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, 0, 0, 0, 0, 0, 28153), -- Sweete's Lockbox
+(293343, 10, 25466, 'Sweete\'s Lockbox', 'questinteract', 'Opening', '', 1, 93, 0, 0, 0, 0, 0, 0, 0, 0, 0, 275309, 0, 0, 0, 21400, 0, 0, 0, 0, 0, 0, 0, 62481, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 28153), -- Sweete's Lockbox
+(296053, 7, 648, 'Chair', '', '', '', 1, 1, 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, 28153), -- Chair
+(296252, 3, 49819, 'Box of Large Azerite Grenades', 'questinteract', 'Collecting', '', 1, 43, 0, 1, 0, 0, 0, 0, 0, 52252, 0, 0, 0, 0, 0, 19676, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 92414, 1, 0, 0, 0, 28153), -- Box of Large Azerite Grenades
+(293134, 3, 50483, 'Large Azerite Grenade', 'questinteract', 'Collecting', '', 1.20000004768371582, 43, 0, 0, 0, 0, 0, 0, 0, 52252, 0, 0, 0, 0, 0, 19676, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 89209, 1, 0, 0, 0, 28153), -- Large Azerite Grenade
+(302841, 43, 52705, 'Ashvane Ship', '', '', '', 1, -1, 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, 0, 0, 0, 0, 28153), -- Ashvane Ship
+(298962, 43, 52706, 'Ashvane Ship', '', '', '', 1, -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, 28153), -- Ashvane Ship
+(292768, 5, 50344, 'Broken Pillar', 'questinteract', '', '', 0.33000001311302185, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28153), -- Broken Pillar
+(290547, 5, 49535, 'Stone Circle', 'questinteract', '', '', 1.5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28153), -- Stone Circle
+(302812, 0, 14501, 'Invisible Door', '', '', '', 1, 0, 0, 3000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28153), -- Invisible Door
+(290543, 5, 35067, 'Witch Fog', '', '', '', 1.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, 28153), -- Witch Fog
+(302835, 5, 49311, 'Drust Stone', 'questinteract', '', '', 0.660000026226043701, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28153), -- Drust Stone
+(290546, 5, 20764, 'Skull Brazier', 'questinteract', '', '', 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28153), -- Skull Brazier
+(290548, 5, 46359, 'Drust Stone', 'questinteract', '', '', 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, 28153), -- Drust Stone
+(290542, 5, 49332, 'Witch FX Energy (Large)', 'questinteract', '', '', 2, 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, 0, 0, 0, 28153), -- Witch FX Energy (Large)
+(292696, 5, 50329, 'Fog', '', '', '', 0.5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28153), -- Fog
+(294175, 10, 49333, 'Portal to the Blighted Lands', 'questinteract', '', '', 1.5, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 271921, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 63012, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28153), -- Portal to the Blighted Lands
+(293425, 10, 45104, 'Drust Effigy', 'questinteract', 'Placing', '', 2.20000004768371582, 1691, 0, 0, 3000, 0, 0, 0, 0, 0, 0, 278043, 0, 0, 0, 35196, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28153), -- Drust Effigy
+(294309, 10, 51329, 'Jaina\'s Staff', 'questinteract', 'Searching for Clues', '', 1, 93, 0, 0, 1, 0, 0, 0, 0, 0, 0, 278162, 0, 0, 0, 92145, 0, 0, 0, 0, 0, 1, 0, 64207, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28153), -- Jaina's Staff
+(294082, 5, 9806, 'Lift Ritual Lantern', '', '', '', 1, 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, 0, 0, 0, 0, 0, 28153), -- Lift Ritual Lantern
+(294083, 5, 9806, 'Use Ritual Knife', '', '', '', 1, 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, 0, 0, 0, 0, 0, 28153), -- Use Ritual Knife
+(294081, 5, 9806, 'Ring Ritual Bell', '', '', '', 1, 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, 0, 0, 0, 0, 0, 28153), -- Ring Ritual Bell
+(294080, 9, 36780, 'Scroll of Safe Passage', '', '', '', 1, 7818, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28153), -- Scroll of Safe Passage
+(291260, 3, 14746, 'Myra\'s Favorite Pick', 'questinteract', 'Retrieving', '', 1, 43, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 23645, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 88461, 0, 0, 0, 0, 28153); -- Myra's Favorite Pick
+
+UPDATE `gameobject_template` SET `name`='Portal to Exodar' WHERE `entry`=246003; -- Portal to Exodar
+UPDATE `gameobject_template` SET `name`='Portal to Ironforge' WHERE `entry`=245998; -- Portal to Ironforge
+
+UPDATE `gameobject_template` SET `VerifiedBuild`=28153 WHERE `entry` IN (296915, 294025, 294027, 294026, 279357, 289447, 289556, 279620, 298982, 298981, 295078, 295077, 295076, 295075, 295422, 295403, 295427, 295404, 295426, 295405, 295413, 295406, 297906, 299321, 279347, 209076, 235882, 197094, 197095, 195141, 267266, 295217, 298982, 298981, 295077, 295075, 295078, 295076, 295422, 295403, 295404, 295427, 295426, 295405, 295413, 295406, 297906, 299321, 279347, 293010, 293009, 278682, 280603, 297149, 297148, 297709, 297142, 297143, 296227, 296226, 293317, 281347, 281346, 281345, 281344, 281342, 281341, 281335, 293327, 293333, 281317, 281343, 281336, 293330, 293328, 293329, 293334, 293332, 293331, 281305, 296874, 281879, 296625, 289556, 289447, 290147, 296381, 207310, 287195, 279882, 279895, 279620, 297935, 297893, 294025, 294027, 294026, 279357, 296915, 291223, 289708, 296694, 296695, 296697, 296696, 296700, 296699, 296711, 296710, 296709, 296708, 296707, 296705, 296704, 273814, 295081, 295082, 295084, 295083, 273766, 277389, 291222, 296918, 272792, 296701, 277352, 278482, 290532, 298982, 298981, 295075, 295077, 295076, 295078, 295427, 295426, 295422, 295403, 295404, 297906, 295405, 295406, 295413, 299321, 279347, 294027, 294026, 294025, 279357, 296915, 298768, 278735, 277727, 296918, 291222, 278738, 273050, 272792, 291223, 277897, 296706, 289701, 277896, 277894, 289708, 296711, 296710, 296709, 296705, 296694, 296695, 296700, 296699, 296697, 296696, 296708, 296707, 296704, 273814, 295081, 295084, 295082, 273766, 295083, 278482, 296701, 277352, 270960, 270961, 270959, 277389, 303037, 303036, 303035, 303034, 303033, 303032, 277459, 289564, 291045, 291042, 289565, 289563, 291044, 289569, 289568, 297826, 292408, 292409, 292407, 292405, 296161, 293892, 294028, 294032, 281635, 281473, 297149, 297148, 297709, 281482, 297142, 297143, 282452, 293208, 289447, 289556, 296625, 288595, 303170, 282151, 281879, 279302, 303039, 185903, 289577, 294173, 290138, 290147, 296381, 207310, 288609);