From 2b066b8ff58a21fdee063db0a1284043bdc58a7a Mon Sep 17 00:00:00 2001
From: malcrom <malcromdev@gmail.com>
Date: Wed, 4 Jan 2012 11:25:45 +0100
Subject: DB/Creatures: set correct faction for frostmane troll whelp

closes #1105
---
 sql/updates/world/2012_01_03_01_world_quest_template.sql    | 2 +-
 sql/updates/world/2012_01_03_03_world_creature_template.sql | 2 ++
 2 files changed, 3 insertions(+), 1 deletion(-)
 create mode 100644 sql/updates/world/2012_01_03_03_world_creature_template.sql

(limited to 'sql')

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;
-- 
cgit v1.2.3