Merchant Lorvo (NPC=54943)

DELETE FROM `creature_text` WHERE `CreatureID` = 54943;
INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES
(54943, 0, 0, 'Shhhh! Come quietly. She''s practicing.', 12, 0, 100, 0, 0, 0, 0, 0, 'Merchant Lorvo');

DELETE FROM `areatrigger_scripts` WHERE `entry` = 7748;
INSERT INTO `areatrigger_scripts` (`entry`, `ScriptName`) VALUES
(7748, 'SmartTrigger');

SET @GUID = ( SELECT guid FROM creature WHERE id = 54943 ORDER BY guid ASC LIMIT 1 );

UPDATE creature_template SET AIName = 'SmartAI' WHERE entry = 54943;
DELETE FROM `smart_scripts` WHERE `entryorguid` IN (7748, 54943);
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`, `event_param5`, `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
(7748, 2, 0, 0, 46, 0, 100, 0, 7748, 0, 0, 0, 0, 86, 116221, 2, 10, @GUID, 54943, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'On Trigger - Cross Cast'),
(54943, 0, 0, 0, 31, 0, 100, 0, 116221, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'On SpellHit - Talk');

DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceEntry` = 7748;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
(22, 1, 7748, 2, 0, 1, 0, 116221, 0, 0, 1, 0, 0, '', 'SAI only - Player has aura, Negation');