[3.3.5][6.x] Kara NPC Fix: Koren

[ghost]

Rev: cebdf03
DB: TDB 335.60

Issue: Koren will currently allow everyone repair and buy from him. Retail behavior requires you to be at least honored with the Violet Eye to do such.

Source from 2.0.8

Koren will offer you his services to buy items and repair if you are honored or higher with 
The Violet Eye...

His gossip_menu_option is currently non-existant and there is no condition for this functionality.

Suggested Fix:

DELETE FROM `gossip_menu_option` WHERE `menu_id`=7435;
INSERT INTO `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 
(7435, 0, 1, 'I\'m in need of your skill as a blacksmith, Koren.', 14188, 3, 128, 0, 0, 0, 0, NULL, 0);

DELETE FROM `conditions` WHERE `SourceTypeOrReferenceID` = 15 AND `SourceGroup` = 7435;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES 
(15, 7435, 0, 0, 0, 5, 0, 967, 224, 0, 0, 0, 0, '', 'Koren - Show Vendor option if Honored thru Exalted with Violet Eye');

Tested all rep levels, and he will now only let you buy/sell with him starting at honored.

[Rushor]

nice :)

[Rushor]

aef7265