DELETE FROM `gossip_menu_option` WHERE `menu_id`=1047 AND `id`=1;
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
(1047, 1, 0, 'I would like to learn the \'Minor Recombobulator\'.', 1, 1, 0, 0, 0, 0, '');

-- Matrix Punchograph 3005-B SAI
SET @ENTRY := 142475;
UPDATE `gameobject_template` SET `AIName`="SmartGameObjectAI" WHERE `entry`=@ENTRY;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=1;
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,1,0,1,62,0,100,0,1047,0,0,0,56,9282,1,0,0,0,0,7,0,0,0,0,0,0,0,"Matrix Punchograph 3005-B - On Gossip Option 0 Selected - Add Item 'Blue Punch Card' 1 Time"),
(@ENTRY,1,1,2,61,0,100,0,1047,0,0,0,57,9280,1,0,0,0,0,7,0,0,0,0,0,0,0,"Matrix Punchograph 3005-B - On Gossip Option 0 Selected - Remove Item 'Yellow Punch Card' 1 Time"),
(@ENTRY,1,2,0,61,0,100,0,1047,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,"Matrix Punchograph 3005-B - On Gossip Option 0 Selected - Close Gossip"),
(@ENTRY,1,4,5,62,0,100,0,1047,1,0,0,85,4011,2,0,0,0,0,7,0,0,0,0,0,0,0,"Matrix Punchograph 3005-B - On Gossip Option 1 Selected - Invoker Cast 'Minor Recombobulator'"),
(@ENTRY,1,5,0,61,0,100,0,1047,1,0,0,72,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Matrix Punchograph 3005-B - On Gossip Option 1 Selected - Close Gossip");

DELETE FROM `gossip_menu_option` WHERE `menu_id`=1050 AND `id`=1;
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
(1050, 1, 0, 'I would like to learn the \'Discombobulator Ray\'.', 1, 1, 0, 0, 0, 0, '');

-- Matrix Punchograph 3005-D SAI
SET @ENTRY := 142696;
UPDATE `gameobject_template` SET `AIName`="SmartGameObjectAI" WHERE `entry`=@ENTRY;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=1;
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,1,0,1,62,0,100,0,1050,0,0,0,56,9316,1,0,0,0,0,7,0,0,0,0,0,0,0,"Matrix Punchograph 3005-D - On Gossip Option 0 Selected - Add Item 'Prismatic Punch Card' 1 Time"),
(@ENTRY,1,1,2,61,0,100,0,1050,0,0,0,57,9281,1,0,0,0,0,7,0,0,0,0,0,0,0,"Matrix Punchograph 3005-D - On Gossip Option 0 Selected - Remove Item 'Red Punch Card' 1 Time"),
(@ENTRY,1,2,0,61,0,100,0,1050,0,0,0,72,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Matrix Punchograph 3005-D - On Gossip Option 0 Selected - Close Gossip"),
(@ENTRY,1,4,5,62,0,100,0,1050,1,0,0,85,11595,2,0,0,0,0,7,0,0,0,0,0,0,0,"Matrix Punchograph 3005-D - On Gossip Option 1 Selected - Invoker Cast 'Discombobulator Ray'"),
(@ENTRY,1,5,0,61,0,100,0,1050,1,0,0,72,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Matrix Punchograph 3005-D - On Gossip Option 1 Selected - Close Gossip");

/* conditions for all gossips */
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup` IN (1045, 1047, 1049, 1050);
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
(15, 1045, 0, 0, 0, 2, 0, 9279, 1, 0, 0, 0, 0, '', 'Show gossip option if player has White Punch Card'),
(15, 1047, 0, 0, 0, 2, 0, 9280, 1, 0, 0, 0, 0, '', 'Show gossip option if player has Yellow Punch Card'),
(15, 1049, 0, 0, 0, 2, 0, 9282, 1, 0, 0, 0, 0, '', 'Show gossip option if player has Blue Punch Card'),
(15, 1050, 0, 0, 0, 2, 0, 9281, 1, 0, 0, 0, 0, '', 'Show gossip option if player has Red Punch Card'),
(15, 1047, 1, 0, 0, 7, 0, 202, 140, 0, 0, 0, 0, '', 'Show gossip option if player has Engineering 140'),
(15, 1050, 1, 0, 0, 7, 0, 202, 140, 0, 0, 0, 0, '', 'Show gossip option if player has Engineering 140');