[WOD]The new you

[Cidragon]

Bugtracker link: https://firestorm-servers.com/es/report/see_report/10644

wowhead link: http://www.wowhead.com/quest=14109/the-new-you

brought correction: Add gossip behavior of npcs to complete quest

Code: 

-- http://www.wowhead.com/quest=14109/the-new-you

-- gossip menu
DELETE FROM `world`.`gossip_menu` WHERE `entry` IN('10620', '10622', '10624');
INSERT INTO `world`.`gossip_menu` (`entry`, `text_id`) VALUES 
('10620', '0'),
('10622', '0'),
('10624', '0');

-- add gossip option
DELETE FROM `world`.`gossip_menu_option` WHERE `menu_id` IN('10620', '10622', '10624');
INSERT INTO `world`.`gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `OptionBroadcastTextID`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `box_coded`, `box_money`, `box_text`, `BoxBroadcastTextID`) VALUES 
('10620', '0', '0', 'Set me up with the phattest, shiniest bling you got!', '0', '1', '1', '0', '0', '0', '0', '', '0'),
('10622', '0', '0', 'Szabo, I need a hip, new outfit for the party I\'m throwing!', '0', '1', '1', '0', '0', '0', '0', '', '0'),
('10624', '0', '0', 'I need some cool shades. What will two stacks of macaroons get me?', '0', '1', '1', '0', '0', '0', '0', '', '0');

-- add gossip condition on quest
DELETE FROM `world`.`conditions` where `ConditionValue1`='14109';
INSERT INTO `world`.`conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`) VALUES 
('15', '10620', '0', '0', '0', '9', '0', '14109', '0', '0', '0', '0', '0'),
('15', '10622', '0', '0', '0', '9', '0', '14109', '0', '0', '0', '0', '0'),
('15', '10624', '0', '0', '0', '9', '0', '14109', '0', '0', '0', '0', '0');

-- SAI 
DELETE FROM `world`.`smart_scripts` where `entryorguid` IN('35126', '35128' ,'35130');
INSERT INTO `world`.`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
('35126', '0', '0', '1', '62', '0', '100', '0', '10620', '0', '0', '0', '56', '47045', '1', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', 'Gappy Silvertooth - On Gossip Option 0 Selected - Add Item \'\' 1 Time'),
('35126', '0', '1', '0', '61', '0', '100', '0', '0', '0', '0', '0', '72', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Gappy Silvertooth - On Gossip Option 0 Selected - Close Gossip'),
('35126', '0', '2', '0', '64', '0', '100', '0', '0', '0', '0', '0', '10', '1', '3', '5', '6', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', 'Gappy Silvertooth - On Gossip Hello - Play Random Emote (1, 3, 5, 6)'),
('35128', '0', '0', '1', '62', '0', '100', '0', '10622', '0', '0', '0', '56', '47046', '1', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', 'Szabo - On Gossip Option 0 Selected - Add Item \'\' 1 Time'),
('35128', '0', '1', '0', '61', '0', '100', '0', '3', '0', '0', '0', '72', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Szabo - On Gossip Option 0 Selected - Close Gossip'),
('35128', '0', '2', '0', '64', '0', '100', '0', '0', '0', '0', '0', '10', '1', '3', '5', '6', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', 'Szabo - On Gossip Hello - Play Random Emote (1, 3, 5, 6)'),
('35130', '0', '0', '1', '62', '0', '100', '0', '10624', '0', '0', '0', '56', '47047', '1', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', 'Missa Spekkies - On Gossip Option 0 Selected - Add Item \'\' 1 Time'),
('35130', '0', '1', '0', '61', '0', '100', '0', '0', '0', '0', '0', '72', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Missa Spekkies - On Gossip Option 0 Selected - Close Gossip'),
('35130', '0', '2', '0', '64', '0', '100', '0', '0', '0', '0', '0', '10', '1', '3', '5', '6', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', 'Missa Spekkies - On Gossip Hello - Play Random Emote (1, 3, 5, 6)');

Note: This was tested on trinitycore 6.x branch with 22520 build so this should work on legion too I guess

Edited October 19, 2016 by Cidragon

[Mikrole]

Hello Cidragon,
thank you for this Patch but the Quest http://www.wowhead.com/quest=14109/the-new-you#comments is already working on our Expansion WoD.