Fix BloodIsle achievement for alliance race different to Draenei

[Titesusy]

I just saw we can't reach the global number of succeed quest in Bloodmyst Isles if we aren't Draenei (tested with a Worgen War and an Human Demonist). Looking at the databases (official and EC), i found the Bloodmyst Isle is identifed like the area "3525".

SELECT * FROM quest_template WHERE Id = '9753';

We can see the Area code is 3525 for the quest 9753.

Now, let's search in database the different races from the Alliance can take the quests. To know, the all Alliance race code is : "2098253".

SELECT
quest_template.Id,
quest_template.ZoneOrSort,
quest_template.RequiredRaces
FROM
quest_template
WHERE
quest_template.ZoneOrSort =  '3525' AND
quest_template.RequiredRaces <>  '0' AND
quest_template.RequiredRaces <>  '2098253';

The Result refers to 4 quests : 9753, 9756, 9760 and 9761. After verification to wowhead site, these quest are available for all the Alliance, so let's go to change it:
(the fix is below)



Now, the Fix :

UPDATE `quest_template` SET `RequiredRaces`='2098253' 
WHERE (`Id`='9753' OR `Id`='9756' OR `Id`='9760' OR `Id`='9761' );
UPDATE `quest_template` SET `PrevQuestId`='0' WHERE (`Id`='9671');

The second part is about the quest "9671" had wrongly a previous quest "9602", but according to wowhead, the quest has no previous quest...
Just tested now with the worgen : succeed! But not tested yet with the human (but it should be ok)

 

[ExO]

Thanks for the report. Executed the RequiredRaces SQL. Good job