diff options
| author | Shauren <shauren.trinity@gmail.com> | 2021-05-09 15:45:29 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2021-05-09 16:01:34 +0200 |
| commit | dd8aed421a48225b0e60c677969d1fc133954279 (patch) | |
| tree | 28a90ad1d4561fe10b3b6f5f9784a00aea73d72f /sql | |
| parent | f6094712de2b5f4d36f2a11bc44257ef7dbcb60f (diff) | |
Core/Quests: Drop unneeded QuestSpecialFlags
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2021_05_09_00_world.sql | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_05_09_00_world.sql b/sql/updates/world/master/2021_05_09_00_world.sql new file mode 100644 index 00000000000..5945bbbade7 --- /dev/null +++ b/sql/updates/world/master/2021_05_09_00_world.sql @@ -0,0 +1,20 @@ +UPDATE `quest_template_addon` SET `SpecialFlags`=`SpecialFlags`&~32; + +DELETE FROM `quest_template_addon` WHERE + `MaxLevel`=0 + AND `AllowableClasses`=0 + AND `SourceSpellID`=0 + AND `PrevQuestID`=0 + AND `NextQuestID`=0 + AND `ExclusiveGroup`=0 + AND `RewardMailTemplateID`=0 + AND `RewardMailDelay`=0 + AND `RequiredSkillID`=0 + AND `RequiredSkillPoints`=0 + AND `RequiredMinRepFaction`=0 + AND `RequiredMaxRepFaction`=0 + AND `RequiredMinRepValue`=0 + AND `RequiredMaxRepValue`=0 + AND `ProvidedItemCount`=0 + AND `SpecialFlags`=0 + AND `ScriptName`=''; |