From e370e471833be841504ffe3d62d69fc481f8c360 Mon Sep 17 00:00:00 2001 From: Malcrom Date: Mon, 8 Apr 2024 20:53:06 +0200 Subject: DB/Forbidden Reach: Minor fixes for first dracthyr quest --- sql/updates/world/master/2024_04_08_01_world.sql | 23 +++++++++++++++++++++++ 1 file changed, 23 insertions(+) create mode 100644 sql/updates/world/master/2024_04_08_01_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2024_04_08_01_world.sql b/sql/updates/world/master/2024_04_08_01_world.sql new file mode 100644 index 00000000000..9e73192fc3a --- /dev/null +++ b/sql/updates/world/master/2024_04_08_01_world.sql @@ -0,0 +1,23 @@ +-- Add spellclick and questgiver flags +UPDATE `creature_template` SET `npcflag`=16777218 WHERE entry IN (187223,181494); + +-- Spell Click +DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN (187223,181494); +INSERT INTO `npc_spellclick_spells` (`npc_entry`,`spell_id`,`cast_flags`,`user_type`) VALUES +(187223,362355,1,0), +(181494,362355,1,0); + +-- Quest data +DELETE FROM `creature_queststarter` WHERE `id` IN (187223,181494) AND `quest`=64864; +INSERT INTO `creature_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES +(187223, 64864, 52649), +(181494, 64864, 52649); + +-- Condition for Spell click event condition type Queststate +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=18 AND `SourceGroup` IN (187223,181494) AND `SourceEntry` IN (362355) AND `SourceId`=0; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(18, 187223, 362355, 0, 0, 47, 0, 64864, 8, 0, 0, 0, 0, '', 'Spellclick unit Kodethi will have Disintegrate cast on him if quest Awaken, Dracthyr'), +(18, 181494, 362355, 0, 1, 47, 0, 64864, 8, 0, 0, 0, 0, '', 'Spellclick unit Dervishian will have Disintegrate cast on him if quest Awaken, Dracthyr'); + +-- Quest Awaken, Dracthyr is not an auto accept quest +UPDATE `quest_template_addon` SET `SpecialFlags`=0 WHERE `ID`=64864; -- cgit v1.2.3