diff options
| author | Nay <dnpd.dd@gmail.com> | 2011-08-09 17:33:45 +0100 |
|---|---|---|
| committer | Nay <dnpd.dd@gmail.com> | 2011-08-09 17:33:45 +0100 |
| commit | c3613cd47746b32a309c8fff789e287818257f8c (patch) | |
| tree | 2ec70bf936d8976027194293efe32bc5b51bfcd1 | |
| parent | 4ce345a9f9ca389f97c914da191552f35420c883 (diff) | |
DB/Misc: Update two spawns z position; set two npcs in ICC to triggers (invisible) and use the correct Berserking spell in playercreateinfo_action
| -rw-r--r-- | sql/updates/world/2011_08_09_01_world_misc.sql | 5 |
1 files changed, 5 insertions, 0 deletions
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 |