aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authortkrokli <tkrokli@users.noreply.github.com>2017-07-18 04:19:13 +0200
committertkrokli <tkrokli@users.noreply.github.com>2017-07-18 04:22:05 +0200
commit134700b28fb176a8cad5dc7a04edd771e72da09a (patch)
tree3cc78202d68a4028b0aa72d409c1dee90686c577
parente0194e4a2c659597da18e220000055484ff504ad (diff)
DB/Quests: Battle of Hillsbrad (7) missing Progress & Reward text
- the original quest ID 550 is already deprecated & from before patch 3.3.0 - http://www.wowhead.com/quest=550/deprecated-battle-of-hillsbrad - sniffs of current quest ID 14351 only contain quest_template text - added text from http://www.wowhead.com/quest=14351/deprecated-battle-of-hillsbrad * The texts differ enough to fit their personalities. - http://www.wowhead.com/npc=36273/bragor-bloodfist - http://www.wowhead.com/npc=2425/varimathras
-rw-r--r--sql/updates/world/3.3.5/2017_07_18_00_world_335.sql9
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_07_18_00_world_335.sql b/sql/updates/world/3.3.5/2017_07_18_00_world_335.sql
new file mode 100644
index 00000000000..75b7ef80a07
--- /dev/null
+++ b/sql/updates/world/3.3.5/2017_07_18_00_world_335.sql
@@ -0,0 +1,9 @@
+-- Battle of Hillsbrad (7) Progress gossip text (missing)
+DELETE FROM `quest_request_items` WHERE `ID`=14351;
+INSERT INTO `quest_request_items` (`ID`,`EmoteOnComplete`,`EmoteOnIncomplete`,`CompletionText`,`VerifiedBuild`) VALUES
+(14351, 1, 0, "Why aren't you out on the battlefield, $c?", 12340);
+
+-- Battle of Hillsbrad (7) Reward gossip text (missing)
+DELETE FROM `quest_offer_reward` WHERE `ID`=14351;
+INSERT INTO `quest_offer_reward` (`ID`,`Emote1`,`Emote2`,`Emote3`,`Emote4`,`EmoteDelay1`,`EmoteDelay2`,`EmoteDelay3`,`EmoteDelay4`,`RewardText`,`VerifiedBuild`) VALUES
+(14351, 0, 0, 0, 0, 0, 0, 0, 0, "So you're the $c who tore through the Alliance forces in the Hillsbrad Foothills? I've heard your name already. Word travels fast.$B$BThe Horde can use someone like you if you keep this up, $N.$B$BWe need to keep our eyes on all threats around us, but with that king leading them, the humans will continue to be a problem. You've confirmed that there's strength enough in the Horde to end that threat in time.", 12340);