Advertisement
Guest User

Field Repair Bot 74A SAI and Conditions

a guest
Oct 31st, 2014
163
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.96 KB | None | 0 0
  1. -- Schematic: Field Repair Bot 74A SAI and Conditions
  2. SET @ENTRY := 179552;
  3. UPDATE `gameobject_template` SET `AIName`="SmartGameObjectAI" WHERE `entry`=@ENTRY;
  4. DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=1;
  5. 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
  6. (@ENTRY,1,0,1,62,0,100,0,5749,0,0,0,85,22864,0,0,0,0,0,7,0,0,0,0,0,0,0,"Schematic: Field Repair Bot 74A - On Gossip Option 0 Selected - Invoker Cast 'Field Repair Bot 74A'"),
  7. (@ENTRY,1,1,0,61,0,100,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,"Schematic: Field Repair Bot 74A - On Gossip Option 0 Selected - Close Gossip");
  8.  
  9. DELETE FROM `conditions` WHERE `SourceGroup`=5749;
  10. INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
  11. (14,5749,6932,0,0,25,0,22704,0,0,0,0,0,"","Show gossip menu if player learned the spell"),
  12. (14,5749,6929,0,0,25,0,4036,0,0,1,0,0,"","Show gossip menu if player is not an Engineer"),
  13. (14,5749,6930,0,0,7,0,202,300,0,0,0,0,"","Show gossip menu if player have 300 or more in Engineering"),
  14. (14,5749,6931,0,0,25,0,4036,0,0,0,0,0,"","Show gossip menu if player is an Engineer"),
  15. (14,5749,6931,0,0,7,0,202,300,0,1,0,0,"","Show gossip menu if player is an Engineer but have less than 300"),
  16. (15,5749,0,0,0,25,0,22704,0,0,1,0,0,"","Show gossip menu if player doesn't learned the spell"),
  17. (15,5749,0,0,0,7,0,202,300,0,0,0,0,"","Show gossip menu if player have 300 or more in Engineering");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement