Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DROP TABLE IF EXISTS `1_quest_template_convert`;
- CREATE TABLE `1_quest_template_convert` (
- `ID` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `QuestType` tinyint(3) unsigned NOT NULL DEFAULT '2',
- `QuestLevel` smallint(3) NOT NULL DEFAULT '1',
- `MinLevel` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `QuestSortID` smallint(6) NOT NULL DEFAULT '0',
- `QuestInfoID` smallint(5) unsigned NOT NULL DEFAULT '0',
- `SuggestedGroupNum` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `RequiredFactionId1` smallint(5) unsigned NOT NULL DEFAULT '0',
- `RequiredFactionId2` smallint(5) unsigned NOT NULL DEFAULT '0',
- `RequiredFactionValue1` mediumint(8) NOT NULL DEFAULT '0',
- `RequiredFactionValue2` mediumint(8) NOT NULL DEFAULT '0',
- `RewardNextQuest` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `RewardXPDifficulty` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `RewardMoney` int(11) NOT NULL DEFAULT '0',
- `RewardBonusMoney` int(10) unsigned NOT NULL DEFAULT '0',
- `RewardDisplaySpell` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `RewardSpell` int(11) NOT NULL DEFAULT '0',
- `RewardHonor` int(11) NOT NULL DEFAULT '0',
- `RewardKillHonor` float NOT NULL DEFAULT '0',
- `StartItem` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `Flags` int(10) unsigned NOT NULL DEFAULT '0',
- `RequiredPlayerKills` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `RewardItem1` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `RewardAmount1` smallint(5) unsigned NOT NULL DEFAULT '0',
- `RewardItem2` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `RewardAmount2` smallint(5) unsigned NOT NULL DEFAULT '0',
- `RewardItem3` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `RewardAmount3` smallint(5) unsigned NOT NULL DEFAULT '0',
- `RewardItem4` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `RewardAmount4` smallint(5) unsigned NOT NULL DEFAULT '0',
- `RewardChoiceItemID1` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `RewardChoiceItemQuantity1` smallint(5) unsigned NOT NULL DEFAULT '0',
- `RewardChoiceItemID2` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `RewardChoiceItemQuantity2` smallint(5) unsigned NOT NULL DEFAULT '0',
- `RewardChoiceItemID3` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `RewardChoiceItemQuantity3` smallint(5) unsigned NOT NULL DEFAULT '0',
- `RewardChoiceItemID4` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `RewardChoiceItemQuantity4` smallint(5) unsigned NOT NULL DEFAULT '0',
- `RewardChoiceItemID5` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `RewardChoiceItemQuantity5` smallint(5) unsigned NOT NULL DEFAULT '0',
- `RewardChoiceItemID6` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `RewardChoiceItemQuantity6` smallint(5) unsigned NOT NULL DEFAULT '0',
- `POIContinent` smallint(5) unsigned NOT NULL DEFAULT '0',
- `POIx` float NOT NULL DEFAULT '0',
- `POIy` float NOT NULL DEFAULT '0',
- `POIPriority` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `RewardTitle` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `RewardTalents` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `RewardArenaPoints` smallint(5) unsigned NOT NULL DEFAULT '0',
- `RewardFactionID1` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
- `RewardFactionValue1` mediumint(8) NOT NULL DEFAULT '0',
- `RewardFactionOverride1` mediumint(8) NOT NULL DEFAULT '0',
- `RewardFactionID2` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
- `RewardFactionValue2` mediumint(8) NOT NULL DEFAULT '0',
- `RewardFactionOverride2` mediumint(8) NOT NULL DEFAULT '0',
- `RewardFactionID3` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
- `RewardFactionValue3` mediumint(8) NOT NULL DEFAULT '0',
- `RewardFactionOverride3` mediumint(8) NOT NULL DEFAULT '0',
- `RewardFactionID4` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
- `RewardFactionValue4` mediumint(8) NOT NULL DEFAULT '0',
- `RewardFactionOverride4` mediumint(8) NOT NULL DEFAULT '0',
- `RewardFactionID5` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
- `RewardFactionValue5` mediumint(8) NOT NULL DEFAULT '0',
- `RewardFactionOverride5` mediumint(8) NOT NULL DEFAULT '0',
- `TimeAllowed` int(10) unsigned NOT NULL DEFAULT '0',
- `AllowableRaces` smallint(5) unsigned NOT NULL DEFAULT '0',
- `LogTitle` text,
- `LogDescription` text,
- `QuestDescription` text,
- `AreaDescription` text,
- `QuestCompletionLog` text,
- `RequiredNpcOrGo1` mediumint(8) NOT NULL DEFAULT '0',
- `RequiredNpcOrGo2` mediumint(8) NOT NULL DEFAULT '0',
- `RequiredNpcOrGo3` mediumint(8) NOT NULL DEFAULT '0',
- `RequiredNpcOrGo4` mediumint(8) NOT NULL DEFAULT '0',
- `RequiredNpcOrGoCount1` smallint(5) unsigned NOT NULL DEFAULT '0',
- `RequiredNpcOrGoCount2` smallint(5) unsigned NOT NULL DEFAULT '0',
- `RequiredNpcOrGoCount3` smallint(5) unsigned NOT NULL DEFAULT '0',
- `RequiredNpcOrGoCount4` smallint(5) unsigned NOT NULL DEFAULT '0',
- `RequiredItemId1` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `RequiredItemId2` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `RequiredItemId3` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `RequiredItemId4` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `RequiredItemId5` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `RequiredItemId6` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `RequiredItemCount1` smallint(5) unsigned NOT NULL DEFAULT '0',
- `RequiredItemCount2` smallint(5) unsigned NOT NULL DEFAULT '0',
- `RequiredItemCount3` smallint(5) unsigned NOT NULL DEFAULT '0',
- `RequiredItemCount4` smallint(5) unsigned NOT NULL DEFAULT '0',
- `RequiredItemCount5` smallint(5) unsigned NOT NULL DEFAULT '0',
- `RequiredItemCount6` smallint(5) unsigned NOT NULL DEFAULT '0',
- `Unknown0` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `ObjectiveText1` text,
- `ObjectiveText2` text,
- `ObjectiveText3` text,
- `ObjectiveText4` text,
- `VerifiedBuild` smallint(5) DEFAULT '0',
- PRIMARY KEY (`ID`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Quest System';
- DROP TABLE IF EXISTS `1_quest_details_convert`;
- CREATE TABLE `1_quest_details_convert` (
- `ID` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `Emote1` smallint(5) unsigned NOT NULL DEFAULT '0',
- `Emote2` smallint(5) unsigned NOT NULL DEFAULT '0',
- `Emote3` smallint(5) unsigned NOT NULL DEFAULT '0',
- `Emote4` smallint(5) unsigned NOT NULL DEFAULT '0',
- `EmoteDelay1` int(10) unsigned NOT NULL DEFAULT '0',
- `EmoteDelay2` int(10) unsigned NOT NULL DEFAULT '0',
- `EmoteDelay3` int(10) unsigned NOT NULL DEFAULT '0',
- `EmoteDelay4` int(10) unsigned NOT NULL DEFAULT '0',
- `VerifiedBuild` smallint(5) NOT NULL DEFAULT '0',
- PRIMARY KEY (`ID`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
- DROP TABLE IF EXISTS `1_quest_offer_reward_convert`;
- CREATE TABLE `1_quest_offer_reward_convert` (
- `ID` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `Emote1` smallint(5) unsigned NOT NULL DEFAULT '0',
- `Emote2` smallint(5) unsigned NOT NULL DEFAULT '0',
- `Emote3` smallint(5) unsigned NOT NULL DEFAULT '0',
- `Emote4` smallint(5) unsigned NOT NULL DEFAULT '0',
- `EmoteDelay1` int(10) unsigned NOT NULL DEFAULT '0',
- `EmoteDelay2` int(10) unsigned NOT NULL DEFAULT '0',
- `EmoteDelay3` int(10) unsigned NOT NULL DEFAULT '0',
- `EmoteDelay4` int(10) unsigned NOT NULL DEFAULT '0',
- `RewardText` text,
- `VerifiedBuild` smallint(5) NOT NULL DEFAULT '0',
- PRIMARY KEY (`ID`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
- DROP TABLE IF EXISTS `1_quest_request_items_convert`;
- CREATE TABLE `1_quest_request_items_convert` (
- `ID` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `EmoteOnComplete` smallint(5) unsigned NOT NULL DEFAULT '0',
- `EmoteOnIncomplete` smallint(5) unsigned NOT NULL DEFAULT '0',
- `CompletionText` text,
- `VerifiedBuild` smallint(5) NOT NULL DEFAULT '0',
- PRIMARY KEY (`ID`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
- DROP TABLE IF EXISTS `1_quest_template_addon_converted`;
- CREATE TABLE `1_quest_template_addon_converted` (
- `ID` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `MaxLevel` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `AllowableClasses` int(10) unsigned NOT NULL DEFAULT '0',
- `SourceSpellID` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `PrevQuestID` mediumint(8) NOT NULL DEFAULT '0',
- `NextQuestID` mediumint(8) NOT NULL DEFAULT '0',
- `ExclusiveGroup` mediumint(8) NOT NULL DEFAULT '0',
- `RewardMailTemplateID` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `RewardMailDelay` int(10) unsigned NOT NULL DEFAULT '0',
- `RequiredSkillID` smallint(5) unsigned NOT NULL DEFAULT '0',
- `RequiredSkillPoints` smallint(5) unsigned NOT NULL DEFAULT '0',
- `RequiredMinRepFaction` smallint(5) unsigned NOT NULL DEFAULT '0',
- `RequiredMaxRepFaction` smallint(5) unsigned NOT NULL DEFAULT '0',
- `RequiredMinRepValue` mediumint(8) NOT NULL DEFAULT '0',
- `RequiredMaxRepValue` mediumint(8) NOT NULL DEFAULT '0',
- `ProvidedItemCount` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `SpecialFlags` tinyint(3) unsigned NOT NULL DEFAULT '0',
- PRIMARY KEY (`ID`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
- DROP TABLE IF EXISTS `1_creature_questender`;
- CREATE TABLE `1_creature_questender` (
- `id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier',
- `quest` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
- PRIMARY KEY (`id`,`quest`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Creature System';
- DROP TABLE IF EXISTS `1_creature_queststarter`;
- CREATE TABLE `1_creature_queststarter` (
- `id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier',
- `quest` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
- PRIMARY KEY (`id`,`quest`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Creature System';
- 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`)
- 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);
- INSERT INTO `1_quest_details_convert` (`ID`, `Emote1`, `Emote2`,`Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `VerifiedBuild`)
- SELECT `Id`, `DetailsEmote1`, `DetailsEmote2`,`DetailsEmote3`, `DetailsEmote4`, `DetailsEmoteDelay1`, `DetailsEmoteDelay2`, `DetailsEmoteDelay3`, `DetailsEmoteDelay4`, `WDBVerified` FROM `quest_template` WHERE `Id` IN (32050, 32051, 20040, 20041, 20042, 20043, 20044);
- INSERT INTO `1_quest_offer_reward_convert` (`ID`, `Emote1`, `Emote2`,`Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`)
- 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);
- INSERT INTO `1_quest_request_items_convert` (`ID`, `EmoteOnComplete`, `EmoteOnIncomplete`,`CompletionText`, `VerifiedBuild`)
- SELECT `Id`, `EmoteOnComplete`, `EmoteOnIncomplete`,`RequestItemsText`, `WDBVerified` FROM `quest_template` WHERE `Id` IN (32050, 32051, 20040, 20041, 20042, 20043, 20044);
- INSERT INTO `1_quest_template_addon_converted` (`ID`, `MaxLevel`, `AllowableClasses`, `SourceSpellID`, `PrevQuestID`, `NextQuestID`, `ExclusiveGroup`, `RewardMailTemplateID`, `RewardMailDelay`, `RequiredSkillID`, `RequiredSkillPoints`, `RequiredMinRepFaction`, `RequiredMaxRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepValue`, `ProvidedItemCount`, `SpecialFlags`)
- 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);
- INSERT INTO `1_creature_questender` (`id`, `quest`)
- SELECT `id`, `quest` FROM `creature_involvedrelation` WHERE `quest` IN (32050, 32051, 20040, 20041, 20042, 20043, 20044);
- INSERT INTO `1_creature_queststarter` (`id`, `quest`)
- 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