Anachronos

http://www.youtube.com/watch?v=0-djLEhf8vI
SET @GOSSIP=51000;
SET @NPC=15192;
SET @NPCTEXT=15192;
SET @QUEST = 8742;
-- Update Gossip menu id in Anachronos Creature template
UPDATE `creature_template` SET `gossip_menu_id`=@GOSSIP WHERE `entry`=@NPC;
-- Add gossip menu
DELETE FROM `gossip_menu` WHERE `entry`=@GOSSIP;
INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES
(@GOSSIP, @NPCTEXT);
-- Add gossip menu option to get scepter
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`, `box_coded`, `box_money`, `box_text`) VALUES
(@GOSSIP, 1, 0, 'I am ready. Anachronos. Please grant me the scepter of the Shifting Sands.', 1, 1, 0, 0, 0, 0, '');
-- Add gossip text for after The Might of Kalimdor is complted
DELETE FROM `npc_text` WHERE `ID`=@NPCTEXT;
INSERT INTO `npc_text` (`ID`, `text0_0`, `text0_1`, `lang0`, `prob0`, `em0_0`, `em0_1`, `em0_2`, `em0_3`, `em0_4`, `em0_5`, `text1_0`, `text1_1`, `lang1`, `prob1`, `em1_0`, `em1_1`, `em1_2`, `em1_3`, `em1_4`, `em1_5`, `text2_0`, `text2_1`, `lang2`, `prob2`, `em2_0`, `em2_1`, `em2_2`, `em2_3`, `em2_4`, `em2_5`, `text3_0`, `text3_1`, `lang3`, `prob3`, `em3_0`, `em3_1`, `em3_2`, `em3_3`, `em3_4`, `em3_5`, `text4_0`, `text4_1`, `lang4`, `prob4`, `em4_0`, `em4_1`, `em4_2`, `em4_3`, `em4_4`, `em4_5`, `text5_0`, `text5_1`, `lang5`, `prob5`, `em5_0`, `em5_1`, `em5_2`, `em5_3`, `em5_4`, `em5_5`, `text6_0`, `text6_1`, `lang6`, `prob6`, `em6_0`, `em6_1`, `em6_2`, `em6_3`, `em6_4`, `em6_5`, `text7_0`, `text7_1`, `lang7`, `prob7`, `em7_0`, `em7_1`, `em7_2`, `em7_3`, `em7_4`, `em7_5`, `WDBVerified`) VALUES
(@NPCTEXT, 'The Scepter of the Shifting Sands is whole once more, $N.\r\n\r\nIt must be you who uses the scepter. It must be you who heralds in the next age of your people.\r\n\r\nYou must wait for the armies of the Horde and the alliance to arrive in Sillithus before you may ring the Scarab Gong. The time for war is close at hand.', '', 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, 0, 0, 0, 0, -1);
-- Add conditons for text and menu option to appear only after The Might of Kalimdor is complted
DELETE FROM `conditions` WHERE `SourceGroup`=@GOSSIP;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
(14, @GOSSIP, @NPCTEXT, 0, 0, 8, @QUEST, 0, 0, 0, '', 'Anachronos completed The Might of Kalimdor gossip'),
(15, @GOSSIP, 1, 0, 0, 8, @QUEST, 0, 0, 0, '', 'Anachronos completed The Might of Kalimdor gossip option');
-- Add SAI for Anachronos to give scepter when gossip option is selected
UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@NPC;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@NPC;
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
(@NPC,0,0,1,62,0,100,0,@GOSSIP,1,0,0,11,25861,0,0,0,0,0,7,0,0,0,0.0,0.0,0.0,0.0,'Anachronos - Select menu option - cast spell to give item'),
(@NPC,0,1,0,61,0,100,0,0,0,0,0,72,0,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'Anachronos - close gossip');