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


---
--- Misión 14469:
--- https://imgur.com/a/XiiEj4S
---

-- npcflag Spellclick y SmartAI para el NPC 36756
UPDATE creature_template SET npcflag = 16777216, AIName = "SmartAI" WHERE entry = 36756;

-- npc_spellclick_spells 69261 para el NPC 36756
DELETE FROM npc_spellclick_spells WHERE npc_entry = 36756;
INSERT INTO npc_spellclick_spells (`npc_entry`, `spell_id`, `cast_flags`, `user_type`) VALUES
(36756, 69261, 2, 1);

-- smart_scripts
DELETE FROM smart_scripts WHERE entryorguid IN (36756, 3675600);
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`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
(36756, 0, 0, 0, 73, 0, 100, 0, 0, 0, 0, 0, 80, 3675600, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "WarSages - Dead Soldier - On Spellclick - Call Timed Action List"),
(3675600, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 18, 33554432, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "WarSages - Dead Soldier - On Script - Set Unit Flags"),
(3675600, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 5, 381, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, "WarSages - Dead Soldier - On Script - Play Emote"),
(3675600, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 41, 1000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "WarSages - Dead Soldier - On Script - Force Despawn");

-- condition para que el spellclick del NPC 36756 solo se pueda usar teniendo la misión 14469
DELETE FROM conditions WHERE SourceGroup = 36756;
INSERT INTO conditions (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
(18, 36756, 69261, 0, 0, 9, 0, 14469, 0, 0, 0, 0, 0, "", "WarSages - Condition para que el spellclick del NPC 36756 solo se pueda usar teniendo la misión 14469 o cuando no se tiene completa");

-- quest_poi
DELETE FROM quest_poi WHERE questId = 14469;
INSERT INTO quest_poi (`questId`, `id`, `objIndex`, `mapid`, `WorldMapAreaId`, `FloorId`, `unk3`, `unk4`, `VerifiedBuild`) VALUES
(14469, 0, -1, 1, 181, 0, 0, 1, 0),
(14469, 1, 4, 1, 181, 0, 0, 7, 0);

-- quest_poi_points
DELETE FROM quest_poi_points WHERE questId = 14469;
INSERT INTO quest_poi_points (`questId`, `id`, `idx`, `x`, `y`, `VerifiedBuild`) VALUES
(14469, 0, 0, 3261, -4997, 0),
(14469, 1, 0, 3356, -5026, 0),
(14469, 1, 1, 3433, -4997, 0),
(14469, 1, 2, 3529, -4925, 0),
(14469, 1, 3, 3558, -4876, 0),
(14469, 1, 4, 3558, -4833, 0),
(14469, 1, 5, 3515, -4790, 0),
(14469, 1, 6, 3394, -4833, 0),
(14469, 1, 7, 3341, -4852, 0),
(14469, 1, 8, 3327, -4876, 0),
(14469, 1, 9, 3322, -4915, 0),
(14469, 1, 10, 3322, -4958, 0),
(14469, 1, 11, 3336, -4992, 0);

-- RequestItemsText y OfferRewardText
UPDATE quest_template SET RequestItemsText = "Nothing wrong with recycled goods." WHERE id = 14469;
UPDATE quest_template SET OfferRewardText = "You're a light-footed bugger, aren't ya? Good work.$B$BHere are a few of the supplies to keep you lively." WHERE id = 14469;


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