[Mage][Pet] Water elemental - No spells

[GoogleCodeExporter]

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]

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]

[deleted comment]

[GoogleCodeExporter]

His id is 510, not 512.

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

[GoogleCodeExporter]

with one table to add spells for water elemental?

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

[GoogleCodeExporter]

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]

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]

-- 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]

Fixed in database update, but still not necessarily proper fix.

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

• Changed state: Fixed