[News] Mists of Pandaria Premium Repack 6.1 is out!
What's new

Fix worgen quest not giving Spell two forms

P

pedroevil51

Gold Supporter
Senior User
154
2017
1
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
Click to expand...

Use this code to fix it, no need to restart, just .reload quest_template
after using the code.
 
Last edited:
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.
 
eyerobot said:
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.
Click to expand...

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 said:
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.
Click to expand...

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
 
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?
 
eyerobot said:
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?
Click to expand...

Yes, exactly. its not teaching at all.
On the quest files, RewardSpell=72857,
RewardSpellCast=72857 are RewardSpell=68996,
RewardSpellCast=68996
 
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.
Code: 
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 said:
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.
Code: 
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.
Click to expand...


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
 
LKarthas said:
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
Click to expand...

Hum , got it then. i will try it out
 
this Fix Work? i have this problem

eyerobot said:
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.


Code: 
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.
Click to expand...
 
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.
 
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)
 
Last edited:
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');
 
You must log in or register to reply here.
Back
Top