diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2017_03_19_00_world.sql | 184 |
1 files changed, 184 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_03_19_00_world.sql b/sql/updates/world/3.3.5/2017_03_19_00_world.sql new file mode 100644 index 00000000000..b19feaae716 --- /dev/null +++ b/sql/updates/world/3.3.5/2017_03_19_00_world.sql @@ -0,0 +1,184 @@ +-- +UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID`=3761; +UPDATE `quest_template_addon` SET `NextQuestID`=11123 WHERE `ID`=1282; +UPDATE `quest_template_addon` SET `NextQuestID`=11123 WHERE `ID`=1302; +UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID`=11123; +UPDATE `quest_template_addon` SET `NextQuestID`=1476 WHERE `ID`=1507; +UPDATE `quest_template_addon` SET `NextQuestID`=1476 WHERE `ID`=1472; +UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID`=1476; +UPDATE `quest_template_addon` SET `NextQuestID`=1471 WHERE `ID`=1501; +UPDATE `quest_template_addon` SET `NextQuestID`=1471 WHERE `ID`=1473; +UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID`=1471; +UPDATE `quest_template_addon` SET `NextQuestID`=1498 WHERE `ID`=1818; +UPDATE `quest_template_addon` SET `NextQuestID`=1498 WHERE `ID`=1505; +UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID`=1498; +UPDATE `quest_template_addon` SET `NextQuestID`=1517 WHERE `ID`=1519; +UPDATE `quest_template_addon` SET `NextQuestID`=1517 WHERE `ID`=1516; +UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID`=1517; +UPDATE `quest_template_addon` SET `NextQuestID`=1639 WHERE `ID`=1638; +UPDATE `quest_template_addon` SET `NextQuestID`=1639 WHERE `ID`=9582; +UPDATE `quest_template_addon` SET `NextQuestID`=1639 WHERE `ID`=1684; +UPDATE `quest_template_addon` SET `NextQuestID`=1639 WHERE `ID`=1679; +UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID`=1639; +UPDATE `quest_template_addon` SET `NextQuestID`=1699 WHERE `ID`=10371; +UPDATE `quest_template_addon` SET `NextQuestID`=1699 WHERE `ID`=1698; +UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID`=1699; +UPDATE `quest_template_addon` SET `NextQuestID`=1963 WHERE `ID`=1859; +UPDATE `quest_template_addon` SET `NextQuestID`=1963 WHERE `ID`=1885; +UPDATE `quest_template_addon` SET `NextQuestID`=1963 WHERE `ID`=9532; +UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID`=1963; +UPDATE `quest_template_addon` SET `NextQuestID`=1861 WHERE `ID`=9595; +UPDATE `quest_template_addon` SET `NextQuestID`=1861 WHERE `ID`=1879; +UPDATE `quest_template_addon` SET `NextQuestID`=1861 WHERE `ID`=1860; +UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID`=1861; +UPDATE `quest_template_addon` SET `NextQuestID`=1882 WHERE `ID`=9402; +UPDATE `quest_template_addon` SET `NextQuestID`=1882 WHERE `ID`=1883; +UPDATE `quest_template_addon` SET `NextQuestID`=1882 WHERE `ID`=1881; +UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID`=1882; +UPDATE `quest_template_addon` SET `NextQuestID`=2260 WHERE `ID`=2259; +UPDATE `quest_template_addon` SET `NextQuestID`=2260 WHERE `ID`=2300; +UPDATE `quest_template_addon` SET `NextQuestID`=2260 WHERE `ID`=2299; +UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID`=2260; +UPDATE `quest_template_addon` SET `NextQuestID`=2382 WHERE `ID`=2379; +UPDATE `quest_template_addon` SET `NextQuestID`=2382 WHERE `ID`=10372; +UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID`=2382; +UPDATE `quest_template_addon` SET `NextQuestID`=3639 WHERE `ID`=3640; +UPDATE `quest_template_addon` SET `NextQuestID`=3639 WHERE `ID`=3638; +UPDATE `quest_template_addon` SET `NextQuestID`=3639 WHERE `ID`=3642; +UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID`=3639; +UPDATE `quest_template_addon` SET `NextQuestID`=5624 WHERE `ID`=5626; +UPDATE `quest_template_addon` SET `NextQuestID`=5624 WHERE `ID`=5623; +UPDATE `quest_template_addon` SET `NextQuestID`=5624 WHERE `ID`=9586; +UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID`=5624; +UPDATE `quest_template_addon` SET `NextQuestID`=5648 WHERE `ID`=5651; +UPDATE `quest_template_addon` SET `NextQuestID`=5648 WHERE `ID`=9489; +UPDATE `quest_template_addon` SET `NextQuestID`=5648 WHERE `ID`=5649; +UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID`=5648; +UPDATE `quest_template_addon` SET `NextQuestID`=6126 WHERE `ID`=5927; +UPDATE `quest_template_addon` SET `NextQuestID`=6126 WHERE `ID`=5926; +UPDATE `quest_template_addon` SET `NextQuestID`=6126 WHERE `ID`=5928; +UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID`=6126; +UPDATE `quest_template_addon` SET `NextQuestID`=6145 WHERE `ID`=6144; +UPDATE `quest_template_addon` SET `NextQuestID`=6145 WHERE `ID`=14349; +UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID`=6145; +UPDATE `quest_template_addon` SET `NextQuestID`=7921 WHERE `ID`=7888; +UPDATE `quest_template_addon` SET `NextQuestID`=7921 WHERE `ID`=7887; +UPDATE `quest_template_addon` SET `NextQuestID`=7921 WHERE `ID`=7886; +UPDATE `quest_template_addon` SET `NextQuestID`=7921 WHERE `ID`=8292; +UPDATE `quest_template_addon` SET `NextQuestID`=7921 WHERE `ID`=7873; +UPDATE `quest_template_addon` SET `NextQuestID`=7921 WHERE `ID`=7872; +UPDATE `quest_template_addon` SET `NextQuestID`=7921 WHERE `ID`=7871; +UPDATE `quest_template_addon` SET `NextQuestID`=7921 WHERE `ID`=7788; +UPDATE `quest_template_addon` SET `NextQuestID`=7921 WHERE `ID`=8291; +UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID`=7921; +UPDATE `quest_template_addon` SET `NextQuestID`=8081 WHERE `ID`=8159; +UPDATE `quest_template_addon` SET `NextQuestID`=8081 WHERE `ID`=8158; +UPDATE `quest_template_addon` SET `NextQuestID`=8081 WHERE `ID`=8157; +UPDATE `quest_template_addon` SET `NextQuestID`=8081 WHERE `ID`=8155; +UPDATE `quest_template_addon` SET `NextQuestID`=8081 WHERE `ID`=8080; +UPDATE `quest_template_addon` SET `NextQuestID`=8081 WHERE `ID`=8154; +UPDATE `quest_template_addon` SET `NextQuestID`=8081 WHERE `ID`=8156; +UPDATE `quest_template_addon` SET `NextQuestID`=8081 WHERE `ID`=8297; +UPDATE `quest_template_addon` SET `NextQuestID`=8081 WHERE `ID`=8298; +UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID`=8081; +UPDATE `quest_template_addon` SET `NextQuestID`=8124 WHERE `ID`=8299; +UPDATE `quest_template_addon` SET `NextQuestID`=8124 WHERE `ID`=8300; +UPDATE `quest_template_addon` SET `NextQuestID`=8124 WHERE `ID`=8165; +UPDATE `quest_template_addon` SET `NextQuestID`=8124 WHERE `ID`=8163; +UPDATE `quest_template_addon` SET `NextQuestID`=8124 WHERE `ID`=8162; +UPDATE `quest_template_addon` SET `NextQuestID`=8124 WHERE `ID`=8161; +UPDATE `quest_template_addon` SET `NextQuestID`=8124 WHERE `ID`=8164; +UPDATE `quest_template_addon` SET `NextQuestID`=8124 WHERE `ID`=8123; +UPDATE `quest_template_addon` SET `NextQuestID`=8124 WHERE `ID`=8160; +UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID`=8124; +UPDATE `quest_template_addon` SET `NextQuestID`=8389 WHERE `ID`=8430; +UPDATE `quest_template_addon` SET `NextQuestID`=8389 WHERE `ID`=8368; +UPDATE `quest_template_addon` SET `NextQuestID`=8389 WHERE `ID`=8428; +UPDATE `quest_template_addon` SET `NextQuestID`=8389 WHERE `ID`=8427; +UPDATE `quest_template_addon` SET `NextQuestID`=8389 WHERE `ID`=8426; +UPDATE `quest_template_addon` SET `NextQuestID`=8389 WHERE `ID`=8431; +UPDATE `quest_template_addon` SET `NextQuestID`=8389 WHERE `ID`=8432; +UPDATE `quest_template_addon` SET `NextQuestID`=8389 WHERE `ID`=8433; +UPDATE `quest_template_addon` SET `NextQuestID`=8389 WHERE `ID`=8434; +UPDATE `quest_template_addon` SET `NextQuestID`=8389 WHERE `ID`=8435; +UPDATE `quest_template_addon` SET `NextQuestID`=8389 WHERE `ID`=8429; +UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID`=8389; +UPDATE `quest_template_addon` SET `NextQuestID`=8390 WHERE `ID`=8437; +UPDATE `quest_template_addon` SET `NextQuestID`=8390 WHERE `ID`=8438; +UPDATE `quest_template_addon` SET `NextQuestID`=8390 WHERE `ID`=8439; +UPDATE `quest_template_addon` SET `NextQuestID`=8390 WHERE `ID`=8442; +UPDATE `quest_template_addon` SET `NextQuestID`=8390 WHERE `ID`=8443; +UPDATE `quest_template_addon` SET `NextQuestID`=8390 WHERE `ID`=8441; +UPDATE `quest_template_addon` SET `NextQuestID`=8390 WHERE `ID`=8440; +UPDATE `quest_template_addon` SET `NextQuestID`=8390 WHERE `ID`=8370; +UPDATE `quest_template_addon` SET `NextQuestID`=8390 WHERE `ID`=8436; +UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID`=8390; +UPDATE `quest_template_addon` SET `NextQuestID`=8386 WHERE `ID`=8407; +UPDATE `quest_template_addon` SET `NextQuestID`=8386 WHERE `ID`=8406; +UPDATE `quest_template_addon` SET `NextQuestID`=8386 WHERE `ID`=8405; +UPDATE `quest_template_addon` SET `NextQuestID`=8386 WHERE `ID`=8404; +UPDATE `quest_template_addon` SET `NextQuestID`=8386 WHERE `ID`=8403; +UPDATE `quest_template_addon` SET `NextQuestID`=8386 WHERE `ID`=8402; +UPDATE `quest_template_addon` SET `NextQuestID`=8386 WHERE `ID`=8401; +UPDATE `quest_template_addon` SET `NextQuestID`=8386 WHERE `ID`=8400; +UPDATE `quest_template_addon` SET `NextQuestID`=8386 WHERE `ID`=8399; +UPDATE `quest_template_addon` SET `NextQuestID`=8386 WHERE `ID`=8372; +UPDATE `quest_template_addon` SET `NextQuestID`=8386 WHERE `ID`=8408; +UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID`=8386; +UPDATE `quest_template_addon` SET `NextQuestID`=8384 WHERE `ID`=8398; +UPDATE `quest_template_addon` SET `NextQuestID`=8384 WHERE `ID`=8397; +UPDATE `quest_template_addon` SET `NextQuestID`=8384 WHERE `ID`=8396; +UPDATE `quest_template_addon` SET `NextQuestID`=8384 WHERE `ID`=8395; +UPDATE `quest_template_addon` SET `NextQuestID`=8384 WHERE `ID`=8374; +UPDATE `quest_template_addon` SET `NextQuestID`=8384 WHERE `ID`=8394; +UPDATE `quest_template_addon` SET `NextQuestID`=8384 WHERE `ID`=8393; +UPDATE `quest_template_addon` SET `NextQuestID`=8384 WHERE `ID`=8392; +UPDATE `quest_template_addon` SET `NextQuestID`=8384 WHERE `ID`=8391; +UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID`=8384; +UPDATE `quest_template_addon` SET `NextQuestID`=8748 WHERE `ID`=8752; +UPDATE `quest_template_addon` SET `NextQuestID`=8748 WHERE `ID`=8757; +UPDATE `quest_template_addon` SET `NextQuestID`=8748 WHERE `ID`=8747; +UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID`=8748; +UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID`=8966; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`= 19 AND `SourceEntry`= 8966; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(19, 0, 8966, 0, 0, 8, 0, 8962, 0, 0, 0, 0, 0, '', "The Left Piece of Lord Valthalak's Amulet"), +(19, 0, 8966, 0, 1, 8, 0, 8963, 0, 0, 0, 0, 0, '', "The Left Piece of Lord Valthalak's Amulet"), +(19, 0, 8966, 0, 2, 8, 0, 8964, 0, 0, 0, 0, 0, '', "The Left Piece of Lord Valthalak's Amulet"), +(19, 0, 8966, 0, 3, 8, 0, 8965, 0, 0, 0, 0, 0, '', "The Left Piece of Lord Valthalak's Amulet"); +UPDATE `quest_template_addon` SET `NextQuestID`=10467 WHERE `ID`=10460; +UPDATE `quest_template_addon` SET `NextQuestID`=10467 WHERE `ID`=10461; +UPDATE `quest_template_addon` SET `NextQuestID`=10467 WHERE `ID`=10462; +UPDATE `quest_template_addon` SET `NextQuestID`=10467 WHERE `ID`=10463; +UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID`=10467; +UPDATE `quest_template_addon` SET `NextQuestID`=10554 WHERE `ID`=10552; +UPDATE `quest_template_addon` SET `NextQuestID`=10554 WHERE `ID`=10551; +UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID`=10554; +UPDATE `quest_template_addon` SET `NextQuestID`=10571 WHERE `ID`=10683; +UPDATE `quest_template_addon` SET `NextQuestID`=10571 WHERE `ID`=10568; +UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID`=10571; +UPDATE `quest_template_addon` SET `NextQuestID`=10816 WHERE `ID`=10619; +UPDATE `quest_template_addon` SET `NextQuestID`=10816 WHERE `ID`=10807; +UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID`=10816; +UPDATE `quest_template_addon` SET `NextQuestID`=10733 WHERE `ID`=10730; +UPDATE `quest_template_addon` SET `NextQuestID`=10733 WHERE `ID`=10729; +UPDATE `quest_template_addon` SET `NextQuestID`=10733 WHERE `ID`=10731; +UPDATE `quest_template_addon` SET `NextQuestID`=10733 WHERE `ID`=10732; +UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID`=10733; +UPDATE `quest_template_addon` SET `NextQuestID`=10897 WHERE `ID`=10906; +UPDATE `quest_template_addon` SET `NextQuestID`=10897 WHERE `ID`=10905; +UPDATE `quest_template_addon` SET `NextQuestID`=10897 WHERE `ID`=10907; +UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID`=10897; +UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID`=11023; +UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID`=11078; +UPDATE `quest_template_addon` SET `NextQuestID`=11978 WHERE `ID`=11977; +UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID`=11978; +UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID`=11982; +UPDATE `quest_template_addon` SET `NextQuestID`=12174 WHERE `ID`=12297; +UPDATE `quest_template_addon` SET `NextQuestID`=12174 WHERE `ID`=12171; +UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID`=12174; +UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID`=12310; +UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID`=12664; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`= 19 AND `SourceEntry`= 12664; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(19, 0, 12664, 0, 0, 8, 0, 12648, 0, 0, 0, 0, 0, '', "Dressing Down"); |