diff options
| author | Nay <dnpd.dd@gmail.com> | 2011-03-07 17:51:06 +0000 |
|---|---|---|
| committer | Nay <dnpd.dd@gmail.com> | 2011-03-07 17:51:06 +0000 |
| commit | 11ea7a2ea918a621aa3947fec501443c372469f3 (patch) | |
| tree | 1a9e9a9c5dbd3fc997d712d65b5d7caea690d640 | |
| parent | d6ddc6410c9c9cde6f6960bf57207b007195cf6c (diff) | |
DB/Misc: Remove auras from mounts inside ToC5 and reset their faction to 35 (core scripts should be able to change auras and factions)
Revert Emblematic achievement reward (it will be implemented later with a better achievement system)
Delete a typo in npc_spellclick_spells.
Closes #853
| -rw-r--r-- | sql/updates/world/2011_03_07_0_world_misc.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/2011_03_07_0_world_misc.sql b/sql/updates/world/2011_03_07_0_world_misc.sql new file mode 100644 index 00000000000..6e7b679a277 --- /dev/null +++ b/sql/updates/world/2011_03_07_0_world_misc.sql @@ -0,0 +1,4 @@ +UPDATE `creature_template_addon` SET `auras`=NULL WHERE `entry` IN (36558,35644); -- Argent mounts inside ToC5 shouldn't have any aura (for now) +DELETE FROM `npc_spellclick_spells` WHERE `npc_entry`=36477; -- Krick isn't a vehicle +DELETE FROM `achievement_reward` WHERE `entry` IN (4784,4785); -- Revert Emblematic achiev rewards +UPDATE `creature_template` SET `faction_A`=35,`faction_H`=35 WHERE `entry`=35644; -- Argent Warhorse (faction depends on the players faction that starts ToC5 fight) |