Advertisement
Guest User

Untitled

a guest
Jun 23rd, 2017
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 2.15 KB | None | 0 0
  1. DELETE FROM creature WHERE id=24209;
  2. INSERT INTO creature (id, map, spawnMask, phaseMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, DeathState, MovementType)VALUES
  3. ('24209', '571', '1', '1', '0', '542', '2127.63', '-3292.62', '152.45', '3.14', '300', '0', '0', '9291', '3231', '0', '0');
  4.  
  5.  
  6. UPDATE creature_template AIName='EventAI' WHERE entry=24210;
  7.  
  8. DELETE FROM creature_ai_scripts WHERE creature_id= 24210;
  9.  
  10. INSERT INTO creature_ai_scripts(id, creature_id, event_type, event_inverse_phase_mask, event_chance, event_flags, event_param1, event_param2, event_param3, event_param4, action1_type, action1_param1, action1_param2, action1_param3, action2_type, action2_param1, action2_param2, action2_param3, action3_type, action3_param1, action3_param2, action3_param3, COMMENT)VALUES
  11. ('2421001', '24210', '11', '0', '100', '0', '0', '0', '0', '0', '21', '0', '0', '0', '18', '2097152', '0', '0', '23', '1', '0', '0', 'Riven Widow Cocon-Prevent Combat Movement and Set Unit Flags and Set Phase 2 on Spawn'),
  12. ('2421002', '24210', '6', '1', '10', '0', '0', '0', '0', '0', '12', '23990', '0', '60000', '0', '0', '0', '0', '0', '0', '0', '0', 'Riven Widow Cocoon-Summon Gjalerbron Rune-Caster'),
  13. ('2421003', '24210', '6', '1', '10', '0', '0', '0', '0', '0', '12', '23989', '0', '60000', '0', '0', '0', '0', '0', '0', '0', '0', 'Riven Widow Cocoon-Summon Gjalerbron Sleep-Watcher'),
  14. ('2421004', '24210', '6', '1', '10', '0', '0', '0', '0', '0', '12', '23991', '0', '60000', '0', '0', '0', '0', '0', '0', '0', '0', 'Riven Widow Cocoon-Summon Gjalerbron Warrior'),
  15. ('2421005', '24210', '6', '1', '70', '0', '0', '0', '0', '0', '12', '24211', '0', '60000', '33', '24211', '6', '0', '0', '0', '0', '0', 'Riven Widow Cocoon-Summon Freed Winterhoof Longrunner'),
  16. ('2421006', '24210', '6', '1', '20', '0', '0', '0', '0', '0', '41', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Riven Widow Cocoon-Chance To Despawn on Death'),
  17. ('2421007', '24210', '7', '0', '100', '0', '0', '0', '0', '0', '22', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Riven Widow Cocoon-Set Phase to 0 on Evade');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement