Players Learn all Spells NEED HELP!

[V1cTorY]

Hey, I can't seem to figure out how to make it so when you create a character you start with all spells at level 80, or where trainers can teach stances and forms. If I change PlayerStart.AllSpells in worldserver.exe and then players start out with level 70 spells and then learn the rest of their spells work, except then druids have travel form on 24/7 and it's a bit bugged. Does anyone have any suggestion to as how i can get players to start with all their spells (instant 80) or where a trainer can teach every spell? Any help would be greatly appreciated. Thanks!

[ReppzYouTube]

Hey, I can't seem to figure out how to make it so when you create a character you start with all spells at level 80, or where trainers can teach stances and forms. If I change PlayerStart.AllSpells in worldserver.exe and then players start out with level 70 spells and then learn the rest of their spells work, except then druids have travel form on 24/7 and it's a bit bugged. Does anyone have any suggestion to as how i can get players to start with all their spells (instant 80) or where a trainer can teach every spell? Any help would be greatly appreciated. Thanks!

Update to the latest core to remove previous bugs.
In worldserver.conf
PlayerStart.AllReputation = 0
PlayerStart.AllSpells = 0
PlayerStart.MapsExplored = 1
Not recommended tho as if your DB isnt up-to-date DK's will have a languge problem (did for me anyway).

[V1cTorY]

... you really didnt tell me anything..

[Facebook]

He's saying that configuration option is busted, not that he doesn't know what configuration option to use.

I know the in-game command is also bugged. I'm sure they use the same system.

The issue with the in-game command is it teaches you procs, and talents.

I don't know as much with this configuration option though. I'm sure it just hasn't been updated since WotLK was released.

[V1cTorY]

He's saying that configuration option is busted, not that he doesn't know what configuration option to use.

I know the in-game command is also bugged. I'm sure they use the same system.

The issue with the in-game command is it teaches you procs, and talents.

I don't know as much with this configuration option though. I'm sure it just hasn't been updated since WotLK was released.

Then how would you go along making to so players start with all spells?

[Facebook]

I suppose fixing the configuration option. One moment let me look at it and see if I can figure out where exactly the issue lies.

You say you learn level 70 spells, and druids get stuck with travel form 24/7? Can you check the aura id of the flightform of a druid experiencing this issue for me?

---------- Post added at 11:35 PM ---------- Previous post was at 11:24 PM ----------

Here is your first fix. I believe this will fix the issue with druids being stuck in travel form.

UPDATE playercreateinfo_spell_custom SET Active = 0 WHERE Spell = 783;

And to fix the issue with them only learning up to level 70.
You can use this query as a framework for adding every individual spell from 71-80. ;P

INSERT INTO playercreateinfo_spell_custom (`race`, `class`, `spell`, `note`, `active`) VALUES
(RACEID, CLASSID, SPELLID, "Spell name as inside quotations", 1 OR 0);

Note: for the active column (final one), 1 means the spell is active, 0 means it isn't.

[V1cTorY]

I suppose fixing the configuration option. One moment let me look at it and see if I can figure out where exactly the issue lies.

You say you learn level 70 spells, and druids get stuck with travel form 24/7? Can you check the aura id of the flightform of a druid experiencing this issue for me?

---------- Post added at 11:35 PM ---------- Previous post was at 11:24 PM ----------

Here is your first fix. I believe this will fix the issue with druids being stuck in travel form.

UPDATE playercreateinfo_spell_custom SET Active = 0 WHERE Spell = 783;

And to fix the issue with them only learning up to level 70.
You can use this query as a framework for adding every individual spell from 71-80. ;P

INSERT INTO playercreateinfo_spell_custom (`race`, `class`, `spell`, `note`, `active`) VALUES
(RACEID, CLASSID, SPELLID, "Spell name as inside quotations", 1 OR 0);

Note: for the active column (final one), 1 means the spell is active, 0 means it isn't.

Thanks for the replies, here i'll explain it a little more in-depth. In my config i set it PlayerStart.AllSpells = 1 so that players at least start with 70 spells, which would make warriors have stances, warlocks have pets, hunters with tame beast, all the quest spells etc.. and then they can learn the rest from the trainers. But when i do that druids have the spells "Swift Flight Form (Passive)" "Flight Form (Passive)" "Travel Form (Passive)" And then Humans are missing Every Man for Himself and I haven't check the other classes but i bet their missing some racials too. So I think if i could find an sql to put in playercreate_spell_custom so players start with all their spells, or just where you start out with level 1 spells + Stances / Pets / etc OR a trainer that can teach them it. I ran the first code you gave me, replacing the Spell to the ones druids aren't supposed to have but it didn't seem to do anything. So if you can work off of that and try and help me out you'd be the man. ha thanks.

[Facebook]

Well if you want to add the 71-80 spells, I'll see what I can do to make one.

As for the druid issue, give me a minute. I'll see if I updated the wrong spell or something.

[V1cTorY]

Well if you want to add the 71-80 spells, I'll see what I can do to make one.

As for the druid issue, give me a minute. I'll see if I updated the wrong spell or something.

Hey dude i figured it out, I just went page through page in spell_custom and deleted them at first I didn't realize there were 6 pages., and then im adding in racials. As far as 71-80 spells doesn't really matter because players still need trainers for Talents. Thanks though dude!

[Facebook]

Alright well I'm probably going to create a program that will create a query for the 71-80 spells so I can add that in, and hopefully get it pushed to TrinityCore itself.

(I don't have push access there anymore. :P)

Anyways, glad I could help. I suggest if you didn't remove spell 783, to correct it back to Active 1 since putting it to 0 didn't fix the issue.

[frigin]

Has anyone fixed the dk's cant talk and start naked problems if the config is enabled. before you say update i'm using:

Using ACE: 5.8.3
TrinityCore Rev: 10538 Release Hash: 803cb847c17b (Win32,little-endian) (core-daemon)
World DB: TDB 335.11.34
EventAI: TDBAI 335.0.1

If there is a fix in the sql updates i dont know what it is.. or where it is.. point me in that direction but to the BEST of my knowledge and ability ive updated all appropriate updates.

[cemak]

give SET FOREIGN_KEY_CHECKS=0; -- ----------------

[Verosk]

i had the same problem with dks and they were naked.

They didnt start off with any language so i just added the horde language and alliance language into the db with..
Class = 6
Race = 0

make to new rows one for the alliance language and one for horde.

then the problem with them beign naked, they dont actually have plate-mail spell learnt, so you just add that into the db with..
class = 6
race = 0