· 9 years ago · Jan 17, 2017, 09:22 PM
1DROP TABLE IF EXISTS `1_quest_template_convert`;
2CREATE TABLE `1_quest_template_convert` (
3 `ID` mediumint(8) unsigned NOT NULL DEFAULT '0',
4 `QuestType` tinyint(3) unsigned NOT NULL DEFAULT '2',
5 `QuestLevel` smallint(3) NOT NULL DEFAULT '1',
6 `MinLevel` tinyint(3) unsigned NOT NULL DEFAULT '0',
7 `QuestSortID` smallint(6) NOT NULL DEFAULT '0',
8 `QuestInfoID` smallint(5) unsigned NOT NULL DEFAULT '0',
9 `SuggestedGroupNum` tinyint(3) unsigned NOT NULL DEFAULT '0',
10 `RequiredFactionId1` smallint(5) unsigned NOT NULL DEFAULT '0',
11 `RequiredFactionId2` smallint(5) unsigned NOT NULL DEFAULT '0',
12 `RequiredFactionValue1` mediumint(8) NOT NULL DEFAULT '0',
13 `RequiredFactionValue2` mediumint(8) NOT NULL DEFAULT '0',
14 `RewardNextQuest` mediumint(8) unsigned NOT NULL DEFAULT '0',
15 `RewardXPDifficulty` tinyint(3) unsigned NOT NULL DEFAULT '0',
16 `RewardMoney` int(11) NOT NULL DEFAULT '0',
17 `RewardBonusMoney` int(10) unsigned NOT NULL DEFAULT '0',
18 `RewardDisplaySpell` mediumint(8) unsigned NOT NULL DEFAULT '0',
19 `RewardSpell` int(11) NOT NULL DEFAULT '0',
20 `RewardHonor` int(11) NOT NULL DEFAULT '0',
21 `RewardKillHonor` float NOT NULL DEFAULT '0',
22 `StartItem` mediumint(8) unsigned NOT NULL DEFAULT '0',
23 `Flags` int(10) unsigned NOT NULL DEFAULT '0',
24 `RequiredPlayerKills` tinyint(3) unsigned NOT NULL DEFAULT '0',
25 `RewardItem1` mediumint(8) unsigned NOT NULL DEFAULT '0',
26 `RewardAmount1` smallint(5) unsigned NOT NULL DEFAULT '0',
27 `RewardItem2` mediumint(8) unsigned NOT NULL DEFAULT '0',
28 `RewardAmount2` smallint(5) unsigned NOT NULL DEFAULT '0',
29 `RewardItem3` mediumint(8) unsigned NOT NULL DEFAULT '0',
30 `RewardAmount3` smallint(5) unsigned NOT NULL DEFAULT '0',
31 `RewardItem4` mediumint(8) unsigned NOT NULL DEFAULT '0',
32 `RewardAmount4` smallint(5) unsigned NOT NULL DEFAULT '0',
33 `RewardChoiceItemID1` mediumint(8) unsigned NOT NULL DEFAULT '0',
34 `RewardChoiceItemQuantity1` smallint(5) unsigned NOT NULL DEFAULT '0',
35 `RewardChoiceItemID2` mediumint(8) unsigned NOT NULL DEFAULT '0',
36 `RewardChoiceItemQuantity2` smallint(5) unsigned NOT NULL DEFAULT '0',
37 `RewardChoiceItemID3` mediumint(8) unsigned NOT NULL DEFAULT '0',
38 `RewardChoiceItemQuantity3` smallint(5) unsigned NOT NULL DEFAULT '0',
39 `RewardChoiceItemID4` mediumint(8) unsigned NOT NULL DEFAULT '0',
40 `RewardChoiceItemQuantity4` smallint(5) unsigned NOT NULL DEFAULT '0',
41 `RewardChoiceItemID5` mediumint(8) unsigned NOT NULL DEFAULT '0',
42 `RewardChoiceItemQuantity5` smallint(5) unsigned NOT NULL DEFAULT '0',
43 `RewardChoiceItemID6` mediumint(8) unsigned NOT NULL DEFAULT '0',
44 `RewardChoiceItemQuantity6` smallint(5) unsigned NOT NULL DEFAULT '0',
45 `POIContinent` smallint(5) unsigned NOT NULL DEFAULT '0',
46 `POIx` float NOT NULL DEFAULT '0',
47 `POIy` float NOT NULL DEFAULT '0',
48 `POIPriority` mediumint(8) unsigned NOT NULL DEFAULT '0',
49 `RewardTitle` tinyint(3) unsigned NOT NULL DEFAULT '0',
50 `RewardTalents` tinyint(3) unsigned NOT NULL DEFAULT '0',
51 `RewardArenaPoints` smallint(5) unsigned NOT NULL DEFAULT '0',
52 `RewardFactionID1` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
53 `RewardFactionValue1` mediumint(8) NOT NULL DEFAULT '0',
54 `RewardFactionOverride1` mediumint(8) NOT NULL DEFAULT '0',
55 `RewardFactionID2` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
56 `RewardFactionValue2` mediumint(8) NOT NULL DEFAULT '0',
57 `RewardFactionOverride2` mediumint(8) NOT NULL DEFAULT '0',
58 `RewardFactionID3` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
59 `RewardFactionValue3` mediumint(8) NOT NULL DEFAULT '0',
60 `RewardFactionOverride3` mediumint(8) NOT NULL DEFAULT '0',
61 `RewardFactionID4` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
62 `RewardFactionValue4` mediumint(8) NOT NULL DEFAULT '0',
63 `RewardFactionOverride4` mediumint(8) NOT NULL DEFAULT '0',
64 `RewardFactionID5` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
65 `RewardFactionValue5` mediumint(8) NOT NULL DEFAULT '0',
66 `RewardFactionOverride5` mediumint(8) NOT NULL DEFAULT '0',
67 `TimeAllowed` int(10) unsigned NOT NULL DEFAULT '0',
68 `AllowableRaces` smallint(5) unsigned NOT NULL DEFAULT '0',
69 `LogTitle` text,
70 `LogDescription` text,
71 `QuestDescription` text,
72 `AreaDescription` text,
73 `QuestCompletionLog` text,
74 `RequiredNpcOrGo1` mediumint(8) NOT NULL DEFAULT '0',
75 `RequiredNpcOrGo2` mediumint(8) NOT NULL DEFAULT '0',
76 `RequiredNpcOrGo3` mediumint(8) NOT NULL DEFAULT '0',
77 `RequiredNpcOrGo4` mediumint(8) NOT NULL DEFAULT '0',
78 `RequiredNpcOrGoCount1` smallint(5) unsigned NOT NULL DEFAULT '0',
79 `RequiredNpcOrGoCount2` smallint(5) unsigned NOT NULL DEFAULT '0',
80 `RequiredNpcOrGoCount3` smallint(5) unsigned NOT NULL DEFAULT '0',
81 `RequiredNpcOrGoCount4` smallint(5) unsigned NOT NULL DEFAULT '0',
82 `RequiredItemId1` mediumint(8) unsigned NOT NULL DEFAULT '0',
83 `RequiredItemId2` mediumint(8) unsigned NOT NULL DEFAULT '0',
84 `RequiredItemId3` mediumint(8) unsigned NOT NULL DEFAULT '0',
85 `RequiredItemId4` mediumint(8) unsigned NOT NULL DEFAULT '0',
86 `RequiredItemId5` mediumint(8) unsigned NOT NULL DEFAULT '0',
87 `RequiredItemId6` mediumint(8) unsigned NOT NULL DEFAULT '0',
88 `RequiredItemCount1` smallint(5) unsigned NOT NULL DEFAULT '0',
89 `RequiredItemCount2` smallint(5) unsigned NOT NULL DEFAULT '0',
90 `RequiredItemCount3` smallint(5) unsigned NOT NULL DEFAULT '0',
91 `RequiredItemCount4` smallint(5) unsigned NOT NULL DEFAULT '0',
92 `RequiredItemCount5` smallint(5) unsigned NOT NULL DEFAULT '0',
93 `RequiredItemCount6` smallint(5) unsigned NOT NULL DEFAULT '0',
94 `Unknown0` tinyint(3) unsigned NOT NULL DEFAULT '0',
95 `ObjectiveText1` text,
96 `ObjectiveText2` text,
97 `ObjectiveText3` text,
98 `ObjectiveText4` text,
99 `VerifiedBuild` smallint(5) DEFAULT '0',
100 PRIMARY KEY (`ID`)
101) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Quest System';
102
103DROP TABLE IF EXISTS `1_quest_details_convert`;
104CREATE TABLE `1_quest_details_convert` (
105 `ID` mediumint(8) unsigned NOT NULL DEFAULT '0',
106 `Emote1` smallint(5) unsigned NOT NULL DEFAULT '0',
107 `Emote2` smallint(5) unsigned NOT NULL DEFAULT '0',
108 `Emote3` smallint(5) unsigned NOT NULL DEFAULT '0',
109 `Emote4` smallint(5) unsigned NOT NULL DEFAULT '0',
110 `EmoteDelay1` int(10) unsigned NOT NULL DEFAULT '0',
111 `EmoteDelay2` int(10) unsigned NOT NULL DEFAULT '0',
112 `EmoteDelay3` int(10) unsigned NOT NULL DEFAULT '0',
113 `EmoteDelay4` int(10) unsigned NOT NULL DEFAULT '0',
114 `VerifiedBuild` smallint(5) NOT NULL DEFAULT '0',
115 PRIMARY KEY (`ID`)
116) ENGINE=MyISAM DEFAULT CHARSET=utf8;
117
118DROP TABLE IF EXISTS `1_quest_offer_reward_convert`;
119CREATE TABLE `1_quest_offer_reward_convert` (
120 `ID` mediumint(8) unsigned NOT NULL DEFAULT '0',
121 `Emote1` smallint(5) unsigned NOT NULL DEFAULT '0',
122 `Emote2` smallint(5) unsigned NOT NULL DEFAULT '0',
123 `Emote3` smallint(5) unsigned NOT NULL DEFAULT '0',
124 `Emote4` smallint(5) unsigned NOT NULL DEFAULT '0',
125 `EmoteDelay1` int(10) unsigned NOT NULL DEFAULT '0',
126 `EmoteDelay2` int(10) unsigned NOT NULL DEFAULT '0',
127 `EmoteDelay3` int(10) unsigned NOT NULL DEFAULT '0',
128 `EmoteDelay4` int(10) unsigned NOT NULL DEFAULT '0',
129 `RewardText` text,
130 `VerifiedBuild` smallint(5) NOT NULL DEFAULT '0',
131 PRIMARY KEY (`ID`)
132) ENGINE=MyISAM DEFAULT CHARSET=utf8;
133
134DROP TABLE IF EXISTS `1_quest_request_items_convert`;
135CREATE TABLE `1_quest_request_items_convert` (
136 `ID` mediumint(8) unsigned NOT NULL DEFAULT '0',
137 `EmoteOnComplete` smallint(5) unsigned NOT NULL DEFAULT '0',
138 `EmoteOnIncomplete` smallint(5) unsigned NOT NULL DEFAULT '0',
139 `CompletionText` text,
140 `VerifiedBuild` smallint(5) NOT NULL DEFAULT '0',
141 PRIMARY KEY (`ID`)
142) ENGINE=MyISAM DEFAULT CHARSET=utf8;
143
144DROP TABLE IF EXISTS `1_quest_template_addon_converted`;
145CREATE TABLE `1_quest_template_addon_converted` (
146 `ID` mediumint(8) unsigned NOT NULL DEFAULT '0',
147 `MaxLevel` tinyint(3) unsigned NOT NULL DEFAULT '0',
148 `AllowableClasses` int(10) unsigned NOT NULL DEFAULT '0',
149 `SourceSpellID` mediumint(8) unsigned NOT NULL DEFAULT '0',
150 `PrevQuestID` mediumint(8) NOT NULL DEFAULT '0',
151 `NextQuestID` mediumint(8) NOT NULL DEFAULT '0',
152 `ExclusiveGroup` mediumint(8) NOT NULL DEFAULT '0',
153 `RewardMailTemplateID` mediumint(8) unsigned NOT NULL DEFAULT '0',
154 `RewardMailDelay` int(10) unsigned NOT NULL DEFAULT '0',
155 `RequiredSkillID` smallint(5) unsigned NOT NULL DEFAULT '0',
156 `RequiredSkillPoints` smallint(5) unsigned NOT NULL DEFAULT '0',
157 `RequiredMinRepFaction` smallint(5) unsigned NOT NULL DEFAULT '0',
158 `RequiredMaxRepFaction` smallint(5) unsigned NOT NULL DEFAULT '0',
159 `RequiredMinRepValue` mediumint(8) NOT NULL DEFAULT '0',
160 `RequiredMaxRepValue` mediumint(8) NOT NULL DEFAULT '0',
161 `ProvidedItemCount` tinyint(3) unsigned NOT NULL DEFAULT '0',
162 `SpecialFlags` tinyint(3) unsigned NOT NULL DEFAULT '0',
163 PRIMARY KEY (`ID`)
164) ENGINE=MyISAM DEFAULT CHARSET=utf8;
165
166DROP TABLE IF EXISTS `1_creature_questender`;
167CREATE TABLE `1_creature_questender` (
168 `id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier',
169 `quest` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
170 PRIMARY KEY (`id`,`quest`)
171) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Creature System';
172
173DROP TABLE IF EXISTS `1_creature_queststarter`;
174CREATE TABLE `1_creature_queststarter` (
175 `id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier',
176 `quest` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
177 PRIMARY KEY (`id`,`quest`)
178) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Creature System';
179
180INSERT INTO `1_quest_template_convert` (`ID`, `QuestType`, `QuestLevel`, `MinLevel`, `QuestSortID`, `QuestInfoID`, `SuggestedGroupNum`, `RequiredFactionId1`, `RequiredFactionId2`, `RequiredFactionValue1`, `RequiredFactionValue2`, `RewardNextQuest`, `RewardXPDifficulty`, `RewardMoney`, `RewardBonusMoney`, `RewardDisplaySpell`, `RewardSpell`, `RewardHonor`, `RewardKillHonor`, `StartItem`, `Flags`, `RequiredPlayerKills`, `RewardItem1`, `RewardAmount1`, `RewardItem2`, `RewardAmount2`, `RewardItem3`, `RewardAmount3`, `RewardItem4`, `RewardAmount4`, `RewardChoiceItemID1`, `RewardChoiceItemQuantity1`, `RewardChoiceItemID2`, `RewardChoiceItemQuantity2`, `RewardChoiceItemID3`, `RewardChoiceItemQuantity3`, `RewardChoiceItemID4`, `RewardChoiceItemQuantity4`, `RewardChoiceItemID5`, `RewardChoiceItemQuantity5`, `RewardChoiceItemID6`, `RewardChoiceItemQuantity6`, `POIContinent`, `POIx`, `POIy`, `POIPriority`, `RewardTitle`, `RewardTalents`, `RewardArenaPoints`, `RewardFactionID1`, `RewardFactionValue1`, `RewardFactionOverride1`, `RewardFactionID2`, `RewardFactionValue2`, `RewardFactionOverride2`, `RewardFactionID3`, `RewardFactionValue3`, `RewardFactionOverride3`, `RewardFactionID4`, `RewardFactionValue4`, `RewardFactionOverride4`, `RewardFactionID5`, `RewardFactionValue5`, `RewardFactionOverride5`, `TimeAllowed`, `AllowableRaces`, `LogTitle`, `LogDescription`, `QuestDescription`, `AreaDescription`, `QuestCompletionLog`, `RequiredNpcOrGo1`, `RequiredNpcOrGo2`, `RequiredNpcOrGo3`, `RequiredNpcOrGo4`, `RequiredNpcOrGoCount1`, `RequiredNpcOrGoCount2`, `RequiredNpcOrGoCount3`, `RequiredNpcOrGoCount4`, `RequiredItemId1`, `RequiredItemId2`, `RequiredItemId3`, `RequiredItemId4`, `RequiredItemId5`, `RequiredItemId6`, `RequiredItemCount1`, `RequiredItemCount2`, `RequiredItemCount3`, `RequiredItemCount4`, `RequiredItemCount5`, `RequiredItemCount6`, `Unknown0`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `VerifiedBuild`)
181SELECT `Id`, `Method`, `Level`, `MinLevel`, `ZoneOrSort`, `Type`, `SuggestedPlayers`, `RequiredFactionId1`, `RequiredFactionId2`, `RequiredFactionValue1`, `RequiredFactionValue2`, `NextQuestIdChain`, `RewardXPId`, `RewardOrRequiredMoney`, `RewardMoneyMaxLevel`, `RewardSpell`, `RewardSpellCast`, `RewardHonor`, `RewardHonorMultiplier`, `SourceItemId`, `Flags`, `RequiredPlayerKills`, `RewardItemId1`, `RewardItemCount1`, `RewardItemId2`, `RewardItemCount2`, `RewardItemId3`, `RewardItemCount3`, `RewardItemId4`, `RewardItemCount4`, `RewardChoiceItemId1`, `RewardChoiceItemCount1`, `RewardChoiceItemId2`, `RewardChoiceItemCount2`, `RewardChoiceItemId3`, `RewardChoiceItemCount3`, `RewardChoiceItemId4`, `RewardChoiceItemCount4`, `RewardChoiceItemId5`, `RewardChoiceItemCount5`, `RewardChoiceItemId6`, `RewardChoiceItemCount6`, `PointMapId`, `PointX`, `PointY`, `PointOption`, `RewardTitleId`, `RewardTalents`, `RewardArenaPoints`, `RewardFactionId1`, `RewardFactionValueId1`, `RewardFactionValueIdOverride1`, `RewardFactionId2`, `RewardFactionValueId2`, `RewardFactionValueIdOverride2`, `RewardFactionId3`, `RewardFactionValueId3`, `RewardFactionValueIdOverride3`, `RewardFactionId4`, `RewardFactionValueId4`, `RewardFactionValueIdOverride4`, `RewardFactionId5`, `RewardFactionValueId5`, `RewardFactionValueIdOverride5`, `LimitTime`, `RequiredRaces`, `Title`, `Objectives`, `Details`, `EndText`, `CompletedText`, `RequiredNpcOrGo1`, `RequiredNpcOrGo2`, `RequiredNpcOrGo3`, `RequiredNpcOrGo4`, `RequiredNpcOrGoCount1`, `RequiredNpcOrGoCount2`, `RequiredNpcOrGoCount3`, `RequiredNpcOrGoCount4`, `RequiredItemId1`, `RequiredItemId2`, `RequiredItemId3`, `RequiredItemId4`, `RequiredItemId5`, `RequiredItemId6`, `RequiredItemCount1`, `RequiredItemCount2`, `RequiredItemCount3`, `RequiredItemCount4`, `RequiredItemCount5`, `RequiredItemCount6`, `Unknown0`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `WDBVerified` FROM `quest_template` WHERE `Id` IN (32050, 32051, 20040, 20041, 20042, 20043, 20044);
182
183INSERT INTO `1_quest_details_convert` (`ID`, `Emote1`, `Emote2`,`Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `VerifiedBuild`)
184SELECT `Id`, `DetailsEmote1`, `DetailsEmote2`,`DetailsEmote3`, `DetailsEmote4`, `DetailsEmoteDelay1`, `DetailsEmoteDelay2`, `DetailsEmoteDelay3`, `DetailsEmoteDelay4`, `WDBVerified` FROM `quest_template` WHERE `Id` IN (32050, 32051, 20040, 20041, 20042, 20043, 20044);
185
186INSERT INTO `1_quest_offer_reward_convert` (`ID`, `Emote1`, `Emote2`,`Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`)
187SELECT `Id`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `OfferRewardEmoteDelay1`, `OfferRewardEmoteDelay2`, `OfferRewardEmoteDelay3`, `OfferRewardEmoteDelay4`, `OfferRewardText`, `WDBVerified` FROM `quest_template` WHERE `Id` IN (32050, 32051, 20040, 20041, 20042, 20043, 20044);
188
189INSERT INTO `1_quest_request_items_convert` (`ID`, `EmoteOnComplete`, `EmoteOnIncomplete`,`CompletionText`, `VerifiedBuild`)
190SELECT `Id`, `EmoteOnComplete`, `EmoteOnIncomplete`,`RequestItemsText`, `WDBVerified` FROM `quest_template` WHERE `Id` IN (32050, 32051, 20040, 20041, 20042, 20043, 20044);
191
192INSERT INTO `1_quest_template_addon_converted` (`ID`, `MaxLevel`, `AllowableClasses`, `SourceSpellID`, `PrevQuestID`, `NextQuestID`, `ExclusiveGroup`, `RewardMailTemplateID`, `RewardMailDelay`, `RequiredSkillID`, `RequiredSkillPoints`, `RequiredMinRepFaction`, `RequiredMaxRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepValue`, `ProvidedItemCount`, `SpecialFlags`)
193SELECT `Id`, `MaxLevel`, `RequiredClasses`, `SourceSpellId`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `RewardMailTemplateId`, `RewardMailDelay`, `RequiredSkillId`, `RequiredSkillPoints`, `RequiredMinRepFaction`, `RequiredMaxRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepValue`, `SourceItemCount`, `SpecialFlags` FROM `quest_template` WHERE `Id` IN (32050, 32051, 20040, 20041, 20042, 20043, 20044);
194
195INSERT INTO `1_creature_questender` (`id`, `quest`)
196SELECT `id`, `quest` FROM `creature_involvedrelation` WHERE `quest` IN (32050, 32051, 20040, 20041, 20042, 20043, 20044);
197
198INSERT INTO `1_creature_queststarter` (`id`, `quest`)
199SELECT `id`, `quest` FROM `creature_questrelation` WHERE `quest` IN (32050, 32051, 20040, 20041, 20042, 20043, 20044);