casucristy

qyas

Jul 14th, 2012
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.88 KB | None | 0 0
  1. -- [Q]Fires Over Skettis
  2. -- http://old.wowhead.com/quest=11008
  3.  
  4. SET @TRIGGER := 22991;
  5. SET @EGG := 185549;
  6. SET @SKYBLAST := 39844;
  7. SET @SUMMEGG := 39843;
  8.  
  9. DELETE FROM `gameobject` WHERE `id`=185549;
  10. UPDATE `creature` SET `spawntimesecs` = 10;
  11. UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry`=@TRIGGER;
  12. DELETE FROM `smart_scripts` WHERE (`entryorguid`=22991 AND `source_type`=0);
  13. 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
  14. (@TRIGGER,0,0,0,1,0,100,0,60000,60000,60000,60000,50,185549,48880,0,0,0,0,1,0,0,0,0,0,0,0, 'Monstrous Kaliri Egg Bunny - OOC - Summon Egg'),
  15. (@TRIGGER,0,1,2,8,0,100,0,@SKYBLAST,0,0,0,33,@TRIGGER,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Monstrous Kaliri Egg Trigger - On Skyguard Blasting Charge hit - Give kill credit'),
  16. (@TRIGGER,0,2,0,61,0,100,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Monstrous Kaliri Egg Trigger - Linked event - Despawn');
  17.  
  18. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=@SKYBLAST;
  19. DELETE FROM `conditions` WHERE `SourceEntry` = @TRIGGER;
  20. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
  21. (13,1,@SKYBLAST,1,31,3,@TRIGGER,0,0,'',"targets Monstrous Kaliri Egg Trigger"),
  22. (13,1,@SKYBLAST,0,31,3,@EGG,1,0,'',"targets Monstrous Kaliri Object"),
  23. (22,1,@TRIGGER,0,0,30,185549,1,0,'','SAI will only summ if there is the object on the creature');
Advertisement
Add Comment
Please, Sign In to add comment