All pastes #741958 Raw Edit
running 2.3

public sql v1 · immutable
·published 2007-10-19 03:09 UTC
## 2.2 rep update timbermaw hold questupdate `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 questsupdate `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 questsupdate `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 questupdate `quest_template` set `ZoneOrSort` = -264, `RequiredSkillValue` = 290, `RequiredMinRepFaction` = 576, `RequiredMinRepValue` = 3000, `SpecialFlags` = `SpecialFlags`|64, `ReqSpellCast1` = 0, `Repeatable` = 0 where `entry` = 6032;## cloth questupdate `quest_template` set `RequiredMinRepFaction` = 576, `RequiredMinRepValue` = 3000, `Repeatable` = 0 where `entry` = 6031;## adjusting felwood questsupdate `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 timeupdate `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 tunnelupdate `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;