diff options
| author | Nay <dnpd.dd@gmail.com> | 2012-09-11 13:19:34 -0700 |
|---|---|---|
| committer | Nay <dnpd.dd@gmail.com> | 2012-09-11 13:19:34 -0700 |
| commit | 78d0fac217bb7cd0dece38842a5aca07582e141e (patch) | |
| tree | 484d3614ba9622da52efb9dace711c5da5255175 /sql | |
| parent | 8d049545de87595a84e6e2c54d7b44b354644144 (diff) | |
| parent | 02096f1c2328bc7de4c718b9dec6437a3d5ab563 (diff) | |
Merge pull request #7731 from w1sht0l1v3/ToCr2
Core/Scripts: Anub'Arak encounter changes and fixes.
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2012_09_10_14_world_misc.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/world/2012_09_10_14_world_misc.sql b/sql/updates/world/2012_09_10_14_world_misc.sql new file mode 100644 index 00000000000..0f47f1bf2e9 --- /dev/null +++ b/sql/updates/world/2012_09_10_14_world_misc.sql @@ -0,0 +1,11 @@ +-- ToCr orbs + +SET @NPC_ORB1 := 34606; -- Frost Sphere +SET @NPC_ORB2 := 34649; -- Frost Sphere + +UPDATE `creature_template` SET `speed_walk`=1.2,`speed_run`=1.42,`InhabitType`=7 WHERE `entry` IN (@NPC_ORB1,@NPC_ORB2); + +DELETE FROM `creature_template_addon` WHERE `entry` IN (@NPC_ORB1,@NPC_ORB2); +INSERT INTO `creature_template_addon` (`entry`,`mount`,`bytes1`,`bytes2`,`auras`) VALUES +(@NPC_ORB1,0,0x3000000,0x1,''), +(@NPC_ORB2,0,0x3000000,0x1,''); |