Advertisement
Guest User

Untitled

a guest
Jan 17th, 2017
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 15.93 KB | None | 0 0
  1. DROP TABLE IF EXISTS `1_quest_template_convert`;
  2. CREATE 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.  
  103. DROP TABLE IF EXISTS `1_quest_details_convert`;
  104. CREATE 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.  
  118. DROP TABLE IF EXISTS `1_quest_offer_reward_convert`;
  119. CREATE 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.  
  134. DROP TABLE IF EXISTS `1_quest_request_items_convert`;
  135. CREATE 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.  
  144. DROP TABLE IF EXISTS `1_quest_template_addon_converted`;
  145. CREATE 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.  
  166. DROP TABLE IF EXISTS `1_creature_questender`;
  167. CREATE 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.  
  173. DROP TABLE IF EXISTS `1_creature_queststarter`;
  174. CREATE 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.  
  180. INSERT 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`)
  181. SELECT `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.  
  183. INSERT INTO `1_quest_details_convert` (`ID`, `Emote1`, `Emote2`,`Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `VerifiedBuild`)
  184. SELECT `Id`, `DetailsEmote1`, `DetailsEmote2`,`DetailsEmote3`, `DetailsEmote4`, `DetailsEmoteDelay1`, `DetailsEmoteDelay2`, `DetailsEmoteDelay3`, `DetailsEmoteDelay4`, `WDBVerified` FROM `quest_template` WHERE `Id` IN (32050, 32051, 20040, 20041, 20042, 20043, 20044);
  185.  
  186. INSERT INTO `1_quest_offer_reward_convert` (`ID`, `Emote1`, `Emote2`,`Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`)
  187. SELECT `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.  
  189. INSERT INTO `1_quest_request_items_convert` (`ID`, `EmoteOnComplete`, `EmoteOnIncomplete`,`CompletionText`, `VerifiedBuild`)
  190. SELECT `Id`, `EmoteOnComplete`, `EmoteOnIncomplete`,`RequestItemsText`, `WDBVerified` FROM `quest_template` WHERE `Id` IN (32050, 32051, 20040, 20041, 20042, 20043, 20044);
  191.  
  192. INSERT INTO `1_quest_template_addon_converted` (`ID`, `MaxLevel`, `AllowableClasses`, `SourceSpellID`, `PrevQuestID`, `NextQuestID`, `ExclusiveGroup`, `RewardMailTemplateID`, `RewardMailDelay`, `RequiredSkillID`, `RequiredSkillPoints`, `RequiredMinRepFaction`, `RequiredMaxRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepValue`, `ProvidedItemCount`, `SpecialFlags`)
  193. SELECT `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.  
  195. INSERT INTO `1_creature_questender` (`id`, `quest`)
  196. SELECT `id`, `quest` FROM `creature_involvedrelation` WHERE `quest` IN (32050, 32051, 20040, 20041, 20042, 20043, 20044);
  197.  
  198. INSERT INTO `1_creature_queststarter` (`id`, `quest`)
  199. SELECT `id`, `quest` FROM `creature_questrelation` WHERE `quest` IN (32050, 32051, 20040, 20041, 20042, 20043, 20044);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement