DB/GameObjects: Updated gameobject_template data from 7.0.3

1 files changed, 85 insertions, 0 deletions

diff --git a/sql/updates/world/6.x/2016_10_15_02_world.sql b/sql/updates/world/6.x/2016_10_15_02_world.sql
new file mode 100644
index 00000000000..7bfaa3f858b
--- /dev/null
+++ b/sql/updates/world/6.x/2016_10_15_02_world.sql
@@ -0,0 +1,85 @@
+DELETE FROM `gameobject_template` WHERE `entry` IN (248019 /*Lively Aethril*/, 246433 /*Hearty Feast*/, 248004 /*Felwort*/, 245436 /*Collision PC Size*/, 248012 /*Felwort*/, 253119 /*Feasting Plate*/, 247370 /*Brimstone Destroyer Core*/, 251287 /*Massive Azsunian Pearl*/, 248009 /*Felwort*/, 248018 /*Bushy Foxflower*/, 248031 /*Iridescent Starlight Rose*/, 247898 /*Smoke*/, 247897 /*Singed Fjarnskaggl*/, 248020 /*Iridescent Aethril*/, 248029 /*Pungent Fjarnskaggl*/, 248044 /*Felhide Gargantuan*/, 247606 /*Flourishing Dreamleaf*/, 247999 /*Felwort*/);
+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`, `RequiredLevel`, `VerifiedBuild`) VALUES
+(248019, 50, 35262, 'Lively Aethril', '', '', '', 1, 29, 65104, 0, 0, 745, 795, 15, 0, 0, 0, 0, 0, 100, 1, 0, 0, 0, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 98, 22810), -- Lively Aethril
+(246433, 22, 22665, 'Hearty Feast', 'Interact', '', '', 0.8, 201599, 35, 1, 0, 0, 37750, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22810), -- Hearty Feast
+(248004, 3, 32112, 'Felwort', '', '', '', 1.2, 29, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 46864, 110, 3, 0, 0, 0, 800, 800, 0, 193384, 0, 0, 0, 62242, 0, 0, 98, 22810), -- Felwort
+(245436, 5, 7735, 'Collision PC Size', '', '', '', 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, 22810), -- Collision PC Size
+(248012, 3, 32112, 'Felwort', '', '', '', 1.2, 29, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 46857, 100, 1, 0, 0, 0, 800, 800, 0, 193384, 0, 0, 0, 62242, 0, 0, 98, 22810), -- Felwort
+(253119, 10, 25487, 'Feasting Plate', '', 'Drinking', '', 2, 2567, 0, 0, 0, 0, 0, 0, 0, 0, 0, 223418, 0, 0, 0, 21295, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22810), -- Feasting Plate
+(247370, 3, 25536, 'Brimstone Destroyer Core', '', '', '', 10, 38, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 46840, 110, 1, 0, 0, 0, 800, 800, 0, 205060, 0, 0, 0, 60612, 0, 0, 98, 22810), -- Brimstone Destroyer Core
+(251287, 3, 9559, 'Massive Azsunian Pearl', '', 'Recovering', '', 0.1, 1691, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 55091, 0, 0, 0, 110, 3, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 66584, 0, 0, 98, 22810), -- Massive Azsunian Pearl
+(248009, 3, 32112, 'Felwort', '', '', '', 1.2, 29, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 46848, 110, 3, 0, 0, 0, 800, 800, 0, 193384, 0, 0, 0, 62242, 0, 0, 98, 22810), -- Felwort
+(248018, 50, 31228, 'Bushy Foxflower', '', '', '', 1.8, 29, 65106, 0, 0, 745, 795, 15, 0, 0, 0, 0, 0, 100, 1, 0, 0, 0, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 98, 22810), -- Bushy Foxflower
+(248031, 50, 36132, 'Iridescent Starlight Rose', '', '', '', 1.8, 29, 65108, 0, 0, 765, 795, 15, 0, 0, 0, 0, 0, 100, 1, 0, 0, 0, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 98, 22810), -- Iridescent Starlight Rose
+(247898, 6, 16853, 'Smoke', '', '', '', 0.5, 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, 0, 22810), -- Smoke
+(247897, 50, 30942, 'Singed Fjarnskaggl', '', '', '', 1, 29, 65273, 0, 0, 745, 795, 15, 0, 0, 0, 0, 0, 100, 1, 0, 0, 0, 0, 10, 0, 247898, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 98, 22810), -- Singed Fjarnskaggl
+(248020, 50, 35262, 'Iridescent Aethril', '', '', '', 1, 29, 65104, 0, 0, 745, 795, 15, 0, 0, 0, 0, 0, 100, 1, 0, 0, 0, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 98, 22810), -- Iridescent Aethril
+(248029, 50, 30942, 'Pungent Fjarnskaggl', '', '', '', 1.8, 29, 65107, 0, 0, 745, 795, 15, 0, 0, 0, 0, 0, 100, 1, 0, 0, 0, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 98, 22810), -- Pungent Fjarnskaggl
+(248044, 3, 32149, 'Felhide Gargantuan', '', 'Skinning', '', 5, 2502, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 106243, 0, 0, 46835, 0, 0, 0, 0, 0, 0, 0, 0, 205285, 0, 0, 0, 64558, 0, 0, 0, 22810), -- Felhide Gargantuan
+(247606, 50, 34082, 'Flourishing Dreamleaf', '', '', '', 1.8, 29, 65105, 0, 0, 745, 795, 15, 0, 0, 0, 0, 0, 100, 1, 0, 0, 0, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 98, 22810), -- Flourishing Dreamleaf
+(247999, 3, 32112, 'Felwort', '', '', '', 1.2, 29, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 46838, 110, 3, 0, 0, 0, 800, 800, 0, 193384, 0, 0, 0, 62242, 0, 0, 98, 22810); -- Felwort
+
+UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=183877; -- Ethereal Transporter Control Panel
+UPDATE `gameobject_template` SET `Data8`=0, `VerifiedBuild`=22810 WHERE `entry`=185519; -- Mana-Tombs Stasis Chamber
+UPDATE `gameobject_template` SET `Data8`=0, `VerifiedBuild`=22810 WHERE `entry`=185522; -- Shaffar's Stasis Chamber
+UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=185460; -- Ethereum Prison Base Group (Global)
+UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=181671; -- Fel Horde Banner
+UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=181439; -- Doodad_OnyziasLairLavaTrap72
+UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=181438; -- Doodad_OnyziasLairLavaTrap64
+UPDATE `gameobject_template` SET `Data8`=0, `VerifiedBuild`=22810 WHERE `entry`=182540; -- Grand Warlock Chamber Door
+UPDATE `gameobject_template` SET `Data8`=0, `VerifiedBuild`=22810 WHERE `entry`=182539; -- Grand Warlock Chamber Door
+UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=181442; -- Doodad_OnyziasLairLavaTrap83
+UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=181441; -- Doodad_OnyziasLairLavaTrap82
+UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=181440; -- Doodad_OnyziasLairLavaTrap81
+UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=181437; -- Doodad_OnyziasLairLavaTrap78
+UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=181436; -- Doodad_OnyziasLairLavaTrap79
+UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=181435; -- Doodad_OnyziasLairLavaTrap80
+UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=211498; -- Instance Portal (Party + Heroic)
+UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=182094; -- Cage
+UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=185292; -- Skar'this's Prison
+UPDATE `gameobject_template` SET `type`=50, `Data3`=0, `Data4`=350, `Data5`=400, `Data6`=15, `Data12`=65, `Data13`=1, `Data18`=10, `Data19`=0, `Data23`=0, `Data24`=0, `VerifiedBuild`=22810 WHERE `entry`=181275; -- Ragveil
+UPDATE `gameobject_template` SET `type`=50, `Data3`=0, `Data4`=0, `Data5`=0, `Data6`=15, `Data12`=67, `Data13`=1, `Data18`=10, `Data19`=0, `VerifiedBuild`=22810 WHERE `entry`=181276; -- Flame Cap
+UPDATE `gameobject_template` SET `type`=50, `Data3`=0, `Data4`=365, `Data5`=415, `Data6`=15, `Data12`=68, `Data13`=1, `Data18`=10, `Data19`=0, `Data23`=0, `Data24`=0, `VerifiedBuild`=22810 WHERE `entry`=181278; -- Ancient Lichen
+UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=187215; -- Bench
+UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=187214; -- Bench
+UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=187207; -- Bench
+UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=187206; -- Bench
+UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=187578; -- Scrying Orb
+UPDATE `gameobject_template` SET `Data8`=0, `VerifiedBuild`=22810 WHERE `entry`=188166; -- Doodad_Kael_Explode_FX_Right01
+UPDATE `gameobject_template` SET `Data8`=0, `VerifiedBuild`=22810 WHERE `entry`=188165; -- Doodad_Kael_Explode_FX_Left01
+UPDATE `gameobject_template` SET `Data8`=0, `VerifiedBuild`=22810 WHERE `entry`=188065; -- Assembly Chamber Door
+UPDATE `gameobject_template` SET `Data8`=0, `VerifiedBuild`=22810 WHERE `entry`=188064; -- Asylum Door
+UPDATE `gameobject_template` SET `Data8`=0, `VerifiedBuild`=22810 WHERE `entry`=187770; -- Doodad_SunwellRaid_Gate_04
+UPDATE `gameobject_template` SET `Data8`=0, `VerifiedBuild`=22810 WHERE `entry`=188075; -- Doodad_Sunwell_Fire_Barrier_ext01
+UPDATE `gameobject_template` SET `Data8`=0, `VerifiedBuild`=22810 WHERE `entry`=187990; -- Doodad_SunwellRaid_Gate_07
+UPDATE `gameobject_template` SET `Data8`=0, `VerifiedBuild`=22810 WHERE `entry`=187979; -- Doodad_SunwellRaid_Gate_02
+UPDATE `gameobject_template` SET `Data8`=0, `VerifiedBuild`=22810 WHERE `entry`=187896; -- Doodad_SunwellRaid_Gate_05
+UPDATE `gameobject_template` SET `Data8`=0, `VerifiedBuild`=22810 WHERE `entry`=187766; -- Agamath, The First Gate
+UPDATE `gameobject_template` SET `Data8`=0, `VerifiedBuild`=22810 WHERE `entry`=188524; -- Doodad_Sunwell_BossCollision02
+UPDATE `gameobject_template` SET `Data8`=0, `VerifiedBuild`=22810 WHERE `entry`=188523; -- Doodad_Sunwell_BossCollision01
+UPDATE `gameobject_template` SET `Data8`=0, `VerifiedBuild`=22810 WHERE `entry`=188421; -- Doodad_Sunwell_BossForceField01
+UPDATE `gameobject_template` SET `Data8`=0, `VerifiedBuild`=22810 WHERE `entry`=188119; -- Doodad_Sunwell_Ice_Barrier01
+UPDATE `gameobject_template` SET `Data8`=0, `VerifiedBuild`=22810 WHERE `entry`=188118; -- Doodad_SunwellRaid_Gate_08
+UPDATE `gameobject_template` SET `Data8`=0, `VerifiedBuild`=22810 WHERE `entry`=188081; -- Sanctum Planetarium
+UPDATE `gameobject_template` SET `Data8`=0, `VerifiedBuild`=22810 WHERE `entry`=187765; -- Archonisus, The Third Gate
+UPDATE `gameobject_template` SET `Data8`=0, `VerifiedBuild`=22810 WHERE `entry`=187764; -- Rohendor, The Second Gate
+UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=188173; -- Escape to the Isle of Quel'Danas
+UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=185103; -- Dark Portal
+UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=186002; -- Brazier
+UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=186001; -- Brazier
+UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=186000; -- Brazier
+UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=185999; -- Brazier
+UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=185974; -- Brazier
+UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=185973; -- Brazier
+UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=185170; -- The Mark of Kael'Thas
+UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=180611; -- Doodad_GeneralChairLoEnd05
+UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=180610; -- Doodad_GeneralChairLoEnd04
+UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=180609; -- Doodad_GeneralChairLoEnd02
+UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=186393; -- L70ETC Bleachers
+
+DELETE FROM `gameobject_questitem` WHERE (`GameObjectEntry`=251287 AND `Idx`=0);
+INSERT INTO `gameobject_questitem` (`GameObjectEntry`, `Idx`, `ItemId`, `VerifiedBuild`) VALUES
+(251287, 0, 138398, 22810); -- Massive Azsunian Pearl
+
+UPDATE `gameobject_questitem` SET `VerifiedBuild`=22810 WHERE (`GameObjectEntry`=181671 AND `Idx`=0); -- Fel Horde Banner
+