Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[3.3.5][Quest/DB fix] Armaments for War #16828

Closed
Rhisk opened this issue Mar 23, 2016 · 3 comments
Closed

[3.3.5][Quest/DB fix] Armaments for War #16828

Rhisk opened this issue Mar 23, 2016 · 3 comments

Comments

@Rhisk
Copy link

Rhisk commented Mar 23, 2016

Description: This quest is the final quest in Emissary Roman'khan quest line in Silithus. Have a separate version for each class except DK class.

Current behaviour: Some AllowableClasses in the db are in 0 or wrong.

Branch(es): 335

TC hash/commit: TrinityCore rev. 16f9d4c 2015-10-31 00:03:38 +0100 (3.3.5 branch) (Win64, Release)
TDB version: TDB 335.60

Operating system: Windows7

Fix:

DELETE FROM `quest_template_addon` WHERE `ID` IN (8316,8376,8377,8378,8379,8380,8381,8382);
INSERT INTO `quest_template_addon` (`ID`, `MaxLevel`, `AllowableClasses`, `SourceSpellID`, `PrevQuestID`, `NextQuestID`, `ExclusiveGroup`, `RewardMailTemplateID`, `RewardMailDelay`, `RequiredSkillID`, `RequiredSkillPoints`, `RequiredMinRepFaction`, `RequiredMaxRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepValue`, `ProvidedItemCount`, `SpecialFlags`) VALUES 
('8316', '0', '1', '0', '8315', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
('8376', '0', '2', '0', '8315', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
('8377', '0', '4', '0', '8315', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
('8378', '0', '8', '0', '8315', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
('8379', '0', '16', '0', '8315', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
('8380', '0', '64', '0', '8315', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
('8381', '0', '384', '0', '8315', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
('8382', '0', '1024', '0', '8315', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
@TrinityCoreBot
Copy link

This issue is not considered valid because of the following reasons:

  • No proper commit hash (revision)

Please read http://bit.ly/tc-issuetracker-and-you . Thanks.

@TrinityCoreBot TrinityCoreBot added the Invalid-IncompleteData/OrNotTrinityCore Reporter deleted parts or all template or he is using a 3rd party unsupported core. label Mar 23, 2016
@Aokromes
Copy link
Member

There is no need of delete and insert the rest of the classes, also we don't put ' around numbers.

@Rhisk
Copy link
Author

Rhisk commented Mar 23, 2016

I use Navicat, it put ' around numbers. Sorry for that.

Killyana added a commit that referenced this issue Mar 24, 2016
P-Kito pushed a commit to P-Kito/TrinityCore that referenced this issue Mar 27, 2016
@Aokromes Aokromes removed the Invalid-IncompleteData/OrNotTrinityCore Reporter deleted parts or all template or he is using a 3rd party unsupported core. label Sep 11, 2017
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants