aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authormalcrom <malcromdev@gmail.com>2012-01-04 11:25:45 +0100
committerZxBiohazardZx <zxbiohazardzx@gmail.com>2012-01-04 11:25:45 +0100
commit2b066b8ff58a21fdee063db0a1284043bdc58a7a (patch)
treed6cbc1226f568cfa2148c45ab7fd7086b0aa0fcc
parenteb6b5d8d13ea89a3cd00a36a99d0988db0eeeebe (diff)
DB/Creatures: set correct faction for frostmane troll whelp
closes #1105
-rw-r--r--sql/updates/world/2012_01_03_01_world_quest_template.sql2
-rw-r--r--sql/updates/world/2012_01_03_03_world_creature_template.sql2
2 files changed, 3 insertions, 1 deletions
diff --git a/sql/updates/world/2012_01_03_01_world_quest_template.sql b/sql/updates/world/2012_01_03_01_world_quest_template.sql
index 5ffc0930645..f35ea3be65b 100644
--- a/sql/updates/world/2012_01_03_01_world_quest_template.sql
+++ b/sql/updates/world/2012_01_03_01_world_quest_template.sql
@@ -1 +1 @@
-UPDATE quest_template SET OfferRewardText='<Getry looks you over.>$B$BThis is all Ickoris could send?' WHERE entry=11703;
+UPDATE `quest_template` SET `OfferRewardText`='<Getry looks you over.>$B$BThis is all Ickoris could send?' WHERE `id`=11703;
diff --git a/sql/updates/world/2012_01_03_03_world_creature_template.sql b/sql/updates/world/2012_01_03_03_world_creature_template.sql
new file mode 100644
index 00000000000..29d0e802abe
--- /dev/null
+++ b/sql/updates/world/2012_01_03_03_world_creature_template.sql
@@ -0,0 +1,2 @@
+-- Update faction for Frostmane Troll Whelp "From Sniff"
+UPDATE `creature_template` SET `faction_A`=7,`faction_H`=7 WHERE `entry`=706;