diff options
| author | w1sht0l1v3 <w1sht0l1v3@gmail.com> | 2012-04-22 13:58:22 +0300 |
|---|---|---|
| committer | w1sht0l1v3 <w1sht0l1v3@gmail.com> | 2012-04-22 13:58:22 +0300 |
| commit | 8cf7d9185725b14b31f35c73f167a665edce543f (patch) | |
| tree | 26ebcc87d7e6a816b7f17ea29a200d824c0f9255 /sql | |
| parent | 409ebcca974009beb9807963aebfec4e861ccf33 (diff) | |
Core/DB: Quest The Emissary.
Fix condition in item spell(usable only when npc is above 95% hp).
Added correct faction,unit_flags and emote to Leviroth.
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2012_04_05_00_world_creature_misc.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/2012_04_05_00_world_creature_misc.sql b/sql/updates/world/2012_04_05_00_world_creature_misc.sql new file mode 100644 index 00000000000..ae35b3fba5d --- /dev/null +++ b/sql/updates/world/2012_04_05_00_world_creature_misc.sql @@ -0,0 +1,5 @@ +UPDATE `creature_template` SET `faction_A`=1914,`faction_H`=1914,`unit_flags`=33024 WHERE `entry`=26452; + +DELETE FROM `creature_template_addon` WHERE `entry`=26452; +INSERT INTO `creature_template_addon` (`entry`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(26452,0,0,0,1,383,''); |