-- [Q]The purification of the Quel'delar(H)
UPDATE `creature_template` SET `minlevel`=80,`maxlevel`=80,`Health_mod`=2.9480580,`Mana_mod`=1,`IconName`='Speak', `npcflag`=3,`gossip_menu_id`=50000,`AIname`='SmartAI' WHERE `entry`=37523;
-- spawn Warden of sunwell
DELETE FROM `creature` WHERE `id`=37523;
INSERT INTO `creature` VALUES ('1002398', '37523', '530', '1', '1', '0', '0', '12556.6', '-6779.59', '15.039', '0.223384', '300', '0', '0', '41', '60', '0', '0', '0', '0');
INSERT INTO `creature` VALUES ('1002399', '37523', '530', '1', '1', '0', '0', '12556.7', '-6769.64', '15.1005', '0.283409', '300', '0', '0', '41', '60', '0', '0', '0', '0');

DELETE FROM `gossip_menu` WHERE `entry`=50000;
INSERT INTO `gossip_menu` VALUES (50000,300000);
-- Texts from Warden of Sunwell
DELETE FROM `npc_text` WHERE `id`=300000;
INSERT INTO `npc_text` VALUES (300000, 'I will escort you into the Sunwell when you\'re ready.', 'I will escort you into the Sunwell when you\'re ready.', '0','1', '0', '1', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0','0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '12340');

DELETE FROM `gossip_menu_option` WHERE `menu_id`=50000;
INSERT INTO `gossip_menu_option` (`menu_id`,`id`,`option_icon`,`option_text`,`option_id`,`npc_option_npcflag`) VALUES
(50000,0,0,'I\'m ready to enter the Sunwell.',1,1);

-- Warden of Sunwell script SAI
DELETE FROM `smart_scripts` WHERE `entryorguid`=37523 AND `source_type`=0;
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
('37523', '0', '0', '1', '61', '0', '100', '0', '0', '0', '0', '0', '85', '70746', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', 'Warden of the Sunwell - On Gossip Select - Cast spell on self'),
('37523', '0', '1', '0', '62', '0', '100', '0', '50000', '0', '0', '0', '72', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Warden of the Sunwell - On Gossip Select - Close Gossip');

DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=50000;
/*INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
(15,50000,0,0,9,24596,0,0,0,'',"Only show first gossip if player is on quest The purification of the Quel'delar(H)"),
(15,50000,0,1,9,24595,0,0,0,'',"Only show first gossip if player is on quest The purification of the Quel'delar(A)");*/

DELETE FROM `spell_area` WHERE `spell`=70193;
INSERT INTO `spell_area` (`spell`,`area`,`quest_start`,`quest_end`,`aura_spell`,`racemask`,`gender`,`autocast`) VALUES
(70193,4075,24522,24553,0,0,2,1),
(70193,4075,24562,24564,0,0,2,1),
(70193,4094,24522,24553,0,0,2,1),
(70193,4094,24562,24564,0,0,2,1),
(70193,4080,24522,24553,0,0,2,1),
(70193,4080,24562,24564,0,0,2,1);

DELETE FROM `spell_target_position` WHERE `id`='70746';
INSERT INTO `spell_target_position`(`id`,`target_map`,`target_position_x` ,`target_position_y`,`target_position_z`,`target_orientation`) VALUES
(70746,580,1788.911865,648.928284,71.204185,2.171664);

-- Warden of Sunwell script
DELETE FROM `smart_scripts` WHERE `entryorguid`=37523;
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
(37523,0,0,1,62,0,100,0,50000,0,0,0,11,70746,0,0,0,0,0,7,0,0,0,0,0,0,0,"Warden of the Sunwell - On Gossip Select - Cast Spell Teleport Into Sunwell"),
(37523,0,1,0,61,0,100,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,"Warden of the Sunwell - On Gossip Select - Close Gossip");