diff options
| -rw-r--r-- | sql/updates/world/master/2017_11_20_00_world.sql | 59 |
1 files changed, 59 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_11_20_00_world.sql b/sql/updates/world/master/2017_11_20_00_world.sql new file mode 100644 index 00000000000..bd2e1d25ae6 --- /dev/null +++ b/sql/updates/world/master/2017_11_20_00_world.sql @@ -0,0 +1,59 @@ +-- The Rise of the Darkspear Quest +DELETE FROM `quest_offer_reward` WHERE `ID` IN (26272,24764,24607,24750,24776,24782,24758,24770); +INSERT INTO `quest_offer_reward` (`ID`,`RewardText`,`VerifiedBuild`) VALUES +(26272, 'Anotha newblood, eh?$B$BYa actually have a sly look about ya though. Fierce eyes. You might have the makings of a real $c.$B$BLets not waste anymore time ''den.',25383), +(24764, 'Anotha newblood, eh?$B$BYa actually have a sly look about ya though. Fierce eyes. You might have the makings of a real $c.$B$BLets not waste anymore time ''den.',25383), +(24607, 'Anotha newblood, eh?$B$BYa actually have a sly look about ya though. Fierce eyes. You might have the makings of a real $c.$B$BLets not waste anymore time ''den.',25383), +(24750, 'Anotha newblood, eh?$B$BYa actually have a sly look about ya though. Fierce eyes. You might have the makings of a real $c.$B$BLets not waste anymore time ''den.',25383), +(24776, 'Anotha newblood, eh?$B$BYa actually have a sly look about ya though. Fierce eyes. You might have the makings of a real $c.$B$BLets not waste anymore time ''den.',25383), +(24782, 'Anotha newblood, eh?$B$BYa actually have a sly look about ya though. Fierce eyes. You might have the makings of a real $c.$B$BLets not waste anymore time ''den.',25383), +(24758, 'Anotha newblood, eh?$B$BYa actually have a sly look about ya though. Fierce eyes. You might have the makings of a real $c.$B$BLets not waste anymore time ''den.',25383), +(24770, 'Anotha newblood, eh?$B$BYa actually have a sly look about ya though. Fierce eyes. You might have the makings of a real $c.$B$BLets not waste anymore time ''den.',25383); + +-- The Basics: Hitting Things Quest +DELETE FROM `quest_offer_reward` WHERE `ID` IN (24777,24765,24759,24783,24751,24639,24771,26273); +INSERT INTO `quest_offer_reward` (`ID`,`RewardText`,`VerifiedBuild`) VALUES +(24777, 'Not bad, mon. Ya have a natural flow to ya swings - you may have a talent for dis.$B$BSome rough edges ta be sure, but we''ll get dose ironed out here and I''ll teach ya a few new tings as we go.',25383), +(24765, 'Not bad, mon. Ya have a natural flow to ya swings - you may have a talent for dis.$B$BSome rough edges ta be sure, but we''ll get dose ironed out here and I''ll teach ya a few new tings as we go.',25383), +(24759, 'Not bad, mon. Ya have a natural flow to ya swings - you may have a talent for dis.$B$BSome rough edges ta be sure, but we''ll get dose ironed out here and I''ll teach ya a few new tings as we go.',25383), +(24783, 'Not bad, mon. Ya have a natural flow to ya swings - you may have a talent for dis.$B$BSome rough edges ta be sure, but we''ll get dose ironed out here and I''ll teach ya a few new tings as we go.',25383), +(24751, 'Not bad, mon. Ya have a natural flow to ya swings - you may have a talent for dis.$B$BSome rough edges ta be sure, but we''ll get dose ironed out here and I''ll teach ya a few new tings as we go.',25383), +(24639, 'Not bad, mon. Ya have a natural flow to ya swings - you may have a talent for dis.$B$BSome rough edges ta be sure, but we''ll get dose ironed out here and I''ll teach ya a few new tings as we go.',25383), +(24771, 'Not bad, mon. Ya have a natural flow to ya swings - you may have a talent for dis.$B$BSome rough edges ta be sure, but we''ll get dose ironed out here and I''ll teach ya a few new tings as we go.',25383), +(26273, 'Not bad, mon. Ya have a natural flow to ya swings - you may have a talent for dis.$B$BSome rough edges ta be sure, but we''ll get dose ironed out here and I''ll teach ya a few new tings as we go.',25383); + +-- A Rough Start Quest +DELETE FROM `quest_offer_reward` WHERE `ID` IN (24641,24785,24761,26275,24767,24753,24773,24779); +INSERT INTO `quest_offer_reward` (`ID`,`RewardText`,`VerifiedBuild`) VALUES +(24641, 'Dese are some fine pelts, $G boy:girl;. We could make some hefty cloaks outta dese.',25383), +(24785, 'Dese are some fine pelts, $G boy:girl;. We could make some hefty cloaks outta dese.',25383), +(24761, 'Dese are some fine pelts, $G boy:girl;. We could make some hefty cloaks outta dese.',25383), +(26275, 'Dese are some fine pelts, $G boy:girl;. We could make some hefty cloaks outta dese.',25383), +(24767, 'Dese are some fine pelts, $G boy:girl;. We could make some hefty cloaks outta dese.',25383), +(24753, 'Dese are some fine pelts, $G boy:girl;. We could make some hefty cloaks outta dese.',25383), +(24773, 'Dese are some fine pelts, $G boy:girl;. We could make some hefty cloaks outta dese.',25383), +(24779, 'Dese are some fine pelts, $G boy:girl;. We could make some hefty cloaks outta dese.',25383); + +-- Proving Pit Quest +DELETE FROM `quest_offer_reward` WHERE `ID` IN (24768,24780,24642,24786,24754,26276,24774,24762); +INSERT INTO `quest_offer_reward` (`ID`,`RewardText`,`VerifiedBuild`) VALUES +(24768, 'Ya handle yerself quite well. Ya gonna be quite powerful some day.',25383), +(24780, 'Ya handle yerself quite well. Ya gonna be quite powerful some day.',25383), +(24642, 'Ya handle yerself quite well. Ya gonna be quite powerful some day.',25383), +(24786, 'Ya handle yerself quite well. Ya gonna be quite powerful some day.',25383), +(24754, 'Ya handle yerself quite well. Ya gonna be quite powerful some day.',25383), +(26276, 'Ya handle yerself quite well. Ya gonna be quite powerful some day.',25383), +(24774, 'Ya handle yerself quite well. Ya gonna be quite powerful some day.',25383), +(24762, 'Ya handle yerself quite well. Ya gonna be quite powerful some day.',25383); + +-- More Than Expected Quest +DELETE FROM `quest_offer_reward` WHERE `ID` IN (26277,24769,24781,24787,24643,24763,24755,24775); +INSERT INTO `quest_offer_reward` (`ID`,`RewardText`,`VerifiedBuild`) VALUES +(26277, 'Ya tha new recruit everyone''s talkin'' about, eh? Welcome ta tha Darkspear.',25383), +(24769, 'Ya tha new recruit everyone''s talkin'' about, eh? Welcome ta tha Darkspear.',25383), +(24781, 'Ya tha new recruit everyone''s talkin'' about, eh? Welcome ta tha Darkspear.',25383), +(24787, 'Ya tha new recruit everyone''s talkin'' about, eh? Welcome ta tha Darkspear.',25383), +(24643, 'Ya tha new recruit everyone''s talkin'' about, eh? Welcome ta tha Darkspear.',25383), +(24763, 'Ya tha new recruit everyone''s talkin'' about, eh? Welcome ta tha Darkspear.',25383), +(24755, 'Ya tha new recruit everyone''s talkin'' about, eh? Welcome ta tha Darkspear.',25383), +(24775, 'Ya tha new recruit everyone''s talkin'' about, eh? Welcome ta tha Darkspear.',25383); |