Fix worgen quest not giving Spell two forms

[pedroevil51]

So, spell id on reward was wrong

-EDIT = LKArthas told me that it was supposed to not teach you the spell right away, only after a event.

IGNORE

Use this code to fix it, no need to restart, just .reload quest_template
after using the code.

 

[eyerobot]

I remember seeing people debating about this. I never could figure out what was so hard to understand about it. Either you get it or you don't. And then there were bug reports from people that said they never got it. So I guess they blew it after all. As for me, I don't play alliance very often, So I stayed out of it.

 

[pedroevil51]

I remember seeing people debating about this. I never could figure out what was so hard to understand about it. Either you get it or you don't. And then there were bug reports from people that said they never got it. So I guess they blew it after all. As for me, I don't play alliance very often, So I stayed out of it.

Yeah, there are two spells, the other id its the spell alredy on the character, this ID is for the learning of the spell. ex, if you use .cast 72857 on a player, it will teach them the TWO FORMS spell.

 

[pedroevil51]

Yeah, there are two spells, the other id its the spell alredy on the character, this ID is for the learning of the spell. ex, if you use .cast 72857 on a player, it will teach them the TWO FORMS spell.

Also, if you not learn the spell via the intented way = 72857 , you will not learn the racial trait of Free Running with the worgen

 

[eyerobot]

I don't think that the rewspellcast needs to be changed, Once should be enough, And the second one seems to be some kind of cut scene if i'm reading it right.
Forcecast Worgen Intro Completion. But who knows.
So what's wrong with 68996? Is it not teaching two forms like it's supposed to?

 

[pedroevil51]

I don't think that the rewspellcast needs to be changed, Once should be enough, And the second one seems to be some kind of cut scene if i'm reading it right.
Forcecast Worgen Intro Completion. But who knows.
So what's wrong with 68996? Is it not teaching two forms like it's supposed to?

Yes, exactly. its not teaching at all.
On the quest files, RewardSpell=72857,
RewardSpellCast=72857 are RewardSpell=68996,
RewardSpellCast=68996

 

[eyerobot]

Well after doing some reading, It appears that rew spell is ignored if rew spell cast is entered in the template. And obviously their spell doesn't work. So I say we go with your fix as it is, And call it good. Good Job.

Here it is after entering that data into truice.

UPDATE `quest_template` SET `RewardSpell` = 72857, `RewardSpellCast` = 72857 WHERE `Id` = 14375;

This way the semicolons don't get left out. There are a lot of people that wouldn't know how to fix that.
Truice is available in the how to guides under sql tutorials.

 

[LKarthas]

Well after doing some reading, It appears that rew spell is ignored if rew spell cast is entered in the template. And obviously their spell doesn't work. So I say we go with your fix as it is, And call it good. Good Job.

Here it is after entering that data into truice.

UPDATE `quest_template` SET `RewardSpell` = 72857, `RewardSpellCast` = 72857 WHERE `Id` = 14375;

This way the semicolons don't get left out. There are a lot of people that wouldn't know how to fix that.
Truice is available in the how to guides under sql tutorials.

Please don't run that after Last Chance of humanity worgens doesn't learn the two forms, that's why, they get it after completing neither human nor Beast Quest and it's working propperly (event Inluded)
just give it a try
Best Regards

 

[pedroevil51]

Please don't run that after Last Chance of humanity worgens doesn't learn the two forms, that's why, they get it after completing neither human nor Beast Quest and it's working propperly (event Inluded)
just give it a try
Best Regards

Hum , got it then. i will try it out

 

[kambire]

this Fix Work? i have this problem

Well after doing some reading, It appears that rew spell is ignored if rew spell cast is entered in the template. And obviously their spell doesn't work. So I say we go with your fix as it is, And call it good. Good Job.

Here it is after entering that data into truice.

UPDATE `quest_template` SET `RewardSpell` = 72857, `RewardSpellCast` = 72857 WHERE `Id` = 14375;

This way the semicolons don't get left out. There are a lot of people that wouldn't know how to fix that.
Truice is available in the how to guides under sql tutorials.

 

[eyerobot]

If you have completed neither human nor Beast Quest , And it still doesn't work, then i would suggest contacting Lkarthas to figure out what's going on. I don't know much about alliance quests myself.

 

[Inc]

No need to change RewardSpell.You have to update RewardSpellCast.

UPDATE `quest_template` SET `RewardSpellCast`='72857' WHERE (`Id`='24593')

Already tested and it works perfectly. (8.1)

 

[eyerobot]

Bumping this!
My suggestion is that if there is a server side script for this quest that causes the cinematic to happen. And it also casts spell 72857. Then that spell should be removed from that script. And the database entry from Vannworld should be used instead. UPDATE `quest_template` SET `RewardSpellCast`='72857' WHERE (`Id`='24593');

 

[eyerobot]

I bumped the thread with your fix in it Vannworld. I'll also submit your fix in the current version just to make sure it gets put in this time.

 

[ExO]

Executed in the database, thanks.