TDB UDB Fixes

-- Move Vhel'kur to a position that does not have LOS issuesUPDATE `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 CDELETE 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: ControlUPDATE `quest_template` SET `SpecialFlags`=0 WHERE `entry`=9595;-- Missed Faction Change on Farshire Grain CreditUPDATE `creature_template` SET `faction_A`=35, `faction_H`=35 WHERE `entry`=26161;-- Remove XP from Dying SoldierUPDATE `creature_template` SET `flags_extra`=64 WHERE `entry`=31304;-- Remove XP from Dting BerserkerUPDATE `creature_template` SET `flags_extra`='64' WHERE `entry`='31273';-- Remove XP from Scourging CrystalUPDATE `creature_template` SET `flags_extra`=64 WHERE `entry`=24464;-- Remove HP regen for WG VehiclesUPDATE `creature_template` SET `regenhealth`=0 WHERE name like 'Wintergrasp%' and vehicleId > 0;-- Quest - Moving InUPDATE `creature_template` SET `killcredit1`=29412 WHERE `entry`=29411;-- Missing Items for LW Trainer - Trainer Fix Applied PreviousINSERT 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 WhelpsUPDATE `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 DoomUPDATE `quest_template` SET `reqspellcast1`=49625, `reqspellcast2`=49625, `reqspellcast3`=49625, `reqspellcast4`=49625 WHERE `entry`=11259;-- Quest Bombard the BallistaUPDATE `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 gobjectINSERT 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 invisibiltyUPDATE `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 RepUPDATE `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 checkUPDATE `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');