-- Entry Into Karazhan
UPDATE `gameobject_template` SET `flags` = 0 WHERE `entry` = 182196;

-- The Second and Third Fragments
UPDATE `gameobject_template` SET `flags` = 0 WHERE `entry` = 182198;

-- The Master's Touch
REPLACE 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;
-- now
update item_template set ExtendedCost=1432 where entry=33705;
update creature_template set npcflag=128 where entry in (25178,18898,24392);
-- other

update item_template set spellid_1=43737, spelltrigger_1=1 where entry=33509;
-- Field Repair Bot 110G
update item_template set spellid_1=44389 where entry=34113;

-- Adamantite Shell Machine
update item_template set spelltrigger_1=0 where entry=34504;

-- Vindicator's Chain Bracers
update item_template set spellid_1=14027, spelltrigger_1=1 where entry=33876;

-- Dragonspine Trophy
update item_template set spellid_1=14049, spelltrigger_1=1 where entry=28830;

-- Mad Alchemist's Potion
update item_template set spellid_1=45051 where entry=34440;

-- Idol of Terror
update item_template set spellid_1=43737, spelltrigger_1=1 where entry=33509;

-- Formula: Enchant Weapon - Executioner
update item_template set spellcharges_1=-1, spellppmRate_1=-1 where entry=33307;

-- remove wrong equip in Ancient Aqir Artifact
update item_template set spellid_2=0 where entry=33830;

-- remove wrong equip in Battlemaster's Cruelty
update item_template set spellid_2=0 where entry=34163;

-- Wub's Cursed Hexblade
update item_template set dmg_max1=127 where entry=33354;

-- Glove Reinforcements
update 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 Kit
update item_template set spellcharges_1=-1, spellppmRate_1=-1 where entry=34330;

-- Design: Chaotic Skyfire Diamond
update item_template set spellid_1=34221, spellcharges_1=-1, spellppmRate_1=-1 where entry=34221;

-- Binds when picked up for Heartless
update item_template set bonding=1 where entry=33388;


-- missing loot item Mail of Fevered Pursuit
delete 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 Audacity
update item_template set spellid_1=24196, spelltrigger_1=1, spellid_2=44055 where entry=34579;
-- Battlemaster's Cruelty
update item_template set spellid_2=44055 where entry=34576;
-- Battlemaster's Depravity
update item_template set spellid_2=44055 where entry=34577;
-- Battlemaster's Determination
update item_template set spellid_1=15826, spelltrigger_1=1, spellid_2=44055 where entry=34578;
-- Battlemaster's Perseverance
update item_template set spellid_1=33820, spelltrigger_1=1, spellid_2=44055 where entry=34580;

-- Field Repair Bot 110G
update item_template set spellid_1=44389, spellcooldown_1=600000 where entry=34113;
-- Adamantite Shell Machine
update item_template set spelltrigger_1=0 where entry=34504;

-- Vindicator's Chain Bracers
update item_template set spellid_1=14027, spelltrigger_1=1 where entry=33876;

-- Dragonspine Trophy
update item_template set spellid_1=14049, spelltrigger_1=1 where entry=28830;

-- Mad Alchemist's Potion
update item_template set spellid_1=45051 where entry=34440;

-- Idol of Terror
update item_template set spellid_1=43737, spelltrigger_1=1 where entry=33509;

-- Formula: Enchant Weapon - Executioner
update item_template set spellcharges_1=-1, spellppmRate_1=-1 where entry=33307;

-- remove wrong equip in Ancient Aqir Artifact
update item_template set spellid_2=0 where entry=33830;

-- remove wrong equip in Battlemaster's Cruelty
update item_template set spellid_2=0 where entry=34163;

-- Wub's Cursed Hexblade
update item_template set dmg_max1=127 where entry=33354;

-- Glove Reinforcements
update 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 Kit
update item_template set spellcharges_1=-1, spellppmRate_1=-1 where entry=34330;

-- Design: Chaotic Skyfire Diamond
update item_template set spellid_1=44793, spellcharges_1=-1, spellppmRate_1=-1 where entry=34221;

-- Binds when picked up for Heartless
update item_template set bonding=1 where entry=33388;


-- missing loot item Mail of Fevered Pursuit
delete 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 Audacity
update item_template set spellid_1=24196, spelltrigger_1=1, spellid_2=44055 where entry=34579;
-- Battlemaster's Cruelty
update item_template set spellid_2=44055 where entry=34576;
-- Battlemaster's Depravity
update item_template set spellid_2=44055 where entry=34577;
-- Battlemaster's Determination
update item_template set spellid_1=15826, spelltrigger_1=1, spellid_2=44055 where entry=34578;
-- Battlemaster's Perseverance
update item_template set spellid_1=33820, spelltrigger_1=1, spellid_2=44055 where entry=34580;

-- Powerful Earthstorm Diamond
REPLACE 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 Greaves
update item_template set spellid_1=14055, spelltrigger_1=1 where entry=33890;
-- Vindicator's Lamellar Belt
update item_template set spellid_1=14055, spelltrigger_1=1 where entry=33888;
-- Vindicator's Lamellar Bracers
update item_template set spellid_1=14054, spelltrigger_1=1 where entry=33889;

-- Overpower Bonus Tier 5 Raid Set
replace 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);