## 2.2 rep update timbermaw hold quest update `quest_template` set `RewRepFaction1` = 576, `RewRepValue1` = 500, `RewRepFaction2` = 0, `RewRepValue2` = 0, `RewRepFaction3` = 0, `RewRepValue3` = 0, `RewRepFaction4` = 0, `RewRepValue4` = 0, `RewRepFaction5` = 0, `RewRepValue5` = 0 where `entry` = 6032; update `quest_template` set `RewRepFaction1` = 576, `RewRepValue1` = 700, `RewRepFaction2` = 0, `RewRepValue2` = 0, `RewRepFaction3` = 0, `RewRepValue3` = 0, `RewRepFaction4` = 0, `RewRepValue4` = 0, `RewRepFaction5` = 0, `RewRepValue5` = 0 where `entry` = 8460; update `quest_template` set `RewRepFaction1` = 576, `RewRepValue1` = 50, `RewRepFaction2` = 0, `RewRepValue2` = 0, `RewRepFaction3` = 0, `RewRepValue3` = 0, `RewRepFaction4` = 0, `RewRepValue4` = 0, `RewRepFaction5` = 0, `RewRepValue5` = 0 where `entry` = 8462; update `quest_template` set `RewRepFaction1` = 576, `RewRepValue1` = 150, `RewRepFaction2` = 0, `RewRepValue2` = 0, `RewRepFaction3` = 0, `RewRepValue3` = 0, `RewRepFaction4` = 0, `RewRepValue4` = 0, `RewRepFaction5` = 0, `RewRepValue5` = 0 where `entry` = 8466; update `quest_template` set `RewRepFaction1` = 576, `RewRepValue1` = 150, `RewRepFaction2` = 0, `RewRepValue2` = 0, `RewRepFaction3` = 0, `RewRepValue3` = 0, `RewRepFaction4` = 0, `RewRepValue4` = 0, `RewRepFaction5` = 0, `RewRepValue5` = 0 where `entry` = 8467; update `quest_template` set `RewRepFaction1` = 576, `RewRepValue1` = 50, `RewRepFaction2` = 0, `RewRepValue2` = 0, `RewRepFaction3` = 0, `RewRepValue3` = 0, `RewRepFaction4` = 0, `RewRepValue4` = 0, `RewRepFaction5` = 0, `RewRepValue5` = 0 where `entry` = 8465; update `quest_template` set `RewRepFaction1` = 576, `RewRepValue1` = 700, `RewRepFaction2` = 0, `RewRepValue2` = 0, `RewRepFaction3` = 0, `RewRepValue3` = 0, `RewRepFaction4` = 0, `RewRepValue4` = 0, `RewRepFaction5` = 0, `RewRepValue5` = 0 where `entry` = 8464; update `quest_template` set `RewRepFaction1` = 576, `RewRepValue1` = 150, `RewRepFaction2` = 0, `RewRepValue2` = 0, `RewRepFaction3` = 0, `RewRepValue3` = 0, `RewRepFaction4` = 0, `RewRepValue4` = 0, `RewRepFaction5` = 0, `RewRepValue5` = 0 where `entry` = 8469; update `quest_template` set `RewRepFaction1` = 576, `RewRepValue1` = 500, `RewRepFaction2` = 0, `RewRepValue2` = 0, `RewRepFaction3` = 0, `RewRepValue3` = 0, `RewRepFaction4` = 0, `RewRepValue4` = 0, `RewRepFaction5` = 0, `RewRepValue5` = 0 where `entry` = 6031; update `quest_template` set `RewRepFaction1` = 576, `RewRepValue1` = 700, `RewRepFaction2` = 0, `RewRepValue2` = 0, `RewRepFaction3` = 0, `RewRepValue3` = 0, `RewRepFaction4` = 0, `RewRepValue4` = 0, `RewRepFaction5` = 0, `RewRepValue5` = 0 where `entry` = 8470; update `quest_template` set `RewRepFaction1` = 576, `RewRepValue1` = 700, `RewRepFaction2` = 0, `RewRepValue2` = 0, `RewRepFaction3` = 0, `RewRepValue3` = 0, `RewRepFaction4` = 0, `RewRepValue4` = 0, `RewRepFaction5` = 0, `RewRepValue5` = 0 where `entry` = 8461; ## timbermaw hold quests update `quest_template` set `MinLevel` = 52, `QuestLevel` = 55, `RequiredRaces` = 0, `PrevQuestId` = 0, `NextQuestId` = 0, `ExclusiveGroup` = 0, `NextQuestInChain` = 0 where `entry` = 6032; update `quest_template` set `MinLevel` = 45, `QuestLevel` = 48, `RequiredRaces` = 0, `PrevQuestId` = 0, `NextQuestId` = 0, `ExclusiveGroup` = 0, `NextQuestInChain` = 0 where `entry` = 8460; update `quest_template` set `MinLevel` = 45, `QuestLevel` = 55, `RequiredRaces` = 8460, `PrevQuestId` = 0, `NextQuestId` = 0, `ExclusiveGroup` = 0, `NextQuestInChain` = 0 where `entry` = 8462; update `quest_template` set `MinLevel` = 45, `QuestLevel` = 55, `RequiredRaces` = 8460, `PrevQuestId` = 0, `NextQuestId` = 0, `ExclusiveGroup` = 0, `NextQuestInChain` = 0 where `entry` = 8466; update `quest_template` set `MinLevel` = 45, `QuestLevel` = 55, `RequiredRaces` = 8460, `PrevQuestId` = 0, `NextQuestId` = 0, `ExclusiveGroup` = 0, `NextQuestInChain` = 0 where `entry` = 8467; update `quest_template` set `MinLevel` = 45, `QuestLevel` = 55, `RequiredRaces` = 0, `PrevQuestId` = 0, `NextQuestId` = 0, `ExclusiveGroup` = 0, `NextQuestInChain` = 0 where `entry` = 8465; update `quest_template` set `MinLevel` = 45, `QuestLevel` = 58, `RequiredRaces` = 0, `PrevQuestId` = 0, `NextQuestId` = 0, `ExclusiveGroup` = 0, `NextQuestInChain` = 0 where `entry` = 8464; update `quest_template` set `MinLevel` = 50, `QuestLevel` = 56, `RequiredRaces` = 8464, `PrevQuestId` = 0, `NextQuestId` = 0, `ExclusiveGroup` = 0, `NextQuestInChain` = 0 where `entry` = 8469; update `quest_template` set `MinLevel` = 50, `QuestLevel` = 55, `RequiredRaces` = 0, `PrevQuestId` = 0, `NextQuestId` = 0, `ExclusiveGroup` = 0, `NextQuestInChain` = 0 where `entry` = 6031; update `quest_template` set `MinLevel` = 45, `QuestLevel` = 55, `RequiredRaces` = 0, `PrevQuestId` = 0, `NextQuestId` = 0, `ExclusiveGroup` = 0, `NextQuestInChain` = 0 where `entry` = 8470; update `quest_template` set `MinLevel` = 45, `QuestLevel` = 55, `RequiredRaces` = 0, `PrevQuestId` = 0, `NextQuestId` = 0, `ExclusiveGroup` = 0, `NextQuestInChain` = 0 where `entry` = 8461; ## get rif of old timbermaw quests update `quest_template` set `Title` = 'OLD Winterfall Activity' where `entry` = 6241; update `quest_template` set `Title` = 'OLD Timbermaw Ally' where `entry` = 6131; update `quest_template` set `Title` = 'OLD Deadwood of the North' where `entry` = 6221; delete from `creature_questrelation` where `quest` in (6241, 6131, 6221); delete from `creature_involvedrelation` where `quest` in (6241, 6131, 6221); ## tailor quest update `quest_template` set `ZoneOrSort` = -264, `RequiredSkillValue` = 290, `RequiredMinRepFaction` = 576, `RequiredMinRepValue` = 3000, `SpecialFlags` = `SpecialFlags`|64, `ReqSpellCast1` = 0, `Repeatable` = 0 where `entry` = 6032; ## cloth quest update `quest_template` set `RequiredMinRepFaction` = 576, `RequiredMinRepValue` = 3000, `Repeatable` = 0 where `entry` = 6031; ## adjusting felwood quests update `quest_template` set `MinLevel` = 48, `QuestLevel` = 55, `RequiredRaces` = 1101, `PrevQuestId` = 0, `NextQuestId` = 0, `ExclusiveGroup` = 0, `NextQuestInChain` = 0 where `entry` = 4101; update `quest_template` set `MinLevel` = 48, `QuestLevel` = 55, `RequiredRaces` = 690, `PrevQuestId` = 0, `NextQuestId` = 0, `ExclusiveGroup` = 0, `NextQuestInChain` = 0 where `entry` = 4102; update `quest_template` set `MinLevel` = 49, `QuestLevel` = 55, `RequiredRaces` = 0, `PrevQuestId` = 5202, `NextQuestId` = 0, `ExclusiveGroup` = 0, `NextQuestInChain` = 5204 where `entry` = 5203; update `quest_template` set `MinLevel` = 49, `QuestLevel` = 57, `RequiredRaces` = 0, `PrevQuestId` = 5203, `NextQuestId` = 0, `ExclusiveGroup` = 0, `NextQuestInChain` = 5385 where `entry` = 5204; update `quest_template` set `MinLevel` = 49, `QuestLevel` = 54, `RequiredRaces` = 690, `PrevQuestId` = 4505, `NextQuestId` = 0, `ExclusiveGroup` = 0, `NextQuestInChain` = 0 where `entry` = 4506; update `quest_template` set `MinLevel` = 48, `QuestLevel` = 54, `RequiredRaces` = 0, `PrevQuestId` = 0, `NextQuestId` = 0, `ExclusiveGroup` = 0, `NextQuestInChain` = 0 where `entry` = 5156; ## move salfa, hopefully for the last time update `creature` set `position_x` = '6897.56', `position_y` = '-2287.83', `position_z` = '588.992', `orientation` = '3.9', `spawn_position_x` = '6897.56', `spawn_position_y` = '-2287.83', `spawn_position_z` = '588.992', `spawn_orientation` = '3.9' where `guid` = 49440 and `id` = 11556; ## move meilosh to inside timbermaw tunnel update `creature` set `position_x` = '7025.96', `position_y` = '-2135.07', `position_z` = '586.33', `orientation` = '2.7', `spawn_position_x` = '7025.96', `spawn_position_y` = '-2135.07', `spawn_position_z` = '586.33', `spawn_orientation` = '2.7' where `guid` = 49441 and `id` = 11557; ## update `quest_template` set `NextQuestId` = 7629, `ExclusiveGroup` = '-7625' where `entry` = 7625; update `quest_template` set `NextQuestId` = 7630, `ExclusiveGroup` = '-7626' where `entry` = 7626; update `quest_template` set `NextQuestId` = 7630, `ExclusiveGroup` = '-7626' where `entry` = 7627; update `quest_template` set `NextQuestId` = 7630, `ExclusiveGroup` = '-7626' where `entry` = 7628; update `quest_template` set `PrevQuestId` = 0, `NextQuestId` = 7629, `ExclusiveGroup` = '-7625' where `entry` = 7630; update `quest_template` set `PrevQuestId` = 0 where `entry` = 7629;