[SOLVED] Trinitycore: Mages have succubus spells?!

[Blazeqts]

Mages have some spells learned on creation that belong to the pet Succubus. I have no clue how to remove it, I've checked playercreateinfo_spell_custom from top to bottom and playercreateinfo_skills from top to bottom. I've even set this to 0

#    PlayerStart.AllSpells
#        Description: If enabled, players will start with all their class spells (not talents).
#                     You must populate playercreateinfo_spell_custom table with the spells you
#                     want, or this will not work! The table has data for all classes / races up
#                     to WoTLK expansion.
#        Default:     0 - (Disabled)
#                     1 - (Enabled)

PlayerStart.AllSpells = 0

to check if mages would still have the spells learned. And they did!

My question now is:

Where can I check what spells classes learn on char creation outside of the SQL tables I listed above?

 

[Blazeqts]

bump

 

[Kaev]

There's a DBC file, where you can find the spell IDs. Not sure about the name, but i think you will find it if you read the names of the DBCs.

 

[Sylica]

Mages have some spells learned on creation that belong to the pet Succubus. I have no clue how to remove it, I've checked playercreateinfo_spell_custom from top to bottom and playercreateinfo_skills from top to bottom. I've even set this to 0

#    PlayerStart.AllSpells
#        Description: If enabled, players will start with all their class spells (not talents).
#                     You must populate playercreateinfo_spell_custom table with the spells you
#                     want, or this will not work! The table has data for all classes / races up
#                     to WoTLK expansion.
#        Default:     0 - (Disabled)
#                     1 - (Enabled)

PlayerStart.AllSpells = 0

to check if mages would still have the spells learned. And they did!

My question now is:

Where can I check what spells classes learn on char creation outside of the SQL tables I listed above?

Blazeqts, did you use the command to learn the spells? If so, that's most likely how that's happening. On my server, I tested this and haven't seen it yet.

 

[Blazeqts]

Blazeqts, did you use the command to learn the spells? If so, that's most likely how that's happening. On my server, I tested this and haven't seen it yet.

No I did not, it is learned on character creation on any mage.

- - - Updated - - -

There's a DBC file, where you can find the spell IDs. Not sure about the name, but i think you will find it if you read the names of the DBCs.

I'm aware what the spell IDs are.

 

[Sylica]

No I did not, it is learned on character creation on any mage.

Have you tried a fully install of the core/database as a test? Just wondering and some debugging.

Here's some pics from me trying to recreate the issues. Must be something with your database/core.

 

[Blazeqts]

Here's my Playercreateinfo_spell_custom table, try run this and test it

I'm 100% certain that it has nothing to do with this table tho', as I disabled the table in Worldserver.conf and the issue still happened
http://pastebin.com/xv9ysU23

 

[Blazeqts]

I fixed it.
Here's what I did, step by step:

1: I backup'd playercreateinfo_skills

2: I deleted everything in it.

3: restarted server.

4: Succubus spell was removed from mages.

 

[Sylica]

Here's my Playercreateinfo_spell_custom table, try run this and test it

I'm 100% certain that it has nothing to do with this table tho', as I disabled the table in Worldserver.conf and the issue still happened
http://pastebin.com/xv9ysU23

Well, everything looks fine up to this point. You have 440 rows, and I have 460 rows for playercreateinfo_spell_custom. 20 rows of data difference.

I tested your table and didn't receive the spell on creation.