aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorVincent_Michael <Vincent_Michael@gmx.de>2013-01-17 23:32:50 +0100
committerVincent_Michael <Vincent_Michael@gmx.de>2013-01-17 23:32:50 +0100
commit11bda92b145617f6d3ab2dc454db29ce382c76bd (patch)
treee23717babff745b947f6d0838ff1f1ef76ea4485 /sql
parent224b4480a70c4896d67e2f2907620b550e585057 (diff)
parenta74bd06ac7aef65f0c9955922ea60fc597e98dea (diff)
Merge branch 'master' of github.com:TrinityCore/TrinityCore into mmaps
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/2013_01_16_01_world_creature_text.sql7
-rw-r--r--sql/updates/world/2013_01_17_00_world_creature_template.sql2
2 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/2013_01_16_01_world_creature_text.sql b/sql/updates/world/2013_01_16_01_world_creature_text.sql
new file mode 100644
index 00000000000..69bdd91b886
--- /dev/null
+++ b/sql/updates/world/2013_01_16_01_world_creature_text.sql
@@ -0,0 +1,7 @@
+-- Text for Crushridge Warmonger
+SET @ENTRY := 2287;
+DELETE FROM `creature_text` WHERE `entry`=@ENTRY;
+INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
+(@ENTRY,0,0,'Raaar!!! Me smash $R',12,0,100,0,0,0,'Crushridge Warmonger'),
+(@ENTRY,0,1,'Me smash! You die!',12,0,100,0,0,0,'Crushridge Warmonger'),
+(@ENTRY,0,2,'I''ll crush you!',12,0,100,0,0,0,'Crushridge Warmonger');
diff --git a/sql/updates/world/2013_01_17_00_world_creature_template.sql b/sql/updates/world/2013_01_17_00_world_creature_template.sql
new file mode 100644
index 00000000000..af602096440
--- /dev/null
+++ b/sql/updates/world/2013_01_17_00_world_creature_template.sql
@@ -0,0 +1,2 @@
+-- proper faction for Bran in Halls of Stone
+UPDATE `creature_template` SET `faction_A`=1665,`faction_H`=1665 WHERE `entry` IN (28070,31366);