API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Dec 11th, 2014
218
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.23 KB | None | 0 0
raw download clone embed print report
  1. /*
  2. Author: Sparkless
  3. Ticket: 206
  4. Descr.: Quest Free at Last (GrizzlyHills) - New SmartScript
  5. */
  6.  
  7. /* Change Faction and SmartScript for Giants */
  8. UPDATE creature_template SET exp = 2, faction_A = 1771, faction_H = 1771, AIName = 'SmartAI', ScriptName = '' WHERE entry = 26417; -- Runed Giant
  9. UPDATE creature_template SET exp = 2, faction_A = 35, faction_H = 35, speed_run = 0.99206, unit_class = 2, AIName = '', ScriptName = '' WHERE entry = 26783; -- Freed Giant
  10. UPDATE creature_template SET exp = 2, minlevel = 74, maxlevel = 75, faction_A = 1771, faction_H = 1771, mindmg = 249, maxdmg = 304, attackpower = 280, dmg_multiplier = 4, unit_class = 2, AIName = 'SmartAI', ScriptName = '' WHERE entry = 26872; -- Weakened Giant
  11.  
  12. /* Add Spell Condition */
  13. DELETE FROM conditions WHERE SourceEntry = 47604 AND SourceTypeOrReferenceId = 17; -- Gavrocks Runebreaker
  14. INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
  15. (17, 0, 47604, 0, 0, 31, 1, 3, 26417, 0, 0, 173, 0, '', 'Gavrocks Runebreaker - Target must be entry 26417'), -- Runed Giant
  16. (17, 0, 47604, 0, 1, 31, 1, 3, 26872, 0, 0, 173, 0, '', 'Gavrocks Runebreaker - Target must be entry 26872'); -- Weakened Giant
  17.  
  18. /* SmartScript for Runed Giants */
  19. DELETE FROM smart_scripts WHERE entryorguid = 26417; -- Runed Giants
  20. 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
  21. (26417, 0, 0, 0, 8, 0, 100, 0, 47604, 0, 0, 0, 87, 2641700, 2641701, 2641701, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Runed Giant - On spellhit - Call random timed actionlist'); -- Either killcredit or attack
  22.  
  23. /* SmartScript for Runed Giants */
  24. DELETE FROM smart_scripts WHERE entryorguid = 26872; -- Weakened Giants
  25. 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
  26. (26872, 0, 0, 0, 8, 0, 33, 0, 47604, 0, 0, 0, 87, 2641700, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Weakened Giant - On spellhit - Call random timed actionlist'); -- Either killcredit or attack
  27.  
  28. /* Actionlist for Killcredit */
  29. DELETE FROM smart_scripts WHERE entryorguid = 2641700; -- Killcredit Actionlist
  30. 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
  31. (2641700, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 36, 26783, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Freed Giant - Action list - Update template'), -- Change template
  32. (2641700, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 20, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Freed Giant - Action list - Stop attack'), -- Stop attack
  33. (2641700, 9, 3, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 33, 26783, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Freed Giant - Action list - Give quest credit'), -- Killcredit
  34. (2641700, 9, 4, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Freed Giant - Action list - Say lines'), -- Speak
  35. (2641700, 9, 5, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 36, 26417, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Freed Giant - Action list - Reset template'), -- Reset template
  36. (2641700, 9, 6, 0, 0, 0, 100, 0, 0, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Freed Giant - Action list - Despawn'); -- Despawn
  37.  
  38. /* Actionlist for Attack */
  39. DELETE FROM smart_scripts WHERE entryorguid = 2641701; -- Attack Actionlist
  40. 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
  41. (2641701, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 36, 26872, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Weakened Giant - Action list - Update template'), -- Change template
  42. (2641701, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 49, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Weakened Giant - Action list - Attack start'); -- Start attack
  43.  
  44. /* Delete Text from wrong template */
  45. DELETE FROM creature_text WHERE entry = 26417; -- Runed Giant
  46.  
  47. /* Add Text to Freed Giant */
  48. DELETE FROM creature_text WHERE entry = 26783; -- Freed Giant
  49. INSERT INTO creature_text (entry, groupid, id, text, type, language, probability, emote, duration, sound, comment) VALUES
  50. (26783, 0, 0, 'I thought I was doomed. Thank you for freeing me.', 12, 0, 100, 0, 0, 0, 'Freed Giant'),
  51. (26783, 0, 1, 'You have my gratitude.', 12, 0, 100, 0, 0, 0, 'Freed Giant'),
  52. (26783, 0, 2, 'I never thought I\'d be free from that terrible spell!', 12, 0, 100, 0, 0, 0, 'Freed Giant'),
  53. (26783, 0, 3, 'Thank you, small one.', 12, 0, 100, 0, 0, 0, 'Freed Giant');
  54.  
  55. /* Add German Text to Freed Giant */
  56. DELETE FROM locales_creature_text WHERE entry = 26783; -- Freed Giant
  57. INSERT INTO locales_creature_text (entry, groupid, id, text_loc3) VALUES
  58. (26783, 0, 0, 'Ich dachte, ich sei verdammt. Danke, dass Ihr mich befreit habt'),
  59. (26783, 0, 1, 'Ihr habt meine Dankbarkeit'),
  60. (26783, 0, 2, 'Ich dachte, ich würde nie von diesem Zauber befreit werden!'),
  61. (26783, 0, 3, 'Habt Dank, kleines Wesen');
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!