From ec50fc7c3b4d9e092321613d389149928ca2d7e6 Mon Sep 17 00:00:00 2001 From: Malcrom Date: Wed, 16 Jan 2013 20:06:24 -0330 Subject: DB/Creature_text: Add some missing text to db. --- sql/updates/world/2013_01_16_01_world_creature_text.sql | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100644 sql/updates/world/2013_01_16_01_world_creature_text.sql (limited to 'sql') 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..c814797986e --- /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'); -- cgit v1.2.3 From 937fcc38100c46edfad89e62bdcc85d0a0f79b4d Mon Sep 17 00:00:00 2001 From: Malcrom Date: Wed, 16 Jan 2013 20:54:22 -0330 Subject: DB/Creature_text: Missing ; from previous commit --- sql/updates/world/2013_01_16_01_world_creature_text.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'sql') 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 index c814797986e..69bdd91b886 100644 --- a/sql/updates/world/2013_01_16_01_world_creature_text.sql +++ b/sql/updates/world/2013_01_16_01_world_creature_text.sql @@ -1,5 +1,5 @@ -- Text for Crushridge Warmonger -SET @ENTRY := 2287 +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'), -- cgit v1.2.3 From a74bd06ac7aef65f0c9955922ea60fc597e98dea Mon Sep 17 00:00:00 2001 From: w1sht0l1v3 Date: Thu, 17 Jan 2013 18:30:04 +0200 Subject: DB/Misc: Proper faction for npc Brann Bronzebeard. This makes him assist in combat and now the mobs that spawn attack him. --- sql/updates/world/2013_01_17_00_world_creature_template.sql | 2 ++ 1 file changed, 2 insertions(+) create mode 100644 sql/updates/world/2013_01_17_00_world_creature_template.sql (limited to 'sql') 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); -- cgit v1.2.3