diff options
| -rw-r--r-- | sql/updates/world/master/2017_04_30_00_world.sql | 118 |
1 files changed, 118 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_04_30_00_world.sql b/sql/updates/world/master/2017_04_30_00_world.sql new file mode 100644 index 00000000000..9dc253a06a2 --- /dev/null +++ b/sql/updates/world/master/2017_04_30_00_world.sql @@ -0,0 +1,118 @@ +UPDATE `quest_template` SET `LogTitle`='Salving the Corruption' WHERE `ID`=45550; +UPDATE `quest_template` SET `LogTitle`='Salving the Corruption' WHERE `ID`=45549; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardFactionValue1`=4, `RewardFactionValue2`=4, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=44026; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=43613; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardXPMultiplier`=0, `RewardArtifactXPMultiplier`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=43347; +UPDATE `quest_template` SET `RewardFactionValue1`=7, `RewardFactionOverride1`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=42764; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardXPMultiplier`=0, `RewardFactionValue1`=3, `RewardFactionValue2`=3, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41828; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `RewardSkillLineID`=773, `RewardNumSkillUps`=1, `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41665; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41613; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41505; +UPDATE `quest_template` SET `Expansion`=5, `VerifiedBuild`=23911 WHERE `ID`=35994; +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=15000, `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=32237; +UPDATE `quest_template` SET `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=32222; +UPDATE `quest_template` SET `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=32214; +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=15000, `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=32137; +UPDATE `quest_template` SET `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=32136; +UPDATE `quest_template` SET `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=30292; +UPDATE `quest_template` SET `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=30283; +UPDATE `quest_template` SET `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=30282; +UPDATE `quest_template` SET `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=30281; +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=26968; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=26125; +UPDATE `quest_template` SET `Expansion`=2, `VerifiedBuild`=23911 WHERE `ID`=14199; +UPDATE `quest_template` SET `Expansion`=2, `VerifiedBuild`=23911 WHERE `ID`=13373; +UPDATE `quest_template` SET `Expansion`=1, `VerifiedBuild`=23911 WHERE `ID`=10593; +UPDATE `quest_template` SET `Expansion`=1, `VerifiedBuild`=23911 WHERE `ID`=9441; +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=9226; +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=9225; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=9141; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=9136; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=8421; +UPDATE `quest_template` SET `RewardFactionValue1`=7, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=8258; +UPDATE `quest_template` SET `RewardFactionValue1`=7, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=7502; +UPDATE `quest_template` SET `RewardBonusMoney`=0, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23911 WHERE `ID`=5513; +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionValue2`=5, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `VerifiedBuild`=23911 WHERE `ID`=5235; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=4906; +UPDATE `quest_template` SET `RewardFactionValue1`=6, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=4001; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=3526; +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=3002; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=2937; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=2756; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=2742; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=2242; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1384; +UPDATE `quest_template` SET `RewardFactionValue1`=3, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=910; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardFactionValue1`=4, `RewardFactionValue2`=4, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=44026; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardXPMultiplier`=0, `RewardFactionValue1`=3, `RewardFactionValue2`=3, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41828; +UPDATE `quest_template` SET `RewardFactionValue1`=7, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=7502; + +UPDATE `quest_objectives` SET `Description`='Manaroot applied' WHERE `ID`=289533; -- 289533 +UPDATE `quest_objectives` SET `Description`='Felborne killed' WHERE `ID`=289519; -- 289519 +UPDATE `quest_objectives` SET `Description`='Manaroot applied' WHERE `ID`=289534; -- 289534 +UPDATE `quest_objectives` SET `Description`='Felborne killed' WHERE `ID`=289518; -- 289518 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=286127; -- 286127 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=285550; -- 285550 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=285223; -- 285223 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=284723; -- 284723 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=284722; -- 284722 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282894; -- 282894 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282630; -- 282630 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282568; -- 282568 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282455; -- 282455 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=274474; -- 274474 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=269566; -- 269566 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=269616; -- 269616 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=269607; -- 269607 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=269537; -- 269537 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=268146; -- 268146 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=268142; -- 268142 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=268148; -- 268148 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=268147; -- 268147 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=267576; -- 267576 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=267575; -- 267575 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=265119; -- 265119 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=264123; -- 264123 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258184; -- 258184 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258183; -- 258183 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258182; -- 258182 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=251676; -- 251676 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=260317; -- 260317 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=260316; -- 260316 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=260655; -- 260655 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=260654; -- 260654 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=262195; -- 262195 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=262149; -- 262149 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23911 WHERE `ID`=260091; -- 260091 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23911 WHERE `ID`=260090; -- 260090 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259149; -- 259149 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259013; -- 259013 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257713; -- 257713 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257712; -- 257712 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257418; -- 257418 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257417; -- 257417 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258322; -- 258322 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258321; -- 258321 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258320; -- 258320 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258319; -- 258319 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257182; -- 257182 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23911 WHERE `ID`=257034; -- 257034 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256610; -- 256610 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255476; -- 255476 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255475; -- 255475 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256293; -- 256293 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255808; -- 255808 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255807; -- 255807 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=286127; -- 286127 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282894; -- 282894 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259013; -- 259013 + +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=285223 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=284723 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=284722 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=274474 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=268142 AND `Index`=3); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=268142 AND `Index`=2); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=268142 AND `Index`=1); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=268142 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=268148 AND `Index`=0); |