Coren Direbrew

SET @Entry := 23872;
SET @Gossip := 30000;
SET @GossipSub :=@Gossip +1;
SET @GosOption1 :=0;
SET @GosOption2 :=1;
SET @CorenGuid :=213141;
-- Spawn Coren Direbrew
DELETE FROM `creature` WHERE `guid`=@CorenGuid;
INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES
(@CorenGuid, 23872, 230, 1, 1, 0, 0, 894.145, -129.226, -49.7446, 5.23982, 300, 0, 0, 302400, 0, 0, 0, 0, 0); -- Coren Direbrew
-- Add Dialog options
UPDATE `creature_template` SET `gossip_menu_id`=@Gossip, `faction_A`=735, `faction_H`=735, `npcflag`=1 WHERE `entry`=23872 LIMIT 1;
-- Bulk Gossip Text Main
DELETE FROM `gossip_menu` WHERE `entry`=@Gossip;
INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES (@Gossip, 15858);
-- Main menu Options
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, 0, 0, 'Insult Coren Direbrew\'s brew', 1, 1, @GossipSub, 1, 0, 0, NULL);
-- Bulk Gossip Text Sub
DELETE FROM `gossip_menu` WHERE `entry`=@GossipSub;
INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES (@GossipSub, 15859);
-- Submenu Options
DELETE FROM `gossip_menu_option` WHERE `menu_id`=@GossipSub;
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
(@GossipSub, @GosOption1, 0, 'Fight!', 1, 1, 0, 0, 0, 0, NULL),
(@GossipSub, @GosOption2, 0, 'Apoligize', 1, 1, 0, 0, 0, 0, NULL);
-- Add creature text for Coren
DELETE FROM `creature_text` WHERE `entry`=@Entry;
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES
(@Entry, 0, 0, 'This is an insult! An affront! They deny us participation in time-honored dwarven traditions!', 12, 0, 0, 0, 0, 0, 'Coren_Direbrew_To_Troops'),
(@Entry, 1, 0, 'Are We Going to hide in our mountain and let those swill-peddlers have their little shindig without us?!', 12, 0, 0, 0, 0, 0, 'Coren_Direbrew_To_Troops_2'),
(@Entry, 2, 0, 'DAMN RIGHT! We\'ll show \'em why you don\'t cross the Dark iron dwarves!', 12, 0, 0, 0, 0, 0, 'Coren_Direbrew_To_Troops_3'),
(@Entry, 3, 0, 'You\'ll pay for this insult, $C!', 12, 0, 0, 0, 0, 0, 'Coren_Direbrew_Start');
-- Coren Dire brew Script
UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry`=@Entry;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@Entry;
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
(@Entry,0,0,0,1,0,100,0,0,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'Coren Direbrew - phase 1 - gossip'),
(@Entry,0,1,0,62,1,100,0,@GossipSub,@GosOption2,0,0,72,0,0,0,0,0,0,7,0,0,0,0.0,0.0,0.0,0.0,'Coren Direbrew - Select Apoligize - Close gossip'),
(@Entry,0,2,3,62,1,100,0,@GossipSub,@GosOption1,0,0,81,0,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'Coren Direbrew - Select Fight - remove npc flag'),
(@Entry,0,3,4,61,1,100,0,0,0,0,0,72,2,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'Coren Direbrew - close gossip'),
(@Entry,0,4,5,61,1,100,0,0,0,0,0,2,736,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'Coren Direbrew - change faction'),
(@Entry,0,5,6,61,1,100,0,0,0,0,0,1,3,1,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'Coren Direbrew - Say Start'),
(@Entry,0,6,0,61,1,100,0,0,0,0,0,18,524288,7,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'Coren Direbrew - Enter combat');