diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2017_11_14_17_world_335.sql | 21 |
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); |