Advertisement
Guest User

Untitled

a guest
May 25th, 2017
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 2.06 KB | None | 0 0
  1. -- Support for quest Burn in Effigy (11656)
  2.  
  3. -- Triggers
  4. DELETE FROM creature WHERE id IN (25511,25513);
  5. INSERT INTO creature VALUES
  6. (11687912,25511,571,1,2,0,0,3026.53,6788.67,0.737596,4.39547,25,5,0,1,0,0,0),
  7. (11687913,25513,571,1,2,0,0,2522.66,6845.47,0.527573,4.81076,25,5,0,1,0,0,0);
  8.  
  9.    
  10. -- Missing TEMP (300173)
  11. DELETE FROM gameobject WHERE id=300173;
  12. INSERT INTO gameobject VALUES
  13. (507487,300173,571,1,2,3026.53,6788.67,0.737596,4.39547,0,0,0.809828,-0.586668,25,0,1),
  14. (507489,300173,571,1,2,2522.67,6845.49,0.526334,0.63401,0,0,0.311722,0.950173,25,0,1),
  15. (507486,300173,571,1,2,3048.65,6752.09,6.49282,4.29351,0,0,0.838671,-0.544639,25,0,1),
  16. (507488,300173,571,1,2,2868.42,6864.51,3.80855,2.02458,0,0,0.848048,0.52992,25,0,1);
  17.  
  18.  
  19. -- Flames (64561)
  20. UPDATE creature_template SET AIName='EventAI', unit_flags=unit_flags|8 WHERE entry IN (25510,25511,25512,25513);   
  21. DELETE FROM creature_ai_scripts WHERE creature_id IN (25510,25511,25512,25513);
  22. INSERT INTO creature_ai_scripts VALUES
  23. (2551001,25510,8,0,100,1,45692,-1,11,64561,0,4,22,1,0,0,1,-241511,0,0,0,0,'1st Kvaldir Vessel Cast Flames and Set Phase 1 (Q:12903)'),
  24. (2551002,25510,1,1,100,1,15000,15000,15000,15000,28,0,64561,0,23,-1,0,0,0,0,0,0,'1st Kvaldir Vessel Unaura Flames and Set Phase 0 (Q:12903)'),
  25. (2551101,25511,8,0,100,1,45692,-1,11,64561,0,4,22,1,0,0,0,0,0,0,0,0,'2nd Kvaldir Vessel Cast Flames and Set Phase 1 (Q:12903)'),
  26. (2551102,25511,1,1,100,1,15000,15000,15000,15000,28,0,64561,0,23,-1,0,0,0,0,0,0,'2nd Kvaldir Vessel Unaura Flames and Set Phase 0 (Q:12903)'),
  27. (2551201,25512,8,0,100,1,45692,-1,11,64561,0,4,22,1,0,0,0,0,0,0,0,0,'3rd Kvaldir Vessel Cast Flames and Set Phase 1 (Q:12903)'),
  28. (2551202,25512,1,1,100,1,15000,15000,15000,15000,28,0,64561,0,23,-1,0,0,0,0,0,0,'3rd Kvaldir Vessel Unaura Flames and Set Phase 0 (Q:12903)'),
  29. (2551301,25513,8,0,100,1,45692,-1,11,64561,0,4,22,1,0,0,0,0,0,0,0,0,'4th Kvaldir Vessel Cast Flames and Set Phase 1 (Q:12903)'),
  30. (2551302,25513,1,1,100,1,15000,15000,15000,15000,28,0,64561,0,23,-1,0,0,0,0,0,0,'4th Kvaldir Vessel Unaura Flames and Set Phase 0 (Q:12903)');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement