Kaja'Cola Quest bug fix

[Adriel]

Run this SQL query to fix the Kaja'Cola goblin start area quest questgiver to supply you with the 6-pack of kaja'cola to turn in.
This is for the EMU Coach 4.3.4 Cataclysm repack MySQL world database

UPDATE `quest_template` SET `SourceItemId`='54453', `SourceItemCount`='1' WHERE (`Id`='25473')

 

[ExO]

Thank you for the contribution to our repack, any help is highly appreciated!

 

[Adriel]

Yeah it was a thing I found by just messing around with toons in game.
There are alot of buggy things in the goblin area that range from incorrect npc or go ids to no phase masking set (mods spawns where they should not be at time the should not be, etc).
There is another quest for the blood elf start area "Thirst Unending" which cannot be completed. Now I have corrected the required npc id and required spell id but it is still bugged so the best thing I can do is nullify the quest to zero so you can get it and just turn it back in to get the xp and rewards.
The problem was resolved back in 3.3.3 server releases via a core code typo but it seems the devs mucked it up again.

The whole thing is a WIP and has been since the old Ascent days. I will post any fixs I come up with as I test and complete them.

 

[w3bariak]

I am going to use it, thanks very much.

 

[kncould]

go to test it

 

[tanin2684]

Thank You

Fix