-- https://www.wowhead.com/ru/quest=48954 Кровь Титана
DELETE FROM `conversation_actors` WHERE (`ConversationId`=6079 AND `Idx`=0);
INSERT INTO `conversation_actors` (`ConversationId`, `ConversationActorId`, `Idx`, `VerifiedBuild`) VALUES
(6079, 47036, 0, 64502); -- Creature-SubType:0-RealmId:3895-MapId:1220-ServerId:14607-Entry:90417-390F0000217320 Map: 1220 Entry: 90417
UPDATE `conversation_actors` SET `ConversationActorGuid` = 90417 WHERE `ConversationId` = 6079 AND `Idx` = 0;


DELETE FROM `conversation_line_template` WHERE `Id` IN (13483, 13482, 13481, 13479, 13480, 13478);
INSERT INTO `conversation_line_template` (`Id`, `StartTime`, `UiCameraID`, `ActorIdx`, `Flags`, `VerifiedBuild`) VALUES
(13483, 51462, 0, 0, 0, 64502),
(13482, 40304, 0, 0, 0, 64502),
(13481, 29655, 0, 0, 0, 64502),
(13479, 20445, 0, 0, 0, 64502),
(13480, 11491, 0, 0, 0, 64502),
(13478, 0, 0, 0, 0, 64502);


DELETE FROM `conversation_template` WHERE `Id`=6079;
INSERT INTO `conversation_template` (`Id`, `FirstLineID`, `LastLineEndTime`, `VerifiedBuild`) VALUES
(6079, 13478, 56766, 64502);

DELETE FROM `smart_scripts` WHERE `entryorguid` = 90417 AND `source_type` = 0 AND `id` = 53;
INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `event_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `action_param_float`, `action_delay`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
(90417, 0, 53, 0, 20, 0, 100, 0, 48954, 0, 0, 0, 0, 206, 6079, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'QR - Say');


-- https://tracker.legionbugs.com/view.php?id=34379 Allied Races, auto quests
DELETE FROM `player_actions` WHERE `event_type` = 10 AND `event_param1` = 0 AND `action_type` = 5 AND `action_param1` IN (49928,49784,49782,49783);
INSERT INTO `player_actions` (`event_type`, `event_param1`, `event_param2`, `event_param3`, `action_chance`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param_x`, `action_param_y`, `action_param_z`, `action_param_o`, `delay`, `options_type`, `options_param`, `options_param2`, `options_param3`, `action_text`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `comment`) VALUES
(10, 0, 0, 0, 100, 5, 49928, 0, 0, 0, 0, 0, 0, 0, 0, 11, 49928, 0, 0, NULL, 0, 0, 0, 0, 'Void Elf - Legacy of the Void'),
(10, 0, 0, 0, 100, 5, 49784, 0, 0, 0, 0, 0, 0, 0, 0, 11, 49784, 0, 0, NULL, 0, 0, 0, 0, 'Nightborne - Legacy of the Nightborne'),
(10, 0, 0, 0, 100, 5, 49782, 0, 0, 0, 0, 0, 0, 0, 0, 11, 49782, 0, 0, NULL, 0, 0, 0, 0, 'Lightforged Draenei - Legacy of the Lightforged'),
(10, 0, 0, 0, 100, 5, 49783, 0, 0, 0, 0, 0, 0, 0, 0, 11, 49783, 0, 0, NULL, 0, 0, 0, 0, 'Highmountain Tauren - Legacy of the Highmountain');

DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 35 AND `SourceEntry` IN (49928,49784,49782,49783);
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`, `MaxExpansion`, `MinExpansion`) VALUES
-- Void Elf (49928)
(35, 0, 49928, 0, 0, 17, 0, 12291, 0, 0, 1, 0, '', 'Void Elf - no achievement Legacy of the Void', 0, 6),
(35, 0, 49928, 0, 0, 27, 0, 110, 0, 0, 0, 0, '', 'Void Elf - level 110', 0, 6),
(35, 0, 49928, 0, 0, 14, 0, 49928, 0, 0, 0, 0, '', 'Void Elf - No Saved Quest', 0, 6),
(35, 0, 49928, 0, 0, 16, 0, 268435456, 0, 0, 0, 0, '', 'Void Elf - race', 0, 6),

-- Nightborne (49784)
(35, 0, 49784, 0, 0, 17, 0, 12413, 0, 0, 1, 0, '', 'Nightborne - no achievement Legacy of the Nightborne', 0, 6),
(35, 0, 49784, 0, 0, 27, 0, 110, 0, 0, 0, 0, '', 'Nightborne - level 110', 0, 6),
(35, 0, 49928, 0, 0, 14, 0, 49784, 0, 0, 0, 0, '', 'Nightborne - No Saved Quest', 0, 6),
(35, 0, 49784, 0, 0, 16, 0, 67108864, 0, 0, 0, 0, '', 'Nightborne - race', 0, 6),

-- Lightforged Draenei (49782)
(35, 0, 49782, 0, 0, 17, 0, 12414, 0, 0, 1, 0, '', 'Lightforged Draenei - no achievement Legacy of the Lightforged', 0, 6),
(35, 0, 49782, 0, 0, 27, 0, 110, 0, 0, 0, 0, '', 'Lightforged Draenei - level 110', 0, 6),
(35, 0, 49928, 0, 0, 14, 0, 49782, 0, 0, 0, 0, '', 'Lightforged Draenei - No Saved Quest', 0, 6),
(35, 0, 49782, 0, 0, 16, 0, 536870912, 0, 0, 0, 0, '', 'Lightforged Draenei - race', 0, 6),

-- Highmountain Tauren (49783)
(35, 0, 49783, 0, 0, 17, 0, 12415, 0, 0, 1, 0, '', 'Highmountain Tauren - no achievement Legacy of the Highmountain', 0, 6),
(35, 0, 49783, 0, 0, 27, 0, 110, 0, 0, 0, 0, '', 'Highmountain Tauren - level 110', 0, 6),
(35, 0, 49928, 0, 0, 14, 0, 49783, 0, 0, 0, 0, '', 'Highmountain Tauren - No Saved Quest', 0, 6),
(35, 0, 49783, 0, 0, 16, 0, 134217728, 0, 0, 0, 0, '', 'Highmountain Tauren - race', 0, 6);

-- https://tracker.legionbugs.com/view.php?id=34380
DELETE FROM `smart_scripts` WHERE `entryorguid` = 44916 AND `id` IN (3);
INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `event_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `action_param_float`, `action_delay`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
(44916, 0, 3, 0, 19, 0, 100, 0, 27069, 0, 0, 0, 0, 85, 83839, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'QA - Cast');

-- https://tracker.legionbugs.com/view.php?id=34381
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = -100 WHERE `entry` = 77314 AND `item` = 108410;