API tools faq
paste
Advertisement
LKArthas

Kaw the Mammoth Destroyer (Trinity Core Adaptation)

LKArthas
Feb 9th, 2016
104
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 5.06 KB | None | 0 0
raw download clone embed print report
  1. -- Fix quest 11879 "Kaw the Mammoth Destroyer"
  2. -- Set to SAI and delete CAIS
  3. UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`='25802';
  4. UPDATE `creature_template` SET `unit_flags`=0, `AIName`='SmartAI' WHERE `entry`='25881';
  5.  
  6. -- Wooly Mammoth Bull SAI
  7. UPDATE `creature_template` SET `npcflag`=16777216 WHERE  `entry`=25743;
  8.  
  9. UPDATE `creature_template` SET `spell1`=46317,`spell2`=46315,`spell3`=46316,`Health_mod`=2 WHERE `entry`=25743;
  10. DELETE FROM `smart_scripts` WHERE `entryorguid`=25743 AND `source_type`=0 AND `id` IN (2,3);
  11. 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
  12. (25743,0,2,0,27,0,100,0,0,0,0,0,8,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Wooly Mammoth Bull - On Passenger board - Set react state passive'),
  13. (25743,0,3,0,28,0,100,0,0,0,0,0,41,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Wooly Mammoth Bull - On Passenger remove - Despawn');
  14.  
  15. -- Wooly Mammoth Bull Vehicle condition
  16. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=16 AND `SourceEntry`=25743;
  17. INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
  18. (16,0,25743,0,0,9,0,11879,0,0,0,0,'','Vehicle Wooly Mammoth Bull requires quest 11879');
  19.  
  20. -- Apply rep aura on quest accept
  21. DELETE FROM `spell_area` WHERE `spell`=46234;
  22. INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES
  23. (46234, 3537, 11879, 0, 0, 0, 2, 1, 74, 11);
  24.  
  25. -- Kaw speach on event start
  26. DELETE FROM `creature_text` WHERE `entry`='25802';
  27. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES
  28. (25802, 0, 0, 'You challenge Kaw, destroyer of mammoths? Then face me and feel my thunder!', 14, 0, 100, 0, 0, 0, 'Kaw the Mammoth Destroyer');
  29. DELETE FROM `creature_loot_template` WHERE `entry`=25802 AND `item`=35234;
  30. DELETE FROM `creature_loot_template` WHERE `entry`=25881 AND `item`=35234;
  31.  
  32. -- Kaw SAI
  33. DELETE FROM `smart_scripts` WHERE `entryorguid`='25802' AND `source_type`=0;
  34. DELETE FROM `smart_scripts` WHERE `entryorguid`='2580200' AND `source_type`=9;
  35. 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
  36. (25802,0,0,0,1,0,100,1,0,0,0,0,18,33024,0,0,0,0,0,1,0,0,0,0,0,0,0,'Kaw - OOC - Make self unattackable'),
  37. (25802,0,1,0,4,0,100,0,1,1,0,0,80,2580200,2,0,0,0,0,1,0,0,0,0,0,0,0,'Kaw - On Aggro - Run Script'),
  38. (25802,0,2,0,6,0,100,0,0,0,0,0,11,46310,2,0,0,0,0,1,0,0,0,0,0,0,0,'Kaw - On Death - Cast Drop War Halberd'),
  39. (2580200,9,0,0,0,0,100,1,0,0,0,0,1,0,2000,0,0,0,0,1,0,0,0,0,0,0,0,'Kaw - Timed - Yell'),
  40. (2580200,9,1,0,0,0,100,1,0,0,0,0,59,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Kaw - Timed - Enable Running'),
  41. (2580200,9,2,0,0,0,100,1,3000,3000,0,0,69,0,0,0,0,0,0,8,0,0,0,3974.17,5476.31,35.602,5.564,'Kaw - Timed - Move to Moria'),
  42. (2580200,9,3,0,0,0,100,1,2500,2500,0,0,11,46260,2,0,0,0,0,19,25881,100,0,0,0,0,0,'Kaw - Timed - Mount to Moria');
  43.  
  44. -- Moria SAI
  45. DELETE FROM `smart_scripts` WHERE `entryorguid`='25881';
  46. DELETE FROM `smart_scripts` WHERE `entryorguid`='2588100';
  47.  
  48. 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
  49. (25881,0,0,0,8,0,100,1,46317,0,0,0,80,2588100,2,0,0,0,0,1,0,0,0,0,0,0,0,'Moria - On spell hit - Start Event'),
  50. (25881,0,1,0,6,0,100,1,0,0,0,0,19,33024,0,0,0,0,0,19,25802,100,0,0,0,0,0,'Moria - On death - Make Kaw attackable'),
  51. (25881,0,2,0,1,0,100,1,0,0,0,0,8,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Moria - OOC - Set passive'),
  52. (25881,0,3,0,1,0,100,1,0,0,0,0,28,46260,0,0,0,0,0,1,0,0,0,0,0,0,0,'Moria - OOC - Dismount Kaw'),
  53. (2588100,9,0,0,0,0,100,1,0,0,0,0,11,17683,2,0,0,0,0,1,0,0,0,0,0,0,0,'Moria - Timed - Heal self'),
  54. (2588100,9,1,0,0,0,100,1,0,0,0,0,45,1,1,0,0,0,0,19,25802,100,0,0,0,0,0,'Moria - Timed - Set Data 1 1 on Kaw'),
  55. (2588100,9,2,0,0,0,100,1,5500,5500,0,0,8,2,0,0,0,0,0,1,0,0,0,0,0,0,0,'Moria - Timed - Set aggresive');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!