Trainee Nim (NPC=60183)

DELETE FROM `creature_text` WHERE `CreatureID` = 60183;
INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES
(60183, 0, 0, 'I hope you''re ready, $p. Jaomin Ro awaits you just over the bridge.', 12, 0, 100, 0, 0, 0, 0, 0, 'Trainee Nim');

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

SET @GUID = ( SELECT guid FROM creature WHERE id = 60183 );

UPDATE creature_template SET AIName = 'SmartAI' WHERE entry = 60183;
DELETE FROM `smart_scripts` WHERE `entryorguid` IN (7746, 60183);
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
(7746, 2, 0, 0, 46, 0, 100, 0, 7746, 0, 0, 0, 0, 86, 116219, 2, 10, @GUID, 60183, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'On Trigger - Cross Cast'),
(60183, 0, 0, 0, 31, 0, 100, 0, 116219, 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` = 7746;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
(22, 1, 7746, 2, 0, 1, 0, 116219, 0, 0, 1, 0, 0, '', 'SAI only - Player has aura');