-- Vyčarování portálu do SC po nabrání q + Gossip
SET @GUID_TIRION := 821056; -- quest giver
SET @NPC_TIRION := 31044; -- Tirion
SET @QUEST_REQUIRE := 13081; -- quest The Will of the Naaru
SET @NPC_RHYDIAN := 30656; -- Summoner portalu
SET @GUID_RHYDIAN := 821053; -- Summoner portalu
SET @SPELL_SC_PORT := 57676; -- portal
SET @GOSSIP := 30656;

UPDATE `creature_template` SET `gossip_menu_id`=@GOSSIP WHERE `entry`=@GOSSIP;
DELETE FROM `gossip_menu` WHERE `entry`=@GOSSIP;
INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES (@GOSSIP, 1);
DELETE FROM `gossip_menu_option` WHERE `menu_id`=@GOSSIP;
INSERT INTO `gossip_menu_option` (`menu_id` ,`id` ,`option_icon` ,`option_text` ,`option_id` ,`npc_option_npcflag` ,`action_menu_id` ,`action_poi_id` ,`action_script_id` ,`box_coded` ,`box_money` ,`box_text`) VALUES
(@GOSSIP, 0, 0, 'Hail. I could not help but overhear your conversation. Please allow me to lend some assistance.', 1, 1, 0, 0, @GOSSIP, 0, 0, NULL);
DELETE FROM `conditions` WHERE `SourceGroup`=@GOSSIP;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
(15, @GOSSIP, 0, 0, 9, @QUEST_REQUIRE, 0, 0, 0, '', 'Rhydian portal to Shattrath');

-- SAI
-- Tirion
UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@NPC_TIRION;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@GUID_TIRION 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
(@GUID_TIRION, 0, 0, 0, 19, 0, 100, 1, @QUEST_REQUIRE, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 10, @GUID_RHYDIAN, @NPC_RHYDIAN, 0, 0, 0, 0, 0, 'Tirion - On Q Accept - Set Data for Rhydian');
-- Rhydian
UPDATE `creature_template` SET `AIName`='SmartAI', `ScriptName`='', `npcflag`=1  WHERE `entry` =@NPC_RHYDIAN;
DELETE FROM `smart_scripts` WHERE `entryorguid` =@GUID_RHYDIAN;
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
(@GUID_RHYDIAN, 0, 0, 0, 38, 0, 100, 1, 1, 1, 0, 0, 11, @SPELL_SC_PORT, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Rhydian - On Data from Tirion - Summon portal SC'),
(@GUID_RHYDIAN, 0, 1, 2, 62, 0, 100, 0, @GOSSIP, 0, 0, 0, 11, @SPELL_SC_PORT, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Rhydian - On gossip select - Cast Portal On Self'),
(@GUID_RHYDIAN, 0, 2, 3, 61, 0, 100, 0, 0, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Rhydian - On gossip select - Close gossip');