diff options
| author | Malcrom <malcromdev@gmail.com> | 2024-04-08 20:53:06 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2024-04-08 20:53:06 +0200 |
| commit | e370e471833be841504ffe3d62d69fc481f8c360 (patch) | |
| tree | 24a151ca2e45117ccf08865019e673fc488156b8 /sql | |
| parent | 4f5d1737a3975b0815ddd48f724b7df4fb46860a (diff) | |
DB/Forbidden Reach: Minor fixes for first dracthyr quest
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2024_04_08_01_world.sql | 23 |
1 files changed, 23 insertions, 0 deletions
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 <Dark Talons> 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 <Obsidian Warders> 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;
|