DB: Fix some DB errors

Ref #15829

1 files changed, 538 insertions, 0 deletions

diff --git a/sql/updates/world/master/2018_03_29_00_world.sql b/sql/updates/world/master/2018_03_29_00_world.sql
new file mode 100644
index 00000000000..8988f509710
--- /dev/null
+++ b/sql/updates/world/master/2018_03_29_00_world.sql
@@ -0,0 +1,538 @@
+UPDATE `quest_template_addon` SET `SpecialFlags`=`SpecialFlags`|2 WHERE `ID`=24661;
+DELETE FROM `quest_template_addon` WHERE `ID` IN (38220,39174,40658,38535,38543,38544,38545,38550,38549,38547,38546,38551,38610,44426,38596,38894,38903,38850,38993,38940,39005,39009,39010,39030,39118,39156,39216,39273,39271,39282,39285,39303,39304,38994,39420,38834,38844,39460,39607,39609,39610,39671,39758,39828,39612,39613,39611,39759,39615,39616,39767,39829,39712,39017,40422,39717,39730,39732,39734,39745,39775,39794,39795,39797,39798,39865,39980,39981,39982,40622,40574,40124,39991,39517,39518,40340,40343,40374,40375,40398,40409,40410,40411,40122,38384,38382,38381,38142,38235,39384,38225,38147,40582,40581,40580,40584,40601,40609,40610,40612,40621,40619,40620,40627,40616,40638,40639,40640,40662,40663,40664,40521,40686,40688,40687,40701,40702,40703,40630,40708,40707,40709,40723,40722,40724,40736,40735,40732,40733,40734,40738,40737,40768,40781,40804,40810,40817,40818,40842,40843,40844,40921,40922,40923,40924,40936,40937,41079,41080,41081,41071,41072,41073,41074,41075,41092,41117,41148,40514,41153,41194,41246,41263,41330,41328,41329,41359,41559,41734,41805,41812,39695,41963,41982,42061,42073,42072,42078,42084,42085,42167,42189,42192,42212,42427,42456,42480,42482,42507,42513,42527,42528,42529,42530,42531,42532,42569,42570,42571,42572,42573,42574,42575,42576,42577,42578,42579,42580,42581,42595,42116,42727,42715,42716,42717,42718,42741,42842,42860,42871,42873,42874,42875,42876,42877,42878,42879,42891,42892,42893,42894,42895,42896,42898,42900,42902,42906,42907,42908,42909,42910,42934,42938,42941,42942,42943,42944,42945,42946,42947,42948,42949,42950,42136,42960,42135,42961,42972,40975,42973,43016,43159,43158,43366,43433,43442,43443,43444,43464,43467,43510,43511,43671,43646,43647,43648,43649,43650,43651,43652,43653,43654,43655,43656,43657,43658,43659,43660,43661,43662,43663,43664,43665,43666,43667,43668,43669,43670,43672,43673,43674,43675,43676,43677,43678,43679,43680,43681,43634,44188,43799,43682,43683,43684,43685,43688,43695,43704,43706,43707,43578,43579,43713,43715,43720,43719,43725,43727,43728,43729,43730,43731,43732,43733,43734,43735,43736,43737,45447,43760,43761,43775,43787,43788,43790,43789,43791,43800,43940,43941,43939,43952,43950,43953,43946,43947,43948,43965,43966,43967,43970,43972,43971,43976,43978,43977,43979,43981,43982,43983,40087,44036,44037,44038,44045,44046,44047,44059,41360,44060,44061,44062,44064,44065,44066,44069,44068,44079,43986,43987,43988,43989,44123,44129,44130,44131,44132,44133,42649,43795,44295,44307,44308,44309,44330,44331,44332,44342,44354,44358,44367,44368,44369,44371,44372,44373,44297,44376,44377,44378,44380,44382,44388,44390,44389,44402,44403,44404,44410,44408,44409,44419,44420,44418,44427,44428,44429,44432,44433,44434,44436,44444,44445,44446,44447,44455,44659,44698,44702,44761,44781,44853,44854,44951,44963,44965,44966,44970,45022,45023,45029,47213,47209,47212,47210,45302,45165,47208,45470,47207,45309,45310,45313,45315,45393,45394,45395,45396,47211,45518,45546,45636,45773,45815,45817,45822,45823,45824,45830,45828,45829,45831,45827,45826,45825,45984,46002,46768,46767,46033,46793,46734,41694,47195,46665,46775,46835,46870,46871,46939,46952,46955,47021,47044,47053,47038,47064,47062,47065,47063,47193,47191,47194,47196,47956,47954,47829,48064,48030,48031,48032,48033,48937,38995,48668);
+INSERT INTO `quest_template_addon` (`ID`, `SpecialFlags`) VALUES
+(38220,2),
+(39174,2),
+(40658,2),
+(38535,2),
+(38543,2),
+(38544,2),
+(38545,2),
+(38550,2),
+(38549,2),
+(38547,2),
+(38546,2),
+(38551,2),
+(38610,2),
+(44426,2),
+(38596,2),
+(38894,2),
+(38903,2),
+(38850,2),
+(38993,2),
+(38940,2),
+(39005,2),
+(39009,2),
+(39010,2),
+(39030,2),
+(39118,2),
+(39156,2),
+(39216,2),
+(39273,2),
+(39271,2),
+(39282,2),
+(39285,2),
+(39303,2),
+(39304,2),
+(38994,2),
+(39420,2),
+(38834,2),
+(38844,2),
+(39460,2),
+(39607,2),
+(39609,2),
+(39610,2),
+(39671,2),
+(39758,2),
+(39828,2),
+(39612,2),
+(39613,2),
+(39611,2),
+(39759,2),
+(39615,2),
+(39616,2),
+(39767,2),
+(39829,2),
+(39712,2),
+(39017,2),
+(40422,2),
+(39717,2),
+(39730,2),
+(39732,2),
+(39734,2),
+(39745,2),
+(39775,2),
+(39794,2),
+(39795,2),
+(39797,2),
+(39798,2),
+(39865,2),
+(39980,2),
+(39981,2),
+(39982,2),
+(40622,2),
+(40574,2),
+(40124,2),
+(39991,2),
+(39517,2),
+(39518,2),
+(40340,2),
+(40343,2),
+(40374,2),
+(40375,2),
+(40398,2),
+(40409,2),
+(40410,2),
+(40411,2),
+(40122,2),
+(38384,2),
+(38382,2),
+(38381,2),
+(38142,2),
+(38235,2),
+(39384,2),
+(38225,2),
+(38147,2),
+(40582,2),
+(40581,2),
+(40580,2),
+(40584,2),
+(40601,2),
+(40609,2),
+(40610,2),
+(40612,2),
+(40621,2),
+(40619,2),
+(40620,2),
+(40627,2),
+(40616,2),
+(40638,2),
+(40639,2),
+(40640,2),
+(40662,2),
+(40663,2),
+(40664,2),
+(40521,2),
+(40686,2),
+(40688,2),
+(40687,2),
+(40701,2),
+(40702,2),
+(40703,2),
+(40630,2),
+(40708,2),
+(40707,2),
+(40709,2),
+(40723,2),
+(40722,2),
+(40724,2),
+(40736,2),
+(40735,2),
+(40732,2),
+(40733,2),
+(40734,2),
+(40738,2),
+(40737,2),
+(40768,2),
+(40781,2),
+(40804,2),
+(40810,2),
+(40817,2),
+(40818,2),
+(40842,2),
+(40843,2),
+(40844,2),
+(40921,2),
+(40922,2),
+(40923,2),
+(40924,2),
+(40936,2),
+(40937,2),
+(41079,2),
+(41080,2),
+(41081,2),
+(41071,2),
+(41072,2),
+(41073,2),
+(41074,2),
+(41075,2),
+(41092,2),
+(41117,2),
+(41148,2),
+(40514,2),
+(41153,2),
+(41194,2),
+(41246,2),
+(41263,2),
+(41330,2),
+(41328,2),
+(41329,2),
+(41359,2),
+(41559,2),
+(41734,2),
+(41805,2),
+(41812,2),
+(39695,2),
+(41963,2),
+(41982,2),
+(42061,2),
+(42073,2),
+(42072,2),
+(42078,2),
+(42084,2),
+(42085,2),
+(42167,2),
+(42189,2),
+(42192,2),
+(42212,2),
+(42427,2),
+(42456,2),
+(42480,2),
+(42482,2),
+(42507,2),
+(42513,2),
+(42527,2),
+(42528,2),
+(42529,2),
+(42530,2),
+(42531,2),
+(42532,2),
+(42569,2),
+(42570,2),
+(42571,2),
+(42572,2),
+(42573,2),
+(42574,2),
+(42575,2),
+(42576,2),
+(42577,2),
+(42578,2),
+(42579,2),
+(42580,2),
+(42581,2),
+(42595,2),
+(42116,2),
+(42727,2),
+(42715,2),
+(42716,2),
+(42717,2),
+(42718,2),
+(42741,2),
+(42842,2),
+(42860,2),
+(42871,2),
+(42873,2),
+(42874,2),
+(42875,2),
+(42876,2),
+(42877,2),
+(42878,2),
+(42879,2),
+(42891,2),
+(42892,2),
+(42893,2),
+(42894,2),
+(42895,2),
+(42896,2),
+(42898,2),
+(42900,2),
+(42902,2),
+(42906,2),
+(42907,2),
+(42908,2),
+(42909,2),
+(42910,2),
+(42934,2),
+(42938,2),
+(42941,2),
+(42942,2),
+(42943,2),
+(42944,2),
+(42945,2),
+(42946,2),
+(42947,2),
+(42948,2),
+(42949,2),
+(42950,2),
+(42136,2),
+(42960,2),
+(42135,2),
+(42961,2),
+(42972,2),
+(40975,2),
+(42973,2),
+(43016,2),
+(43159,2),
+(43158,2),
+(43366,2),
+(43433,2),
+(43442,2),
+(43443,2),
+(43444,2),
+(43464,2),
+(43467,2),
+(43510,2),
+(43511,2),
+(43671,2),
+(43646,2),
+(43647,2),
+(43648,2),
+(43649,2),
+(43650,2),
+(43651,2),
+(43652,2),
+(43653,2),
+(43654,2),
+(43655,2),
+(43656,2),
+(43657,2),
+(43658,2),
+(43659,2),
+(43660,2),
+(43661,2),
+(43662,2),
+(43663,2),
+(43664,2),
+(43665,2),
+(43666,2),
+(43667,2),
+(43668,2),
+(43669,2),
+(43670,2),
+(43672,2),
+(43673,2),
+(43674,2),
+(43675,2),
+(43676,2),
+(43677,2),
+(43678,2),
+(43679,2),
+(43680,2),
+(43681,2),
+(43634,2),
+(44188,2),
+(43799,2),
+(43682,2),
+(43683,2),
+(43684,2),
+(43685,2),
+(43688,2),
+(43695,2),
+(43704,2),
+(43706,2),
+(43707,2),
+(43578,2),
+(43579,2),
+(43713,2),
+(43715,2),
+(43720,2),
+(43719,2),
+(43725,2),
+(43727,2),
+(43728,2),
+(43729,2),
+(43730,2),
+(43731,2),
+(43732,2),
+(43733,2),
+(43734,2),
+(43735,2),
+(43736,2),
+(43737,2),
+(45447,2),
+(43760,2),
+(43761,2),
+(43775,2),
+(43787,2),
+(43788,2),
+(43790,2),
+(43789,2),
+(43791,2),
+(43800,2),
+(43940,2),
+(43941,2),
+(43939,2),
+(43952,2),
+(43950,2),
+(43953,2),
+(43946,2),
+(43947,2),
+(43948,2),
+(43965,2),
+(43966,2),
+(43967,2),
+(43970,2),
+(43972,2),
+(43971,2),
+(43976,2),
+(43978,2),
+(43977,2),
+(43979,2),
+(43981,2),
+(43982,2),
+(43983,2),
+(40087,2),
+(44036,2),
+(44037,2),
+(44038,2),
+(44045,2),
+(44046,2),
+(44047,2),
+(44059,2),
+(41360,2),
+(44060,2),
+(44061,2),
+(44062,2),
+(44064,2),
+(44065,2),
+(44066,2),
+(44069,2),
+(44068,2),
+(44079,2),
+(43986,2),
+(43987,2),
+(43988,2),
+(43989,2),
+(44123,2),
+(44129,2),
+(44130,2),
+(44131,2),
+(44132,2),
+(44133,2),
+(42649,2),
+(43795,2),
+(44295,2),
+(44307,2),
+(44308,2),
+(44309,2),
+(44330,2),
+(44331,2),
+(44332,2),
+(44342,2),
+(44354,2),
+(44358,2),
+(44367,2),
+(44368,2),
+(44369,2),
+(44371,2),
+(44372,2),
+(44373,2),
+(44297,2),
+(44376,2),
+(44377,2),
+(44378,2),
+(44380,2),
+(44382,2),
+(44388,2),
+(44390,2),
+(44389,2),
+(44402,2),
+(44403,2),
+(44404,2),
+(44410,2),
+(44408,2),
+(44409,2),
+(44419,2),
+(44420,2),
+(44418,2),
+(44427,2),
+(44428,2),
+(44429,2),
+(44432,2),
+(44433,2),
+(44434,2),
+(44436,2),
+(44444,2),
+(44445,2),
+(44446,2),
+(44447,2),
+(44455,2),
+(44659,2),
+(44698,2),
+(44702,2),
+(44761,2),
+(44781,2),
+(44853,2),
+(44854,2),
+(44951,2),
+(44963,2),
+(44965,2),
+(44966,2),
+(44970,2),
+(45022,2),
+(45023,2),
+(45029,2),
+(47213,2),
+(47209,2),
+(47212,2),
+(47210,2),
+(45302,2),
+(45165,2),
+(47208,2),
+(45470,2),
+(47207,2),
+(45309,2),
+(45310,2),
+(45313,2),
+(45315,2),
+(45393,2),
+(45394,2),
+(45395,2),
+(45396,2),
+(47211,2),
+(45518,2),
+(45546,2),
+(45636,2),
+(45773,2),
+(45815,2),
+(45817,2),
+(45822,2),
+(45823,2),
+(45824,2),
+(45830,2),
+(45828,2),
+(45829,2),
+(45831,2),
+(45827,2),
+(45826,2),
+(45825,2),
+(45984,2),
+(46002,2),
+(46768,2),
+(46767,2),
+(46033,2),
+(46793,2),
+(46734,2),
+(41694,2),
+(47195,2),
+(46665,2),
+(46775,2),
+(46835,2),
+(46870,2),
+(46871,2),
+(46939,2),
+(46952,2),
+(46955,2),
+(47021,2),
+(47044,2),
+(47053,2),
+(47038,2),
+(47064,2),
+(47062,2),
+(47065,2),
+(47063,2),
+(47193,2),
+(47191,2),
+(47194,2),
+(47196,2),
+(47956,2),
+(47954,2),
+(47829,2),
+(48064,2),
+(48030,2),
+(48031,2),
+(48032,2),
+(48033,2),
+(48937,2),
+(38995,2),
+(48668,2);
\ No newline at end of file