UPDATE `creature_template` SET `gossip_menu_id`='30657' WHERE `entry`=30657;
DELETE FROM `gossip_menu` WHERE `entry`=30657;
INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES (30657, 1);
DELETE FROM `gossip_menu_option` WHERE `menu_id`=30657;
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
('30657', '0', '0', 'The Lich kings minnions are comming. May i prepare cannon for you?', '1', '3', '0', '0', '30657', '0', '0', 'Are you ready to defend the camp?');
/*
DELETE FROM `gossip_scripts` WHERE `id`=30657;
INSERT INTO `gossip_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES
(30657, 0, 10, 730017, 600000, 0, 6291.32, 140.507, 386.517, 4.43048),
(30657, 0, 10, 730017, 600000, 0, 6311.92, 127.115, 389.501, 3.98517),
(30657, 0, 10, 730019, 600000, 0, 6325.59, 115.692, 390.431, 3.78489),
(30657, 0, 10, 730019, 600000, 0, 6343.48, 94.1783, 391.444, 3.54927),
(30657, 0, 10, 730019, 600000, 0, 6339.35, 67.395, 390.09, 2.6657),
(30657, 0, 10, 730017, 600000, 0, 6265.25, 145.87, 383.394, 4.59306),
(30657, 0, 10, 730021, 600000, 0, 6272.11, 77.81, 393.821, 0.69),
(30657, 0, 6, 571, 0, 0, 6272.30, 77.69, 393.82, 0.82),
(30657, 0, 10, 30236, 600000, 0, 6282.92, 70.2466, 396.427, 0.936193),
(30657, 0, 10, 30236, 600000, 0, 6273.69, 79.3612, 396.309, 0.791233),
(30657, 0, 10, 30236, 600000, 0, 6264.18, 85.28, 391.7, 0.68),
(30657, 0, 10, 30236, 600000, 0, 6289.03, 61.45, 391.81, 0.92);
*/
SET @NPC_Fezzik :=30657;
UPDATE `creature_template` SET `AIName`='SmartAI',`ScriptName`='',`npcflag`=3 WHERE `entry`=@NPC_Fezzik;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@NPC_Fezzik 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
(@NPC_Fezzik,0,0,0,1,0,100,0,1000,1000,1000,1000,15,3070,0,0,0,0,0,18,1,0,0,0,0,0,0,'Complete quest on player range'),
(@NPC_Fezzik,0,1,0,62,0,100,0,30657,0,0,0,12,30236,3,600000,0,0,0,8,0,0,0,6282.92,70.2466,396.427,0.936193,'Siegemaster Fezzik - summon cannon on gossip'),
(@NPC_Fezzik,0,2,1,61,0,100,0,0,0,0,0,12,30236,3,600000,0,0,0,8,0,0,0,6289.03,61.45,391.81,0.92,'Siegemaster Fezzik - summon cannon on gossip'),
(@NPC_Fezzik,0,3,2,61,0,100,0,0,0,0,0,12,30236,3,600000,0,0,0,8,0,0,0,6273.69,79.3612,396.309,0.791233,'Siegemaster Fezzik - summon cannon on gossip'),
(@NPC_Fezzik,0,4,3,61,0,100,0,0,0,0,0,12,30236,3,600000,0,0,0,8,0,0,0,6264.18,85.28,391.7,0.68,'Siegemaster Fezzik - summon cannon on gossip'),
(@NPC_Fezzik,0,5,4,61,0,100,0,0,0,0,0,12,730017,3,600000,0,0,0,8,0,0,0,6291.32, 140.507, 386.517, 4.43048,'Siegemaster Fezzik - summon spawner on gossip'),
(@NPC_Fezzik,0,6,5,61,0,100,0,0,0,0,0,12,730017,3,600000,0,0,0,8,0,0,0,6311.92, 127.115, 389.501, 3.98517,'Siegemaster Fezzik - summon spawner on gossip'),
(@NPC_Fezzik,0,7,6,61,0,100,0,0,0,0,0,12,730017,3,600000,0,0,0,8,0,0,0,6265.25, 145.87, 383.394, 4.59306,'Siegemaster Fezzik - summon spawner on gossip'),
(@NPC_Fezzik,0,8,7,61,0,100,0,0,0,0,0,12,730019,3,600000,0,0,0,8,0,0,0,6325.59, 115.692, 390.431, 3.78489,'Siegemaster Fezzik - summon spawner on gossip'),
(@NPC_Fezzik,0,9,8,61,0,100,0,0,0,0,0,12,730019,3,600000,0,0,0,8,0,0,0,6343.48, 94.1783, 391.444, 3.54927,'Siegemaster Fezzik - summon spawner on gossip'),
(@NPC_Fezzik,0,10,9,61,0,100,0,0,0,0,0,12,730019,3,600000,0,0,0,8,0,0,0,6339.35, 67.395, 390.09, 2.6657,'Siegemaster Fezzik - summon spawner on gossip'),
(@NPC_Fezzik,0,11,10,61,0,100,0,0,0,0,0,81,2,0,0,0,0,0,7,0,0,0,0,0,0,0,'Fezzik - set flag to gossip'),
(@NPC_Fezzik,0,12,11,1,0,100,0,600000,600000,0,0,81,3,0,0,0,0,0,7,0,0,0,0,0,0,0,'Fezzik - set flag back to quest giver ');