From c3613cd47746b32a309c8fff789e287818257f8c Mon Sep 17 00:00:00 2001 From: Nay Date: Tue, 9 Aug 2011 17:33:45 +0100 Subject: DB/Misc: Update two spawns z position; set two npcs in ICC to triggers (invisible) and use the correct Berserking spell in playercreateinfo_action --- sql/updates/world/2011_08_09_01_world_misc.sql | 5 +++++ 1 file changed, 5 insertions(+) create mode 100644 sql/updates/world/2011_08_09_01_world_misc.sql (limited to 'sql') diff --git a/sql/updates/world/2011_08_09_01_world_misc.sql b/sql/updates/world/2011_08_09_01_world_misc.sql new file mode 100644 index 00000000000..8099e91f6f7 --- /dev/null +++ b/sql/updates/world/2011_08_09_01_world_misc.sql @@ -0,0 +1,5 @@ +UPDATE `creature` SET `position_z`=-6.03356 WHERE `guid`=46069 AND `id`=11741; -- Dredge Crusher +UPDATE `creature` SET `position_z`=8.638660 WHERE `guid`=49069 AND `id`=11374; -- Hooktooth Frenzies +UPDATE `creature_template` SET `flags_extra`=`flags_extra`|128 WHERE `entry` = 37231; -- Robe Beam Stalker +UPDATE `creature_template` SET `flags_extra`=`flags_extra`|128 WHERE `entry` = 38008; -- Blood Orb Controller +UPDATE `playercreateinfo_action` SET `action`=26297 WHERE `action` IN (20554,50621,26635,26296) AND `race`=8; -- Berserking - Troll racial -- cgit v1.2.3