1. -- TESTS for new command 39 - RESPAWN
  2. --creature id 11717
  3. UPDATE creature_template SET MovementType = 2 WHERE Entry = 11717;
  4. UPDATE creature SET MovementType = 2 WHERE id = 11717;
  5. DELETE FROM creature_movement_template WHERE entry = 11717;
  6. INSERT INTO creature_movement_template (entry, point, position_x, position_y, position_z, waittime, script_id, orientation, model1, model2) VALUES
  7. (11717, 1, -4396.43,3178.16,58.7254, 0, 0, 2.46263, 0, 0),
  8. (11717, 2, -4396.43,3178.16,58.7254, 10000, 1171701, 2.46263, 0, 0);
  9. DELETE FROM dbscripts_on_creature_movement WHERE id = 1171701;
  10. INSERT INTO dbscripts_on_creature_movement (id, delay, command, datalong, datalong2, buddy_entry, search_radius, data_flags, dataint, dataint2, dataint3, dataint4, x, y, z, o, comments) VALUES
  11. (1171701,2,1,3,0,0,0,0,0,0,0,0,0,0,0,0,''),
  12. -- test for self:
  13. -- test after: despawn
  14. -- (1171701,5,18,0,0,0,0,0x04,0,0,0,0,0,0,0,0,''),
  15. -- test after: death
  16. -- (1171701,5,15,5,0,0,0,0x04,0,0,0,0,0,0,0,0,''),
  17. (1171701,8,39,0,0,0,0,0x04,0,0,0,0,0,0,0,0,''); -- work after both despawn and death
  19. -- test for buddy:
  20. -- test after: buddy despawn
  21. -- (1171701,5,18,0,0,7879,20,1,0,0,0,0,0,0,0,0,''),
  22. -- test after: buddy death
  23. -- (1171701,5,15,5,0,7879,20,1,0,0,0,0,0,0,0,0,''),
  24. -- (1171701,8,39,0,0,7879,20,1,0,0,0,0,0,0,0,0,''); -- doesnt work after both despawn and death(shouldnt?)
  27. -- TESTS for new command 40 - FLY
  28. DELETE FROM dbscripts_on_creature_movement WHERE id IN (2840602,2840603);
  29. INSERT INTO dbscripts_on_creature_movement (id, delay, command, datalong, datalong2, buddy_entry, search_radius, data_flags, dataint, dataint2, dataint3, dataint4, x, y, z, o, comments) VALUES
  30. (2840602,1,24,26308,0,0,0,0x08,0,0,0,0,0,0,0,0,'mount'),
  31. -- echo.TEST ON -- levitate
  32. -- (2840602,2,40,1,0,0,0,0,0,0,0,0,0,0,0,0,'levitate ON'), -- doesnt work
  33. -- (2840603,2,40,0,0,0,0,0,0,0,0,0,0,0,0,0,'levitate OFF'), -- doesnt work
  34. -- echo.TEST OFF
  36. -- echo.TEST ON -- fly
  37. (2840602,2,40,1,0,0,0,0x08,0,0,0,0,0,0,0,0,'fly ON'), -- doesnt work
  38. (2840603,2,40,0,0,0,0,0x08,0,0,0,0,0,0,0,0,'fly OFF'), -- doesnt work
  39. -- echo.TEST OFF
  40. (2840603,3,24,0,0,0,0,0x08,0,0,0,0,0,0,0,0,'unmount');
  43. -- TESTS for new command 41 - DESPAWN OBJECT
  44. DELETE FROM dbscripts_on_creature_movement WHERE id = 2140904;
  45. INSERT INTO dbscripts_on_creature_movement (id, delay, command, datalong, datalong2, buddy_entry, search_radius, data_flags, dataint, dataint2, dataint3, dataint4, x, y, z, o, comments) VALUES
  46. (2140904,1,28,8,0,0,0,0,0,0,0,0,0,0,0,0,'STATE_KNEEL'),
  47. (2140904,6,0,2,0,0,0,0,2000005488,0,0,0,0,0,0,0,''),
  48. (2140904,7,25,0,0,0,0,0,0,0,0,0,0,0,0,0,'RUN OFF'),
  49. -- echo.TEST ON
  50. (2140904,7,41,0,0,184798,50,7,0,0,0,0,0,0,0,0,'despawn object'), -- works
  51. -- echo.TEST OFF
  52. (2140904,8,28,0,0,0,0,0,0,0,0,0,0,0,0,0,'STATE_STAND');
  56. -- COMMENTS:
  57. -- 39 SCRIPT_COMMAND_RESPAWN_SELF
  58. -- Looks like respawn system doesnt recognize buddy system.
  59. -- reciving errors like:
  60. -- DB-SCRIPTS: Process table `dbscripts_on_creature_movement` id 1171701, command 39 has buddy 7879 not found in range 20 of searcher Creature (Entry: 11717 Guid: 51236) (data-flags 1), skipping.
  62. -- 40 SCRIPT_COMMAND_SET_FLY
  63. -- Doesnt work at all.. (it worked with prev. patch you gave me... smth was added into command 25 - RUN..+ 0x08 additional... gravity on off?)
  65. -- 41 SCRIPT_COMMAND_DESPAWN_GO
  66. -- Works fine