-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathQuestTemplate.sql
125 lines (116 loc) · 6.4 KB
/
QuestTemplate.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
-- Quest Template
-- --------------------------------------------------------------------------------------- --
SET
@QuestID = 0,
@PreviousQuest = 0,
@QuestStarterID = 0,
@QuestEnderID = 0,
@QuestType = 2, -- 0:Autocomplete, 2:Normal --
@QuestLevel = 0,
@MinLevel = 0,
@QuestSortID = 0, -- Area ID --
@QuestInfoID = 0,
@SuggestedGroupNum = 0,
@Flags = 0, -- 512:Hide rewards, 4096:Daily, 131072:Show item in quest tracker --
@StartItem = 0,
@TimeAllowed = 0,
@AllowableRaces = 0,
@SpecialFlags = 0, -- 1:Repeatable --
@LogTitle = 'The Quest to Collect Items',
@QuestDescription = 'I\'m a questgiver and I love items. Please collect some for me.',
@LogDescription = 'Questgiver wants you to collect some items.',
@AreaDescription = '',
@ObjectiveText1 = 'Items collected.',
@ObjectiveText2 = '',
@ObjectiveText3 = '',
@ObjectiveText4 = '',
@QuestCompletionLog = 'Return to Questgiver.',
@RequestItems = 'Have you collected those items?',
@OfferReward = 'Nice. Here\'s a reward.',
@RequiredNpcOrGo1 = 0,
@RequiredNpcOrGoCount1 = 0,
@RequiredNpcOrGo2 = 0,
@RequiredNpcOrGoCount2 = 0,
@RequiredNpcOrGo3 = 0,
@RequiredNpcOrGoCount3 = 0,
@RequiredNpcOrGo4 = 0,
@RequiredNpcOrGoCount4 = 0,
@RequiredItemId1 = 0,
@RequiredItemCount1 = 0,
@RequiredItemId2 = 0,
@RequiredItemCount2 = 0,
@RequiredItemId3 = 0,
@RequiredItemCount3 = 0,
@RequiredItemId4 = 0,
@RequiredItemCount4 = 0,
@RequiredItemId5 = 0,
@RequiredItemCount5 = 0,
@RequiredItemId6 = 0,
@RequiredItemCount6 = 0,
@RequiredFactionId1 = 0,
@RequiredFactionValue1 = 0,
@RequiredFactionId2 = 0,
@RequiredFactionValue2 = 0,
@RequiredPlayerKills = 0,
@RewardItem1 = 0,
@RewardAmount1 = 0,
@RewardItem2 = 0,
@RewardAmount2 = 0,
@RewardItem3 = 0,
@RewardAmount3 = 0,
@RewardItem4 = 0,
@RewardAmount4 = 0,
@RewardChoiceItemID1 = 0,
@RewardChoiceItemQuantity1 = 0,
@RewardChoiceItemID2 = 0,
@RewardChoiceItemQuantity2 = 0,
@RewardChoiceItemID3 = 0,
@RewardChoiceItemQuantity3 = 0,
@RewardChoiceItemID4 = 0,
@RewardChoiceItemQuantity4 = 0,
@RewardChoiceItemID5 = 0,
@RewardChoiceItemQuantity5 = 0,
@RewardChoiceItemID6 = 0,
@RewardChoiceItemQuantity6 = 0,
@RewardTitle = 0,
@RewardHonor = 0,
@RewardKillHonor = 0,
@RewardArenaPoints = 0,
@RewardXPDifficulty = 0,
@RewardMoney = 0,
@RewardMoneyDifficulty = 0,
@RewardDisplaySpell = 0,
@RewardSpell = 0,
@RewardFactionID1 = 0,
@RewardFactionOverride1 = 0,
@RewardNextQuest = 0,
@POIContinent = 0,
@POIx = 0,
@POIy = 0,
@POIPriority = 0,
@ItemDrop1 = 0,
@ItemDropQuantity1 = 0,
@ItemDrop2 = 0,
@ItemDropQuantity2 = 0,
@ItemDrop3 = 0,
@ItemDropQuantity3 = 0,
@ItemDrop4 = 0,
@ItemDropQuantity4 = 0,
@VerifiedBuild = 12345;
-- --------------------------------------------------------------------------------------- --
-- --------------------------------------------------------------------------------------- --
-- Add Quest --
DELETE FROM quest_template WHERE ID = @QuestID;
DELETE FROM quest_template_addon WHERE ID = @QuestID;
DELETE FROM quest_request_items WHERE ID = @QuestID;
DELETE FROM quest_offer_reward WHERE ID = @QuestID;
DELETE FROM creature_queststarter WHERE quest = @QuestID;
DELETE FROM creature_questender WHERE quest = @QuestID;
INSERT INTO quest_template VALUES (@QuestID,@QuestType,@QuestLevel,@MinLevel,@QuestSortID,@QuestInfoID,@SuggestedGroupNum,@RequiredFactionId1,@RequiredFactionId2,@RequiredFactionValue1,@RequiredFactionValue2,@RewardNextQuest,@RewardXPDifficulty,@RewardMoney,@RewardMoneyDifficulty,@RewardDisplaySpell,@RewardSpell,@RewardHonor,@RewardKillHonor,@StartItem,@Flags,@RequiredPlayerKills,@RewardItem1,@RewardAmount1,@RewardItem2,@RewardAmount2,@RewardItem3,@RewardAmount3,@RewardItem4,@RewardAmount4,@ItemDrop1,@ItemDropQuantity1,@ItemDrop2,@ItemDropQuantity2,@ItemDrop3,@ItemDropQuantity3,@ItemDrop4,@ItemDropQuantity4,@RewardChoiceItemID1,@RewardChoiceItemQuantity1,@RewardChoiceItemID2,@RewardChoiceItemQuantity2,@RewardChoiceItemID3,@RewardChoiceItemQuantity3,@RewardChoiceItemID4,@RewardChoiceItemQuantity4,@RewardChoiceItemID5,@RewardChoiceItemQuantity5,@RewardChoiceItemID6,@RewardChoiceItemQuantity6,@POIContinent,@POIx,@POIy,@POIPriority,@RewardTitle,0,@RewardArenaPoints,@RewardFactionID1,0,@RewardFactionOverride1,0,0,0,0,0,0,0,0,0,0,0,0,@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,0,@ObjectiveText1,@ObjectiveText2,@ObjectiveText3,@ObjectiveText4,@VerifiedBuild);
INSERT INTO quest_template_addon (ID, PrevQuestID, SpecialFlags) VALUES (@QuestID, @PreviousQuest, @SpecialFlags);
INSERT INTO quest_request_items VALUES (@QuestID, 1, 1, @RequestItems, @VerifiedBuild);
INSERT INTO quest_offer_reward VALUES (@QuestID, 1, 0, 0, 0, 0, 0, 0, 0, @OfferReward, @VerifiedBuild);
INSERT INTO creature_queststarter (id, quest) VALUES (@QuestStarterID, @QuestID);
INSERT INTO creature_questender (id, quest) VALUES (@QuestEnderID, @QuestID);
-- Add questgiver flag --
UPDATE creature_template SET npcflag=npcflag|2 WHERE entry IN (@QuestStarterID, @QuestEnderID);