rendered paste body-- Entry Into KarazhanUPDATE `gameobject_template` SET `flags` = 0 WHERE `entry` = 182196;-- The Second and Third FragmentsUPDATE `gameobject_template` SET `flags` = 0 WHERE `entry` = 182198;-- The Master's TouchREPLACE INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`, `ReqSourceCount4`, `ReqSourceRef1`, `ReqSourceRef2`, `ReqSourceRef3`, `ReqSourceRef4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `ReqSpellCast1`, `ReqSpellCast2`, `ReqSpellCast3`, `ReqSpellCast4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `StartScript`, `CompleteScript`) VALUES (9836, 1941, 69, 70, 81, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 130, 0, 9832, 0, 0, 9837, 24489, 1, 0, 'The Master\'s Touch', 'I\'ve put together the very key I used as an apprentice. It looks completely functional as far as keys go. In regards to opening Karazhan, however, this might as well be a piece of scrap metal.$B$BWithout Medivh\'s consent, the key is worthless. Yes, of course I know Medivh is dead. This merely makes things difficult, not impossible.$B$BThere is a place in Azeroth called the Caverns of Time, guarded by the bronze dragonflight. Find a way inside, travel back in time and get Medivh to enable the key.', 'Go into the Caverns of Time and convince Medivh to enable your Restored Apprentice\'s Key.', 'That key, I recognize it. That is Kadghar\'s key... of course I haven\'t given it to him yet.', 'Who are you and what do you want?', 'Master\'s Touch', '', '', '', '', 24489, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 967, 0, 0, 0, 0, 350, 0, 0, 0, 0, 0, 94800, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);[6:12:33 PM] plamen spune: DELETE FROM `gameobject` WHERE `id` = '186733';INSERT INTO `gameobject` VALUES (NULL, 186733, 568, -150.842, 1343.26, 49.7888, 3.48383, 0, 0, 0.985395, -0.170283, 25, 0, 1);DELETE FROM gameobject_loot_template WHERE entry = 22883;INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrRef`, `QuestChanceOrGroup`, `mincount`, `maxcount`, `freeforall`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES(22883, 33013, 0, 100, 1, 1, 1, 0, 0, 0);[6:12:41 PM] plamen spune: update item_template set ExtendedCost=1432 where entry=34016;update item_template set ExtendedCost=1432 where entry=34015;update item_template set ExtendedCost=1432 where entry=33801;update item_template set ExtendedCost=1435 where entry=33770;update item_template set ExtendedCost=1432 where entry=33756;update item_template set ExtendedCost=1670 where entry=33754;update item_template set ExtendedCost=1435 where entry=33753;update item_template set ExtendedCost=1435 where entry=33757;update item_template set ExtendedCost=1435 where entry=33747;update item_template set ExtendedCost=1670 where entry=33737;update item_template set ExtendedCost=1664 where entry=33727;update item_template set ExtendedCost=1435 where entry=33699;update item_template set ExtendedCost=1432 where entry=33689;update item_template set ExtendedCost=1435 where entry=33682;update item_template set ExtendedCost=1435 where entry=33674;update item_template set ExtendedCost=1670 where entry=33669;update item_template set ExtendedCost=1435 where entry=33668;update item_template set ExtendedCost=1664 where entry=33006;-- nowupdate item_template set ExtendedCost=1432 where entry=33705;update creature_template set npcflag=128 where entry in (25178,18898,24392);-- otherupdate item_template set spellid_1=43737, spelltrigger_1=1 where entry=33509;-- Field Repair Bot 110Gupdate item_template set spellid_1=44389 where entry=34113;-- Adamantite Shell Machineupdate item_template set spelltrigger_1=0 where entry=34504;-- Vindicator's Chain Bracersupdate item_template set spellid_1=14027, spelltrigger_1=1 where entry=33876;-- Dragonspine Trophyupdate item_template set spellid_1=14049, spelltrigger_1=1 where entry=28830;-- Mad Alchemist's Potionupdate item_template set spellid_1=45051 where entry=34440;-- Idol of Terrorupdate item_template set spellid_1=43737, spelltrigger_1=1 where entry=33509;-- Formula: Enchant Weapon - Executionerupdate item_template set spellcharges_1=-1, spellppmRate_1=-1 where entry=33307;-- remove wrong equip in Ancient Aqir Artifactupdate item_template set spellid_2=0 where entry=33830;-- remove wrong equip in Battlemaster's Crueltyupdate item_template set spellid_2=0 where entry=34163;-- Wub's Cursed Hexbladeupdate item_template set dmg_max1=127 where entry=33354;-- Glove Reinforcementsupdate item_template set spellid_1=44769, spellcharges_1=-1, spellppmRate_1=-1 where entry=34207;-- Knothide Ammo Pouch update item_template set spellid_1=14829, spelltrigger_1=1 where entry=34099;-- 1 charge Heavy Knothide Armor Kitupdate item_template set spellcharges_1=-1, spellppmRate_1=-1 where entry=34330;-- Design: Chaotic Skyfire Diamondupdate item_template set spellid_1=34221, spellcharges_1=-1, spellppmRate_1=-1 where entry=34221;-- Binds when picked up for Heartlessupdate item_template set bonding=1 where entry=33388;-- missing loot item Mail of Fevered Pursuitdelete from creature_loot_template where item=30907 and entry=17968;INSERT INTO creature_loot_template (entry, item, ChanceOrRef, QuestChanceOrGroup, mincount, maxcount, freeforall, lootcondition, condition_value1, condition_value2)VALUES (17968, 30907, 13, 0, 1, 1, 0, 0, 0, 0);update item_template set spellid_1=44793, spellcharges_1=-1, spellppmRate_1=-1 where entry=34221;-- Battlemaster's Audacityupdate item_template set spellid_1=24196, spelltrigger_1=1, spellid_2=44055 where entry=34579;-- Battlemaster's Crueltyupdate item_template set spellid_2=44055 where entry=34576;-- Battlemaster's Depravityupdate item_template set spellid_2=44055 where entry=34577;-- Battlemaster's Determinationupdate item_template set spellid_1=15826, spelltrigger_1=1, spellid_2=44055 where entry=34578;-- Battlemaster's Perseveranceupdate item_template set spellid_1=33820, spelltrigger_1=1, spellid_2=44055 where entry=34580;-- Field Repair Bot 110Gupdate item_template set spellid_1=44389, spellcooldown_1=600000 where entry=34113;-- Adamantite Shell Machineupdate item_template set spelltrigger_1=0 where entry=34504;-- Vindicator's Chain Bracersupdate item_template set spellid_1=14027, spelltrigger_1=1 where entry=33876;-- Dragonspine Trophyupdate item_template set spellid_1=14049, spelltrigger_1=1 where entry=28830;-- Mad Alchemist's Potionupdate item_template set spellid_1=45051 where entry=34440;-- Idol of Terrorupdate item_template set spellid_1=43737, spelltrigger_1=1 where entry=33509;-- Formula: Enchant Weapon - Executionerupdate item_template set spellcharges_1=-1, spellppmRate_1=-1 where entry=33307;-- remove wrong equip in Ancient Aqir Artifactupdate item_template set spellid_2=0 where entry=33830;-- remove wrong equip in Battlemaster's Crueltyupdate item_template set spellid_2=0 where entry=34163;-- Wub's Cursed Hexbladeupdate item_template set dmg_max1=127 where entry=33354;-- Glove Reinforcementsupdate item_template set spellid_1=44769, spellcharges_1=-1, spellppmRate_1=-1 where entry=34207;-- Knothide Ammo Pouch update item_template set spellid_1=14829, spelltrigger_1=1 where entry=34099;-- 1 charge Heavy Knothide Armor Kitupdate item_template set spellcharges_1=-1, spellppmRate_1=-1 where entry=34330;-- Design: Chaotic Skyfire Diamondupdate item_template set spellid_1=44793, spellcharges_1=-1, spellppmRate_1=-1 where entry=34221;-- Binds when picked up for Heartlessupdate item_template set bonding=1 where entry=33388;-- missing loot item Mail of Fevered Pursuitdelete from creature_loot_template where item=30907 and entry=17968;INSERT INTO creature_loot_template (entry, item, ChanceOrRef, QuestChanceOrGroup, mincount, maxcount, freeforall, lootcondition, condition_value1, condition_value2)VALUES (17968, 30907, 13, 0, 1, 1, 0, 0, 0, 0);DELETE FROM npc_vendor WHERE entry = 24780;INSERT INTO `npc_vendor` (entry, item, maxcount, incrtime) VALUES(24780, 17030, 0, 0),(24780, 17020, 0, 0),(24780, 28056, 0, 0),(24780, 8925, 0, 0),(24780, 5173, 0, 0),(24780, 16583, 0, 0),(24780, 8924, 0, 0),(24780, 8923, 0, 0),(24780, 5140, 0, 0),(24780, 22147, 0, 0),(24780, 17028, 0, 0),(24780, 17037, 0, 0),(24780, 18256, 0, 0),(24780, 5565, 0, 0),(24780, 28061, 0, 0),(24780, 17038, 0, 0),(24780, 3777, 0, 0),(24780, 2931, 0, 0),(24780, 17032, 0, 0),(24780, 17031, 0, 0),(24780, 17029, 0, 0),(24780, 27498, 1, 3600),(24780, 27499, 1, 3600),(24780, 27503, 1, 3600),(24780, 17033, 0, 0),(24780, 21177, 0, 0),(24780, 28101, 2, 3600),(24780, 28100, 1, 3600),(24780, 17021, 0, 0),(24780, 22148, 0, 0),(24780, 17026, 0, 0);update creature_template set npcflag=4224 where entry=24780;-- Battlemaster's Audacityupdate item_template set spellid_1=24196, spelltrigger_1=1, spellid_2=44055 where entry=34579;-- Battlemaster's Crueltyupdate item_template set spellid_2=44055 where entry=34576;-- Battlemaster's Depravityupdate item_template set spellid_2=44055 where entry=34577;-- Battlemaster's Determinationupdate item_template set spellid_1=15826, spelltrigger_1=1, spellid_2=44055 where entry=34578;-- Battlemaster's Perseveranceupdate item_template set spellid_1=33820, spelltrigger_1=1, spellid_2=44055 where entry=34580;-- Powerful Earthstorm DiamondREPLACE item_template (entry, class, subclass, unk0, name, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, RangedModRange, spellid_1, spellcooldown_1, spellid_2, spellcooldown_2, spellid_3, spellcooldown_3, bonding, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, RandomSuffix, block, itemset, MaxDurability, area, Map, TotemCategory, socketColor_1, socketColor_2, socketColor_3, socketBonus, GemProperties, ExtendedCost, RequiredDisenchantSkill, ScriptName) VALUES ('25896', '3', '6', '-1', "Powerful Earthstorm Diamond", '39203', '3', '0', '1', '30000', '120000', '0', '-1', '-1', '70', '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', '0', '0', '0', '0', '100', '0', '-1', '0', '-1', '0', '-1', '0', '0', '0', '0', '0', '0', '-1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '165', '0', '-1', "internalitemhandler");update item_template set description="Only fits in a meta gem slot." where entry=25896;-- Vindicator's Lamellar Greavesupdate item_template set spellid_1=14055, spelltrigger_1=1 where entry=33890;-- Vindicator's Lamellar Beltupdate item_template set spellid_1=14055, spelltrigger_1=1 where entry=33888;-- Vindicator's Lamellar Bracersupdate item_template set spellid_1=14054, spelltrigger_1=1 where entry=33889;-- Overpower Bonus Tier 5 Raid Setreplace into spell_proc_event (entry,procflags,ppmrate) values (37528,524289,1.5);-- (24932) Leader of the Pack ()DELETE FROM `spell_proc_event` WHERE `entry` IN (24932);INSERT INTO `spell_proc_event` VALUES (24932, 0x00, 0, 0, 0, 0x0000000000000000, 0x00400000, 0.000000);