Alchemy Mastery Serious Bug

#1 » Post by **jaceliteforces** » 13 Dec 2012 08:44

Hello, i already did this topic on a tickect (and is still opened with this same details)... Kindly a GM answer in no time but he couldnt fix the problem, he said that he needed access to db content.

In resume, with my Priest called Piaros, i had learn Elixir Mastery, which works fine just the same time i learned it, but when i relog, dont work any longer, even i can see it in my spellbook. When i try to change to Trasmutation, works perfect until i relog, that when the most rare thing happens, at the time i login again both Masteries appear in my spellbook and none works ofc.

This masteries works only the session i unlearn and learn it again, which cost 150g everytime i log, which is quite expensive and is wrong.

I just want Trasnmutation on and working. Thanks in foward.

#2 » Post by **Doctor_J** » 13 Dec 2012 12:35

This is core issue with the way profession specializations are handled I came across same problem when I attempted to script Book "Soothsaying for Dummies" (well for engineers anyway), seems the way core handles profession specializations this seems to happen with tailoring and alchemy too where if you switch specialization the old specialization will come back at login, or it seems the specialization for which you did quest to learn will always return no matter what,

Its a shame because I scripted This (and this is entirely i smartai (that version only works for engineers even though did add support for learning lw specs) but this business with specializations returning after switching is mean reason why I shelved this for now.

#3 » Post by **jaceliteforces** » 13 Dec 2012 16:20

A solution, or at last, a "patch"... could work if i unlearn the the Proofesion at all, remake it and do the quest for Transmutation?... Wouldnt be a general fix, but could resolve the problem?... But, as GM, you can unlearn my proof, learn it again, leveling up to 450 and make the quest for Transmutation?...
Thanks in foward and sorry for bothering you with this topic.

#4 » Post by **Doctor_J** » 13 Dec 2012 16:28

quests are not repeatable even if you drop profession and retake quests will still be done and you will still have specialization,

Only way of fixing this atm is to remove quest which awarded the specialization skill and replace with one for other spec but this is dodgy.

#5 » Post by **jaceliteforces** » 13 Dec 2012 16:52

But, is still a solution, right?... i dont want Elixir Mastery ever, that solution you refer is to remove the quest it self from database char and do the other one?... Is not a solution, i'm agreed, but could fix my particular problem?... I dont know why i did not make the Trasmutation Quest in the first place

...

I'm on the char with the problem if you wanna to try anything (i dont if you actually need it logged

)

#6 » Post by **Doctor_J** » 13 Dec 2012 17:27

Well I have done some testing if you remove quest with gm commands ie .quest remove it will always show as rewarded again on relog,

But I was experimenting with quests but since the char I was testing on was engineer, once you have done that quest seems the professions reappearing in spellbook even after unlearning are linked to this,

I executed this, this was only for a test char and was remove gnomish engineering quest

delete FROM characters3.character_queststatus_rewarded where guid=246 and quest=3643;

Once that was executed and unlearnt gnomish engineer the specialization no longer returned at login, but removing is quests is dodgy since theres nothing stopping player from doing quest again and getting 2 specialisations,

theoretically solution would to be remove quest from old specialisation and add new one to db, then log on char and cast spells to learn/unlearn professions but as said this could be abused, as quest for old spec could be taken again.

#7 » Post by **jaceliteforces** » 13 Dec 2012 17:37

I just got your idea and the problem (i'm quite slow today).

Should i leave the ticket open in game then, right?... there is no suitable solution for now... I dont want to take out more of your time... Thanks for your patience... Best ragards

#8 » Post by **Doctor_J** » 13 Dec 2012 18:00

well think the solution would be to remove all elixir master quests from rewarded quests for your char and replace them with entries for transmute master but this would have to be done with sql as .quest remove just does not seem to work in game as quest ends up back again at relog, then cast Unlearn Transmutation Mastery, Unlearn Elixir Mastery and Transmutation Master

Seems old specializations including ones for which you no longer have the profession for is linked to rewarded quests for this specializations if you remove quest then remove the spell in game it no longer returns on relogin, but as said removing 1 quest would be dodgy as if you just remove last quest you maybe able to gain that profession by repeating last quest which was removed unless they are in exclusive group only safeway of doing this maybe to remove whole chain for elixir master from rewarded quests and insert entries to say you did trasmute quest chain, then unlearn both and learn transmute.

#9 » Post by **jaceliteforces** » 13 Dec 2012 18:10

Ok, got it... i should unlearn both masteries Elixir and Transmutation (Potion one wont be necessary, i think in my case), then you do something like this (pseudo code):

UPDATE FROM 'tbl_charname' SET 'Specializattion'='Transmutation' WHERE 'Specialization'='Elixir'

I dont know db table content how is set in the server, this would be the solution for a particular case.

Now, do you need me for any of this process, need me logged off, anything?...
Thanks

#10 » Post by **Doctor_J** » 13 Dec 2012 18:20

I cant actually perform what I said and then theres possibility of there still been issues but there is core bug here d: and its not just this profession its all professions with specializations.

#11 » Post by **jaceliteforces** » 13 Dec 2012 18:29

Ok, thanks... i will investigate on Trinity Core if something come up...

#12 » Post by **Doctor_J** » 13 Dec 2012 18:37

well appears the problem is that reward spells for rewarded quests get recast on login

Existing user Log In