google-code-export / oregoncore

Automatically exported from code.google.com/p/oregoncore
GNU General Public License v2.0
1 stars 0 forks source link

[Mage][Pet] Water elemental - No spells #428

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago

Issue:
Water elemental does not have any spells (water bolt/freeze etc)

Screenshot:
http://oi54.tinypic.com/2cesy1f.jpg

Original issue reported on code.google.com by Dimman...@gmail.com on 3 Apr 2011 at 9:42

GoogleCodeExporter commented 9 years ago
You need to give spells to mob. Mob id 510. Don't remember spell ID's. It's not 
core, but database

Original comment by dscrashr...@gmail.com on 4 Apr 2011 at 10:01

GoogleCodeExporter commented 9 years ago
[deleted comment]
GoogleCodeExporter commented 9 years ago
His id is 510, not 512.

Original comment by dscrashr...@gmail.com on 6 Apr 2011 at 4:39

GoogleCodeExporter commented 9 years ago
with one table to add spells for water elemental?

Original comment by xevi...@gmail.com on 7 Apr 2011 at 10:37

GoogleCodeExporter commented 9 years ago
You can add spells to creature_template
Spell ID's 31707 and 33395

It will work... but it's still a hack.
Core must load and add this spells from petcreateinfo_spell table.

Original comment by alexso...@gmail.com on 8 Apr 2011 at 2:58

GoogleCodeExporter commented 9 years ago
but no-one pets have spells voidwalker also dont have any him spells but when i 
use .learn 31707 or .learn 33395 that command teach me spells so they are in DB 
i thing something is wrong in core files

Original comment by xevi...@gmail.com on 8 Apr 2011 at 4:57

GoogleCodeExporter commented 9 years ago
-- Spells for Mage's Water Elemental
UPDATE `creature_template` SET spell1=31707, spell2=33395 WHERE `entry`=510;
-- Spells for Shaman's Earth Elemental
UPDATE `creature_template` SET spell1=36213 WHERE `entry`=15352;
-- Spells for Shaman's Fire Elemental
UPDATE `creature_template` SET spell1=12470, spell2=13376 WHERE `entry`=15438;

Original comment by gid...@inbox.ru on 9 Apr 2011 at 10:11

GoogleCodeExporter commented 9 years ago
Fixed in database update, but still not necessarily proper fix.

Original comment by henry...@gmail.com on 7 Aug 2011 at 5:24