diff options
| -rw-r--r-- | sql/updates/world/master/2016_10_23_01_world.sql | 100 |
1 files changed, 100 insertions, 0 deletions
diff --git a/sql/updates/world/master/2016_10_23_01_world.sql b/sql/updates/world/master/2016_10_23_01_world.sql new file mode 100644 index 00000000000..5db0d726031 --- /dev/null +++ b/sql/updates/world/master/2016_10_23_01_world.sql @@ -0,0 +1,100 @@ +DELETE FROM `gameobject_template` WHERE `entry` IN (248024 /*Iridescent Dreamleaf*/, 251671 /*Candy Bucket*/, 247605 /*Flourishing Aethril*/, 236110 /*Steamworks Sausage Grill*/, 251670 /*Candy Bucket*/, 254938 /*6FX_Bonfire (scale x0.5) - Large*/, 246865 /*Basilisk Meat*/, 246874 /*Holding Pen*/, 251672 /*Candy Bucket*/, 249466 /*Stolen Nar'thalas Relic*/, 249464 /*Stolen Nar'thalas Relic*/, 249467 /*Stolen Nar'thalas Relic*/); +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 +(248024, 50, 34082, 'Iridescent 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), -- Iridescent Dreamleaf +(251671, 2, 6404, 'Candy Bucket', '', '', '', 1, 0, 20329, 0, 0, 0, 0, 0, 0, 0, 0, 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), -- Candy Bucket +(247605, 50, 35262, 'Flourishing 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), -- Flourishing Aethril +(236110, 8, 7385, 'Steamworks Sausage Grill', '', '', '', 1, 4, 10, 31442, 0, 0, 0, 0, 0, 0, 0, 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), -- Steamworks Sausage Grill +(251670, 2, 6404, 'Candy Bucket', '', '', '', 1, 0, 20328, 0, 0, 0, 0, 0, 0, 0, 0, 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), -- Candy Bucket +(254938, 5, 14672, '6FX_Bonfire (scale x0.5) - Large', '', '', '', 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, 22810), -- 6FX_Bonfire (scale x0.5) - Large +(246865, 10, 31803, 'Basilisk Meat', 'questinteract', 'Harvesting', '', 1, 93, 0, 0, 0, 0, 0, 0, 0, 0, 0, 203236, 0, 0, 0, 42231, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22810), -- Basilisk Meat +(246874, 10, 14674, 'Holding Pen', 'questinteract', 'Destroying', '', 0.25, 99, 0, 0, 3000, 0, 0, 0, 0, 0, 0, 203293, 0, 0, 0, 24585, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22810), -- Holding Pen +(251672, 2, 6404, 'Candy Bucket', '', '', '', 1, 0, 20330, 0, 0, 0, 0, 0, 0, 0, 0, 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), -- Candy Bucket +(249466, 3, 33399, 'Stolen Nar''thalas Relic', '', 'Recovering', '', 1, 1691, 65918, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 55091, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22810), -- Stolen Nar'thalas Relic +(249464, 3, 33398, 'Stolen Nar''thalas Relic', '', 'Recovering', '', 0.5, 1691, 65918, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 55091, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22810), -- Stolen Nar'thalas Relic +(249467, 3, 33401, 'Stolen Nar''thalas Relic', '', 'Recovering', '', 0.15, 1691, 65918, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 55091, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22810); -- Stolen Nar'thalas Relic + +UPDATE `gameobject_template` SET `Data5`=923, `VerifiedBuild`=22810 WHERE `entry`=182352; -- Portal to Silvermoon +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=180408; -- G_WitchHat_01 +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=180428; -- G_WitchBroom_01 scale 0.5 +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=186314; -- Loosely Turned Soil +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=186267; -- Pumpkin Shrine +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=214284; -- Blade of the Anointed +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=186327; -- Headless Horseman Pumpkin Table +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=186269; -- Headless Horseman Candle +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=181191; -- Skullpile 01 +UPDATE `gameobject_template` SET `Data8`=0, `VerifiedBuild`=22810 WHERE `entry`=210562; -- Doodad_MonestarySecretDoor01 +UPDATE `gameobject_template` SET `Data8`=0, `VerifiedBuild`=22810 WHERE `entry`=210563; -- Doodad_MonestaryBossDoor01 +UPDATE `gameobject_template` SET `Data8`=0, `VerifiedBuild`=22810 WHERE `entry`=210564; -- Doodad_ScarletCathedralDoor01 +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=214286; -- Aura Red Tall (scale x1.5) +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=214290; -- Pool Statue +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=214285; -- Blades of the Anointed Coffin +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=214289; -- Aura Yellow Tall (scale x1.5) +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=214287; -- Blade of the Anointed +UPDATE `gameobject_template` SET `Data8`=0, `VerifiedBuild`=22810 WHERE `entry`=211844; -- Graveyard Door +UPDATE `gameobject_template` SET `Data8`=1, `VerifiedBuild`=22810 WHERE `entry`=214508; -- Instance Portal (Party + Heroic + Challenge) +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=180523; -- Apple Bob +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=180411; -- G_Ghost_01 +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=180410; -- G_HangingSkeleton_01 +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=180429; -- G_WitchHat_01 scale 0.5 +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=180415; -- CandleBlack01 +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=180472; -- HangingSkullLight02 +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=180405; -- G_Pumpkin_01 +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=180407; -- G_Pumpkin_03 +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=180406; -- G_Pumpkin_02 +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=180523; -- Apple Bob +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=180411; -- G_Ghost_01 +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=180410; -- G_HangingSkeleton_01 +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=180429; -- G_WitchHat_01 scale 0.5 +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=180415; -- CandleBlack01 +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=180472; -- HangingSkullLight02 +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=180405; -- G_Pumpkin_01 +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=180407; -- G_Pumpkin_03 +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=180406; -- G_Pumpkin_02 +UPDATE `gameobject_template` SET `Data26`=1, `VerifiedBuild`=22810 WHERE `entry`=185010; -- Arcano Control Unit +UPDATE `gameobject_template` SET `Data26`=1, `VerifiedBuild`=22810 WHERE `entry`=185009; -- Arcano Control Unit +UPDATE `gameobject_template` SET `Data26`=1, `VerifiedBuild`=22810 WHERE `entry`=185008; -- Arcano Control Unit +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=184870; -- Baa'ri Tablet Fragment +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=184716; -- Coilskar Chest +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=184714; -- Ball and Chain +UPDATE `gameobject_template` SET `Data26`=1, `VerifiedBuild`=22810 WHERE `entry`=185058; -- Fel Reaver Control Console +UPDATE `gameobject_template` SET `Data26`=1, `VerifiedBuild`=22810 WHERE `entry`=185057; -- Fel Reaver Control Console +UPDATE `gameobject_template` SET `Data26`=1, `VerifiedBuild`=22810 WHERE `entry`=185034; -- Fel Reaver Control Console +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=184949; -- Doctor's Alchemy Table +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=184947; -- The Doctor's Strongbox +UPDATE `gameobject_template` SET `Data26`=1, `VerifiedBuild`=22810 WHERE `entry`=184979; -- Deathforged Infernal +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=182954; -- Brackish Mixed School +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=183151; -- Campfire +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=183155; -- Campfire +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=183154; -- Campfire +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=183132; -- Campfire +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=183153; -- Campfire +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=183152; -- Campfire +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=182581; -- Draenei Vessel +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=182583; -- Draenei Vessel +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=182582; -- Draenei Vessel +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=186114; -- Brazier +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=186115; -- Brazier +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=186011; -- Brazier +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=185511; -- Baby_Tr +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=185510; -- Baby_Ta +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=185509; -- Baby_Or +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=185508; -- Baby_Ne +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=185507; -- Baby_Hu +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=185506; -- Baby_Gn +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=186023; -- Bonfire +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=186010; -- Brazier +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=183433; -- Bonfire +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=186012; -- Brazier +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=186009; -- Brazier +UPDATE `gameobject_template` SET `VerifiedBuild`=22810 WHERE `entry`=186018; -- Brazier + +DELETE FROM `gameobject_questitem` WHERE (`GameObjectEntry`=249466 AND `Idx`=0) OR (`GameObjectEntry`=249464 AND `Idx`=0) OR (`GameObjectEntry`=249467 AND `Idx`=0); +INSERT INTO `gameobject_questitem` (`GameObjectEntry`, `Idx`, `ItemId`, `VerifiedBuild`) VALUES +(249466, 0, 136822, 22810), -- Stolen Nar'thalas Relic +(249464, 0, 136822, 22810), -- Stolen Nar'thalas Relic +(249467, 0, 136822, 22810); -- Stolen Nar'thalas Relic + +UPDATE `gameobject_questitem` SET `VerifiedBuild`=22810 WHERE (`GameObjectEntry`=214284 AND `Idx`=0); -- Blade of the Anointed +UPDATE `gameobject_questitem` SET `VerifiedBuild`=22810 WHERE (`GameObjectEntry`=184870 AND `Idx`=0); -- Baa'ri Tablet Fragment +UPDATE `gameobject_questitem` SET `VerifiedBuild`=22810 WHERE (`GameObjectEntry`=184947 AND `Idx`=0); -- The Doctor's Strongbox +UPDATE `gameobject_questitem` SET `VerifiedBuild`=22810 WHERE (`GameObjectEntry`=182581 AND `Idx`=0); -- Draenei Vessel |