SQL Query Fixes Here

[akumavenom]

Hello everyone i'd like to share any bug fixes to the database i find for you all to enjoy for UWOW/Emucoaches Legion repack.

This quick fix is for the demon hunter intro scenario quest called "Between Us And Freedom", it turns out that the demon npc "Bastillax" that needs to be killed can not actually be killed and almost always kills the player in a few hits so run this SQL query in creature_template using HeidiSQL and it will scale him down so you can win and complete the intro scenario for demon hunters.

UPDATE creature_template
SET minlevel = 90,
    maxlevel = 90
WHERE entry = 96783;

-----------------------------------------

This quick fix is for the WOD quest called "Quakefist". The npc would not spawn that needed to be killed before you can create your garrison so run these queries to complete the quest objective so it will be able to be turned in to Yurel instantly upon accepting it.

1. Run in world2.quest_template:

UPDATE world2.quest_template
SET Flags = 524288
WHERE ID = 34585;

2. Run in world2.quest_objectives

UPDATE world2.quest_objectives
SET Amount = 0
WHERE QuestID = 34585;

-----------------------------------------

This quick fix is for the quest called "AHHHHHHHHHHH! AHHHHHHHHHHH!!!" found in Redridge Mountains, the player can not enter the tank vehicle needed to complete the quest, run this query and it will make the quest objective completed so you can turn it in instantly for all players.

UPDATE world2.quest_template
SET Flags = 524288
WHERE ID = 26708;

UPDATE world2.quest_objectives
SET Amount = 0
WHERE QuestID = 26708;

-----------------------------------------

This quick fix is the quest called "Darkblaze, Brood of the Worldbreaker" the horn of summoning does not spawn to complete the quest so this query will make the quest be able to be turned in strait after accepting the quest.

UPDATE world2.quest_template
SET Flags = 524288
WHERE ID = 26714;

UPDATE world2.quest_objectives
SET Amount = 0
WHERE QuestID = 26714;

-----------------------------------------

This fix will scale enemies down to the right level in the Western Plaguelands, the graveyard between chillwind camp and uther's tomb had level 98 creatures that should be around level 35-40, this query fix will scale them all down to between levels 35-40 so you don't get killed in 1 hit while doing the quests in the graveyard.

UPDATE creature_template
SET minlevel = 35,
    maxlevel = 40,
    ScaleLevelMin = 35,
    ScaleLevelMax = 40
WHERE entry = 108815;

UPDATE creature_template
SET minlevel = 35,
    maxlevel = 40,
    ScaleLevelMin = 35,
    ScaleLevelMax = 40
WHERE entry = 108847;

UPDATE creature_template
SET minlevel = 35,
    maxlevel = 40,
    ScaleLevelMin = 35,
    ScaleLevelMax = 40
WHERE entry = 108830;

UPDATE creature_template
SET minlevel = 35,
    maxlevel = 40,
    ScaleLevelMin = 35,
    ScaleLevelMax = 40
WHERE entry = 108824;

-----------------------------------------

This quick fix will make two quests be able to be turned in instantly because they require the caravan in Eastern Plaguelands to move to the towers but the player can not enter them.

UPDATE world2.quest_template
SET Flags = 524288
WHERE ID = 27373;

UPDATE world2.quest_objectives
SET Amount = 0
WHERE QuestID = 27373;

UPDATE world2.quest_template
SET Flags = 524288
WHERE ID = 27448;

UPDATE world2.quest_objectives
SET Amount = 0
WHERE QuestID = 27448;

-----------------------------------------