Advertisement
Guest User

g

a guest
Feb 7th, 2011
662
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.26 KB | None | 0 0
  1. -- --------------------------------------------------------------------------------
  2. -- 2011_02_04_0_world_quest_template.sql
  3. -- --------------------------------------------------------------------------------
  4. -- Fix missing Previous Quest Requirement for They Grow Up So Fast
  5. UPDATE `quest_template` SET `prevquestid`=13887 WHERE `entry`=13906;
  6.  
  7.  
  8. -- --------------------------------------------------------------------------------
  9. -- 2011_02_04_0_world_sai.sql
  10. -- --------------------------------------------------------------------------------
  11. -- Heldgarr Steelbeard "Valiance Keep" SAI (tested)
  12. UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry`=25281;
  13. DELETE FROM `smart_scripts` WHERE `entryorguid` IN (25281);
  14. 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
  15. (25281,0,0,0,1,0,100,0,6000,6000,6000,6000,11,45425,2,0,0,0,0,10,103993,24921,0,0,0,0,0,'Fire at target every 6 sec');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement