0 Потребители и 1 Гост преглежда(т) тази тема.
UPDATE `creature_template` SET `ainame`='SmartAI' WHERE `entry` IN (27370,27359);UPDATE `creature_template` SET `unit_flags`=512,`flags_extra`=2 WHERE `entry`=27359; DELETE FROM `creature_text` WHERE `entry`=27359;INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES('27359','0','0','Good of you to come, champion! The beast almost had me!','12','0','0','0','0','0',''),('27359','0','1','Finally! A hero has come!','12','0','0','0','0','0',''),('27359','0','2','Thank you, kind soul.','12','0','0','0','0','0',''),('27359','0','3','I\'ll never forget you, friend.','12','0','0','0','0','0','');DELETE FROM `smart_scripts` WHERE `entryorguid`=27370 AND `source_type`=0;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('27370','0','0','0','4','0','100','0','0','0','0','0','64','1','0','0','0','0','0','2','0','0','0','0','0','0','0','On Aggro - Store Target List '),('27370','0','1','2','6','0','100','0','0','0','0','0','100','1','0','0','0','0','0','19','27359','10','0','0','0','0','0','On Death - Send stored targets'),('27370','0','2','0','61','0','100','0','0','0','0','0','45','0','1','0','0','0','0','19','27359','10','0','0','0','0','0','Link With Previous Event - Set Data 0 1 ');DELETE FROM `smart_scripts` WHERE `entryorguid`=27359 AND `source_type`=0;DELETE FROM `smart_scripts` WHERE `entryorguid`=2735900 AND `source_type`=9;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('27359','0','0','0','38','0','100','0','0','1','0','0','80','2735900','0','0','0','0','0','1','0','0','0','0','0','0','0','On Data Set 0 1 - Call Timed Actionlist'),('27359','0','1','0','40','0','100','0','1','27359','0','0','41','0','0','0','0','0','0','1','0','0','0','0','0','0','0','On WP Reached - Despawn'),('27359','0','2','0','11','0','100','0','0','0','0','0','11','48361','3','0','0','0','0','1','0','0','0','0','0','0','0','On Spawn - Cast Helpless Wintergarde Villager Aggro Aura'),('2735900','9','0','0','0','0','100','0','0','0','0','0','28','48361','0','0','0','0','0','1','0','0','0','0','0','0','0','Event 0 - Remove Aura'),('2735900','9','1','0','0','0','100','0','0','0','0','0','1','0','0','0','0','0','0','1','0','0','0','0','0','0','0','Event 1 - Talk'),('2735900','9','2','0','0','0','100','0','0','0','0','0','33','27359','0','0','0','0','0','12','1','0','0','0','0','0','0','Event 2 - Give Quest Credit '),('2735900','9','3','0','0','0','100','0','2000','2000','0','0','53','1','27359','0','0','0','0','1','0','0','0','0','0','0','0','Event 2 - Sart WP Movement');DELETE FROM `waypoints` WHERE `entry`=27359;INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES('27359','1','3719.13','-839.1','164.9',NULL);DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceEntry`=27359 AND `SourceGroup`=1;INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES('22','1','27359','0','0','1','1','48361','0','0','0','0','0','',NULL);