-- Move Vhel'kur to a position that does not have LOS issues
UPDATE `creature` SET `position_x` = '-5052.04', `position_y` = '662.587', `position_z` = '89.5709', `orientation` = '0.0201144' WHERE `guid` = '76114' AND `id` = '21801';  

-- Quest: Emergency Protocol: Section 8.2, Paragraph C
DELETE FROM `npc_spellclick_spells` WHERE `npc_entry`=25841;  
INSERT INTO `npc_spellclick_spells` VALUES (25841, 46166, 11795, 1, 11795, 3,0,0,0);  
UPDATE `creature_template` SET `IconName`='LootAll' WHERE `entry`=25841;
DELETE FROM `creature` WHERE `id`=25841;
INSERT INTO creature
   (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`)
VALUES
   (118601, 25841, 571, 1, 1, 23430, 0, 3325.55, 5169.61, 13.1208, 3.15905, 300, 0, 0, 7185, 7196, 1, 0),
   (118602, 25841, 571, 1, 1, 23430, 0, 3290.12, 5082.75, 16.2845, 3.94444, 300, 0, 0, 7185, 7196, 1, 0),
   (118603, 25841, 571, 1, 1, 23430, 0, 3356.85, 5044.32, 13.1208, 3.9968, 300, 0, 0, 7185, 7196, 1, 0),
   (118620, 25841, 571, 1, 1, 23430, 0, 3609.9, 5059.68, 13.0899, 5.91667, 300, 0, 0, 7185, 7196, 1, 0),
   (118622, 25841, 571, 1, 1, 23430, 0, 3591.06, 5034.88, 15.2107, 4.57276, 300, 0, 0, 7185, 7196, 1, 0),
   (118625, 25841, 571, 1, 1, 23430, 0, 3720.89, 4988.25, 4.04832, 1.32645, 300, 0, 0, 7185, 7196, 1, 0),
   (118627, 25841, 571, 1, 1, 23430, 0, 3736.02, 5039.35, -1.15135, 2.77507, 300, 0, 0, 7185, 7196, 1, 0),
   (118634, 25841, 571, 1, 1, 23430, 0, 3394.59, 5143.99, 13.1208, 4.59022, 300, 0, 0, 7185, 7196, 1, 0),
   (118643, 25841, 571, 1, 1, 23430, 0, 3669.97, 5060.01, 13.0899, 1.09956, 300, 0, 0, 7185, 7196, 1, 0),
   (118664, 25841, 571, 1, 1, 23430, 0, 3418.47, 5076.99, 14.2947, 0.331613, 300, 0, 0, 7185, 7196, 1, 0),
   (118682, 25841, 571, 1, 1, 23430, 0, 3474.19, 4824.96, 12.8505, 1.09956, 300, 0, 0, 7185, 7196, 1, 0),
   (118683, 25841, 571, 1, 1, 23430, 0, 3425.42, 5182.84, 17.6477, 0.575959, 300, 0, 0, 7185, 7196, 1, 0),
   (118684, 25841, 571, 1, 1, 23430, 0, 3493.85, 5153.4, 16.5017, 0.820305, 300, 0, 0, 7185, 7196, 1, 0),
   (118685, 25841, 571, 1, 1, 23430, 0, 3525.88, 5124.33, 13.3699, 0.890118, 300, 0, 0, 7185, 7196, 1, 0),
   (118686, 25841, 571, 1, 1, 23430, 0, 3499.22, 5079.69, 13.6477, 5.02655, 300, 0, 0, 7185, 7196, 1, 0);
UPDATE `creature` SET `DeathState`=0 WHERE `id`=25841;
DELETE FROM `creature_template_addon` WHERE `entry`=25841;
INSERT INTO `creature_template_addon`(`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES 
(25841, 0, 0, 7, 1, 0, 0, '');
UPDATE `item_template` SET maxcount=6 WHERE entry=35126; -- sanity check limit number to quest required ammount

-- Mage Queset: Control
UPDATE `quest_template` SET `SpecialFlags`=0 WHERE `entry`=9595;

-- Missed Faction Change on Farshire Grain Credit
UPDATE `creature_template` SET `faction_A`=35, `faction_H`=35 WHERE `entry`=26161;

-- Remove XP from Dying Soldier
UPDATE `creature_template` SET `flags_extra`=64 WHERE `entry`=31304;

-- Remove XP from Dting Berserker
UPDATE `creature_template` SET `flags_extra`='64' WHERE `entry`='31273';

-- Remove XP from Scourging Crystal
UPDATE `creature_template` SET `flags_extra`=64 WHERE `entry`=24464;

-- Remove HP regen for WG Vehicles
UPDATE `creature_template` SET `regenhealth`=0 WHERE name like 'Wintergrasp%' and vehicleId > 0;

-- Quest - Moving In
UPDATE `creature_template` SET `killcredit1`=29412 WHERE `entry`=29411;

-- Missing Items for LW Trainer - Trainer Fix Applied Previous
INSERT INTO `item_template` (`entry`, `class`, `subclass`, `unk0`, `name`, `displayid`, `Quality`, `Flags`, `BuyCount`, `BuyPrice`, `SellPrice`, `InventoryType`, `AllowableClass`, `AllowableRace`, `ItemLevel`, `RequiredLevel`, `RequiredSkill`, `RequiredSkillRank`, `requiredspell`, `requiredhonorrank`, `RequiredCityRank`, `RequiredReputationFaction`, `RequiredReputationRank`, `maxcount`, `stackable`, `ContainerSlots`, `StatsCount`, `stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`, `ScalingStatDistribution`, `ScalingStatValue`, `dmg_min1`, `dmg_max1`, `dmg_type1`, `dmg_min2`, `dmg_max2`, `dmg_type2`, `armor`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `delay`, `ammo_type`, `RangedModRange`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellppmRate_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellppmRate_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellppmRate_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellppmRate_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellppmRate_5`, `spellcooldown_5`, `spellcategory_5`, `spellcategorycooldown_5`, `bonding`, `description`, `PageText`, `LanguageID`, `PageMaterial`, `startquest`, `lockid`, `Material`, `sheath`, `RandomProperty`, `RandomSuffix`, `block`, `itemset`, `MaxDurability`, `area`, `Map`, `BagFamily`, `TotemCategory`, `socketColor_1`, `socketContent_1`, `socketColor_2`, `socketContent_2`, `socketColor_3`, `socketContent_3`, `socketBonus`, `GemProperties`, `RequiredDisenchantSkill`, `ArmorDamageModifier`, `Duration`, `ItemLimitCategory`, `HolidayId`, `ScriptName`, `DisenchantID`, `FoodType`, `minMoneyLoot`, `maxMoneyLoot`) VALUES
(44932, 9, 1, -1, 'Pattern: Windripper Boots', 1096, 4, 4160, 1, 0, 0, 0, -1, -1, 80, 0, 165, 440, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 483, 0, -1, 0, -1, 0, -1, 62176, 6, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 1, 'Teaches you how to make Windripper Boots.', 0, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, '', 0, 0, 0, 0),
(44933, 9, 1, -1, 'Pattern: Windripper Leggings', 1096, 4, 4160, 1, 0, 0, 0, -1, -1, 80, 0, 165, 440, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 483, 0, -1, 0, -1, 0, -1, 62177, 6, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 1, 'Teaches you how to make Windripper Leggings.', 0, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, '', 0, 0, 0, 0);

-- Quest- Green Eggs and Whelps
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = 23777;
DELETE FROM `creature_ai_scripts` WHERE `creature_id`=23777;
INSERT INTO `creature_ai_scripts` (`creature_id`,`event_type`,`event_inverse_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action1_type`,`action1_param1`,`action1_param2`,`action1_param3`,`action2_type`,`action2_param1`,`action2_param2`,`action2_param3`,`action3_type`,`action3_param1`,`action3_param2`,`action3_param3`,`comment`) VALUES
(23777,8,0,100,1,43157,-1,30000,30000,12,24160,6,60000,11,51592,0,0,0,0,0,0,"Green Eggs and Whelps");

-- Quest Towers of Certain Doom
UPDATE `quest_template` SET `reqspellcast1`=49625, `reqspellcast2`=49625, `reqspellcast3`=49625, `reqspellcast4`=49625 WHERE `entry`=11259;

-- Quest Bombard the Ballista
UPDATE `quest_template` SET `reqspellcast1`=48345 WHERE `entry`=12232;
DELETE FROM `spell_script_target` WHERE `entry` = 48345;
INSERT INTO spell_script_target (`entry`, `type`, `targetEntry`) VALUES (48345, 1, 27331);

-- 3 Monitor the Rifts Quest
-- Add tiggers and gobject
INSERT INTO gameobject (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`)
VALUES (300170, 571, 1,1,3286.95, 6604.72, -2.26261, 0.691993, 0, 0, 0.339134, 0.940738, 25, 0, 1);
INSERT INTO creature (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`)
VALUES (25310,571,1,1,0,0,3287.67,6605.12,-2.34545,0.794095,25,0,0,1,0,0,0);
INSERT INTO gameobject (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`)
VALUES (300170, 571, 1,1,3791.6, 6043.25, -132.459, 2.7301, 0, 0, 0.978909, 0.204297, 25, 0, 1);
INSERT INTO creature ( `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`)
VALUES (25308,571,1,1,0,0,3790.55,6043.71,-133.723,2.7301,25,0,0,1,0,0,0);
INSERT INTO creature ( `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`)
VALUES (25309,571,1,1,0,0,4138.87,6258.26,28.5849,6.20313,25,0,0,4979,0,0,0);
INSERT INTO gameobject (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`)
VALUES (300170, 571, 1,1,4138.87, 6258.26, 28.5849, 6.20313, 0, 0, 0.0400166, -0.999199, 25, 0, 1);
-- Make tiggers invisibilty
UPDATE `creature_template` SET `flags_extra`='128' WHERE entry = '25310';
UPDATE `creature_template` SET `flags_extra`='128' WHERE entry = '25308';
UPDATE `creature_template` SET `flags_extra`='128' WHERE entry = '25309';

-- Changes for Timbermaw Hold Rep
UPDATE `creature_onkill_reputation` SET `MaxStanding1` = '5', `RewOnKillRepValue1` = '20'  WHERE `creature_id` IN ('7153', '7154', '7155', '7156', '7157', '7158', '7438', '7439', '7440', '7441', '7442', '10916', '14372'); 
UPDATE `creature_onkill_reputation` SET `MaxStanding1` = '7', `RewOnKillRepValue1` = '60'  WHERE `creature_id` IN ('9462', '9464'); 
UPDATE `creature_onkill_reputation` SET `MaxStanding1` = '7', `RewOnKillRepValue1` = '40'  WHERE `creature_id` IN ('10738');
UPDATE `creature_onkill_reputation` SET `MaxStanding1` = '7', `RewOnKillRepValue1` = '100' WHERE `creature_id` IN ('14342', '10199', '15623');
UPDATE `quest_template` SET `RewRepValue1` = '1400'  WHERE `entry` IN ('8461', '8470', '8471', '8464'); 
UPDATE `quest_template` SET `RewRepValue1` = '1000'  WHERE `entry` IN ('6031', '6032'); 
UPDATE `quest_template` SET `RewRepValue1` = '100'  WHERE `entry` IN ('8462', '8465'); 
UPDATE `quest_template` SET `RewRepValue1` = '300'  WHERE `entry` IN ('8467', '8466', '8469');


-- core updates missed to check
UPDATE `creature_template` SET `ScriptName` = 'mob_fiendish_portal' WHERE `entry` = 17265;
UPDATE `item_template` SET `ScriptName` = 'item_harvesters_gift' WHERE `entry` = 39253;
UPDATE `creature_template` SET `ScriptName` = 'mob_feugen' WHERE `entry` = 15930; 

INSERT INTO `creature_template` VALUES (26688, 0, 0, 0, 169, 0, 11686, 0, 'Statis orb', '', '', 1, 1, 1, 1, 0, 0, 0, 35, 35, 0, 0.3, 1, 0, 0, 0, 0, 0, 1, 2000, 0, 0, 33554818, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10, 1024, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 1, 0, 32767, 0, 'mob_palehoof_orb');