Modcraft - The community dedicated to quality WoW modding!

Wrath of the Lich King Modding => Miscellaneous => Topic started by: Sprucey on March 07, 2015, 02:38:53 am

Title: [QUESTION] SQL - world playercreateinfo_spell missing?
Post by: Sprucey on March 07, 2015, 02:38:53 am

Hey, a bit of a weird or possibly stupid question.

I've just been trying to add spells to a custom race, but the playercreateinfo_spell table is missing from the latest Trinity database (335.57).

I wondered how I'd go about adding spells without it, or if I'd need to revert to an earlier revision of the core and DB to do it. I noticed playercreateinfo_spell_custom was there, but it doesn't seem as complete, and I can't query anything into it.

Title: Re: [QUESTION] SQL - world playercreateinfo_spell missing?
Post by: caduceus on March 07, 2015, 05:47:26 am

Quote from: "Sprucey"

Hey, a bit of a weird or possibly stupid question.

I've just been trying to add spells to a custom race, but the playercreateinfo_spell table is missing from the latest Trinity database (335.57).

I wondered how I'd go about adding spells without it, or if I'd need to revert to an earlier revision of the core and DB to do it. I noticed playercreateinfo_spell_custom was there, but it doesn't seem as complete, and I can't query anything into it.

playercreateinfo_spell is no longer used. In order to add custom spells you will have to use playercreateinfo_spell_custom (make sure to allow starting spells in your world.config)  You can also add the skills to playercreateinfo_skill. (Use SkillLine.dbc as a refrence to skills)

Title: Re: [QUESTION] SQL - world playercreateinfo_spell missing?
Post by: Sprucey on March 07, 2015, 07:47:34 am

Thanks! It's a bit strange but I'm sure I'll adapt. It pointed me in the right direction and I somehow totally missed that the masks are multiple races.

I had just a couple more questions meanwhile: Is it still possible to assign custom races others racial spells and languages through SQL and SkillLineAbility.dbc? A fair bit's changed since I last did this and I'm wondering what's possible or not.

Before I could just copy spells off a race from playercreateinfo_spell and be done with it.

Title: Re: [QUESTION] SQL - world playercreateinfo_spell missing?
Post by: Sprucey on March 09, 2015, 01:37:18 am

Are certain spells handled elsewhere?

I'm trying to get to grips with just removing/adding spells to default created characters but not having any luck at all.

My test at the moment is removing Sword Specialization from Humans, I'm altering the classmask value from 411 to 410, which should remove the it for human warriors, right? Having a similar issue with skills, where changing a value to remove or add a skill is simply doing after starting the worldserver and getting in-game.