aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoroffl <offl@users.noreply.github.com>2017-11-15 01:25:43 +0100
committerKillyana <morphone1@gmail.com>2017-11-15 01:25:43 +0100
commit8161be2b19d82a79a3f114cd8ba6d6c4efdf9f9c (patch)
tree7d675619df37d34bed79a8667f2400e379bd7bc0
parent3446424540c5692c9e0ff11803d70e8129a5adc4 (diff)
DB/Quest: A Gift for the Warchief
Closes #19157
-rw-r--r--sql/updates/world/3.3.5/2017_11_14_17_world_335.sql21
1 files changed, 21 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_11_14_17_world_335.sql b/sql/updates/world/3.3.5/2017_11_14_17_world_335.sql
new file mode 100644
index 00000000000..86905b12dad
--- /dev/null
+++ b/sql/updates/world/3.3.5/2017_11_14_17_world_335.sql
@@ -0,0 +1,21 @@
+-- Love is in the Air: "A Gift for the ..." quests
+DELETE FROM `quest_request_items` WHERE `ID` IN (24597,24609,24610,24611,24612,24613,24614,24615);
+INSERT INTO `quest_request_items` (`ID`,`CompletionText`,`VerifiedBuild`) VALUES
+(24597,'Well met, $c. Did you have something for me?',-1),
+(24609,'Well met, $c. Did you have something for me?',-1),
+(24610,'Well met, $c. Did you have something for me?',-1),
+(24611,'Well met, $c. Did you have something for me?',-1),
+(24612,'Well met, $c. Did you have something for me?',-1),
+(24613,'Well met, $c. Did you have something for me?',-1),
+(24614,'Well met, $c. Did you have something for me?',-1),
+(24615,'Well met, $c. Did you have something for me?',-1);
+DELETE FROM `quest_offer_reward` WHERE `ID` IN (24597,24609,24610,24611,24612,24613,24614,24615);
+INSERT INTO `quest_offer_reward` (`ID`,`RewardText`,`VerifiedBuild`) VALUES
+(24597,'My thanks for this Lovely Charm Bracelet.',-1),
+(24609,'My thanks for this Lovely Charm Bracelet.',-1),
+(24610,'My thanks for this Lovely Charm Bracelet.',-1),
+(24611,'My thanks for this Lovely Charm Bracelet.',-1),
+(24612,'My thanks for this Lovely Charm Bracelet.',-1),
+(24613,'My thanks for this Lovely Charm Bracelet.',-1),
+(24614,'My thanks for this Lovely Charm Bracelet.',-1),
+(24615,'My thanks for this Lovely Charm Bracelet.',-1);